返回dataset的问题

Question

public DataSet getassignentry( ...)
{
   return //DataSet 类型
}

Answer 1

               private void button1_Click(object sender, System.EventArgs e)
{
string TableName = "BM_Doctor";
string ConnectionStr = "workstation id=ZHAOLIREN;packet size=4096;user id=sa;data source=YLGLSERVER;persist security info=True;initial catalog=ylgldb;password=sa";
string RunSQL = "select * from BM_Doctor";
dataGrid1.DataSource = getDateSet(ConnectionStr,RunSQL,TableName);
dataGrid1.DataMember = TableName;
}

private System.Data.DataSet getDateSet(string ConnectionStr,string RunSQL,string TableName)
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConnectionStr);
conn.Open();
System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(RunSQL,conn);
System.Data.DataSet ds = new System.Data.DataSet();
sda.Fill(ds,TableName);
conn.Close();
return ds;
}

Answer 2

public EntryDataSet GetAssignedEntry(string EntryId)
{
    先定义一个包含EntryId的SQL string;
    DataSet ds=new DataSet();
    然后定义ds的connection和command;
    return ds;----//最后返回ds;
   
}