来自「设置POS机资料、班次资料、收银员资料等。 2）灵活、细分的权限管理」· 代码 · 共 27 行

using System;
using System.Collections.Generic;
using System.Text;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            using (System.Data.SqlClient.SqlConnection conn=new System.Data.SqlClient.SqlConnection (@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\1.mdf;Integrated Security=True;User Instance=True"))
            {
                System.Data.SqlClient.SqlCommand cmd=conn.CreateCommand();
                cmd.CommandText="SELECT test.* FROM test";
                conn.Open();
                System.Data.SqlClient.SqlDataReader rd=cmd.ExecuteReader();
                while(rd.Read())
                {
                    Console.WriteLine("{0},{1}",(int)rd["id"],(string)rd["name"]);
                }
                rd.Close();
            }

        }
    }
}