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

[Tim Field]

Hi all,

Im 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 Im 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.