I think that will help you.
Write the function for RowCount:
private int RowCount
{
get { return Convert.ToInt32(ViewState["RowCount"]); }
set { ViewState["RowCount"] = value; }
}
Retrieve this:
using (MYDataClassesDataContext dc = new MYDataClassesDataContext())
{
var rec = dc.CustomerDomainTbls.FirstOrDefault();
if (rec == null)
{
Response.Write("");
}
else
{
try
{
var query = from po in pc.CustomerDomainTbls
join co in pc.CustomerOrderTbls
on po.OrderID equals co.OrderID
select new
{co.OrderDate,
co.CustomerTbl.CustomerName,
co.EmployeeTbl.Name,
co.ServiceTypeTbl.ServiceName,
co.QuotedAmount, co.ExpectedCompletionDate,
Count = dc.po.Count()};
gridorders.DataSource = query;
gridorders.DataBind();
}
catch (Exception rr)
{
}
}
}