datareader
What to use for a datagrid with a lot of data?
Found this interesting interview question: You need to display the sales data for your division for the past 5 years in a DataGrid on a Web Form. Performance is very important. What would be the best[详细]
2023-01-21 13:53 分类:问答DataAdapter returns a empty rowset, but DataReader returns data
I execute a query that calls a SP, that SP returns data... but when I call it with a DataAdapter I get no result data, if use a DataReader instead... then I get data. The database is SQL Server and th[详细]
2023-01-20 12:22 分类:问答ADO.NET Performance : Which Approach will faster and resonable? [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this[详细]
2023-01-20 09:01 分类:问答How to handle multiple ResultSets, each with multiple Rows? IDataReader.NextResult() ending Read()
How to handle multiple ResultSets, each with multiple Rows? The call to NextResult() breaks the while loop.[详细]
2023-01-18 15:01 分类:问答Error in DataReader is not closed
Can anyone help me on how this error came up There is already an open DataReader associated with this Connection which must be closed first.[详细]
2023-01-18 08:02 分类:问答Measure stored procedure duration
In my application I want to know the execution time for a stored procedure. My pattern is to execute reader and get the data reader and read the results. The reader ret开发者_开发技巧urn immediately[详细]
2023-01-16 10:16 分类:问答Pipe SQL to a file
Any idea how to pipe the results of ... DECLARE @session_name VARCHAR(200) = \'test_trace\' SELECT pivoted_data.*[详细]
2023-01-14 02:18 分类:问答how to use the datareader across multiple functions in a single .net web page
Is it better to declare the datareader as public or declare as local to each and every function in which we 开发者_如何学运维use the datareader in a .net page?[详细]
2023-01-13 17:45 分类:问答DataReader with parametrs;
I am currently struggling with MySQL database with DataSet. The thing is开发者_如何学C that it uses loads of memory(as I found somewhere over the net it uses almost 4x memory rather than when you are[详细]
2023-01-08 01:53 分类:问答data reader in vb.net
Please help, how do I make a while loopequivalent of this for loop. So that I could read from one row in the table of mysql database and displayit on the combobox in vb.net.[详细]
2023-01-07 19:19 分类:问答