Param dataGrid Question

Why does this Sub program work well with ASP.NET Web MAtrix and gives
ERROR when compiled in VS.NET 2003 :-
"Prepared statement '(@dotnet.itags.org.State nvarchar(2))select * from Authors where
state = @dotnet.itags.org.State' expects parameter @dotnet.itags.org.State, which was not supplied."
The error comes at line :-
MyCommand.SelectCommand.Parameters("@dotnet.itags.org.State").Value = MySelect.Value
Sub GetAuthors_Click(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
Dim SelectCommand As String = "select * from Authors where state
= @dotnet.itags.org.State"
MyConnection = New
SqlConnection("server=(local);database=pubs;integrated security=true;")
MyCommand = New SqlDataAdapter(SelectCommand, MyConnection)
MyCommand.SelectCommand.Parameters.Add(New
SqlParameter("@dotnet.itags.org.State", SqlDbType.NVarChar, 2))
MyCommand.SelectCommand.Parameters("@dotnet.itags.org.State").Value =
MySelect.Value
DS = new DataSet()
MyCommand.Fill(DS, "Authors")
MyDataGrid.DataSource=DS.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End SubOops found my error with VS.NET i needed to declare
<select id="MySelect" runat="server" name="MySelect">
like
Protected MySelect As System.Web.UI.HtmlControls.HtmlSelect
Which u musn't do in ASP.NET WebMAtrix..
Patrick
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

> Why does this Sub program work well with ASP.NET Web MAtrix and gives
> ERROR when compiled in VS.NET 2003 :-
> "Prepared statement '(@.State nvarchar(2))select * from Authors where
> state = @.State' expects parameter @.State, which was not supplied."
> The error comes at line :-
> MyCommand.SelectCommand.Parameters("@.State").Value = MySelect.Value
>
> Sub GetAuthors_Click(Sender As Object, E As EventArgs)
> Dim DS As DataSet
> Dim MyConnection As SqlConnection
> Dim MyCommand As SqlDataAdapter
> Dim SelectCommand As String = "select * from Authors where state
> = @.State"
> MyConnection = New
> SqlConnection("server=(local);database=pubs;integrated security=true;")
> MyCommand = New SqlDataAdapter(SelectCommand, MyConnection)
> MyCommand.SelectCommand.Parameters.Add(New
> SqlParameter("@.State", SqlDbType.NVarChar, 2))
> MyCommand.SelectCommand.Parameters("@.State").Value =
> MySelect.Value
> DS = new DataSet()
> MyCommand.Fill(DS, "Authors")
> MyDataGrid.DataSource=DS.Tables("Authors").DefaultView
> MyDataGrid.DataBind()
> End Sub
User submitted from AEWNET (http://www.aewnet.com/)