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();
        }
Esempio n. 2
0
        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();*/
        }