Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
Ranked #107.55K
~210 People Reached
Favorite Forums
Favorite Tags
sql x 1

1 Posted Topic

Member Avatar for sumitshah4u

Hi, Check this query var result = from row in dt.AsEnumerable() select new { stk = row.Field<string>("Stock"), Avg = (row.Field<int>("TotPrice")) / (row.Field<int>("Qty")), Qty = row.Field<int>("Qty"), TranType = row.Field<string>("Type") }; result variable will have the data as of your requirement after executing above statement.

Member Avatar for Rehan_4
0
210

The End.