- using System;
- using System.Data.SqlClient;
- public class TestADO
- {
- public static void Main()
- {
- SqlConnection conn = new SqlConnection(Data Source=localhost; Integrated Security=SSPI; Initial Catalog=pubs);
- SqlCommand cmd = new SqlCommand(SELECT * FROM employees, conn);
- try
- {
- conn.Open();
- SqlDataReader reader = cmd.ExecuteReader();
- while (reader.Read())
- {
- Console.WriteLine(First Name: {0}, Last Name: {1}, reader.GetString(0), reader.GetString(1));
- }
- reader.Close();
- conn.Close();
- }
- catch(Exception e)
- {
- Console.WriteLine(Exception Occured -->> {0},e);
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/310520133709.html
来源: http://www.codesnippet.cn/detail/310520133709.html