Adding database data to a textbox

Thomas J

15y2.9kWindows Forms

I am stuck as to how to add individual database values from a database I created to a textbox.

8 Replies

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

Vulpes15y ago
Accepted answer
You can also use a DataReader. For example, if you're using SQL Server, the code would be something like this:

SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.CommandText = "SELECT someColumn FROM someTable";
SqlDataReader reader = cmd.ExecuteReader();
reader.Read(); // read first row
textBox1.Text = reader["someColumn"].ToString();
con.Close();
0
Sam Hobbs15y ago
There are many articles in this web site that can help you. There are even a few just about how to create connections and then you can get the connection string created for you automatically. One way is to go to the Project's Settings.Settings file and add a connection string property there and then you can use that to create a connection string for your project, but you probably need more instructions for how to do that.
0
Suthish Nair15y ago
Is this a correct profile name "blank". Please update your valid name or your account get blocked.

0
Vulpes15y ago
No. it shouldn't change anything.

What matters is what version of which database you're using.
0
Thomas J15y ago
I'm using VS2010 would that change any of the advice given above on how to enter database values into textboxes?
0
Vulpes15y ago
This site is a good reference for figuring out connection strings (http://www.connectionstrings.com/).
0
Thomas J15y ago
SqlConnection con = new SqlConnection(connectionString);

How can I determine the connection string.
0
Dorababu Meka15y ago
Get the Database values to a dataset and assign them to individual text boxes as follows

textbox1.Text = YourDataset.Tables["Table"].Rows[0]["YourDatabaseColumnname"].ToString();

Fore more information look at this article

http://www.c-sharpcorner.com/UploadFile/syedshakeer/1402/
0