最后的分，请教一个同时插入数据问题

[Been_H2]

我现在页面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];
}

请问这个该怎么写呢？谢谢

[Been_H2]

谁能指导下，正确的写法是？多谢

[wuyq11]

string[] arr1= this.answerre.Value.Split(new char[]{'|'},StringSplitOptions.RemoveEmptyEntries);
string[] arr2= this.answerno.Value.Split(new char[]{'|'},StringSplitOptions.RemoveEmptyEntries);
for(int i=0;<arr1.Length;i++)
{
//插入数据
}

[tan124]

string[] arr1= this.answerre.Value.Split(new char[]{'|'},StringSplitOptions.RemoveEmptyEntries);
string[] arr2= this.answerno.Value.Split(new char[]{'|'},StringSplitOptions.RemoveEmptyEntries);
for(int i=0; <arr1.Length;i++)
{
//插入数据
}

[hongch1987]

UP

[Been_H2]

现在出错的是插入数据的部分
插入数据错误了

[xxyping]

其实你这些数据都是一一对应的，你只要在放数据的时候找到对应的就行了，你在保存数据的时候可以用字典保存，将数据与key对应起来，然后插入就好！不晓得你可是这个意思！

[Been_H2]

能具体说清楚点吗？

[wangping06]

for(int i=0;i<conArr.Length;i++)
{
insert into table(answerre  ,answerno  ,itshow )
values (conArr[i],conArr [i],'my')
}

楼主是这个意思吗？

[Been_H2]

可能我没表达清楚，我想最后数据都一一对应的插入到数据库中，请问这个该怎么写呢？
我想数据库中结果是

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

[feifei313116]

string[] name = this.answerre.Value.Split('|');
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);
//插入数据库

}

[Been_H2]

string[] name = this.answerre.Value.Split('|');
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();
}

}

但提示出错了