Create Procedure prclogin_check
    (
    @User_name varchar(20),
    @U_Password varchar(23),
    @Results int Output
    )
    Set @Results = (Select count(*) from User_Table
    where User_name =@User_name and U_Password = @U_Password)

    using System.Data.SqlClient;
    String strcon = "User id = sa;Password= topman;Server=myServer;Database=MyDB";
    SqlConnection con = new SqlConnection(strcon);
    SqlCommand cmdselect = new SqlCommand();
    cmdselect.CommandTimeout = 0;
    cmdselect.CommandType = CommandType.StoredProcedure;
    cmdselect.Connection = con;
    cmdselect.CommandText = "prclogin_check";
    cmdselect.Parameters.Add("@Results",SqlDbType.Int,4);
    cmdselect.Parameters["@Results"].Direction = ParameterDirection.Output;
    int Res;
    try
    {
    con.Open();
    cmdselect.ExecuteNonQuery();
    Res = (int)cmdselect.Parameters["@Results"].Value;
    con.Close();
    }
    catch (SqlException e)
    {
    MessageBox.Show(e.Message);
    }