如何自定义DataSet返回从数据库中查询的数据

[bestzone]

大家好，请问如何自定义DataSet，以便返回从数据库中查询到的数据信息，各位高手给个提示即可，谢谢！！

[sky11007]

SqlConnection conn = new SqlConnection("server=;database=;uid=;pwd=");
string sqlcmd = "select 语句";
SqlDataAdapter da = new SqlDataAdapter(sqlcmd ,conn );
DataSet ds = new DataSet();
da.Fill(ds);
你说的是不是这个用Dataset返回数据库的信息，

[流氓兔]

/// <summary>
/// 得到DATASET对象
/// </summary>
/// <returns></returns>
private DataSet GetDataSet()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=(local);database=AdventureWorks;Integrated Security=SSPI;";
DataSet ds = new DataSet();
try
{
conn.Open();
string cmdtext = "select * from person.address";
SqlCommand cmd = new SqlCommand(cmdtext, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds, "address");
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
finally
{
conn.Close();
}

return ds;
}