C / C++ / MFC

TedChangKorea wrote:

I've clarified my question; I am trying to write a C++ dll using Excel C API.

public partial class Form1 : Form
    {
        String[,] contactRecords = new String[50, 3]; //2-D array to hold our contact info.
        String[,] serverRecords = new String[50, 4]; //2-D array to hold our server info.

        public Form1()
        {
            InitializeComponent();
        }

        public void importSettings(object sender, EventArgs e)
        {


            /// Import contact settings
            StreamReader sr = new StreamReader("contact.data");
            String line = sr.ReadLine();
            String[] lineSplit = line.Split(',');
            for (int i=0;line != null; i++)
            {
                lineSplit = line.Split(',');
                contactRecords[i, 0] = lineSplit[0]; //First Name
                contactRecords[i, 1] = lineSplit[1]; //Title
                contactRecords[i, 2] = lineSplit[2]; //Phone #

                line = sr.ReadLine();
            }

            for (int x = 0; contactRecords[x, 0] != null; x++)
            {
                CLB_Contact.Items.Add(contactRecords[x, 0]);
            }
            sr.Close();



            /// Import server settings
            StreamReader sr2 = new StreamReader("servers.data");
            String line2 = sr2.ReadLine();
            String[] lineSplit2 = line2.Split(',');
            for (int j=0; line2 != null; j++)
            {
                lineSplit2 = line2.Split(',');
                serverRecords[j, 0] = lineSplit2[0]; //Host Name
                serverRecords[j, 1] = lineSplit2[1]; //IP Address
                serverRecords[j, 2] = lineSplit2[2]; //Resouces Accessed
                serverRecords[j, 3] = lineSplit2[3]; //Contacts

                line2 = sr2.ReadLine();
            }
   
            for (int x = 0; serverRecords[x, 0] != null; x++)
            {
                Servers_LV.Items.Add(serverRecords[x, 0]);
            }
            sr.Close();

   
        }

        public void helloWorld(object sender, MouseEventArgs e)
        {
            ListView.SelectedListViewItemCollection list = Servers_LV.SelectedItems;
            foreach (String x in serverRecords)
            {
                if (x == list[0].Text)
                {
                    TB_IPAddress.Text = x;
                    Array.IndexOf(serverRecords, x);
                }
            }
        }
    }

private void helloWorld_SelectedIndexChanged(object sender, EventArgs e)
{
    ListView.SelectedListViewItemCollection list = Servers_LV.SelectedItems;
    int firstIndex = 0, secondIndexer = 0;
    if (list.Count <= 0) // Check the selected object value has items before Iteration
        return;
    foreach (String x in serverRecords)
    {
        if (x == list[0].Text)
        {
            TB_IPAddress.Text = serverRecords[secondIndexer, 1];
            // serverRecords[secondIndexer, 2] -> ResourceAccessed
            // serverRecords[secondIndexer, 3] -> Contact
            return;
        }
        firstIndex++;
        if (firstIndex % 4 == 0) // Skip properties associated with server
            secondIndexer++;

    }
}