public void AddClient() { try { // Make new client row NBDDataSet.CLIENTRow r = dsNBD.CLIENT.NewCLIENTRow(); r.cliName = txtName.Text.ToString(); r.cliAddress = txtAddress.Text.ToString(); if (ddlProvinces.SelectedValue != "-1") { r.cliProvince = ddlProvinces.SelectedValue.ToString(); } r.cliPCode = txtPostal.Text.ToString(); r.cliPhone = txtPhone.Text.ToString(); r.cliConFName = txtFirst.Text.ToString(); r.cliConLName = txtLast.Text.ToString(); r.cliConPosition = txtPosition.Text.ToString(); // If city already exists... if (ddlCities.SelectedValue != "-2" && ddlCities.SelectedValue != "-1") { r.cityID = Convert.ToInt32(ddlCities.SelectedValue.ToString()); } // If city is new, add new row to city else if (ddlCities.SelectedValue != "-1") { NBDDataSet.CITYRow city = dsNBD.CITY.NewCITYRow(); city.city = txtCities.Text.ToString(); dsNBD.CITY.Rows.Add(city); CITYTableAdapter daCities = new CITYTableAdapter(); daCities.Update(dsNBD.CITY); r.cityID = city.ID; } // Add row dsNBD.CLIENT.Rows.Add(r); CLIENTTableAdapter daClients = new CLIENTTableAdapter(); daClients.Update(dsNBD.CLIENT); // Pop up alert ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('New Client Added!');window.location ='../Clients.aspx';", true); } catch (Exception ex) { lblMessage.Text = "Unable to add client: " + ex.Message; } }
static ClientEntry() { dsNBD = new NBDDataSet(); CITYTableAdapter daCities = new CITYTableAdapter(); CLIENTTableAdapter daClients = new CLIENTTableAdapter(); try { daCities.Fill(dsNBD.CITY); daClients.Fill(dsNBD.CLIENT); } catch { } }