第4章在Windows窗体应用程序中使用数据.doc

在Windows窗体应用程序中使用数据 习题解答 如何填充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;); SqlCommand mySelectSQLCommand=new SqlCommand(); mySelectSQLCommand.CommandText = SELECT * FROM authors; MyConnection.SelectCommand = mySelectSQLCommand; DataSet DS = new DataSet(); MyConnection.Fill(DS); d) SqlConnection MyConnection = new SqlConnection(server=(local);database=pubs;UID=myUser;PWD=myPassword;); MyDataAdapter.CommandText = SELECT * FROM authors; MyDataAdapter.Connection = MyConnection; DataSet DS = new DataSet(); MyDataAdapter.Fill(DS); 答：B 下面的代码添加一条新纪录到数据集中(DS是一个DataSet)： a) DataRow dr = DS.Tables[0].NewRow(); dr[Field1] = New Book; dr[Field2] = business; DS.Tables[0].Rows.Add(dr); b) DataRow dr = DS.NewRow(); dr[Field1] = New Book; dr[Field2] = business; DS.Rows.Add(dr); c) DataRow dr = NewRow(); dr[Field1] = New Book; dr[Field2] = business; DS.Tables[0].Rows.Add(dr); d) DataRow dr = DS.NewRow(); dr[Field1] = New Book; dr[Field2] = business; DS.Rows.Add(dr); 答：A 加载表架构到一个新数据集中 a) DataSet thisDataSet = new DataSet(); string filename=mySchema.xml; System.IO.FileStream myFileStream = new System.IO.Fil