Problem with updating database based on user input

b_clodius · May 28th, 2010, 03:11 PM

Let me explain what i am trying to do.

I am creating a number of webforms that allow a building manager to receive forms from managers requesting for equipment, offices, etc for new employees or existing employees. In one webform the building manager can click a GetForm button that will get the information from a MS Access Database and show the form with all the data filled out based on what was saved by a manager. If the building manager wants to change something he clicks a button to enable all the controls and can change any textbox or checkbox on the page. After that he/she clicks an Update button that calls a function that grabs the params and updates the database. However when update is clicked nothing is updated but no errors are thrown. In MS Access I tested the query and it works. What could i be missing?

Source Page(edited out some params to make more readable):

Code:

                <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/aDatabase.mdb" 
        SelectCommand="SELECT * FROM [Requests]"
        UpdateCommand="UPDATE [Requests] SET [Requester Name] = ?, //...some 60 params later [Special Instructions] = ? WHERE [ID] = ?">
        <UpdateParameters>
            <asp:FormParameter Name="Requester Name"  />
              //...some 60 params later
            <asp:FormParameter Name="Special Instructions"  />
            <asp:Parameter Name="ID"  />
        </UpdateParameters>
    </asp:AccessDataSource>

Code Behind Update Button Click:

Code:

    protected void btn_update_Click(object sender, EventArgs e)
    {
        GridView1.Enabled = false;
       

        string eN = Request.QueryString["form"];
        string dE = decryptQueryString(eN);


        AccessDataSource1.UpdateParameters["Requester Name"].DefaultValue = txb_rqstname.Text;
        AccessDataSource1.UpdateParameters["Special Instructions"].DefaultValue = txbx_SpecialInstructions.Text;
        AccessDataSource1.UpdateParameters["ID"].DefaultValue = dE;

        for (int x = 0; x < 60; x++)
        {
            //debug       Response.Write(AccessDataSource1.UpdateParameters[x].DefaultValue + " ");
        }

        AccessDataSource1.Update();
        //Response.Redirect("UpdateSuccessful.aspx");
    }

Imar · May 28th, 2010, 06:26 PM

Hi there,

Two things you could look into:

1. Do very simply updates work? That is, are you sure you can write to the database?

2. Is the WHERE clause OK? Do you assign it a valid ID?

3. Do all your parameters match? Because of the index based nature of Access queries you may have missed one and never assign the ID.....

Cheers,

Imar

b_clodius · June 1st, 2010, 12:10 PM

Woohoo I got it!

Thanks for the suggestions Imar, i had already done them but did them again, after further investigation and realization that nothing was changing i fixed the PageLoad event by wrapping all the code in a !PostBack and that did the trick.

Thanks again