How to put data from the database to a Textbox?

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

How can i put CustomerID coming from the DB to a textbox...

Posted 28-Jul-11 16:17pm

thejowker

Add a Solution

Comments

walterhevedeich 28-Jul-11 22:21pm

The question is how are you retrieving your data from your DB. It should be pretty straightforward if have done it. Otherwise, a little reading on ADO.Net may help.

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Syed Salman Raza Zaidi · Answer 1 · 2011-07-28T21:15:00

Solution 5

Hi,
Try this most simplest one :)

SqlCommand cmd = new SqlCommand("select productid from table where condition", con);
con.Open();
TextBox.Text=cmd.ExecuteScalar().toString();

Posted 28-Jul-11 21:15pm

Syed Salman Raza Zaidi

Comments

jmpapa 16-Feb-13 5:22am

What id there are 3 columns to retrieve and datas will be posted to 3 textbox?

Mohd Wasif · Answer 2 · 2011-07-28T20:00:00

txtEmployeeId.Text = dt.Rows[0]["EmployeeId"].ToString();

or use like it.

SqlCommand cmd = new SqlCommand("select * from table where condition", con);
con.Open();
SqlDataReader dtr = cmd.ExecuteReader();
if (dtr.Read())
{
TextBox.Text = dtr["ProductId"].ToString();
}
con.Close();

harikreddy · Answer 3 · 2011-07-28T20:09:00

Dim connection As String = System.Configuration.ConfigurationManager.AppSettings("Conn")
Using con As New OleDbConnection(connection)
If con.State = ConnectionState.Closed Then con.Open()
Try
sql = " SELECT CustomerID FROM TABLE NAME "
Dim cmd As OleDbCommand
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
If dr.Read Then
If dr("CustomerID") Is DBNull.Value Then
TextBox.Text = ""
Else
TextBox.Text = dr("CustomerID")
End If
End If
Catch ex As Exception
Response.write(ex.Message)
Finally
If con.State = ConnectionState.Open Then con.Close()
con.Dispose()
If Not dr Is Nothing Then
dr.Close()
End If
End Try
End Using

Christian Graus · Answer 4 · 2011-07-28T16:22:00

Solution 1

MyTextBox.Text = myCustomerId.ToString() ( in case it was an int ).

Posted 28-Jul-11 16:22pm

Christian Graus

v2

ohkuy · Answer 5 · 2011-07-28T16:40:00

Solution 2

uses the ADO.NET
Connection DB,
Command sql,
Read myCustomerId into Array or List
and return the result
last,MyTextBox.Text=result

Posted 28-Jul-11 16:40pm

ohkuy

Comments

Christian Graus 28-Jul-11 22:52pm

Why on earth would you read an array if you only want to show one result ?

ohkuy 31-Jul-11 22:03pm

Expansibility,if the result more than one?

How to put data from the database to a Textbox?

5 solutions

Solution 5

Solution 3

Solution 4

Solution 1

Solution 2

Add your solution here

Preview 0