Search:
Select * From Table1 Where Name Like 'Name'
Insert:
Insert Into Users(User ,Pass) Values('Name', Password')
Delete:
Delete From Table1 Where Name = 'Name'
UpDate:
UpDate Table1 Set Name = 'Name' Where ID= IDNum
Dim Conn As New SQLConnection("ConnectionString")
Dim Comm as SQLCommand
Dim DR as SQLDataReader
Comm = New SQLCommand("Select * From Table1", Conn)
Conn.Open
DR = Comm.ExecuteReader
If DR.Read Then
TextBox1.Text = DR("Col1")
End If
Conn.Close
