المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : get SQL Insert Query



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