protected void btnSave_Click(object sender, EventArgs e) { String id = Request.QueryString["id"]; if (id != null && id.Length > 0) { try { SqlDataSourceOwners.Update(); displayMessageAlert("Record updated successfully."); } catch (SqlException exc) { String errorMsg = "Error updating record! Please check all fields entered."; displayMessageAlert(errorMsg); } } else { try { String connectionString = ConfigurationManager.ConnectionStrings["Vet_DataConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); string query = "INSERT INTO Pet_Owner(First, Last, Mobile_No, Email_Address, Licence_No, Medicare_No, ID_checked, Utility_bill, Street_Address, Postcode) VALUES (@First, @Last, @Mobile, @Email, @Licence, @Medicare, @ID_Checked, @Utility, @Address, @Postcode); SELECT SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@First", txtFirstname.Text); cmd.Parameters.AddWithValue("@Last", txtLastname.Text); cmd.Parameters.AddWithValue("@Mobile", txtMobile.Text); cmd.Parameters.AddWithValue("@Email", txtEmail.Text); cmd.Parameters.AddWithValue("@Licence", txtLicence.Text); cmd.Parameters.AddWithValue("@Medicare", txtMedicare.Text); cmd.Parameters.AddWithValue("@ID_Checked", chkID.Checked); cmd.Parameters.AddWithValue("@Utility", txtAddress.Text); cmd.Parameters.AddWithValue("@Address", txtAddress.Text); cmd.Parameters.AddWithValue("@Postcode", txtPostcode.Text); con.Open(); txtPetOwnerID.Text = cmd.ExecuteScalar().ToString(); con.Close(); displayMessageAlert("Record added successfully."); } catch (SqlException exc) { String errorMsg = "Error creating record! Please check all fields entered."; displayMessageAlert(errorMsg); } } }
private void displayPetOwnerDetails() { DataView data = (DataView)SqlDataSourceOwners.Select(DataSourceSelectArguments.Empty); if (data != null && data.Count > 0) { txtFirstname.Text = data[0]["First"].ToString(); txtLastname.Text = data[0]["Last"].ToString(); txtMobile.Text = data[0]["Mobile_No"].ToString(); txtEmail.Text = data[0]["Email_Address"].ToString(); chkID.Checked = Convert.ToBoolean(data[0]["ID_checked"].ToString()); txtLicence.Text = data[0]["Licence_No"].ToString(); txtMedicare.Text = data[0]["Medicare_No"].ToString(); txtUtility.Text = data[0]["Utility_bill"].ToString(); txtAddress.Text = data[0]["Street_Address"].ToString(); txtPostcode.Text = data[0]["Postcode"].ToString(); txtPetOwnerID.Text = data[0]["Pet_OwnerID"].ToString(); } }