跪求 asp.net 批量添加学生账号和密码的页面程序和后台程序代码。。。
答案:2 悬赏:0
解决时间 2021-02-03 04:36
- 提问者网友:很好的背叛
- 2021-02-02 23:08
跪求 asp.net 批量添加学生账号和密码的页面程序和后台程序代码。。。
最佳答案
- 二级知识专家网友:零负荷的放任
- 2021-02-02 23:17
前台代码:
<div>
用户名:
<asp:TextBox ID="txtUserName" runat="server" Height="24px" Width="600px"></asp:TextBox>
<br />
多个密码请用
逗号","分开<br />
<br />
初始密码:
<asp:TextBox ID="txtPassword" runat="server" Height="24px" Width="100"></asp:TextBox>
<br />
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
</div>
后台代码:
protected void Button1_Click(object sender, EventArgs e)
{
string[] strUser = this.txtUserName.Text.Split((new char[] { ',' })[0]);//取得用户名列表,并去掉,号
for (int i = 0; i < strUser.Length; i++)
{
//构造sql语句
string sqlStr = "intsert into user(username,password) values('" + strUser[i].ToString() + "','" + this.txtPassword.Text + "')";
try
{
using (SqlConnection conn = new SqlConnection("connectionString"))//connectionString为你的数据库链接字符串
{
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
<div>
用户名:
<asp:TextBox ID="txtUserName" runat="server" Height="24px" Width="600px"></asp:TextBox>
<br />
多个密码请用
逗号","分开<br />
<br />
初始密码:
<asp:TextBox ID="txtPassword" runat="server" Height="24px" Width="100"></asp:TextBox>
<br />
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
</div>
后台代码:
protected void Button1_Click(object sender, EventArgs e)
{
string[] strUser = this.txtUserName.Text.Split((new char[] { ',' })[0]);//取得用户名列表,并去掉,号
for (int i = 0; i < strUser.Length; i++)
{
//构造sql语句
string sqlStr = "intsert into user(username,password) values('" + strUser[i].ToString() + "','" + this.txtPassword.Text + "')";
try
{
using (SqlConnection conn = new SqlConnection("connectionString"))//connectionString为你的数据库链接字符串
{
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
全部回答
- 1楼网友:颜值超标
- 2021-02-03 00:35
你好!
怎么个批量发
打字不易,采纳哦!
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯