Виконано

VB6 How To set background color in a grid

Here's a simple one to be done in VB6

I've got a recordset (RsICDs) that contains data. The recordset contains thousands of items. It was pulled with:

iSQL = "SELECT ID, Code, Description, PersonalCode, Common, IsComplete " & "FROM ICD9Codes ORDER BY Code"

Now, here is what I need help with.

I want to take this recordset (all the data is now in RsICDs) and have it put into a DataGrid (or a ComponentOne TDBgrid).

The Code field is always present.

The Description, PersonalCode, Common, and IsComplete fields may or may not have data. In other words, they will either have a string, "", or null.

Finally, and most importantly. The field IsComplete will contain either a "C" or an "I" (or ""). If it is a "C", I want the corresponding row to have a green background. If it is a "I" I want a yellow background. If it is anything else, I want just the default white background.

So, in summary, I only want the lines of code to populate a grid from a recordset, and set the background color of a specified row based on one of the field values from within that row.

I don't need a complilable program, or anything else. Just the rough code that I can understand and adapt to my own needs later.

Thanks!

## Deliverables

All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

win

Навички: Техніка, MySQL, PHP, Архітектура ПЗ, Тестування ПЗ, Visual Basic

Деталі: grid background, needs of a buyer, how to string, how to it work, how to code php, how to code, how to be coder, common string, background 50, white background, php grid, how to t, background white, background color, grid program, set within, recordset, php string contain, simple data grid, vb6 simple

Про роботодавця:
( 114 відгуки(-ів) ) United States

ID Проекту: #3885323

Доручено:

maccee

See private message.

$17 USD за 1 день
(29 відгуків(-и))
5.1

16 фрілансерів(-и) у середньому готові виконати цю роботу за $14

reliableinfotek

See private message.

$21.25 USD за 1 день
(29 відгуків(и))
5.7
dotnetsqlCoder

See private message.

$4.25 USD за 1 день
(87 відгуків(и))
5.5
cezartorescu

See private message.

$12.75 USD за 1 день
(33 відгуків(и))
5.1
cyrilguptatt

See private message.

$17 USD за 1 день
(45 відгуків(и))
4.9
ruska

See private message.

$17 USD за 1 день
(23 відгуків(и))
4.7
piton911

See private message.

$12.75 USD за 1 день
(24 відгуків(и))
4.2
softwareprabhu

See private message.

$20.4 USD за 1 день
(15 відгуків(и))
4.5
cdcosmin

See private message.

$3.4 USD за 1 день
(21 відгуків(и))
3.2
prag

See private message.

$17 USD за 1 день
(5 відгуків(и))
2.5
vw1605961vw

See private message.

$12.75 USD за 1 день
(2 відгуків(и))
1.2
RapidSol

See private message.

$6.38 USD за 1 день
(0 відгуків(и))
0.0
mrlinx

See private message.

$21.25 USD за 1 день
(0 відгуків(и))
0.0
madhuprakash

See private message.

$19.55 USD за 1 день
(0 відгуків(и))
0.0
captain2005

See private message.

$8.5 USD за 1 день
(0 відгуків(и))
0.0
naasp

See private message.

$17 USD за 1 день
(0 відгуків(и))
0.0