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();
 }
Exemple #2
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();
    }