[2.0] How to presents data from the database in textbox?

[jsc0624]

I have here a code for dropdownlist to present data from the database.

                DataTable dtCountry = new DataTable();

                daCountry.Fill(dtCountry);

                countryList.DataSource = dtCountry;
                countryList.DataTextField = "Country";
                countryList.DataValueField = "CountryID";
                string countryID = clusterList.SelectedValue;

What about the code for textBox? Many thanks!!!

[Rauland]

Hi,not sure whether this is what your´re looking for,

I haven´t tried it out either,..

Let´s say the text you are interested in is at row 3, column 3;

textbox.text = dtCountry .Rows[3][3].ToString()

[jsc0624]

I tried to used this code in order for me to view the current row in the database to a textbox.

lblSiteName.Text = dtSite.Rows.ToString();

But the output is:

System.Data.DataRowCollection

How can I fixed this thing? Thanks

[mendhak]

Look at what he said:

dtCountry .Rows[3][3].ToString()

You need to specify a row number and a column number in the square brackets.