在DataGrid中使满足条件的记录的某一行(列)变色" ，（急）

[dfdsfdsfsfsafsdfsdf]

？？

[luzufu]

我建议你使用别的数据控件MSHFLXGD.OCX能实现你的想法，很简单。

[脆皮大雪糕]

我没有用过datagrid，只用vb自带的mshflexgrid，给你一个设置一行的颜色的代码吧。在窗体中放置一个MSHFlexGrid1贴上下面的代码


Private Sub Form_Load()
With MSHFlexGrid1
.Rows = 5
.Cols = 9
Dim i As Integer
For i = 0 To 8
.Row = 3
.Col = i
.CellBackColor = vbRed
Next
End With
End Sub

[haipingma]

datagrid沒有辦法實現你的要求,考慮用MSHFlexGrid1或VsFlexgrid

[dfdsfdsfsfsafsdfsdf]

請問有沒有人自已寫過些代碼，因為MSHFlexGrid1的界有的功能沒有。

[地狱余烬]

我天天写
dim cnnWszDB As ADODB.Connection
...

dim AdoRs as new adodb.Recordset
adors.open "select ....",cnn,adOpenForwardOnly
set MSHFlexGrid1.datasouce = adors
adors.close :set adors =nothing
With MSHFlexGrid1
Dim i As Integer
For i = 1 To .rows -1
.Row = 3
.Col = i
if ... = true then
.CellBackColor = vbRed
end if
Next
End With

[陈燕君]

为什么要用DataGrid控件？怎么不用Vsflexgrid控件？

[benxie]

.CellBackColor = vbRed