本文介绍了如何命名在存储过程中返回的数据集表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下存储过程
Create procedure psfoo () AS select * from tbA select * from tbB然后我以这种方式访问数据:
I'm then accessing the data this way :
Sql Command mySqlCommand = new SqlCommand("psfoo" , DbConnection) DataSet ds = new DataSet(); mySqlCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); mySqlDataAdapter.SelectCommand = mySqlCommand; mySqlDataAdapter.Fill(ds);现在,当我想访问我的表时,我必须这样做:
Now, when I want to access my tables, I have to do this :
DataTable datatableA = ds.Tables[0]; DataTable datatableB = ds.Tables[1];数据集 Tables 属性也通过字符串(而不是 int)获得访问器.
the dataset Tables property also got an accessor by string (instead of int).
是否可以在 SQL 代码中指定表的名称,以便我可以改为这样写:
DataTable datatableA = ds.Tables["NametbA"]; DataTable datatableB = ds.Tables["NametbB"];我使用的是 SQL Server 2008,如果这会有所不同的话.
I'm using SQL server 2008, if that makes a difference.
推荐答案据我所知,从存储过程中,你不能这样做.但是,您可以在检索到 DataSet 后设置名称,然后从那时起使用它们.
As far as I know, from the stored proc, you can't do that. You can, however, set the names once you have retrieved the DataSet, and then use them from then on.
ds.Tables[0].TableName = "NametbA";更多推荐
如何命名在存储过程中返回的数据集表?
发布评论