<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
求:VB8.0的TextBox内容实现Update到数据库写法
Dim queryString As String = Update NP Set Ps= admin
Dim cmd As New OleDb.OleDbCommand(queryString, conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
其中第一句实现的是把“admin”字符串Update到数据库Ps字段的SQL语法,现在想实现把一个文本编辑框TextBox的内容Update到数据库该怎么写呢?Dim queryString As String = Update NP Set Ps= ?
关于数据库的创建、连接、打开关闭都会了,就是写还不太会,有哪位高手能指点一二啊?
__________________________________________________________________________
先取得TextBox内容
dim strUpText as string
strUpText =Textbox1.text
更新SQL语句
Dim queryString As String = Update NP Set Ps= & strUpText &
__________________________________________________________________________
问题已经解决,感谢renren00
__________________________________________________________________________
求:VB8.0的TextBox内容实现Update到数据库写法
Dim queryString As String = Update NP Set Ps= admin
Dim cmd As New OleDb.OleDbCommand(queryString, conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
其中第一句实现的是把“admin”字符串Update到数据库Ps字段的SQL语法,现在想实现把一个文本编辑框TextBox的内容Update到数据库该怎么写呢?Dim queryString As String = Update NP Set Ps= ?
关于数据库的创建、连接、打开关闭都会了,就是写还不太会,有哪位高手能指点一二啊?
__________________________________________________________________________
先取得TextBox内容
dim strUpText as string
strUpText =Textbox1.text
更新SQL语句
Dim queryString As String = Update NP Set Ps= & strUpText &
__________________________________________________________________________
问题已经解决,感谢renren00
__________________________________________________________________________