On-line Address Book in ASP.NET 2.0

Rahul Saxena
12y
50k
0
3

Article

This is an On Line Address Book project. Learn with this small project that How to make a project.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. I stored the database in ZipFile.

Welcome.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Welcome.aspx.cs" Inherits="Welcome" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Welcome</title>

</head>

<body>

<div>

<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>

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

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

</td></tr>

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

</td></tr>

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

</td></tr>

</td></tr>

</table>

<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: [email protected]"

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

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

</table>

</div>

</form>

</body>

</html>

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AllRecord.aspx.cs" Inherits="AllRecord" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>All Record</title>

</head>

<body>

<div>

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

<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>

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

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

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

</td></tr>

<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">

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

</asp:BoundColumn>

<asp:TemplateColumn HeaderText="First Name">

<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">

</asp:BoundColumn>

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

</asp:BoundColumn>

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

</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>

</table></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>

</html>

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 when User run the application:

Figure 2: All Record.

Register.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Address Book</title>

</head>

<body>

<div>

</td></tr>

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

</td></tr>

</td> </tr>

<tr><td>                   &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>             

</td></tr>

<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 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>

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

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

<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>

</html>

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Search.aspx.cs" Inherits="Search" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Search</title>

</head>

<body>

<div>

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

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

</marquee>

</td></tr>

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

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

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

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

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

</td></tr>

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

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

</td></tr>

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

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

</td></tr>

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

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

</td></tr>

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

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

</td></tr>

</table>

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

BorderStyle="ridge" GridLines="Both" BorderWidth="2px" BorderColor ="white" BackColor="white" CellPadding="0"

OnItemCommand="Grid_ItemCommand" AllowSorting="true" PagerStyle-

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

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

</asp:BoundColumn>

<asp:TemplateColumn HeaderText="First Name" >

<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)">

</asp:BoundColumn>

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

</asp:BoundColumn>

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

</asp:BoundColumn>

</Columns>

</asp:DataGrid>

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

</div>

</form>

</body>

</html>

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LoginCheck.aspx.cs" Inherits="LoginCheck" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Login User</title>

</head>

<body>

<div>

<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><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>

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

</table>

</div>

</form>

</body>

</html>

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UpdateTheRecord.aspx.cs" Inherits="UpdateTheRecord" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Update Record</title>

</head>

<body>

<div>

<asp:Label ID="Label1" runat="server" Text="Update Professional Information" Font-Bold="true"
Font-Size="14pt" ForeColor="#ff6600"></asp:Label></td></tr>

<table>

<tr><td>
<marquee><asp:Label ID="lblPersonnelInformation" runat="server"

Text="Personnel Information" Font-Bold="True" ForeColor=ActiveCaption></asp:Label>

</marquee> </td> </tr>

<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>

<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>

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

</td></tr>

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

</td></tr>

<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>

<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 align="center" height="50px"> <asp:Button ID="btnUpdateRecord" runat="server"

Text="Update The Record" Width="303px" OnClick="UpdateRecord_Click" />

<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>

</html>

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ShowSelectedRecord.aspx.cs" Inherits="ShowSelectedRecord" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Individual Record</title>

</head>

<body>

<div>

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

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

</marquee> </td ></tr>

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

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

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

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

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

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

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

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

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

</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>

</div>

</form>

</body>

</html>

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.

Up Next

Ebook Download

View all

Hands on with ASP.Net MVC - Covering MVC 6

Read by 23.2k people

Download Now!

Learn

View all