public void BindGrid() { DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); Asset_mst objAsset = new Asset_mst(); BLLCollection<Asset_mst> colAsset = new BLLCollection<Asset_mst>(); colAsset = objAsset.Get_All(); foreach (Asset_mst obj in colAsset) { DataRow row; row = dtTable.NewRow(); row["computername"] = Convert.ToString(obj.Computername); assetid = Convert.ToInt16(obj.Assetid); Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst(); objos = objos.Get_By_Assetid(assetid); row["osname"] = Convert.ToString(objos.Os_name); row["username"] = Convert.ToString(objos.User_name); row["productkey"] = Convert.ToString(objos.Product_key); Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst(); objproduct = objproduct.Get_By_Assetid(assetid); row["productname"] = Convert.ToString(objproduct.Product_name); row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer); row["serialno"] = Convert.ToString(objproduct.Serial_number); Asset_Processor_mst objprocessor = new Asset_Processor_mst(); objprocessor = objprocessor.Get_By_Assetid(assetid); row["processorname"] = Convert.ToString(objprocessor.Processor_name); Asset_Memory_mst objmemory = new Asset_Memory_mst(); objmemory = objmemory.Get_By_Assetid(assetid); row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem); dtTable.Rows.Add(row); } dtgrid.DataSource = dtTable; dtgrid.DataBind(); }
//Coded by lalit protected void BindAsset() { colAsset = objAsset.Get_All(); DrpAsset.DataTextField = "computername"; DrpAsset.DataValueField = "assetid"; DrpAsset.DataSource = colAsset; DrpAsset.DataBind(); ListItem item = new ListItem(); item.Text = "All"; item.Value = "0"; DrpAsset.Items.Add(item); DrpAsset.SelectedValue = "0"; }
public void BindGrid() { DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); Asset_mst objAsset = new Asset_mst(); BLLCollection <Asset_mst> colAsset = new BLLCollection <Asset_mst>(); colAsset = objAsset.Get_All(); foreach (Asset_mst obj in colAsset) { DataRow row; row = dtTable.NewRow(); row["computername"] = Convert.ToString(obj.Computername); assetid = Convert.ToInt32(obj.Assetid); Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst(); objos = objos.Get_By_Assetid(assetid); row["osname"] = Convert.ToString(objos.Os_name); row["username"] = Convert.ToString(objos.User_name); row["productkey"] = Convert.ToString(objos.Product_key); Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst(); objproduct = objproduct.Get_By_Assetid(assetid); row["productname"] = Convert.ToString(objproduct.Product_name); row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer); row["serialno"] = Convert.ToString(objproduct.Serial_number); Asset_Processor_mst objprocessor = new Asset_Processor_mst(); objprocessor = objprocessor.Get_By_Assetid(assetid); row["processorname"] = Convert.ToString(objprocessor.Processor_name); Asset_Memory_mst objmemory = new Asset_Memory_mst(); objmemory = objmemory.Get_By_Assetid(assetid); row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem); dtTable.Rows.Add(row); } dtgrid.DataSource = dtTable; dtgrid.DataBind(); }