Insert new record in Access DB from aspx page

[ajap99]

I am using a datalist to display one entry in Access DB.
I want to enter new values into the textboxes on datalist and hit a submit button to insert new record in DB
I can do this when with the following code

strInsert = "INSERT INTO Bookings (StartDate, NoWeeks, Available) VALUES ( '09/09/1999', '3', '1')"

But I want to read the values from the asp text boxes.
Below is the asp textbox entries in the HTML on the page


<asp:TextBox id="tbstartDate" Text='<%# DataBinder.Eval(Container.DataItem, "StartDate") %>' Font-Size="Medium" runat="server" Width="73px" Font-Bold="True"></asp:TextBox>

<asp:TextBox id="tbNoWeeks" Text='<%# DataBinder.Eval(Container.DataItem, "NoWeeks") %>' Font-Size="Medium" runat="server" Width="73px" Font-Bold="True"></asp:TextBox>

<asp:TextBox id="tbAvailable" Text='<%# DataBinder.Eval(Container.DataItem, "Available") %>' Font-Size="Medium" runat="server" Width="73px" Font-Bold="True"></asp:TextBox>

How can I read the values entered into the textboxes into the 'INSERT' statement

 

[ca8msm]

strInsert = "INSERT INTO Bookings (StartDate, NoWeeks, Available) VALUES ( '" & tbstartDate.Text & "', '" & tbNoWeeks.Text & "', '" & tbAvailable.Text & "')"

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ajap99]

When I use that code the following Compiler error Message is displayed

BC30451:name 'tbStartDate' is not declared

 

[ca8msm]

If you are using VS there should be a line within the "Web Form Designer Generated Code" section that looks like:

Protected WithEvents tbStartDate As System.Web.UI.WebControls.TextBox

If you are not using VS, you may have to add the line yourself.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ca8msm]

Oops - I just read that the Textboxes are in a DataList. Ignore that last post - you will have to use the FindControl method within your DataList to find the Textboxes.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ajap99]

The following message is displayed

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object

Fails at
strInsert = "INSERT INTO Bookings (StartDate) VALUES ( '" & tbstartDate.Text & "')"

I am just using webmatrix to compile code

I put the Protected WithEvents etc just under where I Dim connection to database - Is this OK

 

[ajap99]

How would I use the find control method ?

 

[ca8msm]

http://msdn.microsoft.com/library/d...ynamicallyindatalistwebcontrolvisualbasic.asp

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.