using System;

using System.Data;

using System.Data.SqlClient;


namespace DBUtil

{

class Program

{

static void Main(string[] args)

{

//连接数据库

/**

* 注意如果是本地数据库用Trusted_Connection=SSPI;

* 是server的话用uid,pwd等账户密码进行验证

*/

SqlConnection myCon = new SqlConnection();

myCon.ConnectionString = @"Data Source=localhost\SQLEXPRESS;Initial Catalog=test;Trusted_Connection=SSPI";

try

{

//打开数据库

myCon.Open();

//使用SqlCommand提交查询命令

SqlCommand sql = new SqlCommand("select * from Student", myCon);


//获取数据适配器

SqlDataAdapter sda = new SqlDataAdapter();

sda.SelectCommand = sql;


//填充DataSet

DataSet ds = new DataSet();

sda.Fill(ds, "Student");

Console.WriteLine("{0}", ds.GetXml());


}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

finally

{

myCon.Close();

}



}

}

}