Hi rickabbam,
Please refer below sample and article
SQL
CREATE PROCEDURE MemberInsertDelete 20
@ID INT=NULL
AS
BEGIN
INSERT INTO oldMembers (name,age,location)
SELECT name,age,location FROM Members WHERE id=@ID
DELETE FROM Members WHERE id=@ID
END
HTML
<div>
Member Table Gridview
<asp:GridView ID="gvMembsers" runat="server" AutoGenerateColumns="false" OnRowDataBound="gvMembsers_RowDataBound">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" />
<asp:BoundField DataField="name" HeaderText="name" />
<asp:BoundField DataField="age" HeaderText="age" />
<asp:BoundField DataField="dob" HeaderText="dob" />
<asp:BoundField DataField="location" HeaderText="location" />
</Columns>
</asp:GridView>
<asp:Button ID="btnInsert" runat="server" Text="Insert" Visible="false" OnClick="btnInsert_Click" />
<br />
<br />
Old Member Tabel GridView
<asp:GridView ID="gvOldmembers" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" />
<asp:BoundField DataField="name" HeaderText="name" />
<asp:BoundField DataField="age" HeaderText="age" />
<asp:BoundField DataField="dob" HeaderText="dob" />
<asp:BoundField DataField="location" HeaderText="location" />
</Columns>
</asp:GridView>
</div>
Namespaces
C#
using TestModel;
using System.Web.UI.WebControls;
Vb.Net
Imports TestModel
Code
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Bind();
}
}
private void Bind()
{
TestEntities test = new TestEntities();
gvMembsers.DataSource = from m in test.members
select m;
gvMembsers.DataBind();
}
protected void gvMembsers_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CheckBox chk = new CheckBox();
chk.EnableViewState = true;
chk.Enabled = true;
chk.ID = "chkb";
chk.AutoPostBack = true;
chk.CheckedChanged += new EventHandler(CheckBox_CheckedChanged);
e.Row.Cells[0].Controls.Add(chk);
e.Row.TableSection = TableRowSection.TableBody;
}
}
protected void CheckBox_CheckedChanged(object sender, EventArgs e)
{
GridViewRow row = ((sender as CheckBox).NamingContainer) as GridViewRow;
string id = row.Cells[0].Text;
TestEntities test = new TestEntities();
test.InsertDelete(Convert.ToInt32(id));
this.Bind();
}
Vb.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Me.Bind()
End If
End Sub
Private Sub Bind()
Dim test As TestEntities = New TestEntities()
gvMembsers.DataSource = From m In test.members Select m
gvMembsers.DataBind()
End Sub
Protected Sub gvMembsers_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
Dim chk As CheckBox = New CheckBox()
chk.EnableViewState = True
chk.Enabled = True
chk.ID = "chkb"
chk.AutoPostBack = True
chk.CheckedChanged += New EventHandler(AddressOf CheckBox_CheckedChanged)
e.Row.Cells(0).Controls.Add(chk)
e.Row.TableSection = TableRowSection.TableBody
End If
End Sub
Protected Sub CheckBox_CheckedChanged(ByVal sender As Object, ByVal e As EventArgs)
Dim row As GridViewRow = TryCast(((TryCast(sender, CheckBox)).NamingContainer), GridViewRow)
Dim id As String = row.Cells(0).Text
Dim test As TestEntities = New TestEntities()
test.InsertDelete(Convert.ToInt32(id))
Me.Bind()
End Sub