C# ADO.NET怎样才能和SQL数据库连接

Question

C# ADO.NET怎样才能和SQL数据库连接

Answer 1

一个简单的例子： private DataTable sget()
{
SqlConnection conn = new SqlConnection(@"Data Source=.\sqlexpress;database=Asp600;user id=sa;password=123");//()里面是连接数据库的字符串，连接后用sqlconnection对象
SqlDataAdapter ad=new SqlDataAdapter("select top 10 * from Count_Iplocal", conn);
DataTable ds = new DataTable();
ad.Fill(ds);
return ds; }

Answer 2

private DataTable sget()
{
SqlConnection conn = new SqlConnection(@"连接数据库的字符串");conn.open();
SqlDataAdapter ad=new SqlDataAdapter("你要查询的语名", conn);
DataTable ds = new DataTable();
ad.Fill(ds);
return ds;}