用一个数据适配器来填充到里面就是了,比如用SqlDataAdapter的Fill方法;参考如下:
SqlConnection cn=new SqlConnection(connectionString);
SqlCommand selectCommand=new SqlCommand(cmdText,cn);
SqlDataAdapter ada=new SqlDataAdapter();
ada.SelectCommand = selectCommand;
DataSet ds = new DataSet();
ada.Fill(ds);
这样ds里就有cmdText所查到的记录了.
SqlConnection cn=new SqlConnection(connectionString);
SqlCommand selectCommand=new SqlCommand(cmdText,cn);
SqlDataAdapter ada=new SqlDataAdapter();
ada.SelectCommand = selectCommand;
DataSet ds = new DataSet();
ada.Fill(ds);
这样ds里就有cmdText所查到的记录了.
SqlCommand selectCommand=new SqlCommand(cmdText,cn);
SqlDataAdapter ada=new SqlDataAdapter();
ada.SelectCommand = selectCommand;
DataSet ds = new DataSet();
ada.Fill(ds);
("SELECT * FROM Student",
"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\\mcb.mdb" );
DataSet ds = new DataSet();
da.Fill(ds, "Student");