将DataGridView填充到Tabcontrol中 [英] Populate DataGridView into a Tabcontrol
问题描述
大家好,
我想在C#中创建一个量规。
在我的应用程序中我有一个TabControl,其中一些TabPages用于字母表中的每个字母(A,B,C,D ......)
我的联系人进入SQL数据库。
我选择姓氏第一个字母的数据,代码如下:
< pre lang =c#> string query = SELECT COGNOME,NOME,TELEFONO来自dbo.ripContatti,其中COGNOME LIKE' + tabLettere.SelectedTab.Text.ToString()+ %'跨度>;
SqlDataAdapter da = new SqlDataAdapter(query,connessione);
DataSet ds = new DataSet();
da.Fill(ds);
但是,我的问题是:
我必须为每个Tabpages都有一个datagridview吗?
我如何对数据进行排序并将其放入特定的TabPages?
感谢所有我自己解决了。
这里我的代码:
string query = < span class =code-string> SELECT COGNOME,NOME,TELEFONO from dbo.ripContatti WHERE COGNOME LIKE' + tabLettere.SelectedTab.Text.ToString()+ %';
SqlDataAdapter da = new SqlDataAdapter(query,connessione);
DataSet ds = new DataSet();
da.Fill(ds);
我补充说:
DataGridView dgvContatti = new DataGridView();
dgvContatti.Dock = DockStyle.Fill;
dgvContatti.DataSource = ds.Tables [ 0 ];
tabLettere.SelectedTab.Controls.Add(dgvContatti);
我对每个Tabpages只使用一个datagridview。
Hi everyone,
I want to create a rubric in C#.
In my application I have a TabControl with some TabPages one for each letter of the alphabet (A,B,C,D ... )
My contacts are into a SQL database.
I select the data taking the first letter of the last name, with this code:
string query = "SELECT COGNOME, NOME, TELEFONO FROM dbo.ripContatti WHERE COGNOME LIKE '" + tabLettere.SelectedTab.Text.ToString() + "%'";
SqlDataAdapter da = new SqlDataAdapter(query, connessione);
DataSet ds = new DataSet();
da.Fill(ds);
But, my question are:
I must to have a datagridview for every Tabpages?
How can I sort my data and put it into its specific TabPages?
Thanks to all
I've solved by myself.
Here my code:
string query = "SELECT COGNOME, NOME, TELEFONO FROM dbo.ripContatti WHERE COGNOME LIKE '" + tabLettere.SelectedTab.Text.ToString() + "%'"; SqlDataAdapter da = new SqlDataAdapter(query, connessione); DataSet ds = new DataSet(); da.Fill(ds);
I added:
DataGridView dgvContatti = new DataGridView(); dgvContatti.Dock = DockStyle.Fill; dgvContatti.DataSource = ds.Tables[0]; tabLettere.SelectedTab.Controls.Add(dgvContatti);
I use only one datagridview for every Tabpages.
这篇关于将DataGridView填充到Tabcontrol中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!