Snipplr

(C#) Check SqlDataReader Column Is Exists (extension method) - emregulcan

Wed, 11 May 2011 08:30:49 GMT

This snippet is "extension method" for IDataReader. You can use this snippet below ; I assume you have datareader like that SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.IsColumnExists("columnName")) { //do something } and also you should validation null value control if you work critical datas if (dataReader.IsColumnExists("columName")) { if (dataReader["columName"] != DBNull.Value) { //do something } }

(C#) Reading data into a dataset in C# - fengelz

Mon, 04 Apr 2011 23:25:14 GMT

Snip it if you keep forgetting how its done.

(C#) Inserting Data With C# and parameterized values - fengelz

Mon, 04 Apr 2011 23:20:28 GMT

Not that theres anything new to this. In fact its very old fashioned, but If you like me forget how its done; snip it.

(C#) Basic SQL access - brandonroath

Wed, 24 Nov 2010 02:40:23 GMT

(C#) create aspnet db in sql from .net tools - hairajeshk

Tue, 19 Oct 2010 13:13:24 GMT

create aspnet db in sql from .net tools

(C#) SQL Output Parameters - jx_boi

Tue, 31 Aug 2010 10:16:14 GMT

(C#) Simple SQL Server Diff Tool - jmcd

Fri, 13 Aug 2010 02:02:13 GMT

(C#) Pagination in SQL - tomaszsimon

Tue, 15 Dec 2009 04:37:40 GMT

Call it in the button click event after in(de)crementing CurrentPage value

(C#) ASP.net: Update SQL from a DropDownList dynamically created in a GridView. - jink

Mon, 01 Jun 2009 20:39:26 GMT

Bind the DropDownList like normal (set DataSourceID, DataTextField, DataValueField), and the SelectedValue field. AutoPostBack should be enabled. In the OnSelectedIndexChanged:

(C#) Simple SubSonic Collection Query - mordecaix7

Wed, 22 Apr 2009 15:27:02 GMT

This is an example piece of code that will load a SubSonic collection into the "col1" object. The collection class is told to look for the column "VendorId" in the products table and pull it based based on the matching supplied vendorId.

(C#) ASP.Net Page to Return an Image from an SQL Blob Query - rengber

Mon, 24 Mar 2008 21:36:37 GMT

(C#) String Validation for Sqlinjection - jags_sonawane

Thu, 14 Feb 2008 00:34:13 GMT

(C#) Database Retrieve - lfbarbieri

Wed, 09 May 2007 15:24:44 GMT

(C#) Get the Return Value from an SQL Stored Procedure - rengber

Wed, 21 Mar 2007 20:32:32 GMT

(C#) SQL Stored Proc to Generate a list of C# constants representing data field names. - rengber

Thu, 07 Dec 2006 14:58:14 GMT