Click here to Skip to main content
15,905,028 members
Home / Discussions / Database
   

Database

 
GeneralRe: Join Pin
Anonymous17-Nov-03 2:39
Anonymous17-Nov-03 2:39 
Generalsql Pin
ranjjj13-Nov-03 17:18
ranjjj13-Nov-03 17:18 
GeneralAccess Query Pin
bgeroux13-Nov-03 16:25
bgeroux13-Nov-03 16:25 
GeneralRe: Access Query Pin
Hesham Amin13-Nov-03 21:28
Hesham Amin13-Nov-03 21:28 
GeneralRe: Access Query Pin
Roger Wright14-Nov-03 3:14
professionalRoger Wright14-Nov-03 3:14 
GeneralRe: Access Query Pin
bgeroux14-Nov-03 3:43
bgeroux14-Nov-03 3:43 
GeneralRe: Access Query Pin
Roger Wright14-Nov-03 4:19
professionalRoger Wright14-Nov-03 4:19 
GeneralRe: Access Query Pin
Mike Dimmick15-Nov-03 1:52
Mike Dimmick15-Nov-03 1:52 
A VB.NET console application (requires the database that Roger linked to above):
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
Hope this helps. Some people have reported that using the ODBC classes rather than OLE DB is faster in the current version of the framework (probably due to lower interop overhead for 'flat' APIs versus COM APIs).
GeneralRe: Access Query Pin
bgeroux15-Nov-03 6:31
bgeroux15-Nov-03 6:31 
Generaldbms_pipe Pin
mhmoud rawas12-Nov-03 18:30
mhmoud rawas12-Nov-03 18:30 
GeneralRe: dbms_pipe Pin
Mike Dimmick13-Nov-03 23:22
Mike Dimmick13-Nov-03 23:22 
GeneralRe: dbms_pipe Pin
mhmoud rawas14-Nov-03 20:01
mhmoud rawas14-Nov-03 20:01 
GeneralRe: dbms_pipe Pin
Mike Dimmick15-Nov-03 1:30
Mike Dimmick15-Nov-03 1:30 
GeneralRe: dbms_pipe Pin
mhmoud rawas15-Nov-03 18:36
mhmoud rawas15-Nov-03 18:36 
GeneralSQL get some ZERO's Pin
student()12-Nov-03 11:52
sussstudent()12-Nov-03 11:52 
GeneralRe: SQL get some ZERO's Pin
Jeff Varszegi12-Nov-03 13:25
professionalJeff Varszegi12-Nov-03 13:25 
GeneralRe: SQL get some ZERO's Pin
student()12-Nov-03 13:55
sussstudent()12-Nov-03 13:55 
GeneralRe: SQL get some ZERO's Pin
student()12-Nov-03 14:27
sussstudent()12-Nov-03 14:27 
GeneralRe: SQL get some ZERO's Pin
Edbert P12-Nov-03 14:58
Edbert P12-Nov-03 14:58 
GeneralRe: SQL get some ZERO's Pin
Jeff Varszegi12-Nov-03 16:01
professionalJeff Varszegi12-Nov-03 16:01 
GeneralRe: SQL get some ZERO's Pin
student()13-Nov-03 3:35
sussstudent()13-Nov-03 3:35 
GeneralRe: SQL get some ZERO's Pin
Matt Gullett12-Nov-03 17:05
Matt Gullett12-Nov-03 17:05 
GeneralADO and DAO Pin
Anonymous12-Nov-03 4:41
Anonymous12-Nov-03 4:41 
GeneralRe: ADO and DAO Pin
Hesham Amin12-Nov-03 7:00
Hesham Amin12-Nov-03 7:00 
GeneralRe: ADO and DAO Pin
Tom Archer14-Nov-03 17:02
Tom Archer14-Nov-03 17:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.