Insert Null value in Access db

strSql = “INSERT INTO tbl (clmn1,clmn2) Values(1,null)”  

.net Debuggers

1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch. it resides in “C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\“ 2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR. it resides in “C:\Program Files\Microsoft.NET\SDK\v2.0\GuiDebug” more information :  http://blogs.msdn.com/noahc/archive/2006/01/04/509450.aspx

Distinct rows from Datatable

we can get distinct rows from a datatable by following way… myDataTable.DefaultView.ToTable(True, “myDistinctColumnName”) First parameter takes boolean value for mentioning we need Distinct or Not. passing True is for Distinct records.

Datatable: Filter with Wildcard Characters

To filter data in datatable use dt.Select(“ItemName LIKE ‘*product*’”) Date type: filter_string = ” taas_data_inizio = #” & dtpDataInizio.Value & “# “ String type : filter_string = ” emp_name LIKE ‘*” & txtEmpName.Text & “*’ “ more details : http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx