Advanced Search

Return to Snippet

Revision: 43997
at April 27, 2011 19:29 by fengelz
Updated Code 
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

var connectionStr = ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(connectionStr);
cmd.Connection.Open();
cmd.CommandText = "SELECT name, lastName FROM myTable";
var users = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(users);
cmd.Connection.Close();
cmd.Connection.Dispose();

Revision: 43996
at April 27, 2011 19:28 by fengelz
Updated Code 
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
var connectionStr = ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(connectionStr);
cmd.Connection.Open();
cmd.CommandText = "SELECT name, lastName FROM myTable";
var users = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(users);
cmd.Connection.Close();
cmd.Connection.Dispose();

Revision: 43995
at April 4, 2011 23:25 by fengelz
Initial Code 
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
var connectionStr = ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(CONNECTIONSTR);
cmd.Connection.Open();
cmd.CommandText = "SELECT name, lastName FROM myTable";
var users = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(winners);
cmd.Connection.Close();
cmd.Connection.Dispose();
Initial URL 









Initial Description





Snip it if you keep forgetting how its done.









Initial Title





Reading data into a dataset in C#









Initial Tags





database, sql, c#









Initial Language





C#