01-08-2012 The order of the parameters collection of an OleDbCommand must match the order to which those parameters appear in the SQL statement. Otherwise the .net framework will try to fill the parameters in your SQL statement according to the order of parameters in the OleDbCommand.Parameters collection. This can cause an Data type mismatch inContinue reading “Is Order Of OleDbCommand.Parameters Important”
Tag Archives: C#.NET
How to use LIKE operator in Dataview.RowFilter for Date Time or Numaric Fields using CONVERT
2012-01-16 // http://pagead2.googlesyndication.com/pagead/show_ads.js The RowFilter property of the DataView allows to use flexible string similar to SQL or LINQ to easily filter rows wihtout having to iterate through them. I had to implement a fully flexible search module for a project I’m working on. The user had to be able to perform a string searchContinue reading “How to use LIKE operator in Dataview.RowFilter for Date Time or Numaric Fields using CONVERT”
How to auto save the data table in memory into database?
2010-04-01 We frequently get to fetch data from the database, update them and then write them back to the database. Most of the time we only have to write them back as individual records. How about updating a whole database table in the memory and having to synchronize all changes to the actual data table? My initial thoughtContinue reading “How to auto save the data table in memory into database?”
C# ASP.NET – GridView : How to Use Checkbox in Gridview to Select Multiple Rows
2009-01-06 // http://pagead2.googlesyndication.com/pagead/show_ads.js I wanted to select multiple rows of the grid view using check boxes to select each row. In this post I will discus how and what I did to achieve this goal… I used a template column which holds a check box to select or de-select a row in the grid view.Continue reading “C# ASP.NET – GridView : How to Use Checkbox in Gridview to Select Multiple Rows”
C# ASP.NET – GridView : How to Keep Modified Data of Template Fields when Paging is Enabled?
2008-12-04 Today I had to take care of a problem of a certain company (CIS) that I consult. They had a problem of keeping the values modified in a template field of a gridview when the user moves from one page of the grid to another. Template fields allow us to add custom columns intoContinue reading “C# ASP.NET – GridView : How to Keep Modified Data of Template Fields when Paging is Enabled?”
I Learnt Today 