自义DataGrid列与隐藏一列

最新推荐文章于 2023-03-29 10:35:24 发布

add8849

最新推荐文章于 2023-03-29 10:35:24 发布

阅读量1.1k

点赞数

分类专栏： C# 文章标签： datagrid class database sql string server

本文链接：https://blog.csdn.net/add8849/article/details/89103

版权

C# 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

SqlConnection conn = new SqlConnection("server=it003;database=pubs;uid=sa;pwd=");
string sql ="select * from authors";
conn.Open();
SqlDataAdapter dta = new SqlDataAdapter(sql,conn);
dta.Fill(Class1.ds,"authors");
dataGrid1.DataSource=Class1.ds.Tables["authors"];
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName =Class1.ds.Tables["authors"].TableName;
DataGridTextBoxColumn UserNameCol = new DataGridTextBoxColumn();
UserNameCol.MappingName = Class1.ds.Tables["authors"].Columns[0].ColumnName;
UserNameCol.HeaderText = "au_id";
ts.GridColumnStyles.Add(UserNameCol);
DataGridTextBoxColumn address = new DataGridTextBoxColumn();
address.MappingName=Class1.ds.Tables["authors"].Columns["address"].ColumnName;
address.HeaderText="地址";
ts.GridColumnStyles.Add(address);
ts.GridColumnStyles[0].Width = 30;
ts.GridColumnStyles[1].Width = 30;
dataGrid1.TableStyles.Add(ts);