Database

SELECT Id,Name, Age,City, AdmDate 
FROM IP LEFT JOIN MDoc
ON IP.DoId=MDoc.DoId 
WHERE AdmDate >= '2003-11-15' AND
AdmDate < DATEADD( Day, 1, '2003-11-15' )
ORDER BY IP_Id

Update table1 set userName="bla bla" where ID=@MyID

parameters @MyID long;

Imports System.Data.OleDb
 
Module Module1
 
   Sub Main()
 
      Dim conn As OleDbConnection
      Dim cmd As OleDbCommand
      Dim param As OleDbParameter
      Dim rdr As OleDbDataReader
 
      Try
 
         conn = New OleDbConnection( _
            "Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=""courses.mdb"";" & _
            "Persist Security Info=False")
 
         conn.Open()
 
         cmd = New OleDbCommand("qryStudentsOnCourse", conn)
         cmd.CommandType = CommandType.StoredProcedure
 
         param = cmd.Parameters.Add("@courseID", OleDbType.VarChar, 10)
         param.Value = "C0450"
 
         rdr = cmd.ExecuteReader()
 
         While rdr.Read()
 
            Console.WriteLine("{0} {1}", rdr("firstName"), rdr("lastName"))
 
         End While
 
      Finally
 
         If Not rdr Is Nothing Then
            rdr.Close()
         End If
 
         If Not cmd Is Nothing Then
            cmd.Dispose()
         End If
 
         If Not conn Is Nothing Then
            conn.Close()
         End If
 
      End Try
 
   End Sub
 
End Module