problem Updating a record in access database with a web form

Question

Hi Experts -

I have created a edit web form.  It does get populated with the appropriate record by using DataReader....
but I would like to modify/edit data and save it so it is updated in the access database.

I have created a SaveIssueButton button and put update sql statement in it.  After I change any data in the form and click save button, it doesn't save the changes...I get no errors...but the record is not updated.

Below is my 2 methods:  one at page_load I'm populating the web controls with a record.  Second method is for SaveIssuButton and what its supposed to do.

Please let me know where I might be going wrong and how to solve it.  Is it because the data i'm populating on webform is read only?  Not sure.

The Code is below:  Thanks in Advanced :)

----1
 private void Page_Load(object sender, System.EventArgs e)
    {

        if (Page.IsPostBack == false)
        {
       
        string isID = Request.QueryString["Issueid"];
        int ISID = Convert.ToInt32(isID);

        string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~\\App_Data") + "\\ISSUELOG.mdb";

        OleDbConnection cn = new OleDbConnection(connectString);

        //Open the connection.
        cn.Open();

        //Use a variable to hold the SQL statement.
        string selectString = "SELECT * FROM IssueRecordTable where IssueID="+ISID;

        OleDbCommand cmd = new OleDbCommand(selectString, cn);

        OleDbDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            IssueIDLabel.Text = reader["IssueID"].ToString();
            JobNumbertxt.Text = reader["JobNumber"].ToString();
            JobProgrammedbyddl.SelectedValue = reader["JobProgrammedby"].ToString();
            VendorProgtxt.Text = reader["VendorProgName"].ToString();
            Statuslbl.Text = reader["Status"].ToString();
            DateOfIssuetxt.Value = reader["DateofIssue"].ToString();
            IssEnteredByddl.SelectedValue = reader["IssEnteredBy"].ToString();
            ReportSourceddl.SelectedValue = reader["ReportSource"].ToString();
            ReporterNametxt.Text = reader["ReporterName"].ToString();
            IssueCategoryddl.SelectedValue = reader["IssueCategory"].ToString();
            IssueCategory2ddl.SelectedValue = reader["IssueDetailCombobox"].ToString();
            IssueCategory3ddl.SelectedValue = reader["IssueDetail2opts"].ToString();
            //OverUnderLB.Rows= reader["QuotaOU"].ToString();
            EstimatedDateTxt.Value = reader["EstimatedDate"].ToString();
            ActualDateTxt.Value = reader["ActualDate"].ToString();
            EstdTimeTxt.Text = reader["EstimatedTime"].ToString();
            ActualTimeTxt.Text = reader["ActualTime"].ToString();
            TimeLateTxt.Text= reader["TimeLate"].ToString();
            NumMinsAwayTxt.Text = reader["IssueDetail3txt"].ToString();
            SeverityLevelddl.SelectedValue= reader["SeverityLevel"].ToString();
            StdGuidVioddl.SelectedValue = reader["StnGdlViolated"].ToString();
            //ResponsibleForErrorLB.Rows = reader["CausedError"].ToString();
            ProgDollarAmounttxt.Text= reader["ProgrammingDollarAmount"].ToString();
            DataConDollarAmounttxt.Text= reader["DataConDollarAmount"].ToString();
            QADollarAmounttxt.Text= reader["QADollarAmount"].ToString();
            RespondentsAffectedtxt.Text = reader["RespondentsAffected"].ToString();
            EscalatedTotxt.Text = reader["EscalatedTo"].ToString();
            QAedddl.SelectedValue = reader["QAed"].ToString();
            //QAedByLB.SelectedValue = reader["WhoQAed"].ToString();
            WhatHappenedtxt.Text = reader["WhatHappened"].ToString();
            WhyDidItHappentxt.Text = reader["WhyDidItHappen"].ToString();
            ActionTakentxt.Text = reader["ActionTaken"].ToString();
            HowtoPreventtxt.Text= reader["HowtoPrevent"].ToString();
            CostDescriptiontxt.Text = reader["CostDescription"].ToString();
            Summarytxt.Text = reader["Summary"].ToString();
            ClosedDatetxt.Value = reader["ClosedDate"].ToString();
            IssueClosedByddl.SelectedValue = reader["ClosedUser"].ToString();
        }
   
        reader.Close();
        cn.Close();
           // MultiViewRBL.SelectedIndex = 0;
                    
        }
     
    }

-----2
protected void SaveIssueButton_Click(object sender, EventArgs e)
    {
        //Create a connection to the local NorthWind database
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~\\App_Data") + "\\ISSUELOG.mdb");
 
        con.Open();

        //Build update command
        OleDbCommand cmd = new OleDbCommand("Update IssueRecordTable Set JobNumber =@JobNumber , JobProgrammedby=@JobProgrammedby, VendorProgName=@VendorProgrammerName, Status=@Status,  DateofIssue=@DateOfIssue, IssEnteredBy=@IssueEnteredBy, ReportSource=@ReportSource, ReporterName=@ReportName, IssueCategory=@IssueCategory1, IssueDetailCombobox=@IssueDetail2, IssueDetail2opts=@IssueDetail3, QuotaOU=@OverUnder, EstimatedDate=@EstdDate, ActualDate=@ActualDate, EstimatedTime=@EstdTime, ActualTime=@ActualTime, TimeLate=@TimeLate, IssueDetail3txt=@NumberofMinutesAway, SeverityLevel=@SeverityLevel, StnGdlViolated=@StdGuidVio, CausedError=@ResponsibleforError, ProgrammingDollarAmount=@ProgDollarAmount, DataConDollarAmount=@DataConDollarAmount, QADollarAmount=@QADollarAmount, RespondentsAffected=@RespondentsAffected, EscalatedTo=@EscalatedTo, QAed=@QAed, WhoQAed=@QAby, WhatHappened=@WhatHappened, WhyDidItHappen=@WhyDiditHappen, ActionTaken=@ActionTaken, HowtoPrevent=@HowtoPrevent, CostDescription=@CostDescription, Summary=@Summary, ClosedUser=@ClosedUser, ClosedDate=@ClosedDate where IssueID = @IssueID", con);

        //Use parameters
        //=======
        OleDbParameter parIssueID = cmd.Parameters.Add("@IssueID", SqlDbType.VarChar);
        parIssueID.Value = IssueIDLabel.Text;
        OleDbParameter parJobNumber = cmd.Parameters.Add("@JobNumber", SqlDbType.VarChar);
        parJobNumber.Value = JobNumbertxt.Text;
        OleDbParameter parJobProgrammedby = cmd.Parameters.Add("@JobProgrammedby", SqlDbType.VarChar);
        parJobProgrammedby.Value = JobProgrammedbyddl.SelectedValue;
        OleDbParameter parVendorProgrammerName = cmd.Parameters.Add("@VendorProgrammerName", SqlDbType.VarChar);
        parVendorProgrammerName.Value = VendorProgtxt.Text;
        OleDbParameter parStatus = cmd.Parameters.Add("@Status", SqlDbType.VarChar);
        parStatus.Value = Statuslbl.Text;
        OleDbParameter parDateOfIssue = cmd.Parameters.Add("@DateOfIssue", SqlDbType.VarChar);
        parDateOfIssue.Value = DateOfIssuetxt.Value;
        OleDbParameter parIssueEnteredBy = cmd.Parameters.Add("@IssueEnteredBy", SqlDbType.VarChar);
        parIssueEnteredBy.Value = IssEnteredByddl.SelectedValue;
        OleDbParameter parReportSource = cmd.Parameters.Add("@ReportSource", SqlDbType.VarChar);
        parReportSource.Value = ReportSourceddl.SelectedValue;
        OleDbParameter parReportName = cmd.Parameters.Add("@ReportName", SqlDbType.VarChar);
        parReportName.Value = ReporterNametxt.Text;
        OleDbParameter parIssueCategory1 = cmd.Parameters.Add("@IssueCategory1", SqlDbType.VarChar);
        parIssueCategory1.Value = IssueCategoryddl.SelectedValue;
        OleDbParameter parIssueDetail2 = cmd.Parameters.Add("@IssueDetail2", SqlDbType.VarChar);
        parIssueDetail2.Value = IssueCategory2ddl.SelectedValue;
        OleDbParameter parIssueDetail3 = cmd.Parameters.Add("@IssueDetail3", SqlDbType.VarChar);
        parIssueDetail3.Value = IssueCategory3ddl.SelectedValue;
        OleDbParameter parOverUnder = cmd.Parameters.Add("@OverUnder", SqlDbType.VarChar);
        parOverUnder.Value = OverUnderLB.SelectedValue;
        OleDbParameter parEstdDate = cmd.Parameters.Add("@EstdDate", SqlDbType.VarChar);
        parEstdDate.Value = EstimatedDateTxt.Value;
        OleDbParameter parActualDate = cmd.Parameters.Add("@ActualDate", SqlDbType.VarChar);
        parActualDate.Value = ActualDateTxt.Value;
        OleDbParameter parEstdTime = cmd.Parameters.Add("@EstdTime", SqlDbType.VarChar);
        parEstdTime.Value = EstdTimeTxt.Text;
        OleDbParameter parActualTime = cmd.Parameters.Add("@ActualTime", SqlDbType.VarChar);
        parActualTime.Value = ActualTimeTxt.Text;
        OleDbParameter parTimeLate = cmd.Parameters.Add("@TimeLate", SqlDbType.VarChar);
        parTimeLate.Value = TimeLateTxt.Text;
        OleDbParameter parNumberofMinutesAway = cmd.Parameters.Add("@NumberofMinutesAway", SqlDbType.VarChar);
        parNumberofMinutesAway.Value = NumMinsAwayTxt.Text;
        OleDbParameter parSeverityLevel = cmd.Parameters.Add("@SeverityLevel", SqlDbType.VarChar);
        parSeverityLevel.Value = SeverityLevelddl.SelectedValue;
        OleDbParameter parStdGuidVio = cmd.Parameters.Add("@StdGuidVio", SqlDbType.VarChar);
        parStdGuidVio.Value = StdGuidVioddl.SelectedValue;
        OleDbParameter parResponsibleforError = cmd.Parameters.Add("@ResponsibleforError", SqlDbType.VarChar);
        parResponsibleforError.Value = ResponsibleForErrorLB.SelectedValue;
        OleDbParameter parProgDollarAmount = cmd.Parameters.Add("@ProgDollarAmount", SqlDbType.VarChar);
        parProgDollarAmount.Value = ProgDollarAmounttxt.Text;
        OleDbParameter parDataConDollarAmount = cmd.Parameters.Add("@DataConDollarAmount", SqlDbType.VarChar);
        parDataConDollarAmount.Value = DataConDollarAmounttxt.Text;
        OleDbParameter parQADollarAmount = cmd.Parameters.Add("@QADollarAmount", SqlDbType.VarChar);
        parQADollarAmount.Value = QADollarAmounttxt.Text;
        OleDbParameter parRespondentsAffected = cmd.Parameters.Add("@RespondentsAffected", SqlDbType.VarChar);
        parRespondentsAffected.Value = RespondentsAffectedtxt.Text;
        OleDbParameter parEscalatedTo = cmd.Parameters.Add("@EscalatedTo", SqlDbType.VarChar);
        parEscalatedTo.Value = EscalatedTotxt.Text;
        OleDbParameter parQAed = cmd.Parameters.Add("@QAed", SqlDbType.VarChar);
        parQAed.Value = QAedddl.SelectedValue;
        OleDbParameter parQAby = cmd.Parameters.Add("@QAby", SqlDbType.VarChar);
        parQAby.Value = QAedByLB.SelectedValue;
        OleDbParameter parWhatHappened = cmd.Parameters.Add("@WhatHappened", SqlDbType.VarChar);
        parWhatHappened.Value = WhatHappenedtxt.Text;
        OleDbParameter parWhyDiditHappen = cmd.Parameters.Add("@WhyDiditHappen", SqlDbType.VarChar);
        parWhyDiditHappen.Value = WhyDidItHappentxt.Text;
        OleDbParameter parActionTaken = cmd.Parameters.Add("@ActionTaken", SqlDbType.VarChar);
        parActionTaken.Value = ActionTakentxt.Text;
        OleDbParameter parHowtoPrevent = cmd.Parameters.Add("@HowtoPrevent", SqlDbType.VarChar);
        parHowtoPrevent.Value = HowtoPreventtxt.Text;
        OleDbParameter parCostDescription = cmd.Parameters.Add("@CostDescription", SqlDbType.VarChar);
        parCostDescription.Value = CostDescriptiontxt.Text;
        OleDbParameter parSummary = cmd.Parameters.Add("@Summary", SqlDbType.VarChar);
        parSummary.Value = Summarytxt.Text;
        OleDbParameter parClosedUser = cmd.Parameters.Add("@ClosedUser", SqlDbType.VarChar);
        parClosedUser.Value = IssueClosedByddl.SelectedValue;
        OleDbParameter parClosedDate = cmd.Parameters.Add("@ClosedDate", SqlDbType.VarChar);
        parClosedDate.Value = ClosedDatetxt.Value;

       //=======
   
        cmd.ExecuteNonQuery();
       
        con.Close();

    }