The following code sample shows how to edit or delete in a gridview
///////////////////////////
void bind()
{
ds = ob1.dbrdset("select * from student1");
GridView1.DataSource=ds.Tables[0];
GridView1.DataBind();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
bind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
bind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
TextBox t1 = (TextBox)(GridView1.Rows[GridView1.EditIndex].Cells[0].Controls[0]);
TextBox t2 = (TextBox)(GridView1.Rows[GridView1.EditIndex].Cells[1].Controls[0]);
if (t1.Text == "")
{
//alert..
}
else if (t2.Text == "")
{
//alert..
}
else
{
cmd = ob1.dbcommand("updateproc");
//cmd.Parameters.Add("roll", SqlDbType.Int).Value = id;
cmd.Parameters.Add("roll", SqlDbType.Int).Value = Convert.ToInt32(t1.Text);
cmd.Parameters.Add("marks", SqlDbType.Int).Value = Convert.ToInt32(t2.Text);
cmd.Parameters.Add("dept", SqlDbType.VarChar, 50).Value = t3.Text;
cmd.Parameters.Add("name", SqlDbType.VarChar, 50).Value = t4.Text;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
bind();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int i = (int)GridView1.DataKeys[e.RowIndex].Value;
cmd = ob1.dbcommand("deleteproc");
cmd.Parameters.Add("roll", SqlDbType.Int).Value = i;
GridView1.EditIndex = -1;
cmd.ExecuteNonQuery();
bind();
}
|
| Author: Debasmit Samal 07 May 2008 | Member Level: Gold Points : 2 |
When I am opening this page it is asking for Please enter your name. Please enter your roll number etc........
How u have done this for this perticular page
|
| Author: Nithya 07 May 2008 | Member Level: Bronze Points : 2 |
please send design view also
|
| Author: Nithya 07 May 2008 | Member Level: Bronze Points : 2 |
please send design view also
|
| Author: shaik mohiuddin 10 May 2008 | Member Level: Gold Points : 2 |
nice one but send design view also .
|