	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.8

ASP.NET 3.5 login page (C#)

Asked by haramsde in Programming for ASP.NET, Microsoft Visual C#.Net

Tags: C#

Hi experts

I'm trying to create a login page that will authenticate users that are in a SQL Server 2005 database. I'm creating the login page in Visual Studio 2008 Professional Edition (Trial Version).

The login page is fine, it's the class that is authenticating the user that I'm having problems with. It has given me errors with my case statement amongst other things and I'm not sure how to correct it.
Any help would be greatly appreciated.

Thanks

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:

           
           
             Login page:
 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="SmartLearner.Login" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Secure Site</title>    
    <meta content="Microsoft Visual Studio 7.0" name="GENERATOR"/>    
    <meta content="C#" name="CODE_LANGUAGE"/>    
    <meta content="JavaScript" name="vs_defaultClientScript"/>    
    <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"/>  
    </head>  
    <body>    
    <form id="login" method="post" runat="server">      
    <table cellspacing="0" cellpadding="0" border="0">      
    <tr>        
    <td valign="top" align="left">          
    <asp:label id="Message" runat="server" ForeColor="#ff0000">          
    </asp:label>        
    </td>      
    </tr>      
    <tr>        
    <td valign="top" align="left">          
    <b>E-mail:</b>        
    </td>      
    </tr>      
    <tr>        
    <td valign="top" align="left">          
    <asp:textbox id="username" runat="server" Width="120">          
    </asp:textbox>        
    </td>      
    </tr>      
    <tr>        
    <td valign="top" align="left">          
    <b>Password:</b>        
    </td>      
    </tr>      
    <tr>        
    <td valign="top" align="left">          
    <asp:textbox id="password" runat="server" Width="120" textMode="Password">          
    </asp:textbox>        
    </td>      
    </tr>      
    <tr>        
    <td valign="top" align="left">          
    <asp:checkbox id="saveLogin" runat="server" text="<b>Save my login</b>">          
    </asp:checkbox>        
    </td>      
    </tr>      
    <tr>        
    <td valign="top" align="right">          
        &nbsp;</td>      
    </tr>      
    </table>    
        <asp:Button ID="btnLogin" runat="server" text="Login" />
    </form>  
    </body>
</html>
 
Class:
 
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
 
namespace SmartLearner
{
    public class CCommonDB: CSql  {public CCommonDB() : base() { }    
        public string AuthenticateUser(      
            System.Web.SessionState.HttpSessionState objSession, // Session Variable      
            System.Web.HttpResponse objResponse,                 // Response Variable      
            string email,                                        // Login      
            string password,                                     // Password      
            bool bPersist                                        // Persist login      
            )    
        {      
            int nLoginID  = 0;      
            int nLoginType  = 0;      // Log the user in      
            Login(email, password, ref nLoginID, ref nLoginType);      
            if(nLoginID != 0)  // Success      
            {        // Log the user in        
                System.Web.Security.FormsAuthentication.SetAuthCookie(nLoginID.ToString(), bPersist);        
                // Set the session varaibles            
                objSession["loginID"]  = nLoginID.ToString();        
                objSession["loginType"] = nLoginType.ToString();        
                // Set cookie information incase they made it persistant        
                System.Web.HttpCookie wrapperCookie = new System.Web.HttpCookie("wrapper");        
                wrapperCookie.Value = objSession["wrapper"].ToString();        
                wrapperCookie.Expires = DateTime.Now.AddDays(30);              
                System.Web.HttpCookie lgnTypeCookie = new System.Web.HttpCookie("loginType");        
                lgnTypeCookie.Value = objSession["loginType"].ToString();        
                lgnTypeCookie.Expires = DateTime.Now.AddDays(30);        
                // Add the cookie to the response        
                objResponse.Cookies.Add(wrapperCookie);        
                objResponse.Cookies.Add(lgnTypeCookie);        
                return "/default.aspx";          
            }          
            case 1:  // Admin Login          
            {            
                return "/Admin.aspx";          
            }          
            case 2:  // Staff Login          
            {            
                return "/Staff.aspx";          
            }          
            default:          
            {            
                return string.Empty;          
            }        
        }      
    }      
    else      
{        
    return string.Empty;      
}    
}    
/// <summary>    
/// Verifies the login and password that were given    
/// </summary>    
/// <param name="email">the login</param>    
/// <param name="password">the password</param>    
/// <param name="nLoginID">returns the login id</param>    
/// <param name="nLoginType">returns the login type</param>    
 
    public void Login(string email, string password, ref int nLoginID, ref int nLoginType)    
{      ResetSql();      
DataSet ds = new DataSet();      
// Set our parameters      
SqlParameter paramLogin = new 
SqlParameter("@username", SqlDbType.VarChar, 100);      paramLogin.Value = email;      SqlParameter paramPassword = new SqlParameter("@password", SqlDbType.VarChar, 20);      paramPassword.Value = password;      
 
Command.CommandType = CommandType.StoredProcedure;      
Command.CommandText = "glbl_Login";      
Command.Parameters.Add(paramLogin);      
Command.Parameters.Add(paramPassword);      
 
Adapter.TableMappings.Add("Table", "Login");      
Adapter.SelectCommand = Command;      
Adapter.Fill(ds);      
if(ds.Tables.Count != 0)      
{        
    DataRow row = ds.Tables[0].Rows[0];        
// Get the login id and the login type        
nLoginID  = Convert.ToInt32(row["Login_ID"].ToString());        
nLoginType  = Convert.ToInt32(row["Login_Type"].ToString());      
}      
else      
{        
nLoginID = 0;        
nLoginType = 0;      
}    
}  
}
}
abstract public class CSql  
{    
private SqlConnection sqlConnection;      // Connection string    
private SqlCommand sqlCommand;          // Command    
private SqlDataAdapter sqlDataAdapter;      // Data Adapter          
private DataSet sqlDataSet;            // Data Set    
public CSql()    
{      
sqlConnection  = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);      
sqlCommand    = new SqlCommand();      
sqlDataAdapter  = new SqlDataAdapter();      
sqlDataSet    = new DataSet();      
sqlCommand.Connection = sqlConnection;    
}    
/// <summary>    
/// Access to our sql command    
/// </summary>    
protected SqlCommand Command    
{      
    get { return sqlCommand; }    }    
/// <summary>    
/// Access to our data adapter    
/// </summary>    
protected SqlDataAdapter Adapter    
{      
    get { return sqlDataAdapter; }    }    
/// <summary>    
/// Makes sure that everything is clear and ready for a new query    
/// </summary>    
 
protected void ResetSql()    
{      
    if(sqlCommand != null)      
{        sqlCommand = new SqlCommand();        
sqlCommand.Connection = sqlConnection;      
}      
    if(sqlDataAdapter != null)        
sqlDataAdapter = new SqlDataAdapter();      
if(sqlDataSet != null)        
sqlDataSet = new DataSet();    }    
 
/// <summary>    
/// Runs our command and returns the dataset    
/// </summary>    
/// <returns>the data set</returns>    
protected DataSet RunQuery()    
{      
sqlDataAdapter.SelectCommand = Command;      
sqlConnection.Open();      
sqlConnection.Close();      
sqlDataAdapter.Fill(sqlDataSet);      
return sqlDataSet;    }  
}
}
           
         

20091118-EE-VQP-93 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. abel981,693
2. guru_sami764,050
3. TheLearn...530,855
4. CodeCruiser439,606
5. nmarun431,054
6. GiftsonDJ...364,715
7. aibusines...314,444
8. Juan_Bar...310,594
9. x_com306,380
10. Dhaest300,866
11. jinal294,858
12. CB_Thiru...294,313
13. carlnorrbom258,132
14. davrob60252,917
15. sunithnair237,805
16. DropZone234,070
17. praveenv...232,932
18. prairiedog220,925
19. burakiewicz216,947
20. daveamour215,055
21. Omego2K213,665
22. ragi0017208,315
23. HainKurt206,459
24. angelIII201,692
25. wht1986186,866

1. TheLearn...3,568,317
2. samtran0...2,728,399
3. raterus2,081,290
4. nauman_...1,216,228
5. sammy1...1,193,317
6. Rejojohny1,121,409
7. abel1,016,343
8. mmarinov996,221
9. scolja962,242
10. prairiedog921,362
11. Dhaest793,214
12. guru_sami764,050
13. angelIII759,102
14. Juan_Bar...648,279
15. lem2802634,188
16. AerosSaga600,606
17. TimCottee580,519
18. pratima_...579,106
19. Edwin_C568,753
20. CodeCruiser542,665
21. x_com530,881
22. tusharashah517,701
23. Justin_W489,746
24. strickdd487,968
25. carl_tawn470,356

ASP.NET 3.5 login page (C#)

Asked by haramsde in Programming for ASP.NET, Microsoft Visual C#.Net

Tags: C#

About this solution