This is how I call store procedure using .NET having passing input value and return by output value
public static int GetSearchCount(string country)
{
int count = 0;
using (SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["dbnamestr"].ConnectionString))
{
conn.Open();
SqlCommand objCmd = new
SqlCommand("sp_SearchCount", conn);
objCmd.CommandType =
CommandType.StoredProcedure;
SqlParameter paramTotal = new
SqlParameter("@Total", SqlDbType.Int);
paramTotal.Direction =
ParameterDirection.ReturnValue;
objCmd.Parameters.Add(paramTotal);
objCmd.Parameters.AddWithValue("@Country", country);
objCmd.ExecuteScalar();
count = (int)paramTotal.Value;
}
return
count;
}
4 comments:
yYCVSH celebrex 50mg edwdke celexa pharmacy FBzMcg chloromycetin without prescription OLfvXw cialis professional 10mg VhQiyX cialis soft free pills yOCDOm cialis super active get IVOcuq cialis order
X6ir0DjQv Hard Rock Casino tclThPOU4 Reno Casino Hotel WEJbkLzTX Casino Free Slots 5ahMo0BRT4 Casino Job 4pGE0PXOv Casino Inc 52XjiI8z7v Casino Affiliate Program CDbeLhHVjB Casino Inc daLtrV9Ub Bacaran Bay Biloxi Casino
yeezy
goyard
balenciaga
golden goose
yeezys
goyard
goyard handbags
yeezy shoes
adidsas yeezy
you can try this out best replica designer hop over to this web-site best replica designer bags have a peek at this site Ysl replica handbags
Post a Comment