insert into 语句怎么用代码代替数据库的字段名呢~~谢谢
如图：
我想用insert into 语句往数据库中插入一行记录~~，希望能用第二种方法，就是字段名用COMBOBOX的文本内容，请问书写格式对吗。第一种可以正常插入数据，第二种不能，谢谢~~~~
Dim sql3 As String = "insert into 单价 (白玫瑰,红玫瑰)values ('" + TextBox4.Text + "','" + TextBox7.Text + "')"
Dim sql3 As String = "insert into 单价 ('" + ComboBox2.Text + "','" + ComboBox1.Text + "')values ('" + TextBox4.Text + "','" + TextBox7.Text + "')" insert?into 数据 数据库 SQL ComboBox
[解决办法]
Dim sql3 As String = "insert into 单价 (白玫瑰,红玫瑰)values ('" + TextBox4.Text.Replace("'","''") + "','" + TextBox7.Text.Replace("'","''") + "')"
Dim sql3 As String = "insert into 单价 ([" + ComboBox2.Text.Replace("]","[]]").Replace("]","[]]") + "],[" + ComboBox1.Text.Replace("]","[]]").Replace("]","[]]") + "])values ('" + TextBox4.Text.Replace("'","''") + "','" + TextBox7.Text.Replace("'","''") + "')"
[解决办法]
Dim sql3 As String = "insert into 单价 (" + ComboBox2.Text + "," + ComboBox1.Text + ")values ('" + TextBox4.Text + "','" + TextBox7.Text + "')"
试试
[解决办法]
多跟踪调试几次，肯定可以的。
顺便问一句：
花店也买爆米花吗？
[解决办法]
是的,可以的...首先要生成表字段...
