Page.IsValid

[Caden]

Hey tek-tips, i'm having a bit of trouble, hope you can help.

I'm trying to make a simple guestboot in ASP, 3 fields, name, email, and message, here's the function to insert info into the database

Function InsertGuestbookEntry(ByVal guestbookEntriesID As Integer, ByVal name As String, ByVal email As String, ByVal message As String) As Integer
Dim connectionString As String = "server='(local)'; user id='sa'; password='starwars'; database='ASPexamples'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "INSERT INTO [GuestbookEntries] ([GuestbookEntriesID], [Name], , [Message],"& _
" [Date]) VALUES (@GuestbookEntriesID, @Name, @Email, @Message, getdate())"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dbParam_guestbookEntriesID As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_guestbookEntriesID.ParameterName = "@GuestbookEntriesID"
dbParam_guestbookEntriesID.Value = guestbookEntriesID
dbParam_guestbookEntriesID.DbType = System.Data.DbType.Int32
dbCommand.Parameters.Add(dbParam_guestbookEntriesID)
Dim dbParam_name As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_name.ParameterName = "@Name"
dbParam_name.Value = name
dbParam_name.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_name)
Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_email.ParameterName = "@Email"
dbParam_email.Value = email
dbParam_email.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_email)
Dim dbParam_message As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_message.ParameterName = "@Message"
dbParam_message.Value = message
dbParam_message.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_message)

Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try

Return rowsAffected
End Function


That works no problem...

then I add the Page.IsValid fucntion

Sub btnSubmit_Click(sender As Object, e As EventArgs)
if Page.IsValid then
InsertGuestbookEntry(name.text, email.text, message.text)
Response.Redirect("ViewGuestbook.aspx")
End If
End Sub

and this is the error I get...

Compiler Error Message: BC30455: Argument not specified for parameter 'message' of 'Public Function InsertGuestbookEntry(guestbookEntriesID As Integer, name As String, email As String, message As String) As Integer'.

If I remove message.text it tells me the same thing for email.text, if I remove email.text it still gives me the email error it doesn't ever give me a name.text error.

I don't know how to fix this...thanks

Caden

 

[BoulderBum]

You ask for 4 arguments, but you only provided 3 with:

InsertGuestbookEntry(name.text, email.text, message.text)

Try passing the guestbookEntriesID as the first argument.

[COLOR=blue gainsboro]
Get a FREE iPod by helping me get mine! Click my referrer link:

http://www.freeiPods.com/default.aspx?referer=8158886

More about the company and deal:

http://www.wired.com/news/mac/0,2125,64614,00.html?tw=wn_2culthead

[/color]