how to add new row in gridview in asp.net dynamically using c#
HTML
1.Add new row Gridview
<asp:Label ID="lblError2" runat="server" ForeColor="red"></asp:Label>
<asp:GridView runat="server" ID="GridView2" AlternatingRowStyle-BackColor="#cccccc"
ShowFooter="true" AutoGenerateColumns="false" Width="100%">
<RowStyle HorizontalAlign="Center" />
<Columns>
<asp:BoundField DataField="RowNumber" HeaderText="Serial No" HeaderStyle-Width="50px" />
<asp:TemplateField HeaderText="Name" HeaderStyle-Width="100px">
<ItemTemplate>
<asp:TextBox ID="txtName" runat="server" CssClass="form-control" MaxLength="100"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email Id" HeaderStyle-Width="100px">
<ItemTemplate>
<asp:TextBox ID="txtEmail_Id" runat="server" CssClass="form-control" MaxLength="50"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Mobile No" HeaderStyle-Width="100px">
<ItemTemplate>
<asp:TextBox ID="txtMobileNo" runat="server" CssClass="form-control" MaxLength="10"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address" HeaderStyle-Width="150px">
<ItemTemplate>
<asp:TextBox ID="txtAddress" runat="server" CssClass="form-control" MaxLength="100"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-Width="50px">
<FooterStyle HorizontalAlign="Right" />
<FooterTemplate>
<asp:Button ID="ButtonAdd" runat="server" Text="Add Row" OnClick="ButtonAdd_Click" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Button ID="btnSave" runat="server" Text="Save" CssClass="btn btn-primary btn-lg"
OnClick="btnSave_Click" />
C# Code
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStringsql"].ConnectionString.ToString());
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SetInitialRow();
BindGridView();
}
}
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("Column4", typeof(string)));
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["Column1"] = string.Empty;
dr["Column2"] = string.Empty;
dr["Column3"] = string.Empty;
dr["Column4"] = string.Empty;
dt.Rows.Add(dr);
//Store the DataTable in ViewState
ViewState["CurrentTable"] = dt;
GridView2.DataSource = dt;
GridView2.DataBind();
}
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++)
{
TextBox txtName = (TextBox)GridView2.Rows[rowIndex].Cells[1].FindControl("txtName");
TextBox txtEmail_Id = (TextBox)GridView2.Rows[rowIndex].Cells[2].FindControl("txtEmail_Id");
TextBox txtMobileNo = (TextBox)GridView2.Rows[rowIndex].Cells[3].FindControl("txtMobileNo");
TextBox txtAddress = (TextBox)GridView2.Rows[rowIndex].Cells[4].FindControl("txtAddress");
txtName.Text = dt.Rows[i]["Column1"].ToString();
txtEmail_Id.Text = dt.Rows[i]["Column2"].ToString();
txtMobileNo.Text = dt.Rows[i]["Column3"].ToString();
txtAddress.Text = dt.Rows[i]["Column4"].ToString();
rowIndex++;
}
}
}
}
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
TextBox txtName = (TextBox)GridView2.Rows[rowIndex].Cells[1].FindControl("txtName");
TextBox txtEmail_Id = (TextBox)GridView2.Rows[rowIndex].Cells[2].FindControl("txtEmail_Id");
TextBox txtMobileNo = (TextBox)GridView2.Rows[rowIndex].Cells[3].FindControl("txtMobileNo");
TextBox txtAddress = (TextBox)GridView2.Rows[rowIndex].Cells[4].FindControl("txtAddress");
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["RowNumber"] = i + 1;
dtCurrentTable.Rows[i - 1]["Column1"] = txtName.Text;
dtCurrentTable.Rows[i - 1]["Column2"] = txtEmail_Id.Text;
dtCurrentTable.Rows[i - 1]["Column3"] = txtMobileNo.Text;
dtCurrentTable.Rows[i - 1]["Column4"] = txtAddress.Text;
rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["CurrentTable"] = dtCurrentTable;
GridView2.DataSource = dtCurrentTable;
GridView2.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
//Set Previous Data on Postbacks
SetPreviousData();
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
message.Visible = false;
AddNewRowToGrid();
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
foreach (GridViewRow g1 in GridView2.Rows)
{
string Name = (g1.FindControl("txtName") as TextBox).Text;
string Email_Id = (g1.FindControl("txtEmail_Id") as TextBox).Text;
string MobileNo = (g1.FindControl("txtMobileNo") as TextBox).Text;
string Address = (g1.FindControl("txtAddress") as TextBox).Text;
con.Open();
SqlCommand cmd = new SqlCommand("insert into tbl_Insert_Gridview_Values values('" + Name + "','" + Email_Id + "','" + MobileNo + "','" + Address + "')", con);
cmd.ExecuteNonQuery();
con.Close();
}
message.Visible = true;
BindGridView();
GridView2.DataSource = null;
GridView2.DataBind();
}
catch (Exception ex)
{
message.Visible = false;
lblError.Visible = true;
lblError.Text = ex.ToString();
}
}
2.Bind Gridview
<asp:Label ID="lblMessage" runat="server" CssClass="mylabel" Font-Bold="True" ForeColor="Red"></asp:Label>
<asp:GridView ID="GridView1" Border="1" Style="border: 1px solid #ccc;" GridLines="None"
AllowPaging="false" PageSize="10" Width="100%" HeaderStyle-BackColor="#06D995"
AutoGenerateColumns="false" runat="server">
<RowStyle BackColor="#ffffff" HorizontalAlign="Center" ForeColor="#000000" />
<HeaderStyle BackColor="#1493f4" Font-Bold="True" Height="30" ForeColor="White" />
<AlternatingRowStyle BackColor="#dddddd" ForeColor="#000000" />
<Columns>
<asp:TemplateField HeaderText="Sr.No." ControlStyle-Width="10">
<ItemTemplate>
<asp:Label ID="srLabel" runat="server" Text='<%#Container.DataItemIndex+1 %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%# Eval("Name")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email_Id">
<ItemTemplate>
<asp:Label ID="lblEmail_Id" runat="server" Text='<%# Eval("Email_Id")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Mobile_No">
<ItemTemplate>
<asp:Label ID="lblMobile_No" runat="server" Text='<%# Eval("MobileNo")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<asp:Label ID="lblAddress" runat="server" Text='<%# Eval("Address")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
C# Code
private void BindGridView()
{
try
{
SqlCommand cmd = new SqlCommand("select * from tbl_Insert_Gridview_Values ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
GridView1.DataSource = dt;
if (dt.Rows.Count > 0)
{
GridView1.Visible = true;
lblMessage.Visible = false;
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
GridView1.Visible = false;
lblMessage.Visible = true;
lblMessage.Text = "No records found";
}
}
catch (Exception ex)
{
lblMessage.Visible = true;
lblMessage.Text = ex.Message.ToString();
}
}
No comments:
Post a Comment