I'm trying to pull data from my SqlDataReader and display it in an else statment. The data from the reader displays fine when the if condition is meet but when the condition is else I can't get my data from the reader to display. It's just empty, it almost
seems as if the reader is cut off after the if statement.
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
string key = user.ProviderUserKey.ToString();
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("usp_GetDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserKey", key);
SqlDataReader reader;
try
{
con.Open();
reader = cmd.ExecuteReader();
reader.Read();
getBidNumber = reader["SelectedBid"] ...
Go to the complete details ...