定义了
string str1,str2,str3,str4;
并赋值了,现在要循环的读出四个字符串
用
for (int i = 1; i <= 4; i++)
{
String SqlString = "insert into tb values("+ str[i]+")";
}
但是好像语法不对,就是str[i]的使用不对,求正确的写法;
string str1,str2,str3,str4;
并赋值了,现在要循环的读出四个字符串
用
for (int i = 1; i <= 4; i++)
{
String SqlString = "insert into tb values("+ str[i]+")";
}
但是好像语法不对,就是str[i]的使用不对,求正确的写法;
string[] str={"1","2","3","4"};
for (int i = 0; i < 4; i++)
{
String SqlString = "insert into tb values("+ str[i].ToString()+")";
}
string[] str = {"1","2","3","4"};
string strSql=string.Empty;
for (int i = 0; i < 4; i++)
{
strSql+= "insert into tb values("+ str[i]+");";
}
for (int i = 0; i < 4; i++)
{
String SqlString = "insert into tb values(‘"+ str[i].ToString()+"’)";
}修正一下有点崩溃的感觉
//string[] str = new String[4];
string[] str = {"1","2","3","4"};
string strSql=string.Empty;
for (int i = 0; i < 4; i++)
{
strSql+= "insert into tb values("+ str[i]+");";
//这里要顺便进行数据库的操作,不然strSql被替换
}
要实现楼主的意思, 动态创建变量, 该是要用动态编译了。
用字符串数组就可以实现你上面的要求了。string[] str;
str[0] = ; ... str[3] = ; //初始化
for (int i=0; i<4; i++)
{
String SqlString = "insert into tb values("+ str[i]+")";
}
string[] str = {"1","2","3","4"};
string strSql=string.Empty;
for (int i = 0; i < 4; i++)
{
strSql+= "insert into tb values('"+ str[i]+"');";
}
另外提醒一下LZ你的tb表中不可能只有一个字段吧,表名后面还是要加上列名的
insert into tb(列名) values("+ str[i]+")";
for (int i = 1; i <= 4; i++)
{
string str = str + i.ToString();
string SqlString = "insert into tb values('"+str+"')";
}
string[] str={str1,str2,str3,str4};
for (int i = 0; i < 4; i++)
{
String SqlString = "insert into tb values("+ str[i].ToString()+")";
//DB.exute(SqlString);
}
using System.Reflection;namespace PCHelper
{
class Str2Value
{ public string str1, str2, str3, str4; public Str2Value(string str1, string str2, string str3, string str4)
{
this.str1 = str1;
this.str2 = str2;
this.str3 = str3;
this.str4 = str4;
} public void GetValues()
{
Type type = this.GetType();
FieldInfo fieldInfo;
for (int i = 1; i <= 4; i++)
{
//String SqlString = "insert into tb values(" + str[i] + ")";
fieldInfo = type.GetField("str" + i.ToString());
Console.WriteLine("insert into tb values({0})",fieldInfo.GetValue(this).ToString());
}
}
} class Test
{
static void Main(string[] args)
{
Console.WriteLine("Being here!"); Str2Value testIt = new Str2Value("XXX1", "XXX2", "XXX3", "XXX4");
testIt.GetValues(); Console.ReadKey();
}
}
}输出:
Being here!
insert into tb values(XXX1)
insert into tb values(XXX2)
insert into tb values(XXX3)
insert into tb values(XXX4)
for (int i = 1; i <= 4; i++)
{
String SqlString = "insert into tb values("+"str"+i.ToString()+")";
}
string[] str = {"1","2","3","4"};
string strSql=string.Empty;
for (int i = 0; i < 4; i++)
{
strSql+= "insert into tb values("+ str[i]+");";
}
如果是一个字符串可以那样,比如 string a = "abcdefg";
MessageBox.Show(a[0].ToString());//a[0]=a,a[1]=b,...
string[] str=new string[]{str1,str2,str3,str4};
for (int i = 1; i <= 4; i++)
{
String SqlString = "insert into tb values("+ str[i]+")";
}
string sql = "insert into tb values('";
for (int i = 0; i < 4; i++)
{
if (i == str.Length-1)
{
sql += str[i] + "')";
}
else
{
sql += str[i] + "','";
}
}
Console.Write(sql);//insert into tb values('a','b','c','d')