public int GetAvailableQty(int stockid) { var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = _constr } }; return Convert.ToInt32(ta.AvailableQty(stockid)); }