Dim cmdtxt As String
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values (" & "'" & txb1.Text & "'" & "," & "'" & txb2.Text & "'" & "," & "'" & txb4.Text & "'" & "," & "'" & txb3.Text & "'" & "," & "'" & txb5.Text & "'" & ")"有什么优化方法没,主要是減少 & 和 ""
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values (" & "'" & txb1.Text & "'" & "," & "'" & txb2.Text & "'" & "," & "'" & txb4.Text & "'" & "," & "'" & txb3.Text & "'" & "," & "'" & txb5.Text & "'" & ")"有什么优化方法没,主要是減少 & 和 ""
解决方案 »
- 请问高手:修复数据库的问题
- 菜鸟提问,高手请答!--一个简单的查询:
- 着急sql问题 在线等 大虾没门帮帮忙
- 修改employee表中的字段salary数据类型为numeric(9,2)??
- zjcxc(邹建) 等高手请帮忙!!!导出表结构的语句,非常有用,但是现在有点缺陷!
- 求条语句!
- 为什么从SQL6.5升级到2000的数据库补支持下面这个语句
- 邹老大,请帮忙呀.
- 谢谢yang_sun,mshy! but how to get weblogic jdbc for sql server?
- 登录远程服务器需要先输入用户名和密码然后运行程序
- 这个触发器怎么写?(table1只要增加记录就同步增加到
- 只用c#连接sql2005,需启动什么服务?
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values ('" & txb1.Text & "','" & txb2.Text & "','" & txb4.Text & "','" & txb3.Text & "','" & txb5.Text & "')"
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values ('" & txb1.Text & "','" & txb2.Text & "','" & txb4.Text & "','" & txb3.Text & "','" & txb5.Text & "')"
Dim cmdtxt As String
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values (" & "'" & txb1.Text & "'" & "," & "'" & txb2.Text & "'" & "," & "'" & txb4.Text & "'" & "," & "'" & txb3.Text & "'" & "," & "'" & txb5.Text & "'" & ")" removed some "&"
Dim cmdtxt As String
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values ('" & txb1.Text & "','" & txb2.Text & "','" & txb4.Text & "','" & txb3.Text & "','" & txb5.Text & "')" format with _
Dim cmdtxt As String
cmdtxt = "insert into fenghuashuju (f_name,f_sex,f_minzhu,f_chusheng,f_shenfz) values ('" _
& txb1.Text & "','" _
& txb2.Text & "','" _
& txb4.Text & "','" _
& txb3.Text & "','" _
& txb5.Text & "')"