C# filling a textbox with data from dataset

[Pit]

Hi all,

Sry for the noobish question, i have just starting to learn C#..

Now I have a dataset who returns just one single record with 3 columns in it.
Now I want to bind the item from the first column to a textbox, the second item to another textbox and so on.
this is what I have:

faqBLL _localFaqBLL;
            try
            {
                int id = ListBoxFaqOverzicht.SelectedIndex;
                _localFaqBLL = new faqBLL();
               DataSet myDS = _localFaqBLL.ReadFaqDetailBLL ();
               TextBoxVraag.Text = myDS.Tables[0].Rows[0].ItemArray[0].ToString ;
            }

I can't find the error in this..
Can someone help pls.

Thx in advance.
Pit

[dip_developer]

Hi all,

Sry for the noobish question, i have just starting to learn C#..

Now I have a dataset who returns just one single record with 3 columns in it.
Now I want to bind the item from the first column to a textbox, the second item to another textbox and so on.
this is what I have:

faqBLL _localFaqBLL;
try
{
int id = ListBoxFaqOverzicht.SelectedIndex;
_localFaqBLL = new faqBLL();
DataSet myDS = _localFaqBLL.ReadFaqDetailBLL ();
TextBoxVraag.Text = myDS.Tables[0].Rows[0].ItemArray[0].ToString ;
}

I can't find the error in this..
Can someone help pls.

Thx in advance.
Pit

you better use...........

 
TextBoxVraag.Text =  myDS.Tables[0].Rows[0].ItemArray.GetValue(0).ToString();