No overload for method 'sphLogin' takes '2' arguments
HejJeg får følgende fejl når jeg køre mit login script.
Har fået det før og fik det løst.
Men nu siger den det igen, jeg har prøvet at være inde at rette det men det virker ikke. nogen forslag.
Server Error in '/' Application.
--------------------------------------------------------------------------------
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: CS1501: No overload for method 'sphLogin' takes '2' arguments
Source Error:
Line 7:
Line 8: System.Data.DataSet userDS = new System.Data.DataSet();
Line 9: userDS = sphLogin(UserName.Text, UserPass.Text);
Line 10:
Line 11:
Her er koden:
<%@ Page Language="C#" %>
<script runat="server">
void LoginBtn_Click(Object sender, EventArgs e) {
if (Page.IsValid) {
System.Data.DataSet userDS = new System.Data.DataSet();
userDS = sphLogin(UserName.Text, UserPass.Text);
if (userDS.Tables[0].Rows.Count == 1) {
Session["userid"] = userDS.Tables[0].Rows
[0].ItemArray[0];
FormsAuthentication.RedirectFromLoginPage
(UserName.Text, false);
}
else {
Msg.Text = "Invalid Credentials: Please try again";
}
}
}
System.Data.DataSet sphLogin(string username, string password, int memberShipClass) {
string connectionString = "server=\'sql.xxxxx.dk\'; user id=\'xxxxxx\'; password=\'xxxxxxx\'; database=\'" +
"xxxxxx\'";
System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);
string queryString = "SELECT [ssForhandler].* FROM [ssForhandler] WHERE (([ssForhandler].[KundeNr] = @username)" +
" AND ([ssForhandler].[KodeOrd] = @password)))";
System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDataParameter dbParam_username = new System.Data.SqlClient.SqlParameter();
dbParam_username.ParameterName = "@username";
dbParam_username.Value = username;
dbParam_username.DbType = System.Data.DbType.StringFixedLength;
dbCommand.Parameters.Add(dbParam_username);
System.Data.IDataParameter dbParam_password = new System.Data.SqlClient.SqlParameter();
dbParam_password.ParameterName = "@password";
dbParam_password.Value = password;
dbParam_password.DbType = System.Data.DbType.StringFixedLength;
dbCommand.Parameters.Add(dbParam_password);
System.Data.IDbDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
</script>
<html>
<form runat="server">
<h1>Forhandler login</h1>
<table>
<tr>
<td width="30"> </td>
<td><p>KundeNummer:</p></td>
<td><asp:TextBox id="UserName" runat="server" Width="100"></asp:TextBox></td>
<td><asp:RequiredFieldValidator ControlToValidate="UserName" Display="Static" ErrorMessage="*" runat="server" ID="Requiredfieldvalidator1" ForeColor="#000000"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td> </td>
<td><p>Kodeord:</p></td>
<td><asp:TextBox id="UserPass" TextMode="Password" runat="server" Width="100" Columns="2"></asp:TextBox></td>
<td><asp:RequiredFieldValidator ControlToValidate="UserPass" Display="Static" ErrorMessage="*" runat="server" ID="Requiredfieldvalidator2" ForeColor="#000000"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div align="center"><asp:button id="LoginBtn" text="Login" OnClick="LoginBtn_Click" runat="server"></asp:button></div></td>
<td> </td>
</tr>
</table>
<p><asp:Label id="Msg" ForeColor="blue" runat="server"></asp:Label></p>
</form>
</body>
</html>
