如果标题ID就如str1中的数据,直接遍历str2, string str2 = "标题1,标题2,标题3,标题4,标题5,标题6"; string[] tArray = str2.Split(','); int i=0; foreach (string s in tArray) { i++; string update="Update test set title='"+s+"' WHERE (ID="+i+")"; }
或者: string str1 = "1,2,3,4,5,6"; string str2 = "标题1,标题2,标题3,标题4,标题5,标题6"; string[] sArray = str1.Split(','); string[] tArray = str2.Split(','); for (int i = 0; i<sArray.Count(); i++) { string update = "Update test set title='" + tArray[i] + "' WHERE (ID='" + sArray[i] + "')"; }
private string[] mycode() { string str1 = "1,2,3,4,5,6"; string str2 = "标题1,标题2,标题3,标题4,标题5,标题6"; string[] sArray = str1.Split(','); string[] tArray = str2.Split(','); string[] strSqls = new string[sArray.Length]; if (sArray.Length == tArray.Length) { for (int i = 0; i < sArray.Length; i++) { strSqls[i] = string.Format("Update test set title='{0}' WHERE (ID='{1}') ", tArray[i], sArray[i]); } } return strSqls; }建议用参数化sql,防止sql注入。
Update test set title='"+str2(i)+"' WHERE (ID='" + str1(i) + "')
http://www.cnblogs.com/insus/archive/2012/09/22/2698515.html#3106240
或者写个存储过程,把数组作为参数传递
string str2 = "标题1,标题2,标题3,标题4,标题5,标题6";
string[] tArray = str2.Split(',');
int i=0;
foreach (string s in tArray)
{
i++;
string update="Update test set title='"+s+"' WHERE (ID="+i+")"; }
或者:
string str1 = "1,2,3,4,5,6";
string str2 = "标题1,标题2,标题3,标题4,标题5,标题6";
string[] sArray = str1.Split(',');
string[] tArray = str2.Split(',');
for (int i = 0; i<sArray.Count(); i++)
{
string update = "Update test set title='" + tArray[i] + "' WHERE (ID='" + sArray[i] + "')";
}
{
string str1 = "1,2,3,4,5,6";
string str2 = "标题1,标题2,标题3,标题4,标题5,标题6";
string[] sArray = str1.Split(','); string[] tArray = str2.Split(',');
string[] strSqls = new string[sArray.Length];
if (sArray.Length == tArray.Length)
{
for (int i = 0; i < sArray.Length; i++)
{
strSqls[i] = string.Format("Update test set title='{0}' WHERE (ID='{1}') ", tArray[i], sArray[i]);
}
}
return strSqls;
}建议用参数化sql,防止sql注入。