In my form load event... check datatable column value...

[laxatcg1]

On my form load event, I want to check the value of a particular column from the database till the End Of File and then perform a action. For ex: There is a column named 'SelectOption' in my datatable 'test' and I want to do some action if the value of the 'SelectOption' = 'Option1' till the end of file is reached. Hope am clear. Please help me on this regard. THank you!

[GremlinSA]

So where do you have the problem ???

in the form_load event open your dataset (as per usual method) and do your checks...

But just something to note, this will drastically effect the load time of your form...

Gremmy..

[laxatcg1]

What / How will be my check statement? I mean...

SelectOption(Database column name) = "Option1" till the end of the file. Please help me out.

[laxatcg1]

Am sorry, I forgot to ask this... You had mentioned "... this will drastically effect the load time of your form" and you are absolutely right. Let me explain you what am planning to do... On loading my main form (start form) based on the Date.Today... I want to dynamically add rows/values on to my database.

So what/how do you suggest on handling this out?

[cindex]

[How to make the Grid inactive (not in focus) as long as the user clicks the Grid's cell?

I saw your question. I have the same problem.

if you solve this problem, send e-mail me, please.

or reply this or passed your quote.

[GremlinSA]

To open a ADO database look at this thread and i sugest reading over this thread for more information on this..

Gremmy..