Write to SQL db

[brianh]

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

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

[Memnoch1207]

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

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();       
}

[brianh]

I get this error:

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

[Memnoch1207]

I changed it.

[brianh]

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

[brianh]

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

[brianh]

OK I got it....Thanks!

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