Dynamically Adding and Deleting Rows in GridView and Saving

Debasis Mohapatra

Hi,

After click the Addnew button in Gridview the data is adding . i have a drop down box after that when i have enter the Dynamically Adding the rows the data is adding now the question is how to save the data in after click the save button.

My code

private void SetPreviousData()
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DropDownList box1 = (DropDownList)Gridview1.Rows[rowIndex].Cells[1].FindControl("ddlhead");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtamount");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremark");
box1.Text = dt.Rows[i]["Column1"].ToString();
box2.Text = dt.Rows[i]["Column2"].ToString();
box3.Text = dt.Rows[i]["Column3"].ToString();
rowIndex++;
}
}
}
protected void Gridview1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void btnsave_Click(object sender, EventArgs e)
{
string sql = string.Empty;
try
{
if (string.IsNullOrEmpty(hdnid.Value.ToString()))
sql = "insert into payment (vessel_id,head,amount,remark) values ('" + ddlvessal.SelectedValue.ToString() + "',)";
int k = General.ExecuteQuery(sql);
}
catch (Exception ex)
{
// throw;
}
finally
{ }
}
}
}
private void SetInitialRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
dt.Columns.Add(new DataColumn("Column1", typeof(string)));
dt.Columns.Add(new DataColumn("Column2", typeof(string)));
dt.Columns.Add(new DataColumn("Column3", typeof(string)));
dt.Columns.Add(new DataColumn("Action", typeof(string)));
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["Column1"] = string.Empty;
dr["Column2"] = string.Empty;
dr["Column3"] = string.Empty;
dt.Rows.Add(dr);
//dr = dt.NewRow();
//Store the DataTable in ViewState
ViewState["CurrentTable"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
private void AddNewRowToGrid()
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
//extract the TextBox values
DropDownList box1 = (DropDownList)Gridview1.Rows[rowIndex].Cells[1].FindControl("ddlhead");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtamount");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("txtremark");
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["RowNumber"] = i + 1;
dtCurrentTable.Rows[i - 1]["Column1"] = box1.Text;
dtCurrentTable.Rows[i - 1]["Column2"] = box2.Text;
dtCurrentTable.Rows[i - 1]["Column3"] = box3.Text;
rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["CurrentTable"] = dtCurrentTable;
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
//Set Previous Data on Postbacks
SetPreviousData();
}
protected void Gridview1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void btnsave_Click(object sender, EventArgs e)
{
string sql = string.Empty;
try
{
if (string.IsNullOrEmpty(hdnid.Value.ToString()))
sql = "insert into payment (vessel_id,head,amount,remark) values ('" + ddlvessal.SelectedValue.ToString() + "',)";
int k = General.ExecuteQuery(sql);
}
catch (Exception ex)
{
// throw;
}
finally
{ }
}
}
}

Design

class="body">
"Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false" OnSelectedIndexChanged="Gridview1_SelectedIndexChanged" style="border-collapse:collapse;" class="table table-stripped table-bordered">
"RowNumber" HeaderText="SL No" />
" Head">
"ddlhead" class="form-control show-tick" data-live-search="true" runat="server" DataSourceId="MyDataSource" DataTextField="name" DataValueField="name">
"hdnid" runat="server" />
"Amount">
"txtamount" runat="server">
"Remark">
"txtremark" runat="server">
"Action">
class="btn-group">
"lnkaddnamedelete" data-toggle="tooltip" CommandArgument="Delete"
OnClientClick="javascript:return confirm('Are you sure you want to delete this ?');"
CausesValidation="false" data-placement="bottom" title="Delete"
CssClass="fa fa-close" runat="server" onclick="lnkaddnamedelete_Click">

"Right" />

"ButtonAdd" class="btn btn-success" CausesValidation="false" OnClick="ButtonAdd_Click" runat="server" Text="Add New" >

Please how to save the all the data in the database after click on save

string sql = string.Empty;
try
{
if (string.IsNullOrEmpty(hdnid.Value.ToString()))
sql = "insert into payment (vessel_id,head,amount,remark) values ('" + ddlvessal.SelectedValue.ToString() + "',)";
int k = General.ExecuteQuery(sql);
}
catch (Exception ex)
{
// throw;
}
finally
{ }

3 Replies

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

Jignesh Kumar6y ago
Hi,

Please find below links which will help you to resolve your query,

https://www.c-sharpcorner.com/UploadFile/8c19e8/dynamically-adding-and-deleting-rows-in-gridview-and-saving/
https://www.aspforums.net/Threads/100433/Dynamically-add-and-delete-rows-from-ASPNet-GridView-on-Button-click-using-C/
Debasis Mohapatra6y ago
I would like to say my connection is General is the class. So how to do
using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
public class General
{
~General()
{
}
public static int ExecuteMaltipleQuery(string[] Query)
{
return Referance.GetAbstract().ExeDataByMalQuery(Query);
}
public static string[] ExecuteProcedure(string procName, ArrayList prmInformation)
{
return Referance.GetAbstract().procedure(procName, prmInformation);
}
public static int ExecuteQuery(string Query)
{
return Referance.GetAbstract().ExeDataByQuery(Query);
}
public static DataSet GetDataByProcedure_WithParameter(string procName, ArrayList prmInformation)
{
return Referance.GetAbstract().GetDataByProcedure_WithParameter(procName, prmInformation);
}
public static SqlDataReader GetDatareder_Procedure(string procedureName)
{
return Referance.GetAbstract().GetDataReaderByProcedure(procedureName);
}
public static SqlDataReader GetDatareder_Query(string Query)
{
return Referance.GetAbstract().GetDataReader(Query);
}
public static DataSet GetDataset_Procedure(string procedureName)
{
return Referance.GetAbstract().GetDataByProcedure(procedureName);
}
public static DataSet GetDataset_Query(string Query)
{
return Referance.GetAbstract().GetData(Query);
}
public static DataTable GetDatatable_Query(string Query)
{
return Referance.GetAbstract().GetDatatable(Query);
}
public static object GetExecuteScalar_Procedure(string procedureName)
{
return Referance.GetAbstract().ExeScalarByProcedure(procedureName);
}
public static object GetExecuteScalar_Query(string Query)
{
return Referance.GetAbstract().ExeScalarByQuery(Query);
}
public static bool GetExecute_Input_only(string procName, ArrayList prmInformation)
{
return Referance.GetAbstract().Execute_Input_by_proc_only(procName,prmInformation);
}
}
## for the connection
SqlCommand insertCommand = new SqlCommand( sql, connection);

what should i pass for the connection.
Ashutosh Gupta6y ago
var sql = insert into payment (vessel_id,head,amount,remark) values (@0, @1, @2, @3)

SqlCommand insertCommand = new SqlCommand( sql, connection);

insertCommand.Parameters.Add(new SqlParameter("0", ddlvessal.SelectedValue.ToString()));

insertCommand.Parameters.Add(new SqlParameter("1", selectedvalye from control);

insertCommand.Parameters.Add(new SqlParameter("2", selectedvalye from control);

insertCommand.Parameters.Add(new SqlParameter("3", selectedvalye from control);

insertCommand.ExecuteNonQuery();