Retrive data from Datatable.......

[Inbaraj]

hi...

I have broght the database value to Datatable. Now i want to view that value in text box. Can any one say me how to view the datatable. I tryed the codeing.

   for(int i=0;i<datatable.Rows.Count;i++)
         MessageBox.Show(datatable.Rows[i].ToString())

but it is printing "System.DataTable.Row" Plz help me...

thanks in advance...

reg
Inbaraj

[GayathriP]

The code should be

for(int intOuter=0; intOuter<datatable.Rows.Count; intOuter++)
{
       for(int intInner=0; intInner<datatable.Columns.Count; intInner++)
       {
            MessageBox.Show(datatable.Rows[intOuter].ItemArray[intInner].ToString())   
       }
}

[Frinavale]

The code should be

for(int intOuter=0; intOuter<datatable.Rows.Count; intOuter++)
{
       for(int intInner=0; intInner<datatable.Columns.Count; intInner++)
       {
            MessageBox.Show(datatable.Rows[intOuter].ItemArray[intInner].ToString())   
       }
}

Thanks for the help GayathriP!

Could you both please use [code] tags when posting code.
An example of posting C# code:
[code=cpp]
//My C# code here
[/code]

An example of posting VB.NET code:
[code=vbnet]
'My Vb.NET code here
[/code]

Thank you!
-Moderator

[GayathriP]

sorry for that. i will follow the same in future