存储过程在ASP.NET中的应用

Code
   protected void Button2_Click(object sender, EventArgs e)
    {
        System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
        conn.ConnectionString = this.ConnStr;
        SqlCommand cmd = new SqlCommand();
        conn.Open();
        cmd.Connection = conn;
   
        cmd.CommandText = "AddBlogClass";
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter Para1 = new SqlParameter("@ClassName",SqlDbType.NVarChar);
        Para1.Value = TextBoxName.Text;


        SqlParameter Para2 = new SqlParameter("@ClassPic", SqlDbType.NVarChar);
        if (String.IsNullOrEmpty(TextBoxPic.Text))
            Para2.Value = DBNull.Value;
        else
            Para2.Value = TextBoxPic.Text;
        SqlParameter Para3 = new SqlParameter("@ClassSort", SqlDbType.Int);
        if (String.IsNullOrEmpty(TextBoxSort.Text))
            Para3.Value = DBNull.Value;
        else
            Para3.Value = Convert.ToInt32(TextBoxSort.Text);
        cmd.Parameters.Add(Para1);
        cmd.Parameters.Add(Para2);
        cmd.Parameters.Add(Para3);
        int result = cmd.ExecuteNonQuery();
        switch (result)
        {
            case 2:
                Label1.Text = "添加成功。";
                GridView1.DataBind();
                break;
            case 1:
                Label1.Text = "添加出错，只有部分数据保存。";
                break;
            case 0:
                Label1.Text = "添加出错，没有数据被保存。";
                break;
            default:
                break;
        }

    }