How I Can Give The Parameter Of A Scalar Sql Server Function Using C# And Get The Value?

Question

0.00/5 (No votes)

See more:

What is the problem in the following code?i want to give the scalar function the parameter iddoc for @iddoctor and get the result in the txt box

SqlConnection conn = new SqlConnection
            ("Data Source=(LocalDB)\\v11.0;Integrated Security=True");

        conn.Open();
        SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[name_of_the_doctor](@iddoctor);", conn);
        SqlParameter code1 = new SqlParameter("@iddoctor", SqlDbType.Int);
        cmd.Parameters.Add(code1);
        cmd.Parameters["@iddoctor"].Value = iddoc;
        textBox1.Text = cmd.ExecuteScalar().ToString();

Posted 24-May-15 0:34am

Member 10491587

Add a Solution

Comments

OriginalGriff 24-May-15 6:45am

And?
What happens when you try?

Member 10491587 24-May-15 6:57am

i get the error that the object [dbo].[name_of_the_doctor] doesn't exist

Member 10491587 24-May-15 6:59am

information: Invalid object name 'dbo.name_of_the_doctor'.

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 · 2015-05-24T01:18:00

"i get the error that the object [dbo].[name_of_the_doctor] doesn't exist"

Error messages are supposed to give you a small clue as to what you are doing wrong: in this case a very quick read of the error message should tell you what you need to do.

Check your database: look under "Programmability"..."Functions"..."Scalar-values Functions" and check that a function called "name_of_the_doctor" exists.

If it doesn't, then you need to write it...
If it does, try this:

C#

SqlCommand cmd = new SqlCommand("SELECT dbo.name_of_the_doctor(@iddoctor);", conn);

[edit]Markdown strikes again![/edit]