Loading

SQL Select based on user input

Mohammed Salim

I m trying to retrieve no of rows from sql based user input & display in gridview

Please help!

This is code what I'm using

Int32 text = Convert.ToInt32(this.Txtusers.Text);
con.Open();
cmd = new SqlCommand("select TOP '" + text + "' * from Avaya_Id where LOB = '" + DDLOB.SelectedItem.Value + "' and Status = 'Unassigned'", con);
SqlDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.DataBind();
con.Close();

1 Reply

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

Nitin Sontakke8y ago
So where are you stuck? What is the question. Please be very specific. If you are getting error(s), please post the full stack trace / screen shot.