using System;
using System.Data.SqlClient;
using System.Data.SqlTypes;
public class NativeSqlServer
{
public static void Main()
{
string SQL = "SELECT OrderID, CustomerID, OrderDate, Freight FROM Orders";
SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI");
SqlCommand cmd = new SqlCommand(SQL, con);
SqlDataReader r;
con.Open();
r = cmd.ExecuteReader();
while (r.Read()) {
SqlInt32 orderID = r.GetSqlInt32(0);
SqlString customerID = r.GetSqlString(1);
SqlDateTime orderDate = r.GetSqlDateTime(2);
SqlMoney freight = r.GetSqlMoney(3);
Console.Write(orderID.ToString() + ", ");
Console.Write(customerID + ", ");
Console.Write(orderDate.ToString() + ", ");
Console.Write(freight.ToString() + ", ");
Console.WriteLine();
}
}
}
|