Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL

AmitGajjar

Rate me:

4.87/5 (21 votes)

17 Aug 2012CPOL8 min read

253.8K

17.3K

Create, Read, Update and Delete operations in ASP.Net with MySQL database with N-Tier Architecture

CRUD_Database.zip
- CRUD Database.sql
CRUD.zip
- CRUD
  - BAL
    - BAL.csproj
    - BALCountry.cs
    - bin
      - Debug
        
        BAL.dll
        
        BAL.pdb
        
        DAL.dll
        
        DAL.pdb
        
        MySql.Data.dll
        
        PROP.dll
        
        PROP.pdb
      - Release
    - obj
      - Debug
        
        BAL.csproj.FileListAbsolute.txt
        
        BAL.dll
        
        BAL.pdb
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        ResolveAssemblyReference.cache
        
        TempPE
    - Properties
      - AssemblyInfo.cs
  - Bin
    - MySql.Data.dll
  - CRUD.sln
  - CRUD.sln.docstates.suo
  - CRUD.suo
  - CRUD
    - App_Data
    - bin
      - BAL.dll
      - BAL.pdb
      - CRUD.dll
      - CRUD.pdb
      - DAL.dll
      - DAL.pdb
      - Logging.dll
      - Logging.pdb
      - MySql.Data.dll
      - PROP.dll
      - PROP.pdb
    - CRUD.csproj
    - CRUD.csproj.user
    - Default.aspx
    - Default.aspx.cs
    - Default.aspx.designer.cs
    - Global.asax
    - Global.asax.cs
    - obj
      - Debug
        
        CRUD.csproj.FileListAbsolute.txt
        
        CRUD.dll
        
        CRUD.pdb
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        ResolveAssemblyReference.cache
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - Scripts
    - Site.Master
    - Site.Master.cs
    - Site.Master.designer.cs
    - Styles
      - Site.css
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - DAL
    - bin
      - Debug
        
        DAL.dll
        
        DAL.pdb
        
        MySql.Data.dll
        
        PROP.dll
        
        PROP.pdb
      - Release
    - DAL.csproj
    - DALCountry.cs
    - obj
      - Debug
        
        DAL.csproj.FileListAbsolute.txt
        
        DAL.dll
        
        DAL.pdb
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        ResolveAssemblyReference.cache
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - SQLHelper.cs
  - Logging
    - bin
      - Debug
        
        DAL.dll
        
        DAL.pdb
        
        Logging.dll
        
        Logging.pdb
        
        MySql.Data.dll
        
        PROP.dll
        
        PROP.pdb
      - Release
    - clsLogging.cs
    - Logging.csproj
    - obj
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        Logging.csproj.FileListAbsolute.txt
        
        Logging.dll
        
        Logging.pdb
        
        ResolveAssemblyReference.cache
        
        TempPE
    - Properties
      - AssemblyInfo.cs
  - PROP
    - bin
      - Debug
        
        PROP.dll
        
        PROP.pdb
      - Release
    - obj
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        PROP.csproj.FileListAbsolute.txt
        
        PROP.dll
        
        PROP.pdb
        
        TempPE
    - PROP.csproj
    - PROPCountry.cs
    - Properties
      - AssemblyInfo.cs

D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\obj\Debug\ResolveAssemblyReference.cache
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\bin\Debug\DAL.dll
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\bin\Debug\DAL.pdb
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\bin\Debug\MySql.Data.dll
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\obj\Debug\DAL.dll
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\obj\Debug\DAL.pdb
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\bin\Debug\PROP.dll
D:\IMPORTANT DATA\project\CRUD\CRUD\DAL\bin\Debug\PROP.pdb

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

AmitGajjar

Software Developer (Senior)

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL

License

Comments and Discussions