How to retrieve data from database in textboxes

Sakshi Kaul

I want when employee enters emp id in text box and press enter then the corresponding other details present in the registration form should be entered and by default all text box should be kept disable and when the user clicks on edit button then he should be able to edit the text (enter the information) and when he clicks on registration button then the data should be saved in other table and on clear button again the new page should be loaded

I have done coding for registration button that will save data in the table.

What all changes should be done in order to implement above scenario ?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
SqlCommand cmd = new SqlCommand();
SqlConnection con= new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=SAKSHIKAUL-LT\SQLEXORESS1;Initial Catalog=registrationForm;Integrated Security=True";
con.Open();
{
if (!this.IsPostBack)
Label1.Text = "";
}
}
protected void Button1_Click(object sender, EventArgs e)
{ SqlCommand cmd = new SqlCommand("insert into RegistrationTable" + "(EmpId,Nationality,Religion,Gender,Address,EmailId,Hobbies,MaritalStatus) values (@EmpId,@Nationality,@Religion,@Gender,@Address,@EmailId,@Hobbies,@MaritalStatus)", con);
//string insertQuery = "insert into RegistrationTable(EmpId,Nationality,Religion,Gender,Address,EmailId,Hobbies,Maritalstatus)values (@EmpId,@Nationality,@Religion,@Gender,@Address,@EmailId,@MHobbies,@Maritalstatus)";
cmd.Parameters.AddWithValue("@EmpId", TextBox1.Text);
cmd.Parameters.AddWithValue("@Nationality", TextBox2.Text);
cmd.Parameters.AddWithValue("@Religion", TextBox3.Text);
cmd.Parameters.AddWithValue("@Gender", TextBox4.Text);
cmd.Parameters.AddWithValue("@Address", TextBox5.Text);
cmd.Parameters.AddWithValue("@EmailId", TextBox6.Text);
cmd.Parameters.AddWithValue("@Hobbies", TextBox7.Text);
cmd.Parameters.AddWithValue("@Maritalstatus", TextBox8.Text);
cmd.ExecuteNonQuery();
Label1.Text = "Registered Successfuly";
}
protected void Button2_Click(object sender, EventArgs e)
{
cmd.CommandText = "update RegistrationTable set Nationality =' " + TextBox2.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Religion =' " + TextBox3.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Gender =' " + TextBox4.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Address =' " + TextBox5.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set EmailId =' " + TextBox6.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Hobbies =' " + TextBox7.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set MaritalStatus =' " + TextBox8.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.Connection = con;
cmd.ExecuteNonQuery();
Label1.Text = "Updated Successfuly";
}
protected void Button3_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
TextBox8.Text = "";
Label1.Text = "Clear All";
}
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
}

10 Replies

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

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.youtube.com/watch?v=Xl_Bk3wobrk
Thilak S7y ago
Use the below code for bringing value from database based on the given id in textbox.

Consider the ID textbox as txtEmployeeId.Text = 1;
public void btnEnter_Click(object sender, Event args e)
{
SqlConnection connect = new SqlConnection();
connect .Open();
SqlCommand command = new SqlCommand("usp_get_individual_employee_details",connect );
command.CommandType = CommandType.storedprocedure;
command.Parameters.AddWithValue("@employee_id", txtEmployeeId.Text) ;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
command.ExecuteNonQuery();
connect .Close();
}
Now, Execute the below stored procedure in Sql Server.
CREATE PROCEDURE usp_get_individual_employee_details
(
@employee_id varchar(10)
)
AS BEGIN
SELECT * FROM  WHERE EmpId = @employee_id
END
I think this should work. Reply if you have any doubts...
Ashwin Chauhan7y ago
use this link your help full.
http://www.ashishblog.com/calling-database-using-jquery-ajax-and-asp-net/
Sakshi Kaul7y ago
Is it possible to make function in css file itself?
instead of using jquery ?
Can I make a function and call in the below code?

string FetchData = ("Select EmpId,Nationality,Religion,Gender,Address,EmailId,Hobbies,Maritalstatus from EmpDetails where EmpId='" + TextBox1.Text.Trim() + "'");
cmd = new SqlCommand(FetchData, conn);
dr = cmd.ExecuteReader();
if (!this.IsPostBack)
Label1.Text = "";
Ashwin Chauhan7y ago
http://easyautocomplete.com/examples

step 1 : Create Web Service in asmx extenstion file;

step 2 : download plagin;

step 3 : set link jquery.easy-autocomplete.min.js;

step 4 : Ajax POST use

url: function(phrase) {

return "setYour WebService Url";

},

getValue: function(element) {

return element.name;

},
Sakshi Kaul7y ago
@ashwin chauhan
If I you recommend to use jquery then please help where add te jquery code?
in aspx page itself???
Sakshi Kaul7y ago
Hi

i want coding in cs page nly so for that i am trying the following:-

protected void Page_Load(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=SAKSHIKAUL-LT\SQLEXORESS1;Initial Catalog=registrationForm;Integrated Security=True";
conn.ConnectionString = @"Data Source=SAKSHIKAUL-LT\SQLEXORESS1;Initial Catalog=registrationForm;Integrated Security=True";
con.Open();
conn.Open();
{
string FetchData = ("Select EmpId,Nationality,Religion,Gender,Address,EmailId,Hobbies,Maritalstatus from EmpDetails where EmpId='" + TextBox1.Text.Trim() + "'");
cmd = new SqlCommand(FetchData, conn);
dr = cmd.ExecuteReader();
if (!this.IsPostBack)
Label1.Text = "";
}
if (dr.Read())
{
TextBox1.Text += dr[0].ToString() + " ";
TextBox2.Text += dr[1].ToString() + " ";
TextBox3.Text += dr[2].ToString() + " ";
TextBox4.Text += dr[3].ToString() + " ";
TextBox5.Text += dr[4].ToString() + " ";
TextBox6.Text += dr[5].ToString() + " ";
TextBox7.Text += dr[6].ToString() + " ";
TextBox8.Text += dr[7].ToString() + " ";
conn.Close();
Ashwin Chauhan7y ago
you can use jqery with web service and Set value
Sakshi Kaul7y ago
Hi

I have following registration form

Emp Id -> text box1
nationality-> Textbox2
Religion-> Textbox3

register button edit button cancel button

I want when employee enters the emp id in the text box then for that particular employee all the details should be entered automatically from the database.I have tried writting folowing code but its not working so what all changes should be done n the below code in order to implement the same ?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
SqlCommand cmd = new SqlCommand();
SqlConnection con= new SqlConnection();
SqlConnection conn = new SqlConnection();
SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=SAKSHIKAUL-LT\SQLEXORESS1;Initial Catalog=registrationForm;Integrated Security=True";
conn.ConnectionString = @"Data Source=SAKSHIKAUL-LT\SQLEXORESS1;Initial Catalog=registrationForm;Integrated Security=True";
con.Open();
conn.Open();
{
string FetchData = "Select * from EmpDetails where EmpId=''";
cmd = new SqlCommand(FetchData, conn);
dr = cmd.ExecuteReader();
if (!this.IsPostBack)
Label1.Text = "";
}
if (dr.Read())
{
TextBox1.Text += dr[0].ToString() + " ";
TextBox2.Text += dr[1].ToString() + " ";
TextBox3.Text += dr[2].ToString() + " ";
TextBox4.Text += dr[3].ToString() + " ";
TextBox5.Text += dr[4].ToString() + " ";
TextBox6.Text += dr[5].ToString() + " ";
TextBox7.Text += dr[6].ToString() + " ";
conn.Close();
{
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{ SqlCommand cmd = new SqlCommand("insert into RegistrationTable" + "(EmpId,Nationality,Religion,Gender,Address,EmailId,Hobbies,MaritalStatus) values (@EmpId,@Nationality,@Religion,@Gender,@Address,@EmailId,@Hobbies,@MaritalStatus)", con);
//string insertQuery = "insert into RegistrationTable(EmpId,Nationality,Religion,Gender,Address,EmailId,Hobbies,Maritalstatus)values (@EmpId,@Nationality,@Religion,@Gender,@Address,@EmailId,@MHobbies,@Maritalstatus)";
cmd.Parameters.AddWithValue("@EmpId", TextBox1.Text);
cmd.Parameters.AddWithValue("@Nationality", TextBox2.Text);
cmd.Parameters.AddWithValue("@Religion", TextBox3.Text);
cmd.Parameters.AddWithValue("@Gender", TextBox4.Text);
cmd.Parameters.AddWithValue("@Address", TextBox5.Text);
cmd.Parameters.AddWithValue("@EmailId", TextBox6.Text);
cmd.Parameters.AddWithValue("@Hobbies", TextBox7.Text);
cmd.Parameters.AddWithValue("@Maritalstatus", TextBox8.Text);
cmd.ExecuteNonQuery();
Label1.Text = "Registered Successfuly";
}
protected void Button2_Click(object sender, EventArgs e)
{ cmd.CommandText = "update RegistrationTable set Nationality =' " + TextBox2.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Religion =' " + TextBox3.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Gender =' " + TextBox4.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Address =' " + TextBox5.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set EmailId =' " + TextBox6.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set Hobbies =' " + TextBox7.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.CommandText = "update RegistrationTable set MaritalStatus =' " + TextBox8.Text + "' where EmpId='" + TextBox1.Text + "' ";
cmd.Connection = con;
cmd.ExecuteNonQuery();
Label1.Text = "Updated Successfuly";
}
protected void Button3_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
TextBox8.Text = "";
Label1.Text = "Clear All";
}
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged1(object sender, EventArgs e)
{
}
}
Ashwin Chauhan7y ago
https://stackoverflow.com/questions/17779973/refresh-an-asp-net-page-on-button-click
Help This Link Page Redirct