Thanks everybody for help. Anybody can recommend a good forum for .NET questions? I have to talk to the owner of the code regarding removing the thread...

Thanks again.Unfortunately they always put too much on your plate ..

Dear Peddie,

http://www.codeproject.com/useritems/CheckBoxCommand.asp - this one solved the problem, I converted C# into VB and it works fine .

Last thing for me left is   on some event check or uncheck all...

You were right, it helped!

I want to select a column and append a value to it but I get an error, why?

select column + " some text to add to result "  as result

THANK YOU THANK YOU THANK YOU !

This WORKS!

OK never mind

Just copied all the records into good old VI and find them all

Didn't work

Should return a record like s3BBkdLLL if at least one character is lower case. It's a more complex regular expression I guess....

There are no empty strings. All that is needed is to catch cases with lower case letters in the field. Thanks!

"and while the datareader is still open you can use the same connection to execute other commands (including updates, inserts, deletes) on the same connection"

I tried to read data then...

Thank you all guys! I will go look at the examples. I can only learn from some practical  examples.

I don't know which way to go though, stored procedures in...

I only see update post and preview buttons...

If I have dateStart and dateEnd, how to calculate how many days between those two dates?

Link doesn't work

Well, I don't think it's a good idea to have a table of dates. You mean to create it on the fly and then drop it? What if something happens...