一個有關Update類型的預存程序的問題

來源:互聯網
上載者:User
CREATE PROCEDURE testupdateproc   AS
declare @id int
declare @trandate datetime
declare @tranlimit int
update test set trandate=@trandate, tranlimit=@tranlimit where test.id=@id
GO
預存程序語句如上,檢查文法是沒有問題的,但是在程式中執行時卻不行。程式如下:
            Class1 c= new Class1();
            System.Data.SqlClient.SqlParameter[] para = new System.Data.SqlClient.SqlParameter[3];
            para[0] = new System.Data.SqlClient.SqlParameter("@id",this.textBox3.Text);
             if (this.textBox1.Text != "")
                para[1] = new System.Data.SqlClient.SqlParameter("@trandate", this.textBox1.Text);
            else
                para[1] = new System.Data.SqlClient.SqlParameter("@trandate", DBNull.Value);
            if (this.textBox2.Text != "")
                para[2] = new System.Data.SqlClient.SqlParameter("@tranlimit", this.textBox2.Text);
            else
                para[2] = new System.Data.SqlClient.SqlParameter("@tranlimit", DBNull.Value);
            //c.DataInsert();
            if (c.DataUpdate())
                MessageBox.Show("OK");
            else
                MessageBox.Show("False");
DataUpdae方法如下:
         public bool DataUpdate()
        {
            string strConn = "Server=.;Initial Catalog=test;User Id=sa;Password=123";
            SqlConnection sqlcon = new SqlConnection(strConn);
            sqlcon.Open();
            SqlCommand sqlcom = new SqlCommand();
            sqlcom.Connection = sqlcon;
            sqlcom.CommandType = CommandType.StoredProcedure;
            sqlcom.CommandText = "testupdateproc";
            int i = sqlcom.ExecuteNonQuery();
            sqlcon.Close();
            bool flag = false;
            if (i > 0)
                flag = true;
            else
                flag = false;
            return flag;
        }
程式執行返回的是false ,資料庫中資料也沒有改變,大家看看是怎麼回事?

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.