C# 存储过程示例：执行SQL并获取计数

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
           String Str="Data Source=WIN7-20140915LP\\SQLEXPRESS;Initial Catalog=xuesheng;Integrated Security=True";
            SqlConnection con = new SqlConnection(Str);
            SqlCommand mycom = new SqlCommand();
            mycom.Connection = con;
            mycom.CommandType = CommandType.StoredProcedure;
            mycom.CommandText = "count1";
            mycom.Parameters.Add("@性别", SqlDbType.NVarChar, 10);
            mycom.Parameters[0].Value = "男";
            mycom.Parameters.Add("@count", SqlDbType.Int);
            mycom.Parameters[1].Direction = ParameterDirection.Output;
            con.Open();
            SqlDataReader rd = mycom.ExecuteReader();
            Console.WriteLine("{0}", rd.GetName(0));
            while (rd.Read())
            {
                Console.WriteLine("{0}", rd.GetString(0));
            }
            rd.NextResult();