数据网格值插入表中 [英] Data Grid Value insert In the Table

问题描述

我有数据网格视图名称为

DG1

此数据网格中的列是

Id ，月，账单

且值为

I have Data Grid view Name as
DG1
The columns in this data grid are
Id, month, bill
and the values are

ID        MONTH            BILL
1            1              200
2            1              300
3            1              300

此视图中的更多价值



我想使用该命令

MORE VALUES ARE ALSO IN THIS VIEW

I WANT TO USE THE COMMAND AS

cm=new SQLCommand(select * from Bill where empid in(values of id from data grid view ))

如何写入语句for datagrid view

数据网格视图中的id值

how can i write in statement for datagrid view
values of id from data grid view

推荐答案

我不确定你到底想做什么，因为下面查询：

I''m not sure what you exactly want to do, because below query:

select * from Bill where empid in(values of id from data grid view )

只会获取相同但不重复的记录。如果这是您的意图，请尝试在MS SQL Server Management Studio中使用以下查询来查看结果：

will fetch only records which are equal, but not duplicated. If this is your intension, try to use below query in MS SQL Server Management Studio to see result:

SELECT *
FROM (
    SELECT 'Excel' AS [Source], [ID], [MONTH], [BILL]
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\Example.xls', 'SELECT * FROM [Sheet1

'）
UNION < span class =code-keyword> ALL
SELECT ' SQL Server' AS [来源]，[ID]，[MONTH]，[BILL]
FROM Bill）
< span class =code-keyword> ORDER BY [ID]，[MONTH]，[ Source ]

') UNION ALL SELECT 'SQL Server' AS [Source], [ID], [MONTH], [BILL] FROM Bill) ORDER BY [ID], [MONTH], [Source]

额外的 [来源] 字段用于识别数据来源。



你想用VB.NET代码做什么？

An extra [Source] field is to identify the source of data.

Is that what you want do to in VB.NET code?

这篇关于数据网格值插入表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！