<?xml version="1.0" encoding="utf-8" ?> <codesnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <codesnippet format="1.0.0"> <header> <title>Select All Records from SQL Server Database</title> <shortcut>selallsql</shortcut> <description>Select All Records from SQL Server Database</description> <author>C# .Net Fun - http://www.dotnetfun.com - Michael G.</author> </header> <snippet> <declarations> <literal> <id>strConn</id> <type>System.String</type> <tooltip>Your SQL connection string.</tooltip> <default>"Data Source=HOSTNAME; User ID=userid; Password=password; Initial Catalog=Database;"</default> </literal> <literal> <id>strSQL</id> <type>System.String</type> <tooltip>Your SQL command string.</tooltip> <default>"SELECT * FROM MyTable;"</default> </literal> <literal> <id>TableName</id> <type>System.String</type> <tooltip>The name of the DataSet/database table.</tooltip> <default>"MyTable"</default> </literal> <object> <id>DataSet</id> <type>System.Data.DataSet</type> <tooltip>The DataSet object that will hold an in-memory representation of your table.</tooltip> <default>new DataSet()</default> </object> </declarations> <code language="CSharp"> <![CDATA[ // NOTE: This code snippet is designed for VS.NET 2005 or later. // Make sure the following import directives are set: // using System.Data; // using System.Data.SqlClient; try { DataSet ds = $DataSet$; using (SqlConnection sqlConn = new SqlConnection($strConn$)) { using (SqlDataAdapter sqlAdp = new SqlDataAdapter($strSQL$, sqlConn)) { sqlAdp.Fill(ds, $TableName$); } } } catch (SqlException e) { throw e; } catch (Exception e) { throw e; } ]> </code> </snippet> </codesnippet> </codesnippets>