string name1 = name.Text;
string score = textBox1.Text;
string adress = textBox2.Text;
//string sql = string.Format("insert into student values('{0}','{1}','{2}')", name1, score, adress);
// string sql="insert into student values('小张','2','3')";
string sql=string.Format ("insert into student values('{0}','{1}','{2}')",name1 ,score ,adress );
SQL.Text = sql;
//sql = "insert into student values(‘小明',‘69',‘赤壁’)";
SqlCommand cmd = new SqlCommand(sql, conn);
string score = textBox1.Text;
string adress = textBox2.Text;
//string sql = string.Format("insert into student values('{0}','{1}','{2}')", name1, score, adress);
// string sql="insert into student values('小张','2','3')";
string sql=string.Format ("insert into student values('{0}','{1}','{2}')",name1 ,score ,adress );
SQL.Text = sql;
//sql = "insert into student values(‘小明',‘69',‘赤壁’)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
问题点:SQLServel 中的引号与VS2010 中,电脑输入法的引号不一至所至成了SQL语法错误。
1号处的引与与2号处的引号有一点点区别,1号区是一个斜的,而2号地方的引号是一个坚的,请仔细看,这小BUg调了半天,才发现,开始还以是String的Unicode不兼容