Home All Groups Group Topic Archive Search About

change DataSet Row background color

Author
23 Jun 2006 9:21 PM
martin1
Hi,

want to loop DataSet to change row background color based on data retrieved
from sql db, the color can be blue, yellow, red or purple. Therefore, Is
there any way (vb.net) to change dataset row background color? how to loop
dataset, which is already populated data from database?

Thanks

Author
24 Jun 2006 5:25 AM
Cor Ligthert [MVP]
Martin,

A dataset has never a background color. The control that you use to show the
dataset can have a background, but that can even be more if you show the
dataset in the same time using many controls.

I hope this helps,

Cor

Show quoteHide quote
"martin1" <mart***@discussions.microsoft.com> schreef in bericht
news:A60EFBDD-5F4A-4543-8E6F-0FDEF7F6A6FA@microsoft.com...
> Hi,
>
> want to loop DataSet to change row background color based on data
> retrieved
> from sql db, the color can be blue, yellow, red or purple. Therefore, Is
> there any way (vb.net) to change dataset row background color? how to loop
> dataset, which is already populated data from database?
>
> Thanks
Author
26 Jun 2006 2:04 PM
martin1
Cor,

can we use DataSet's table and NewRow() property/method like
DataSet.Tables().NewRow() to change row background color?

Thanks,

Show quoteHide quote
"Cor Ligthert [MVP]" wrote:

> Martin,
>
> A dataset has never a background color. The control that you use to show the
> dataset can have a background, but that can even be more if you show the
> dataset in the same time using many controls.
>
> I hope this helps,
>
> Cor
>
> "martin1" <mart***@discussions.microsoft.com> schreef in bericht
> news:A60EFBDD-5F4A-4543-8E6F-0FDEF7F6A6FA@microsoft.com...
> > Hi,
> >
> > want to loop DataSet to change row background color based on data
> > retrieved
> > from sql db, the color can be blue, yellow, red or purple. Therefore, Is
> > there any way (vb.net) to change dataset row background color? how to loop
> > dataset, which is already populated data from database?
> >
> > Thanks
>
>
>
Author
26 Jun 2006 3:26 PM
Cor Ligthert [MVP]
Martin,

Where can you look at that color in the dataset.
It is a piece in memory.

Cor

Show quoteHide quote
"martin1" <mart***@discussions.microsoft.com> schreef in bericht
news:6119B608-70D2-4766-8A3E-13AB72E8F75A@microsoft.com...
> Cor,
>
> can we use DataSet's table and NewRow() property/method like
> DataSet.Tables().NewRow() to change row background color?
>
> Thanks,
>
> "Cor Ligthert [MVP]" wrote:
>
>> Martin,
>>
>> A dataset has never a background color. The control that you use to show
>> the
>> dataset can have a background, but that can even be more if you show the
>> dataset in the same time using many controls.
>>
>> I hope this helps,
>>
>> Cor
>>
>> "martin1" <mart***@discussions.microsoft.com> schreef in bericht
>> news:A60EFBDD-5F4A-4543-8E6F-0FDEF7F6A6FA@microsoft.com...
>> > Hi,
>> >
>> > want to loop DataSet to change row background color based on data
>> > retrieved
>> > from sql db, the color can be blue, yellow, red or purple. Therefore,
>> > Is
>> > there any way (vb.net) to change dataset row background color? how to
>> > loop
>> > dataset, which is already populated data from database?
>> >
>> > Thanks
>>
>>
>>
Author
27 Jun 2006 7:36 PM
martin1
Cor,

I am wrong place, i should use DataGridView to change color.

Thanks,


Show quoteHide quote
"Cor Ligthert [MVP]" wrote:

> Martin,
>
> Where can you look at that color in the dataset.
> It is a piece in memory.
>
> Cor
>
> "martin1" <mart***@discussions.microsoft.com> schreef in bericht
> news:6119B608-70D2-4766-8A3E-13AB72E8F75A@microsoft.com...
> > Cor,
> >
> > can we use DataSet's table and NewRow() property/method like
> > DataSet.Tables().NewRow() to change row background color?
> >
> > Thanks,
> >
> > "Cor Ligthert [MVP]" wrote:
> >
> >> Martin,
> >>
> >> A dataset has never a background color. The control that you use to show
> >> the
> >> dataset can have a background, but that can even be more if you show the
> >> dataset in the same time using many controls.
> >>
> >> I hope this helps,
> >>
> >> Cor
> >>
> >> "martin1" <mart***@discussions.microsoft.com> schreef in bericht
> >> news:A60EFBDD-5F4A-4543-8E6F-0FDEF7F6A6FA@microsoft.com...
> >> > Hi,
> >> >
> >> > want to loop DataSet to change row background color based on data
> >> > retrieved
> >> > from sql db, the color can be blue, yellow, red or purple. Therefore,
> >> > Is
> >> > there any way (vb.net) to change dataset row background color? how to
> >> > loop
> >> > dataset, which is already populated data from database?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>
>