Database

ConnMaster.Open(masterconnstring);
ConUpload.Open(uploadConnString);
string sql = "insert into master_table (f1,f2,f3) values (?,?,?)"
OledbCommand cmmd = new OleDbCommand(ConnMaster,sql);
using (Datareader dr = ConnUpload.Executereader("select f1,f2,f3from upload table");)
{
  while (dr.Read())
  {
    try{
    cmd.parameters.clear();
    cmd.parameters.add(new oledbparameter("p1",dr[0].getvalue());
    cmd.parameters.add("p2",dr[1].getvalue());
    cmd.parameters.add("p3",dr[2].getvalue());
    cmd.execute();
    }
    catch(oledbexception e)
    {
      logdata("insert failed" + e.tostring());
     }
  }
}

L wrote:

can I put insert into (*)" and leave off values?

<br />
                        <small>OleDbConnection con = new OleDbConnection(strConnection);<br />
			<br />
			OleDbConnection con2 = new OleDbConnection(strConnection2);<br />
			<br />
			con.Open();<br />
			con2.Open();<br />
			string strSQL = "INSERT INTO First_Table([OID]) values (@OID)";<br />
			string strSQL2 = "Select [OID] From First_Table";<br />
                        OleDbCommand cmd2 = new OleDbCommand(strSQL2,con2);<br />
			<br />
			OleDbCommand cmd = new OleDbCommand(strSQL,con);<br />
			<br />
			OleDbDataReader dr = cmd.ExecuteReader();<br />
			<br />
		<br />
			while (dr.Read())<br />
			{<br />
				try<br />
				{<br />
					<br />
				cmd.Parameters.Add (new OleDbParameter("OID",dr[0].ToString()));<br />
cmd.ExecuteReader();<br />
				}					<br />
				catch (Exception err)<br />
				{				<br />
					string str=err.Message;<br />
					bNoError=false;<br />
					<br />
				}					<br />
				finally<br />
				{<br />
					if (con.State.ToString() == "Open")<br />
						con.Close();<br />
					if (con2.State.ToString() == "Open")<br />
						con2.Close();<br />
				}</small><br />

CREATE TABLE IF NOT EXISTS YourTableName
    (create_definition,...)
    [table_option] ...