User Id :    Password :      New Member   Forgot Password  
 
On-line Address Book in ASP.NET 2.0
Description This is a small project on On Line Address Book. This small project will be very useful for those who are going to start or new in ASP.NET.   No. of Views     17906
  Rating     3
Author Rahul Saxena   Posted On     09 Aug 2011
Tags .NET 2.0    

Sample Code   Download Code

This is an on-line address book project. Learn with this small project how to develop an application using .net 2.0. Those who are new to ASP.NET or going for first project can learn a lot from this. This is a project to keep the address and other information. In our daily life we meet many people and we have to keep the information and addresses of these people. This project is very useful to keep the record.

To use this project just change the connection string.

 Welcome.aspx
 

<body>

  <form id="form1" runat="server">

    <div>

      <table cellpadding="0" cellspacing="0" width="100%"    

                background="BackGround.jpg">

        <tr><td align="center">

              <asp:Label ID="lblWelcome" runat="server" 
                       Text="Welcome In On Line Address Book" 

                     Font-Bold="true"  Font-Size="22pt"  ForeColor="#6600ff"> </asp:Label>

            </td></tr>

            <tr><td>&nbsp;</td></tr>

            <tr><td align="center">

                  <asp:Label ID="lblDoAddress" runat="server" 
                                     Text="Do Your Address On Line" Font-Bold="true" 

                         ForeColor="#33cccc"  Font-Size="14pt"></asp:Label>

                 </td></tr>

            <tr><td height="50px">&nbsp;</td></tr>

            <tr><td align="center">

                  <asp:ImageButton ID="Imgm" ImageUrl="~/case2-a.gif" runat="server" OnClick="StartAddress" />

                </td></tr>

            <tr><td>&nbsp;</td></tr>

            <tr><td align="center">

                  <asp:Label ID="lblAddress" runat="server" Text="(Address Book)" Font-Bold="true" ForeColor="#000099" 
                            Font-Size="16pt"></asp:Label>

                </td></tr>

            <tr><td height="190px"></td></tr>

            <tr><td>&nbsp;&nbsp; &nbsp;&nbsp; <asp:Button ID="btnAddressBook" runat="server" 
                            Text="Go Inside The Address Book" BackColor="#ff9900" Height="45px" OnClick="btnInside_Click" />

            </td></tr>

           

      </table>

      <table background="BackGround.jpg" cellpadding="0" cellspacing="0" width="100%"> 

        <tr><td align="right">

              <asp:Label ID="lblName" runat="server" Text="Rahul Saxena" Font-Bold="true" Font-Size="16pt" 

                 ForeColor="#6600ff"></asp:Label><br /><br />

              <asp:Label ID="lblEmail" runat="server" Text="Email: 14rahulsaxena@gmail.com" Font-Bold="true" 

                           Font-Size="14pt"   ForeColor="#6600ff"></asp:Label>

            </td><td width="5%"></td></tr>

        <tr><td Height="43px"></td></tr>

      </table>    

    </div>

  </form>

</body>

The  window will be:

Figure 1: Welcome window.

Welcome.aspx.cs is:

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

 

public partial class Welcome : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }


    protected void btnInside_Click(object sender, EventArgs e)

    {

        Response.Redirect("AllRecord.aspx");

    }


    protected void StartAddress(object sender, ImageClickEventArgs e)

    {

        Response.Redirect("AllRecord.aspx");

    }

}

AllRecord.aspx

<body>

  <form id="form1" runat="server">

    <div>

      <table cellpadding="0" cellspacing="0" width="90%" border="0" height="100%">

        <tr><td width="10px"></td><td><asp:Image ID="imageContact" runat="server"  ImageUrl="~/clip1-c.gif"/>
         </td></tr>

        <tr><td width="10px"></td><td width="90%"  background="BackGround.jpg" align="left">
                  &nbsp; &nbsp; &nbsp;&nbsp;

              <asp:Button ID="btnSubmit" runat="server" Text="Add New Address" OnClick="btnSubmit_Click" /> 
                          &nbsp; &nbsp; &nbsp; &nbsp;
              <asp:Button ID="btnSearch"  runat="server" Text="Search A Address"  OnClick="SearchRecord" />
                            &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;

              <asp:Image ID="ImgMove" runat="server" ImageUrl="~/ball1-a.gif" />

              <asp:Label ID="lblSearch" Text="All Address" runat="server" Font-Bold="true"  ForeColor="#ff6600"
                          Font-Size="16pt"> </asp:Label>

                 &nbsp; &nbsp; &nbsp; &nbsp;

             <asp:Image ID="ImgDate" runat="server" ImageUrl="~/hourglass-b.gif" />

             <asp:Label ID="lblShowTime" runat="server" Text="Date" Font-Bold="true"> </asp:Label>
                    &nbsp; &nbsp;

             <asp:Label ID="lbltime" runat="server"></asp:Label>

           </td></tr>

        <tr><td height="5px"></td></tr>

        <tr><td width="10px"></td>

             <td><table background="BackGround.jpg"  cellpadding="0" cellspacing="0" height="100%"
                     border="0" width="100%">

                   <tr><td height="25px"></td></tr>

                   <tr><td width="10px"></td><td align="center" >

                         <asp:DataGrid ID="GridAllRecord" runat="server"  AutoGenerateColumns="false" Width="90%" 
                            DataKeyField="ID" PagerStyle-HorizontalAlign ="Center"  BorderStyle="ridge" GridLines="Both"

                                BorderWidth="2px" BorderColor ="white" BackColor="white" CellPadding="3" CellSpacing="1" 

                                OnEditCommand="EditAddress"  OnDeleteCommand="AddressDelete" 

                                OnItemCommand="Grid_ItemCommand" AllowSorting="true" PageSize=5 

                                OnPageIndexChanged="GridAllRecord_PageIndexChanged" AllowPaging="true">

                         <FooterStyle ForeColor="Black" BackColor="#C6C3C6"></FooterStyle>

                         <HeaderStyle Font-Bold="True" ForeColor="#FFFFFF" BackColor="#A53A6A"></HeaderStyle>

                         <FooterStyle BackColor="beige" />

                         <PagerStyle Font-Bold="true" Mode=NumericPages Font-Underline="true"/>

                         <Columns>

                           <asp:BoundColumn DataField=ID HeaderText="ID" Visible="false">

                             <ItemStyle BackColor="graytext" />

                             <HeaderStyle BackColor="graytext" />

                           </asp:BoundColumn>

                        

                           <asp:TemplateColumn HeaderText="First Name">

                             <ItemTemplate>

                               <asp:LinkButton ID="lnkName" runat="server"  Text='<%#DataBinder.Eval

                                   (Container.DataItem,"FirstName") %>' CommandName="RecordShow"> </asp:LinkButton>

                             </ItemTemplate>

                           </asp:TemplateColumn>            

                           

                           <asp:BoundColumn DataField=LastName HeaderText="Last Name">

                             <ItemStyle BackColor=GhostWhite />

                           </asp:BoundColumn>                

                           

                           <asp:BoundColumn DataField=PersonelEmail HeaderText="Personnel(EMail)">

                             <ItemStyle BackColor=GhostWhite />

                           </asp:BoundColumn>          

                           

                           <asp:BoundColumn DataField=Mobile HeaderText="Mobile">

                             <ItemStyle BackColor=GhostWhite />

                           </asp:BoundColumn>    

                              

                           <asp:EditCommandColumn EditText="Edit Address" HeaderText="Edit Address"> 

                 </asp:EditCommandColumn>       

                           <asp:ButtonColumn  CommandName="DeleteAddress" HeaderText="Delete Address" 

                                  Text="Delete"></asp:ButtonColumn>

                         </Columns>    

                      </asp:DataGrid>

                    </td>

                  </tr>

                <tr><td height="25px"></td></tr>

              </table></td></tr>

           <tr><td height="15px"></td></tr>

         <%-- <tr><td width="10px"></td><td><asp:Label ID="lblTotalRegisterartion" runat="server" 
                   Text="Total Registered Address :"></asp:Label><asp:Label ID="lblRegistered"     

                                                 runat="server"></asp:Label></td></tr>--%>

       </table>    

     </div>

    </form>

  </body>

AllRecord.aspx.cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

 

public partial class AllRecord : System.Web.UI.Page

{

    string connect = @"Data Source=MCN0100;Initial Catalog=AddressBook; Uid=sa; Pwd="; 

    SqlConnection con;

    SqlCommand cmd = new SqlCommand();

    SqlDataAdapter da;

    DataSet ds = new DataSet();

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            rebind();

            string Time = DateTime.Now.Date.ToShortDateString();

            lbltime.Text = Time;

            //TotalUsers();

        }

    }

 

    public void rebind()

    {

        con = new SqlConnection(connect);

        cmd.CommandText = "select ID,FirstName,LastName, Mobile, PersonelEmail from record";

        da = new SqlDataAdapter(cmd);

        cmd.Connection = con;

        da.Fill(ds);

        con.Open();

        cmd.ExecuteNonQuery();

        GridAllRecord.DataSource = ds;

        GridAllRecord.DataBind();

    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        Response.Redirect("Register.aspx");

    }

 

    protected void Grid_ItemCommand(object sender, DataGridCommandEventArgs e)

    {

        if (e.CommandName == "RecordShow")

        {

            int Rep_Id = int.Parse(e.Item.Cells[0].Text);

            Session["ID"] = Rep_Id;

            Response.Redirect("ShowSelectedRecord.aspx");

        }

        if (e.CommandName == "DeleteAddress")

        {

            con = new SqlConnection(connect);

            int UpadteAddress = int.Parse(e.Item.Cells[0].Text);

            cmd.CommandText = "delete from Record where ID=" + UpadteAddress;

            cmd.Connection = con;

            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();           

            GridAllRecord.EditItemIndex=-1;

            rebind();                    

        }

    }

 

    protected void SearchRecord(object sender, EventArgs e)

    {

        Response.Redirect("Search.aspx");

    }

 

    public void GridAllRecord_PageIndexChanged(object source, DataGridPageChangedEventArgs e)

    {

        GridAllRecord.CurrentPageIndex = e.NewPageIndex;

        rebind();

    }

 

    public void EditAddress(object ssender, DataGridCommandEventArgs e)

    {

        int UpadteAddress = int.Parse(e.Item.Cells[0].Text);

        Session["UpadteAddressID"] = UpadteAddress;

        Response.Redirect("LoginCheck.aspx");

    }

 

    public void AddressDelete(object sender, DataGridCommandEventArgs e)

    {

        con = new SqlConnection(connect);

        int UpadteAddress = int.Parse(e.Item.Cells[0].Text);

        cmd.CommandText = "delete from Record where ID=" + UpadteAddress;

        cmd.Connection = con;

        con.Open();

        cmd.ExecuteNonQuery();

        con.Close();       

        GridAllRecord.EditItemIndex=-1;

        rebind();

    } 

 

    //public void TotalUsers()

    //{

    //    con = new SqlConnection(connect);

    //    cmd.CommandText = "select  *  from Record";

    //    da = new SqlDataAdapter(cmd);

    //    da.Fill(ds);

    //    cmd.Connection = con;

    //    con.Open();

    //    cmd.ExecuteNonQuery();

    //    int TotalUser = int.Parse(ds.Tables[0].Rows.Count.ToString());

    //    lblRegistered.Text = TotalUser.ToString();

    //    con.Close();

    //}

}

 The output of the application:

Figure 2: All Record.

Register.aspx

<body>

  <form id="form1" runat="server">

    <div>

      <table cellpadding="0" cellspacing="0" width="90%" border="0" align=center>

        <tr><td>

          <table cellpadding="0" cellspacing="0" width="80%" align="center" border="4" background=BackGround.jpg>

            <tr><td align="center"><asp:Label ID="lblWelcome" Text="Welcome On Line Address Book" runat="server" 
                    Font-Bold="true" Font-Size="14pt" ForeColor="black"> </asp:Label>

                 </td></tr>   

             <tr><td><marquee bgcolor="#ff9900" behavior="alternate">

                   <asp:Label ID="lblInformationfill" runat="server" Text="Please Fill The Information" ForeColor="#0000ff"
                     Font-Bold="true"> </asp:Label> </marquee>

                 </td></tr>

             <tr><td><asp:Label ID="lblRecordAdded" runat="server" Visible="false" ForeColor="Red">
                           </asp:Label> </td> </tr>

              <tr><td>
              &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;     

                &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 

                          <asp:Label ID="lbltitle" runat="server" Text="Select Title" Width="100" Font-Bold="true"> 

                            </asp:Label>

                   <asp:DropDownList ID="listTitle" runat="server">

                     <asp:ListItem Value="Select">--Select--</asp:ListItem>

                     <asp:ListItem Value="Mr">Mr</asp:ListItem>

                     <asp:ListItem Value="Ms">Ms</asp:ListItem>

                   </asp:DropDownList>
                &nbsp;&nbsp; &nbsp; &nbsp; &nbsp

  </td></tr>              

               <tr><td align="center" style="height: 233px">

                    <table cellpadding="0" cellspacing="0" width="80%" border="0">

                      <tr><td align="center">

                        <table>                          

                          <tr><td><marquee> <asp:Label ID="lblPersonnelInformation" runat="server"  
                                                             Text="Personnel Information" Font-Bold="True" ForeColor=ActiveCaption>

                                 </asp:Label> </marquee>

                                </td></tr>

                          <tr><td align="left"><asp:Label ID="lblFirstNmae" Text="First Name" runat="server" Width="100px" 

                                                                ForeColor=ActiveCaption> </asp:Label>

                                                      <asp:TextBox ID="txtFirstName" runat="server"> </asp:TextBox>

                               </td></tr>

                            <tr><td align="left"><asp:Label ID="lblMiddleName" Text="Middle Name" runat="server" Width="100px" 

                                                   ForeColor=ActiveCaption> </asp:Label>

                                                      <asp:TextBox ID="txtMiddleName" runat="server"></asp:TextBox>

                                </td></tr>

                            <tr><td align="left"> <asp:Label ID="lblLastName" Text="Last Name" runat="server" Width="100px" 

                                                               ForeColor=ActiveCaption> </asp:Label>

                                                 <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>

                                 </td></tr>

                            <tr><td align="left"> <asp:Label ID="lblHomePhone" Text="Home Phone" runat="server" 
                                                        Width="100px" ForeColor=ActiveCaption> </asp:Label>

                                    <asp:TextBox ID="txtHomePhone" runat="server"></asp:TextBox>

                            </td></tr>

                            <tr><td align="left"><asp:Label ID="lblMobile" Text="Mobile" runat="server" Width="100px" 

                                   ForeColor=ActiveCaption> </asp:Label>

                                                <asp:TextBox ID="txtMobile" runat="server"></asp:TextBox>

                                 </td></tr>                            

                            <tr><td align="left"><asp:Label ID="lblPersonelEmail" Text="Email" runat="server" Width="100px" 

                                           ForeColor=ActiveCaption>  </asp:Label>

                                                <asp:TextBox ID="txtPersonnelEmail" runat="server"></asp:TextBox>

                            </td></tr>

                         </table></td>

                         <td>

                           <table>

                              <tr><td><marquee><asp:Label ID="lblOfficeInformation" runat="server" Text="Official Information"  
                                       Font-Bold="True" ForeColor="Chocolate"> </asp:Label> </marquee> </td> </tr>

                              <tr><td align="left"><asp:Label ID="lblCompany" Text="Company" runat="server" Width="100px" 

                                          ForeColor="Chocolate"> </asp:Label>

                                   <asp:TextBox ID="txtCompany" runat="server"></asp:TextBox>

                                   </td></tr>

                            

                               <tr><td align="left"><asp:Label ID="lblJobTitle" Text="Job Title" runat="server" Width="100px" 

                                                                         ForeColor="Chocolate"> </asp:Label>

                                                    <asp:TextBox ID="txtJobTitle" runat="server"></asp:TextBox>

                                    </td></tr>

                               <tr><td align="left"><asp:Label ID="lblWebSite" Text="Web Site" runat="server" Width="100px" 

                                                                       ForeColor="Chocolate"></asp:Label>

                                                    <asp:TextBox ID="txtWebSite" runat="server"></asp:TextBox>

                                     </td></tr>

                               <tr><td align="left"><asp:Label ID="lblOfficePhone" Text="OfficePhone" runat="server" 
                                             Width="100px"   Color="Chocolate"> </asp:Label>

                                                    <asp:TextBox ID="txtOfficePhone" runat="server"></asp:TextBox>

                                    </td></tr>                            

                               <tr><td align="left"><asp:Label ID="lblFax" Text="Fax" runat="server" Width="100px" 

                                                                           ForeColor="Chocolate"> </asp:Label>

                                                    <asp:TextBox ID="txtFax" runat="server"></asp:TextBox>

                              </td></tr>

                            

                              <tr><td align="left"><asp:Label ID="lblOfficeEmail" Text="Office Email"  runat="server" ></asp:Label>

                          <asp:TextBox ID="txtOfficeEmail" runat="server"></asp:TextBox>

                                      </td></tr> 

                        </table></td>

                       </tr> 

                    </table></td></tr>

                        

                  <tr><td> 
                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                       <asp:Label ID="lblAddress" runat="server" Text="Address" ForeColor=ActiveCaption> </asp:Label> 

                             &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                        <asp:TextBox ID="txtAddress" runat="server" TextMode="MultiLine"> </asp:TextBox>
                    </td></tr>      

                  <tr><td align="center" style="height: 52px">
                        <asp:Button ID="btnSubmitRecord" runat="server" Text="Submit" Height="40px" 
                                 OnClick="btnSubmit_Click" Width="200px"/>

                       &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

                       <asp:ImageButton ID="ImageMain" runat="server" ImageUrl="~/5ar04a.gif" OnClick="Main_Click"  
                                ToolTip="Click Here To Go On All Record"/>

             </td></tr>

           </table>

        </td></tr> 

      </table>

     </div>

    </form>

</body>

Register.aspx.cs

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

 

public partial class _Default : System.Web.UI.Page 

{

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

 

    SqlConnection con;

    SqlCommand cmd = new SqlCommand();

    string connection = @"Data Source=MCN0100;Initial Catalog=AddressBook; Uid=sa; Pwd=";    

 

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        if (txtFirstName.Text !="" && txtLastName.Text !="")

        {

            InserRecord();

            txtFirstName.Text = "";

            txtLastName.Text = "";

            txtMiddleName.Text = "";

            txtJobTitle.Text = "";

            txtCompany.Text = "";

            txtWebSite.Text = "";

            txtOfficePhone.Text = "";

            txtHomePhone.Text = "";

            txtMobile.Text = "";

            txtFax.Text = "";

            txtOfficeEmail.Text = "";

            txtPersonnelEmail.Text = "";      

            txtAddress.Text="";    

        }

        else

        {

            lblRecordAdded.Visible = true;

            lblRecordAdded.Text = "Please Fill First Name and Last Name ";            

        }

    }

 

    public void InserRecord()

    {        

        con = new SqlConnection(connection);

        cmd.CommandText = "insert into Record( Title,FirstName, LastName,MiddleName, JobType,Company, WebSite,

 OfficePhone, HomePhone, Mobile,Fax, OfficialEmail, PersonelEmail,Address)  values('" + listTitle.Text + "','" + txtFirstName.Text + "', 

'" + txtLastName.Text + "','" +  txtMiddleName.Text + "','" +  txtJobTitle.Text + "',

'" + txtCompany.Text +  "','" +  txtWebSite.Text + "',

'" +  txtOfficePhone.Text + "','" + txtHomePhone.Text + "','" + txtMobile.Text + "','" + txtFax.Text + "','" + txtOfficeEmail.Text + "',

'" + txtPersonnelEmail.Text +  "','"+ txtAddress.Text + "')";

        cmd.Connection = con;

        con.Open();

        cmd.ExecuteNonQuery();

        con.Close();

        lblRecordAdded.Visible = true;

        lblRecordAdded.Text = "Your Address has benn sucessfuly Submitted, Thanx for add a Record ";        

    }


    protected void Main_Click(object sender, ImageClickEventArgs e)

    {

        Response.Redirect("Allrecord.aspx");

    }

}

 Adding a new Record

 


Figure 3: Add a new address.

Search.aspx 
 

<body>

  <form id="form1" runat="server">

    <div>

      <table cellpadding="0" cellspacing="0" width="70%" border="4" background="BackGround.jpg" align="center">

        <tr><td><marquee>

                  <asp:Label ID="lblsearchName" runat="server" Text="Search Your Address" 

                            BackColor="#ff9900"></asp:Label>

                  </marquee>

              </td></tr>

        <tr><td>&nbsp;&nbsp;
            <asp:Label ID="lblSearch" runat="server" Text="Search By:" Font-Bold="true" 

                    ForeColor="#0000ff">  </asp:Label>

                  &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;

                <asp:Label ID="lblError" runat="server" ForeColor="Red"></asp:Label>    

          </td></tr>

        <tr><td height="5px"></td></tr>

        <tr><td>&nbsp;&nbsp; &nbsp; &nbsp;
                     <asp:Label ID="lblIDsearch" runat="server" Text="ID" Width="120px"> </asp:Label>

                          &nbsp;&nbsp;

                    <asp:TextBox ID="txtIDSearch" runat="server"></asp:TextBox> 
                    &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 

                  &nbsp;&nbsp;

                          <asp:Button ID="btnIDSearch" runat="server" Text="Search" OnClick="btnIDSearch_Click" />

          </td></tr> 

        <tr><td height="5px"></td></tr>

        <tr><td>&nbsp;&nbsp;&nbsp;&nbsp;
                  <asp:Label ID="lblName" runat="server" Text="First Name" Width="120px"></asp:Label>

                  &nbsp;&nbsp;

                 <asp:TextBox ID="txtFirstNameSearch" runat="server"> </asp:TextBox>  

      &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;

                 <asp:Button ID="btnNameSearch" runat="server" Text="Search" OnClick="btnFirstNameSearch_click" />

            </td></tr>

        <tr><td height="5px"></td></tr>

        <tr><td>&nbsp;&nbsp; &nbsp;&nbsp;
                  <asp:Label ID="lblLastName" runat="server" Text="Last Name"  Width="120px"> </asp:Label> 

                &nbsp;&nbsp;

                <asp:TextBox ID="txtLastNameSearch" runat="server"></asp:TextBox>
                      &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;  &nbsp; &nbsp; &nbsp; 

                             &nbsp;&nbsp;&nbsp;

                <asp:Button ID="btnLastNameSearch" runat="server" Text="Search" OnClick="btnLastNameSearch_Click" /> 

        </td></tr>

    

        <tr><td height="5px"></td></tr>

        <tr><td>&nbsp;&nbsp; &nbsp;&nbsp;
                <asp:Label ID="lblMobilesearch" runat="server" Text="Mobile"  Width="120px"> </asp:Label> 

                &nbsp;&nbsp;

                <asp:TextBox ID="txtMobileSearch" runat="server"></asp:TextBox>
                  &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

                <asp:Button ID="btnMobileSearch" runat="server" Text="Search" OnClick="btnMobileSearch_Click" />

            </td></tr>

        

            <tr><td height="5px"></td></tr>

            <tr><td>&nbsp; &nbsp;&nbsp; &nbsp;
                     <asp:Label ID="lblEmailSearch" runat="server" Text="Email"  Width="120px"></asp:Label> &nbsp; &nbsp;

                     <asp:TextBox ID="txtEmailSearch" runat="server"> </asp:TextBox> 

             &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; 

                &nbsp;&nbsp;

                       <asp:Button ID="btnEmailSearch" runat="server" Text="Search" OnClick="btnEmailSearch_Click" />

         </td></tr> 

        <tr><td> <asp:ImageButton ID="ImageMain" runat="server" ImageUrl="~/5ar04a.gif" OnClick="Main_Click" 
                     ToolTip="Click Here To Go On All Record"/></td></tr>   

      </table>

      <table cellpadding="0" cellspacing="0" border="0" width="70%" align="center">

        <tr><td height="5px"></td></tr>

        <tr><td>

              <asp:DataGrid ID="GridAllRecord" runat="server" AutoGenerateColumns="false" 
                  Width="100%" DataKeyField="ID" 

                    BorderStyle="ridge"  GridLines="Both" BorderWidth="2px" BorderColor ="white"  BackColor="white" 
                    CellPadding="0"  CellSpacing="0"  OnItemCommand="Grid_ItemCommand" AllowSorting="true"   

                          PagerStyle-HorizontalAlign="Center" PageSize=5 AllowPaging="true">

              <FooterStyle ForeColor="Black" BackColor="#C6C3C6"></FooterStyle>

              <HeaderStyle Font-Bold="True" ForeColor="#FFFFFF" BackColor="#A53A6A"></HeaderStyle>

              <FooterStyle BackColor="beige" />

              <PagerStyle Font-Bold="true" Mode=NumericPages Font-Underline="true"/>

              <Columns>

                <asp:BoundColumn DataField=ID HeaderText="ID" Visible="false">

                  <ItemStyle BackColor="graytext" />

                  <HeaderStyle BackColor="graytext" />

                </asp:BoundColumn>

                <asp:TemplateColumn HeaderText="First Name" >

                  <ItemTemplate>

                    <asp:LinkButton ID="lnkName" runat="server" 
                      Text='<%#DataBinder.Eval(Container.DataItem,"FirstName") %>' CommandName="RecordShow"> 

                           </asp:LinkButton>

                  </ItemTemplate>

                </asp:TemplateColumn>            

                <asp:BoundColumn DataField=OfficialEmail HeaderText="Official(EMail)">

                  <ItemStyle BackColor=GhostWhite />

                    </asp:BoundColumn>                

                <asp:BoundColumn DataField=PersonelEmail HeaderText="Personnel(EMail)">

                  <ItemStyle BackColor=GhostWhite />

                </asp:BoundColumn>          

                <asp:BoundColumn DataField=Mobile HeaderText="Mobile">

              <ItemStyle BackColor=GhostWhite />

            </asp:BoundColumn>                                

          </Columns>    

      </asp:DataGrid>

    </td></tr></table>

  </div>

 </form>

</body>

 Search.aspx.cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

 

public partial class Search : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

    SqlConnection con;

    SqlDataAdapter da;

    SqlCommand cmd = new SqlCommand();

    DataSet ds = new DataSet();

    string connect = @"Data Source=MCN0100;Initial Catalog=AddressBook; Uid=sa; Pwd=";

    string commandSearch;

 

    protected void btnFirstNameSearch_click(object sender, EventArgs e)

    {

        if (txtFirstNameSearch.Text == "")

        {

            lblError.Text = "Please Enter First Name";

        }

        else

        {

            commandSearch = "select * from Record where FirstName='" + txtFirstNameSearch.Text + "'";

            showSearchRecord();

        }

    }

 

    protected void btnLastNameSearch_Click(object sender, EventArgs e)

    {

        if (txtLastNameSearch.Text == "")

        {

            lblError.Text = "Please Enter Last Name";

        }

        else

        {

            commandSearch = "select * from Record where LastName='" + txtLastNameSearch.Text + "'";

            showSearchRecord();

        }

    }

 

    protected void btnMobileSearch_Click(object sender, EventArgs e)

    {

        if (txtMobileSearch.Text == "")

        {

            lblError.Text = "Please Enter a Mobile Number";

        }

        else

        {

            commandSearch = "select * from Record where Mobile='" + txtMobileSearch.Text + "'";

            showSearchRecord();

        }

    }

 

    protected void btnEmailSearch_Click(object sender, EventArgs e)

    {

        if (txtEmailSearch.Text == "")

        {

            lblError.Text = "Please Enter a Email";

        }

        else

        {

            commandSearch = "select * from Record where personelEmail='" + txtEmailSearch.Text + "'";

            showSearchRecord();

        }

    }

 

    public void showSearchRecord()

    {

        con = new SqlConnection(connect);

        cmd.CommandText = commandSearch;

        cmd.Connection = con;

        da = new SqlDataAdapter(cmd);

        da.Fill(ds);

        con.Open();

        cmd.ExecuteNonQuery();

        if (ds.Tables[0].Rows.Count > 0)

        {

            lblError.Text = "";

            GridAllRecord.DataSource = ds;

            GridAllRecord.DataBind();

        }

        else

        {

            lblError.Text = "No Address Found  For This Search";

            GridAllRecord.DataSource = null;

            GridAllRecord.DataBind();

        }

    }

 

    protected void Grid_ItemCommand(object sender, DataGridCommandEventArgs e)

    {

        if (e.CommandName == "RecordShow")

        {

            int  Id = int.Parse(e.Item.Cells[0].Text);

            Session["ID"] =  Id;

            Response.Redirect("ShowSelectedRecord.aspx");

        }

    }


    protected void btnIDSearch_Click(object sender, EventArgs e)

    {

        if (txtIDSearch.Text == "")

        {

            lblError.Text = "Please Enter a ID";

        }

        else

        {

            commandSearch = "select * from Record where ID='" + txtIDSearch.Text + "'";

            showSearchRecord();

        }

    }


    protected void Main_Click(object sender, ImageClickEventArgs e)

    {

        Response.Redirect("Allrecord.aspx");

    }

}

 

 Figure 4: Searching a address.

Login.aspx

<body>

    <form id="form1" runat="server">

    <div>

    <table cellpadding="0" cellspacing="0" width="60%" align="center" border=4 background="BackGround.jpg">     

    <tr><td align="center"><asp:Label ID="lblLoginWelcome" runat="server"
         Text="Wecome Here In OnLine Address Book" ForeColor="Blue" Font-Bold="true"></asp:Label> </td></tr>

    <tr><td><asp:Label ID="lblError" runat="server" Visible=false ForeColor="blue"></asp:Label></td></tr>

    <tr><td><table cellpadding="0" cellspacing="0" width="50%" align="center" border="0">

    <tr><td height="15px"></td></tr>

    <tr><td><asp:Label ID="lblLogin" runat="server" Text="Login" Width="112px" Font-Bold="true" 

                             ForeColor="#990066"></asp:Label>
                  <asp:TextBox ID="txtLogin" runat="server"> </asp:TextBox> </td></tr>

    <tr><td height="15px"></td></tr>

    <tr><td><asp:Label ID="lblPassword" runat="server" Text="Password" Width="112px" Font-Bold="true" 

                         ForeColor="#990066"></asp:Label>
                <asp:TextBox ID="txtPassword" runat="server" TextMode="Password"> </asp:TextBox> </td> </tr>

     <tr><td height="15px"></td></tr>

     <tr><td align="center"><asp:Button ID="btnLogin" runat="server" OnClick="btnLogin_Click"
                     Text="Login" Width="76px" /> </td> </tr>

    </table></td></tr>

    </table>

    

    </div>

    </form>

</body>

Login.aspx.cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

 

public partial class LoginCheck : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

    protected void btnLogin_Click(object sender, EventArgs e)

    {

        if (txtLogin.Text == "rahul" && txtPassword.Text == "saxena")

        {

            Response.Redirect("UpdateTheRecord.aspx");

        }

        else

        {

            lblError.Visible = true;

            lblError.Text = "Invalid User"; 

        }

    }

}

 

Figure 5: If user want to update the address then he have to Login before edit the an address

UpdateRecord

<body>

    <form id="form1" runat="server">

    <div>

     <table cellpadding="0" cellspacing="0" border="1" width="90%" align="center" 

                    background="BackGround.jpg">

       <tr><td align="center"><table cellpadding="0" cellspacing="0" width="80%" 

                      border="0" align="center">

       <tr><td align="center" style="border-bottom:2px solid;">

              <asp:Label ID="lblName" runat="server"

                  Text="Update Personnel Information" Font-Bold="true"  Font-    

                           Size="14pt" ForeColor="#0099ff"> </asp:Label>

            </td>

            <td align="center" style="border-bottom:2px solid;">

               <asp:Label ID="Label1" runat="server"

                      Text="Update Professional Information"  Font-Bold="true" Font-

                              Size="14pt" ForeColor="#ff6600"> </asp:Label> 

            </td>

       </tr>                 

       <tr><td align="center">

             <table>                  

               <tr><td><marquee>

                         <asp:Label ID="lblPersonnelInformation" runat="server" 

                                 Text="Personnel Information"  Font-Bold="True"  

                                    ForeColor=ActiveCaption></asp:Label>

                       </marquee>

                    </td>

               </tr>

              <tr><td align="left">

                    <asp:Label ID="lblFirstNmae" Text="First Name" runat="server"            

                        Width="100px"  ForeColor=ActiveCaption>

                     </asp:Label>

                    <asp:TextBox ID="txtFirstName" runat="server" 

                        Enabled=false> </asp:TextBox>

                   </td>

              </tr>

             <tr><td align="left">

                   <asp:Label ID="lblMiddleName" Text="Middle Name" runat="server" 

                           Width="100px" ForeColor=ActiveCaption>

                    </asp:Label>

                    <asp:TextBox ID="txtMiddleName" runat="server" 

                            Enabled=false></asp:TextBox>

                  </td>

             </tr>

              <tr><td align="left">

                    <asp:Label ID="lblLastName" Text="Last Name" runat="server" 

                       Width="100px" ForeColor=ActiveCaption> 

                    </asp:Label>

                     <asp:TextBox ID="txtLastName" runat="server" Enabled=false> 

                    </asp:TextBox>

                   </td>

              </tr>

              <tr><td align="left">

                    <asp:Label ID="lblHomePhone" Text="Home Phone" runat="server" 

                                Width="100px" ForeColor=ActiveCaption> 

                    </asp:Label>

                    <asp:TextBox ID="txtHomePhone" runat="server"> 

                    </asp:TextBox>

                   </td>

               </tr>                                                                   

               <tr><td align="left"> 

                     <asp:Label ID="lblMobile" Text="Mobile" runat="server" 

                                 Width="100px" ForeColor=ActiveCaption> 

                     </asp:Label>

                     <asp:TextBox ID="txtMobile" runat="server">

                     </asp:TextBox>

                   </td>

                </tr>                           

                <tr><td align="left"> 

                      <asp:Label ID="lblPersonelEmail" Text="Email" runat="server" 

                                 Width="100px" ForeColor=ActiveCaption>

                      </asp:Label>

                      <asp:TextBox ID="txtPersonnelEmail" runat="server">

                      </asp:TextBox>

                    </td>

                </tr>

              </table></td>                     

             <td>

                 <table>

                      <tr><td><marquee> 

                                <asp:Label ID="lblOfficeInformation" runat="server" 

                                       Text="Official Information" Font-Bold="True" 

                                                 ForeColor="Chocolate">

                                </asp:Label>

                              </marquee> 

                           </td>

                       </tr>

                       <tr> <td align="left">

                              <asp:Label ID="lblCompany" Text="Company" runat="server" 

                                              Width="100px" ForeColor="Chocolate">

                              </asp:Label>

                              <asp:TextBox ID="txtCompany" runat="server">

                              </asp:TextBox>

                            </td>

                       </tr>                       

                       <tr><td align="left"> 

                             <asp:Label ID="lblJobTitle" Text="Job Title" runat="server" 

                                              Width="100px" ForeColor="Chocolate"> 

                             </asp:Label>

                             <asp:TextBox ID="txtJobTitle" runat="server">

                             </asp:TextBox>

                           </td>

                         </tr>

                        <tr><td align="left"> 

                              <asp:Label ID="lblWebSite" Text="Web Site" runat="server" 

                                               Width="100px" ForeColor="Chocolate"> 

                              </asp:Label>

                              <asp:TextBox ID="txtWebSite" runat="server"> 

                              </asp:TextBox>

                            </td>

                        </tr>                           

                        <tr><td align="left">

                              <asp:Label ID="lblOfficePhone" Text="OfficePhone" 

                                         runat="server" Width="100px"  ForeColor="Chocolate">

                              </asp:Label>

                              <asp:TextBox ID="txtOfficePhone" runat="server">

                              </asp:TextBox>

                            </td>

                        </tr>

                        <tr><td align="left">

                              <asp:Label ID="lblFax" Text="Fax" runat="server" 

                                       Width="100px" ForeColor="Chocolate">

                              </asp:Label>

                              <asp:TextBox ID="txtFax" runat="server"> </asp:TextBox>

                            </td>

                         </tr>

                         <tr><td align="left"> 

                               <asp:Label ID="lblOfficeEmail" Text="Office Email" 

                                          runat="server" Width="100px" ForeColor="Chocolate">

                               </asp:Label>

                               <asp:TextBox ID="txtOfficeEmail" runat="server">

                               </asp:TextBox><td></tr> 

                     </table></td>

                  </tr> 

                  <tr><td>

                       <asp:Label ID="Label2" runat="server" Width="120px" 

                                Text="Address" Font-Bold="true" ForeColor=ActiveCaption>

                       </asp:Label>

                       <asp:TextBox ID="txtAddress" runat="server" 

                                        TextMode="MultiLine"> 

                       </asp:TextBox>

                     </td>

                 </tr>

             </table></td></tr>     

             <tr><td height="5px"></td></tr>

            <tr><td align="center" height="50px">

                <asp:Button ID="btnUpdateRecord" runat="server" Text="Update The 

                             Record" Width="303px" OnClick="UpdateRecord_Click" />

                 &nbsp;&nbsp; &nbsp; &nbsp; 

                <asp:ImageButton ID="ImageMain" runat="server" 

                                 ImageUrl="~/5ar04a.gif" OnClick="Main_Click"  

                                    ToolTip="Click Here To Go On All Record"/>

            </td></tr>

        </table>     

      </div>

    </form>

  </body>

UpdateRecord.aspx.cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

 

public partial class UpdateTheRecord : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            record4Update();

        }

    }

    SqlConnection con;

    SqlDataAdapter da;

    SqlCommand cmd = new SqlCommand();

    DataSet ds = new DataSet();

    string connect = @"Data Source=MCN0100;Initial Catalog=AddressBook; Uid=sa; Pwd="; 

 

    protected void UpdateRecord_Click(object sender, EventArgs e)

    {

        int IDUpdate = int.Parse(Session["UpadteAddressID"].ToString());

        con = new SqlConnection(connect);

        cmd.CommandText = "update Record set Jobtype='" + txtJobTitle.Text + "' , 

Company='" +  txtCompany.Text +  "', WebSite='" +  txtWebSite.Text + "',  OfficePhone='" + txtOfficePhone.Text + "',  

HomePhone='" +  txtHomePhone.Text  + "',Mobile='" + txtMobile.Text + "', Fax='" + txtFax.Text  + "', 

OfficialEmail='" + txtOfficeEmail.Text + "', PersonelEmail='" +  txtPersonnelEmail.Text + "', Address='"+txtAddress.Text+"' where ID="+IDUpdate;;

        cmd.Connection = con;

        con.Open();

        cmd.ExecuteNonQuery();

        con.Close();

    }

 

    public void record4Update()

    {

        int IDUpdate = int.Parse(Session["UpadteAddressID"].ToString());

        con = new SqlConnection(connect);

        cmd.CommandText = "select * from Record where ID=" + IDUpdate;

        cmd.Connection = con;

        da = new SqlDataAdapter(cmd);

        da.Fill(ds);        

        con.Open();

        cmd.ExecuteNonQuery();

        txtFirstName.Text = ds.Tables[0].Rows[0][2].ToString();

        txtMiddleName.Text = ds.Tables[0].Rows[0][4].ToString();

        txtLastName.Text = ds.Tables[0].Rows[0][3].ToString();

        txtMobile.Text = ds.Tables[0].Rows[0][10].ToString();

        txtOfficeEmail.Text = ds.Tables[0].Rows[0][12].ToString();

        txtOfficePhone.Text = ds.Tables[0].Rows[0][8].ToString();

        txtPersonnelEmail.Text = ds.Tables[0].Rows[0][13].ToString();

        txtWebSite.Text = ds.Tables[0].Rows[0][7].ToString();

        txtJobTitle.Text = ds.Tables[0].Rows[0][5].ToString();

        txtCompany.Text = ds.Tables[0].Rows[0][6].ToString();

        txtHomePhone.Text = ds.Tables[0].Rows[0][9].ToString();

        txtFax.Text = ds.Tables[0].Rows[0][11].ToString();

        txtAddress.Text = ds.Tables[0].Rows[0][14].ToString();

        con.Close();

    }

    protected void Main_Click(object sender, ImageClickEventArgs e)

    {

        Response.Redirect("AllRecord.aspx");

    }

} 

 

Figure 6: In updating the Record.

ShowSelectedRecord.aspx

<body>

    <form id="form1" runat="server">

    <div>

    <table cellpadding="0" cellspacing="0" border="1" width="90%" align="center" background="BackGround.jpg">

    <tr><td> <table cellpadding="0" cellspacing="0" width="70%" align="center" >

     <tr> <td align="center" style="border-bottom:2px solid;"> 
          <asp:Label ID="lblName" runat="server" Text="Individual Record" Font-Bold="true" 

                Font-Size="14pt" > </asp:Label> </td> </tr>

    

    <tr><td height="5px"></td></tr>

    <tr><td> <marquee behavior=alternate bgcolor="#ffcccc">
           <asp:Label ID="lblNameHeading" runat="server" Font-Bold="true" ForeColor="#0000ff"> </asp:Label> 
              &nbsp; <asp:Label ID="lblLastNameHeading" runat="server"

                               Width="140px" Font-Bold="true" ForeColor="#0000ff" >
             </asp:Label> </marquee></td> </tr>

    <tr><td height="5px"></td></tr>

    

    <tr><td> <table width="60%" align="center">

    <tr><td> <asp:Label ID="lblFirstname" runat="server" Width="140px" Text="First Name" Font-Bold="true">

                            </asp:Label>

            <asp:TextBox ID="txtFirsname" runat="server"> </asp:TextBox> </td> </tr>

     <tr><td height="5px"> </td></tr>

      

    <tr><td> <asp:Label ID="lblMiddleName" runat="server" Width="140px" Text="Middle Name" Font-Bold="true">

                            </asp:Label>

            <asp:TextBox ID="txtMiddleName" runat="server"> </asp:TextBox></td></tr>

     <tr><td height="5px"></td></tr>

    <tr><td> <asp:Label ID="lblLastName" runat="server" Width="140px" Text="Last Name" Font-Bold="true"> </asp:Label>

            <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox></td></tr>  

 

 <tr><td height="5px"></td></tr>

    <tr><td> <asp:Label ID="lblCompany" runat="server" Width="140px" Text="Company" Font-Bold="true">

                       </asp:Label>

            <asp:TextBox ID="txtCompany" runat="server"></asp:TextBox></td></tr>

 <tr><td height="5px"> </td></tr>

    <tr><td><asp:Label ID="lblJobTitle" runat="server" Width="140px" Text="Job Title" Font-Bold="true"> </asp:Label>

            <asp:TextBox ID="txtJobTitle" runat="server"></asp:TextBox></td></tr>

 <tr><td height="5px"></td></tr>

   <tr><td><asp:Label ID="lblMobile" runat="server" Width="140px" Text="Mobile" Font-Bold="true"></asp:Label>

            <asp:TextBox ID="txtMobile" runat="server"></asp:TextBox></td></tr>

 <tr><td height="5px"></td></tr>

   <tr><td><asp:Label ID="lblPersonnelEmail" runat="server" Width="140px" Text="Personnel Email" Font-Bold="true">

                </asp:Label>

            <asp:TextBox ID="txtPersonnelEmail" runat="server"></asp:TextBox> 

            

            </td></tr> <tr><td height="5px"></td></tr>

            

            <tr><td> <asp:Label ID="Label1" runat="server" Width="140px" Text="Address" Font-Bold="true">

                          </asp:Label>

            <asp:TextBox ID="txtAddress" runat="server" TextMode="MultiLine"></asp:TextBox> 

            

            </td></tr>

            <tr><td height="5px"></td></tr>

            <tr><td> <asp:Button ID="btnAllRecord" runat="server" Text="Return On All Record"

                        Width="303px" OnClick="AllRecord_Click" /> </td></tr>

            </table></td></tr>

    </table></td></tr>    

    </table>    

    </div>

    </form>

</body>

ShowSelectedRecord.aspx.cs

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

 

public partial class ShowSelectedRecord : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        record();       

    }

    string connection = @"Data Source=MCN0100;Initial Catalog=AddressBook; Uid=sa; Pwd=";

    SqlConnection con;

    SqlCommand cmd = new SqlCommand();

    SqlDataAdapter da;

    DataSet ds = new DataSet();

 

    public void record()

    {

        int ID = int.Parse(Session["ID"].ToString());

        con = new SqlConnection(connection);

        cmd.CommandText = "select * from record where ID="+ID;

        cmd.Connection = con;

        da = new SqlDataAdapter(cmd);

        da.Fill(ds);

        con.Open();

        cmd.ExecuteReader();

        if (ds.Tables[0].Rows.Count > 0)

        {

            txtFirsname.Text = ds.Tables[0].Rows[0][2].ToString();

            txtLastName.Text = ds.Tables[0].Rows[0][3].ToString();

            txtMiddleName.Text = ds.Tables[0].Rows[0][4].ToString();

            txtCompany.Text = ds.Tables[0].Rows[0][6].ToString();

            txtJobTitle.Text = ds.Tables[0].Rows[0][5].ToString();

            txtMobile.Text = ds.Tables[0].Rows[0][10].ToString();

            txtPersonnelEmail.Text = ds.Tables[0].Rows[0][13].ToString();

            lblNameHeading.Text = ds.Tables[0].Rows[0][2].ToString();

            lblLastNameHeading.Text = ds.Tables[0].Rows[0][3].ToString();
            txtAddress.Text== ds.Tables[0].Rows[0][14].ToString();

        }

        else

        {

            Response.Write("No Record");

        }

        con.Close(); 

    }

    protected void AllRecord_Click(object sender, EventArgs e)

    {

        Response.Redirect("AllRecord.aspx");

    }

}




Figure 7: Selected Address.




 

 

About Author

About Author Rahul shows great interests in working with Microsoft technologies. He specializes in the implementation of DataBase & Graphics. His area of expertise includes: C#, ASP.NET,ADO.NET,Windows Forms & Web Services. He hails from background , Master's in Computer Application. With programming he loves photography, traveling and reading books. Rahul Saxena
No Photo
 
Country India
Company N/A
Home Page N/A

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

 
 
Posted By Annonymous on 03 Sep 2011 at 01:54 AM
 
Ah, i see. Well that's not too tkircy at all!"
 
 
   
Write your comment here.
Comment
Verification Code