Provides a way of reading a forward-only stream of rows from a SQL Server database.

learn more… | top users | synonyms

2
votes
0answers
23 views

SqlCommand Update in SqlDataReader Read Block

I want to get one row record with SqlCommand. After data reader reading, I want to update LastLoginDate. But it fails. How can I update records in drf.Read() block. SqlCommand kf = ...
1
vote
0answers
84 views

Properly Loading DataGridView From DataReader

Reading this documentation I was unde the impression that the following code would work: using (SqlConnection con = new SqlConnection(Properties.Settings.Default.C_Str)) { try ...
1
vote
0answers
214 views

SQL Datareader is not holding the values

I have been working with a project for last 4 months. We are using a custom framework for the development. The problem I am talking about, was working for all other classes. But for the first time I ...
0
votes
0answers
13 views

Map SqlDataReader using reflection

Hi I'm new in Stackoverflow. What I need is to populate the child list for class passed as parameter. Anybody can help me? Actually the lists always are "null" at the return debtor. I need to map the ...
0
votes
0answers
35 views

advanced select query sql, using c# reader

i have a complicated query question which my skills on sql cant solve, thought i would see if the pro's have some advice. I'm integrating between NOPCommerce and an ERP system, a c# based system runs ...
0
votes
0answers
84 views

Writing binary file to response - only first chunk of content works

I am using the chunk method to read a binary file and write it to response. We implemented this code a few months ago to avoid the OutOfMemory exception on large video files. I swear it used to work - ...
0
votes
0answers
45 views

Argument of Out Range Exception while trying to read data from a List

I have a method that reads data from a database table using SqlDataReader. i assign data retrieved by SqlDataReader into a List and return it. when i want to assign the List data from method into the ...
0
votes
0answers
223 views

Need faster method for - XML parse using linq and convert ienumerable to idatareader and update reader to DB

I am wondering if anyone can help me to resolve a difficult scenario I am going through... I am iterating through a collection of items..there are about 400000 items in the collection. And for each ...
0
votes
0answers
47 views

SqlDataReader does not update value for column

I have a stored procedure running on SQL Server 2008 that returns a list of all procedures and their parameters: procedure [dbo].[p_ListProcedures] as select sp.name as 'Procedure', p.name as ...
0
votes
0answers
57 views

Unwanted Exception squelching during VS2008 debugging

Is there a way to force SqlDataReader to throw exceptions? There seems to be a very problematic behavior with it where SqlDataReader will have an exception and cause the function it's in to end ...
0
votes
0answers
56 views

How to resolved. Timeout issue cause of multiple reader

I have problem with OleDbDataReader Timeout. FYI, I have multiple OleDbDataReader in one try/catch. After reading, it will insert into same database. Refer to my sample code here: Dim ReadTerima, ...
0
votes
0answers
58 views

Generalizing the SqlDataReader pattern

I have a lot of code of the form: Using cn As New SqlConnection(MyConnectionString) cn.Open() Using cmd As New SqlCommand(MySqlText, cn) Using dr As SqlDataReader = ...
0
votes
0answers
30 views

sqldatareader reads null

I'm using an SQLDataReader to retrieve a row of data from a table. public SalesOrderItem getSalesOrderQuantity(Int32 so_no, Int32 so_item_no) { string commStr2 = "SELECT * FROM ...
0
votes
0answers
261 views

No data displayed in datagridview in WPF

I have a WPF form with a system.windows.form.datagridview in it. Using a SQL query I retrieve data from a database and us a SQLreader to read the data. This is stored in a dataview that is bound to ...
0
votes
0answers
131 views

Sqldatareader throwing providerbase.fieldnamelookup.getordinal(string fieldname) out of index error

I have a form based application where after selecting a SKU from drop down box, many different text boxes on the forms get populated by reading data from SQL. In my Sql datareader I have a condition ...

15 30 50 per page