Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 02, 2012 10:23 AM by Mastan Oli
Contributor
3102 Points
934 Posts
May 02, 2012 09:33 AM|LINK
Hi All,
I have Datatable which contains 10 columns out of which i only want first 4 column names.( Don't Want Each n Every Column Name)..
And these column names should get added in string array one by one....
So how should i do this ?
Member
319 Points
105 Posts
May 02, 2012 09:40 AM|LINK
hi
use Datatable.Select() method, filler which row u want in datatable
All-Star
31376 Points
5421 Posts
May 02, 2012 09:42 AM|LINK
hi, refer below code
String[] colNames = new String[4]; for (int i = 0; i < 4; i++) { colNames[i] = dt.Columns[i].ColumnName; }
5088 Points
998 Posts
May 02, 2012 10:23 AM|LINK
LINQ??? like
DataTable myTable = new DataTable(); myTable.Columns.Add("test_id", typeof(int)); myTable.Columns.Add("counts", typeof(int)); myTable.Columns.Add("c1", typeof(int)); myTable.Columns.Add("c2", typeof(int)); myTable.Columns.Add("c3", typeof(int)); myTable.Columns.Add("c4", typeof(int)); myTable.Columns.Add("s1", typeof(string)); myTable.Rows.Add(11, 12, 13, 14, 15, 16, "1x"); myTable.Rows.Add(21, 22, 23, 24, 25, 26, "2x"); myTable.Rows.Add(31, 32, 33, 34, 35, 36, "3x"); DataTable returnTable = new DataTable(); returnTable.Columns.Add(myTable.Columns[0].ColumnName + myTable.Columns[1].ColumnName + myTable.Columns[2].ColumnName + myTable.Columns[3].ColumnName); myTable.AsEnumerable().Select(T => string.Join(",", T[1].ToString() + T[2].ToString() + T[3].ToString() + T[4].ToString())).ToList().ForEach(F => returnTable.Rows.Add(F)); /*returnTable contains * column name = test_idcountsc1c2 * row1 = 11121314 * row2 = 21222324 * row3 = 31323334 * */
rohitpundlik
Contributor
3102 Points
934 Posts
Get Specific Column Names from DataTable
May 02, 2012 09:33 AM|LINK
Hi All,
I have Datatable which contains 10 columns out of which i only want first 4 column names.( Don't Want Each n Every Column Name)..
And these column names should get added in string array one by one....
So how should i do this ?
Rohit Pundlik
Please mark as answer if this helps you...
jamshed alam
Member
319 Points
105 Posts
Re: Get Specific Column Names from DataTable
May 02, 2012 09:40 AM|LINK
hi
use Datatable.Select() method, filler which row u want in datatable
karthicks
All-Star
31376 Points
5421 Posts
Re: Get Specific Column Names from DataTable
May 02, 2012 09:42 AM|LINK
String[] colNames = new String[4]; for (int i = 0; i < 4; i++) { colNames[i] = dt.Columns[i].ColumnName; }Karthick S
Mastan Oli
Contributor
5088 Points
998 Posts
Re: Get Specific Column Names from DataTable
May 02, 2012 10:23 AM|LINK
LINQ??? like
DataTable myTable = new DataTable(); myTable.Columns.Add("test_id", typeof(int)); myTable.Columns.Add("counts", typeof(int)); myTable.Columns.Add("c1", typeof(int)); myTable.Columns.Add("c2", typeof(int)); myTable.Columns.Add("c3", typeof(int)); myTable.Columns.Add("c4", typeof(int)); myTable.Columns.Add("s1", typeof(string)); myTable.Rows.Add(11, 12, 13, 14, 15, 16, "1x"); myTable.Rows.Add(21, 22, 23, 24, 25, 26, "2x"); myTable.Rows.Add(31, 32, 33, 34, 35, 36, "3x"); DataTable returnTable = new DataTable(); returnTable.Columns.Add(myTable.Columns[0].ColumnName + myTable.Columns[1].ColumnName + myTable.Columns[2].ColumnName + myTable.Columns[3].ColumnName); myTable.AsEnumerable().Select(T => string.Join(",", T[1].ToString() + T[2].ToString() + T[3].ToString() + T[4].ToString())).ToList().ForEach(F => returnTable.Rows.Add(F)); /*returnTable contains * column name = test_idcountsc1c2 * row1 = 11121314 * row2 = 21222324 * row3 = 31323334 * */playingOOPS | மெய்ப்பொருள் காண்பதறிவு
Mark as Answer If you find helpful