protected void Button2_Click(object sender, EventArgs e) //search/display { ServiceReference1.gettestdata g = new ServiceReference1.gettestdata(); g = client.GetInfo(); DataTable dt = new DataTable(); dt = g.usertab; GridView1.DataSource = dt; GridView1.DataBind(); }
protected void Button2_Click(object sender, EventArgs e) { ServiceReference1.gettestdata g = new ServiceReference1.gettestdata(); g = client.GetInfo(); DataTable dt = new DataTable(); dt = g.usertab; GridView1.DataSource = dt; GridView1.DataBind(); /*string constr = ConfigurationManager.ConnectionStrings["MyTestDB"].ToString(); * SqlConnection con = new SqlConnection(constr); * con.Open(); * SqlCommand cmd = new SqlCommand("SELECT * FROM UserTab where Name like @UserID + '%'", con); * cmd.Parameters.AddWithValue("@UserID", lblmsg.Text.Trim()); * SqlDataAdapter sda = new SqlDataAdapter(cmd); * DataTable dt = new DataTable(); * sda.Fill(dt); * GridView1.DataSource = dt; * GridView1.DataBind();*/ }