private void GetAllTables(DataGridView dgv, ComboBox cbo) { //make sure text is a number //int limitInt = -1; //if (!Validator.IsInteger(txtLimit.Text, out limitInt)) //{ // limitInt = 5; //} //make sure text is a number string limitStr; if (Validator.IsIntegerRegEx(txtLimit.Text)) { limitStr = txtLimit.Text; } else { limitStr = "5"; } //string table = cboTableNames.SelectedItem.ToString(); string table = cbo.SelectedItem.ToString(); //string query = "SELECT * FROM " + table + " LIMIT " + limitInt.ToString() + ";"; string query = "SELECT * FROM `" + table + "` LIMIT " + limitStr + ";"; //NEED BACKTICKS (`) for table name (`IN`) //dgvTableResults.DataSource = EpicorDB.MySqlDataToGridView(query); dgv.DataSource = EpicorDB.MySqlDataToGridView(query); //copy to clipboard dgv.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText; dgv.AutoResizeColumns(); }
//******************************** //******************************** //INVENTORY (RAW) TAB private void LoadInventoryRawDataGridView() { string query = "SELECT * FROM view_IN_alternate"; dgvInventoryRaw.DataSource = EpicorDB.MySqlDataToGridView(query); dgvInventoryRaw.AutoResizeColumns(); }
private void CustomQuery(DataGridView dgv) { //set query from textbox string query = txtCustomQuery.Text; //dgvTableResults.DataSource = EpicorDB.MySqlDataToGridView(query); dgv.DataSource = EpicorDB.MySqlDataToGridView(query); dgv.AutoResizeColumns(); }
private void txtLikeFilter_TextChanged(object sender, EventArgs e) { string likeFilter = txtLikeFilter.Text; //SELECT * FROM inventory WHERE color LIKE '%blue%' //@"SELECT table_name,column_name FROM information_schema.columns WHERE column_name like '%sku%'" string query = @"SELECT table_name,column_name FROM information_schema.columns WHERE column_name like '%" + likeFilter + "%'"; dgvSearch.DataSource = EpicorDB.MySqlDataToGridView(query); dgvSearch.AutoResizeColumns(); }
//CUSTOM TAB //******************************** //******************************** //INVENTORY TAB private void LoadInventoryDataGridView() { string query = "SELECT DISTINCT in_prime_department AS DeptNo, " + "in_item_number AS SKU, " + "in_item_description AS Description, " + "in_item_weight AS Attr1, " + "in_weight_unit AS Unit, " + "in_retail_price AS Retail, " + "in_quantity_on_hand AS QOH, " + "in_quantity_on_order AS QOO " + "FROM view_IN_alternate " + "WHERE in_sds_seq_all_stores_id=1;"; //only shows first result (there are multiple lines otherwise) dgvInventory.DataSource = EpicorDB.MySqlDataToGridView(query); dgvInventory.AutoResizeColumns(); }
private void Form1_Load(object sender, EventArgs e) { //-------------- //TABLE TAB //push data to table... //EpicorDB.MySqlDataToGridView("SELECT * FROM dw_customer LIMIT 3", dgvTableResults); dgvTableResults.DataSource = EpicorDB.MySqlDataToGridView("SELECT * FROM dw_customer LIMIT 3"); dgvTableResults.AutoResizeColumns(); //dgvTableResults.DataSource = EpicorDB.MySqlDataToGridView("SHOW TABLES"); //data to combobox (Table Names) EpicorDB.MySqlDataToComboBox(cboTableNames); //-------------- //-------------- //SEARCH TAB //search for SKU (or other relevant tables) string query = @"SELECT table_name,column_name FROM information_schema.columns WHERE column_name like '%sku%'"; dgvSearch.DataSource = EpicorDB.MySqlDataToGridView(query); dgvSearch.AutoResizeColumns(); //-------------- //-------------- //CUSTOM SEARCH //pulldown EpicorDB.MySqlDataToComboBox(cboCustomQuery); //SELECT * FROM (SHOW TABLES); //string query2 = @"SELECT * FROM information_schema.columns WHERE column_name like '%sku%'"; string query2 = @"SELECT * FROM information_schema.columns"; dgvCustomQuery.DataSource = EpicorDB.MySqlDataToGridView(query2); dgvSearch.AutoResizeColumns(); //-------------- //-------------- //INVENTORY TAB LoadInventoryDataGridView(); //-------------- //-------------- //INVENTORY (RAW) TAB LoadInventoryRawDataGridView(); //-------------- }