Database

SELECT <br />
	SNO,<br />
	Id,<br />
(<br />
	SELECT <br />
		(COUNT(*) + 1) <br />
	FROM <br />
		table1 b <br />
	WHERE <br />
		b.SNO < a.SNO AND <br />
		a.Id = b.Id)<br />
FROM <br />
	table1 a<br />

<br />
SELECT <br />
	SNO,<br />
	Id,<br />
(<br />
	SELECT <br />
		COUNT(*)<br />
	FROM <br />
		table1 b <br />
	WHERE <br />
		b.SNO <= a.SNO AND <br />
		a.Id = b.Id)<br />
FROM <br />
	table1 a<br />

<br />
private bool uploadData(string myPath, string txtUpload)<br />
		{<br />
			bool bNoError = true;<br />
			string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" +<br />
				"Data Source=" +myPath +txtUpload +";";<br />
<br />
			OleDbConnection con = new OleDbConnection(strConnection);<br />
			con.Open();<br />
			<br />
			<br />
			try<br />
			{<br />
				DataSet dsEWEtmp = new DataSet();<br />
				<br />
				OleDbDataAdapter daEWEForm = new OleDbDataAdapter("SELECT * FROM Some_Form", con);<br />
<br />
				<br />
				int updates = daEWEForm.Fill(dsEWEtmp, "Some_Form");<br />
				foreach (DataRow dataRow in dsEWEtmp.Tables)<br />
				{<br />
					dsEWEtmp.Tables[0].ImportRow(dataRow);<br />
					dsEWEtmp.Tables[0].AcceptChanges();<br />
				}<br />
<br />
				updates = daEWEForm.Update(dsEWEtmp);<br />
//				return dsEWEtmp;<br />
<br />
				DataTable tblEWEForm;<br />
				tblEWEForm = dsEWEtmp.Tables[0];<br />
			<br />
				OleDbCommandBuilder objCommandBuilder = new OleDbCommandBuilder(daEWEForm);<br />
				daEWEForm.Update(dsEWEtmp, "Some_Form");<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 />
				{<br />
					con.Close();<br />
				}<br />
			}<br />
			return bNoError;

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