// Some useful C# code snippets.
// Chris North, Virginia Tech



// turn on double buffering for non-flash graphics repainting:
this.SetStyle(ControlStyles.DoubleBuffer | ControlStyles.UserPaint | ControlStyles.AllPaintingInWmPaint, true);




// Load dataset from DB:
using System.Data.OleDb;
DataSet data;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/census4604.mdb");
OleDbCommand cmd = new OleDbCommand("SELECT * FROM States4604", con);   // SQL query
OleDbDataAdapter adpt = new OleDbDataAdapter(cmd);
data = new DataSet( );
adpt.Fill(data);   // execute the query and put result in ‘data’
dataGrid1.SetDataBinding(data.Tables[0], null);



// extract data from a dataset:
foreach(System.Data.DataRow r in data.Tables[0].Rows){
	x = Convert.ToDouble(r["Income per Capita"]);
	y = Convert.ToDouble(r["% College Grad"]);