【C#学习笔记】读SQL Server2008

时间:2024-10-01 17:04:32
using System;
using System.Data.SqlClient;

namespace ConsoleApplication
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection con = new SqlConnection("server=.\\sqlexpress;uid=sa;pwd=123456;database=stuDB");
            con.Open();

            SqlCommand com = con.CreateCommand();
            com.CommandText = "select * from stuInfo";

            SqlDataReader reader = com.ExecuteReader();

            while (reader.Read())
                Console.WriteLine(reader["stuName"].ToString() + reader["stuAge"].ToString() + reader["stuSex"].ToString());

            reader.Close();
            con.Close();
            Console.Read();
        }
    }
}