execute parameterized stored procedure from code behind

Add This to your Web.config file








SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConStr"]);
SqlCommand cmd = new SqlCommand("spCheckProjectStatus", conn);
cmd.CommandType = CommandType.StoredProcedure;

SqlParameter sqlParam = new SqlParameter();
sqlParam = cmd.Parameters.Add("@ProjectId",SqlDbType.VarChar);
sqlParam.Direction = ParameterDirection.Input;
sqlParam.Value = dtTemp.Rows[i]["Pid"].ToString();

SqlParameter sqlParam2 = new SqlParameter();
sqlParam2 = cmd.Parameters.Add("@BiderId",SqlDbType.VarChar);
sqlParam2.Direction = ParameterDirection.Input;
sqlParam2.Value = dtTemp.Rows[i]["Bid"].ToString();

conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
conn.Close();

hope this will help you....