如何隐藏一个dataset中的某列

ltt1987 2006-10-31 03:24:57

SqlConnection conn = new SqlConnection(Frameworks.Config.GetConnString);
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM tv_ProductInfo", conn);
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;

我想绑定的时候不将第3列显示出来，但是要用到里面的数据。该如何设置。

...全文

266 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

dlzhangln 2006-10-31

打赏
举报

How do I hide a column?

dlzhangln 2006-10-31

打赏
举报

http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q708q

dlzhangln 2006-10-31

打赏
举报

// Creating connection and command sting

string conStr = @"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb";

string sqlStr = "SELECT * FROM Employees";

// Create connection object

OleDbConnection conn = new OleDbConnection(conStr);

// Create data adapter object

OleDbDataAdapter da = new OleDbDataAdapter(sqlStr,conn);

// Create a dataset object and fill with data using data adapter's Fill method

DataSet ds = new DataSet();

da.Fill(ds, "Employees");

// Hide the column and attach dataset's DefaultView to the datagrid control

ds.Tables["Employees"].Columns["LastName"].ColumnMapping = MappingType.Hidden;

dataGrid1.DataSource = ds.Tables["Employees"];

huing 2006-10-31

打赏
举报

width=0;
Visible = false;
都可以

GXY2005 2006-10-31

打赏
举报

隐藏第三列 dataGridView1.Columns[2].Visible = false;

lsj_zrp 2006-10-31

打赏
举报

dataGridView1.DataSource = ds.Tables["Customers"];
隐藏第三列 dataGridView1.Columns[2].Visible = false;
获得第三列第一个数据string str=ds.Tables["Customers"].Rows[2][0].ToString();

diablo1003 2006-10-31