Do you mean this one ?
const string sql = "SELECT * FROM MyTable";
var dataTable = new DataTable("MyTable");
using (var sqlConnection = new SqlConnection("MyConnectionStringBlaBlaBla"))
{
sqlConnection.Open();
using (var sqlDataAdapter = new SqlDataAdapter(sql, sqlConnection))
{
sqlDataAdapter.Fill(dataTable);
}
}
MessageBox.Show(dataTable.Rows[0].ItemArray[0].ToString());