datatable – Page 4 – Tarik Billa

Mapping columns in a DataTable to a SQL table with SqlBulkCopy

August 27, 2023 by Tarik

You probably need some thing like public void BatchBulkCopy(DataTable dataTable, string DestinationTbl, int batchSize) { // Get the DataTable DataTable dtInsertRows = dataTable; using (SqlBulkCopy sbc = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity)) { sbc.DestinationTableName = DestinationTbl; // Number of records to be processed in one go sbc.BatchSize = batchSize; // Add your column mappings here sbc.ColumnMappings.Add(“field1″,”field3”); sbc.ColumnMappings.Add(“foo”,”bar”); … Read more

How to calculate sum of a DataTable’s Column in LINQ (to Dataset)?

August 20, 2023 by Tarik

If untyped (replace int with the correct data type): var sum = table.AsEnumerable().Sum(x=>x.Field<int>(3)); or: var sum = table.AsEnumerable().Sum(x=>x.Field<int>(“SomeProperty”)); If typed: var sum = table.Sum(x=>x.SomeProperty);

How to change results per page value in datatables

August 18, 2023 by Tarik

The fully correct answer would be to use both and display length to 5: $(document).ready( function(){ $(‘#table’).dataTable({ “iDisplayLength”: 5, “aLengthMenu”: [[5, 10, 25, 50, -1], [5, 10, 25, 50, “All”]] }); }); If you use JUST “iDisplayLength”, then the dropdown will not have that length in options later or when the page loads (instead you … Read more

Inline editing in the Angular Material data table

August 17, 2023 by Tarik

Well this isn’t clean inline editing, but – I’m looking for the same thing – this is close enough for my purposes: [The idea is to have a small popup when you click on the cell] My alternative Idea would be (though with more work) to replace all cells with Inputfields and bind them to … Read more

The source contains no DataRows

August 15, 2023 by Tarik

ds.Tables[4] might, but the result of your linq-query might not, which is likely where the exception is being thrown. Split your method chaining to use interim parameters so you can be dead certain where the error is occurring. It’ll also help you check for existing rows before you call CopyToDataTable() and avoid said exception. Something … Read more

Change the default width of a VuetifyJS DataTable cell

August 13, 2023 by Tarik

You can set width with header like below headers: [ { text: ‘Dessert (100g serving)’, value: ‘name’, width: ‘20%’}, { text: ‘Calories’, value: ‘calories’, width: ‘50%’ }, { text: ‘Fat (g)’, value: ‘fat’ }, { text: ‘Carbs (g)’, value: ‘carbs’, width: ‘200px’ }, ],

How to check if Datarow value is null

August 12, 2023 by Tarik

Check if the data column is not null with DataRow.IsNull(string columnName) if (!row.IsNull(“Int64_id”)) { // here you can use it safety long someValue = (long)row[“Int64_id”]; } There are overloads for it using the index of the column or if you have the instance of the DataColumn. If you are sure about the index, use the … Read more

Loop through the rows of a particular DataTable

August 12, 2023 by Tarik

For Each row As DataRow In dtDataTable.Rows strDetail = row.Item(“Detail”) Next row There’s also a shorthand: For Each row As DataRow In dtDataTable.Rows strDetail = row(“Detail”) Next row Note that Microsoft’s style guidelines for .Net now specifically recommend against using hungarian type prefixes for variables. Instead of “strDetail”, for example, you should just use “Detail”. … Read more

C# DBNull and nullable Types – cleanest form of conversion

August 7, 2023 by Tarik

The LINQ to DataSets chapter of LINQ in Action is a good read. One thing you’ll see is the Field<T> extension method, which is used as follows:- int? x = dr.Field<int?>( “Field” ); Or int y = dr.Field<int?>( “Field” ) ?? 0; Or var z = dr.Field<int?>( “Field” );

Adding new row to datatable’s top

August 4, 2023 by Tarik

You use the NewRow to create a row with the same columns. To actually get it into the DataTable, you’ve got to do myDataTable.Rows.InsertAt(myDataRow, 0); Where 0 is the index you want to insert it at.