protected void FetchCompaniesList()
{
//MySqlConnection connection = new MySqlConnection
//{
//ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
//};
//MySqlCommand command = new MySqlCommand("SELECT Name FROM `shobingg_P2M_Operations`.`Clients Invoices` group by Company", connection)
//{
//CommandType = System.Data.CommandType.Text
//};
//MySqlDataAdapter dataAdapter = new MySqlDataAdapter("SELECT ID,Name FROM `shobingg_P2M_Operations`.`Company` ", connection);
//DataTable dataTable = new DataTable();
//dataAdapter.Fill(dataTable);
//connection.Open();
//CompaniesList.DataSource = dataTable;
//CompaniesList.DataTextField = "Name";
//CompaniesList.DataValueField = "ID";
//CompaniesList.DataBind();
//connection.Close();
CompanyDAL companies = new CompanyDAL
{
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
CompaniesList.DataSource = companies.GetCompany(null);
CompaniesList.DataTextField = "Name";
CompaniesList.DataValueField = "ID";
CompaniesList.DataBind();
CompaniesList.Items.Insert(0, new ListItem("--Select Company--", "0"));
}
