hi Make a column to template column and then in template col property use a drop down control in the design. ok bye

I am suprised it doesn't work since I use the techique all over the place. So if your existing query is: Select Name, TimeIN, TimeOUT from yourTable All you should have to do is: Select Name, TimeIN, IsNull(TimeOut,'') as 'TimeOut' from yourTable If you are using Sql server. If you ask me it is really best to handle this sort of thing on the database side in what you are passing to .net then try to handle it in .net. Ben

You usually don't try to format the data coming from your database in your code, instead you set a display format on the column in the grid itself.

Well, you create the table as a standalone datatable, and then you point it to ds.Tables[0]. If you haven't actually read anything from the database then this will be the problem. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before.

try converting fields TimeOUT and TimeIN in varchar datatype. DECLARE @dd AS datetime SET @dd =(SELECT convert(datetime,cast(TimeOUT as varchar)) - convert(datetime,cast(TimeIN as varchar))) SELECT convert(varchar,@dd,108) AS minutes

Thank you very much,its working now. keep on the good srpirit.

Can't you just do email to sms? Send an email to X@vtext.com where X is a Verizon cell phone number and it will be delivered as an SMS to the phone. There are similar email addresses for Sprint, Cingular, and T-Mobile. Probably for companies not in America as well. Just remember that you are limited to 160 characters.

Thanks Turbochimp!! I used a picturebox inside a panel with scrollbars & fixed size,and is working exactly as I wanted. Thanks a lot Guys!!!:laugh:;P

Thanks a lot Colin,this is exactly what I wanted and is working perfect;P

what I mean is that: -how can one find out the number of connections to the pool -is there any limits to the connection pooling,if so how can I trace if that limit is reached. hope I 've clarify my question now "enjoycrack"

Thanx Guys!! that code really helped me. keep on helping the others. cheerz......:laugh: