C#获得数据源信息

来源：互联网发布：索尼l36h没数据网络编辑：程序博客网时间：2024/05/02 00:31

namespace dc3
{
    class Program
    {
        static void Main(string[] args)
        {
            string strcon = "Data Source=(local);Database=TEST;Uid=sa;Pwd=123";
            SqlConnection strconn = new SqlConnection(strcon);
            SqlCommand sqlcom = new SqlCommand();

            try
            {
                strconn.Open();
                sqlcom.Connection = strconn;
                sqlcom.CommandText = "select id,name from roleinfo";
                SqlDataReader dr = sqlcom.ExecuteReader();
                Console.WriteLine("{0}/t{1}", "id", "name");
                Console.WriteLine();
                while(dr.Read())
                {
                    Console.WriteLine("{0}/t{1}",dr.GetInt32(0),dr.GetString(1));
                }

            }
            catch (Exception e)
            {
                Console.WriteLine("try有问题");
            }
            Console.ReadLine();
        }
    }
}