Provides a way of reading a forward-only stream of rows from a SQL Server database.
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 ...