我现在页面a.aspx上有两组数据,代码如下<input type="text" id="itshow" runat="server" />
<input type="text" id="answerre" runat="server" value="B|A|C|A|D|B" />
<input type="text" id="answerno" runat="server" value="1|5|18|2|78|9" />上面的两个输入框中的value值是一一对应的也就是说B - 1
A - 5
C - 18
A - 2
D - 78
B - 9
我现在有一个数据库的表 table1,结构是
id answerre answerno itshow我想把上面获取到的值对应插到该数据库中,请问该怎么写呢?string itshow = Request.Params["itshow"]; //比如这里获取到的是 my最后变成
id answerre answerno itshow
1 B 1 my
1 A 5 my
1 C 18 my
1 A 2 my
1 D 78 my
1 B 9 my string answerrelist = Request.Params["answerre"];
string[] conArr = Regex.Split(answerrelist, ",");
int pageCount = conArr.Length; for (int p = 0; p < pageCount; p++)
{
string answerre = conArr[p];
}string answernolist = Request.Params["answerno"];
string[] conArr = Regex.Split(answernolist, ",");
int pageCount = conArr.Length; for (int p = 0; p < pageCount; p++)
{
string answerno= conArr[p];
}请问这个该怎么写呢?谢谢
<input type="text" id="answerre" runat="server" value="B|A|C|A|D|B" />
<input type="text" id="answerno" runat="server" value="1|5|18|2|78|9" />上面的两个输入框中的value值是一一对应的也就是说B - 1
A - 5
C - 18
A - 2
D - 78
B - 9
我现在有一个数据库的表 table1,结构是
id answerre answerno itshow我想把上面获取到的值对应插到该数据库中,请问该怎么写呢?string itshow = Request.Params["itshow"]; //比如这里获取到的是 my最后变成
id answerre answerno itshow
1 B 1 my
1 A 5 my
1 C 18 my
1 A 2 my
1 D 78 my
1 B 9 my string answerrelist = Request.Params["answerre"];
string[] conArr = Regex.Split(answerrelist, ",");
int pageCount = conArr.Length; for (int p = 0; p < pageCount; p++)
{
string answerre = conArr[p];
}string answernolist = Request.Params["answerno"];
string[] conArr = Regex.Split(answernolist, ",");
int pageCount = conArr.Length; for (int p = 0; p < pageCount; p++)
{
string answerno= conArr[p];
}请问这个该怎么写呢?谢谢
解决方案 »
- 【求证,求解脱】取变量,对象的名称,不知道可否实现
- 关于ADO.net参数化模糊查询的问题 代码如下:
- 关于c#中指针 和引用
- 数据放松格式说明书3
- c#调用c++的dll文件,提示:尝试读取或写入受保护的内存。这通常指示其他内存已损坏。急!!!
- WinForm当中,picturebox加载图片如何优化?
- event和委托!!!!!!!!!!!!!!!!!!!
- C#如何使用Excel中的SavaAs????
- 如何获取Excel单元格 下一列格子的标志,比如“E1”下一列”E2“
- 怎么通过ole调用excel把一个excel文件另存为text文件!!!
- 回车提交表单没有效果
- ListView右键菜单的问题!!!
{
insert into table(answerre ,answerno ,itshow )
values (conArr[i],conArr [i],'my')
}
楼主是这个意思吗?
我想数据库中结果是id answerre answerno itshow
1 B 1 my
1 A 5 my
1 C 18 my
1 A 2 my
1 D 78 my
1 B 9 my
string[] name1 = this.answerno.Value.Split('|');
string sql = "insert into table1 (id,answerre,answerno,itshow) values({0},{1},{2},{3})";
string newsql1 = string.Empty;
for (int i = 0; i < name.Length; i++)
{
newsql1 = string.Format(sql, 1, name[i], name1[i], this.itshow.Value);
//插入数据库
}
string[] name1 = this.answerno.Value.Split('|');
string sql = "insert into table1 (id,answerre,answerno,itshow) values({0},{1},{2},{3})";
string newsql1 = string.Empty;
for (int i = 0; i < name.Length; i++)
{
newsql1 = string.Format(sql, 1, name[i], name1[i], this.itshow.Value);
using (SQLiteConnection cn = new SQLiteConnection(datasouce))
{
cn.Open(); using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = cn;
cmd.CommandText = newsql1;
cmd.ExecuteNonQuery(); } cn.Close();
}
} 但提示出错了
string[] arr2= this.answerno.Value.Split(new char[]{'|'},StringSplitOptions.RemoveEmptyEntries);
for(int i=0;<arr1.Length;i++)
{
//插入数据
}
string[] arr2= this.answerno.Value.Split(new char[]{'|'},StringSplitOptions.RemoveEmptyEntries);
for(int i=0; <arr1.Length;i++)
{
//插入数据
}