Split CSV to String Array

---

More Recent Data Development Articles:

Select XML Nodes by Attribute Value
Get all name nodes use XPath expression /Names/Name. To get only male names (to select all nodes with specific XML attribute) use XPath expression /Names/Name[@type='M'].

Select Top XML Nodes using XPath
This example shows how to select Top N nodes of the specific name from an XML document.

Deserialize XML object
Example on how to Deserialize and XML object into a Class/Object

Search for text with in stored procs of a db
Use these handle statements to search for text within all your stored procs

Update XML within a table
Example on how to update a portion of XML within a table

TSQL Try Catch Block
How to use Begin Try Begin Catch in TSQL

TSQL ROW_NUMBER()
How to use TSQL ROW_NUMBER() function

Read Connection String From DLL.config file
Example on how to read from a DLL's App Config - useful when using class library and you want the library to have its own app.config

Read Connection String From DLL.config file
Example on how to read from a DLL's App Config - useful when using class library and you want the library to have its own app.config

IBM DB2 .Net Provider
Extracting Data from an iSeries is simple using IBM's .Net data provider

SQL 2005 Schema change auditing
An example of SQL 2005 Schema change auditing

Stored Procedure to DataSet
The beloved dataset. Here is an example on how to create and use them.

Exporting a datagrid object's data to Excel
Example on how to send data to Excel

Creating a dataset is simple
Example on how to create and use DataSets

SQL Connection String
How to use SQL connections strings with both Web Applications and Windows Applications

SQL statements that return particular date strings
T-SQL Date Format statements

Excel as a database - ADO.Net
Utilized Excel's OleDB provider to work like SQL

DataGridView - Binding and Filter
DataGridView - Binding and Filter

WCF with LINQ
Utilze LINQ while working with WCF. This is a good example of using the 3.5 framework