public string GetExpiryDt(string itemno) { var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = _constr } }; return ta.GetExpiryDt(itemno, Utils.Company).ToString(); }