protected void FillCompanyddl()
{
//Connecting to Database to get list of companies name to use it in search criteria
CompanyDDL.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select Company--", "0"));
string constr = ConfigurationManager.ConnectionStrings["MySQLConn"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT Name FROM `shobingg_P2M_Operations`.`Clients Invoices` group by Company"))
{
MySqlDataAdapter adp = new MySqlDataAdapter("SELECT ID,Name FROM `shobingg_P2M_Operations`.`Company` ", con);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
}
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = con;
con.Open();
//CompanyDDL.DataSource = cmd.ExecuteReader()
CompanyDDL.DataSource = dt;
CompanyDDL.DataTextField = "Name";
CompanyDDL.DataValueField = "ID";
CompanyDDL.DataBind();
con.Close();
}
}
}
protected void loadCompanyDDL()
{
var x = ClientManager.getAllResellers();
CompanyDDL.DataSource = x;
CompanyDDL.DataTextField = "name";
CompanyDDL.DataValueField = "resellerid";
CompanyDDL.DataBind();
}
protected void ShowCreateStockReceiveBut_Click(object sender, EventArgs e)
{
ClientDetailPnl.Visible = true;
QtyTB.Text = "";
InvoiveTB.Text = "";
RemarksTB.Text = "";
CompanyDDL.ClearSelection();
// ShowCreateStockReceiveBut.Visible = false;
}
