protected void find2() { cmd2 = new SqlCommand("select * from Partners_Notes_table_edutrack where nt_subject like @name+'%'", con); cmd.Parameters.Add("@name", SqlDbType.NVarChar, 50).Value = TextBox_Search.Text; ad = new SqlDataAdapter(); ad.SelectCommand = cmd; DataSet ds2 = new DataSet(); ad.Fill(ds2); Employee_grid.DataSource = ds2; Employee_grid.DataBind(); }
protected void Button_Search_Click(object sender, EventArgs e) { con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString; con.Open(); cmd = new SqlCommand("select * from Registration_table_edutrack where u_name like @name+'%'", con); cmd.Parameters.Add("@name", SqlDbType.NVarChar, 50).Value = TextBox_Search.Text; ad = new SqlDataAdapter(); ad.SelectCommand = cmd; DataSet ds = new DataSet(); ad.Fill(ds); Employee_grid.DataSource = ds; Employee_grid.DataBind(); }