Im a student a Cleveland St Uninveristy and Im working a ASP.NET Web Application that suppossed to insert a new record in a database.
I have to turn this project in next Thursday.

The application has 3 area code and 3 phone text boxes. And 1 email text box.

Im trying to insert into a database the input from these text boxes.
Im putting the data from the area text boxes and phone text boxes into an array. Then I want to loop through the arrays and insert the data into a database. Here is my code below:
variable e1 holds the email address.

Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click
        Dim myCNN As New ADODB.Connection
        Dim mySQL As String
        Dim counter As Integer
        Dim registerDate As DateTime = Today
        Dim expireDate As DateTime = Today.AddYears(5)


        myCNN.Open("DSN=MyDoNotCall")
        counter = 0
        For counter = 1 To 3
            mySQL = "Insert INTO Master(PatronEmail,AreaCode,PhoneNumber,Registrati onDate,ExpirationDate) VALUES (e1,area(counter),phone(counter),registerDate,expi reDate)"
        Next
        myCNN.Close()
        myCNN = Nothing
    End Sub

Can anyone let me know if this is the right way of doing this?
Any help would greatly appreciated.

Thanks Eric

If you are using ADO.NET, you should use the ADO.NET objects, System.Data, System.Data.SQLClient or OLEDB. You can do it that way, it's perfectly fine. you need to execute the SQL string though.

Brian

It worked but it inserted null values in the database.
The arrays that are holding my data are currently in the Page_Load Procedure.

Do I need to take them out of the Page_Load?

ersp,
When you build the string to execute on hte sever, you need to add in the variable values dynamically.
The string you are passing uses the actual variable names not their values.
try something like this.
However this assumes that they are all string values of some sort, numeric values will not require the single quotation mark around the value.
eg (" & e1 & ", instead of ('" & e1 & "',
if eq is a numeric value in the database.

You can Response.Write(mySQL ) to see what the command looks like that you are acutally sending to the Database server.
I suggest trying to write out the mySQL value now and then when you have made the chages so you can see the difference.



======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================