如何将多个表读入数据集? [英] How can I read multiple tables into a dataset?
本文介绍了如何将多个表读入数据集?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这样的一个:
SqlConnection conn = new SqlConnection(CONNECTION_STRING);
SqlCommand cmd = new SqlCommand(sp_mult_tables,conn);
cmd.CommandType = CommandType.StoredProcedure);
IDataReader rdr = cmd.ExecuteReader();
我不知道如何阅读...什么是最好的方法处理这种类型的查询,我猜我应该把数据读入DataSet?
谢谢。
解决方案
改编自 MSDN :
using(SqlConnection conn = new SqlConnection(connection))
{
SqlDataAdapter adapter = new SqlDataAdapter ();
adapter.SelectCommand =新的SqlCommand(query,conn);
adapter.Fill(dataset);
返回数据集;
}
I have a stored procedure that returns multiple tables. How can I execute and read both tables?
I have something like this:
SqlConnection conn = new SqlConnection(CONNECTION_STRING);
SqlCommand cmd = new SqlCommand("sp_mult_tables",conn);
cmd.CommandType = CommandType.StoredProcedure);
IDataReader rdr = cmd.ExecuteReader();
I'm not sure how to read it...whats the best way to handle this type of query, I am guessing I should read the data into a DataSet? How is the best way to do this?
Thanks.
解决方案
Adapted from MSDN:
using (SqlConnection conn = new SqlConnection(connection))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(query, conn);
adapter.Fill(dataset);
return dataset;
}
这篇关于如何将多个表读入数据集?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文