如何从数据集中存储过程返回表名 [英] How to return table name from stored procedure in dataset
本文介绍了如何从数据集中存储过程返回表名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我用了一个数据集存储,我需要在装货时15桌。当我填写所有使用存储过程的表返回我所有的表,但表的名称不来作为在一个数据库中的实际表名。
这需要所有的表与表的名称作为表1,表2,表3 ...
我想他们是这个名字,因为它们实际上是在表中。
SELECT PK_GUEST_TYPE,[说明] FROM L_GUEST_TYPE
SELECT PK_AGE_GROUP_ID,AGE_GROUP从L_AGE_GROUP
SELECT PK_COMPANY_ID,COMPANY_NAME从M_COMPANY
SELECT PK_COUNTRY_ID,国家从L_COUNTRY
SELECT PK_EYE_COLOR_ID,[说明] FROM L_EYE_COLOR
SELECT PK_GENDER_ID,[说明] FROM L_GENDER
SELECT PK_HAIR_COLOR_ID,[说明] FROM L_HAIR_COLOR
SELECT PK_STATE_PROVONCE_ID,[说明] FROM L_STATE_PROVINCE
SELECT PK_STATUS_ID,[说明] FROM L_STATUS
SELECT PK_TITLE_ID,[说明] FROM L_TITLE
SELECT PK_TOWER_ID,[说明] FROM M_TOWER
SELECT PK_CITY_ID,[说明] FROM L_CITY
SELECT PK_REGISTER_TYPE_ID,[说明] FROM L_REGISTER_TYPE
下面是我的前端的编码,以填补数据集。
OpenConnection的();
adp.Fill(DS);
CloseConnection(真正的);
解决方案
也许这将帮助的映射数据源表到数据集表
I used a dataset to store 15 tables that I need at the time of loading. When i filled all the tables using stored procedure it returns me all the table but name of the table doesn't comes as that of actual table name in a database.
It takes all the table with table name as Table1, Table2, Table3...
I want them to be with the name as they actually are in table.
SELECT PK_GUEST_TYPE, [DESCRIPTION] FROM L_GUEST_TYPE
SELECT PK_AGE_GROUP_ID, AGE_GROUP FROM L_AGE_GROUP
SELECT PK_COMPANY_ID, COMPANY_NAME FROM M_COMPANY
SELECT PK_COUNTRY_ID, COUNTRY FROM L_COUNTRY
SELECT PK_EYE_COLOR_ID, [DESCRIPTION] FROM L_EYE_COLOR
SELECT PK_GENDER_ID, [DESCRIPTION] FROM L_GENDER
SELECT PK_HAIR_COLOR_ID, [DESCRIPTION] FROM L_HAIR_COLOR
SELECT PK_STATE_PROVONCE_ID, [DESCRIPTION] FROM L_STATE_PROVINCE
SELECT PK_STATUS_ID, [DESCRIPTION] FROM L_STATUS
SELECT PK_TITLE_ID, [DESCRIPTION] FROM L_TITLE
SELECT PK_TOWER_ID, [DESCRIPTION] FROM M_TOWER
SELECT PK_CITY_ID, [DESCRIPTION] FROM L_CITY
SELECT PK_REGISTER_TYPE_ID, [DESCRIPTION] FROM L_REGISTER_TYPE
Here is my frontend coding to fill dataset.
OpenConnection();
adp.Fill(ds);
CloseConnection(true);
解决方案
Probably this would help Mapping Data Source Tables to Dataset Tables
这篇关于如何从数据集中存储过程返回表名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文