public
DataSet
GetDataSet()
{
//創建壹個SqlConnection對象
string
strCon
=
"Initial
Catalog='數據庫名稱';Server='遠程IP地址,1433';User
ID='登錄用戶名';Password='登錄用戶密碼';Persist
Security
Info=True";
SqlConnection
myConn
=
new
SqlConnection
(
strCon
)
string
strCom
=
"
SELECT
*
FROM
數據表名稱"
//創建壹個
DataSet對象
myDataSet
=
new
DataSet
(
)
myConn.Open
(
)
SqlDataAdapter
myCommand
=
new
SqlDataAdapter
(
strCom
,
myConn
)
myCommand.Fill
(
myDataSet
,
"數據表名稱"
)
myConn.Close
(
)
return
myDataSet;
}