protected void Button2_Click(object sender, EventArgs e) { Button tmp = (Button)sender; tmp.Text = "...clicked..."; try { SqlDataSource2.InsertParameters["ComponentID"].DefaultValue = DetailsView1.SelectedValue.ToString(); // Note - The customer ID is an auto generated identity field. It should not be included in the insert. SqlDataSource3.InsertParameters["PurchaseID"].DefaultValue = TextBox8.Text; SqlDataSource3.InsertParameters["PricePaid"].DefaultValue = TextBox10.Text; SqlDataSource3.InsertParameters["Quantity"].DefaultValue = TextBox11.Text; SqlDataSource3.InsertParameters["QuantityReceived"].DefaultValue = TextBox12.Text; SqlDataSource3.Insert(); TextBox8.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; } catch (Exception ex) { Label2.Text = ex.Message; } }
protected void btnCreate_Click2(object sender, EventArgs e) { int i = 0; try { DataView dv = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty); foreach (DataRowView dr in dv) { i = int.Parse(dr[0].ToString()); } i++; } catch { i = 1; } Session["id"] = i; byte[] defimg = File.ReadAllBytes(Server.MapPath("~/") + "App_Themes/Theme1/noimg.jpg"); Session["logo"] = defimg; SqlDataSource3.Insert(); DSdelRequest.Delete(); string ss = "Trainer Name is: " + txtTrainerName.Text + " / Email to login: "******" / Password to login: "******"mailto:" + txtEmail.Text + "&body=" + ss + "&subject=Trainer Account Successful"); }
protected void Button4_Click(object sender, EventArgs e) { if (FileUpload3.HasFile == true) { SqlDataSource3.Insert(); } }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text != "") { int msj; SqlDataSource3.InsertParameters["MontoInicial"].DefaultValue = TextBox1.Text; SqlDataSource3.InsertParameters["Fecha"].DefaultValue = TextBox2.Text; SqlDataSource3.InsertParameters["ID_Caja"].DefaultValue = DropDownList1.SelectedValue; msj = SqlDataSource3.Insert(); if (msj == 1) { Response.Write("<script>alert('Datos ingresados correctatmente')</script>"); TextBox1.Text = ""; Label1.Text = "Se ingreso a la caja: " + TextBox1.Text; } else { Response.Write("<script>alert('Error, No se guardaron los datos')</script>"); Label1.Text = "Error."; } } else { Response.Write("<script>alert('Ingrese un monto')</script>"); } }
protected void Button2_Click(object sender, EventArgs e) { Button tmp = (Button)sender; Label1.Text = ""; try { //This is similar to the C# we will need for project 2 //SqlDataSource1.InsertParameters["CowKey"].DefaultValue = DetailsView1.SelectedValue.ToString(); // Note - The customer ID is an auto generated identity field. It should not be included in the insert. SqlDataSource3.InsertParameters["PurchaseID"].DefaultValue = TextBox3.Text; SqlDataSource3.InsertParameters["ItemID"].DefaultValue = TextBox5.Text; SqlDataSource3.InsertParameters["Quantity"].DefaultValue = TextBox6.Text; SqlDataSource3.Insert(); } catch (Exception ex) { Label1.Text = ex.Message; } //outside the try catch so that no matter what, the text boxes are cleared. /* * TextBox3.Text = ""; * TextBox5.Text = ""; * TextBox6.Text = ""; */ }
protected void linkInsert_Click(object sender, EventArgs e) { SqlDataSource3.InsertParameters["FirstName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtfName")).Text; SqlDataSource3.InsertParameters["LastName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtlName")).Text; SqlDataSource3.InsertParameters["Address"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtAddress")).Text; SqlDataSource3.InsertParameters["City"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtCity")).Text; SqlDataSource3.InsertParameters["State"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtState")).Text; SqlDataSource3.InsertParameters["ZipCode"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtZipCode")).Text; SqlDataSource3.InsertParameters["Phone"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtPhone")).Text; SqlDataSource3.InsertParameters["Email"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtEMail")).Text; SqlDataSource3.Insert(); }
protected void btnRegister_Click(object sender, EventArgs e) { SqlDataSource3.InsertParameters["CustomerID"].DefaultValue = txtCustomerID.Text; SqlDataSource3.InsertParameters["ProductCode"].DefaultValue = ddlProducts.SelectedValue; SqlDataSource3.InsertParameters["RegistrationDate"].DefaultValue = DateTime.Today.ToShortDateString(); try { SqlDataSource3.Insert(); this.SendEmailConfirmation(); txtCustomerID.Text = ""; lblCustomer.Text = ""; ddlProducts.SelectedIndex = 0; } catch (Exception ex) { Response.Redirect("ErrorMessage.aspx"); } finally { btnRegister.Enabled = false; } }
protected void btnAddCtn_Click(object sender, EventArgs e) { if (Page.IsValid) { SqlDataSource3.Insert(); txtCtnClubname.Text = ""; } }
protected void lbInsert_Click2(object sender, EventArgs e) { SqlDataSource3.InsertParameters["boname"].DefaultValue = ((TextBox)GridView3.FooterRow.FindControl("txtboname")).Text; SqlDataSource3.InsertParameters["bocontact"].DefaultValue = ((TextBox)GridView3.FooterRow.FindControl("txtbocontact")).Text; SqlDataSource3.InsertParameters["bosocietyid"].DefaultValue = ((DropDownList)GridView3.FooterRow.FindControl("ddlbosocietyid")).SelectedValue; SqlDataSource3.InsertParameters["botype"].DefaultValue = ((DropDownList)GridView3.FooterRow.FindControl("ddlbotype")).SelectedValue; SqlDataSource3.Insert(); }
protected void Book_Flight(object sender, EventArgs e) { /* * origin = (string)Session["origin"]; * destination = (string)Session["destination"]; * depart_date = (string)Session["departDate"]; * return_date = (string)Session["returnDate"]; * user_id = (string)Session["uid"]; */ if (selected_flight_departTable_lbl.Text != "" && selected_flight_returnTable_lbl.Text != "") { //depart //registerNewUser(); SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text; SqlDataSource3.InsertCommand = "Insert into ticket_details (ticket_id,customer_ID,flight_id," + "flight_date,Payment_Status) " + "VALUES (@ticket_id,@customer_id,@flight_id,@flight_date,@Payment_Status)"; SqlDataSource3.InsertParameters.Add("ticket_id", "00" + id_From_db); SqlDataSource3.InsertParameters.Add("customer_id", user_id); SqlDataSource3.InsertParameters.Add("flight_id", GridView1.SelectedRow.Cells[0].Text); SqlDataSource3.InsertParameters.Add("flight_date", DateTime.Today.ToString("yyyy-MM-dd")); SqlDataSource3.InsertParameters.Add("Payment_Status", "ok"); SqlDataSource3.Insert(); //return //registerNewUser(); int id_From_db_return = id_From_db + 1; SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text; SqlDataSource3.InsertCommand = "Insert into ticket_details (ticket_id,customer_ID,flight_id," + "flight_date,Payment_Status) " + "VALUES (@ticket_id1,@customer_id1,@flight_id1,@flight_date1,@Payment_Status1)"; SqlDataSource3.InsertParameters.Add("ticket_id1", "00" + id_From_db_return); SqlDataSource3.InsertParameters.Add("customer_id1", user_id); SqlDataSource3.InsertParameters.Add("flight_id1", GridView2.SelectedRow.Cells[0].Text); SqlDataSource3.InsertParameters.Add("flight_date1", DateTime.Today.ToString("yyyy-MM-dd")); SqlDataSource3.InsertParameters.Add("Payment_Status1", "ok"); SqlDataSource3.Insert(); Response.Redirect("~/user_management/receipt", false); } else if (selected_flight_departTable_lbl.Text != "") { //depart only //registerNewUser(); SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text; SqlDataSource3.InsertCommand = "Insert into ticket_details (ticket_id,customer_ID,flight_id," + "flight_date,Payment_Status) " + "VALUES (@ticket_id,@customer_id,@flight_id,@flight_date,@Payment_Status)"; SqlDataSource3.InsertParameters.Add("ticket_id", "00" + id_From_db); SqlDataSource3.InsertParameters.Add("customer_id", user_id); SqlDataSource3.InsertParameters.Add("flight_id", GridView1.SelectedRow.Cells[0].Text); SqlDataSource3.InsertParameters.Add("flight_date", DateTime.Today.ToString("yyyy-MM-dd")); SqlDataSource3.InsertParameters.Add("Payment_Status", "ok"); SqlDataSource3.Insert(); Response.Redirect("~/user_management/receipt", false); } }
protected void LinkButton3_Click(object sender, EventArgs e) { SqlDataSource3.InsertParameters["aadhar"].DefaultValue = ((TextBox)GridView3.FooterRow.FindControl("txtaadhar")).Text; SqlDataSource3.InsertParameters["spname"].DefaultValue = ((TextBox)GridView3.FooterRow.FindControl("txtspname")).Text; SqlDataSource3.InsertParameters["contact"].DefaultValue = ((TextBox)GridView3.FooterRow.FindControl("txtcontact")).Text; SqlDataSource3.InsertParameters["societyid"].DefaultValue = ((DropDownList)GridView3.FooterRow.FindControl("ddlsocietyid")).SelectedValue; SqlDataSource3.InsertParameters["type"].DefaultValue = ((DropDownList)GridView3.FooterRow.FindControl("ddltype")).SelectedValue; SqlDataSource3.InsertParameters["rating"].DefaultValue = ((TextBox)GridView3.FooterRow.FindControl("txtrating")).Text; SqlDataSource3.Insert(); }
protected void insertButtonAutor_Click(object sender, EventArgs e) { SqlDataSource3.InsertParameters["imie"].DefaultValue = ((TextBox)GridView2.FooterRow.FindControl("TextBox1")).Text; SqlDataSource3.InsertParameters["nazwisko"].DefaultValue = ((TextBox)GridView2.FooterRow.FindControl("TextBox2")).Text; SqlDataSource3.Insert(); GridView2.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { DateTime dt = DateTime.Now; SqlDataSource3.InsertParameters.Clear(); SqlDataSource3.InsertParameters.Add("storeid", Session["storeId"].ToString()); SqlDataSource3.InsertParameters.Add("comment", TextBox1.Text); SqlDataSource3.InsertParameters.Add("mail", Session["mail"].ToString()); SqlDataSource3.InsertParameters.Add("time", dt.ToString()); TextBox1.Text = ""; SqlDataSource3.Insert(); }
protected void btnZapisz_Click(object sender, EventArgs e) { SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text; SqlDataSource3.InsertCommand = "Insert into Przedmioty (nazwa,ile_godzin,typ_zajec,semestr,Specjalnosc_id_specjalnosc) VALUES (@nazwa,@ile_godzin,@typ_zajec,@semestr,@Specjalnosc_id_specjalnosc)"; SqlDataSource3.InsertParameters.Clear(); SqlDataSource3.InsertParameters.Add("nazwa", tbNazwa.Text); SqlDataSource3.InsertParameters.Add("ile_godzin", tbIleGodzin.Text); SqlDataSource3.InsertParameters.Add("typ_zajec", tbTypZajec.Text); SqlDataSource3.InsertParameters.Add("semestr", tbSemestr.Text); SqlDataSource3.InsertParameters.Add("Specjalnosc_id_specjalnosc", DropDownList1.SelectedValue.ToString()); SqlDataSource3.Insert(); Panel3.Visible = false; }
protected void Button7_Click(object sender, EventArgs e) { SqlDataSource3.InsertParameters.Clear(); SqlDataSource3.InsertParameters.Add("company_name", TextBox1.Text); SqlDataSource3.InsertParameters.Add("website", TextBox2.Text); SqlDataSource3.InsertParameters.Add("date", TextBox3.Text); SqlDataSource3.InsertParameters.Add("month", TextBox8.Text); SqlDataSource3.InsertParameters.Add("year", TextBox9.Text); SqlDataSource3.InsertParameters.Add("location", TextBox4.Text); SqlDataSource3.InsertParameters.Add("eligibility", TextBox5.Text); SqlDataSource3.InsertParameters.Add("job_roles", TextBox6.Text); SqlDataSource3.InsertParameters.Add("vacancy", TextBox7.Text); SqlDataSource3.Insert(); }
protected void InsButton_Click(object sender, EventArgs e) { try { SqlDataSource3.InsertParameters["UserId"].DefaultValue = (AddUserName.SelectedValue); SqlDataSource3.InsertParameters["CertId"].DefaultValue = (AddCertName.SelectedValue); SqlDataSource3.InsertParameters["DateCert"].DefaultValue = AddDateCal.SelectedDate.ToString("yyyy-MM-dd"); SqlDataSource3.Insert(); } catch { CertExistsError.Visible = true; } }
protected void btnAddPrescriptions_Click(object sender, EventArgs e) { string patientID = "" + gvPatients.SelectedValue; string visitID = "" + gvVisits.SelectedValue; SqlDataSource3.InsertParameters["PatientID"].DefaultValue = patientID; SqlDataSource3.InsertParameters["VisitID"].DefaultValue = visitID; SqlDataSource3.InsertParameters["DrugName"].DefaultValue = txtDrugName.Text; SqlDataSource3.InsertParameters["Instructions"].DefaultValue = txtInstructions.Text; SqlDataSource3.Insert(); txtDrugName.Text = string.Empty; txtInstructions.Text = string.Empty; }
protected void btn_insertar_Click(object sender, EventArgs e) { int cant; cant = SqlDataSource3.Insert(); if (cant == 1) { lbl_resultado.Text = "El participante se ha insertado correctamente."; } else { lbl_resultado.Text = "Se ha producido un error al insertar" + "el participante."; } }
protected void confirmBtn_Click(object sender, EventArgs e) { if (Page.IsValid) { this.GetCustomerData(); SqlDataSource2.InsertParameters["CustEmail"].DefaultValue = emailBox.Text; SqlDataSource2.InsertParameters["OrderDate"].DefaultValue = Convert.ToString(DateTime.Now); SqlDataSource2.InsertParameters["CustEmail"].DefaultValue = emailBox.Text; SqlDataSource2.InsertParameters["ShipMethod"].DefaultValue = shipList.SelectedValue; SqlDataSource2.InsertParameters["CreditCardNumber"].DefaultValue = cardBox.Text; SqlDataSource2.InsertParameters["ExpirationDate"].DefaultValue = expBox.Text; try { SqlDataSource2.Insert(); } catch (Exception ex) { Label1.Text = "A database error has occured" + "Message: " + ex.Message; } SqlDataSource3.InsertParameters["LastName"].DefaultValue = lastNameBox.Text; SqlDataSource3.InsertParameters["FirstName"].DefaultValue = firstNameBox.Text; SqlDataSource3.InsertParameters["Address"].DefaultValue = addressBox.Text; SqlDataSource3.InsertParameters["City"].DefaultValue = cityBox.Text; SqlDataSource3.InsertParameters["State"].DefaultValue = stateDdl.SelectedValue; SqlDataSource3.InsertParameters["ZipCode"].DefaultValue = zipBox.Text; SqlDataSource3.InsertParameters["PhoneNumber"].DefaultValue = phoneBox.Text; SqlDataSource3.InsertParameters["Email"].DefaultValue = emailBox.Text; try { SqlDataSource3.Insert(); } catch (Exception ex) { Label1.Text = "A database error has occured" + "Message: " + ex.Message; } } int cardNumber = Convert.ToInt32(cardBox.Text); Session["First"] = firstNameBox.Text; Session["Last"] = lastNameBox.Text; Session["Date"] = DateTime.Now; Session["Ship"] = shipList.SelectedValue; Response.Redirect("~/ShoppingPages/Receipt.aspx/"); }
protected void Button_Click(object sender, EventArgs e) { lblResult.Text = ""; SqlDataSource3.InsertParameters["FirstName"].DefaultValue = txtFirstName.Text; SqlDataSource3.InsertParameters["LastName"].DefaultValue = txtLastName.Text; SqlDataSource3.InsertParameters["DepartmentID"].DefaultValue = deptDropDownList.SelectedValue; try { SqlDataSource3.Insert(); lblResult.Text = txtFirstName.Text + " Created!"; } catch (Exception ex) { lblResult.Text = "Error" + ex.Message; } }
protected void linkInsert_Click(object sender, EventArgs e) { SqlDataSource3.InsertParameters["item_name"].DefaultValue = txtItem.Text; SqlDataSource3.InsertParameters["rate"].DefaultValue = txtRate.Text; SqlDataSource3.InsertParameters["item_type"].DefaultValue = dropItem.SelectedValue.ToString(); SqlDataSource3.InsertParameters["gross_weight"].DefaultValue = txtGross.Text; SqlDataSource3.InsertParameters["amount"].DefaultValue = txtAmount.Text; SqlDataSource3.Insert(); // Response.Write("inserter"); txtAmount.Text = ""; txtGross.Text = ""; txtItem.Text = ""; txtRate.Text = ""; }
protected void Button1_Click(object sender, EventArgs e) { try { SqlDataSource3.InsertParameters["Name"].DefaultValue = TextBox6.Text; SqlDataSource3.InsertParameters["Address"].DefaultValue = TextBox2.Text; SqlDataSource3.InsertParameters["CardNO"].DefaultValue = TextBox5.Text; SqlDataSource3.InsertParameters["Password"].DefaultValue = TextBox3.Text; SqlDataSource3.InsertParameters["BankId"].DefaultValue = DropDownList1.Text; SqlDataSource3.InsertParameters["BranchID"].DefaultValue = DropDownList2.Text; SqlDataSource3.Insert(); Label1.Text = "SUccessfully Added! , Go back To login"; } catch (Exception ex) { Label1.Text = ex.Message; } }
protected void btn2_Click(object sender, EventArgs e) { try { DataView s = (DataView)Sqlds.Select(new DataSourceSelectArguments()); int s1 = (int)s[0][0]; int s2 = (int)s[0][1]; int s3 = (int)s[0][2]; if (s1 >= int.Parse(txtArjit.Text) && s2 >= int.Parse(txtKirkod.Text) && s3 >= int.Parse(txtVaidyakiya.Text)) { int n = SqlDsHolidays.Update(); if (n == 1) { int a = SqldsRemaining.Update(); if (a == 1) { int b = SqlDataSource3.Insert(); Response.Write("<script>alert('Data Inserted Successfully')</script>"); txtArjit.Text = ""; txtKirkod.Text = ""; txtVaidyakiya.Text = ""; } else { Response.Write("<script>alert('Please enter correct details...')</script>"); } } else { Response.Write("<script>alert('Please fill the form Correctly')</script>"); } } else { Response.Write("<script>alert('You do not have enough holidays')</script>"); } } catch (Exception er) { Response.Write(er); } }
protected void btnZapiszStudenci_Click(object sender, EventArgs e) { SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text; SqlDataSource3.InsertCommand = "Insert into Studenci (imie,nazwisko,rok_urodzenia,obecnosc_dzieci,ile_dzieci,login,haslo,plec,grupa,Stypendium_id_stypendium,Katedra_id_katedra,Specjalnosc_id_specjalnosc) VALUES (@imie,@nazwisko,@rok_urodzenia,@obecnosc_dzieci,@ile_dzieci,@login,@haslo,@plec,@grupa,@Stypendium_id_stypendium,@Katedra_id_katedra,@Specjalnosc_id_specjalnosc)"; SqlDataSource3.InsertParameters.Clear(); SqlDataSource3.InsertParameters.Add("imie", tbImieStudenci.Text); SqlDataSource3.InsertParameters.Add("nazwisko", tbNazwiskoStudenci.Text); SqlDataSource3.InsertParameters.Add("rok_urodzenia", tbRokUrodzeniaStudenci.Text); SqlDataSource3.InsertParameters.Add("obecnosc_dzieci", chbObecnoscDzieciStudenci.Checked.ToString()); SqlDataSource3.InsertParameters.Add("ile_dzieci", tbIleDzieciStudenci.Text); SqlDataSource3.InsertParameters.Add("login", tbLoginStudenci.Text); SqlDataSource3.InsertParameters.Add("haslo", tbHasloStudenci.Text); SqlDataSource3.InsertParameters.Add("grupa", tbGrupaStudenci.Text); SqlDataSource3.InsertParameters.Add("plec", tbPlecStudenci.Text); SqlDataSource3.InsertParameters.Add("Stypendium_id_stypendium", ddlStypendiumStudenci.SelectedValue.ToString()); SqlDataSource3.InsertParameters.Add("Katedra_id_katedra", ddlKatedraStudenci.SelectedValue.ToString()); SqlDataSource3.InsertParameters.Add("Specjalnosc_id_specjalnosc", ddlSpecjalnoscStudenci.SelectedValue.ToString()); SqlDataSource3.Insert(); pDodajStudenci.Visible = false; }
protected void btnRegisterProduct_Click(object sender, EventArgs e) { //Validate customer ID again, as it may have been changed this.Validate("CustomerID"); if (this.IsValid) { SqlDataSource3.InsertParameters["CustomerID"].DefaultValue = txtCustomerID.Text; SqlDataSource3.InsertParameters["ProductCode"].DefaultValue = ddlSelectProduct.SelectedValue; SqlDataSource3.InsertParameters["RegistrationDate"].DefaultValue = "" + DateTime.Today; try { SqlDataSource3.Insert(); //send email SendConfirmationEmail(); txtCustomerID.Text = ""; txtCustomerID.Focus(); lblCustomerName.Text = ""; ddlSelectProduct.SelectedValue = "-1"; EnableControls(false); } catch (Exception ex) { //lblError.Text = "A database error has occurred. <br /><br />" + //"Message: " + ex.Message; Session["Exception"] = ex; Response.Redirect("~/ErrorPages/ErrorMessage.aspx"); } } else { //lblCustomerName.Text = ""; //ddlSelectProduct.SelectedValue = "-1"; //EnableControls(false); } }
protected void Insert_BT_Click(object sender, EventArgs e) { if (studentAct_TB.Text.Length == 7) { SqlDataSource3.InsertParameters["studentAct"].DefaultValue = studentAct_TB.Text; SqlDataSource3.InsertParameters["studentName"].DefaultValue = studentName_TB.Text; using (SqlConnection cnn1 = new SqlConnection(sqlcn)) { using (SqlCommand cmd1 = new SqlCommand()) { cmd1.Connection = cnn1; cmd1.CommandText = "SELECT studentAct FROM dbo.students WHERE studentAct = @studentAct"; cmd1.Parameters.Add("@studentAct", SqlDbType.NVarChar).Value = studentAct_TB.Text; cnn1.Open(); SqlDataReader rr = cmd1.ExecuteReader(); if (!rr.HasRows) { SqlDataSource3.Insert(); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('學號:" + studentAct_TB.Text + " 已存在!');</script>"); } rr.Close(); cmd1.Dispose(); cnn1.Close(); } } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('學號應為7碼,請重新輸入正確學號!');</script>"); } Clear_BT_Click(sender, e); }
protected void Button1_Click(object sender, EventArgs e) { Label1.Text = ""; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); if (view.Count > 0) { //Label1.Text = view[0][3].ToString(); if (view[0][3].ToString().ToLower() == "true") { SqlDataSource3.Update(); } else { Label1.Text = "Student #" + view[0][1].ToString() + " is already registered for class " + view[0][2].ToString(); } } else { SqlDataSource3.Insert(); } GridView1.DataBind(); }
/* * After an event is created, we need to create a page (there is a 1:1 relationship). * To do that, we attach the InsertCommand for the Page SqlDataSource to the OnInserted * event handler for the Event SqlDataSource. */ protected void SqlDataSource2_Inserted(object sender, SqlDataSourceStatusEventArgs e) { lblMessage.Text = "Event scheduled successfully!"; // e.Command.Parameters[...] returns the parameters from the completed insert, which we recycle with the Page object insert. SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text; // Creating Page object for new Event object. // NOTE: parameter names are different every time to avoid parameter confliction errors! SqlDataSource3.InsertCommand = "INSERT INTO Page (DepartmentID, EventID, Page_Title, Page_Content) VALUES (@DepID, @EvID, @PT, @PC)"; SqlDataSource3.InsertParameters.Add("DepID", e.Command.Parameters["@DID"].Value.ToString()); SqlDataSource3.InsertParameters.Add("EvID", InsertedEventID()); SqlDataSource3.InsertParameters.Add("PT", e.Command.Parameters["@ET"].Value.ToString()); SqlDataSource3.InsertParameters.Add("PC", e.Command.Parameters["@ED"].Value.ToString()); SqlDataSource3.Insert(); // Clear text boxes to help user know that the task is completed. txtStartingTime.Text = ""; txtEndingTime.Text = ""; txtEventTitle.Text = ""; txtEventDescription.Text = ""; txtLocation.Text = ""; }
protected void InsertRecord2(object sender, EventArgs e) { if (DropDownList1.Text == "") //|| DropDownList2.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Επιλέξτε Λογαριασμό !!!!');", true); } else { if (TextBox8.Text.Length == 0 || TextBox8.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Δεν έχει συμπληρωθεί το ποσό ΠΡΟΜΗΘΙΕΣ !!!!');", true); } else { SqlDataSource3.Insert(); TextBox8.Text = ""; } } }
protected void btnRegister_Click(object sender, EventArgs e) { var parameters = SqlDataSource3.InsertParameters; parameters["CustomerID"].DefaultValue = txtboxcCustID.Text; parameters["ProductCode"].DefaultValue = DropDownList1.SelectedValue; parameters["RegistrationDate"].DefaultValue = DateTime.Today.ToShortDateString(); try { SqlDataSource3.Insert(); txtboxcCustID.Text = ""; DropDownList1.SelectedIndex = -1; TextBox1.Text = ""; mailTextMsg(); //Response.Redirect("~/ProductRegistration.aspx"); } catch (Exception ex) { Session["exceptionMessage"] = ex.Message; Response.Redirect("~/ErrorMessage.aspx"); } }