/// <summary>绑定ListBox /// /// </summary> private void BindListBoxDetail() { if (cboTableDetail.Text.Trim() == string.Empty) { return; } m_databaseTableDetail = m_dbSchema.DatabaseSchema.Tables.FirstOrDefault(t => t.Name == cboTableDetail.Text); if (m_databaseTableDetail != null) { List <DatabaseColumn> databaseColumn = m_databaseTableDetail.Columns; CheckedListBoxHelper.BindCheckedListBox(lstCheckInputFiledsDetail, databaseColumn, "Name", "Name"); CheckedListBoxHelper.BindCheckedListBox(lstEditShowFiledsDetail, databaseColumn, "Name", "Name"); CheckedListBoxHelper.BindCheckedListBox(lstShowFiledsDetail, databaseColumn, "Name", "Name"); CheckedListBoxHelper.BindCheckedListBox(lstDontRepeatFiledsDetail, databaseColumn, "Name", "Name"); } }
/// <summary>加载数据 /// /// </summary> public void LoadData() { Clear(); CreateMasterDetailView(); DataTable dtColumns = new DataTable(); dtColumns.Columns.Add("Name"); dtColumns.Columns.Add("DataType"); for (int i = 0; i < m_dataSet.Tables[0].Columns.Count; i++) { DataRow dr = dtColumns.NewRow(); dr["Name"] = m_dataSet.Tables[0].Columns[i].ToString(); dr["DataType"] = m_dataSet.Tables[0].Columns[i].DataType.Name; dtColumns.Rows.Add(dr); } CheckedListBoxHelper.BindCheckedListBox(lstQueryFileds, dtColumns, "Name", "Name"); }