How to find dataset has rows

Shivaraj Poojary

15y3.7k.NET

Hi Experts.... can u suggest me how to find if the dataset has rows..I am comparing textbox value with table value..

If dataset has rows it should execute some code and if dataset has no rows it should execute some other data..Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayur Gujrathi15y ago
Accepted answer
do like this if doesnt work please reply
if(ds.Tables(0).Rows.count > 0)
{
Execute code
}
else
{
Execute else code.
}
here ds is dataset
0
Abhimanyu K Vatsa15y ago
Use this

SqlDataSource sds = new SqlDataSource();
sds.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString1"].ToString();

sds.SelectParameters.Add("username", TypeCode.String, this.username.Text);
sds.SelectParameters.Add("password", TypeCode.String, this.password.Text);

sds.SelectCommand = "SELECT * FROM [users] WHERE [username] = @username AND [password] = @password";

DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty);
try
{
if (dv.Count == 0)
{
this.lblinfo.ForeColor = System.Drawing.Color.Red;
this.lblinfo.Text = "Invalid username or password.";
return;
}
else
{
FormsAuthentication.RedirectFromLoginPage(username.Text, true);
Session["username"] = username.Text;
}
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
string msg = "Error";
msg += ex_msg.Message;
throw new Exception(msg);
}
0
Ankit Nandekar15y ago
try this
DataSet ds = new DataSet();

if( ds.Tables[0].Rows.Count>0)
{
write code which u want to execute when row is present in dataset

}
else
{
write code which u want to execute when row is not present in dataset

}
0