从SQL导出到datagrid标头名称 [英] Export from SQL to datagrid headers name

问题描述

你好，

我想知道当我将数据从SQl导出到datagriview时，将在标头名称后自动添加一个数字.一些标头具有相同的名称，并且在datagrid中看起来像:Nazev1，Nazev2，Nazev3为什么?我只想要名称:nazev. -自动重命名为Nazev 1，Nazev2.我该如何解决?

谢谢

我尝试过的事情:

在SQL中定义

Hello,

I would like known when I export data from SQl to datagriview will automatic add a number after header name. Some headers have same name and in datagrid look like: Nazev1, Nazev2,Nazev3 why? I want only name: nazev. - auto renaming to Nazev 1, Nazev2. How can I fix it?

thank you

What I have tried:

Define in SQL

VPrikazMzdyAZmetkyPostup.nazev AS [Nazev]

VPrikazMzdyAZmetkySmena.nazev AS [Nazev]

推荐答案

编写SQL SELECT查询时，您指定标题文本(假设您使用DataTable或DataSet作为数据源):

When you write your SQL SELECT query you specify the header text (assuming you use a DataTable or DataSet as the DataSource):

SELECT A, B, C FROM MyTable

您是这样的DGV:

Will give you a DGV like this:

A   B   C
1   2   3
4   5   6

当您想要特定的文本时，请使用AS:

When you want specific text, you use AS:

SELECT A AS [Column number one], B AS [Charles XII], C AS Hello FROM MyTable

，您将获得标头:

And you will get the headers:

Column number one    Charles XII    Hello
                1              2        3
                4              5        6

根据使用情况的不同，您可能无法拥有多个具有相同名称的列-一个实例必须是具有控件的控件唯一的名称.
我可以使用列名称相同的多个DataGridViews吗? :csharp [^ ]

当然，总会有一些技巧可以克服这个问题

Depending on the usage context, you may not be able to have multiple columns with the same name- an instance would be when it is a control which must have a unique name.
Can I have multiple DataGridViews with columns with the same name? : csharp[^]

Of course, there is always trickery that can be used to overcome this

这篇关于从SQL导出到datagrid标头名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！