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