如何填充DataSet A. SqlDataAdapter MyDataAdapter=new SqlDataAdapter(); SqlCommand mySelectSQLCommand=new SqlCommand(); mySelectSQLCommand.CommandText=”SELECT * FROM authors”; MyDataAdapter.SelectCommand=mySelectSQLCommand; DataSet DS=new DataSet(); MyDataAdapter.Fill(DS); B. SqlConnection MyConnection=new SqlConnection (“server=(local);database=pubs;UID=myUser;PWD=myPassword;”); SqlDataAdapter MyDataAdapter=new SqlDataAdapter(); SqlCommand mySelectSQLCommand=new SqlCommand(); mySelectSQLCommand.CommandText=”SELECT * FROM authors”; mySelectSQLCommand.Connection=MyConnection; MyDataAdapter.SelectCommand=mySelectSQLCommand; DataSet DS=new DataSet(); MyDataAdapter.Fill(DS); C. SqlConnection MyConnection=new SqlConnection (“server=(local);database=pubs;UID=myUser;PWD=myPassword;”); SqlDataAdapter MyDataAdapter=new SqlDataAdapter(); SqlCommand mySelectSQLCommand=new SqlCommand(); mySelectSQLCommand.CommandText=”SELECT * FROM authors”; MyConnection.SelectConnection= mySelectSQLCommand; MyDataAdapter.SelectCommand=mySelectSQLCommand; DataSet DS=new DataSet(); MyConnection.Fill(DS); D. SqlConnection MyConnection=new SqlConnection (“server=(local);database=pubs;UID=myUser;PWD=my Password;”); MyDataAdapter. CommandText=”SELECT * FROM authors”; MyDataAdapter.Connection=MyConnection; DataSet DS=new DataSet(); MyDataAdapter.Fill(DS);