给你个例子:
private void button1_Click(object sender, System.EventArgs e)
{
string strconn= @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=G:\bbs.mdb" ;
OleDbDataAdapter adapter = new OleDbDataAdapter("select top 10 * from sheetbbs ",strconn);
dataSet1 = new DataSet();
adapter.Fill(dataSet1,"sheetbbs");
dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
DataGridTextBoxColumn dataGridTextBoxColumn1 = new DataGridTextBoxColumn();
DataGridTextBoxColumn dataGridTextBoxColumn2 = new DataGridTextBoxColumn();
DataGridTextBoxColumn dataGridTextBoxColumn3 = new DataGridTextBoxColumn();
//dataGridTableStyle1.DataGrid = this.dataGrid1;
dataGridTableStyle1.MappingName =this.dataSet1.Tables[0].TableName ;
// dataGridTableStyle1.ForeColor = System.Drawing.Color.Red;dataGridTableStyle1.GridLineColor = Color.Blue;
dataGridTextBoxColumn1.MappingName = "ID";
dataGridTextBoxColumn1.HeaderText ="art id";dataGridTextBoxColumn2 .MappingName ="userID";
dataGridTextBoxColumn2.HeaderText ="User ID";
dataGridTextBoxColumn2.TextBox.ForeColor =Color.Green;
dataGridTextBoxColumn2.TextBox.DoubleClick += new EventHandler(this.changeColor);
dataGridTextBoxColumn3 .MappingName ="title";
dataGridTextBoxColumn3.HeaderText ="Title";
//
// PropertyDescriptorCollection pcol = this.BindingContext[this.dataSet1.Tables[0]].GetItemProperties();
//
//
// DataGridColumnStyle csOrderAmount =
// new DataGridTextBoxColumn(pcol["content"], "c", true);
DataGridColumnStyle csOrderAmount = new DataGridTextBoxColumn();
csOrderAmount.MappingName = "content";csOrderAmount.HeaderText ="内容";
DataGridColumnStyle website = new DataGridTextBoxColumn();
website.MappingName = "website";
website.HeaderText ="webSite";dataGridTableStyle1.GridColumnStyles.AddRange(new
System.Windows.Forms.DataGridColumnStyle[] {
dataGridTextBoxColumn1,
dataGridTextBoxColumn2,
dataGridTextBoxColumn3,
website,
csOrderAmount
});
dataGrid1.TableStyles.Add(dataGridTableStyle1);
dataGrid1.DataSource = this.dataSet1.Tables["sheetbbs"]; }
private void changeColor(object sender, System.EventArgs e)
{
//MessageBox.Show(sender.GetType().ToString());
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
this.dataGrid1.TableStyles["sheetbbs"].SelectionBackColor=Color.White;
this.dataGrid1.TableStyles["sheetbbs"].SelectionForeColor = Color.Red;
// this.dataGrid1.SelectionBackColor=Color.White;
// this.dataGrid1.SelectionForeColor = Color.Red;
//this.dataGrid1.seleforeach(DataGridTextBoxColumn col in this.dataGrid1.TableStyles["sheetbbs"].GridColumnStyles)
{
col.TextBox.ForeColor = Color.Green;
}
this.dataGrid1.TableStyles["sheetbbs"].ForeColor = Color.Gold;
}
private void button1_Click(object sender, System.EventArgs e)
{
string strconn= @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=G:\bbs.mdb" ;
OleDbDataAdapter adapter = new OleDbDataAdapter("select top 10 * from sheetbbs ",strconn);
dataSet1 = new DataSet();
adapter.Fill(dataSet1,"sheetbbs");
dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
DataGridTextBoxColumn dataGridTextBoxColumn1 = new DataGridTextBoxColumn();
DataGridTextBoxColumn dataGridTextBoxColumn2 = new DataGridTextBoxColumn();
DataGridTextBoxColumn dataGridTextBoxColumn3 = new DataGridTextBoxColumn();
//dataGridTableStyle1.DataGrid = this.dataGrid1;
dataGridTableStyle1.MappingName =this.dataSet1.Tables[0].TableName ;
// dataGridTableStyle1.ForeColor = System.Drawing.Color.Red;dataGridTableStyle1.GridLineColor = Color.Blue;
dataGridTextBoxColumn1.MappingName = "ID";
dataGridTextBoxColumn1.HeaderText ="art id";dataGridTextBoxColumn2 .MappingName ="userID";
dataGridTextBoxColumn2.HeaderText ="User ID";
dataGridTextBoxColumn2.TextBox.ForeColor =Color.Green;
dataGridTextBoxColumn2.TextBox.DoubleClick += new EventHandler(this.changeColor);
dataGridTextBoxColumn3 .MappingName ="title";
dataGridTextBoxColumn3.HeaderText ="Title";
//
// PropertyDescriptorCollection pcol = this.BindingContext[this.dataSet1.Tables[0]].GetItemProperties();
//
//
// DataGridColumnStyle csOrderAmount =
// new DataGridTextBoxColumn(pcol["content"], "c", true);
DataGridColumnStyle csOrderAmount = new DataGridTextBoxColumn();
csOrderAmount.MappingName = "content";csOrderAmount.HeaderText ="内容";
DataGridColumnStyle website = new DataGridTextBoxColumn();
website.MappingName = "website";
website.HeaderText ="webSite";dataGridTableStyle1.GridColumnStyles.AddRange(new
System.Windows.Forms.DataGridColumnStyle[] {
dataGridTextBoxColumn1,
dataGridTextBoxColumn2,
dataGridTextBoxColumn3,
website,
csOrderAmount
});
dataGrid1.TableStyles.Add(dataGridTableStyle1);
dataGrid1.DataSource = this.dataSet1.Tables["sheetbbs"]; }
private void changeColor(object sender, System.EventArgs e)
{
//MessageBox.Show(sender.GetType().ToString());
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
this.dataGrid1.TableStyles["sheetbbs"].SelectionBackColor=Color.White;
this.dataGrid1.TableStyles["sheetbbs"].SelectionForeColor = Color.Red;
// this.dataGrid1.SelectionBackColor=Color.White;
// this.dataGrid1.SelectionForeColor = Color.Red;
//this.dataGrid1.seleforeach(DataGridTextBoxColumn col in this.dataGrid1.TableStyles["sheetbbs"].GridColumnStyles)
{
col.TextBox.ForeColor = Color.Green;
}
this.dataGrid1.TableStyles["sheetbbs"].ForeColor = Color.Gold;
}
解决方案 »
- 双缓存里,如果有滚动条的话,怎么办
- 关于 后台的 问题???
- 数据分割成数组后,最后一个空值怎么去掉呢?
- 简单!请修正.......
- socket 多线程 异步 代码 共享,只为提高自己。
- 人才招聘ASP.NET 源码!!1
- 首字母排序算法的问题??
- vs2008开发的c#代码可以编译成机器码吗?
- 散分
- (前提要用#)老师给了1000个左右txt文本,要求提出里面的被【 】括起来的关键字和括号两边的字并统计两边字的次数,求大神指教!!!! [问题点数:100分]
- ▓▓▓▓在DataGrid中如何根据行宽自动换行?(Winform)▓▓▓
- 问一个简单的,偶想使得textBox的 foreColor 不断得变化,变化范围是 Color中所有的颜色。也就是循环变化,但不死机。
// this.dataGrid1.SelectionForeColor = Color.Red;
//this.dataGrid1.seleforeach(DataGridTextBoxColumn col in this.dataGrid1.TableStyles["sheetbbs"].GridColumnStyles)
{
col.TextBox.ForeColor = Color.Green;
}
这几句话没用,不好意思