Probleme de OLEDB et JET 4.0 sur machine 64Bits
http://blog.nkadesign.com/2008/windows-2008-the-microsoftjetoledb40-provider-is-not-registered-on-the-local-machine/
PInvoke.net : Far beyond managed code (DllImport inside)
PInvoke.net is primarily a wiki, allowing developers to find, edit and add PInvoke* signatures, user-defined types, and any other information related to calling Win32 and other unmanaged APIs from managed code (written in languages such as C# or VB.NET). sample code : [DllImport(“aygshell.dll”)] static extern uint SHRecognizeGesture(ref SHRGINFO shrg); [StructLayout(LayoutKind.Sequential)] class SHRGINFO { public uint […]
[MSSQL] Reset Identity Column
If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want. An example is if you wanted to start numbering your ID column at 1000 instead of 1. It would be wise to first check what the current identify value is. We […]
Uninstall the Vmware tools when already upgraded to workstation 8
Unable to upgrade existing VMware Tools
Dynamic where clause using Linq To SQL
var query = from c in context.Customers select c; if (name != null) query = query.Where ( customer => customer.Name == name ); if (contactName != null) query = query.Where ( customer => customer.ContactName == contactName ); This way we can pass different combinations of arguments to the method and it will still build the […]
Linq to SQL Like Operator
Starting from a simple query from Northwind Database; var query = from c in ctx.Customers where c.City == “London” select c; The query that will be sent to the database will be: SELECT CustomerID, CompanyName, … FROM dbo.Customers WHERE City = [London] There are some ways to write a Linq query that results in using […]
Winforms Textbox Autocomplete in c# using Linq
xyzDataContext dc = new xyzDataContext(); AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection(); var query = from c in dc.Clients select c.Company; foreach (String comp in query) { namesCollection.Add(comp); } tBoxCompany.AutoCompleteSource = AutoCompleteSource.CustomSource; tBoxCompany.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tBoxCompany.AutoCompleteCustomSource = namesCollection; Result => AutoCompleteMode accept thoose values : External link : AutoComplete TextBox In WinForms AutoComplete TextBox in C#