//Create ADODB Objects
ADODB.Connection oConn = new ADODB.ConnectionClass();
ADODB.Recordset oRS = new ADODB.RecordsetClass();
//Change Connection String depending on your SQL Server
string strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=<username>;Initial Catalog=pubs;Data Source=Your SQLServer Name";
oConn.Open(strConn,"","",0);
object objRecs = 100;
oRS = oConn.Execute("select au_Id, au_lname from authors", out objRecs,0);
//Error is generated by referencing the Fields collection
Label1.Text = oRS.Fields["au_id"].Value.ToString();
//Close all connections
oRS.Close();
oConn.Close();
//Release COM Objects
oRS = null;
oConn = null;