存储过程调用

string connameName = ((LinkButton)sender).CommandName; SqlConnection conn = DB.createConn(); conn.Open(); SqlCommand cmd = new SqlCommand("pr_UpdateNewsKindOrder",conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterTabID = new SqlParameter("@newsKindID",SqlDbType.Int,4); parameterTabID.Value = Int32.Parse(this.lbNewsKind.SelectedValue); cmd.Parameters.Add(parameterTabID); SqlParameter parameterMove = new SqlParameter("@moveFlag",SqlDbType.VarChar,20); parameterMove.Value = connameName; cmd.Parameters.Add(parameterMove); cmd.ExecuteNonQuery(); conn.Close();