Click here to Skip to main content
15,894,646 members
Articles / Web Development / ASP.NET

Custom Data Layer for ASP.NET With MySQL

Rate me:
Please Sign up or sign in to vote.
4.40/5 (7 votes)
13 Dec 2007CPOL 46.8K   2K   38  
Data access layer for MySQL based web projects.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TestWebApplication._Default" %>

<!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>Asp.Net With MySql</title>
</head>
<body>
    <form id="form1" runat="server">
        
        <table width="50%" align="center" border="1">
           <tr>
               <td align="center">
                    <b>Asp.Net With MySql</b>
               </td> 
           </tr>     
         </table>
         <br />
         <br />   
       <table width="50%" align="center" border="1">
           <tr>
               <td align="center">
                    <b>Employee Details</b>
               </td> 
           </tr>     
           <tr>    
               <td>
                    <asp:GridView ID="grdViewEmployee" runat="server" Width="100%" AutoGenerateColumns=false>
                    <Columns >
                    <asp:BoundField DataField="Id" HeaderText="Id"/>
                    <asp:BoundField DataField="Emp_Name" HeaderText="Employee Name"/>
                    <asp:BoundField DataField="Emp_Age" HeaderText="Employee Age"/>
                    <asp:TemplateField HeaderText = "Join Date">
                        <ItemTemplate >
                            <asp:Label ID="lblJoinDate" runat="server" Text='<%# Bind("Emp_JoinDate","{0:dd/MM/yyyy}")%>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    </Columns>
                    </asp:GridView>
               </td>  
           </tr> 
       </table>                  
       <br />
       <br />
       <table width="50%" align="center" border="1">
           <tr>
               <td align="center">
                    <b>Get Employee Name</b>
               </td> 
           </tr>     
           <tr>    
               <td>Enter Id
                    <asp:TextBox ID="txtEmpId" runat="server"></asp:TextBox>
                    <asp:Button ID="btnEmployee" runat="server" Text="Get Name" OnClick="btnEmployee_Click" />
                    <asp:Label ID="lblEmpName" runat="server" Text=""></asp:Label>         
               </td>  
           </tr> 
           <tr>    
               <td>&nbsp;</td>  
           </tr>
           </table>
           <br />
           <br /> 
           <table width="50%" align="center" border="1">
           <tr>
               <td align="center">
                    <b>Update Employee Name</b>
               </td> 
           </tr>     
           <tr>    
               <td>Enter Name
                    <asp:TextBox ID="txtEName" runat="server"></asp:TextBox>
                   Enter Id.
                    <asp:TextBox ID="txtEId" runat="server"></asp:TextBox>
                </td>      
           </tr>      
           <tr>
                    <td align=center><asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="Update"/></td>
           </tr>     
       </table>                  
       <br />
       <br />
          
   </form>
</body>
</html>

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
Software Developer
India India
Having 3.5 years of work experience in software development.

Good knowledge of software development lifecycle, active involvement in development, testing and support.

Earned several Dot Net certified credentials from Brian Bench and Microsoft like MCPD, MCTS MCAD.

Comments and Discussions