Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Home » Tip Bank » .NET » C#
Language: .NET
Expertise: Beginner
May 25, 2017

Working with an SQL Output Parameter in C#

When working with an SQL Output parameters, you need to specify the parameter's Direction property once you have created it. Here is a nice little example method:

private float checkValue()
        {
            SqlConnection con = new SqlConnection("Provider=PROVIDER;Server=SERVER;Database=DATABASE;");
            SqlCommand com = new SqlCommand("getValue", con);
            com.CommandType = CommandType.StoredProcedure;

            SqlParameter par = new SqlParameter("@WB", SqlDbType.Float);
            par.Direction = ParameterDirection.Output;
            com.Parameters.Add(par);

            con.Open();
            com.ExecuteNonQuery();
            float i = float.Parse(par.Value.ToString());
            return i;
        }
Implementation
float val = checkvalue();
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date