Specific query on sqlcommand

Question

hii,can anyone tell what is wrong with this code.??

SqlCommand command = new SqlCommand("SELECT DISTINCT TOR_Name FROM TESTCASESTATUS_TABLE WHERE TestCaseID = '" 
        + DropDownList1.SelectedItem.Text + "'", connection);
SqlDataReader x = command.ExecuteReader();
if (null != x && x.HasRows)
   TestCaseName.Text = Convert.ToString(x["TOR_Name"]);
else 
   TestCaseName.Text = "something";
x.Close();

when i debug the code it is even getting into the if conditioon but then it is throwing an error, invalid attempt to read data when no data is present. !!! please help/.

SWeko · Accepted Answer · 2011-04-07 13:27:34Z

3

You need to issue a DataReader.Read command for the data to be actually loaded into fields, like

SqlDataReader x = command.ExecuteReader(); 
if (null != x && x.HasRows) 
{
  x.Read();
  TestCaseName.Text = Convert.ToString(x["TOR_Name"]); 
}
....

answered Apr 7, 2011 at 13:27

SWeko

30.9k11 gold badges74 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Richard Schneider · Accepted Answer · 2011-04-07 13:28:56Z

1

Call x.Read() to fetch the first result.

answered Apr 7, 2011 at 13:28

Richard Schneider

35.5k9 gold badges59 silver badges74 bronze badges

Collectives™ on Stack Overflow

Specific query on sqlcommand

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related