Receiving a record from database on basis of id

I want when user opens the form and fills the emp Id...... all the text boxes present in form (differrent information for a particular employee should be filled )but at the same time the text boxes should be kept disabled and when user will click on edit button then the user should be able to edit the information (txt boxes should be enabled) so that user can enter the data in text box

Below is the registration.aspx.cs page and registration.aspx. page code and i have created a dummy table in database having following columns and i have inserted data in the table :-

CREATE TABLE [dbo].[RegistrationData] ([Emp Id] NVARCHAR (50) NOT NULL,
[Religion] NCHAR (10) NOT NULL,
[Nationality] NCHAR (10) NOT NULL,
[Gender] NCHAR (10) NOT NULL,
[Residential address] NVARCHAR (50) NOT NULL,
[City] NCHAR (10) NOT NULL,
[Pin Code] NUMERIC (18) NOT NULL,
[Personal Email-ID] NVARCHAR (50) NOT NULL,
[Hobbies] NVARCHAR (50) NOT NULL,
[Qualification] NCHAR (10) NOT NULL,
[name] NVARCHAR (50) NOT NULL,
[Mobile] NUMERIC (18) NOT NULL,
[Relation] NVARCHAR (50) NOT NULL,
[Marital status] NCHAR (10) NOT NULL,
[Anniversary date] DATE NOT NULL,
[name1] NVARCHAR (50) NOT NULL,
[DOB1] DATE NOT NULL,
[age1] NUMERIC (18) NOT NULL,
[name2] NVARCHAR (50) NOT NULL,
[DOB2] DATE NOT NULL,
[age2] NUMERIC (18) NOT NULL,
[name3] NVARCHAR (50) NOT NULL,
[DOB3] DATE NOT NULL,
[age3] NUMERIC (18) NOT NULL,
[name4] NVARCHAR (50) NOT NULL,
[DOB4] DATE NOT NULL,
[age4] NUMERIC (18) NOT NULL,
[fname] NVARCHAR (50) NOT NULL,
[fDOB] DATE NOT NULL,
[Fage] NUMERIC (18) NOT NULL,
[Mname] NVARCHAR (50) NOT NULL,
[MDOB] DATE NOT NULL,
[Mage] NUMERIC (18) NOT NULL
);

Registrationaspx.cs code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Data.Sql;
using System.Configuration;
namespace RegistrationForm
{
public partial class Registration : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegiConnectionString"].ConnectionString);
conn.Open();
string checkuser = "select count(*) from RegistrationForm where EmpId='" + EmpIdTxt.Text + "'";
SqlCommand cmd = new SqlCommand(checkuser, conn);
int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("Employee Already Exist");
}
conn.Close();
}
}
protected void Save_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegiConnectionString"].ConnectionString);
conn.Open();
string insertQuery = "insert into RegisterDataBase(EmpId,Religion,Nationality,Gender,Residential asddress)values (@EmpId,@Religion,@Nationality,@Gender,@Residential Address)";
SqlCommand cmd = new SqlCommand(insertQuery, conn);
cmd.Parameters.AddWithValue("@EmpId", EmpIdTxt.Text);
cmd.Parameters.AddWithValue("@Religion", ReligionTxt.Text);
cmd.Parameters.AddWithValue("@Nationality", NationalityTxt.Text);
cmd.Parameters.AddWithValue("@Gender", GenderTxt.Text);
cmd.Parameters.AddWithValue("@Residentail Address",ResidentaiolAddressTxt.Text);
cmd.ExecuteNonQuery();
Response.Write("Employee registeration Successfully!!!thank you");
conn.Close();
}
catch (Exception ex)
{
Response.Write("error" + ex.ToString());
}

Following is the code for registration.aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registration.aspx.cs" Inherits="RegistrationForm.Registration" %>
"server">
protected void ReligionTxt_TextChanged1(object sender, EventArgs e)
{
}
protected void EmpIdTxt_TextChanged(object sender, EventArgs e)
{
}
protected void Save_Click(object sender, EventArgs e)
{
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
"http://www.w3.org/1999/xhtml">
"server">
"text/css">
.auto-style1 {
text-align: center;
}
.auto-style2 {
width: 74%;
height: 2545px;
margin-left: 276px;
background-color: #CCFFCC;
}
.auto-style9 {
margin-top: 4px;
}
.newStyle1 {
}
.newStyle2 {
border: thin double #CCFFCC;
}
.auto-style17 {
width: 678px;
height: 55px;
text-align: center;
}
.auto-style18 {
height: 55px;
}
.auto-style22 {
width: 678px;
height: 54px;
text-align: center;
}
.auto-style23 {
height: 54px;
}
.auto-style24 {
width: 678px;
height: 80px;
text-align: center;
}
.auto-style25 {
height: 55px;
text-align: center;
}
.newStyle3 {
border-style: dashed;
}
.newStyle4 {
border: thin dotted #99FF99;
}
.auto-style29 {
font-weight: bold;
margin-left: 0px;
}
.auto-style30 {
width: 434px;
height: 80px;
text-align: justify;
}
.auto-style31 {
font-weight: bold;
margin-right: 27px;
}
.auto-style32 {
text-align: center;
height: 329px;
width: 1486px;
margin-top: 274px;
}
.auto-style33 {
height: 55px;
width: 434px;
text-align: justify;
}
.auto-style34 {
height: 54px;
text-align: center;
}
.auto-style35 {
text-align: center;
}
.auto-style36 {
text-align: left;
}
.auto-style37 {
width: 434px;
height: 54px;
text-align: justify;
}
.auto-style40 {
height: 65px;
text-align: center;
}
.auto-style41 {
width: 434px;
height: 85px;
text-align: justify;
}
.auto-style42 {
width: 678px;
height: 85px;
text-align: center;
}
.auto-style43 {
width: 434px;
text-align: justify;
}
.auto-style44 {
width: 678px;
text-align: center;
}
.auto-style46 {
text-align: center;
height: 85px;
}
.auto-style47 {
height: 65px;
width: 434px;
text-align: justify;
}
.auto-style48 {
width: 678px;
height: 65px;
text-align: center;
}
.auto-style49 {
height: 72px;
text-align: center;
}
.auto-style50 {
width: 434px;
height: 72px;
text-align: justify;
}
.auto-style51 {
width: 678px;
height: 72px;
text-align: center;
}
.auto-style52 {
height: 69px;
text-align: center;
}
.auto-style53 {
height: 69px;
width: 434px;
text-align: justify;
}
.auto-style54 {
width: 678px;
height: 69px;
text-align: center;
}
.auto-style55 {
width: 434px;
height: 23px;
text-align: justify;
}
.auto-style56 {
width: 678px;
height: 23px;
text-align: center;
}
.auto-style57 {
height: 23px;
text-align: center;
}
"form1" runat="server">
"Image1" runat="server" Height="62px" ImageUrl="~/Logo/logo.png" Width="255px" />

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sakshi Kaul7y ago
Hi
Below is the registration.aspx.cs page and registration.aspx. page code and i have created a dummy table in database having following columns and i have inserted data in the table :-
CREATE TABLE [dbo].[RegistrationData] ([Emp Id] NVARCHAR (50) NOT NULL,
[Religion] NCHAR (10) NOT NULL,
[Nationality] NCHAR (10) NOT NULL,
[Gender] NCHAR (10) NOT NULL,
[Residential address] NVARCHAR (50) NOT NULL,
[City] NCHAR (10) NOT NULL,
[Pin Code] NUMERIC (18) NOT NULL,
[Personal Email-ID] NVARCHAR (50) NOT NULL,
[Hobbies] NVARCHAR (50) NOT NULL,
[Qualification] NCHAR (10) NOT NULL,
[name] NVARCHAR (50) NOT NULL,
[Mobile] NUMERIC (18) NOT NULL,
[Relation] NVARCHAR (50) NOT NULL,
[Marital status] NCHAR (10) NOT NULL,
[Anniversary date] DATE NOT NULL,
[name1] NVARCHAR (50) NOT NULL,
[DOB1] DATE NOT NULL,
[age1] NUMERIC (18) NOT NULL,
[name2] NVARCHAR (50) NOT NULL,
[DOB2] DATE NOT NULL,
[age2] NUMERIC (18) NOT NULL,
[name3] NVARCHAR (50) NOT NULL,
[DOB3] DATE NOT NULL,
[age3] NUMERIC (18) NOT NULL,
[name4] NVARCHAR (50) NOT NULL,
[DOB4] DATE NOT NULL,
[age4] NUMERIC (18) NOT NULL,
[fname] NVARCHAR (50) NOT NULL,
[fDOB] DATE NOT NULL,
[Fage] NUMERIC (18) NOT NULL,
[Mname] NVARCHAR (50) NOT NULL,
[MDOB] DATE NOT NULL,
[Mage] NUMERIC (18) NOT NULL
);
Registrationaspx.cs code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Data.Sql;
using System.Configuration;
namespace RegistrationForm
{
public partial class Registration : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegiConnectionString"].ConnectionString);
conn.Open();
string checkuser = "select count(*) from RegistrationForm where EmpId='" + EmpIdTxt.Text + "'";
SqlCommand cmd = new SqlCommand(checkuser, conn);
int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("Employee Already Exist");
}
conn.Close();
}
}
protected void Save_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegiConnectionString"].ConnectionString);
conn.Open();
string insertQuery = "insert into RegisterDataBase(EmpId,Religion,Nationality,Gender,Residential asddress)values (@EmpId,@Religion,@Nationality,@Gender,@Residential Address)";
SqlCommand cmd = new SqlCommand(insertQuery, conn);
cmd.Parameters.AddWithValue("@EmpId", EmpIdTxt.Text);
cmd.Parameters.AddWithValue("@Religion", ReligionTxt.Text);
cmd.Parameters.AddWithValue("@Nationality", NationalityTxt.Text);
cmd.Parameters.AddWithValue("@Gender", GenderTxt.Text);
cmd.Parameters.AddWithValue("@Residentail Address",ResidentaiolAddressTxt.Text);
cmd.ExecuteNonQuery();
Response.Write("Employee registeration Successfully!!!thank you");
conn.Close();
}
catch (Exception ex)
{
Response.Write("error" + ex.ToString());
}
Following is the code for registration.aspx page
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registration.aspx.cs" Inherits="RegistrationForm.Registration" %>

"server">
protected void ReligionTxt_TextChanged1(object sender, EventArgs e)
{
}
protected void EmpIdTxt_TextChanged(object sender, EventArgs e)
{
}
protected void Save_Click(object sender, EventArgs e)
{
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}

"http://www.w3.org/1999/xhtml">
"server">

"text/css">
.auto-style1 {
text-align: center;
}
.auto-style2 {
width: 74%;
height: 2545px;
margin-left: 276px;
background-color: #CCFFCC;
}
.auto-style9 {
margin-top: 4px;
}
.newStyle1 {
}
.newStyle2 {
border: thin double #CCFFCC;
}
.auto-style17 {
width: 678px;
height: 55px;
text-align: center;
}
.auto-style18 {
height: 55px;
}
.auto-style22 {
width: 678px;
height: 54px;
text-align: center;
}
.auto-style23 {
height: 54px;
}
.auto-style24 {
width: 678px;
height: 80px;
text-align: center;
}
.auto-style25 {
height: 55px;
text-align: center;
}
.newStyle3 {
border-style: dashed;
}
.newStyle4 {
border: thin dotted #99FF99;
}
.auto-style29 {
font-weight: bold;
margin-left: 0px;
}
.auto-style30 {
width: 434px;
height: 80px;
text-align: justify;
}
.auto-style31 {
font-weight: bold;
margin-right: 27px;
}
.auto-style32 {
text-align: center;
height: 329px;
width: 1486px;
margin-top: 274px;
}
.auto-style33 {
height: 55px;
width: 434px;
text-align: justify;
}
.auto-style34 {
height: 54px;
text-align: center;
}
.auto-style35 {
text-align: center;
}
.auto-style36 {
text-align: left;
}
.auto-style37 {
width: 434px;
height: 54px;
text-align: justify;
}
.auto-style40 {
height: 65px;
text-align: center;
}
.auto-style41 {
width: 434px;
height: 85px;
text-align: justify;
}
.auto-style42 {
width: 678px;
height: 85px;
text-align: center;
}
.auto-style43 {
width: 434px;
text-align: justify;
}
.auto-style44 {
width: 678px;
text-align: center;
}
.auto-style46 {
text-align: center;
height: 85px;
}
.auto-style47 {
height: 65px;
width: 434px;
text-align: justify;
}
.auto-style48 {
width: 678px;
height: 65px;
text-align: center;
}
.auto-style49 {
height: 72px;
text-align: center;
}
.auto-style50 {
width: 434px;
height: 72px;
text-align: justify;
}
.auto-style51 {
width: 678px;
height: 72px;
text-align: center;
}
.auto-style52 {
height: 69px;
text-align: center;
}
.auto-style53 {
height: 69px;
width: 434px;
text-align: justify;
}
.auto-style54 {
width: 678px;
height: 69px;
text-align: center;
}
.auto-style55 {
width: 434px;
height: 23px;
text-align: justify;
}
.auto-style56 {
width: 678px;
height: 23px;
text-align: center;
}
.auto-style57 {
height: 23px;
text-align: center;
}



"form1" runat="server">

"Image1" runat="server" Height="62px" ImageUrl="~/Logo/logo.png" Width="255px" />
class="auto-style1">
class="auto-style36">"Label1" runat="server" ForeColor="#990099" style="font-weight: 700; text-align: center" Text="Registration Form">
class="auto-style36">
"Label2" runat="server">