how to get dataset all fields data in single textbox in c#

Question

hi all how to get dataset all fields data in single textbox in c#..? thanks

Jignesh Trivedi · Answer

Hi It is depending on which format you want. Are you required any specific type of format to show data in text box...?

Abhishek Jaiswal · Answer

heyy! try this public static void DataTableToFile(string fileLoc DataTable dt) { StringBuilder str = new StringBuilder(); // get the column headers foreach (DataColumn c in dt.Columns) { str.Append(c.ColumnName.ToString() + ); } str.Remove(str.Length-1 1); str.AppendLine(); // write the data here foreach (DataRow dr in dt.Rows) { foreach (var field in dr.ItemArray) { str.Append(field.ToString() + ); } str.Remove(str.Length-1 1); str.AppendLine(); } try { Write(fileLoc str.ToString()); } catch (Exception ex) { //ToDO:Add error logging } }

Vulpes · Answer

The following code assumes you're using .NET 4.0 (VS 2010) or later. Having set the TextBox's Multiline property to true: string text = ; foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { text += String.Join( dr.ItemArray) + 
; } } textBox1.Text = text;

Renjith V S · Answer

http://stackoverflow.com/questions/4298631/how-to-fill-textbox-from-dataset