1.换行:
string SQL=@"INSERT INTO NetIDS_Eventbase(EVENTTYPEID,EVENTNAME,INITIALNAME)
VALUES ({0},'{1}',{2}')"; //还可以更长,自然换行,不要写转义符。
System.Data.OleDb.OleDbCommand da2=new System.Data.OleDb.OleDbCommand(
string.Format(SQL,ds1.Tables[0].Rows[j].ItemArray.GetValue(0),
ds1.Tables[0].Rows[j].ItemArray.GetValue(1),
ds1.Tables[0].Rows[j].ItemArray.GetValue(2)),
oledbConn);
2.
System.Data.OleDb.OleDbCommand da2 = new System.Data.OleDb.OleDbCommand(
"INSERT INTO NetIDS_Eventbase(EVENTTYPEID,EVENTNAME,INITIALNAME) " +
"VALUES (" + ds1.Tables[0].Rows[j].ItemArray.GetValue(0) +
",'" + ds1.Tables[0].Rows[j].ItemArray.GetValue(1) +
"','" + ds1.Tables[0].Rows[j].ItemArray.GetValue(2)+
"')", oledbConn);
"INSERT INTO NetIDS_Eventbase(EVENTTYPEID,EVENTNAME,INITIALNAME) " +
"VALUES (" + ds1.Tables[0].Rows[j].ItemArray.GetValue(0) +
",'" + ds1.Tables[0].Rows[j].ItemArray.GetValue(1) +
"','" + ds1.Tables[0].Rows[j].ItemArray.GetValue(2)+
"')", oledbConn);