没有参数的存储过程调用
OleDbConnection conn = new OleDbConnection(connStr.ToString());
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "proc_test";
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
conn.Close();
带有参数的存储过程调用
OleDbConnection conn = new OleDbConnection(connStr.ToString());
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "proc_test";
cmd.Parameters.Add("v_name", "刘建新");
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
conn.Close();