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

Varsha B

hi all,

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

thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
Hi,
It is depending on which format you want.
Are you required any specific type of format to show data in text box...?
0
Abhishek Jaiswal12y ago
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
}
}
0
Vulpes12y ago
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) + "\r\n";
}
}

textBox1.Text = text;

0
Renjith V S12y ago
http://stackoverflow.com/questions/4298631/how-to-fill-textbox-from-dataset
0