asp.net

ashima kukreja

hello,

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

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

2 Replies

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

Raj Kumar13y ago
Int inputvalue = 0; // pass value whether o or 1.
cmd.Parameters.Add(new SqlParameter("@IsAdmin" SqlDbType.Int, 32, inputvalue));
Jignesh Trivedi13y ago
hi,

try following code..
cmd.Parameters.Add("@IsAdmin", SqlDbType.VarChar); // specify here type.
cmd.Parameters["@IsAdmin"].Value = 0;

are you got any error run time or compile time?