大家帮我看看,为什么插入不了记录

[ccaakkee]

SqlDataSource5.InsertParameters.Clear()
strsql = "insert into unitsInfo(unitsID,unitsName,unitsAdd,unitsAdd,county,owner,linkman,tel,fax,characters,industry,state) values('" & strID & "','" & Me.txtDWname.Text & "','" & Me.txtDWAddress.Text & "','" & Me.ddlQu.Text & "','" & Me.txtFaRen.Text & "','" & Me.txtLianXiRen.Text & "',,'" & Me.txtTel.Text & "','" & Me.txtFax.Text & "','" & Me.ddlXingZhi.Text & "','" & Me.ddlHangYe.Text & "',1)"
SqlDataSource5.InsertCommand = strsql

执行这段代码无效果,也不报错,就是插入不进去

[心晴Sunheart]

把&替换成+
SqlDataSource5.InsertParameters.Clear()
strsql = "insert into unitsInfo(unitsID,unitsName,unitsAdd,unitsAdd,county,owner,linkman,tel,fax,characters,industry,state) values('" + strID + "','" + Me.txtDWname.Text + "','" + Me.txtDWAddress.Text + "','" + Me.ddlQu.Text + "','" + Me.txtFaRen.Text + "','" + Me.txtLianXiRen.Text + "',,'" + Me.txtTel.Text + "','" + Me.txtFax.Text + "','" + Me.ddlXingZhi.Text + "','" + Me.ddlHangYe.Text + "',1)"
SqlDataSource5.InsertCommand = strsql

[ccaakkee]

还是不行啊,怎么能看到这个SQL语句在执行得时候出错信息

[shilei831115]

这一段代码不是还没有执行吗 仅仅是声明了一下而已阿


要想看到出错信息 要到执行时 把SQL 语句整体考贝出来 看看

[ccaakkee]

怎么让SqlDataSource5.InsertCommand 执行,在下是新手,多多帮助,谢谢

[ccaakkee]

会了,原来是用SqlDataSource5.Insert()
多谢提醒