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