hi, I want to create Datatable sorted by...
-
My code is.... DataTable TableTemp=new DataTable(); if (dt.Rows.Count>0) { TableTemp.Columns.Add("Name"); TableTemp.Columns.Add("Send_date"); TableTemp.Columns.Add("Numbercurrent"); for(int iCounter=0;iCounter<dt.rows.count;icounter++)> { //Dua DL vao Table DataRow row=TableTemp.NewRow(); row["Name"]=dt.Rows[iCounter]["Name"]; row["Send_date"]=dt.Rows[iCounter]["Send_date"]; row["Numbercurrent"] =xl.Checkdate(DateTime.Parse(dt.Rows[iCounter]["Send_date"].ToString(),DateTime.Now); TableTemp.Rows.Add(row); } } I want to create Datatable sorted by Numbercurrent but error message Numbercurrent field not exist.... DataTable dtsort = TableTemp.Clone(); foreach (DataRow dr in TableTemp.Select("", "order by Numbercurrent Desc")) { dtsort.ImportRow(dr); } Please help me solve my problem
-
My code is.... DataTable TableTemp=new DataTable(); if (dt.Rows.Count>0) { TableTemp.Columns.Add("Name"); TableTemp.Columns.Add("Send_date"); TableTemp.Columns.Add("Numbercurrent"); for(int iCounter=0;iCounter<dt.rows.count;icounter++)> { //Dua DL vao Table DataRow row=TableTemp.NewRow(); row["Name"]=dt.Rows[iCounter]["Name"]; row["Send_date"]=dt.Rows[iCounter]["Send_date"]; row["Numbercurrent"] =xl.Checkdate(DateTime.Parse(dt.Rows[iCounter]["Send_date"].ToString(),DateTime.Now); TableTemp.Rows.Add(row); } } I want to create Datatable sorted by Numbercurrent but error message Numbercurrent field not exist.... DataTable dtsort = TableTemp.Clone(); foreach (DataRow dr in TableTemp.Select("", "order by Numbercurrent Desc")) { dtsort.ImportRow(dr); } Please help me solve my problem
Look into the DataView class
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.passion != Programming) -
Look into the DataView class
Harvey Saayman - South Africa Junior Developer .Net, C#, SQL
you.suck = (you.passion != Programming)