DataSet ds = new DataSet(); DataTable dt = new DataTable("Grade"); dt.Columns.Add(new DataColumn("id", typeof(int))); dt.Columns.Add(new DataColumn("Name", typeof(string))); SqlDataReader dataread = null; DataRow dr=null; while(dataread.Read()) { dr = dt.NewRow(); dr["id"] =(string)dataread["id"]; dr["Name"] = (string)dataread["name"]; } dt.Rows.Add(dr); 連線資料庫那部分相信你自己也會添加了吧，程式碼沒有經過測試，應該就是這個意思

publicsqlconnectiongetcon()

{

//連線本地資料庫server=localhost

stringm_str_sqlcon=@"server=localhost;database=表名;integratedsecurity=sspi";

sqlconnectionmycon=newsqlconnection(m_str_sqlcon);

returnmycon;

}

///

///建立一個datatable物件

///

///

///

///

datatablemytable=newdatatable();

publicdatatablegettable(stringm_str_sqlstr)

{

sqlconnectionsqlcon=this.getcon();

sqldataadaptersqlda=newsqldataadapter(m_str_sqlstr,sqlcon);

sqlda.fill(mytable);

sqlcon.close();

sqlcon.dispose();

returnmytable;

}

呼叫該方法:

datatablemytable=gettable("select*from表名")