I would like to pass the logged in User's username value to a Sql Server 2005 stored procedure. This is what I have right now but it's not working. How do I send the username value to the stored procedure?
string strGary = System.Configuration.ConfigurationManager.ConnectionStrings["CEPDBConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(strGary);
SqlCommand cmd = new SqlCommand("aspnet_GetMemberEvents");
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;