The following example shows what a simple application that connects to the Northwind database and returns a list of Categories would look like. The example writes the output to the console, or command prompt.
The following example shows what a simple application that connects to the Northwind database and returns a list of Categories. The example writes the output to the console, or command prompt.
SqlClient
[Visual Basic]
Imports System
Imports
Imports lient
Imports alBasic
Public Class Sample
Public Shared Sub Main()
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;" & _
"User Id=sa;Password=pwd;Initial Catalog=northwind")
Dim catCMD As SqlCommand = teCommand()
mandText = "SELECT CategoryID, CategoryName FROM Categories"
()
Dim myReader As SqlDataReader = uteReader()
Do While ()
eLine(vbTab & "{0}" & vbTab & "{1}", nt32(0), tring(1))
Loop
e()
e()
End Sub
End Class
[C#]
using System;
using ;
using lient;
class Sample
{
public static void Main()
{
SqlConnection nwindConn = new SqlConnection("Data Source=localhost;User Id=sa;Password=pwd;Initial Catalog=northwind");
SqlCommand catCMD = teCommand();
mandText = "SELECT CategoryID, CategoryName FROM Categories";
();
SqlDataReader myReader = uteReader();
while (())
{
eLine("t{0}t{1}", nt32(0), tring(1));
}
e();
e();
}
}
OleDb
[Visual Basic]
Imports System
Imports
Imports b
Imports alBasic
Public Class Sample
Public Shared Sub Main()
Dim nwindConn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" & _
"User Id=sa;Password=pwd;Initial Catalog=northwind")
Dim catCMD As OleDbCommand = teCommand()
mandText = "SELECT CategoryID, CategoryName FROM Categories"
()
Dim myReader As OleDbDataReader = uteReader()
Do While ()
eLine(vbTab & "{0}" & vbTab & "{1}", nt32(0), tring(1))
Loop
e()
e()
End Sub
End Class
[C#]
using System;
using ;
using b;
class Sample
{
public static void Main()
{
OleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;User Id=sa;Password=pwd;Initial Catalog=northwind");
OleDbCommand catCMD = teCommand();
mandText = "SELECT CategoryID, CategoryName FROM Categories";
();
OleDbDataReader myReader = uteReader();
while (())
{
eLine("t{0}t{1}", nt32(0), tring(1));
}
e();
e();
}
}
