Retrieving data from database into textbox in c# using ASP

Question

HI FRIENDS,

please help me in retrieving data from database into textbox in c# using ASP.

when i enter REGDNO. in the textbox and click on the search button then the corresponding data of the entered REGDNO has to be displayed in the text box.

ENTER REGDNO

04331A1209

SEARCH

NAME
BRANCH
ADDRESS
PHNO
STATE

the name has to be displayed in the textbox opposite to NAME field. similarly remaining fields.

Mayur Gujrathi · Answer

http://www.c-sharpcorner.com/uploadfile/5eae74/database-operations-using-dataset/ http://www.vbdotnetheaven.com/uploadfile/5eae74/database-operations-in-VB-Net/default.aspx

Satyapriya Nayak · Answer

Hi chiranjeevi, Here is you solution. Untitled Page onclick="Button1_Click" /> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; //SqlDataAdapter sqlda; //DataSet ds; string str; protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select * from std where REGDNO='" + TextBox1.Text.Trim() + "'"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); if (reader.Read()) { TextBox2.Text=reader["NAME"].ToString(); TextBox3.Text = reader["BRANCH"].ToString(); TextBox4.Text = reader["ADDRESS"].ToString(); TextBox5.Text = reader["PHNO"].ToString(); TextBox6.Text = reader["STATE"].ToString(); reader.Close(); con.Close(); } } } Thanks If this post helps you mark it as answer

anil maske · Answer

Nice .... this code work correctly. Thanks.

Vignesh Mani · Answer

Hi Refer below link http://www.c-sharpcorner.com/Blogs/7547/

Sumata Sam · Answer

Consider the Database STUDENT consisting of following tables: tbl_Course (CourseID: int, CourseName: string) tbl_Student (USN: string, StudName: string, Address: string, CourseID: int, YrOfAdmsn: int) 1. Display the details of students (in a Grid) who belong to a particular course. 2. Display the details the students who have taken admission in a particular year. how to write code for the query 1

Noor Mohamed · Answer

Protected void btnsubmit_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(getconStr); con.Open(); SqlCommand command = new SqlCommand("select * from table_Name where column_Name='" + TxtId.Text + "'", con); SqlDataReader sdr=command.ExecuteReader(); if (sdr.Read()) { TxtName.Text = sdr[0].ToString(); TxtMark1.Text = sdr[1].ToString(); TxtMark2.Text = sdr[2].ToString(); TxtTotal.Text = sdr[3].ToString(); sdr.Close(); } command.Dispose(); conn.Close(); }

razman hashim · Answer

how to retrieving access database into edit box in visual c++ mfc by using odbc in button click??

Calvina Russel D'souza · Answer

Hello Sir, I too want to retrieve data from Database onClick of a Button but the Data should be displayed in a Table since it is Multiple Lines. For Example, on entering a Persons Aadhar No I want to display all its Medical records stored in a Database in a Table. Can you please help me with this?

Joseph Ignacius Gono · Answer

hmmm

Feroz Khan · Answer

Thanks for your Reply...

Tarun Jaiswal · Answer

You can use this : SqlConnection Conn = new SqlConnection(Connection_String); SqlCommand Comm1 = new SqlCommand(Command, Conn); Conn.Open(); SqlDataReader DR1 = Comm1.ExecuteReader(); if (DR1.Read()) { textBox.Text = DR1.GetValue(0).ToString(); } Conn.Close(); another way : Collapse | Copy Code SqlConnection Conn = new SqlConnection(Connection_String); SqlCommand Comm1 = new SqlCommand(Command, Conn); Conn.Open(); textBox.Text = Comm1.ExecuteScalar(); Conn.Close();

Palanivel Loganathan · Answer

Hi Dude , i need same output but the c# coding will be store procedure , how it can be done please thank you in advance

Priya Linge · Answer

Hi, On SearchButton Click Event write below code, Here i hv EmplyoeeData table in that i hv mentioned fields. private void Searchbtn_Click(object sender, EventArgs e) { string query = "select Name,Branch,Address,Phno,State from EmplyoeeData where REGDNO='" + txtRedNo.Text + " ' "; sqlConnection.Open(); sqlCommand = new SqlCommand(query, sqlConnection); sqlReader=sqlCommand.ExecuteReader(); while (sqlReader.Read()) { txtName.Text = sqlReader[0].ToString(); txtBrach.Text = sqlReader[1].ToString(); txtAddress.Text = sqlReader[2].ToString(); txtphno.Text = sqlReader[3].ToString(); txtState.Text = sqlReader[4].ToString(); } sqlConnection.Close(); } Hope this will help you. Thanks.

Retrieving data from database into textbox in c# using ASP

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (13)