public DataRow GetClient(int id_) { try { SqlConnection _conn = (SqlConnection)_dataModule.GetSharedConnection(); SqlDataAdapter _da = new SqlDataAdapter("Select * from tb_Clients Where ID = " + id_.ToString(), _conn); DataSet _ds = new DataSet(); _dataModule.OpenSharedConnection(); _da.Fill(_ds); if (_ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0) { return(_ds.Tables[0].Rows[0]); } else { return(null); } } catch (Exception ex) { throw; } finally { _dataModule.CloseSharedConnection(); } }