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; ...

Complete Date/Time Picker Control

by Peter T. Ringering

A complete replacement to Microsoft's Date/Time Picker control.

Convert a Windows Form to PDF

by Frans Jan

This article shows how to save a Windows Form to a PDF file.

Convert Numbers to Words Neatly

by Normz Antonino

This tip shows you how to convert numbers to words neatly.

Convert Text Represented Number to Numeric String

by FatzBomb

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

Creating SQL Joins in Simple Steps

by Sreedhar Puligundla

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

Custom MessageBox with checkbox

by Avatar2400

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

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

by Yochai Timmer

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

Drawing a Custom Mainframe Window for MFC SDI Applications

by Biruk Abebe

How to completely take control of drawing a custom application window including the captionbar, menubar, toolbar, borders and statusbar in MFC Single document interface (SDI) applications using the MfcSkinSDI class.

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

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 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[^].

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 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...

HTML Parser

by Ahmed Ali El-Sayed

C# DLL for use it in .Net Applications, you can convert it easy to any code

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.

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

Rendering AltNETType (= .NET FreeType port) with OpenGL

by Demid Korneev

Example of AltNETType use in OpenGL