Search Result

Selun · Jan 15 '11, 06:03 PM

Hi all,
First of all im not sure if this is the correct section to ask this.

Im using C# .NET

I m trying to populate a gridview using datareader with the following code

Code:

protected void page_load (object sender, System.EventArgs e)
 {

        SQLCon.ConnectionString = constr;
        SQLCon.Open();

        System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("select

...

smartguy05 · Aug 24 '10, 08:05 PM

I am trying to get the output from a stored procedure. When I enter a value into the stored procedure directly in SQL server management studio it works fine, but when I do it using my code I get nothing. But if I use cmd.parameters( "@oOCR").va lue then I get the first 5 characters, but the last 5 are all zeros. Here is my current code:

Code:

Public Sub GetPlayerCardNumber(ByVal input As String)
        Dim con As SqlConnection

...

majidkorai · Jun 26 '09, 10:14 AM

Hey

Guyz I am having problem when i read the data from a datareader into a data table.

The whole scenario is this that I want to read data from two diffrent databases, the table strcutre is same. You can say that other one is the copy of 1st one. I want to read out the data from one table in one database and merge the results with the one read form the other database.

What i am doing is reading data from two...

Search Result

Problem with retrieving data using DataReader C# .NET

Can't get data from database

Column does not belong to table