how to insert update and delete in asp.net

Posted by Shanky11 under ASP.NET on 12/17/2012 | Points: 10 | Views : 2969 | Status : [Member] | Replies : 9

Write New Post |

Search Forums | Answered

Answered

Resolved Posts |

Un Answered Posts |

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
Width="491px" PageSize="3" EnableViewState="True" ShowFooter="true" ShowHeader="true"
HeaderStyle-BackColor="Aqua" Height="279px"
onselectedindexchanged="GridView1_SelectedIndexChanged"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating"
onrowcancelingedit="GridView1_RowCancelingEdit">
<Columns>
<asp:TemplateField HeaderText="Name" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<%# Eval("Name")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtUserName" runat="Server" Text='<%# Eval("Name") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtnewUserName" runat="Server"></asp:TextBox>
</FooterTemplate>

<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:TemplateField>

<asp:TemplateField HeaderText="Age">
<ItemTemplate>
<%#Eval("Age")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtUserage" runat="Server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<%#Eval("adress")%>

</ItemTemplate>
<FooterTemplate>
<asp:Button ID="Button1" runat="server" Text="Insert" CommandName="add" />
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Delete" ShowDeleteButton="true"
ShowHeader="true" />
<asp:CommandField HeaderText="Edit" ShowEditButton ="true" />
<asp:CommandField HeaderText="Select" ShowSelectButton="true" />

</Columns>
<EmptyDataTemplate>
<asp:Button ID="btnInsert" runat="Server" Text="Insert" CommandName="EmptyInsert" UseSubmitBehavior="False" />
</EmptyDataTemplate>
</asp:GridView>

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Ranjeet_8 on: 12/17/2012 [Member] [MVP] Gold | Points: 25

0	Look at this articel http://www.dotnetfunda.com/articles/article71.aspx http://csharpdotnetfreak.blogspot.com/2009/05/gridview-sqldatasource-insert-edit.html Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ranjeet_8 on: 12/17/2012 [Member] [MVP] Gold | Points: 25

0	@Shanky11 Please Mark As Answer if post helps you. Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0	u can use this for editing....and in next post i will show u how to update protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e) { gvDetails.EditIndex = e.NewEditIndex; BindEmployeeDetails(); } Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0

Down

for updating......try this

 protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());

string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();

TextBox txtcity = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtcity");

TextBox txtDesignation = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtDesg");

con.Open();

SqlCommand cmd = new SqlCommand("update Employee_Details set City='" + txtcity.Text + "',Designation='" + txtDesignation.Text + "' where UserId=" + userid, con);

cmd.ExecuteNonQuery();

con.Close();

lblresult.ForeColor = Color.Green;

lblresult.Text = username + " Details Updated successfully";

gvDetails.EditIndex = -1;

BindEmployeeDetails();

}

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0

Down

for deleting.......try this

 protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values["UserId"].ToString());

string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();

con.Open();

SqlCommand cmd = new SqlCommand("delete from Employee_Details where UserId=" + userid, con);

int result = cmd.ExecuteNonQuery();

con.Close();

if (result == 1)

{

BindEmployeeDetails();

lblresult.ForeColor = Color.Red;

lblresult.Text = username + " details deleted successfully";

}

}

mark this if it helps u

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0	and for canceling u can try following code protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { gvDetails.EditIndex = -1; BindEmployeeDetails(); } Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0	and for canceling u can try following code protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { gvDetails.EditIndex = -1; BindEmployeeDetails(); } Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0	mark this if it helps u Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ankitsrist on: 12/18/2012 [Member] Starter | Points: 25

0	mark this if it helps u Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Login to post response

Latest Posts