How to Stop Auto Generate columns in Flexgrid
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, 开发者_StackOverflow中文版 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
Use the delete column button:
http://helpcentral.componentone.com/nethelp/c1flexgrid/default.htm?turl=c1flexgridcolumneditor.htm
精彩评论