int actualcost = Convert.ToInt32(dt_sms.Rows[0]["Cost"].ToString()); int bargaincost = actualcost - 200; string sql_cust= string.Format("SELECT CustomerMaster.CustomerName, CustomerMaster.Phoneno, CustomerMaster.EmailId, CostMaster.Cost, RequestMaster.SetCost FROM CostMaster INNER JOIN ProductMaster ON CostMaster.ProductId = ProductMaster.ProductId INNER JOIN RequestMaster ON CostMaster.CostId = RequestMaster.CostId INNER JOIN CustomerMaster ON RequestMaster.CustomerId = CustomerMaster.CustomerId where CostMaster.AgentId='{0}' and ProductMaster.ProductId='{1}' and RequestMaster.SetCost Between actualcost and bargaincost")
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)