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