The following samples should take advantage of using statements and furthermore built in features of the ADO.NET framework. Furthermore, if you open a connection, make sure you open it at the latest time possible and close it as soon as possible.Edit: While I was originally not trying to...

An Easy Way To Query a Database

by FZelle

You are both wrong with the DataAdapter.Why do you think there is an overload with the querystring and the connectionstring?public DataSet select_query(string query, string con_str){ try { using (SqlDataAdapter da = new SqlDataAdapter(query,con_str)) { ...

An Easy Way To Query a Database

by woric

The sample code provided by Andrew Rissing is a huge improvement over the original, but incorrectly catches the exception and displays a MessageBox. (Andrew correctly points out this is not a good idea.)A better solution is to allow the exception to fail:public DataSet...

An Easy Way To Query a Database

by PrimeCoder

Nice,How about adding a couple of other methodspublic static void Parameter(IDbCommand command, string naam, object value){ IDbDataParameter par = command.CreateParameter(); par.ParameterName = naam; par.Value = value ?? DBNull.Value; ...

Back and Forward button for MDI Parent form to traverse through opened MDI child forms

by Sarath Jayachandran

Bluetooth Desktop Locker with Android Application

by Arkadeep De

Bluetooth Desktop Locker with Android Application

Bug Fixes for Reading Barcodes from an Image - III

by Matthias Böhnke

Bug Fixes for Reading Barcodes from an Image - III

C# / VB.NET / C++ CLI and WinAPI: How to Programmatically Press Mouse Button, and Check if Mouse Button or Keyboard Key Pressed

by Emiliarge

Using WinAPI functions - GetAsyncKeyState and mouse_event

C# / VB.NET / C++ CLI: Create, read and write MS Access (mdb, accdb), MySQL, SQL Server, SQL Server Compact and SQLite databases

by Emiliarge

Both MS Access formats (mdb and new - accdb), MSSQL 2008 R2, MSSQL CE, SQLite, MySQL

C# / VB.NET / C++ CLI: Read and write MS Access (mdb) database without ADO and SQL via Microsoft DAO

by Emiliarge

Read and write data to Access databases without limitations caused by the use of the SQL.

C# / VB.NET and WinAPI: How to Access Window of Other Application

by Emiliarge

Using FindWindow() and WindowFromPoint() to identify window, and SetWindowText(), MoveWindow(), SetForegroundWindow(), EnableWindow() to interact with it

C# Storable Box Control 1.4.0.4

by Darkencrow

A multi-drawer style collapsable UI container

C# USB HID Interface

by Szymon Roslowski

Just another approach to understanding communication between HID devices and C#.

C#: Read and Write Excel (*.xls and *.xlsx) Files Content without Excel Automation (using NPOI and ADO.NET)

by Emiliarge

2 ways to read and write data to *.xls and *.xls files and display it on DataGridView.

CalcStar: A C++ Math Expression Evaluator

by trident99

CalcStar is an expandable, fast C++ function evaluator that gives the user the same computational power as a scientific calculator.

Calling orchestration using Call orchestration Shape

by Abhay giri

Here we see how can we invoke other orchestration by using Call orchestration shape

Capture a Text Image on the Tracing Layer and Passing it to a Main Form (Using OCR MODI)

by Bob Stoom

New drag-and-drop intuitive engine on the OCR MODI base

CDatabaseExt - A Simple Way to Connect to a Database and Retrieve Data

by _Flaviu

A class designed to connect to a database through ODBC and perform basic operations such as inserts, updates, and deletes

Changing Windows Aero Color

by Tejashwi Kalp Taru

Ever wanted to change the Windows Aero color without restarting the DWM?

Communication Library Files - TCP Client/Server

by Chris Jorna

Source code and demo on general TCP client & server library mainly usable for / tested on SICK lidar devices

Connecting Windows Form Application With ADO.NET in C#

by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

Convert Text Represented Number to Numeric String

by FatzBomb

How to convert a written number to a numerical value anywhere in a string.

Convert VS2008 .msi to WiX project

by User 4838655

A simple utility to convert VS2008 .msi to WiX project

Converting ANSI to Unicode and Back

by Doc Lobster

Converting Multiple Image Files to PDF

by jansok

A tip on converting multiple image files (BMP, PNG, GIF, JPEG, TIFF) to single or multiple PDF

Count the Number of OLE Automation Instances

by SaahilPriya

The sample demonstrates how to count the number of OLE Automation Objects running at a particular time.

Creating SQL Joins in Simple Steps

by Sreedhar Puligundla

Simple steps to create SQL joins by using SQL Server 2008 Management Studio

CTreeObject - A Memory CTreeCtrl like Object

by _Flaviu

A memory CTreeCtrl like object, but resident in memory only

Custom DataGridView (Nested DataGridView / TreeGridView)

by Mang Irpan

This control is a datagridview that can contain control as its node, and it can contain unlimited node control

Custom MenuStrip and A Form Without Borders (Full Control)

by Bob Stoom

Working code of the custom MenuStrip on the LinearGradientBrush constructor base. And how to control Form without borders.

Custom MessageBox with checkbox

by Avatar2400

This is a simple class that allows you to have message box with checkbox and other small features.

DataGridView Row Delete in CellSelect Mode

by Weberto.com

Event to delete rows by selected cells.

Debugging Release Projects in C++ - Finding the Lost Object Information

by Yochai Timmer

Debugging C++ projects in release. Finding the lost object information

Detecting USB Modem Device using C#

by Shivachalappa Gotur

Detecting USB Modem Device using C#.NET

Discussion About switch ... case Statement for Strings

by mbue

switch ... case statement for strings

DLL Registry Control Easier

by DX90

A simple library to control registry easier

Download Mail Details With attachment using IMAP

by Sujith Karivelil

This article Describes Connectivity to Gmail using IMAP, and also guide you to download and save mail content along with attachment.

Dynamic SQL Connection in ASP.NET 3.5 with User Controls

by ss9o9o9o

Transferring backup files from a remote SQL Server and Dynamic SQL Connection with Restore utility.

Easier FTP Management Class (.dll)

by Member 12032084

.dll for making the FTP management with VB.NET easier

Embedded WebBrowser (IWebBrowser2) in Pure C++ (no MFC, etc)

by Emiliarge

Simple WebBrowser (IE) class in Pure C++

Encrypt ConnectionString in Web.Config

by Yamin Khakhu

Encrypting the configuration in Web.Config

Execute System.Net.Sockets.Socket.Connect Method with Timeout Controlled by System.Threading.Timer

by JRINC

Connect to remote socket via System.Net.Sockets.Socket.Connect method with timeout controlled by System.Threading.Timer

Export to Excel in ASP.NET C#

by JatinKhimani

Export Gridview data in Excel formate with gridview design.

Exposing Orchestration as a Web Service

by Krishna P Seetharaman

How to expose multiple operations of an orchestration as multiple methods in a single web service(.asmx). Also explains how to use asynchronous approach in calling these web methods. We can add more methods to the orchestration and these new methods will be visible in the same web service

Fast Barcode 39 Detection

by LORY Flavien

Fast detection of big barcode 39

Finite-Difference Model for the Thermal History of the Earth

by Yuri Heymann

Source code for the article titled "A Finite-Difference Model for the Thermal History of the Earth

FxEngine Plugin to Stream Video Data from a Webcam

by m_sylvain

This tip shows how to build an FxEngine plugin to stream video data from a webcam

Generate Sample XML from XSD

by Joshi, Rushikesh

How to Generate Sample XML from XSD

Generate temporary files with any extension

by Ștefan-Mihai MOGA

How to get temporary files with any extension.

Get a list of physical disks and the partitions on them in VB.NET the easy way

by pdoxtader

Use DeviceIoControl, QueryDosDevice and WNetOpenEnum to get information about your system.

Get DataBase Connection Strings in an Easy Way

by dontumindit

Communication with database in .NET is easy but sometimes one gets stuck by wrong format of connection string

Get DataBase Connection Strings in Easy Way

by jim lahey

Or you could just pop over to:http://www.connectionstrings.com/[^]Use the exhaustive samples they provide and not hard code your connection strings by using a standard .NET configuration file:http://msdn.microsoft.com/en-us/library/1xtk877y.aspx[^]

Get DataBase Connection Strings in Easy Way

by bipin9

goto Server Explorer right Click on DataBase Click on properties in properties window you will get Connection String copy it & use where you want use !!

Get DataBase Connection Strings in Easy Way

by crocks256

The ConnectionStringBuilder classes in .NET can be quite handy...http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.aspx[^].

Get DataBase Connection Strings in Easy Way

by MikkelAndersen

I get it from the web.config via ConfigurationManager.ConnectionStrings;This makes it possible to keep all connectionstring settings in the web.config file.For example: http://www.dreamincode.net/code/snippet1676.htm[^].

Get Highlight Selected Items on CListCtrl when there is no Focus

by MaxMax14

Keep the items highlighted when focus is on another control

Hiding Data in an Image File

by Pikoh

A simple method to join several images in a single file and recover them afterwards

Hosting an Excel Application in an MDI Form

by Your Display Name Here

How to use WebBrowser, a form, and an MDI parent to open Excel files

How can we get the security access information.

by Md. Marufuzzaman

For programmers it is more important that you identify whether you are allowed to do something.

How to "Rotate" a WPF Window?

by Sergey Alexandrovich Kryukov

In response to an interesting Quick Questions & Answers Inquirer's request, I'm showing how to create an impression of window rotation in a simple way

How To Change Screen Brightness in C#

by John Melling

This is a simple program that demonstrates a method used to adjust the screen brightness on any C# application.

How to display or hide standard button cues.

by priyamtheone

How to Hide Menu in CDockablePane

by _Flaviu

A method of how to get rid of "close" menu from multiple CDockablePane panels

How To Hide Or Show .NET Tabs Programmatically

by KazMaxLtd

This article describes how to hide or show TabControl tabs at runtime

How To Hide Or Show .NET Tabs Programmatically

by Bernhard Hiller

That's far too obscure.All you need to do is store a reference to the TabPage instance which was removed from the TabPages collection of the TabControl. You may use the form where the TabControl is placed for that purpose.You could also create your own TabControl which has an extra property...

How to Lock Windows NT Workstation

by Md. Marufuzzaman

Introduction How can you lock your Windows NT based Workstation programmatically? To do this, you just need a little basic knowledge on how to use user32.dll. Here you will find a function name as LockWorkStation() and you need to know how to call this function. A sample example with the...

How to make a multi-language application in C#

by rocket42

How to make a multi-language application in C#.

How to prevent SQL Injection in Stored Procedures

by Shao Voon Wong

How to prevent SQL injection attacks when using dynamic SQL in stored procedures

HPC Template Library, A Supplement to the STL

by trident99

The HPC Template Library is a supplement to the Standard Template Library providing threadsafe containers.

Image Re-sizing Utility

by VaibhavTiparadi

Re-sizing images to equalize the width & height

Including stdafx.h in a non-default location

by Albert Holguin

The vc compiler and intellisense don't look for pre-compiled header in a similar manner, this is a summary of the issue along with workarounds

Increase productivity with Visual Studio extensions

by Ahsan Murshed

This article gives ideas to developers to increase development time productivity using the free Visual Studio 2010 extensions.

Integrate G-MAP in VB.NET Windows Application without API

by TANMAY N

How to Integrate Google map in VB.NET without using any API in VB.NET Windows application

Introducing an Open Source DirectUI Library - SOUI

by flyhigh

SOUI is a directui library and had been used in many commercial softwares, which is published based on MIT and is completely free to any user.

Joomla Remote SQL Call -VB.NET Client

by FrankNight

In this tip, I show a set of helper classes useful to prepare and send messages to the SqlXML Joomla component and execute remote SQL calls to your hosted website.

Know When CDialogBar is Closed

by _Flaviu

A way to know when a floating CDialogBar is closed

License Keys in VB.NET - Revisited

by maz2331

License Key class to make generating and validating keys easy.

List of Tables of Microsoft Access DataBase

by dontumindit

While dealing with databases, sometimes there is a need to get a list of tables in the application

Load textures using OpenGL and Light weight Corona Image I/O

by GPUToaster™

Logging SOAP Web Service Envelop (Request and Reply) in .NET

by Mohsen Heydari

Intercepting WCF and SOAP services for logging SOAP envelope

M1.NET - Decrypt Arcade Audio

by shunninghuang

Software named M1.NET which shows the details of decrypting arcade game audio

Many Questions Answered at Once — Collaboration between Windows Forms or WPF Windows

by Sergey Alexandrovich Kryukov

Popular question on Forms collaboration, also answered for WPF

Mirror keys for multiboxing MMORPG games like WOW/LOTRO

by joejames111

Raw input 64-bit .NET classes.

MVVM Taskbar Notifier

by NobsterTheLobster

Implements a taskbar notifier using an invisible window and a popup control

MySQL Connector for Visual Basic

by rolandomontero

MySQL Connector for Visual Basic, obtaining a data table

NanoXML - Simple and fast XML parser

by BrokenEvent

Simple and fast .NET XML parser without using System.Xml

Open .key and .cer files, sign string with private key

by Antonio Lopez R

Specific implemetation for Mexico CFDI. others can use as they need

Pass OUTPUT Parameter from Stored Procedure to SSIS Precendence Constraints

by Baliram Suryawanshi

Pass OUTPUT parameter from stored procedure to SSIS Precendence Constraints

Passing parameters to Success method in executeQueryAsync in SharePoint

by shahed.sohail

Passing Parameters to Success method in executeQueryAsync.

Refactoring in Visual Studio 2008

by charan anasam

Visual Studio comes with seven refactoring options as explained here.

Rendering AltNETType (= .NET FreeType port) with OpenGL

by Demid Korneev

Example of AltNETType use in OpenGL

Rendering Text with OpenType Fonts Using GDI

by wmjordan

Rendering text with OpenType fonts by P/Invoking GDI API in WinForm applications.

Running a Windows .NET application on Linux

by Nelson Kosta Souto

Running the same compiled assembly on Windows and Linux.

Scroll Window

by Tu (Le Hong)

A scroll window that surpasses the 16-bit limit and can be hosted by a dialog.

Serial Port Communication

by Sreedeep.S

Serial Communication with the .NET Framework in Winforms

Serialize/Deserialize any object to an XML file

by akramKamal

Code to serialize/deserialize any object to an XML file.

SharePoint 2013 Web Part ToolPane Tweak

by Ahmad F Hassan

5 minute trick

Shortcut: Open Containing Folder

by Ajay Vijayvargiya

Open the Folder of current file with a simple keystroke

Simple C# FTP Class

by metastruct

Easy to use class for downloading, uploading, and other FTP commands.

Simple ChessBoard Graphics

by Farhad Reza

A simple ChessBoard graphics using GDI32

Simple Graphics Class

by Farhad Reza

A simple graphics class for 2D drawing

Simple Method to Convert Latitude and Longitude to Readable Address

by Godwinsmith

Function to find the exact address of particular latitude and longitude using Google maps service in C#

Simple SSRS Report using MDX Query

by Ajit Kumar Thakur Microsoft

This tip contains simple step by step solution to read SSAS cube data using MDX query and display in SSRS report.

Single-cell Editable GridView

by Zdenek CZ

Let's go to write ASP.NET GridView with the ability to edit cell on click and save the changes on Enter

Solution information, prevent duplicate information in your projects

by Eduard Keilholz

Solution information file

SSIS - Import Text File

by Math08avan

SQL Server Integration Services - How to read a text file

Textbox Balloon Tooltip .NET 2

by Nishith Jain

Balloon tool tip for the text box.

TreeView with Controls (Supported Org Chart Style)

by Vyacheslav Chernykh

CTreeView is the advanced TreeView control for .NET WinForms that supports more features, different layouts and any controls in the nodes.

Undo/Redo Redirection for WPF

by Sergey Alexandrovich Kryukov

Focused TextBox blocks Undo/Redo invocation of other components, but the problem can be solved comprehensively

Upload the Image and Preview it Dynamically without Saving it

by M.Farrukh Abbas

How to upload an Image and preview it dynamically without saving it using FileUpload control in ASP.NET (C#).

Use IntelliSense in JavaScript Files

by TheyCallMeMrJames

Leverage VSDoc and DEBUG file documentation in VS2010

Using Data Classes in ASP.NET - A Beginner's Guide

by Wombaticus

A beginner's introduction to using data classes in ASP.NET.

Using Integer Instead of Enum in XAML

by Piyush Manharlal

Using integer instead of Enum for ComboBox and Radio Button in XAML

Using Laptop Webcam as a Touch Button

by Zain Ul Abidin

Now it's time to change the usage scope of your laptop Webcam

Visual C++: How to Create Standalone Win32 Application Not Requiring Visual C++ Runtime

by Emiliarge

How to statically link a Win32 Project with Visual C++ libraries (m***.dll)

VTK in MFC

by _Flaviu

A small guide to use VTK in MFC

Working with LINQ to Entities & LINQ to DataTable

by ShaikAnwar

This topic gives us an idea of how to write Linq queries on Entities & DataTable. This covers some basic querying and also usage of joins and group by using LINQ.

WPF Animation

by Anup Kumar Verma

Taskbar Notification like animation in WPF from code behind

WPF C# / VB.NET Additional (fourth) button on window titlebar (Aero only!)

by Emiliarge

Using WindowChrome from Microsoft.Windows.Shell.dll

WPF Preloader Control

by Diwakar M A

WPF based preloader animation sample. Let's make WPF applications more interactive during long process.

XML* (or XMLStar), a C++ STL Based XML Serialization Engine

by trident99

An STL based simple XML serialization and de-serialization engine