Odd stored proc problem (table ok but not returning data).

[Tim Field]

Hi all,

 

I'm doing some pretty standard stuff here. The database is ok and the proc returns 200 records when I run this directly in query analyser. The datareader is returning the recordset but I'm getting no records. Any ideas?

 

Thanks! Tim

 

 

--------------------------------------------------------

SqlConnection mySqlConnection = new SqlConnection();

 

string strConn = "";

 

strConn = "Data Source=" + this.textBoxInstance.Text + ";" ;

strConn += "DataBase= " + this.textBoxDBName.Text + ";" ;

//strConn += " Integrated Security=SSPI ;" ;

strConn += "User ID = sa;" ;

strConn += " connection timeout=10000" ;

 

mySqlConnection.ConnectionString = strConn;

SqlCommand cmd = mySqlConnection.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "sta_pix_Create_Adnos";

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

cmd.Connection.Open();

// use the sqldatareader

dr = cmd.ExecuteReader();

 

string hello;

if(dr.Read())

{

// This will be the UPN

hello = dr.GetString(0); // first column

}

[PlausiblyDamp]

If you step through the code does dr.Read() evaluate to true or false?

[Tim Field]

It evaluates to false.

 

The metadata says it has my column from the data coming back.

[Tim Field]

Sorry it was me being useless! Returning 2 datasets, the first one being empty durrrrrr...

[PlausiblyDamp]

I just noticed you are using both a DataAdapter and a DataReader in your original code - if you are wanting to loop with a DataReader then I would try to remove the DataAdapter related code and see if that clears up the problem.