how to populate data into grid view items then insert into database?

in asp.net webforms it's very easy to achieve, use dataset and dataAdapter

changes are made to dataset which represents in-memory changes at last when you are satisfied with all the changes , we use dataset,Update() which commits changes to database at one go.

go through my article if you have any doubt on disconnected scenario , and follow the example at the last of article

https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter

public partial class DataSetAndDataAdapter : System.Web.UI.Page
{
string cs = "Data Source=SACHIN-PC\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
BindGrid();
BindCountry();
}
}
private DataSet GetEmployee()
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(cs))
{
SqlDataAdapter da = new SqlDataAdapter("select * from Employee",con);
da.Fill(ds);
}
Cache["ds"] = ds;
return ds;
}
private void BindCountry()
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(cs))
{
SqlDataAdapter da = new SqlDataAdapter("select * from country",con);
da.Fill(ds);
}
ddlCountry.DataSource=ds;
ddlCountry.DataBind();
return ds;
}
private void BindGrid()
{
if (Cache["ds"] != null)
{
GridView1.DataSource = (DataSet)Cache["ds"];
GridView1.DataBind();
}
else
{
GridView1.DataSource = GetEmployee();
GridView1.DataBind();
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataSet ds = (DataSet)Cache["ds"];
DataRow dr = ds.Tables[0].Rows[e.RowIndex];
dr[1] = e.NewValues[0].ToString();
dr[2] = e.NewValues[1].ToString();
dr[3] = Convert.ToInt32(e.NewValues[2]);
dr[4] = Convert.ToInt32(e.NewValues[3]);
Cache["ds"] = ds;
GridView1.EditIndex = -1;
BindGrid();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
BindGrid();
}
protected void Button2_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlDataAdapter da = new SqlDataAdapter("select * from Employee", con);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
da.Update((DataSet)Cache["ds"]);
}
}
}

"form1" runat="server">
"GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id"
OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
"True" />
"Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
"Name" HeaderText="Name" SortExpression="Name" />
"Salary" HeaderText="Salary" SortExpression="Salary" />
"DepartmentId" HeaderText="DepartmentId" SortExpression="DepartmentId" />
"Country">
"Label1" runat="server" Text='<%# Eval("Country.Name") %>'>
"server" ID="ddlCountries" DataTextField="Name" DataValueField="ID">
"Button2" runat="server" Text="Updata Database" OnClick="Button2_Click" />

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
in asp.net webforms it's very easy to achieve, use dataset and dataAdapter
changes are made to dataset which represents in-memory changes at last when you are satisfied with all the changes , we use dataset,Update() which commits changes to database at one go.

go through my article if you have any doubt on disconnected scenario , and follow the example at the last of article
https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter
public partial class DataSetAndDataAdapter : System.Web.UI.Page
   {
       string cs = "Data Source=SACHIN-PC\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True";
       protected void Page_Load(object sender, EventArgs e)
       {
           if(!IsPostBack)
        {
            BindGrid();
           BindCountry();
            }
       }
       private DataSet GetEmployee()
       {
           DataSet ds = new DataSet();
           using (SqlConnection con = new SqlConnection(cs))
           {
               SqlDataAdapter da = new SqlDataAdapter("select * from Employee",con);
               da.Fill(ds);
           }
           Cache["ds"] = ds;
           return ds;
       }

private void BindCountry()
       {
           DataSet ds = new DataSet();
           using (SqlConnection con = new SqlConnection(cs))
           {
               SqlDataAdapter da = new SqlDataAdapter("select * from country",con);
               da.Fill(ds);
           }
           ddlCountry.DataSource=ds;
           ddlCountry.DataBind();
           return ds;
       }
       private void BindGrid()
       {
           if (Cache["ds"] != null)
           {
               GridView1.DataSource = (DataSet)Cache["ds"];
               GridView1.DataBind();
           }
           else
           {
               GridView1.DataSource = GetEmployee();
               GridView1.DataBind();

           }

       }

       protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
       {
           GridView1.EditIndex = e.NewEditIndex;
           BindGrid();
       }

       protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
       {
           DataSet ds = (DataSet)Cache["ds"];
           DataRow dr = ds.Tables[0].Rows[e.RowIndex];
           dr[1] = e.NewValues[0].ToString();
           dr[2] = e.NewValues[1].ToString();
           dr[3] = Convert.ToInt32(e.NewValues[2]);
   dr[4] = Convert.ToInt32(e.NewValues[3]);
           Cache["ds"] = ds;
           GridView1.EditIndex = -1;
           BindGrid();
       }

       protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
       {
           GridView1.EditIndex = -1;
           BindGrid();
       }

       protected void Button2_Click(object sender, EventArgs e)
       {
           using (SqlConnection con = new SqlConnection(cs))
           {
               SqlDataAdapter da = new SqlDataAdapter("select * from Employee", con);

               SqlCommandBuilder builder = new SqlCommandBuilder(da);
               da.Update((DataSet)Cache["ds"]);
           }
       }
   }


"form1" runat="server">


        "GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id"
        OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">

                "True" />
                "Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                "Name" HeaderText="Name" SortExpression="Name" />
                "Salary" HeaderText="Salary" SortExpression="Salary" />
                "DepartmentId" HeaderText="DepartmentId" SortExpression="DepartmentId" />
"Country">

                    "Label1" runat="server" Text='<%# Eval("Country.Name") %>'>


                    "server" ID="ddlCountries" DataTextField="Name" DataValueField="ID">






        "Button2" runat="server" Text="Updata Database" OnClick="Button2_Click" />