P
Patrick Olurotimi Ige
With the code below i get error:-
Invalid attempt to read data when reader is closed.
//Get a datareader
SqlDataReader objDataReader;
objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConnection);
datalistoutput.DataSource = objDataReader;
datalistoutput.DataBind();
if (objDataReader["Sub_Category_Text"].ToString() == "asdas")
{
datalistoutput.Visible = true;
}
else
{
datalistoutput.Visible = false;
}
And if i want to check if "Sub_Category_Text" is NULL how can i do it
using my objDataReader?
Invalid attempt to read data when reader is closed.
//Get a datareader
SqlDataReader objDataReader;
objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConnection);
datalistoutput.DataSource = objDataReader;
datalistoutput.DataBind();
if (objDataReader["Sub_Category_Text"].ToString() == "asdas")
{
datalistoutput.Visible = true;
}
else
{
datalistoutput.Visible = false;
}
And if i want to check if "Sub_Category_Text" is NULL how can i do it
using my objDataReader?