private void cboCateg_SelectedIndexChanged(object sender, EventArgs e) { if (cboCateg.Text == "ID") { sql = "SELECT USER_ID FROM useraccounts"; config.autocomplete(sql, txtseaarch); } else if (cboCateg.Text == "NAME") { sql = "SELECT UNAME FROM useraccounts"; config.autocomplete(sql, txtseaarch); } }
private void frmStockOut_Load(object sender, EventArgs e) { sql = "SELECT SUPLIERCUSTOMERID FROM tblperson WHERE TYPE = 'CUSTOMER'"; config.autocomplete(sql, txt_cusid); sql = "SELECT `ITEMID` as 'Id Producto', `NAME` as 'Nombre', `DESCRIPTION` as 'Descripcion', `PRICE` as 'Precio', `QTY` as 'Cantidad Disponible' FROM `tblitems`"; config.Load_DTG(sql, dtgCus_itemlist); funct.ResponsiveDtg(dtgCus_itemlist); }
private void frmStockOut_Load(object sender, EventArgs e) { sql = "SELECT SUPLIERCUSTOMERID FROM tblperson WHERE TYPE = 'CUSTOMER'"; config.autocomplete(sql, txt_cusid); sql = "SELECT `ITEMID` as 'Item Id', `NAME` as 'Name', `DESCRIPTION` as 'Description', `PRICE` as 'Price', `QTY` as 'Available Quantity' FROM `tblitems`"; config.Load_DTG(sql, dtgCus_itemlist); funct.ResponsiveDtg(dtgCus_itemlist); }
private void frmEnrollStudents_Load(object sender, EventArgs e) { sql = "SELECT CONCAT( `LNAME`,', ', `FNAME`,' ', `MNAME`) FROM `tblstudent`"; config.autocomplete(sql, txtsearch); sql = "SELECT `IDNO`, CONCAT( `LNAME`,', ', `FNAME`,' ', `MNAME`) as 'FULL NAME' FROM `tblstudent`"; config.Load_DTG(sql, dtgList); dtgList.Font = new Font("Arial", 9); }
private void frmListScannedFiles_Load(object sender, EventArgs e) { sql = "SELECT ScannedId,EMPLOYEE_ID, concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) as 'Employees Name', `IMGCaption` as 'FilesName', `ImgType` as 'FilesType', `DateUpload` as 'DateUploaded' " + " FROM `tblscannedfiles` s, `employees` e WHERE `EMPLOYEE_ID` = `EmpId` AND concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) Like '%" + txtSearch.Text + "%'"; config.Load_DTG(sql, dtglist); dtglist.Columns[0].Visible = false; dtglist.Columns[1].Visible = false; sql = "SELECT concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) FROM `employees`"; config.autocomplete(sql, txtSearch); //sql = "SELECT concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) FROM `employees`" //append(sql, txtSearch) }
private void frmReturn_Load(object sender, EventArgs e) { sql = "SELECT `TRANSACTIONNUMBER` FROM `tblstock_in_out` WHERE `REMARKS`='Stockout'"; config.autocomplete(sql, txttransactionid); }
private void frmReports_Load(object sender, EventArgs e) { sql = "SELECT concat(`FIRST_NAME`,' ', `MIDDLE_NAME`, ' ',`LAST_NAME`) FROM `employees`"; config.autocomplete(sql, TextBox1); }