When I execute this VBscript I get the following error. Does anyone have an idea how to resolve this issue? The xml it tries to parser is down below labled xml file. Thanks. '*********************************** xml parser CODE******************************* Set xmlDoc = Server.CreateObject("MSXML2.DOMDocument") xmlDoc.async = False xmlDoc.setProperty "ServerHTTPRequest", true xmlDoc.loadXML(objHttp.responseText) xmlDoc.loadXML(sOutPut) Response.write sOutPut.documentElement.selectSingleNode("ebrary_username") ************************************ XML FILE bry_teets7etrfr1ss8s ************************************ ERROR MESSAGE -------------------------------------------------------------------------------- Invalid at the top level of the document. Error processing resource ... Parsing Error......

Thanks for the info.

What's the difference between Session_Start and Application_Start inside the global.asx.cs file?

Is it possible to use a dataview to return multiple rows using two keys for the column? The result set must be based on two condition in the sort function for example, dataview.Sort = "Col1, Col2". Now, how do I use the FindRows function to use 2 keys or do I use a different function? Should I forget the idea of using a dataview and stick with a datatable? Thanks a lot!

How do I remove a hyphen from a text? I'm retrieving the value from a textbox. The value, for example is 567-343, how do I get rid of the hyphen? The trim("-") function doesn't work on this value. Thanks!

Thanks for your suggestion. I tried your recommendation, but I was getting the same results. I decided to set the date range higher in the sql query and placing the larger results into the dataset. It takes longer to load, but the overall results are much better. Thanks again for your suggestion.

Thanks for your reply. I'll using OleDb is because I'm connecting to a dataflex table and not SQL Server. I did find a solution to the problem. Thanks again.

Thanks for your suggestion. I decided to retrieve the entire results from the query and fill the dataset, so I don't experience the problem. Thanks again for the recommendation of sql injection I'll look into to it, but this is a windows application I thought sql was only for web application?

I have a VB.Net windows app that retrieves data from 3 different tables. The SQL command uses a 3 table join. The results from the query is filled into a datatable and later populated into a combobox. The SQL uses the values from a date field inside a text field, for example, 01-15-2005. So, each time I submit the subroutine it executes the SQL command and VB.Net code to retrieve the required data. The date field changes according to the user’s needs. There’s no consistency when the error pops up. The error message I’m getting when it executes, da.Fill(dataTable), “There’s no row at position 0”,. The information I’m on the stack track is as follow: Calling SQLDisconnect --- OleDB UnInitialize not called!!! Connection Object destroyed If I copy the sql into a sql query tool it does retrieve the required data according to the date field. Here’s a sample of the subroutine: cmdQueryINVOICE = _ "SELECT PAYITEM.TRANSACT_NUMBER, " _ & "PAYITEM.ACCOUNT_NUMBER, " _ & "PAYITEM.PAY_DATE, " _ & "LSEINVH.INVOICE_NUMBER " _ & "FROM LSEINVH, PAYITEM, TRANSHDR " _ & "WHERE " _ & " LSEINVH.INVOICE_NUMBER > '" & 75000 _ & "' AND LSEINVH.STATUS <> '" & sStatus _ & "' AND LSEINVH.INVOICE_NUMBER = TRANSHDR.INVOICE_NUMBER " _ & " AND PAYITEM.PAY_DATE > '" & InvoiceDates.StartDate _ & "' AND PAYITEM.PAY_DATE < '" & InvoiceDates.EndDate _ & "' AND PAYITEM.COMPANY = '" & sCompany _ & "' AND PAYITEM.TRANSACT_NUMBER = TRANSHDR.TRANS_NUMBER order by PAYITEM.PAY_DATE desc " Dim sqlQuery As OleDbCommand = connDf.CreateCommand Dim dtInvDate As New DataTable() Dim iInvCnt, x As Integer Dim sUnitQuery As String Dim daInv As New OleDbDataAdapter() Try daInv = New OleDbDataAdapter(cmdQueryINVOICE, connDf) daInv.Fill(dtInvDate) Dim LoopRow As Data.DataRow Dim test As String = dtInvDate.Rows.Item(0).ToString For Each LoopRow In dtInvDate.Rows cboInvoice.Items.Add(LoopRow.Item("INVOICE_NUMBER").ToString + " " + LoopRow.Item("PAY_DATE")) Next Catch e As Exception Dim errMsg As String = e.Message Finally connDf.Close() End Try Thanks, any help would be grateful.

I have a VB.Net windows app that retrieves data from 3 different tables. The SQL command uses a 3 table join. The results from the query is filled into a datatable and later populated into a combobox. The SQL uses the values from a date field inside a text field, for example, 01-15-2005. So, each time I submit the subroutine it executes the SQL command and VB.Net code to retrieve the required data. The date field changes according to the user’s needs. There’s no consistency when the error pops up. The error message I’m getting when it executes, da.Fill(dataTable), “There’s no row at position 0”,. The information I’m on the stack track is as follow: Calling SQLDisconnect --- OleDB UnInitialize not called!!! Connection Object destroyed If I copy the sql into a sql query tool it does retrieve the required data according to the date field. Here’s a sample of the subroutine: cmdQueryINVOICE = _ "SELECT PAYITEM.TRANSACT_NUMBER, " _ & "PAYITEM.ACCOUNT_NUMBER, " _ & "PAYITEM.PAY_DATE, " _ & "LSEINVH.INVOICE_NUMBER " _ & "FROM LSEINVH, PAYITEM, TRANSHDR " _ & "WHERE " _ & " LSEINVH.INVOICE_NUMBER > '" & 75000 _ & "' AND LSEINVH.STATUS <> '" & sStatus _ & "' AND LSEINVH.INVOICE_NUMBER = TRANSHDR.INVOICE_NUMBER " _ & " AND PAYITEM.PAY_DATE > '" & InvoiceDates.StartDate _ & "' AND PAYITEM.PAY_DATE < '" & InvoiceDates.EndDate _ & "' AND PAYITEM.COMPANY = '" & sCompany _ & "' AND PAYITEM.TRANSACT_NUMBER = TRANSHDR.TRANS_NUMBER order by PAYITEM.PAY_DATE desc " Dim sqlQuery As OleDbCommand = connDf.CreateCommand Dim dtInvDate As New DataTable() Dim iInvCnt, x As Integer Dim sUnitQuery As String Dim daInv As New OleDbDataAdapter() Try daInv = New OleDbDataAdapter(cmdQueryINVOICE, connDf) daInv.Fill(dtInvDate) Dim LoopRow As Data.DataRow Dim test As String = dtInvDate.Rows.Item(0).ToString For Each LoopRow In dtInvDate.Rows cboInvoice.Items.Add(LoopRow.Item("INVOICE_NUMBER").ToString + " " + LoopRow.Item("PAY_DATE")) Next Catch e As Exception Dim errMsg As String = e.Message Finally connDf.Close() End Try Thanks, for any help!

I'm having a problem with a datagrid in asp.net. The datagrid loads okay, but during a postback it loses its data, for example when a button is clicked. I'm rebinding the datagrid in the page_load section, for ex: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If (Page.IsPostBack) Then dgridAnswers.DataSource = Session("svRsltTable") dgridAnswers.DataBind() End If The first time I bind the grid is in a function, for ex: Session("svRsltTable") = dSetAnsCmntQt.Tables("RsltTable") dgridAnswers.DataSource = Session("svRsltTable") dgridAnswers.DataBind() I load the session variable in this function so I can use it in the Page_load section to rebind it later. The columns is set to autoGenerateColumns =False. Thanks for any help.

I have a web site that works in developed but having a hell of a time making it work in production environment. The homepage works fine, but the GO button doesn't work and the error massage given state that no error is given. 1. I have created a virtual directory in IIS. 2. Placed all the aspx, DLLs, GIFs, JS, webconfig files in the virtual directory. 3. Set the permission rights. 4. MDAC ver 7 5 .Net framework ver 1.1 Do I need to copy the files from the _vti_cnf folder on the development side to production? What am I forgetting? Thanks!

Hello, Does anyone know how to format a particular column in Excel to an accounting style? Here's my situation, I created a Excel accounting report in a VB.Net application, but I'm not sure how to format certain columns to the different styles for example, accounting or currency. How is this done in the VB code? Thanks!

Thanks for you input!

Hello, I created a website using VB.Net that needs the userId value from the textbox from an existing ASP website. The old ASP website didn't declare the userId varible as a session varible. How do I use request command to read the userID into my webform? Any help would be helpful. Thanks!

javier, Thanks a million!! Can I ask you for one more favor? I didn't get your sample code. If possible may I see the web.config sample you suggested. lxhan

I have a website that is created in asp.net that needs read access to certain files on the network. Since the aspnet username doesn't have access rights it can't read the file on the network. What's the proper method or steps to setup the machine.config if I want to grant access to the network files. Of course, I want to prevent hackers from looking into the machine.config file, and looking at the username and password. Do I have to change the username or password in the machine.config file? Do I have to change anything on IIS ver 5.01? How is the user account, ASPNET created on the network? Thanks!

I'm experiencing a problem w/ my application written in VB.Net. My application is suppose to open Excel, but when I try to create an object using CreateObject function it throws an exception, Specified cast is not valid. If I declare the xlApp as Excel.ApplicationClass it works, but a get the same problem, Specified cast is not valid, on the next line, xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook). I'm using Excel 2000 ver 9.02 and the OS is XP professional. I decided to load the latest version InteropServices, but I'm not using Office 2002. Even though it's loaded into the system the properties for the Excel COM object is pointing to the old version of Excel 2000. Any help would be appreciated. A sample of the code is as follows: Imports System.Runtime.InteropServices Imports Excel Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet xlApp = CType(CreateObject("Excel.Application"), Excel.Application) xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)

Hello, Does anyone know how to email a webform with the related data to another person? I have an ASP.Net application that collects data from the user and emails it to another person. I'm collecting the data in SQL Server 2000 when the user clicks the submit button. My emailing feature works with simple text messages, but I have no clue, how to send, email the webform with the data the user entered. Any help, would be appreciated. Lex

I'm trying to read a CDD file using a ODBC driver. When I try to Open the file it bombs-out. The error messeage I get is as follows: System.Data.OleDb.OleDbException: Connection Failure Unable to find CDD. File not found. (L:\CONNX_LICENSE\CDDFiles\schwanMgntWeb.cdd) Win32 Error(3) UserName=(*****) Here's the strange part, it works on a windows application, but fails to open the file in a web base application. The logic is exactly the same. Yes, I did register the DSN, and it's pointing to the proper location. Here's the snippet of code: Dim connDF As New OleDbConnection() connDF.ConnectionString() = (GetConnectionString("SchwanMgntWeb")) connDF.Open() 'bombs out here The connection string is: m_sConn = "Provider=CONNXOLEDB;DSN=SchwanMgmtWeb;UID=admin;PWD=;NODE=;APPLICATION=;"