private void FrmCustomerList_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'northwindDataSet.Customers' table. You can move, or remove it, as needed.
//this.customersTableAdapter.Fill(this.northwindDataSet.Customers);
//Option 1
SqlHelper.ConnectionString = Settings.Default.ConnectionString;
SqlHelper.Helper.Fill(CommandType.Text, "Select * from customers", northwindDataSet.Customers);
//Option 2
var sql = new SqlProvider(Settings.Default.ConnectionString);
sql.Fill(CommandType.Text, "select * from customers", northwindDataSet.Customers);
//Option 3
var dao = new CustomersDA();
dao.Fill(northwindDataSet.Customers);
}