how to get data 25 column of 100 column from datatable

Question

i have a data table in which 100 column but i want get only 25 column values.

Midhun T P · Answer

Hi You can use below code to get first 25 columns from datatable - for (int i = dt.Columns.Count - 1; i >= 25; i--) { dt.Columns.RemoveAt(i); }

Vaibhav Deshmukh · Answer

Hi Udaybhan Singh Just select Columns in your SQL query whichever you want like e.g Below image showing tblHPAInsurance and has many Columns but I want only ID and PolicyNo columns. Sowhen you write Sql query just write Select IDPolicyNo fromtblHPAInsurance where (Your condition) [Condition is optional]. In your Case In Sql Query Select 25 columns those you want. Select Coumn1Column2....Collumn25 from yourtable that's it. Hope this will help you.