Dr. A

More info about Dr. "A" and his Wife Dr. Anderson can be found at http://www.scotnpatti.com.

Current Projects

Bible Beliefs Database Project

1. Add the connection to the Data Connections in Server Explorer
2. 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.

3. 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

   2. Turned TrackVisitedState to false.

   3. A BindingSource component is added at the bottom. Change the Sort Property to: TopicText ASC

4. 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

5. Added another tableAdaptor for beliefs, as well as a BindingSource and BindingNavigator

   1. Have the TableAdaptor Fill the bibleDB DataSet

//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;
 }

//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);

• scot/PasswordList

CategoryHomepage