Provides a way of reading a forward-only stream of rows from a SQL Server database.
I've got an ASP.NET page that has a bunch of controls that need to be populated (e.g. dropdown …
asp.net performance dataset sqldatareaderi just wondering, what things i have to consider when using DataReader and DataAdapter in fetching data from the database …
c# ado.net sqldatareaderA fairly large web application written in C# keeps throwing up 2 errors: 'ExecuteReader requires an open and available Connection. The …
c# tsql exception sqldatareaderI have an SQL query I get from a configuration file, this query usually contains 3-6 joins. I need to …
c# .net sql-server sqldatareaderI have coded three select statements in stored procedure in Microsoft SQL Server 2005. Both select statements return multiple number of …
stored-procedures sqldatareader multiple-selectWe already have a running system that handles all connection-strings (db2, oracle, MSServer). Currently, We are using ExecuteNonQuery() to do …
c# sql-server bulkinsert sqldatareader sqlbulkcopyI wanted to use nested SqlDataReader in the code below but I couldn't make it.I get "System.InvalidOperationException: There …
c# asp.net sqldatareaderstring query = "select * from cfo_daily_trans_hist"; try { using (SqlConnection connection = new SqlConnection( cnnString)) { SqlCommand command = new SqlCommand(query); …
c# .net sql-server-2008 datatable sqldatareaderIs it not possible to get the return value of a stored procedeure when using a datareader? The return value …
asp.net .net sql sqldatareaderI have a one to many relationship coming from a stored procedure. I have several one to many relationships in …
c# ado.net sqldatareader