aqzman_ wrote: I'm not exatly sure what you mean by it isn't used, the SqlDataSource is called in DataSourceID of the dropdownlist. Or maybe I've misunderstood you. The SqlDataSource is used on the page, but it's not used in the code that you have problems with. --- single minded; short sighted; long gone;

Hello, Their is a Traditional way, for all variable(different datatype). i,e. Consider, Dim str As String = "Iam a string" Dim integ As Integer = 0 Dim da As Date = "#6/22/2007#" Dim ss As String ss = "'" & str & "' " & integ & " '" & da & "'" Answer = 'Iam a string' 0 '6/22/2007' I thing u got the answer. If hve any problem msg me friend...........

Thanks for both of your replies! I'll try your method, kubben.

That worked like a charm! Thanks a lot for the help!

SelectCommand=" Declare @Name varchar SELECT *FROM tblCallers, tblTicket, tblUsersWHERE tblTicket.TicketID = tblCallers.TicketID AND tblTicket.UserID = tblUsers.UserID AND tblUsers.Name = @Name"; I was born dumb!! :laugh:Programming made me laugh:laugh:!!! --sid--

Thanks a lot for your help! I really appreciate it.

true very true!!! :) I was born dumb!! :laugh:Programming made me laugh:laugh:!!! --sid--

Yeah, just set that as the navURL or whatever the property is of the ASP Hyperlink control. I didn't get any requirements for the signature

That's great! Thanks a lot for your reply, and help!

Excellent. Good work! :-D

You're on the right track. You need to use the Mod operator ( it's % in C#, I suspect it's Mod in the ever literal VB ). This will return to you the remainder of your division. So, if you have 63 minutes in Time, Time Mod 60 would give you 3, the number of seconds. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

Christian Graus wrote: fat_boy likes to go after me in all the forums Hmm, paranoid too. Oh come on, I dont stalk you. Anyway, why do I recomend C? Because it is difficult. And my attitude to learning something new is to go for the deep end. And that is what I was suggesting to the postee. Nunc est bibendum