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(); //} } }}