Murray Brown
asked on
ASP.net SQL Parameter Query errors
Hi.
I have written the parameter query shown ithe code below but am getting the following errors:
Error 1 Argument not specified for parameter 'Parameter3' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'. C:\Users\User\Documents\Vi sual Studio 2010\Projects\GC\GC\Page1. aspx.vb 24 9 GC
Error 2 Argument not specified for parameter 'Parameter4' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'. C:\Users\User\Documents\Vi sual Studio 2010\Projects\GC\GC\Page1. aspx.vb 24 9 GC
Error 3 Argument not specified for parameter 'Parameter5' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'. C:\Users\User\Documents\Vi sual Studio 2010\Projects\GC\GC\Page1. aspx.vb 24 9 GC
Error 4 Argument not specified for parameter 'Parameter6' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'. C:\Users\User\Documents\Vi sual Studio 2010\Projects\GC\GC\Page1. aspx.vb 24 9 GC
Error 5 Argument not specified for parameter 'Parameter7' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'. C:\Users\User\Documents\Vi sual Studio 2010\Projects\GC\GC\Page1. aspx.vb 24 9 GC
Error 6 Argument not specified for parameter 'Parameter8' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'. C:\Users\User\Documents\Vi sual Studio 2010\Projects\GC\GC\Page1. aspx.vb 24 9 GC
I have written the parameter query shown ithe code below but am getting the following errors:
Error 1 Argument not specified for parameter 'Parameter3' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'.
Error 2 Argument not specified for parameter 'Parameter4' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'.
Error 3 Argument not specified for parameter 'Parameter5' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'.
Error 4 Argument not specified for parameter 'Parameter6' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'.
Error 5 Argument not specified for parameter 'Parameter7' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'.
Error 6 Argument not specified for parameter 'Parameter8' of 'Public Overridable Overloads Function GetDataBy(Parameter1 As String, Parameter2 As String, Parameter3 As String, Parameter4 As String, Parameter5 As String, Parameter6 As String, Parameter7 As String, Parameter8 As String) As DataSet1.Table1DataTable'.
SELECT ID, School, [User], [Start date], [Start time], [End date], [End time], Form, House, [Subject or activity], [Age Group], [Sport or activity], Other, [Use]
FROM Table1
WHERE (Other LIKE @Parameter1 + '%') AND (School = @Parameter2) AND (USER = @Parameter3) AND (Form = @Parameter4) AND (House = @Parameter5) AND
([Subject or activity] = @Parameter6) AND ([Age Group] = @Parameter7) AND ([Sport or activity] = @Parameter8)
Could you please attach screen shot of the exact error?
ASKER
SELECT ID, School, [User], [Start date], [Start time], [End date], [End time], Form, House, [Subject or activity], [Age Group], [Sport or activity], Other, [Use]
FROM Table1
WHERE (Other LIKE @Parameter1 + '%') AND (School = @Parameter2) AND (USER = @Parameter3) AND (Form = @Parameter4) AND (House = @Parameter5) AND
([Subject or activity] = @Parameter6) AND ([Age Group] = @Parameter7) AND ([Sport or activity] = @Parameter8)
FROM Table1
WHERE (Other LIKE @Parameter1 + '%') AND (School = @Parameter2) AND (USER = @Parameter3) AND (Form = @Parameter4) AND (House = @Parameter5) AND
([Subject or activity] = @Parameter6) AND ([Age Group] = @Parameter7) AND ([Sport or activity] = @Parameter8)
the asp.net relevant part of the code, please
ASKER
Protected Sub btnSeeSpecificCalendarItem s_Click(By Val sender As Object, ByVal e As EventArgs) Handles btnSeeSpecificCalendarItem s.Click
Try
Dim DS1Adapter As New DataSet1TableAdapters.Tabl e1TableAda pter
Dim oSchool As Object
If Me.School_DropDownList.Sel ectedValue = "N/A" Then
oSchool = System.DBNull.Value
Else : oSchool = Me.School_DropDownList.Sel ectedValue
End If
GridView1.DataSource = DS1Adapter.GetDataBy("Rugb y")
GridView1.DataBind()
Catch ex As Exception
MsgBox("There was an error loading data! " & Err.Description)
End Try
End Sub
Try
Dim DS1Adapter As New DataSet1TableAdapters.Tabl
Dim oSchool As Object
If Me.School_DropDownList.Sel
oSchool = System.DBNull.Value
Else : oSchool = Me.School_DropDownList.Sel
End If
GridView1.DataSource = DS1Adapter.GetDataBy("Rugb
GridView1.DataBind()
Catch ex As Exception
MsgBox("There was an error loading data! " & Err.Description)
End Try
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The line where I pass the variable was the issue. thanks
visibly, you did not yet code the part to assign the parameters to the command.