Web Hosting, Free Web Site Builder & Domain Name, Web Hosting Made Easy By Brinkster

Registration, Authentication, and Authorization Application Module

Added By: ttawin

Rated:

(4 of 5) by 8.

Rate Snippet: 12345

Description:

This is a registration module which is a very common component in most web application. The major features of this module include data validation, e-mail notification, database access, and user authentication and authorization. Please test and download this application at http://www22.brinkster.com/ttawin/registration/

Language: C#

Save to web space
E-mail Link

Code Snippet:

This application contains several aspx pages. The aspx below implement a
database connection for the application which allow you to execute
sql statements or a command objects.

Please test and download this application at
http://www22.brinkster.com/ttawin/registration/

==============================================

Example: save this code in page dbConnection.aspx

<%@ Page Language="C#" ClassName="DbConnection" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">

// Insert page code here
    //
    
       string connString = "";
       OleDbConnection conn;
    
       public DbConnection(string connectionString) {
           connString = connectionString;
       }
    
       public OleDbConnection GetConnection() {
           if (connString == "")
                connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" +
                    Server.MapPath("/ttawin") +
                    ConfigurationSettings.AppSettings["dbName"] + ";" +
                    "Persist Security Info=False";
           if (conn == null) conn = new OleDbConnection(connString);
           if (conn.State == ConnectionState.Closed) {
               conn.Open();
               if (conn.State != ConnectionState.Open)
                   throw(new Exception("Unable to open database connection"));
           }
           return conn;
       }
    
       public void CloseConnection() {
           if (conn != null && conn.State == ConnectionState.Open) conn.Close();
       }
    
       public OleDbDataReader GetDataReader(string sql) {
           OleDbDataReader reader = null;
           OleDbCommand cmd = new OleDbCommand(sql, GetConnection());
           try {reader = cmd.ExecuteReader();}
           catch (Exception e) {
               CloseConnection();
               throw(e);
           }
           return reader;
       }
    
       public OleDbDataReader GetDataReader(OleDbCommand cmd) {
           OleDbDataReader reader = null;
           cmd.Connection = GetConnection();
           try {reader = cmd.ExecuteReader();}
           catch (Exception e) {
               CloseConnection();
               throw(e);
           }
           return reader;
       }
    
       public int ExecuteSql(string sql) {
           int count = 0;
           OleDbCommand cmd = new OleDbCommand(sql, GetConnection());
           try {count = cmd.ExecuteNonQuery();}
           catch (Exception e) {throw(e);}
           finally {CloseConnection();}
           return count;
       }
    
       public int ExecuteSql(OleDbCommand cmd) {
           int count = 0;
           cmd.Connection = GetConnection();
           try {count = cmd.ExecuteNonQuery();}
           catch (Exception e) {throw(e);}
           finally {CloseConnection();}
           return count;
       }
    
       public override void Dispose() {
           CloseConnection();
           if (conn != null) {
               conn.Dispose();
               GC.SuppressFinalize(conn);
               conn = null;
           }
           base.Dispose();
       }

</script>

=====================================

You can reuse this class in other pages like this example:

<%@ Page Language="C#" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ reference page="dbConnection.aspx" %> //NOTE THE REFERENCE

DbConnection db = new DbConnection(); //INSTANTIATE THE COMPONENT

public int UpdateVisit(int rid) {
        OleDbCommand cmd = new OleDbCommand("update member set visited = now() where rid = ?");
        cmd.Parameters.Add("rid", OleDbType.Integer).Value = rid;
        return db.ExecuteSql(cmd); //EXECUTE THE COMMAND OBJECT
    }

</script>