sqldatareader
MySQL Connector/NET connection multiple DataReaders per Connection?
I am migrating from Java to C# now that I\'ve realized I prefer the C# language features over the ones in Java, but I have this small issue. In MySQL Connector/J and JDBC, I believe that one of my app[详细]
2023-01-16 04:07 分类:问答sd display the details of selected item in the dropdown list from database
This is the code i have written to display the details of employee selected from the drop down list into textboxes. I didn\'t get any error but the details are not getting displayed in 开发者_JAVA技巧[详细]
2023-01-13 14:49 分类:问答LINQ to SQL - There is already an open data reader associated with this command whic must be closed first
Recently i implemented Linq to SQL in a static class in my ASP.Net project which is a utility class to get some information on site load. when i used the static linqtosql datacontext i got the above e[详细]
2023-01-12 01:23 分类:问答SQLCommand.ExecuteReader() does not restrict to read only statements
So apparently, ExecuteReader is used for read only and ExecuteNonQuery is used for transactions. But for some reason even when I used ExecuteReader I am still able to run write (Insert, Update, Delete[详细]
2023-01-09 16:00 分类:问答How to fill multiple types of Business Objects from a single method?
I have four different Business objects and each calls its corresponding FillBusinessObject method to fill all the individual object properties one by one. Now I wish to create a common method which sh[详细]
2023-01-08 16:46 分类:问答SQL Reading from a DB problem using a DataReader
I have a table of Users (tblUsers) which contains details of University staff. I am trying to populate a text box with the names of lecturers associated with a selected module.[详细]
2023-01-07 22:02 分类:问答SqlHelper.ExecuteReader results varying and unexpected when certain number of records are returned
Note: You may not need to read the whole thing to know what\'s wrong... skip down to the part about the 3 scenarios if you\'d like. Only read the begin if you\'d like some background info on how I\'ve[详细]
2023-01-05 10:37 分类:问答How to get table name of a column from SqlDataReader
I have an SQL query I get from a configuration file, this query usually contains 3-6 joins. I need to find at run time, based on the result set represented by SqlDataReader, to find the name of the t[详细]
2023-01-04 23:39 分类:问答ReSharper show warning with SqlDataReader
When I write something like this: using (var connection = new SqlConnection(\"ConnectionString\")) { using(var cmd= new SqlCommand(\"Command\"))[详细]
2023-01-03 03:57 分类:问答SqlDataReader GetBoolean from Calculated Resultset Field
I\'ve got a field in my SQL SPROC resultset that is a calculated CASE statement that returns 1 or 0 (ie True/False).[详细]
2023-01-02 06:08 分类:问答