protected void FilledCurrentDataGrid() { string select_string = "SELECT * FROM ORDER_FORM"; MySqlCmd.MySqlAdapter adapter = new MySqlCmd.MySqlAdapter(); adapter.grid_view = this.GridView1; adapter.columns = other_cabinet_column; FormFillTools.FilledCurrentForm(WebConfigurationManager.ConnectionStrings["senshang_database_connection_string"].ToString(), select_string, ref adapter); g_dt = adapter.data_table; }
protected void FilledCurrentDataGrid(string search_string) { string select_string = "SELECT * FROM ORDER_FORM WHERE `" + Database.convert_columns_name("item") + "` = \"" + search_string.Trim() + "\" OR `" + Database.convert_columns_name("owner") + "` =\"" + search_string.Trim() + "\" OR `" + Database.convert_columns_name("confirm_number") + "` =\"" + search_string.Trim() + "\""; MySqlCmd.MySqlAdapter adapter = new MySqlCmd.MySqlAdapter(); adapter.grid_view = this.GridView1; adapter.columns = other_cabinet_column; FormFillTools.FilledCurrentForm(WebConfigurationManager.ConnectionStrings["senshang_database_connection_string"].ToString(), select_string, ref adapter); g_dt = adapter.data_table; }