Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neojapanese
Starting Member
13 Posts |
 Posted - 2006-03-03 : 16:03:00
|
| Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30456: 'AddWithValue' is not a member of 'System.Data.SqlClient.SqlParameterCollection'.Line 29: cmdSelect.Parameters.AddWithValue("@username", txtUsername.Text)this is my code is here below_______________<%@ Page Language="VB" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.SqlClient" %><%@ Import Namespace="System.Threading" %><Script Runat="Server">Sub Button_Click( s As Object, e As EventArgs ) Dim conMyData As SqlConnection Dim cmdSelect As SqlCommand Dim parmReturnValue As SqlParameter Dim intResult As Integer 'Server=cedantsql1.cedant.com;uid=NYREIDB;pwd=sushiboy;database=neojapanese1_NYREIDB If IsValid Then conMyData = New SqlConnection("hidden") cmdSelect = New SqlCommand("DBRegister", conMyData) 'GetParam cmdSelect.CommandType = CommandType.StoredProcedure parmReturnValue = cmdSelect.Parameters.Add( "RETURN_VALUE", SqlDbType.Int ) parmReturnValue.Direction = ParameterDirection.ReturnValue 'cmdSelect = New SqlCommand( "GetParam" , conMMTMP) 'cmd.Parameters.AddWithValue("@CategoryName", category) cmdSelect.Parameters.AddWithValue("@username", txtUsername.Text) 'cmdSelect.Parameters.AddWithValue("@username", txtUsername.Text) cmdSelect.Parameters.AddWithValue("@password", txtPassword.Text) conMyData.Open() cmdSelect.ExecuteNonQuery() intResult = cmdSelect.Parameters( "RETURN_VALUE" ).Value conMyData.Close() If intResult = - 1 Then lblMessage.Text = "Username Already Registered!" Else FormsAuthentication.RedirectFromLoginPage( txtUsername.Text, False ) End If End IfEnd Sub</Script><html><head><title>Register.aspx</title></head><body><form Runat="Server"><h2>Please Register</h2><p><b>Login information:</b> </p><asp:Label ID="lblMessage" ForeColor="Red" Font-Bold="True" EnableViewState="False" Runat="Server" /><p><b>Username:</b><br><asp:TextBox ID="txtUsername" Runat="Server" /><asp:RequiredFieldValidator Text="Required!" Runat="Server" /><p><b>Password:</b><br><asp:TextBox ID="txtPassword" Runat="Server" /><asp:RequiredFieldValidator Text="Required!" Runat="Server" /><p> <p><b>Personal information:</b></form><p><b>First Name:</b><br><asp:TextBox ID="txtFN" Runat="Server" /><asp:RequiredFieldValidator Text="Required!" Runat="Server" /></p><p><b>Last Name:</b><br><asp:TextBox ID="txtLN" Runat="Server" /><asp:RequiredFieldValidator Text="Required!" Runat="Server" /></p><p><b>Email:</b><br><asp:TextBox ID="txtUsername2" Runat="Server" /><asp:RequiredFieldValidator Text="Required!" Runat="Server" /></p><p> </p><p><asp:Button Text="Register!" OnClick="Button_Click" Runat="Server" /></p><p> </p></body></html> |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-03 : 16:18:36
|
| Your code doesn't seem to be Transact-SQL.You should post your question on the ASP.NET forum.CODO ERGO SUM |
 |
|
|
|
|
|
Compiler Error Message: BC30456: 'AddWithValue'