protected void RunFilter(String querystring, String col, String val, String includedparts) { //AccessDataSource1.SelectCommand = "SELECT [ProductLine], [Series], [Codename], [ModelName], [ConfigurationNumber], [ReleaseDate], [CodenameInSpareParts] FROM [Products_Basic] WHERE (Series = '" + currentseries + "') AND (" + col + " LIKE '%" + val + "%') ORDER BY [ReleaseDate] DESC, [Codename], [ConfigurationNumber]"; AccessDataSource3.SelectCommand = "SELECT ProductConfiguration.ConfigurationNumber, PartsBOM.PRTNUM, PartsBOM.PRTEUREPAI, PartsBOM.COLVAL, PartsOrdPart.DESCRIPTION, PartsOrdPart.LOCATION, PartsOrdPart.LISTEACH, PartsOrdPart.QUANTITY FROM ((PartsBOM INNER JOIN PartsOrdPart ON PartsBOM.PRTNUM = PartsOrdPart.PARTNUM) INNER JOIN ProductConfiguration ON PartsBOM.MDLCONFIG = ProductConfiguration.ConfigurationNumber) WHERE (PartsOrdPart.DESCRIPTION <> 'ZERO') AND (ProductConfiguration.ConfigurationNumber = '" + querystring + "') AND (" + col + " LIKE '%" + val + "%')" + includedparts + " ORDER BY PartsOrdPart.DESCRIPTION, PartsBOM.PRTNUM"; AccessDataSource3.DataBind(); GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { Session["Now"] = DateTime.Now.ToString(); AccessDataSource3.Insert(); AccessDataSource1.Update(); Response.Redirect("~/Member/ViewHistory.aspx"); }
private void get_product() { DataView dv = (DataView)AccessDataSource3.Select(DataSourceSelectArguments.Empty); DataTable myTable = new DataTable(); myTable = dv.ToTable(); okquery_string = myTable.Rows[0][3].ToString(); okentry_string = myTable.Rows[0][4].ToString(); authrization_type = myTable.Rows[0][1].ToString(); }
private string GetDescriptionById(string id) { AccessDataSource3.SelectParameters["CategoryID"].DefaultValue = id; DataView result = (DataView)AccessDataSource3.Select(DataSourceSelectArguments.Empty); if (result.Count == 0) { return(string.Empty); } return(result[0]["Description"].ToString()); }