请问在VB.NET中如何执行SQL语句?比如在一个按钮的CLICK事件中完成更新数据库中某个记录的某个列的值。(表名A,列名Enter_Sign)
要执行的SQL语句是:Update A set Enter_Sign=1 Where Project_id=proid
SQL语句中的proid是一个string类型变量
请问在按钮CLICK事件中如何写代码?年前必须完成简单的框架,可俺刚刚学,苦啊!谢谢先!
Dim adpt As OleDb.OleDbDataAdapter
Dim strsql As String
Dim strLinkoracle As String
‘连数据库语句
strLinkoracle = "Provider=" & """" & "OraOLEDB.Oracle.1" & """" & ";User ID=system;Data
Source=mi;Extended Properties=;Persist Security Info=True;Password=wonton"
’sql文
strsql= "Update A set Enter_Sign=1 Where Project_id="
strsql=strsql + “‘”+proid+“’”
adpt = New OleDb.OleDbDataAdapter(strSelect, strLinkoracle)