How To Get data in textbox from database?

Hi

sf_hussain786

You have to write sql connection and fire select query from database
and you can use Data Reader/Dataset/DataTable and assing particular value to textbox text


you can write code something like this

  string s = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

            SqlConnection con = new SqlConnection(s);

            SqlCommand cmd = new SqlCommand("select * from table where Id='" + value + "'", con);

            cmd.CommandType = CommandType.Text;

            cmd.Parameters.AddWithValue("@Id",value);



            cmd.Connection = con;

            con.Open();

           

            SqlDataReader dr = cmd.ExecuteReader();

            while (dr.Read())

            {

                TextBox1.Text = dr["username"].ToString();

                TextBox2.Text = dr["password"].ToString();

                TextBox3.Text = dr["fname"].ToString();

                TextBox4.Text = dr["gender"].ToString();

            }



        dr.Close();

        con.Close();

        

If it helps Mark as Answer

Thanks
Rajendra Patel

R D Patel

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

Hi check this:

http://www.daniweb.com/web-development/aspnet/threads/31919
http://forums.asp.net/t/1042463.aspx/1
http://bytes.com/topic/asp-net/answers/319474-displaying-data-database-textboxes

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

Hi Sf_Hussain786,
Refer to :
http://forums.asp.net/t/1042463.aspx/1

Thanks,
Sanjay

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

HI

see this link

http://www.java2s.com/Code/ASP/ADO.net-Database/ReaddatafromdatabaseincodebehindC.htm

R D Patel

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

How to Retrieve Data from database and view datas in label or textbox using ASP.NET and SQL
see here --> http://www.kumaran198726.com/2013/01/how-to-retrieve-data-from-database-and.html

Kumaran K

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

How to Retrieve Data from database and view datas in label or textbox using ASP.NET and SQL
see here --> http://www.kumaran198726.com/2013/01/how-to-retrieve-data-from-database-and.html

Kumaran K

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

Dim strConnString As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
Dim con As New SqlConnection(strConnString)
Dim str As String = "select * from Employees1 where EmployeeID = " & txtEmployeeID.Text
Dim cmd As SqlCommand = New SqlCommand(str, con)
cmd.Connection = con
con.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
While (dr.Read())
txtFirstName.Text = dr("FirstName").ToString()
txtLastName.Text = dr("LastName").ToString()
txtBirthDate.Text = dr("Birthdate").ToString()
txtCity.Text = dr("City").ToString()
txtCountry.Text = dr("Country").ToString()
End While
dr.Close()
con.Close()

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

hello sir SqlDataReader dr = cmd.ExecuteReader(); not support this reader code plse help me

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

Get data in dataset,sqlreader,datatable ....

and then Fill value to textbox

TextBox1.Text = dr["username"].ToString();

Values goes right to left...

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator