I just want to get the value of field UserName and Password in SqlDataReader object dr. But it yeields run-time error "Invalid attempt to read when no data is present" on line dr("UserName") and dr("Password") any ideas?? Dim sql As String = "select * from [Admin] where UserName = '" & Text...more >>

I've created a dataset from a query that returns a column from an amalgamation of fields in the database. e.g. SELECT [FirstName] & ' ' & [LastName] AS [FullName] FROM [tblPeople] However, when I try to modify the value of this column ([FullName], in the example), I get an error saying it's ...more >>

I have many pages in my ASP.NET (VB) which use the SQL command to call Stored Procedures. They create the parameters and set their value using the following syntax cmd.parameters.add("@ParameterName", value) One page though crashes because the parameters have not been set up, their va...more >>

Does the dataview.sort property work with any column in the table or just the primary key columns? When I try to set the sort property to a column that is not a primary key, it is ignored. Do I need to create an index or something first on the columns I want to sort (I am setting the sort pro...more >>

Does a clear command (ie: DataSet11.TableName.Clear() ) clear just the named table or all the tables in the set? It appears to be all? How can I clear, in order to fill, a specific table in a dataset of many tables? Thanks ...more >>

I have a DataView but now I need a DataTable to pass into several routines I've created. Can I make a DataTable from a DataView? The DataView is now sorted and cleaned up and I don't want to reference the original table the DataView came from. Axe ...more >>

How can I crate a subset table or view from a table? I only want certain columns and all the rows? I do NOT want to loop through the rows and add those to my new table or view. I just want to specify a couple of columns and retrieve a subset table or view. Someone has an idea? Thanks, ...more >>

Could anyone help me with the following problem! I open an SqlConnection. Then: 1. execute a reader on SqlCommand and get data through that reader; 2. in a certain time I call Cancel() method on SqlCommand and SqlDataReader.Close(). If I perform steps 1 and 2 several times (sometimes it ha...more >>

Hi, I am using Access as a backend to my project. From my front end I am issuing the queries, however I am finding it is too much slow. I wanted to execute multiple sql statement. My question here is how to execute these multiple statement?. Is it possible in acess 2000. can I have your sugge...more >>

I am getting the following SQL exception: Error: ReadSessionData: Error 1 - Type: System.Data.SqlClient.SqlException Source: .Net SqlClient Data Provider Target Site: System.Data.SqlClient.SqlInternalConnection GetConnection(Boolean ByRef) Description: General network error. Check your ne...more >>

I have downloaded the latest edition of MSDE and am trying to install it on my machine to work with Visual Studio .NET 2003. I ran the install program exactly as Microsoft specified, using the command: setup.exe /qb INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD="mypass" The ins...more >>

Finally run out of ideas on this one.... Just to get it outta the way, the environment: 2 NLB Web servers (each Win2003, IIS6, 2G memory, 2 physical/4 logical CPU, 2 NICs, Unicast) 1 DB Server (Win2K, SQL2K, 2G memory, 2 physical/logical.. no hyperthreading) I'm periodically getting a "Tim...more >>

Hi, I like to know if there is any way we can use SQL Query syntax for getting values out of ADS. If there is any method pls let me know with example. Thanks Regards ARvind Rangan ...more >>

Hi, My app receives data via an async socket. I need to put this data into a DataSet and display it via a DataGrid. If I add the data to the dataset when it arrives using the async created thread, my app crashes with a NullException inside Application.Run(). If I disconnect the DataSet fr...more >>

Hello All: I am attempting to execute two statements as part of a single transaction using the Microsoft data access application block. The code, which is similar to what follows, returns this message when it attempts to execute the second "SqlHelper.ExecuteReader" statement: "The SqlCommand...more >>

I'm quaking at the thought of doing this (it's against my will!), but are there any significant "gotchas" porting a data layer from the SqlClient to the OleDb classes for use with Access? I've got straight-forward SQL for all of the commandtext, generally with parameters for every query. Does Ac...more >>

Hi, Right now in my app I am using databinding for some of my combo boxes. I only uses databinding to display the data to the user. Here is my question. Since, databinding keeps the dataset in memory is it better just to loop through the dataset table and add each item? Or should I create a...more >>

I want to write a funciton that has 2 parameters(string tableName and IDbDataParameter[] params). I can't seem to figure out how to create a new record using a combination of a Dataset/DataTable/DataRow. Or is there a better way to insert rows? ...more >>

Hello all. I have a set up question. Here it is: I wrote ASP.NET application that uses ADO.NET (everything is managed code). Now I am going to deploy this app to my web server. I installed .NET Framework 1.1 Question: Do I need to install MDAC2.7 on my web server for ADO.NET to work? Thanks. ...more >>

Hi I have used SQLDataReader for fetching data(due to performance issue) and now I want to bind this data to DataGrid, How should I do this? Sample code is most welcomed :) Makarand ...more >>

Hi, Does a usercontrol placed on a form automatically inherit or acquire the parent forms' BindingContext? Thanks, Dave ...more >>

Hi I am getting the 'Operator is not valid for type 'DBNull' and string "".' error on the following line; If (mydatatable.Rows.Item(I).Item("Forenames") Is System.DBNull.Value) Then ' 'I' is the loop variable from 0 To mydatatable.Rows.Count - 1. Any ideas on what is the reason for this ...more >>

Hi, I've got a column in a table which contains images (bmp and jpg, i guess sql server don't convent the jpg to bmp??). How can I extract these images from the table. I've tried something with a MemoryStream, but I don't know how to save it to a file because this stream is a byte arr...more >>