DataSet ds =newDataSet();
using (OleDbConnection connection =newOleDbConnection(connectionString))
using (OleDbCommand command =newOleDbCommand(query, connection))
using (OleDbDataAdapter adapter =newOleDbDataAdapter(command))
{
adapter.Fill(ds,"tablename");
}
return ds;
然后直接用ds.tables["tablesname"]就可以了
求解详细步骤
0
最佳答案
0
奖励园豆：5
其他回答(1)
0
这个是ADO.NET知识
SqlConnection Conn=new SqlConnection();
Conn.ConnectionString="连接数据库语句";
SqlCommand Cmd=new SqlCommand();
Cmd.Connection=Conn;
Cmd.CommandText="select * from table";
Cmd.CommandType=CommandType.Text;
SqlDataAdapter SqlApt=New SqlDataAdapter(Cmd);
Conn.Open();
DataTable dt=new DataTable();
SqlApt.Fill(dt);
Conn.Close();
这样就把数据库表table中的数据插入到一个tb对象中了
