Hi,
In MemberShipGetUser I call a stored procedure to get the information on the customer. I need to pass customerid to the stored procedure.
public override MembershipUser GetUser(string username, bool userIsOnline)
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Test"].ConnectionString);
SqlCommand cmd = new SqlCommand("spGetUserByEmail", conn);
cmd.Parameters.AddWithValue("@CustomerAddressBookID", Util.customerid);
cmd.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt == null || dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
int customerid= int.Parse(dr["customerid"].ToString());
//I load other objects as well
TMembersh ...
Go to the complete details ...