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

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

Answers (4)