Default.aspx
<html>
<head>
<title>This is First Page.. </title>
<link rel="Stylesheet" type="text/css" href="Main.css" />
<script type="text/javascript">
function form_validate() {
if (document.getElementById("<%=txtFname.ClientID%>").value == "") {
alert("Enter First Name..");
document.getElementById("<%=txtFname.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtMname.ClientID%>").value == "") {
alert("Please Enter Middle Name.. ");
document.getElementById("<%=txtMname.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtLname.ClientID%>").value == "") {
alert("Please Enter Last Name.. ");
document.getElementById("<%=txtLname.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtMob.ClientID%>").value == "") {
alert("Phone Number Can Not Be Blanked.... ");
document.getElementById("<%=txtMob.ClientID%>").focus();
return false;
}
var numpattern = "^[0-9]{10}$";
var phone = document.getElementById("<%=txtMob.ClientID%>").value;
var matchptrn = phone.match(numpattern);
if (matchptrn == null) {
alert("Phone Number Is Incorrect..");
document.getElementById("<%=txtMob.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtEmail.ClientID%>").value == "") {
alert("Must Enter Email Address.. ");
document.getElementById("<%=txtEmail.ClientID%>").focus();
return false;
}
var emailptrn = "^([0-9a-zA-Z]([-\.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$";
var email = document.getElementById("<%=txtEmail.ClientID%>").value;
var matchemail = email.match(emailptrn);
if (matchemail == null) {
alert("Incorrect Email Address...");
return false;
}
if (document.getElementById("<%=txtAdd1.ClientID%>").value == "") {
alert("Address1 Must be enter.. ");
document.getElementById("<%=txtAdd1.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtPincode.ClientID%>").value == "") {
alert("pincode must be enter. ");
document.getElementById("<%=txtPincode.ClientID%>").focus();
return false;
}
var pincodeptrn = "^[0-9]{6}$";
var pincode = document.getElementById("<%=txtPincode.ClientID%>").value;
var matchpincode = pincode.match(pincodeptrn);
if (matchpincode == null) {
alert("Pincode Must Be Of Six Digits..");
document.getElementById("<%=txtPincode.ClientID%>").focus();
return false;
}
}
function del_confirm() {
var ans = confirm("Are you sure you want to delete this recoed..?");
if (ans == true) {
return true;
}
else {
return false;
}
}
</script>
</head>
<body>
<form id="mainFrm">
<table width="100%">
<tr>
<td>
<table>
<tr>
<td>
<asp:HiddenField ID="hfEmpId" runat="server" />
</td>
</tr>
<tr>
<td align="center" colspan="3">
<h2>
Employee Registration Form</h2>
</td>
</tr>
<tr>
<td>
First Name:
</td>
<td>
<asp:TextBox ID="txtFname" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Middle Name:
</td>
<td>
<asp:TextBox ID="txtMname" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Last Name:
</td>
<td>
<asp:TextBox ID="txtLname" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Mobile/Phone:
</td>
<td>
<asp:TextBox ID="txtMob" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Email:
</td>
<td>
<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Address1:
</td>
<td>
<asp:TextBox ID="txtAdd1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Address2:
</td>
<td>
<asp:TextBox ID="txtAdd2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
City:
</td>
<td>
<asp:TextBox ID="txtCity" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
State:
</td>
<td>
<asp:TextBox ID="txtState" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Pincode:
</td>
<td>
<asp:TextBox ID="txtPincode" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Resume:
</td>
<td>
<asp:FileUpload ID="FileUploadResume" runat="server" />
<asp:HiddenField ID="hfFileUpload" runat="server" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnInsert" class="btn_class" runat="server" Text="Submit" OnClick="btnInsert_Click"
OnClientClick="return form_validate('<%=txtFname.ClientID%>');" />
<asp:Button ID="btnUpdate" class="btn_class" runat="server" Text="Update" OnClick="btnUpdate_Click" />
<asp:Button ID="btnClear" class="btn_class" runat="server" Text="Cancel" OnClick="btnClear_Click" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:GridView class="gridview_class" ID="gvDataDisplay" runat="server" AutoGenerateColumnhs="False"
OnRowCommand="gvDataDisplay_RowCommand" AutoGenerateColumns="False" CellPadding="4"
ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:BoundField DataField="FullName" HeaderText="Full Name" />
<asp:BoundField DataField="Email" HeaderText="Email" />
<asp:BoundField DataField="City" HeaderText="City" />
<asp:BoundField DataField="state" HeaderText="State" />
<asp:TemplateField ShowHeader="False" HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkDel" runat="server" CausesValidation="False" CommandName="rowDelete"
CommandArgument='<%# Eval("emp_id") %>' Text="Delete" OnClientClick="return del_confirm();"
OnClick="lnkDel_Click"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" runat="server" CommandName="rowUpdate"CommandArgument='<%#Eval("emp_id")%>'>Edit</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
Default.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection objCon = new SqlConnection(@"Data Source=DS-1\SQL2008;Initial Catalog=EmployeeDb;User ID=training;Password=training");
SqlCommand cmd = null;
int eid = 0;
protected void Page_Load(object sender, EventArgs e)
{
btnUpdate.Visible = false;
btnInsert.Visible = true;
btnClear.Visible = false;
cmd = new SqlCommand("StoredProcedureSelectData", objCon);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
objCon.Open();
sda.Fill(ds, "employee_master");
objCon.Close();
gvDataDisplay.DataSource = ds;
gvDataDisplay.DataBind();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (FileUploadResume.HasFile)
{
string fileName = FileUploadResume.FileName.ToString();
string filePath = Server.MapPath("~/Resume/" + fileName);
FileUploadResume.SaveAs(filePath);
hfFileUpload.Value = fileName;
}
cmd = new SqlCommand("StoredProcedureInsertData", objCon);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@emp_fname", txtFname.Text);
cmd.Parameters.Add("@emp_fn", SqlDbType.NVarChar).Value = txtFname.Text; // instead of this you can write above line
cmd.Parameters.Add("@emp_mn", SqlDbType.NVarChar).Value = txtMname.Text;
cmd.Parameters.Add("@emp_ln", SqlDbType.NVarChar).Value = txtLname.Text;
cmd.Parameters.Add("@emp_mp", SqlDbType.BigInt).Value = txtMob.Text;
cmd.Parameters.Add("@emp_email", SqlDbType.NVarChar).Value = txtEmail.Text;
cmd.Parameters.Add("@emp_address1", SqlDbType.NVarChar).Value = txtAdd1.Text;
cmd.Parameters.Add("@emp_address2", SqlDbType.NVarChar).Value = txtAdd2.Text;
cmd.Parameters.Add("@emp_city", SqlDbType.NVarChar).Value = txtCity.Text;
cmd.Parameters.Add("@emp_state", SqlDbType.NVarChar).Value = txtState.Text;
cmd.Parameters.Add("@emp_pc", SqlDbType.BigInt).Value = txtPincode.Text;
cmd.Parameters.Add("@emp_resume_path", SqlDbType.NVarChar).Value = hfFileUpload.Value;
objCon.Open();
cmd.ExecuteNonQuery();
objCon.Close();
txtFname.Text = "";
txtMname.Text = "";
txtLname.Text = "";
txtMob.Text = "";
txtEmail.Text = "";
txtAdd1.Text = "";
txtAdd2.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtPincode.Text = "";
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Data Inserted Successfully...!!');", true);
Response.Redirect("#");
}
protected void btnView_Click(object sender, EventArgs e)
{
}
protected void gvDataDisplay_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "rowDelete")
{
int empId = Convert.ToInt32(e.CommandArgument);
cmd = new SqlCommand("StoredProcedureDeleteData", objCon);
cmd.CommandType = CommandType.StoredProcedure;
objCon.Open();
cmd.Parameters.Add("@emp_id", SqlDbType.Int).Value = empId;
cmd.ExecuteNonQuery();
objCon.Close();
Response.Redirect("#");
//gvDataDisplay.DataBind();
}
if (e.CommandName == "rowUpdate")
{
btnInsert.Visible = false;
btnUpdate.Visible = true;
btnClear.Visible = true;
objCon.Open();
SqlCommand cmdEdit = new SqlCommand();
int empId = Convert.ToInt32(e.CommandArgument);
cmdEdit = new SqlCommand("StoredProcedureSelectDataForEdit", objCon);
cmdEdit.CommandType = CommandType.StoredProcedure;
cmdEdit.Parameters.Add("@emp_id", SqlDbType.Int).Value = empId;
SqlDataReader dr;
dr = cmdEdit.ExecuteReader();
while (dr.Read())
{
hfEmpId.Value = dr["emp_id"].ToString();
txtFname.Text = dr["emp_fname"].ToString();
txtMname.Text = dr[2].ToString();
txtLname.Text = dr[3].ToString();
txtMob.Text = dr[4].ToString();
txtEmail.Text = dr[5].ToString();
txtAdd1.Text = dr[6].ToString();
txtAdd2.Text = dr[7].ToString();
txtCity.Text = dr[8].ToString();
txtState.Text = dr[9].ToString();
txtPincode.Text = dr[10].ToString();
}
objCon.Close();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
cmd = new SqlCommand("StoredProcedureUpdate", objCon);
cmd.CommandType = CommandType.StoredProcedure;
objCon.Open();
cmd.Parameters.Add("@emp_id", SqlDbType.Int).Value = hfEmpId.Value;
cmd.Parameters.Add("@emp_fn", SqlDbType.NVarChar).Value = txtFname.Text;
cmd.Parameters.Add("@emp_mn", SqlDbType.NVarChar).Value = txtMname.Text;
cmd.ExecuteNonQuery();
objCon.Close();
Response.Redirect("#");
}
protected void lnkDel_Click(object sender, EventArgs e)
{
}
protected void btnClear_Click(object sender, EventArgs e)
{
btnClear.Visible = false;
btnInsert.Visible = true;
btnUpdate.Visible = false;
txtFname.Text = "";
txtMname.Text = "";
txtLname.Text = "";
txtMob.Text = "";
txtEmail.Text = "";
txtAdd1.Text = "";
txtAdd2.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtPincode.Text = "";
}
}
