|
Size: 1905
Comment:
|
Size: 274
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 8: | Line 8: |
| == Bible Beliefs Database Project == 1. Add the connection to the Data Connections in Server Explorer 1. Add a data set item to the project. This is a nice gui place to create the data set. Drag and drop the tables on the page and you will build yourself a nice database diagram similar to what you would do in Visio. 1. Next I added a DataGridView Object, bound it to the TopicTextViewOrdered and changed the column type to DataGridViewLinkColumn. 1. Note the contextMenuStrip should be where we click to add a new belief possibly 1. Turned TrackVisitedState to false. 1. A BindingSource component is added at the bottom. Change the Sort Property to: TopicText ASC 1. Double Clicked on DGV object to create a CellContentClick event handler. To start with I'll just do a MessageBox as shown in Section 1 of the code below 1. Added another tableAdaptor for beliefs, as well as a BindingSource and BindingNavigator 1. Have the TableAdaptor Fill the bibleDB DataSet |
|
| Line 19: | Line 9: |
| {{{ //Section 1: Accessing the selected value if (Utilities.IsANonHeaderLinkCell(()sender, e)) { int topicKey = (int)dgvTopics.Rows[e.RowIndex].Cells[0].Value; this.beliefsBindingSource.Filter = "TopicKey = " + topicKey; } |
* scot/BibleBeliefsProject |
| Line 27: | Line 11: |
| //Section 2: Utility Function used in Section 1 public static bool IsANonHeaderLinkCell(DataGridView dgv, DataGridViewCellEventArgs cellEvent) { if (dgv.Columns[cellEvent.ColumnIndex] is DataGridViewLinkColumn && cellEvent.RowIndex != -1) { return true; } else { return false; } } //Section 3: Added to MainForm_Load to sort grid this.dgvTopics.Sort(dgvTopics.Columns[1], ListSortDirection.Ascending); }}} |
Dr. A
More info about Dr. "A" and his Wife Dr. Anderson can be found at http://www.scotnpatti.com.
Current Projects
- scot/BibleBeliefsProject