时间:2021-07-01 10:21:17 帮助过:43人阅读
- <br><%@ Page Language="C#" AutoEventWireup="true" CodeFile="BatchAdd.aspx.cs" Inherits="BatchAdd" %> <br><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <br><html xmlns="http://www.w3.org/1999/xhtml"> <br><head runat="server"> <br><title></title> <br></head> <br><body> <br><form id="form1" runat="server" action="BatchAdd.aspx"> <br><div> <br><table id="tblData"> <br><tr> <br><td> <br>ID <br></td> <br><td> <br>Title <br></td> <br><td> <br>SmallClassName <br></td> <br><td> <br>Author <br></td> <br><td> <br>UpdateTime <br></td> <br></tr> <br><tr id="tRow0"> <br><td> <br><input type="text" id="txtID" name="txtID0" /> <br></td> <br><td> <br><input type="text" id="txtTitle" name="txtTitle0" /> <br></td> <br><td> <br><input type="text" id="txtSmallClassName" name="txtSmallClassName0" /> <br></td> <br><td> <br><input type="text" id="txtAuthor" name="txtAuthor0" /> <br></td> <br><td> <br><input type="text" id="txtUpdateTime" name="txtUpdateTime0" /> <br></td> <br></tr> <br></table> <br><input type="hidden" id="hidNum" name="hidNum" value="0" /> <br><input type="button" id="btnAdd" value="Add" /> <br><input type="submit" id="btnSave" value="Save" /> <br></div> <br></form> <br></body> <br></html> <br><script src="js/jquery-1.4.2.min.js" type="text/javascript"></script> <br><script language="javascript" type="text/javascript"> <br>$(function() { <br>$("#btnAdd").click(function() { <br>var num = $("#hidNum").val(); // <br>num = parseInt(num); <br>num++; //点击自加 <br>$("#hidNum").val(num); //重新赋值 <br>$("#tRow0").clone(true).attr("id", "tRow" + num).appendTo("#tblData"); //clone tr 并重新给定ID,装到table <br>$("#tRow" + num + " td").each(function() {//循环克隆的新行里面的td <br>$(this).find("input[type='text']").val(""); //清空克隆行的数据 <br>//修改相关属性 <br>$(this).find("input[name='txtID0']").attr("id", "txtID" + num).attr("name", "txtID" + num); <br>$(this).find("input[name='txtTitle0']").attr("id", "txtTitle" + num).attr("name", "txtTitle" + num); <br>$(this).find("input[name='txtSmallClassName0']").attr("id", "txtSmallClassName" + num).attr("name", "txtSmallClassName" + num); <br>$(this).find("input[name='txtAuthor0']").attr("id", "txtAuthor" + num).attr("name", "txtAuthor" + num); <br>$(this).find("input[name='txtUpdateTime0']").attr("id", "txtUpdateTime" + num).attr("name", "txtUpdateTime" + num); <br>}); <br>}); <br>}); <br></script> <br> <br>cs页面代码: <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>using System; <br>using System.Collections.Generic; <br>using System.Linq; <br>using System.Web; <br>using System.Web.UI; <br>using System.Web.UI.WebControls; <br>public partial class BatchAdd : System.Web.UI.Page <br>{ <br>protected void Page_Load(object sender, EventArgs e) <br>{ <br>if (!string.IsNullOrEmpty(Request["hidNum"])) <br>{ <br>int num = Convert.ToInt32(Request["hidNum"]); <br>string id, title, smallClassName, author, updatetime; <br>int rs = 0; <br>if (num > 0) <br>{ <br>for (int i = 0; i <= num; i++) <br>{ <br>id = Request["txtID" + i]; <br>title = Request["txtTitle" + i]; <br>smallClassName = Request["txtSmallClassName" + i]; <br>author = Request["txtAuthor" + i]; <br>updatetime = Request["txtUpdateTime" + i]; <br>string sql = "insert into News(Title,SmallClassName,Author,Updatetime) values('" + title + "','" + smallClassName + "','" + author + "','" + updatetime + "')"; <br>DBHelper.connString = "server=.;database=test;uid=sa;pwd=123"; <br>if (DBHelper.ExecuteSql(sql) > 0) <br>rs++; <br>} <br>Response.Redirect("Manager.aspx?rs=" + rs); <br>} <br>} <br>} <br>} <br></li><li> </li><li> </li></ol></pre>