Adding database data to a textbox

Question

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

Vulpes · 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();

Sam Hobbs · Answer

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.

Suthish Nair · Answer

Is this a correct profile name "blank". Please update your valid name or your account get blocked.

Vulpes · Answer

No. it shouldn't change anything. What matters is what version of which database you're using.

Thomas J · Answer

I'm using VS2010 would that change any of the advice given above on how to enter database values into textboxes?

Vulpes · Answer

This site is a good reference for figuring out connection strings ( http://www.connectionstrings.com/ ).

Thomas J · Answer

SqlConnection con = new SqlConnection(connectionString); How can I determine the connection string.

Dorababu Meka · Answer

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/

Adding database data to a textbox

Answers (8)