本文介绍了如何在不回发的情况下在数据列表中动态添加行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
亲爱的所有人
如何在不回发的情况下在数据列表中动态添加行
dear all
how can add dynamically row in datalist without post back
推荐答案
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="btnsaveinfo" runat="server" Text="Save info" OnClick="btnsaveinfo_Click"
Visible="false" />
</div>
<div>
<asp:GridView ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false"
GridLines="None">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Qualification"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="Batch"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="Branch"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>
<hr />
</td>
</tr>
</table>
</ItemTemplate>
<FooterStyle HorizontalAlign="Right" />
<FooterTemplate>
<asp:Button ID="ButtonAdd" runat="server" OnClick="ButtonAdd_Click" Text="Add New Row" />
<asp:LinkButton ID="LinkButton1" Visible="false" runat="server" OnClick="LinkButton1_Click">Remove</asp:LinkButton>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
<div>
<table>
<asp:GridView ID="gvqualification" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:TemplateField HeaderText="Qualification">
<ItemTemplate>
<%# Eval("qualification")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Batch">
<ItemTemplate>
<%# Eval("batch")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Branch">
<ItemTemplate>
<%# Eval("branch")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</table>
</div>
<div>
<asp:LinkButton ID="lnkshowall" runat="server" OnClick="lnkshowall_Click" Text="Show All"></asp:LinkButton>
</div>
</form>
</body>
</html>
-----------代码文件(.cs)------------
-----------Code File (.cs)------------
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["MyConnection"].ToString());
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["PreviousTable"] = null;
SetInitialRow();
}
}
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)));
dt.Columns.Add(new DataColumn("Column5", typeof(string)));
dt.Columns.Add(new DataColumn("Column6", typeof(string)));
dr = dt.NewRow();
dr["Column1"] = string.Empty;
dr["Column2"] = string.Empty;
dr["Column3"] = string.Empty;
dr["Column4"] = "Qualification";
dr["Column5"] = "Branch";
dr["Column6"] = "Batch";
dt.Rows.Add(dr);
//dr = dt.NewRow();
//Store the DataTable in ViewState
ViewState["CurrentTable"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
private void SetPreviousDB()
{
int rowIndex = 0;
if (ViewState["PreviousTable"] != null)
{
DataTable dt = (DataTable)ViewState["PreviousTable"];
if (dt.Rows.Count > 0)
{
Response.Write(Gridview1.Rows.Count);
for (int i = 0; i < dt.Rows.Count; i++)
{
TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");
Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");
box1.Text = dt.Rows[i]["qualification"].ToString();
box2.Text = dt.Rows[i]["batch"].ToString();
box3.Text = dt.Rows[i]["branch"].ToString();
lbl4.Text = "Qualification";
lbl5.Text = "Branch";
lbl6.Text = "Batch";
rowIndex++;
}
}
}
DataTable dt1 = (DataTable)ViewState["PreviousTable"];
if (dt1.Rows.Count > 1)
{
//GridView1.FooterRow.FindControl("txtFooter1") as TextBox;
LinkButton LinkButton1 = Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
LinkButton1.Visible = true;
}
}
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 box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");
Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");
box1.Text = dt.Rows[i]["Column1"].ToString();
box2.Text = dt.Rows[i]["Column2"].ToString();
box3.Text = dt.Rows[i]["Column3"].ToString();
lbl4.Text = "Qualification";
lbl5.Text = "Branch";
lbl6.Text = "Batch";
rowIndex++;
}
}
}
DataTable dt1 = (DataTable)ViewState["CurrentTable"];
if (dt1.Rows.Count > 1)
{
//GridView1.FooterRow.FindControl("txtFooter1") as TextBox;
LinkButton LinkButton1= Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
LinkButton1.Visible = true;
}
}
private void AddNewRowToGrid()
{
int rowIndex = 0;
if (ViewState["PreviousTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["PreviousTable"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
//extract the TextBox values
TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");
Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");
drCurrentRow = dtCurrentTable.NewRow();
dtCurrentTable.Rows[i - 1]["qualification"] = box1.Text;
dtCurrentTable.Rows[i - 1]["batch"] = box2.Text;
dtCurrentTable.Rows[i - 1]["branch"] = box3.Text;
dtCurrentTable.Rows[i - 1]["qualification1"] = "Qualification";
dtCurrentTable.Rows[i - 1]["batch1"] = "Branch";
dtCurrentTable.Rows[i - 1]["branch1"] = "Batch";
rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["PreviousTable"] = dtCurrentTable;
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
SetPreviousDB();
}
}
else 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 box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");
Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");
drCurrentRow = dtCurrentTable.NewRow();
dtCurrentTable.Rows[i - 1]["Column1"] = box1.Text;
dtCurrentTable.Rows[i - 1]["Column2"] = box2.Text;
dtCurrentTable.Rows[i - 1]["Column3"] = box3.Text;
dtCurrentTable.Rows[i - 1]["Column4"] = "Qualification";
dtCurrentTable.Rows[i - 1]["Column5"] = "Branch";
dtCurrentTable.Rows[i - 1]["Column6"] = "Batch";
rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["CurrentTable"] = dtCurrentTable;
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
//Set Previous Data on Postbacks
SetPreviousData();
}
}
else
{
Response.Write("ViewState is null");
}
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
AddNewRowToGrid();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
int rowID = gvRow.RowIndex + 1;
if (ViewState["PreviousTable"]!=null)
{
DataTable dt = (DataTable)ViewState["PreviousTable"];
if (dt.Rows.Count > 1)
{
if (gvRow.RowIndex < dt.Rows.Count - 1)
{
//Remove the Selected Row data
dt.Rows.Remove(dt.Rows[dt.Rows.Count-1]);
}
}
ViewState["PreviousTable"] = dt;
//Re bind the GridView for the updated data
Gridview1.DataSource = dt;
Gridview1.DataBind();
int rowIndex = 0;
foreach (GridViewRow row in Gridview1.Rows)
{
TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;
TextBox1.Text = dt.Rows[rowIndex]["qualification"].ToString();
TextBox2.Text = dt.Rows[rowIndex]["batch"].ToString();
TextBox3.Text = dt.Rows[rowIndex]["branch"].ToString();
rowIndex++;
}
if (dt.Rows.Count > 1)
{
LinkButton LinkButton1 = Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
LinkButton1.Visible = true;
}
}
else if (ViewState["CurrentTable"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 1)
{
if (gvRow.RowIndex < dt.Rows.Count - 1)
{
//Remove the Selected Row data
dt.Rows.Remove(dt.Rows[dt.Rows.Count-1]);
}
}
ViewState["CurrentTable"] = dt;
//Re bind the GridView for the updated data
Gridview1.DataSource = dt;
Gridview1.DataBind();
int rowIndex = 0;
foreach (GridViewRow row in Gridview1.Rows)
{
TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;
TextBox1.Text = dt.Rows[rowIndex]["Column1"].ToString();
TextBox2.Text = dt.Rows[rowIndex]["Column2"].ToString();
TextBox3.Text = dt.Rows[rowIndex]["Column3"].ToString();
rowIndex++;
}
if (dt.Rows.Count > 1)
{
LinkButton LinkButton1 = Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
LinkButton1.Visible = true;
}
}
}
protected void btnsaveinfo_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in Gridview1.Rows)
{
TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into qualification values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "') ";
cmd.ExecuteNonQuery();
con.Close();
}
BindGrid();
}
private void BindGrid()
{
DataTable dt = new DataTable();
con.Open();
cmd.Connection = con; ;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from qualification";
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
gvqualification.DataSource = dt;
gvqualification.DataBind();
}
else
{
gvqualification.DataSource = null;
gvqualification.DataBind();
}
con.Close();
}
protected void lnkshowall_Click(object sender, EventArgs e)
{
int rowIndex = 0;
DataTable dt = new DataTable();
con.Open();
cmd.Connection = con; ;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select qualification,batch,branch,qualification1,batch1,branch1 from qualification";
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Gridview1.DataSource = dt;
Gridview1.DataBind();
foreach (GridViewRow row in Gridview1.Rows)
{
TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;
TextBox1.Text = dt.Rows[rowIndex]["qualification"].ToString();
TextBox2.Text = dt.Rows[rowIndex]["batch"].ToString();
TextBox3.Text = dt.Rows[rowIndex]["branch"].ToString();
rowIndex++;
}
ViewState["PreviousTable"] = dt;
}
else
{
Gridview1.DataSource = null;
Gridview1.DataBind();
}
con.Close();
}
-----------------为此程序创建表-----------------------
-----------------Create Table for this program-----------------------
CREATE TABLE qualification
(
id int IDENTITY(1,1) NOT NULL,
qualification varchar(100) ,
batch [varchar](50) ,
branch [varchar](50) ,
qualification1 [varchar](50) ,
batch1 [varchar](50) ,
branch1 [varchar](50)
)
这篇关于如何在不回发的情况下在数据列表中动态添加行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！