sqldatareader
SqlDataReader problems
开发者_开发百科I have a problem when storing data into a SqlDataReader. When i assing the sdr variable, at the point where connection.close(), the sdr variable becomes empty. Why?[详细]
2023-02-11 05:02 分类:问答How do I check a datareader for null?
I have an aspx page which allows a user to submit modified entries into the database, but when the user clicks Submit to fire the stored procedure I want to first run a check to see if a modified row[详细]
2023-02-10 07:40 分类:问答stored procedure returns multiple resultsets but number of resultsets are not fixed
I have a stored procedure which returns variable number of mul开发者_StackOverflow中文版tiple resultsets. DataReader.NextResult() gives error if no next resultset exists . How to find whether next res[详细]
2023-02-10 06:32 分类:问答Cannot convert method group 'Read' to non-delegate type 'bool'
I am trying to use SqlDataReader to check if a entry exists. If it exists, it will return the ID, else it will return false. When I try to compile, I\'m getting the error \"Cannot convert method group[详细]
2023-02-08 15:39 分类:问答SqlDataReader.GetGuid with column name c#?
Is there a way to get a column by name and retain the SQL type information returned by SqlDataReader?[详细]
2023-02-07 16:29 分类:问答Get an error message from TSQL output clause with SqlDataReader
I have the following SQL INSERT INTO [dbo].[table1] ([val1], [val2]) OUTPUT INSERTED.* VALUES (@val1, @val2)[详细]
2023-02-06 06:48 分类:问答SqlDataReader is drops columns randomly!
I have a very strange issue, I\'m using System.Data.SqlClient. to get data from a SQL Server though a stored procedure.[详细]
2023-02-05 09:59 分类:问答Data Reader trimming the leading zeros
I have a string coming from a stored procedure looks like \'001234567\'. sqlCommand = new SqlCommand(\"csp_Bbp_OBN_GetBasePageList\", BBConnection);[详细]
2023-02-04 18:48 分类:问答Powershell 2.0 - SqlDataReader closing when passed into a function
I am interacting with a set of custom .Net 2.0 assemblies, with Powershell 2.0, to automate a current task. I load all the required dlls and call a DAL method, in the dll, to retrieve a System.Data.Sq[详细]
2023-02-04 16:06 分类:问答Using application roles with DataReader
I have an application that should use an application role from the database. I\'m trying to make this work with queries that are actually run using Subsonic (2).[详细]
2023-02-04 07:09 分类:问答