How to read Data table?

Question

How to read the rows from the data table? and how to read particular column in a data row? How to add these particular read column into xmal page table?

Mamta M · Answer

Aarthi, Check this link http://msdn.microsoft.com/en-us/library/cc668792.aspx

Aarthi Palanisamy · Answer

Mamta,i want to select the particular row from the sql table and i want to display it into the webpage using silverlight with help of WCF service what are all steps i need to follow .am the beginner to this silverlight concepts so please give me some suggetions.

Pravin Patil · Answer

Thanks mamta.....

Mamta M · Answer

Aarthi, Both Prabhu and Pravin have given good suggestions. Please check them and revert to us if not working.

Pravin Patil · Answer

To read from data table you simple need to apply foreach loop : [untested] foreach(DataRow row in yourTable.Rows) { string columnValue; columnValue = row["column"]; } This way you will get the row and column in each row. If you want to apply this datatable to the XAML page table then you can use below code : ; Here just replace InputData with the name of your DataTable. Hope this helps. All the best.

Prabhu Raja · Answer

Hi, foreach (DataRow dr in DataTable1.Rows) { foreach (DataColumn dc in DataTable1.Columns) { string col1 = dr[dc].ToString(); } } You can use following Blog, to Add Values to Table. http://www.c-sharpcorner.com/Blogs/6816/create-dynamic-table-with-given-row-and-column-values-from-u.aspx