This can be used to calculate the value of a column on the client side.
Then the return for your select command will not have any Count column, but your DataTable has.
Use the link below to get info for how to fill this column with values.
DataColumn.Expression Property[
^]
DataTable.Compute Method[
^]
You can also do this in SQL
select Vendor_Gatepass, Customer_Name, count(Product) as Count from A_Table;
Add more columns to the select statement as you wish.
For creating a view, you can have a look here.
SQL CREATE VIEW Statement[
^]