Vb SQL database connection and implement in form button on the database query, modify, and delete

CodePudding user response:

Ms SQL or SQL
myMs SQL 2000 or ms SQL 2005 or ms SQL 2008

CodePudding user response:

Sub command1_click ()
SQL="select * from table"
Rs. The open SQL, conn, 1, 1
End sub


Sub command1_click ()
SQL="update table set field='123' the where... "
Rs. The Open SQL, conn
End sub

Sub command1_click ()
SQL="delete from table where... "
Rs. The Open SQL, conn
End sub