ashima kukreja

ashima kukreja

  • 2k
  • 19
  • 11.9k

May 28 2013 4:41 AM

       i have a field in my table isadmin where if he is admin it is 1 otherwise it is set to 0.
on a page load i want to show my gridview  so i am wiritting   this code .

SqlCommand cmd = new SqlCommand(" select fname,lname from UserInfo where IsAdmin=@IsAdmin" , cn);
                    cmd.Parameters.Add(new SqlParameter("@IsAdmin" i want here  that isadmin should take 0 so that it will display rows what to write here ));

                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    DataSet ds = new DataSet();
                    GridView1.DataSource = ds;

Answers (2)