I have the something like the following data structure: Users users_ID, orgs_ID, users_email, users_password, etc. Orgs orgs_ID, orgs_name, orgs_description, etc. I have a single form with two datagrids. I have loaded one dataset with two tables. There is only a single record at an...more >>

In my ADO.Net coding I am using SQLCommand and SQLParameter to run stored procedure. Can any one advice me how to read the output parameter from a stored procedure. I am using SQL Server 2000. Gish Smith ...more >>

I am a newbie in .NET, I am trying to implement Database access components which need to handle transaction management and concurrency control. I have been seeing that the COM+ provides functionalities on transaction management, but is the difference between the COM+ transactions and the transa...more >>

how can export datatable to excel i try to use new excel application then fill data to excel but it very slow how can i to do export datatable to excel fast thanks ...more >>

I have the following problem: I have a dataset with one table. I bind the fields of the table to several entities like textboxes etc. Now I change the values of a row of the table through the textboxes. The value in the table of my dataset has changed (I checked it) but my dataset still h...more >>

Hi I'd like to know if it's possible, with an OleDbProvider, to fill a dataset from a sql squery against a XML schema. For exemple, i have this OleDbCommand : SELECT computer.name, processor.frequency, soundCard.model FROM computer INNER JOIN processor ON computer.processor_id = proces...more >>

(note - sorry for the crosspost - I sent to .vb thinking i was sending to ..adonet). I implemented a very small, basic data access layer for my web application. It works just fine, except for this one bug. One of my methods returns an abstracted dataset. To accomodate X number of input para...more >>

Do I need to fill all the 3 commands ( InsertCommand, DeleteCommand and UpdateCommand), even though I'm using only one of them ? Like if I wants to update records in db, I'm sure that I have to assign the UpdateCommand, in this scenario, do I need to assign the Insert and Delete statements also ...more >>

I have an SQL string that im trying to use to connect to an Access DB im currently using the following string: SQLStr = "SELECT LEFT(LTRIM(RTRIM(Personal.postcode)),LEN(personal.postcode)-1) AS Expr1, LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal INNER JOIN Pen...more >>

I have an app that I have recently been testing to try an determine the cause of this Timeout Expired issue. I am using the performance monitor to check the # of connection pools as well as the # number of pooled connections. When I start the app and the user logs in a pool & connection is creat...more >>

Hi. Just reading about the sqldatareader object I am confused about the recordsaffected property. The example on the help docs use a procedure with some inserts and a select. Can I use a datareader object to run sql commands that does not return records? What is the advantage of using a da...more >>

Does anybody know why when connecting to an Oracle database from a ASP.NET web app running under Windows XP, the connection is very slow. It takes about 2 minutes to open the database connection. The same code running on a NT2000 machine executes in under 4 seconds. To test this, is very simpl...more >>

I am new to .Net but have been unable to find anything about this in the newsgroups. Using C# and the following SQL stored procedure in my SqlDataAdapter: CREATE PROCEDURE HouseholdNextPrevious @PassedName varchar(150), @Direction varchar(4) AS Set NoCount on if @Direction = 'down' /* ne...more >>

I need to handle dynamic changes to a table's schema, even when there is already data present. It appears that the only thing supported by DataTable is to remove a column so I am pulling all the data out into a 2D array, performing my manipulations on the raw data, and then clearing out the tab...more >>

Hello ! Can someone please explain to me what the difference between "output" and "returnValue" as direction for sqlParameter in a stored Procedure ? Thanks, Lanz...more >>

How can I find the DataRow position into the DataRowCollection when I have got the DataRow object after a call to DataTable.Find or Select (C#) Thanks...more >>

Is there any way to modify the following code so I can run it with any number of paramNames as well as any number of paramValues? So far it works with an array of paramValues, but since you can only pass a variable number of parameters in the last parameter of a method, I'm stumped. Perh...more >>