Write to SQL db

When I run this code, I get no error. But the data does show up in SQL...any thoughts?

Code:

---


                private void bSubmit_Click(object sender, System.EventArgs e)
                {
                        string sconn;
                        string insertCommand;
                        string to = tWhoTo.Text; //Request.Form("fDriveBy").(tWhoTo);
                       
                        sconn = "Provider=SQLOLEDB;Data Source=DOGFISH;InitialCatalog=DrvBy;Integrated Security=SSPI;";
                        insertCommand = "Insert into SYS_DRVBY(WhoFrom, WhoTo, dt, Comments) values('" + to + "','" + to + "','" + "11/01/2001" + "','" + "this is a test" + "')";
                        OleDbConnection conn = new OleDbConnection(sconn);
                        conn.Open();
                        OleDbCommand cmd = new OleDbCommand();
 
                        cmd = new OleDbCommand(insertCommand,conn);
                       
               
                }

---

you aren't executing the query. Try the code below

VB Code:

private void bSubmit_Click(object sender, System.EventArgs e)
{
   string sconn;
   string insertCommand;
   string to = tWhoTo.Text; //Request.Form("fDriveBy").(tWhoTo);
            
   sconn = "Provider=SQLOLEDB;Data Source=DOGFISH;InitialCatalog=DrvBy;Integrated Security=SSPI;";
   insertCommand = "Insert into SYS_DRVBY(WhoFrom, WhoTo, dt, Comments) values('" + to + "','" + to + "','" + "11/01/2001" + "','" + "this is a test" + "')";
   OleDbConnection conn = new OleDbConnection(sconn); 
   OleDbCommand cmd = new OleDbCommand(insertCommand,conn);
 
    conn.Open();
    cmd.ExecuteNonQuery(); 
    conn.Close();       
}

I get this error:

No overload for method 'ExecuteNonQuery' takes '2' arguments

I changed it.

OK, getting closer. This is wierd. I get the following error:

System.Data.OleDb.OleDbException: Invalid object Name 'SYSDRVBY'.

SYSDRVBY is the name of my table. I don't get it (I took out the underscore)....

OK, getting closer. This is wierd. I get the following error:

System.Data.OleDb.OleDbException: Invalid object Name 'SYSDRVBY'.

SYSDRVBY is the name of my table. I don't get it (I took out the underscore)....

OK I got it....Thanks!

Code:

---

                        string sconn;
                        string insertCommand;
                        string to = tWhoTo.Text;
                        string from = tWhoBy.Text;
                        string dt = tDate.Text;
                        string comments = tRequestMemo.Text;
                       
                       
                       
                        sconn = "Initial Catalog=DrvBy;Data Source=DOGFISH;Integrated Security=SSPI;";
                        insertCommand = "Insert into SYSDRVBY (WhoFrom, WhoTo, dt, Comments) values('" + from + "','" + to + "','" + dt + "','" + comments + "')";
                        SqlConnection sqlconn = new SqlConnection(sconn);
                        //OleDbConnection conn = new OleDbConnection(sconn);
                        SqlCommand sqlComm = new SqlCommand(insertCommand,sqlconn);
                        //OleDbCommand cmd = new OleDbCommand(insertCommand,conn);

                        sqlconn.Open();
                        sqlComm.ExecuteNonQuery();
                        sqlconn.Close();

---