111,125
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data;
using System.Data.SqlClient;
namespace Program
{
class Db
{
public static void test()
{
SqlConnection MySqlConn = new SqlConnection("server=localhost;database=pubs;Integrated Security=true");
MySqlConn.Open();
SqlDataAdapter MySqlAdapter = new SqlDataAdapter("select * from titles", MySqlConn);
DataSet ds = new DataSet();
MySqlAdapter.Fill(ds, "DeptName");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Console.WriteLine(ds.Tables[0].Rows[i][0]);
}
MySqlConn.Close();
Console.Read();
}
static void Main()
{
Db.test();
}
}
}