Change the anonymous type to list of object in C#
I am using Linq, and have a function shown below to fetch the data from a
database, because when I pull this data into grid view, then I cannot
object of TblSpareParts table to edit the data in grid
private void LoadParts()
{
RST_DBDataContext conn = new RST_DBDataContext();
var AllParts = (from s in conn.TblSpareParts
join m in conn.TblBikeModels on s.ModelID equals
m.ModelID
select new { s.SPartName, s.SPartCode,
s.SPartLocation, s.SPartID,
s.TblBikeModel.ModelName }).ToArray();
SParts_grid.ItemsSource = AllParts;
}
I want this function like this,
private void LoadParts()
{
RST_DBDataContext conn = new RST_DBDataContext();
List<TblSparePart> AllParts = (from s in conn.TblSpareParts
join m in conn.TblBikeModels on s.ModelID
equals m.ModelID
select new { s.SPartName, s.SPartCode,
s.SPartLocation, s.SPartID,
s.TblBikeModel.ModelName }).ToList();
SParts_grid.ItemsSource = AllParts;
}
So basically I want to change this part var AllParts to List<TblSparePart>
AllParts and this .ToArray(); to .ToList();
No comments:
Post a Comment