C#连接数据库

来源:互联网 发布:网络摄像头电源多少伏 编辑:程序博客网 时间:2024/04/28 10:08
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data;using System.Data.SqlClient;namespace ConsoleApplication1{    class Program    {        static void Main(string[] args)        {            //try            //{                Console.WriteLine("程序启动");                SqlConnection conn;                conn = new SqlConnection("server=localhost;uid=sa;pwd=csq123;database=test");                conn.Open();                SqlDataAdapter da = new SqlDataAdapter("select * from users", conn);                DataSet ds = new DataSet();                da.Fill(ds, "users");                foreach (DataRow row in ds.Tables["users"].Rows)                    Console.WriteLine("name={0},age={1}", row[0], row[1]);                Console.ReadKey();            //}            //catch (Exception e)            //{            //    Console.Write("出错了,老大。", e);            //    Console.ReadKey();            //}        }    }}