public int GetAvailableQty(string itemno,string newcon="P",bool usenewcon=false) { var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = usenewcon ?newcon: _constr } }; return Convert.ToInt32(ta.GetAvailableQty(itemno)); }