string strSqlschool = "insert into tblschool(schoolid,schoolname,school_introduce,schoolkind,schooltype,schooladdress,schoolpostalcode,schooltel,schoolmaster,schoolinitiator,schoolSEC,Email,website,gradenum,classnum,teachernum,stunum) Values ('"
+ textBox1.Text + "', '"
+ textBox2.Text + "', '"
+ textBox15.Text + "','"
+ comboBox2.SelectedItem + "', '"
+ comboBox1.SelectedItem + "', '"
+ textBox5.Text + "', '"
+ textBox3.Text + "', '"
+ textBox6.Text + "', '"
+ textBox4.Text + "', '"
+ textBox7.Text + "', '"
+ textBox8.Text + "', '"
+ textBox14.Text + "', '"
+ textBox13.Text + "', '"
+ textBox9.Text + "', '"
+ textBox10.Text + "', '"
+ textBox11.Text + "', '"
+ textBox12.Text + "')";//录入学校信息
+ textBox1.Text + "', '"
+ textBox2.Text + "', '"
+ textBox15.Text + "','"
+ comboBox2.SelectedItem + "', '"
+ comboBox1.SelectedItem + "', '"
+ textBox5.Text + "', '"
+ textBox3.Text + "', '"
+ textBox6.Text + "', '"
+ textBox4.Text + "', '"
+ textBox7.Text + "', '"
+ textBox8.Text + "', '"
+ textBox14.Text + "', '"
+ textBox13.Text + "', '"
+ textBox9.Text + "', '"
+ textBox10.Text + "', '"
+ textBox11.Text + "', '"
+ textBox12.Text + "')";//录入学校信息
解决方案 »
- 分页查询SQL
- 一个sql语句中的除法得到12位小数,怎么结果错误呢?
- 求SQL COMMAND
- SQL Server2008 R2 在windows XP SP3中安装出错
- 将numeric转换为数据类型numeric时发生算术溢出错误
- 网站被攻击,请高手指点
- 帮我看看这个问题?
- 这个错误是什么意思《将 varchar 值 ',一 ,二 ' 转换为数据类型为 int 的列时发生语法错误》详见代码
- 有关access与sql的比较。
- 如何用命令行方式实现SQLserver Enterprise中的 Generate SQL Script功能?
- 请教高手!利用视图完成“示范用例”的以下应用功能:
- 菜鸟求教数据库取值问题
+ textBox1.Text + "', '"
+ textBox2.Text + "', '"
+ textBox15.Text + "','"
+ comboBox2.SelectedItem + "', '"
+ comboBox1.SelectedItem + "', '"
+ textBox5.Text + "', '"
+ textBox3.Text + "', '"
+ textBox6.Text + "', '"
+ textBox4.Text + "', '"
+ textBox7.Text + "', '"
+ textBox8.Text + "', '"
+ textBox14.Text + "', '"
+ textBox13.Text + "', '"
+ textBox9.Text + "', '"
+ textBox10.Text + "', '"
+ textBox11.Text + "', '"
+ textBox12.Text + "')";//录入学校信息