public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(extrusionID,partName,description,partNumber,size,sizeUnits,color,extrusionAngleA,angleAUnits,extrusionAngleB,angleBUnits,extrusionAngleC,angleCUnits,maxLength,lengthUnits,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + ExtrusionName + "','" + ExtrusionDescription + "','" + ExtrusionNumber + "'," + ExtrusionSize + ",'" + SizeUnits + "','" + ExtrusionColor + "'," + AngleA + ",'" + AngleAUnits + "'," + AngleB + ",'" + AngleBUnits + "'," + AngleC + ",'" + AngleCUnits + "'," + ExtrusionMaxLength + ",'" + MaxLengthUnits + "'," + UsdPrice + "," + CadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(rollID,partName,partNumber,width,widthUnits,length,lengthUnits,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + ScreenRollName + "','" + PartNumber + "'," + ScreenRollWidth + ",'" + ScreenRollWidthUnits + "'," + ScreenRollLength + ",'" + ScreenRollLengthUnits + "'," + UsdPrice + "," + CadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(srAccID,partName,description,partNumber,color,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + Sunrail300AccessoriesName + "','" + Sunrail300AccessoriesDescription + "','" + PartNumber + "','" + Sunrail300AccessoriesColor + "'," + Sunrail300AccessoriesUsdPrice + "," + Sunrail300AccessoriesCadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(insulatedFloorID,partName,description,composition,partNumber,size,sizeUnits,maxWidth,widthUnits,maxLength,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + InsulatedFloorName + "','" + InsulatedFloorDescription + "','" + InsulatedFloorComposition + "','" + PartNumber + "'," + InsulatedFloorSize + ",'" + InsulatedFloorSizeUnits + "'," + InsulatedFloorMaxWidth + ",'" + InsulatedFloorMaxWidthUnits + "','" + InsulatedFloorMaxLength + "'," + InsulatedFloorUsdPrice + "," + InsulatedFloorCadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); count = selectTable.Count; try { sqlInsert = "INSERT INTO " + table + "(accId,partName,description,partNumber,color,packQuantity,width,widthUnits,length,lengthUnits,size,sizeUnits,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + AccessoryName + "','" + AccessoryDescription + "','" + AccessoryNumber + "','" + AccessoryColor + "'," + AccessoryPackQuantity + "," + AccessoryWidth + ",'" + AccessoryWidthUnits + "'," + AccessoryLength + ",'" + AccessoryLengthUnits + "'," + AccessorySize + ",'" + accessorySizeUnits + "'," + AccessoryUsdPrice + "," + AccessoryCadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); } catch (Exception ex) { string troubleshoot = ex.Message; } }
//Select all parts from the database public System.Data.DataView SelectAll(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { //set up a dataview object for object member data System.Data.DataView anObjectTable = new System.Data.DataView(); //select row based on table name and part number dataSource.SelectCommand = "SELECT schematicNumber, description, partName, usdPrice, cadPrice, status FROM " + table + " WHERE schematicNumber='" + partNum + "'"; //assign the row to the dataview object anObjectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //return the DataView object return(anObjectTable); }
public DataView getUserListData() { System.Web.UI.WebControls.SqlDataSource sds = new System.Web.UI.WebControls.SqlDataSource(); sds.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; String SQLStr = "SELECT username,name,dep,mail,note FROM AspNetLinkUserData"; sds.SelectParameters.Clear(); //sds.SelectParameters.Add("group_name", "%" + group_name + "%"); sds.SelectCommand = SQLStr; DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); return(dv); }
//Database select all public System.Data.DataView SelectAll(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { //set up a dataview object for object member data System.Data.DataView anObjectTable = new System.Data.DataView(); //select row based on table name and part number dataSource.SelectCommand = "SELECT partName, description, partNumber, color, size, sizeUnits, extrusionAngleA," + " angleAUnits, extrusionAngleB, angleBUnits, extrusionAngleC, angleCUnits, maxLength, lengthUnits, usdPrice, cadPrice, status FROM " + table + " WHERE partNumber = '" + partNum + "'"; //assign the row to the dataview object anObjectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //return the DataView object return(anObjectTable); }
//Select all parts from the database public System.Data.DataView SelectAll(System.Web.UI.WebControls.SqlDataSource dataSource, string partNum, string schematicNum) { //set up a dataview object for object member data System.Data.DataView anObjectTable = new System.Data.DataView(); //select row based on table name and part number dataSource.SelectCommand = "SELECT tblParts.partNumber,tblParts.partName,tblSchematicParts.SchematicNumber, tblSchematicParts.usdPrice, tblSchematicParts.cadPrice, " + "tblSchematicParts.keyNumber " + "FROM tblParts " + "INNER JOIN tblSchematicParts " + "ON tblParts.partNumber = tblSchematicParts.partNumber " + "WHERE tblParts.partNumber = '" + partNum + "' AND tblSchematicParts.schematicNumber= '" + schematicNum + "'"; //assign the row to the dataview object anObjectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //return the DataView object return(anObjectTable); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(sr400ID,partName,description,partNumber,color,maxLengthFeet,lengthFeetUnits,maxLengthInches,lengthInchesUnits,usdPrice,cadPrice,status)" + "VALUES(" + (count + 1) + ",'" + Sunrail400Name + "','" + Sunrail400Description + "','" + PartNumber + "','" + Sunrail400Color + "'," + Sunrail400MaxLengthFeet + ",'" + Sunrail400MaxLengthFeetUnits + "'," + Sunrail400MaxLengthInches + ",'" + Sunrail400MaxLengthInchesUnits + "'," + Sunrail400UsdPrice + "," + Sunrail400CadPrice + "," + 1 + ")"; if (Sunrail400MaxLengthInches == null) { sqlInsert = "INSERT INTO " + table + "(sr400ID,partName,description,partNumber,color,maxLengthFeet,lengthFeetUnits,maxLengthInches,lengthInchesUnits,usdPrice,cadPrice,status)" + "VALUES(" + (count + 1) + ",'" + Sunrail400Name + "','" + Sunrail400Description + "','" + PartNumber + "','" + Sunrail400Color + "'," + Sunrail400MaxLengthFeet + ",'" + Sunrail400MaxLengthFeetUnits + "',null,null," + Sunrail400UsdPrice + "," + Sunrail400CadPrice + "," + 1 + ")"; } //Null Insert dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public CascadingDropDownNameValue[] GetSubCategories(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); int ParentCategoryID = 0; foreach (string s in kv.Keys) ParentCategoryID = Convert.ToInt32(kv[s]); using (var DS = new System.Web.UI.WebControls.SqlDataSource()) { DS.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString"].ConnectionString; DS.SelectCommand = "select ProductCategoryID, Name from ProductCategory where ParentProductCategoryID = " + ParentCategoryID + " order by Name"; using (var result = (DS.Select(System.Web.UI.DataSourceSelectArguments.Empty) as System.Data.DataView).Table) { foreach (DataRow row in result.Rows) { values.Add(new CascadingDropDownNameValue(row["Name"].ToString(), row["ProductCategoryID"].ToString())); } } } return values.ToArray(); }