How to find dataset has rows

Question

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

Mayur Gujrathi · 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

Abhimanyu K Vatsa · Answer

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); }

Ankit Nandekar · Answer

try this DataSet ds = new DataSet(); i f( 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 }