HI,
Can you please send the aspx and aspx.cs code so I can look on it.

I got this error "System.Data.SqlClient.SqlException: Must declare the scalar variable "@EMP_ID"." where i implement this code employeeupdate.aspx

Update Employess Details
Emp Id :	<%----%>

.cs file protected void btnShow1_Click(object sender, EventArgs e) { ParameterCollection prm = SqlDataSource1.SelectParameters; prm[0].DefaultValue = txtEmpId.Text; }

you can do this by using drop down list, if you click on ID in drop down list you can get all data.

Click on drop down list in write this code

{

    string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";

    SqlConnection con = new SqlConnection(str);

    string query = "select * from tablename where name = '"+dropdownlist.text+"' ";

    SqlCommand cmd = new SqlCommand( query,con);

    sqldatareader dbr;

    try

    {

        con.open();

        dbr = cmd.executereader();

        while(dbr.read())

        {

            string sID = (string) dbr["ID"].tostring;

            string sname = (string) dbr["name"] // name is string value

            string sage = (string) dbr["age"].tostring;

            textbox1.text = sid;

            textbox2.text = sname;

            textbox3.text = sage;

            showgrid();

 

        }

        catch(execption es)

        {

           messagebox.show(es.message);

        }

    }

} 


If you want to more operation with grid view or data gridview then go to my C-sharp corner blogs.

HI,

public Datatable bindGridview(int empID)

    {
//Call the store procedure or sql query to get the data from database
        DataTable dt = new DataTable();

        da.Fill(dt);     

        if (dt.Rows.Count == 0)

        {       

            GridView1.Visible = false;

        }

        else

        {

            GridView1.Visible = true;

            GridView1.DataSource = dt;

            GridView1.DataBind();

        }

    }



  protected void Button1_Click(object sender, EventArgs e)

 {

 bindGridview(empID)

}

Hope this will help.