How to Stop Auto Generate columns in Flexgrid

Question

Am using component flexgrid tool in my application for binding bulk of datas from my sql server using Linq, but grid showing all columns from my entity list than i initialized for my flexgrid. I want only three coloumns from it itemname, PartNo, Itemcode, * Thease coloums only initialized first* But showing All Coloums that i don't want ever

  List NewList = new List();
  Itlist = objItemMgmt.GetItms(Convert.ToString(gvPurchaseEntry1.Cols[d].Index.ToString()));//d is ["ItemCode"]
 gvPurcahseItems1.DataSource = Itlist;
 gvPurcahseItems1.Focus();

Here is my Entity data list

  public List GetItms(string itemName)
        {
            var reslt = (from itm in context.ItemMasters
                         join mm in context.MultiMasters
                          on itm.ItemId equals mm.ItemId
                          join gt in context.GoodsDetails 
                          on itm.GoodsId equals gt.GoodsId 
                         join mu in context.Multiunits
                          on mm.MultiunitId equals mu.MultiunitId
                         join u in context.UnitDetails
                          on mu.UnitId equals u.UnitId
                         join s in context.StockDetails
                          on itm.ItemId equals s.ItemId
                         where (itemName == null || itm.ItemName.Contains(itemName)) ||
                               (itemName == null || itm.PartNo.Contains(itemName)) ||
                               (itemName == null || itm.ItemCode.Contains(itemName)) ||
                               //(itemName == null || itm.ArabicDescription.Contains(itemName)) ||
                               (itemName == null || (itm.GoodsDetail.GoodsType + " " + itm.GoodsDetail.GroupCatagory).Contains(itemName)
                               && (itm.StatusId != 3))
                               && (itm.StatusId != 3)
                        //where ((itemName == null) || itm.ItemName.Contains(itemName)
                        //|| itm.ItemCode.Contains(itemName) || itm.OEMNo.Contains(itemName)
                        //|| (itm.GoodsDetail.GoodsType + " " + itm.GoodsDetail.GroupCatagory).Contains(itemName) || itm.PartNo.Contains(itemName))
                        //&& itm.StatusId != 3
                         select new Entity.ItemMasterProp
                         {
                             Id = (int)itm.ItemId,
                             PartNo=(string)itm.PartNo,
                             ItemCode = (string)itm.ItemCode,
                             ItemName = (string)itm.ItemName,
                             Stock = (double)s.AvailableStock,
                             WPrice = (decimal)mm.WPrice,
                             RPrice = (decimal)mm.RetPrice,
                             value = (decimal)mm.Value,
                             UnitId = (int)u.UnitId,
                             UnitName = (string)u.UnitName,
                             UnitCode = (string)u.UnitCode,
                             MultiUnitId = (int)mu.MultiunitId,
                             MultiUnitName = (string)mu.MultiName,
                             MultiUnitCode = (string)mu.MultiCode,
                             GoodTyp=(string)gt.GoodsType + " " + (string)gt.GroupCatagory,
                             GoodId = (int)gt.GoodsId
                             //GoodCatogory = (string)gt.GroupCatagory

                         }).Distinct().ToList();

            var reslt1 =   (from itm in context.ItemMasters
                            join u1 in context.UnitDetails
                            on itm.UnitId equals u1.UnitId
                            join gt in context.GoodsDetails
                            on itm.GoodsId equals gt.GoodsId 
                            join s in context.StockDetails
                            on itm.ItemId equals s.ItemId
                            where (itemName == null || itm.ItemName.Contains(itemName)) ||
                             (itemName == null || itm.PartNo.Contains(itemName)) ||
                            (itemName == null) || itm.ItemCode.Contains(itemName)
                            || (itemName == null || (itm.GoodsDetail.GoodsType + " " + itm.GoodsDetail.GroupCatagory).Contains(itemName) 
                            && (itm.StatusId != 3))
                             select new Entity.ItemMasterProp
                            {
                              Id = (int)itm.ItemId,
                              PartNo = (string)itm.PartNo,
                              ItemCode = (string)itm.ItemCode,
                              ItemName = (string)itm.ItemName,
                              Stock = (double)s.AvailableStock,
                              UnitId = (int)u1.UnitId,
                              UnitName = (string)u1.UnitName,
                              WPrice = (decimal)itm.WPrice,
                              RPrice = (decimal)itm.RPrice,
                              MultiUnitName = (string)u1.UnitName,
                              value = (decimal)1,
                              GoodTyp = (string)gt.GoodsType + " " + (string)gt.GroupCatagory,
                              GoodId=(int)gt.GoodsId,
                               //GoodCatogory = (string)gt.GroupCatagory
                            }).Distinct().ToList();
           reslt = reslt.Concat(reslt1).Distinct().ToList();
            return reslt;
        }

I want only three coloumns from it itemname, PartNo, Itemcode, * Thease coloums only initialized first* But showing All Coloums that i don't want ever

Thanks in Advance

Answer 1

Use the delete column button:

http://helpcentral.componentone.com/nethelp/c1flexgrid/default.htm?turl=c1flexgridcolumneditor.htm