// Database is called “MarcTest1″
// Table is called “phonebook”
// DataSet is called “ds”

string m_Connect = “Data Source=(local);integrated security=SSPI;Initial Catalog=MarcTest1;”;
SqlConnection myConn = new SqlConnection(m_Connect);
SqlDataAdapter da = new SqlDataAdapter();
myConn.Open();
DataSet ds = new DataSet();
string sQueryString = “”;
sQueryString = “SELECT * FROM phonebook”;
da.SelectCommand = new SqlCommand(sQueryString,myConn);
da.Fill(ds, “ImportTable”);
myConn.Close();