sqldatareader_开发者

Same object to read and to contain results

The IDataReader interface inherits from IDataRecord. The Read() method changes the state of the reader so that you can retrieve the fields:[详细]

2023-04-12 23:32 分类：问答

Executereader and execute non-query in a single connection in ado.net

The below snippet employs multiple queries inside the same connection string. first i\'m selecting the some datas from the DB then before closing the datareader(dr) i would like to do some validations[详细]

2023-04-12 15:29 分类：问答

System.IndexOutOfRangeException on SQLDataReader Value Using C#

I have a SQLDataReader that returns three integers. However, there are occasions when two of the integers will return null values.[详细]

2023-04-12 11:49 分类：问答

how can i know when i reach end of a datareader?

cmd.CommandText = \"select name from Tbl_Shahr_No\"; SqlDataReader reader = null; reader = cmd.ExecuteReader();[详细]

2023-04-09 23:50 分类：问答

VWD Express 2010 CommandType

I just converted a website from Foxpro to asp.Net with VB.I\'m now trying to convert to C# and maybe try a few new techniques.I\'ve not used parameters with datareader before - I found some code that[详细]

2023-04-07 19:59 分类：问答

SqlDataAdapter.Fill() - Conversion overflow

All, I am encountering \"Conversion overflow\" exceptions on one of the SqlDataAdapter.Fill() usages for a decimal field. The error occurs for value beginning 10 billion, but not till 1 billion. Here[详细]

2023-04-07 17:43 分类：问答

SqlDataReader showing me InvalidCastException(C# Windows Form)

SqlConnection sqlConn = new SqlConnection开发者_如何学Python(ConfigurationManager.ConnectionStrings[\"myDB\"].ConnectionString);[详细]

2023-04-05 13:23 分类：问答

Datareader Retrieving Data

I have Memberships and Bookings tables in a database containing an attribute cust_id, which is the primary key in Memberships and reference key in Bookings. When I am executing a data reader I want it[详细]

2023-04-03 12:39 分类：问答

Does SqlCommand.ExecuteReader ever automatically open the db connection?

I am noticing some odd behavior on my web page. I have a WCF Data service that serves up JSON to fill up a jqGrid. The service is called using javascript/ajax.[详细]

2023-04-02 08:32 分类：问答

determine if a field is returned from a datareader

I\'m dynamically picking a table to select from and there\'s one fiel开发者_开发问答d that doesn\'t exist on all of the tables.Inside my reader, how can I check to see if that field exists in the coll[详细]

2023-04-01 17:42 分类：问答