Monday 15 August 2011

sql - Conditional DataGrid formatting Colors -


Ive got a Datagrid population with a figure. I want to change the display font color for a whole line where the fifth column (in the column name is SQL = DDLS_NIM) is greater than 3.

  Using Conn as SqlConnection = New SqlConnection (ConnectionString) Con. Open () using SQL Commands = New SQL Commands (SQLite, Conn) Diamond RS SQL Contributor = com. Exeter Reader DMTT Datatable = New Datatile DT. Load (RS) dataGDX Datasource = DT 'if the 5th column [or column name] is value & gt; = 3 then 'Data Grid View 1. ROS [5] [or column name?]. Default sealestyle.ar caller = color. ' I think you have to do this in a process called 'End and End'. Conne & Technology / Div> 

P>

  Private Sub DataGrid View 1_ROPrint (ByVal System, as byVal E. System.Forms.DataGridViewRowPrePaintEventArgs), if DataGridView1.Rows (e.RowIndex). DefaultCellStyle.Fo ReColor = Color.Red End if End Sub    

No comments:

Post a Comment