Hello
I have the following code where i,m trying to see if a CustId exist or not and if it does return data from the database to the textboxes but if not it returns a message in the lblMessage.
But what is happing in my else if statement is allows false so it throws the lblMessage "can not find Customer Id" or an Exception is i change the code to
else if (CustID ==0){ //then code }
protected void Button1_Click(object sender, EventArgs e) { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection1"].ConnectionString); int CustID = 0; SqlCommand command = new SqlCommand(); command.Connection = conn; command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetCustmer"; command.Connection.Open(); SqlParameter param = new SqlParameter(); param.ParameterName = "@ID"; param.SqlDbType = SqlDbType.Int; param.Direction = ParameterDirection.Input; param.Value = txtCustID.Text; command.Parameters.Add(param); int ID = table.Rows.Count; if (string.IsNullOrWhiteSpace(txtCustID.Text)) { //throw new Exception("Id not provided."); lblMessage.Text = "You did not enter a Customer Number"; } else if(CustID !=0) { adapter.SelectCommand = command; adapter.Fill(table); //txtCustID.Text = table.Rows[0].Field<string>("CustID"); txtFirstname.Text = table.Rows[0].Field<string>("Firstname"); txtFirstname.DataBind(); txtSurname.Text = table.Rows[0].Field<string>("Surname"); txtSurname.DataBind(); } else { lblMessage.Text = "Could not find customer number"; } }
Thanks for your help
No comments:
Post a Comment