c# mysql 插入语句_C# sql语句 插入数据库

stringsql1="";for(inti=0;i<=dataGridView1.ColumnCount-1;i++){sql1=sql1+'dataGridView1.CurrentRow.Cells[i].Value'+",";}sql1=sql1.Substring(0,sql1.Length-1);sql1="("+sql1+"...

string sql1=""; for (int i = 0; i <= dataGridView1.ColumnCount-1; i++) { sql1 = sql1 +'dataGridView1.CurrentRow.Cells[i].Value' + ","; } sql1 = sql1.Substring(0,sql1.Length - 1); sql1 = "(" + sql1 + ")"; label1.Text = sql1; string cmdtxt1 = "insert into substationline values '" + sql1 + "'";从datagridview中读取当前行的数据插入数据库(当前行是新增加的新数据行)，插入数据库的语句出错。请问要怎么改？

string sql1="";

for (int i = 0; i <= dataGridView1.ColumnCount-1; i++)

{

sql1 = sql1 +'dataGridView1.CurrentRow.Cells[i].Value' + ",";

}

sql1 = sql1.Substring(0,sql1.Length - 1);

sql1 = "(" + sql1 + ")";

label1.Text = sql1;

string cmdtxt1 = "insert into substationline values '" + sql1 + "'";

从datagridview中读取当前行的数据插入数据库(当前行是新增加的新数据行)，插入数据库的语句出错。请问要怎么改？

展开