C# Programming
05-07-2009, 12:14 PM
Dear All,
I am inserting data into Access Database using Update Queries same as store procedures in MSSQL 2005, i am passing params like following
OleDbCommand cmd=new OleDbCommand("queryName",p.con);
cmd.CommandType= CommandType.StoredProcedure;
cmd.Parameters.Add("@p1", OleDbType.SmallInt).Value = secId;
cmd.Parameters.Add("@p2", OleDbType.SmallInt).Value = comDivId;
cmd.Parameters.Add("@p3", OleDbType.VarChar).Value = prob;
if (p.con.State!=ConnectionState.Open)
p.con.Open();
cmd.ExecuteNonQuery();
this works fine.
now i would like to get the *****alent insert statement of this query
after the statement cmd.ExecuteNonQuery()
how should i get the insert statement *****alent to this update query (store procedures)
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
I am inserting data into Access Database using Update Queries same as store procedures in MSSQL 2005, i am passing params like following
OleDbCommand cmd=new OleDbCommand("queryName",p.con);
cmd.CommandType= CommandType.StoredProcedure;
cmd.Parameters.Add("@p1", OleDbType.SmallInt).Value = secId;
cmd.Parameters.Add("@p2", OleDbType.SmallInt).Value = comDivId;
cmd.Parameters.Add("@p3", OleDbType.VarChar).Value = prob;
if (p.con.State!=ConnectionState.Open)
p.con.Open();
cmd.ExecuteNonQuery();
this works fine.
now i would like to get the *****alent insert statement of this query
after the statement cmd.ExecuteNonQuery()
how should i get the insert statement *****alent to this update query (store procedures)
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan