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

.NET

VS2005

VS2008

Visual-Studio

VS2010

VS.NET2003

An Easy Way To Query a Database

14 Feb 2011 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

23 Feb 2011 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; ...

An Easy Way To Query a Database

14 Feb 2011 by Andrew Rissing

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 Updated Batch Image Resize Tool

22 Aug 2014 by rmliu

Resize either images or canvas only, resize batch images

Arabic Calendar Date to English Calendar Date Windows Form C#

7 Jan 2015 by shouvith hydrose Kerala

This article explains how to change Arabic Calendar Date to English Calendar Date in Windows Form C#.

.NET

VS2010

Visual-Studio

Arduino Code Printing

15 Nov 2015 by David Vanson

A small application to pretty print Arduino code with syntax highlighting

VB10

VS2013

VS2010

ASP.NET DatePicker (Persian/Gregorian)

28 Jul 2014 by Ruhollah Heidarpour

Just another ASP.NET Persian(Jalali/Shamsi/Solar) / Gregorian Datepicker

ASP.NET Menu Control Issue in Chrome and Safari

26 Jul 2012 by Tejas Vaishnav

ASP.NET menu control not shown properly in Chrome and Safari

ASP.NET MVC 4 for Visual Studio 2010 Installation Errors - Incompatible with .NET 4.5 or Earlier, Upgrade to .NET Framework 4.5 latest version

27 Sep 2012 by Shemeer NS

ASP.NET MVC 4 for VS2010 Installation Errors, 0x81f40001 - This product is incompatible with .NET 4.5 or earlier. You must upgrade to .NET Framework 4.5 to the latest version before installing this product, with Web Platform Installer and MSI.

Auto Clearing Label by Extension

14 Apr 2016 by veen_rp

This message will self destruct in 5 seconds...

.NET

VS2010

extension

Auto Completion for #include in VS2010

1 May 2010 by Ajay Vijayvargiya

Visual Studio 2010, for Visual C++ projects/code, now supports auto complete feature for #include statement too!Just type in #include directive followed by " or

C++

VS2010

Visual-Studio

Automatic Skew Correction of Scanned Documents

1 Nov 2015 by Pavel Torgashov

Simple and fast skew correction of scan docs in C#

Autos - Immediate Access to Resources Without Clicking

1 Jan 2015 by tc99

Immediate access to resources without clicking

BackUp and Restore with SMO of SQL Server 2008

26 Oct 2015 by Hernán Hegykozi

This tip will show how to perform a backup and restore database from an application in VB.NET 2010.

Balloon Message using JavaScript & CSS in ASP.NET

18 Feb 2015 by AMB-03

This is a very simple way to create a balloon message... without using any plugin

Basic MVVM and ICommand Usage Example

2 Mar 2017 by Nomesh G

Setting up basic MVVM in WPF and ICommand usage to allow operations on ViewModel from view.

Batch IDE

20 Mar 2015 by Alaa Ben Fatma

Small tool to write, run batch codes

Bench a Dialog on the Taskbar

26 Dec 2014 by Roger65

A project to place a Dialog Box on the Taskbar

Best way to use Entity Framework

14 Jan 2013 by Kundan Singh Chouhan

Simplest, best and most robust architecture.

BIM-ISO8583

25 Mar 2013 by Bim Garcia

Implementation of ISO8583 in .NET

Binarizing image (Thresholding) using EmguCV

6 Jul 2013 by hirosht

Step by step method of thresholding a image using the EmguCV API in C#

Bind Crystal Reports with Dataset or Datatable

5 Aug 2014 by saurav ray

Article determines how to bind a crystal report with a virtual database

Bind Dropdownlist in ASP.NET using jQuery AJAX

26 Nov 2013 by Amol Jadhao

How to bind dropdownlist in ASP.NET using JQuery Ajax

Binding Enum-Values to a ComboBox

15 Mar 2015 by manchanx

Tidy, generic solution to bind Enums (with or without a DescriptionAttribute) to a ComboBox or other Controls

Binding jqxGrid to SQL Database using ASP.NET Web Service ( Responsive & Right-to-Left & Farsi )

12 May 2015 by Masoud Ehteshami (Iran)

main source : https://www.jqwidgets.com

BizTalk Mapping - Map Multiple Schemas to a Single Output Schema

6 Mar 2015 by prachi_pandey

Map fields from multiple schemas to fields of a single output schema

Bootstrap datepicker and Knockout Model Binding

30 May 2014 by DiponRoy

Bootstrap datepicker and Knockout Model Binding

Building OrderBy Lambda Expression from Property Name in C#

10 Sep 2014 by DiponRoy

Let's make a lambda expression from a property name of a particular entity, and use it for OrderBy shorting

C# - Fast Memory Copy Method with x86 Assembly Usage

19 Dec 2014 by OKarpov

How to use ASM in C#.NET and most fast memory copy method

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

29 Sep 2014 by Emiliarge

Using WinAPI functions - GetAsyncKeyState and mouse_event

C# Bluetooth Monitor for Lego Mindstorms NXT

19 Aug 2015 by charles922

Program that continuously monitors the NXT via Bluetooth

C# CountryInfo LanguageInfo CurrencyInfo Classes

20 Jun 2014 by Jochen Scharr

C# CountryInfo class, LanguageInfo class and CurrencyInfo class, derived from CultureInfo respectively RegionInfo for a more intuitive and compile-safe handling of countries, languages and currencies

C# Fast Rational Arithmetic

22 Feb 2015 by D. Christian Ohle

New Rational class to solve epsilon and robustness problems especially for graphics algorithms.

.NET

VS2010

Visual-Studio

C# USB HID Interface

2 Sep 2013 by Szymon Roslowski

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

C#: WebBrowser vs Gecko vs Awesomium vs OpenWebKitSharp: What To Choose And How to Use

1 Feb 2015 by Emiliarge

Comparison of 4 browser engines and controls + some tips for using them (in attached projects and in tip text). Short and clear.

C#: Website HTML Content Parsing, or How To Get Needed Info From Website

12 Jan 2015 by Emiliarge

How to get and parse website content.

C++: Custom RTTI

12 Apr 2016 by Shao Voon Wong

This tip presents a custom RTTI class which is 10x faster than dynamic_cast

C++

VS2010

C++: Prefer Curiously Recurring Template Pattern (CRTP) to Template Pattern

26 Oct 2016 by Shao Voon Wong

C++: Prefer Curiously Recurring Template Pattern (CRTP) to Template Pattern

Calendar of Events in Windows Phone

15 Oct 2012 by Houssem Dellai

Developing a Windows Phone app step by step

Calling Server-Side Code from Client-side Using JavaScript and TextBox's onblur Event

6 Mar 2015 by Ankur .K. Vishwakarma

Calling server-side code from client-side using JavaScript and TextBox's onblur event

Change of Basis for Rotations and Vectors

3 Sep 2014 by milkboy31415

This code transforms rotations and vectors between reference frames such as Unreal, 3d Studio Max, etc.

Changing Windows Aero Color

24 Jun 2013 by Tejashwi Kalp Taru

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

Check maxlength of multiline textbox in JavaScript

21 Feb 2012 by Surjit Singh Dadhwal

This post will help you to resolve problem of checking maxlength of Multiline textbox (Internet Explorer, Chrome & Firefox)

Check Modem or GSM Phone by AT Commands

26 Nov 2014 by SergVoloshyn

Main program for testing modem or GSM phones by AT commands, use only standard classes and libraries.

Cinchoo - Simplified File Type Associations Development

4 Feb 2015 by Cinchoo

Simple and easy to associate file types to an application

Clear Text On Windows Aero Glass

9 Jun 2014 by Rixterz123

How to get text to show perfectly clearly on Aero glass

Color Block Overlay for DataGridView

27 May 2014 by Matus Kovacik

This component allows to overlay grid with colored blocks spanning across multiple columns.

ColorSelector and MenuButton in GIS Applications

30 Jun 2015 by Wu Yehao

A ColorSelector control used in GIS Applications, with a menu button for displaying

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

27 Sep 2014 by Ahmad A.A. Ahmad

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

Communication Library Files - TCP Client/Server

2 Apr 2015 by Chris Jorna

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

Console BEEP Methods, Notation, and Generation

13 Aug 2012 by Dustin Halstead

Hark back to the days of text based adventure games, and simple PC, speaker sound.

Constructor Dependency Injection Pattern Implementation in C#

22 Sep 2014 by Sandeep Singh Shekhawat

This tip is about the Constructor Dependency Injection Pattern Implementation in C#.

Consuming JsonP from a WCF Service ( C# .Net ) using jQuery across different Domains

22 Jul 2014 by Rocky R. Fernandes

Accessing Json Data across different domain using JsonP to get arround Security warning

Controlling Drawn Shapes #2 (simulator)

15 Jan 2015 by rld1971

Adding a physics engine and investigating other .NET tools

Convert doc/docx Documents to PDF with Foxit Reader

10 Apr 2015 by El_Codero

Convert doc/docx documents to pdf with Foxit Reader Printer. Works without use of Word Interop/SharePoint.

Convert Text Represented Number to Numeric String

7 Jun 2013 by FatzBomb

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

Copy document with versions from SharePoint 2010 to SharePoint 2013 Online site using .Net Managed Client Object Model

4 Aug 2015 by ShrutiASharma

Utilizing SharePoint Client Object model to copy files with versions from SharePoint 2010 site to SharePoint 2013 online site.

CPU Usage with graphical indication using C# .NET

19 Nov 2012 by Tyronne Thomas

CPU usage with C#.

Create a Drop Down Calculator Opens like DateTimePicker

24 Jun 2015 by Nadun Liyanage

This tip describes creating a user control to display a drop down calculator that pops out like the DateTimePicker in Visual Studio

Create Data and Control Templates using Delegates

21 Aug 2014 by Paulo Zemek

Avoid generating strings as templates. Avoid the complicated FrameworkElementFactory. Create templates that use a delegate to create new instances, so you can use normal code to do the job.

Create Folders Using Data from Excel File

22 Aug 2014 by brpulsani

How to create folders using data from Excel file

Office

VS2010

Visual-Studio

Create PDF from Images using VB.NET

24 May 2015 by Fahmi Noor Fiqri

Create PDF from Image files using VB.NET and PDFSharp library.

VS2010

Visual-Studio

Create SendEmail Workflow 4 Custom Activity

22 Aug 2013 by User 8388951

In this tip, we are going to create an activity that can send an e-mail message to a target user.

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

17 Aug 2014 by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

Creating a folder the advanced way [VB.Net Code]

8 Jul 2010 by TechKidd

This trick is on a intermediate/advanced level.

VS2010

Visual-Studio

Creating a Issue in Jira using Rest Api

5 Oct 2014 by Abhijit Ghosh (Subho)

Creating a Issue in Jira using Rest API and Microsoft XML Core Services (MSXML)

Creating an Issue with Multiple Attachments in Jira using Rest API

19 Oct 2014 by Abhijit Ghosh (Subho)

This is an alternative for "Creating a Issue in Jira using Rest API". This is an upgraded version as it contains a way of sending attachments with the issue. This version doesn't use MSXML as it is not recommended by Microsoft.

Creating ConcurrentPartitionedDictionary

11 Nov 2014 by D Sarthi Maheshwari

A suggested solution to create serializable Partition based ConcurrentDictionary (reducing chances of OOM errors, reduced memory consumption and adding capability to hold bigger KVP set in Dictionary).

Creating PartitionedDictionary

2 Nov 2014 by D Sarthi Maheshwari

A suggested solution to create Partition based Dictionary (reducing chances of OOM errors and adding capability to hold bigger KVP set in Dictionary).

CUDA 3.0 and Nexus Parallel Nsight on VS 2010

6 Jun 2010 by GPUToaster™

CUDA