public Ledgers.COMMISIONDETAILDataTable GetCommissionDetail(string commid = null,bool isRemote=false) { var dt = new Ledgers().COMMISIONDETAIL; string _sysnstr = Utils.ConnectionstringSync; if (isRemote) { if (Utils.Company != "01") { _sysnstr = new SqlAsyncConnectionString(6, true); } } var ta = new LedgersTableAdapters.COMMISIONDETAILTableAdapter { Connection = { ConnectionString = isRemote ? _sysnstr : _constr } }; if (commid == null) { ta.Fill(dt); } else { ta.FillByCOMID(dt, commid); } return dt; }