C#

Microsoft.Office.Excel._Application app = null;
try
{
  app = new Microsoft.Office.Excel._Application();
}
catch
{
// COM object cannot be created
}

Jacob Dixon wrote:

For some reason when I save my database it tries to convert the Home Phone, Cell Phone, and Fax into System.Int32. I have them set on System.String.

Jacob Dixon wrote:

Like I said in the database the textbox is set to System.String

Jacob Dixon wrote:

if you use return; that will exit the foreach loop won't it?

Jacob Dixon wrote:

Where the return; would be then it would go down here to the next If statement

Jacob Dixon wrote:

Yes! Thanks! As long as it skips the Else statement that is right after the IF statement!

if (some expression is true)
{
    // Do this
}
else // the above expression was false
{
    // Do this instead
}

Jacob Dixon wrote:

As long as it skips the Else statement that is right after the IF statement!

if (DBNull.Value == r.Cells[3].Value);
else richTextBox1.Text += string.Format("{0}\n", r.Cells[3].Value.ToString());

if (DBNull.Value != r.Cells[3].Value)
    richTextBox1.Text += string.Format("{0}\n", r.Cells[3].Value.ToString());

Jacob Dixon wrote:

the problem with this is if Cells[12] was actually DBNull, then for some reason it would skip the richTextBox1.Text += "\n\n";

Jacob Dixon wrote:

When I enter like: 123-4567 it doesn't because of the dash.

Thaer Hamael wrote:

DataSource name not found