2 Replies - 744 Views - Last Post: 11 March 2016 - 08:39 AM

#1 Coding in the name of  Icon User is offline

  • D.I.C Regular

Reputation: 67
  • View blog
  • Posts: 291
  • Joined: 07-July 10

Web Forms, MySQL, missing/duplicate db entries

Posted 11 March 2016 - 06:05 AM

Hi everyone, I've made a web form for internal use that's meant to store its inputs in a database record. Sometimes there are duplicate entries and sometimes entries don't seem to go into the database that should. When I run the form in a browser myself things seem to work fine. The form is being presented as an iframe within another form that's run on a different server.

I'll provide more details if I can but that's about all I can figure out for now, so this may be a bit of a Hail Mary.

Thanks in advance.

Here's the code behind:
Public Class QuestionnaireForm
    Inherits System.Web.UI.Page

    ' Page loaded
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Try
            If Not IsPostBack Then
                ' Store values from query string in fields
                hidLeadID.Value = If(Request.QueryString("LeadID"), "")
                hidAgentName.Value = If(Request.QueryString("AgentName"), "")
                hidTitle.Value = If(Request.QueryString("Title"), "")
                txtCustomerFirstName.Text = If(Request.QueryString("FirstName"), "")
                txtCustomerLastName.Text = If(Request.QueryString("LastName"), "")
                hidCustomerPhone.Value = If(Request.QueryString("Phone"), "")
                txtCustomerAddress1.Text = If(Request.QueryString("Addr1"), "")
                txtCustomerAddress2.Text = If(Request.QueryString("Addr2"), "")
                txtCustomerPostcode.Text = If(Request.QueryString("Postcode"), "")

                If hidLeadID.Value <> "" Then
                    ' See if a matching lead ID can be found
                    sqlLeadData.SelectCommand = "SELECT * FROM `leaddata`.`output` WHERE `LeadID`[email protected];"
                    sqlLeadData.SelectParameters.Clear()
                    sqlLeadData.SelectParameters.Add("@LeadID", hidLeadID.Value)

                    Dim dataView As DataView = CType(sqlLeadData.Select(DataSourceSelectArguments.Empty), DataView)

                    If dataView.Table.Rows.Count > 0 Then
                        Dim row As DataRow = dataView.Table.Rows(0)

                        ' Record id of found record in view state
                        ViewState("idoutput") = row("idoutput")

                        ' Populate fields from existing data
                        rblSkyDish.SelectedValue = If(IsDBNull(row("SkyDish")), rblSkyDish.SelectedValue, row("SkyDish"))
                        rblSkyInsurance.SelectedValue = If(IsDBNull(row("SkyInsurance")), rblSkyInsurance.SelectedValue, row("SkyInsurance"))
                        drpBroadbandProvider.SelectedValue = If(IsDBNull(row("BroadbandProvider")), drpBroadbandProvider.SelectedValue, row("BroadbandProvider"))
                        rblMobileType.SelectedValue = If(IsDBNull(row("MobileType")), rblMobileType.SelectedValue, row("MobileType"))
                        drpMobileProvider.SelectedValue = If(IsDBNull(row("MobileProvider")), drpMobileProvider.SelectedValue, row("MobileProvider"))
                        rblMobileRenewalMonth.SelectedValue = If(IsDBNull(row("MobileRenewalMonth")), rblMobileRenewalMonth.SelectedValue, row("MobileRenewalMonth"))
                        rblMobileRenewalYear.SelectedValue = If(IsDBNull(row("MobileRenewalYear")), rblMobileRenewalYear.SelectedValue, row("MobileRenewalYear"))
                        rblCarInsuranceRenewalMonth.SelectedValue = If(IsDBNull(row("CarInsuranceRenewal")), rblCarInsuranceRenewalMonth.SelectedValue, row("CarInsuranceRenewal"))
                        rblHasLifeInsurance.SelectedValue = If(IsDBNull(row("HasLifeInsurance")), rblHasLifeInsurance.SelectedValue, row("HasLifeInsurance"))
                        rblHasWrittenWill.SelectedValue = If(IsDBNull(row("HasWrittenWill")), rblHasWrittenWill.SelectedValue, row("HasWrittenWill"))
                        rblPrepaidFuneral.SelectedValue = If(IsDBNull(row("FuneralPlan")), rblPrepaidFuneral.SelectedValue, row("FuneralPlan"))
                        rblHasPension.SelectedValue = If(IsDBNull(row("HasPension")), rblHasPension.SelectedValue, row("HasPension"))
                        rblCallBackTime.SelectedValue = If(IsDBNull(row("PensionAdviceTime")), rblCallBackTime.SelectedValue, row("PensionAdviceTime"))
                        rblResponsibleForEnergy.SelectedValue = If(IsDBNull(row("ResponsibleForEnergy")), rblResponsibleForEnergy.SelectedValue, row("ResponsibleForEnergy"))
                        drpElectricitySupplier.SelectedValue = If(IsDBNull(row("ElectricityProvider")), drpElectricitySupplier.SelectedValue, row("ElectricityProvider"))
                        drpGasProvider.SelectedValue = If(IsDBNull(row("GasProvider")), drpGasProvider.SelectedValue, row("GasProvider"))
                        rblEnergyPayment.SelectedValue = If(IsDBNull(row("EnergyPayment")), rblEnergyPayment.SelectedValue, row("EnergyPayment"))
                        rblChangedSupplier.SelectedValue = If(IsDBNull(row("ChangedSupplier")), rblChangedSupplier.SelectedValue, row("ChangedSupplier"))
                        rblEnergyAdvice.SelectedValue = If(IsDBNull(row("EnergyComparison")), rblEnergyAdvice.SelectedValue, row("EnergyComparison"))
                        rblHomeOwner.SelectedValue = If(IsDBNull(row("HomeOwnership")), rblHomeOwner.SelectedValue, row("HomeOwnership"))
                        rblInsulated.SelectedValue = If(IsDBNull(row("HasInsulation")), rblInsulated.SelectedValue, row("HasInsulation"))
                        rblCavityOrSolid.SelectedValue = If(IsDBNull(row("CavityOrSolid")), rblCavityOrSolid.SelectedValue, row("CavityOrSolid"))
                        txtCustomerAddress1.Text = If(IsDBNull(row("Address1")), "", row("Address1"))
                        txtCustomerAddress2.Text = If(IsDBNull(row("Address2")), "", row("Address2"))
                        txtCustomerPostcode.Text = If(IsDBNull(row("Postcode")), "", row("Postcode"))
                        drpAgeBracket.SelectedValue = If(IsDBNull(row("AgeBracket")), drpAgeBracket.SelectedValue, row("AgeBracket"))
                        drpIncomeBracket.SelectedValue = If(IsDBNull(row("HouseholdIncome")), drpIncomeBracket.SelectedValue, row("HouseholdIncome"))
                        txtMemorableWord.Text = If(IsDBNull(row("MemorableWord")), "", row("MemorableWord"))
                        rblMortgageAdvice.SelectedValue = If(IsDBNull(row("MortgageAdvice")), rblMortgageAdvice.SelectedValue, row("MortgageAdvice"))
                        rblHomeInsuranceCost.SelectedValue = If(IsDBNull(row("HomeInsuranceCost")), rblHomeInsuranceCost.SelectedValue, row("HomeInsuranceCost"))
                        rblHomeInsuranceRenewalMonth.SelectedValue = If(IsDBNull(row("HomeInsuranceRenewalMonth")), rblHomeInsuranceRenewalMonth.SelectedValue, row("HomeInsuranceRenewalMonth"))
                        rblHomeInsuranceRenewalYear.SelectedValue = If(IsDBNull(row("HomeInsuranceRenewalYear")), rblHomeInsuranceRenewalYear.SelectedValue, row("HomeInsuranceRenewalYear"))
                        rblHomeInsuranceAdvice.SelectedValue = If(IsDBNull(row("HomeInsuranceReview")), rblHomeInsuranceAdvice.SelectedValue, row("HomeInsuranceReview"))
                        drpBoilerAge.SelectedValue = If(IsDBNull(row("BoilerAge")), drpBoilerAge.SelectedValue, row("BoilerAge"))
                        rblBoilerAdvice.SelectedValue = If(IsDBNull(row("BoilerUpgrade")), rblBoilerAdvice.SelectedValue, row("BoilerUpgrade"))
                        rblConsideredSolar.SelectedValue = If(IsDBNull(row("ConsideredSolar")), rblConsideredSolar.SelectedValue, row("ConsideredSolar"))
                        txtCustomerAlternatePhone.Text = If(IsDBNull(row("CustomerAlternatePhone")), "", row("CustomerAlternatePhone"))
                    End If
                Else
                    Response.Write("Lead ID not given")
                End If
            End If
        Catch ex As Exception
            Response.Write("Exception: " & ex.Message & vbNewLine & ex.StackTrace)
        End Try
    End Sub

    ' Submit button clicked
    Protected Sub Submit(ByVal completion As String)
        Try
            If ViewState("idoutput") Is Nothing Then
                sqlLeadData.InsertCommand = "INSERT INTO `leaddata`.`output`
                                            (`idoutput`, `LeadID`, `AgentName`, `CustomerTitle`, `CustomerPhone`, `SkyDish`, `SkyInsurance`,
                                            `OptIn`, `BroadbandProvider`, `MobileType`, `MobileProvider`, `MobileRenewalMonth`, `MobileRenewalYear`,
                                            `CarInsuranceRenewal`, `HasLifeInsurance`, `HasWrittenWill`, `FuneralPlan`, `HasPension`, `PensionAdviceTime`,
                                            `ResponsibleForEnergy`, `ElectricityProvider`, `GasProvider`, `EnergyPayment`, `ChangedSupplier`, `EnergyComparison`,
                                            `HomeOwnership`, `HasInsulation`, `CavityOrSolid`, `FirstName`, `LastName`, `Address1`, `Address2`, `Postcode`,
                                            `AgeBracket`, `HouseholdIncome`, `MemorableWord`, `MortgageAdvice`, `HomeInsuranceCost`, `HomeInsuranceRenewalMonth`,
                                            `HomeInsuranceRenewalYear`, `HomeInsuranceReview`, `BoilerAge`, `BoilerUpgrade`, `ConsideredSolar`, `CustomerAlternatePhone`,
                                            `OutputDateTime`, `Completion`, `CallbackComplete`, `OnBenefits`, `InsulatedYearsAgo`, `DayOrEvening`, `AppointmentTime`)
                                            VALUES
                                            (DEFAULT, @LeadID, @AgentName, @CustomerTitle, @CustomerPhone, @SkyDish, @SkyInsurance, @OptIn, @BroadbandProvider,
                                            @MobileType, @MobileProvider, @MobileRenewalMonth, @MobileRenewalYear, @CarInsuranceRenewal, @HasLifeInsurance, @HasWrittenWill,
                                            @FuneralPlan, @HasPension, @PensionAdviceTime, @ResponsibleForEnergy, @ElectricityProvider, @GasProvider, @EnergyPayment,
                                            @ChangedSupplier, @EnergyComparison, @HomeOwnership, @HasInsulation, @CavityOrSolid, @FirstName, @LastName, @Address1,
                                            @Address2, @Postcode, @AgeBracket, @HouseholdIncome, @MemorableWord, @MortgageAdvice, @HomeInsuranceCost, @HomeInsuranceRenewalMonth,
                                            @HomeInsuranceRenewalYear, @HomeInsuranceReview, @BoilerAge, @BoilerUpgrade, @ConsideredSolar, @CustomerAlternatePhone, @OutputDateTime,
                                            @Completion, @CallbackComplete, NULL, NULL, NULL, NULL);"

                sqlLeadData.InsertParameters.Clear()
                sqlLeadData.InsertParameters.Add("@LeadID", hidLeadID.Value)
                sqlLeadData.InsertParameters.Add("@AgentName", hidAgentName.Value)
                sqlLeadData.InsertParameters.Add("@CustomerTitle", hidTitle.Value)
                sqlLeadData.InsertParameters.Add("@CustomerPhone", hidCustomerPhone.Value)
                sqlLeadData.InsertParameters.Add("@SkyDish", rblSkyDish.SelectedValue)
                sqlLeadData.InsertParameters.Add("@SkyInsurance", rblSkyInsurance.SelectedValue)
                sqlLeadData.InsertParameters.Add("@OptIn", rblOptIn.SelectedValue)
                sqlLeadData.InsertParameters.Add("@BroadbandProvider", drpBroadbandProvider.SelectedValue)
                sqlLeadData.InsertParameters.Add("@MobileType", rblMobileType.SelectedValue)
                sqlLeadData.InsertParameters.Add("@MobileProvider", drpMobileProvider.SelectedValue)
                sqlLeadData.InsertParameters.Add("@MobileRenewalMonth", rblMobileRenewalMonth.SelectedValue)
                sqlLeadData.InsertParameters.Add("@MobileRenewalYear", rblMobileRenewalYear.SelectedValue)
                sqlLeadData.InsertParameters.Add("@CarInsuranceRenewal", rblCarInsuranceRenewalMonth.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HasLifeInsurance", rblHasLifeInsurance.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HasWrittenWill", rblHasWrittenWill.SelectedValue)
                sqlLeadData.InsertParameters.Add("@FuneralPlan", rblPrepaidFuneral.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HasPension", rblHasPension.SelectedValue)
                sqlLeadData.InsertParameters.Add("@PensionAdviceTime", rblCallBackTime.SelectedValue)
                sqlLeadData.InsertParameters.Add("@ResponsibleForEnergy", rblResponsibleForEnergy.SelectedValue)
                sqlLeadData.InsertParameters.Add("@ElectricityProvider", drpElectricitySupplier.SelectedValue)
                sqlLeadData.InsertParameters.Add("@GasProvider", drpGasProvider.SelectedValue)
                sqlLeadData.InsertParameters.Add("@EnergyPayment", rblEnergyPayment.SelectedValue)
                sqlLeadData.InsertParameters.Add("@ChangedSupplier", rblChangedSupplier.SelectedValue)
                sqlLeadData.InsertParameters.Add("@EnergyComparison", rblEnergyAdvice.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HomeOwnership", rblHomeOwner.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HasInsulation", rblInsulated.SelectedValue)
                sqlLeadData.InsertParameters.Add("@CavityOrSolid", rblCavityOrSolid.SelectedValue)
                sqlLeadData.InsertParameters.Add("@FirstName", txtCustomerFirstName.Text)
                sqlLeadData.InsertParameters.Add("@LastName", txtCustomerLastName.Text)
                sqlLeadData.InsertParameters.Add("@Address1", txtCustomerAddress1.Text)
                sqlLeadData.InsertParameters.Add("@Address2", txtCustomerAddress2.Text)
                sqlLeadData.InsertParameters.Add("@Postcode", txtCustomerPostcode.Text)
                sqlLeadData.InsertParameters.Add("@AgeBracket", drpAgeBracket.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HouseholdIncome", drpIncomeBracket.SelectedValue)
                sqlLeadData.InsertParameters.Add("@MemorableWord", txtMemorableWord.Text)
                sqlLeadData.InsertParameters.Add("@MortgageAdvice", rblMortgageAdvice.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HomeInsuranceCost", rblHomeInsuranceCost.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HomeInsuranceRenewalMonth", rblHomeInsuranceRenewalMonth.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HomeInsuranceRenewalYear", rblHomeInsuranceRenewalYear.SelectedValue)
                sqlLeadData.InsertParameters.Add("@HomeInsuranceReview", rblHomeInsuranceAdvice.SelectedValue)
                sqlLeadData.InsertParameters.Add("@BoilerAge", drpBoilerAge.SelectedValue)
                sqlLeadData.InsertParameters.Add("@BoilerUpgrade", rblBoilerAdvice.SelectedValue)
                sqlLeadData.InsertParameters.Add("@ConsideredSolar", rblConsideredSolar.SelectedValue)
                sqlLeadData.InsertParameters.Add("@CustomerAlternatePhone", txtCustomerAlternatePhone.Text)
                sqlLeadData.InsertParameters.Add("@OutputDateTime", ToUnixTimestamp(Now))
                sqlLeadData.InsertParameters.Add("@Completion", completion)
                sqlLeadData.InsertParameters.Add("@CallbackComplete", "0")

                sqlLeadData.Insert()
            Else
                sqlLeadData.UpdateCommand = "UPDATE `leaddata`.`output` SET
                                            `LeadID`[email protected], `AgentName`[email protected], `CustomerTitle`[email protected], `CustomerPhone`[email protected], `SkyDish`[email protected], `SkyInsurance`[email protected],
                                            `OptIn`[email protected], `BroadbandProvider`[email protected], `MobileType`[email protected], `MobileProvider`[email protected], `MobileRenewalMonth`[email protected], `MobileRenewalYear`[email protected],
                                            `CarInsuranceRenewal`[email protected], `HasLifeInsurance`[email protected], `HasWrittenWill`[email protected], `FuneralPlan`[email protected], `HasPension`[email protected], `PensionAdviceTime`[email protected],
                                            `ResponsibleForEnergy`[email protected], `ElectricityProvider`[email protected], `GasProvider`[email protected], `EnergyPayment`[email protected], `ChangedSupplier`[email protected], `EnergyComparison`[email protected],
                                            `HomeOwnership`[email protected], `HasInsulation`[email protected], `CavityOrSolid`[email protected], `FirstName`[email protected], `LastName`[email protected], `Address1`[email protected], `Address2`[email protected], `Postcode`[email protected],
                                            `AgeBracket`[email protected], `HouseholdIncome`[email protected], `MemorableWord`[email protected], `MortgageAdvice`[email protected], `HomeInsuranceCost`[email protected], `HomeInsuranceRenewalMonth`[email protected],
                                            `HomeInsuranceRenewalYear`[email protected], `HomeInsuranceReview`[email protected], `BoilerAge`[email protected], `BoilerUpgrade`[email protected], `ConsideredSolar`[email protected], `CustomerAlternatePhone`[email protected],
                                            `OutputDateTime`[email protected], `Completion`[email protected]
                                            WHERE `idoutput`[email protected];"

                sqlLeadData.UpdateParameters.Clear()
                sqlLeadData.UpdateParameters.Add("@LeadID", hidLeadID.Value)
                sqlLeadData.UpdateParameters.Add("@AgentName", hidAgentName.Value)
                sqlLeadData.UpdateParameters.Add("@CustomerTitle", hidTitle.Value)
                sqlLeadData.UpdateParameters.Add("@CustomerPhone", hidCustomerPhone.Value)
                sqlLeadData.UpdateParameters.Add("@SkyDish", rblSkyDish.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@SkyInsurance", rblSkyInsurance.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@OptIn", rblOptIn.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@BroadbandProvider", drpBroadbandProvider.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@MobileType", rblMobileType.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@MobileProvider", drpMobileProvider.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@MobileRenewalMonth", rblMobileRenewalMonth.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@MobileRenewalYear", rblMobileRenewalYear.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@CarInsuranceRenewal", rblCarInsuranceRenewalMonth.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HasLifeInsurance", rblHasLifeInsurance.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HasWrittenWill", rblHasWrittenWill.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@FuneralPlan", rblPrepaidFuneral.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HasPension", rblHasPension.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@PensionAdviceTime", rblCallBackTime.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@ResponsibleForEnergy", rblResponsibleForEnergy.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@ElectricityProvider", drpElectricitySupplier.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@GasProvider", drpGasProvider.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@EnergyPayment", rblEnergyPayment.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@ChangedSupplier", rblChangedSupplier.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@EnergyComparison", rblEnergyAdvice.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HomeOwnership", rblHomeOwner.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HasInsulation", rblInsulated.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@CavityOrSolid", rblCavityOrSolid.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@FirstName", txtCustomerFirstName.Text)
                sqlLeadData.UpdateParameters.Add("@LastName", txtCustomerLastName.Text)
                sqlLeadData.UpdateParameters.Add("@Address1", txtCustomerAddress1.Text)
                sqlLeadData.UpdateParameters.Add("@Address2", txtCustomerAddress2.Text)
                sqlLeadData.UpdateParameters.Add("@Postcode", txtCustomerPostcode.Text)
                sqlLeadData.UpdateParameters.Add("@AgeBracket", drpAgeBracket.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HouseholdIncome", drpIncomeBracket.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@MemorableWord", txtMemorableWord.Text)
                sqlLeadData.UpdateParameters.Add("@MortgageAdvice", rblMortgageAdvice.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HomeInsuranceCost", rblHomeInsuranceCost.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HomeInsuranceRenewalMonth", rblHomeInsuranceRenewalMonth.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HomeInsuranceRenewalYear", rblHomeInsuranceRenewalYear.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@HomeInsuranceReview", rblHomeInsuranceAdvice.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@BoilerAge", drpBoilerAge.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@BoilerUpgrade", rblBoilerAdvice.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@ConsideredSolar", rblConsideredSolar.SelectedValue)
                sqlLeadData.UpdateParameters.Add("@CustomerAlternatePhone", txtCustomerAlternatePhone.Text)
                sqlLeadData.UpdateParameters.Add("@OutputDateTime", ToUnixTimestamp(Now))
                sqlLeadData.UpdateParameters.Add("@Completion", completion)
                sqlLeadData.UpdateParameters.Add("@idoutput", ViewState("idoutput"))

                sqlLeadData.Update()
            End If

            ' Reset input states
            ViewState("idoutput") = Nothing
            Session("ViewState") = Nothing
        Catch ex As Exception
            Response.Write("Exception: " & ex.Message & vbNewLine & ex.StackTrace)
        End Try
    End Sub

    Protected Sub btnSale_Click(sender As Object, e As EventArgs) Handles btnSale.Click
        Submit("Sale")
    End Sub

    Protected Sub btnSurveyFullyComplete_Click(sender As Object, e As EventArgs) Handles btnSurveyFullyComplete.Click
        Submit("Survey fully complete")
    End Sub

    Protected Sub btnSurveyPartComplete_Click(sender As Object, e As EventArgs) Handles btnSurveyPartComplete.Click
        Submit("Survey partially complete")
    End Sub
End Class


PS. I've double-checked the MySQL account that the form uses to connect has all the necessary permissions (select, insert, update) and doesn't have any restrictions on no. connections made or anything like that.

Update: As far as the duplicate entries we think it may have been users double-clicking submit buttons.

This post has been edited by Coding in the name of: 11 March 2016 - 06:30 AM


Is This A Good Question/Topic? 0
  • +

Replies To: Web Forms, MySQL, missing/duplicate db entries

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 13562
  • View blog
  • Posts: 54,110
  • Joined: 12-June 08

Re: Web Forms, MySQL, missing/duplicate db entries

Posted 11 March 2016 - 07:44 AM

Why not just use a SQLCommand object?
Was This Post Helpful? 0
  • +
  • -

#3 Coding in the name of  Icon User is offline

  • D.I.C Regular

Reputation: 67
  • View blog
  • Posts: 291
  • Joined: 07-July 10

Re: Web Forms, MySQL, missing/duplicate db entries

Posted 11 March 2016 - 08:39 AM

I'm still new to this so I was going with what worked. When I was interacting with an Access database I used the VS GUI to set things up and it made SqlDataSource's. I'll add it to the todo list.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1