存储过程 (回忆)

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["连接字符串"].ConnectionString);
        SqlCommand cmd = new SqlCommand("存储过程名称", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@参数1", 值1);
        cmd.Parameters.AddWithValue("@参数2", 值2);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();

posted @ 2011-09-26 15:05  lieneces  阅读(111)  评论(0编辑  收藏  举报