Dear All,
i am trying to edit a datagrid with update and cancel commands but on clicking "edit" its not replacing it with update and cancel buttons.
and the code for the update button is as follows:

private void dgemp_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            SqlConnection myconn=new SqlConnection(strconn);
            SqlCommand cmd;
            TextBox txtempname=(TextBox)( e.Item.Cells[1].Controls[0]);
            TextBox txtempsalary= (TextBox)(e.Item.Cells[2].Controls[0]);
            TextBox txtdeptname= (TextBox )(e.Item.Cells[3].Controls[0]);

            string strupdate;
            strupdate ="update employee set empname=@empname, empsalary=@empsalary, deptname=@deptname where empno=@empno";
            cmd=new SqlCommand(strupdate, myconn);
            cmd.Parameters.Add(new SqlParameter("@empname", txtempname.Text));
            cmd.Parameters.Add(new SqlParameter("@empsalary", txtempsalary.Text));
            cmd.Parameters.Add(new SqlParameter("@deptname", txtdeptname.Text));
            cmd.Parameters.Add(new SqlParameter("@empno", e.Item.Cells[0].Text));
            myconn.Open();
            cmd.ExecuteNonQuery ();
            dgemp.EditItemIndex =-1;
            myconn.Close();
            binddata();

}

plz help me out.

thanks and regards,
Muskaan.

You need to get the grid into edit mode with a handler for the grid EditCommand event. The handler should contain something like this:

dgemp.EditItemIndex = e.Item.ItemIndex;
binddata();

This rebuilds the grid with the right edit row in edit mode. Then you get the update button that will fire the event handler you posted above.

-Peter

Thanx Peter,
i have done that with d following code.
but am not getting the buttons..

private void dgemp_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            dgemp.EditItemIndex =e.Item.ItemIndex;
            binddata();
        }

        private void dgemp_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            dgemp.EditItemIndex =1;
            binddata();
        }

        private void binddata()
        {
            SqlConnection myconn= new SqlConnection(strconn);
            string mysql="select * from employee";
            SqlDataAdapter Ademp=new SqlDataAdapter(mysql, myconn);
            DataSet Ds=new DataSet();

            Ademp.Fill(Ds, "employee");
            dgemp.DataSource =Ds.Tables["employee"].DefaultView ;
            dgemp.DataBind();

        }

You aren't getting the edit buttons?

Post your datagrid markup. You have an EditCommandColumn in the column list?

-Peter

Thanx Peter,
am sending u the whole code which is as follows :

public class UpdateDatagrd : System.Web.UI.Page
{
    protected System.Web.UI.WebControls.Label Label1;
    protected System.Web.UI.WebControls.DataGrid dgemp;

    string strconn="Data Source=sapnew; Initial Catalog=master; Integrated Security=SSPI";

private void Page_Load(object sender, System.EventArgs e)
{
    binddata();
}

private void dgemp_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
    dgemp.EditItemIndex =e.Item.ItemIndex;
    binddata();
}

private void dgemp_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
    dgemp.EditItemIndex =-1;
    binddata();
}

private void binddata()
{
    SqlConnection myconn= new SqlConnection(strconn);
    string mysql="select * from employee";
    SqlDataAdapter Ademp=new SqlDataAdapter(mysql, myconn);
    DataSet Ds=new DataSet();

    Ademp.Fill(Ds, "employee");
    dgemp.DataSource =Ds.Tables["employee"].DefaultView ;
    dgemp.DataBind();

}

private void dgemp_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
    SqlConnection myconn=new SqlConnection(strconn);
    SqlCommand cmd;
    TextBox txtempname=(TextBox)( e.Item.Cells[1].Controls[0]);
    TextBox txtempsalary= (TextBox)(e.Item.Cells[2].Controls[0]);
    TextBox txtdeptname= (TextBox )(e.Item.Cells[3].Controls[0]);

    string strupdate;
        strupdate ="update employee set empname=@empname, empsalary=@empsalary, deptname=@deptname where empno=@empno";
    cmd=new SqlCommand(strupdate, myconn);
    cmd.Parameters.Add(new SqlParameter("@empname", txtempname.Text));
    cmd.Parameters.Add(new SqlParameter("@empsalary", txtempsalary.Text));
    cmd.Parameters.Add(new SqlParameter("@deptname", txtdeptname.Text));
    cmd.Parameters.Add(new SqlParameter("@empno", e.Item.Cells[0].Text));
    myconn.Open();
    cmd.ExecuteNonQuery ();
    dgemp.EditItemIndex =-1;
    myconn.Close();
    binddata();
}


and d datagrid markup is as follows :
<asp:DataGrid id="dgemp" style="Z-INDEX: 102; LEFT: 144px; POSITION: absolute; TOP: 88px" runat="server"
                ForeColor="#8080FF" BackColor="#C0FFFF" AutoGenerateColumns="False" Height="224px" Width="488px">
                <SelectedItemStyle ForeColor="#FFFFC0" BackColor="#C0C0FF"></SelectedItemStyle>
                <AlternatingItemStyle BackColor="#FFC0FF"></AlternatingItemStyle>
                <Columns>
                    <asp:BoundColumn DataField="empno" HeaderText="Employee ID"></asp:BoundColumn>
                    <asp:BoundColumn DataField="empname" HeaderText="Employee Name"></asp:BoundColumn>
                    <asp:BoundColumn DataField="empsalary" HeaderText="Employee Salary"></asp:BoundColumn>
                    <asp:BoundColumn DataField="deptname" HeaderText="Department Name"></asp:BoundColumn>
                    <asp:ButtonColumn Text="Select" ButtonType="PushButton" CommandName="Select"></asp:ButtonColumn>
                    <asp:EditCommandColumn ButtonType="PushButton" UpdateText="Update" CancelText="Cancel" EditText="Edit"></asp:EditCommandColumn>
                </Columns>
            </asp:DataGrid>

Thanks & Regards,
Muskaan.

Hey Peter,
now i am getting the buttons "Edit", "Update" and "Cancel" after specifying Postback in the page_load().

but it is not updating the fields.

Regards,
Muskaan.

I am now able to update but the prb is that it is updating all d records in d database with that same value.

private void dgemp_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
    SqlConnection myconn=new SqlConnection(strconn);
    SqlCommand cmd;
    TextBox txtempname=(TextBox)( e.Item.Cells[1].Controls[0]);
    TextBox txtempsalary= (TextBox)(e.Item.Cells[2].Controls[0]);
    TextBox txtdeptname= (TextBox )(e.Item.Cells[3].Controls[0]);

    string strupdate;
    strupdate ="update employee set empname=@empname, empsalary=@empsalary, deptname=@deptname where empno=@empno";
    cmd=new SqlCommand(strupdate, myconn);
    cmd.Parameters.Add(new SqlParameter("@empname", txtempname.Text));
    cmd.Parameters.Add(new SqlParameter("@empsalary", txtempsalary.Text));
    cmd.Parameters.Add(new SqlParameter("@deptname", txtdeptname.Text));
    cmd.Parameters.Add(new SqlParameter("@empno", e.Item.Cells[0].Text));
    myconn.Open();
    cmd.ExecuteNonQuery();
    dgemp.EditItemIndex = -1;
    myconn.Close();

    binddata();

}

private void binddata()
{
    SqlConnection myconn= new SqlConnection(strconn);
    string mysql="select empno, empname, empsalary, deptname from employee";
        SqlDataAdapter Ademp=new SqlDataAdapter(mysql, myconn);
    DataSet Ds=new DataSet();

    Ademp.Fill(Ds, "employee");
    dgemp.DataSource =Ds.Tables["employee"].DefaultView ;
    dgemp.DataBind();
}

Plz help me out.

Thanks & Regards,
Muskaan :)

You're going to have to modify your SQL update statement to update only the records you want. If the query values are correct you'll have to debug it to see what the values are that you are assigning to the stored procedure call.

-Peter