getting the parameters' type

M

Mr. x

Hello,
I am using .NET.
My database is access, and I am using oleDBConnection.
suppose I have the query :
"update myTable set mycol1= ?, mycol2 = ?".

I want to set the paraterers a value, and for that I need to know before I
am setting them a value, which type are the parameters.

Is there any way to parse the query, and retrieve somehow the parameters'
types, before I am setting them a value ?
(I don't know whethere the parameter's type is oledbtype.Integer, or
oledbtype.varchar, etc... - Is there any way I can know this before I am
setting the parameters of "?" a value ?).

Thanks :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Too few parameters error with a IIF statement 5
Word 2016 - Difficulties Learning Style Creation/Application 0
Language of the templates 0
ASK Field Formatting 1
Report asks for Parameter and Won't Display Subreport 7
Conditional Prompting for Parameter? 3
Check Box query issue 3

Top