Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to Trim Datatable all Columns in C#( including Header )

Home
Forums
Visual Basic .NET

How to Trim Datatable all Columns in C#( including Header )

Vishal Goyal

12yAsked May 21, 2014, 9:41 AM22kVisual Basic .NET

Hi Friends,

How to Trim Datatable all cell including Column Header??

Note:I am Coverting A Excel data into Datatable.

1 Reply

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

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Vulpes12y ago
If 'dt' is your DataTable, try this code:

foreach(DataColumn dc in dt.Columns) // trim column names
{
dc.ColumnName = dc.ColumnName.Trim();
}

foreach(DataRow dr in dt.Rows) // trim string data
{
foreach(DataColumn dc in dt.Columns)
{
if(dc.DataType == typeof(string))
{
object o = dr[dc];
if(!Convert.IsDBNull(o) && o != null)
{
dr[dc] = o.ToString().Trim();
}
}
}
}