Windows Forms

neodeaths wrote:

which i drag into my workspace

using Excel = Microsoft.Office.Interop.Excel;


OleDbCommand cmd;
using (OleDbConnection con = new OleDbConnection(string.Format("Data Source={0};"   + "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;", fileName)))
{
    con.Open();
    string sqlToRun = "Create table [test] (Col1 int)";
    string insert = "insert into [test](col1) values (100)";
   
    cmd = new OleDbCommand(sqlToRun, con); // create table (worksheet)
    cmd.ExecuteNonQuery();

    cmd = new OleDbCommand(insert, con); // insert record
    cmd.ExecuteNonQuery();
}

private void Form1_FormClosing(object sender, FormClosingEventArgs e) {
    e.Cancel = true;
}

private void Form1_FormClosing(object sender, FormClosingEventArgs e) {
  if (e.CloseReason == CloseReason.WindowsShutDown) {
    e.Cancel = false;
  } else {
    e.Cancel = true;
  }
}

Vishnu Nath wrote:

I have seen that you can cannot kill anti-virus processes from windows task manager.

Vishnu Nath wrote:

could not be killed by administrator of computer

I are troll

neodeaths wrote:

however i am trying to add values to it as well *e.g hidden values)