Can We pass Datatype as argumet to function and then That datatype use to convert data which is also i am passing as argument

Question

5.00/5 (1 vote)

See more:

hii

I Have to pass around 80 fields to database which is most of different type.
so in code behind file I want to check the type and and have to convert it to db type as value is accessing from textbox.

so I want to make method in which ill check data where its empty (if empty then send DBNULL.Value)
and if not then convert to datatype which ill pass as argument

Is this possible
how can i achieve it

please help....!!!

Posted 7-Mar-13 3:12am

sanchu90

Add a Solution

Comments

[no name] 7-Mar-13 9:31am

"Is this possible", yes it's possible but probably completely unnecessary.
"how can i achieve it", by writing a ton of code that you probably do not need to.
Maybe you should look into parametrized queries and see if that would help you.

sanchu90 7-Mar-13 9:58am

Okay thn please suggest me some way so that i dont need to do checking 80 times

[no name] 7-Mar-13 9:59am

If you read my comment, I already did.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-03-07T03:36:00

Solution 1

Why would you want to?
Check for null by all means - it's a good idea to do that anyway.
But if you pass the value as a parameter using the SqlCommand.Parameters.AddWithValue method, you need do no other conversion at all - it will be sorted out for you.

Posted 7-Mar-13 3:36am

OriginalGriff