private void LoadComboBoxInfo() { DataTable dtParent, dtIpAddress; using (var conn = new SQLiteConnection(Common.ConnectionString)) { dtParent = conn.GetDataTable("SELECT FId,FName FROM RemoteHost WHERE FParentId=0"); dtIpAddress = conn.GetDataTable("SELECT FId,FFullUrl FROM ConnectLib"); } //父级下拉框显示 cbParent.DisplayMember = "FName"; cbParent.ValueMember = "FId"; cbParent.DataSource = dtParent; //IP地址下拉框显示 cbIpAddress.DisplayMember = "FFullUrl"; cbIpAddress.ValueMember = "FId"; cbIpAddress.DataSource = dtIpAddress; }
/// <summary> /// 加载地址库信息 /// </summary> private void LoadIpInfo() { using (var conn = new SQLiteConnection(Common.ConnectionString)) { grid.DataSource = conn.GetDataTable("SELECT FId,FFullUrl IP信息 FROM ConnectLib"); } grid.Columns["FId"].Visible = false; grid.Columns["IP信息"].Width = grid.Width; }