public int GetAvailableSQty(int itemid) { var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = _constr } }; return ta.GetAvailableSQty(itemid) ?? 0; }