01.if (TextBox1.Text == TextBox1.Text)
02. {
03. using (SqlConnection sqlcon = new SqlConnection(connectiondb))
04. {
05. sqlcon.Open();
06. SqlDataAdapter sqlda = new SqlDataAdapter("SELECT Count(*) FROM [Case] Where UsrKey = '"+TextBox1.Text+"' ", sqlcon);
07. DataTable aaa = new DataTable();
08. sqlda.Fill(aaa);
09. GridView1.DataSource = aaa;
10. GridView1.DataBind();
11.
12.
13.
14. }
15. }
