Hi,
I'm trying to have a login page; after logging in the user has to see the list of SQL Server Databases available to him/her. I'm always getting the error
'ASP.login_aspx ' does not contain a definition for 'btnSignIn_Clic k'
I have the btnSignIn_Click function defined in a codebehind .cs file - The file name is Connect.aspx.cs . I made a DLL and have that DLL in the Bin subfolder (Bin\Connect.dl l).
Here's the command I used for making the dll -
C:\Inetpub\wwwr oot\xml\dotnet> csc /out:Connect.dll /r:System.dll,Sy stem.web.dll,Sy stem.Data.dll /t:library Connect.aspx.cs
Here's the code I wrote for Connect.aspx.cs
/*************** *************** *************** *************** *************** *******/
using System;
using System.Web;
using System.Data.Com mon;
using System.Data.Sql Client;
using System.Data.Sql Types;
/// <summary>
/// Description of Class1.
/// </summary>
public class Connect : System.Web.UI.P age
{
public System.Web.UI.W ebControls.Text Box txtLogin;
public System.Web.UI.W ebControls.Requ iredFieldValida tor RFVLogin;
public System.Web.UI.W ebControls.Text Box txtPassword;
public System.Web.UI.W ebControls.Requ iredFieldValida tor RFVPassword;
public System.Web.UI.W ebControls.Butt on btnSignIn;
public System.Web.UI.W ebControls.Labe l Msg;
protected void Page_Load(objec t sender, EventArgs e){
if(!IsPostBack) {
Msg.Text = "Welcome. Enter your SQL Server user-name and password.";
}
}
protected void btnSignIn_Click (object Sender, EventArgs e){
if(Page.IsValid ){
Session["uid"]=txtLogin.Text;
Session["pwd"]=txtPassword.Te xt;
SqlConnection conn = new SqlConnection(" server=localhos t;uid=" + txtLogin.Text + ";pwd=" + txtPassword.Tex t);
try {
conn.Open();
SqlCommand strsql = new SqlCommand("SEL ECT name FROM master.dbo.sysd atabases WHERE has_dbaccess(na me) = 1 ORDER BY name ", conn);
SqlDataReader myreader;
myreader = strsql.ExecuteR eader();
}
catch(SqlExcept ion sqlerr) {
Msg.Text=sqlerr .ToString();
}
}
}
}
/*************** *************** *************** *************** *************** *******/
<pre>
<!--Here's the code page from where I'm referring this codebehind part. login.aspx ------------>
<%@ Page Language="c#" codebehind="Con nect.aspx.cs" Trace="True" %>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<form runat="server">
<h2>Login Page
</h2>
<hr size="1" />
<table>
<tbody>
<tr>
<td>
Username:</td>
<td>
<asp:TextBox id="txtLogin" runat="server"> </asp:TextBox>
</td>
<td>
<asp:RequiredFi eldValidator id="RFVLogin" runat="server" ErrorMessage="* " Display="Static " ControlToValida te="UserName"> </asp:RequiredFie ldValidator>
</td>
</tr>
<tr>
<td>
Password:</td>
<td>
<asp:TextBox id="txtPassword " runat="server" TextMode="Passw ord"></asp:TextBox>
</td>
<td>
<asp:RequiredFi eldValidator id="RFVPassword " runat="server" ErrorMessage="* " Display="Static " ControlToValida te="UserPass"> </asp:RequiredFie ldValidator>
</td>
</tr>
</tbody>
</table>
<asp:Button id="btnSignIn" onclick="btnSig nIn_Click" Text="Sign In" Runat="server"> </asp:Button>
<p>
<asp:Label id="Msg" runat="server" forecolor="red" ></asp:Label>
</p>
</form>
</body>
</html>
<!---------------------------------------------------->
</pre>
Can you please tell me what is causing that error ? I've been breaking my head asking everyone, and Googling everything I can.
Thank you.
