datagrid的问题

[istring]

我记得可以在datagrid里实现这样的规则，
例如当值符合要求（例如大于0），则文字颜色改变，单击则触发事件，有谁记得如何做啊？

[istring]

怎么没人顶啊？？？？？？？？？巨失望—_－

[Lcindep110]

可以在ItemDataBound事件中写
if(e.Items.ItemsType == ListItemType.Item || e.Items.ItemsType == ListItemType.AlternatingItem)
{
//当DataGrid中，单元格第0个的值大于0时，让该行变为红色
int cel1 = Convert.ToInt32(e.Items.Cell[0].Text);
if(cel > 0)
{
e.Items.ForeColor = Color.Red;
}
}

[zoxn]

static void Main()
{
Application.Run(new Form1());
}

private void Form1_Load(object sender, System.EventArgs e)
{
dataGrid1.DataSource = SomeDataTable();
AddCellFormattingColumnStyles(this.dataGrid1, new FormatCellEventHandler(FormatGridCells));

}

private void FormatGridCells(object sender, DataGridFormatCellEventArgs e)
{
//color row 1 red
if(e.Row == 1)
e.BackBrush = Brushes.Red;

//color column 4 blue
if(e.Column == 1)
{
e.ForeBrush = Brushes.White;
e.BackBrush = Brushes.Blue;
}
//set font of some cells to bold
if( (e.Row + e.Column) % 5 == 0 )
e.TextFont = new Font(e.TextFont.Name, e.TextFont.Size, FontStyle.Bold);

//set textcolor of some cells to blue
if( (e.Row + e.Column) % 8 == 0 )
e.ForeBrush = Brushes.DodgerBlue;

//set font of some cells to bold, underline, italic with white text on green background
if( (e.Row + e.Column) % 9 == 0 )
{
e.TextFont = new Font(e.TextFont.Name, e.TextFont.Size, FontStyle.Bold | FontStyle.Italic | FontStyle.Underline);
e.ForeBrush = Brushes.White;
e.BackBrush = Brushes.Green;
}


}

private DataTable SomeDataTable()
{
string SQLConn="server=(local);database=StudentDB;user id=sa;password=19840826";
System.Data.SqlClient.SqlConnection conn=new System.Data.SqlClient.SqlConnection(SQLConn);
string str="select * from user1";

System.Data.SqlClient.SqlDataAdapter sqlAdapter=new SqlDataAdapter(str,conn);
System.Data.DataSet st=new DataSet() ;
sqlAdapter.Fill(st,"table1");
DataTable dt=st.Tables["table1"];
return dt;
}

private void AddCellFormattingColumnStyles(DataGrid grid, FormatCellEventHandler handler)
{
DataGridTableStyle ts = new DataGridTableStyle();

DataTable dt = (DataTable) grid.DataSource;

ts.MappingName = dt.TableName;

for(int j = 0; j < dt.Columns.Count; ++j)
{
DataGridFormattableTextBoxColumn cs = new DataGridFormattableTextBoxColumn(j);
cs.MappingName = dt.Columns[j].ColumnName;
cs.HeaderText = dt.Columns[j].ColumnName;
cs.SetCellFormat += handler;
ts.GridColumnStyles.Add(cs);
}

grid.TableStyles.Clear();
grid.TableStyles.Add(ts);
}
}

public delegate void FormatCellEventHandler(object sender, DataGridFormatCellEventArgs e);

public class DataGridFormatCellEventArgs : EventArgs
{
private int _column;
private int _row;
private Font _font;
private Brush _backBrush;
private Brush _foreBrush;
private bool _useBaseClassDrawing;


public DataGridFormatCellEventArgs(int row, int col, Font font1, Brush backBrush, Brush foreBrush)
{
_row = row;
_column = col;
_font = font1;
_backBrush = backBrush;
_foreBrush = foreBrush;
_useBaseClassDrawing = false;
}

public int Column
{
get{ return _column;}
set{ _column = value;}
}
public int Row
{
get{ return _row;}
set{ _row = value;}
}
public Font TextFont
{
get{ return _font;}
set{ _font = value;}
}

public Brush BackBrush
{
get{ return _backBrush;}
set{ _backBrush = value;}
}
public Brush ForeBrush
{
get{ return _foreBrush;}
set{ _foreBrush = value;}
}
public bool UseBaseClassDrawing
{
get{ return _useBaseClassDrawing;}
set{ _useBaseClassDrawing = value;}
}
}

public class DataGridFormattableTextBoxColumn : DataGridTextBoxColumn
{
//in your handler, set the EnableValue to true or false, depending upon the row & col
public event FormatCellEventHandler SetCellFormat;

private int _col;

public DataGridFormattableTextBoxColumn(int col)
{
_col = col;
}
protected override void Paint(System.Drawing.Graphics g, System.Drawing.Rectangle bounds, System.Windows.Forms.CurrencyManager source, int rowNum, System.Drawing.Brush backBrush, System.Drawing.Brush foreBrush, bool alignToRight)
{
DataGridFormatCellEventArgs e = new DataGridFormatCellEventArgs(rowNum, this._col, this.DataGridTableStyle.DataGrid.Font, backBrush, foreBrush);
if(SetCellFormat != null)
{
SetCellFormat(this, e);
}
if(e.UseBaseClassDrawing)
{
base.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight);
}
else
{
g.FillRectangle(e.BackBrush, bounds);
g.DrawString(this.GetColumnValueAtRow(source, rowNum).ToString(), e.TextFont, e.ForeBrush, bounds.X, bounds.Y);
}
if(e.TextFont != this.DataGridTableStyle.DataGrid.Font)
e.TextFont.Dispose();
}

protected override void Edit(System.Windows.Forms.CurrencyManager source, int rowNum, System.Drawing.Rectangle bounds, bool readOnly, string instantText, bool cellIsVisible)
{
//comment to make cells unable to become editable
base.Edit(source, rowNum, bounds, readOnly, instantText, cellIsVisible);
}
}
}