Hi all...
I have a sql server Proc that I am passing data to. The user populates a text box with a number of days (so I can calculate a date that will give the user results from a number of days back to current date). Anyway, I am converting the txt field to a int32 using convert.toint32 and setting it to zero(0) when the user does not elect to put in days (but search with some other data field - such as street name). I do a msgbox in my code to see the value of what I am sending and it says 0 (zero) but the query in the proc is not seeing it as such.

My question is - how can I see not only the value of the field I am sending but also the format (char, int, etc...)?

hi there... if you are sending zero it's doesn't matter the type of it.. how are you calling the SP?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I am not calling it in the VB.net code but in the sqlDataSource that I created in Visual Studio 2005. I have the textfield mapped correctly in the configuration I think.

to clarify... when the user presses the search button, i have a invisible text box that I initialize to 0 in case the user does not put anything in the textbox on the screen. I am doing this because the user can either reset the form after doing one search or press other buttons and type in search parameters into other fields. I init the inv fields on form when search is pressed. Then I see what buttons are pressed and if they are, populate inv fields with data to send to PROC.

and when are you making the convertion?? maybe you are doing after the calling to the SP??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

hmmm. i am not sure. the sqldatasource is bound to my gridview where the data is returned. the last statement in my search button VB.net code is to make the gridview visible.

if the SP is working if you put a number in there (even a zero) then you are passing a blank field to the SP... maybe better than have hidden fields is to put a validating control that make the field obligatory. That way you are sure that the field has data on it...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

i am pretty sure this is correct. i process other search parameters to this same proc and they are passed in correctly. the difference between them and this field is that they have been defined as nvarchar in the proc and this one is defined as int in the proc.

Sure that your problem is with this parameter not being passed like it should.. you are probably passing a null value to the sp and that's why it fails... another thing you can do is change it to nvarchar and do the conversion in the SP.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Thanks Gbianchi. I will try that.