如何将特定的数据集列绑定到datagridview [英] How to bind particular columns of dataset to a datagridview
问题描述
大家好
在我的应用程序中,我从Web服务获取数据到数据集。
此数据集包含12列。
但是在datagridview中显示我只想显示6个特定列。
请告诉我怎么做。
谢谢
Hi all
In my application, i am getting data from a web service to a dataset.
this dataset contain 12 columns.
But while display in datagridview i just want to show only 6 particular columns.
Please tell me how to do this.
Thank you
推荐答案
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
//Set AutoGenerateColumns False
dataGridView1.AutoGenerateColumns = false;
//Set Columns Count
dataGridView1.ColumnCount = 3;
//Add Columns
dataGridView1.Columns[0].Name = "CustomerId";
dataGridView1.Columns[0].HeaderText = "Customer Id";
dataGridView1.Columns[0].DataPropertyName = "CustomerID";
dataGridView1.Columns[1].HeaderText = "Contact Name";
dataGridView1.Columns[1].Name = "Name";
dataGridView1.Columns[1].DataPropertyName = "ContactName";
dataGridView1.Columns[2].Name = "Country";
dataGridView1.Columns[2].HeaderText = "Country";
dataGridView1.Columns[2].DataPropertyName = "Country";
dataGridView1.DataSource = dt;
}
}
来源 - 检查链接
http://aspsnippets.com/Articles/Show-bind-only-some-specific-certain-columns-of-DataGridView- control-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx [ ^ ]
static DataTable FilterDataTatbleColumns()
{
DataTable table = new DataTable("Orders");
table.Columns.Add("OrderID", typeof(Int32));
table.Columns.Add("OrderQuantity", typeof(Int32));
table.Columns.Add("CompanyName", typeof(string));
table.Columns.Add("Date", typeof(DateTime));
DataRow newRow = table.NewRow();
newRow["OrderID"] = 1;
newRow["OrderQuantity"] = 3;
newRow["CompanyName"] = "NewCompanyName";
newRow["Date"] = "1979, 1, 31";
// Add the row to the rows collection.
table.Rows.Add(newRow);
DataRow newRow2 = table.NewRow();
newRow2["OrderID"] = 2;
newRow2["OrderQuantity"] = 2;
newRow2["CompanyName"] = "NewCompanyName1";
table.Rows.Add(newRow2);
DataRow newRow3 = table.NewRow();
newRow3["OrderID"] = 3;
newRow3["OrderQuantity"] = 2;
newRow3["CompanyName"] = "NewCompanyName2";
table.Rows.Add(newRow3);
//Getting Two Columns("OrderID", "CompanyName") from the table
DataTable NewTable = table.DefaultView.ToTable(false, "OrderID", "CompanyName");
return NewTable;
}
DataSet ds = <-- Get data from Webservice here
DataTable dt = ds.Tables[0];
DataView view = new DataView(dt);
DataTable resultTable = view.ToTable(false, "Column1", "Column2","Column3","Column4","Column5","Column6");
dataGridView1.DataSource = resultTable ;
我假设您将数据输入数据集ds。
数据集实际上包含表格。
您只需从数据集中获取数据表中的数据。
我希望它能工作为你。
I am assuming you are getting data into dataset ds.
Dataset actually contains tables.
you just have take the data in datatable from data set.
I Hope it will work for you.
这篇关于如何将特定的数据集列绑定到datagridview的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!