I have a following table tblDataDamIDCalfTagBTypeBreadLoctation1011010H501021020H501031030H50From above table I displayed few columns in the DataGridView like thatDamIDCalfTagBTypeAction1011010HUpdate1021020HUpdate1031030HUpdateWhen I click on Update link button in each inside DataGridView then it will fetch all five values from above tblData and when I click on update button it will save all the fetched values in another tblAnimal table which is following like that tblAnimalDamNameTagIDBTyp

Hi smilePlease refer below sampleHTMLltaspGridView ID34gvCustomers34 runat34server34 AutoGenerateColumns34false34gt ltColumnsgt ltaspBoundField DataField34DamID34 HeaderText34DamID34 gt ltaspBoundField DataField34CalfTag34 HeaderText34CalfTag34 gt ltaspBoundField DataField34BType34 HeaderText34BType34 gt ltaspTemplateField HeaderText34Action34gt ltItemTemplategt ltaspLinkButton ID34lnkUpdate34 runat34server34 Text34Update34 OnClick34OnlnkUpdate34gtltaspLinkButtongt ltItemTemplategt ltaspTemplateFieldgt ltColumnsgtltaspGridViewgtltbr gtltaspGridView ID34gvAnimals34 runat34server34 AutoGenerateColumns34false34gt ltColumnsgt ltaspBoundField DataField34DamID34 HeaderText34DamID34 gt

Save values from one table to another using ASP.Net GridView in C# and VB.Net

smile

SOLVED CLOSED ACTIVE ANSWERED
User: smile
Posted: on Dec 11, 2022 09:44 PM
Forum: Data Controls
Answer: 1
Views: 1027
Sample Code: Download

I have a following table tblData

DamID	CalfTag	B_Type	Bread	Loctation
101	1010	H	5	0
102	1020	H	5	0
103	1030	H	5	0

From above table I displayed few columns in the DataGridView like that

DamID	CalfTag	B_Type	Action
101	1010	H	Update
102	1020	H	Update
103	1030	H	Update

When I click on Update link button in each inside DataGridView, then it will fetch all five values from above tblData and when I click on update button it will save all the fetched values in another tblAnimal table which is following like that tblAnimal

DamName	TagID	B_Type	Bread	LocNo
101	1010	H	5	0
103	1030	H	5	0

here is my code

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" ForeColor="#333333"
    RowStyle-Wrap="false" HeaderStyle-Wrap="false"
    Class="table table-striped table-bordered table-hover" OnRowCancelingEdit="GridView1_RowCancelingEdit"
    OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"
    onrowdatabound="GridView1_RowDataBound" >
    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    <Columns>
        <asp:TemplateField>
            <HeaderTemplate>
                <asp:CheckBox ID="checkAll" runat="server" onclick="checkAll(this);" />
            </HeaderTemplate>
            <ItemTemplate>
                <asp:CheckBox ID="CheckBox1" runat="server" onclick="Check_Click(this)" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Calf ID">
            <ItemTemplate>
                <asp:Label ID="lbl_No" runat="server" Text='<%# Eval("CalfID") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Dam ID">
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# Eval("DamID") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtDam" runat="server" Text='<%# Eval("DamID") %>' class="form-control"
                    Width="150"></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
       <asp:TemplateField HeaderText="Sire Name">
            <ItemTemplate>
                <asp:Label ID="Label2" runat="server" Text='<%# Eval("SireName") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtSire" runat="server" Text='<%# Eval("SireName") %>' class="form-control"
                    Width="150"></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Date of Birth">
            <ItemTemplate>
                <asp:Label ID="Label3" runat="server" Text='<%# Eval("DOB") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtDate" runat="server" Text='<%# Eval("DOB") %>' class="form-control"
                    Width="150"></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
         
        <asp:TemplateField HeaderText="Calf Tag">
            <ItemTemplate>
                <asp:Label ID="Label4" runat="server" Text='<%# Eval("CalfTag") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtCalfTag" runat="server" Text='<%# Eval("CalfTag") %>' class="form-control"
                    Width="150"></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
         
         <asp:TemplateField HeaderText="Gender">
            <ItemTemplate>
                <asp:Label ID="Label5" runat="server" Text='<%# Eval("Gender") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtGender" runat="server" Text='<%# Eval("Gender") %>' class="form-control"
                    Width="150"></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
 
          <asp:TemplateField HeaderText="Weight">
            <ItemTemplate>
                <asp:Label ID="Label6" runat="server" Text='<%# Eval("Weight") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtWeight" runat="server" Text='<%# Eval("Weight") %>' class="form-control"
                    Width="150"></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
 
         <asp:TemplateField HeaderText="Pen Name ">
            <ItemTemplate>
                <asp:Label ID="Label7" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
            </ItemTemplate>                                            
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Total Days ">
            <ItemTemplate>
                <asp:Label ID="Label70" runat="server" Text='<%# Eval("Days") %>'></asp:Label>
            </ItemTemplate>                                            
        </asp:TemplateField>
 
        <asp:TemplateField HeaderText="Action" ShowHeader="false">
            <ItemTemplate>
                <asp:LinkButton ID="btnedit" runat="server" CommandName="Edit" Text="Update" Visible ='<%# Convert.ToInt16(Eval("Days")) >= Convert.ToInt16(91) %>'></asp:LinkButton>                                                  
            </ItemTemplate>
            <EditItemTemplate>
                <asp:LinkButton ID="btnupdate" runat="server" CommandName="Update" Text="Heifer"></asp:LinkButton>
                <asp:LinkButton ID="btncancel" runat="server" CommandName="Cancel" Text="Dead"></asp:LinkButton>
            </EditItemTemplate>
        </asp:TemplateField>
 
        
    </Columns>
    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <EditRowStyle BackColor="#CCCCCC" />
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>

Label lbl_No = GridView1.Rows[e.RowIndex].FindControl("lbl_No") as Label;////DamID,SireID,DOB,TagID,Gender,Calf_Pen,AnimalName,Bread,Company,AFrom,Type,LocNo,BStatus       
con = new SqlDbConnect();
con.SqlQuery(@"select DamID,SireName,DOB,CalfTag,Gender,Calf_Pen,Animal_Name,Bread,Company,C_From,B_Type,Loctation,B_Status from tblCalf
                where CalfID=@TId;");
con.Cmd.Parameters.Add(new SqlParameter("@TId", lbl_No.Text));
con.RdrEx();
while (con.Rdr.Read())
{
    string Dam = con.Rdr[0].ToString();
    string Sire = con.Rdr[1].ToString();
    string DOB = con.Rdr[2].ToString();
    string Tag = con.Rdr[3].ToString();
    string Gen = con.Rdr[4].ToString();
    string Pen = con.Rdr[5].ToString();
    string Name = con.Rdr[6].ToString();
    string Bread = "5"; // con.Rdr[7].ToString();
    //string Company = con.Rdr[].ToString();
    string AFrom = con.Rdr[8].ToString();
    string Type = con.Rdr[9].ToString();
    string LocNo = con.Rdr[10].ToString();
    string Status = con.Rdr[11].ToString();
}
con.conClose();
 
con = new SqlDbConnect();
//con.SqlQuery(@"Insert into tblAnimal (DamID,SireID,BDate,TagID,Gender,PenID,AnimalName,BreadID,Company,AFrom,Type,LocNo,BStatus) values (@Dam,@Sire,@DOB,@Tag,@Gen,@Pen,@Name,@Bread,@Company,@From,@Type,@Loctation,@Status)");
con.SqlQuery(@"Insert into tblAnimal (DamID,SireID,BDate,TagID,Gender,PenID,AnimalName,BreadID,AFrom,Type,LocNo,BStatus) values (@Dam,@Sire,@DOB,@Tag,@Gen,@Pen,@Name,@Bread,@From,@Type,@Loctation,@Status)");
con.Cmd.Parameters.Add(new SqlParameter("@Dam", Dam.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Sire", Sire.Text));
con.Cmd.Parameters.Add(new SqlParameter("@DOB", DOB.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Tag", Tag.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Gen", Gen.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Pen", Pen.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Name", Name.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Bread", Bread.Text));
//con.Cmd.Parameters.Add(new SqlParameter("@Company", Company.Text));
con.Cmd.Parameters.Add(new SqlParameter("@From", AFrom.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Type", Type.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Loctation", LocNo.Text));
con.Cmd.Parameters.Add(new SqlParameter("@Status", Status.Text));
con.NonQueryEx();

Download FREE API for Word, Excel and PDF in ASP.Net

PrinceG

0 4

Reply
ANSWER
User: PrinceG
Replied: on Dec 12, 2022 03:50 AM
Report

Hi smile,

Please refer below sample.

HTML

<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="DamID" HeaderText="DamID" />
        <asp:BoundField DataField="CalfTag" HeaderText="CalfTag" />
        <asp:BoundField DataField="B_Type" HeaderText="B_Type" />
        <asp:TemplateField HeaderText="Action">
            <ItemTemplate>
                <asp:LinkButton ID="lnkUpdate" runat="server" Text="Update" OnClick="OnlnkUpdate"></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>
<br />
<asp:GridView ID="gvAnimals" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="DamID" HeaderText="DamID" />
        <asp:BoundField DataField="CalfTag" HeaderText="CalfTag" />
        <asp:BoundField DataField="B_Type" HeaderText="B_Type" />
        <asp:BoundField DataField="Bread" HeaderText="Bread" />
        <asp:BoundField DataField="Location" HeaderText="Location" />
    </Columns>
</asp:GridView>
<asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="OnbtnUpdate" />

Namespaces

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

VB.Net

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGirdView();
    }
}

protected void OnlnkUpdate(object sender, EventArgs e)
{
    List<int> damids = new List<int>();
    GridViewRow row = (sender as LinkButton).NamingContainer as GridViewRow;
    int damId = int.Parse(row.Cells[0].Text);
    if (Session["Id"] == null)
    {
        damids.Add(damId);
        Session["Id"] = damids;
    }
    else
    {
        damids = (List<int>)Session["Id"];
        damids.Add(damId);
        Session["Id"] = damids;
    }
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand(string.Format("SELECT * FROM tblData WHERE DamID IN ({0})", string.Join(",", damids.Distinct())), con))
        {
            con.Open();
            gvAnimals.DataSource = cmd.ExecuteReader();
            gvAnimals.DataBind();
            con.Close();
        }
    }
}

private void BindGirdView()
{
    string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT DamID,CalfTag,B_Type FROM tbldata", con))
        {
            con.Open();
            gvCustomers.DataSource = cmd.ExecuteReader();
            gvCustomers.DataBind();
            con.Close();
        }
    }
}

protected void OnbtnUpdate(object sender, EventArgs e)
{
    foreach (GridViewRow row in gvAnimals.Rows)
    {
        string damName = row.Cells[0].Text;
        string tagID = row.Cells[1].Text;
        string b_Type = row.Cells[2].Text;
        string bread = row.Cells[3].Text;
        string locNo = row.Cells[4].Text;
        string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constring))
        {
            using (SqlCommand cmd = new SqlCommand("INSERT INTO tblAnimals (CalfTag,B_Type,Bread,Location) Values (@CalfTag,@B_Type,@Bread,@Location)", con))
            {
                cmd.Parameters.AddWithValue("@CalfTag", tagID);
                cmd.Parameters.AddWithValue("@B_Type", b_Type);
                cmd.Parameters.AddWithValue("@Bread", bread);
                cmd.Parameters.AddWithValue("@Location", locNo);
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Me.BindGirdView()
    End If
End Sub

Protected Sub OnlnkUpdate(ByVal sender As Object, ByVal e As EventArgs)
    Dim damids As List(Of Integer) = New List(Of Integer)
    Dim row As GridViewRow = TryCast(TryCast(sender, LinkButton).NamingContainer, GridViewRow)
    Dim damId As Integer = Integer.Parse(row.Cells(0).Text)
    If Session("Id") Is Nothing Then
        damids.Add(damId)
        Session("Id") = damids
    Else
        damids = CType(Session("Id"), List(Of Integer))
        damids.Add(damId)
        Session("Id") = damids
    End If

    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(conString)
        Using cmd As SqlCommand = New SqlCommand(String.Format("SELECT * FROM tblData WHERE DamID IN ({0})", String.Join(",", damids.Distinct())), con)
            con.Open()
            gvAnimals.DataSource = cmd.ExecuteReader()
            gvAnimals.DataBind()
            con.Close()
        End Using
    End Using
End Sub

Private Sub BindGirdView()
    Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constring)
        Using cmd As SqlCommand = New SqlCommand("SELECT DamID,CalfTag,B_Type FROM tbldata", con)
            con.Open()
            gvCustomers.DataSource = cmd.ExecuteReader()
            gvCustomers.DataBind()
            con.Close()
        End Using
    End Using
End Sub

Protected Sub OnbtnUpdate(ByVal sender As Object, ByVal e As EventArgs)
    For Each row As GridViewRow In gvAnimals.Rows
        Dim damName As String = row.Cells(0).Text
        Dim tagID As String = row.Cells(1).Text
        Dim b_Type As String = row.Cells(2).Text
        Dim bread As String = row.Cells(3).Text
        Dim locNo As String = row.Cells(4).Text
        Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
        Using con As SqlConnection = New SqlConnection(constring)
            Using cmd As SqlCommand = New SqlCommand("INSERT INTO tblAnimals (CalfTag,B_Type,Bread,Location) Values (@CalfTag,@B_Type,@Bread,@Location)", con)
                cmd.Parameters.AddWithValue("@CalfTag", tagID)
                cmd.Parameters.AddWithValue("@B_Type", b_Type)
                cmd.Parameters.AddWithValue("@Bread", bread)
                cmd.Parameters.AddWithValue("@Location", locNo)
                con.Open()
                cmd.ExecuteNonQuery()
                con.Close()
            End Using
        End Using
    Next
End Sub

Screenshot

Output

DamID	CalfTag	B_Type	Bread	Location
1	1020	H	5	0

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save values from one table to another using ASP.Net GridView in C# and VB.Net

Company

Explore

Follow us

Contact Us