For .Net Framework 3.5+ DataTable dt = new DataTable(); DataRow[] dr = dt.Select(“Your string”); DataTable dt1 = dr.CopyToDataTable(); But if there is no rows in the array, it can cause the errors such as The source contains no DataRows. Therefore, if you decide to use this method CopyToDataTable(), you should check the array to know … Read more
Here, give this a shot (this is just a pseudocode) using System; using System.Data; using System.Data.SqlClient; public class PullDataTest { // your data table private DataTable dataTable = new DataTable(); public PullDataTest() { } // your method to pull data from database to datatable public void PullData() { string connString = @”your connection string here”; … Read more
You can use the following code to add column to Datatable at postion 0: DataColumn Col = datatable.Columns.Add(“Column Name”, System.Type.GetType(“System.Boolean”)); Col.SetOrdinal(0);// to put the column in position 0;
First, your second option isn’t quite valid HTML in the sense that all of the rows (TR) in a table should contain an equal number of columns (TD). Your header has 1 while the body has 3. You should use the colspan attribute to fix that. Reference: “The THEAD, TFOOT, and TBODY sections must contain … Read more
You can use operator Contains, private void ContainColumn(string columnName, DataTable table) { DataColumnCollection columns = table.Columns; if (columns.Contains(columnName)) { …. } } MSDN – DataColumnCollection.Contains()
I would recommend ClosedXML – You can turn a DataTable into an Excel worksheet with some very readable code: XLWorkbook wb = new XLWorkbook(); DataTable dt = GetDataTableOrWhatever(); wb.Worksheets.Add(dt,”WorksheetName”); The developer is responsive and helpful. The project is actively developed, and the documentation is superb.
You can use ImportRow method to copy Row from DataTable to DataTable with the same schema: var row = SourceTable.Rows[RowNum]; DestinationTable.ImportRow(row); Update: With your new Edit, I believe: var desRow = dataTable.NewRow(); var sourceRow = dataTable.Rows[rowNum]; desRow.ItemArray = sourceRow.ItemArray.Clone() as object[]; will work
The following shorter version opens fine in Excel, maybe your issue was the trailing comma .net = 3.5 StringBuilder sb = new StringBuilder(); string[] columnNames = dt.Columns.Cast<DataColumn>(). Select(column => column.ColumnName). ToArray(); sb.AppendLine(string.Join(“,”, columnNames)); foreach (DataRow row in dt.Rows) { string[] fields = row.ItemArray.Select(field => field.ToString()). ToArray(); sb.AppendLine(string.Join(“,”, fields)); } File.WriteAllText(“test.csv”, sb.ToString()); .net >= 4.0 And … Read more
Try this: dataTable.Columns[“Marks”].ColumnName = “SubjectMarks”;
Try this (LINQ method syntax): string[] columnNames = dt.Columns.Cast<DataColumn>() .Select(x => x.ColumnName) .ToArray(); or in LINQ Query syntax: string[] columnNames = (from dc in dt.Columns.Cast<DataColumn>() select dc.ColumnName).ToArray(); Cast is required, because Columns is of type DataColumnCollection which is a IEnumerable, not IEnumerable<DataColumn>. The other parts should be obvious.