CREATE PROCEDURE UpdateData(@id? int,@personid? int,@pricelevel? nvarchar(50),@strachtype? nvarchar(50),@packuptype? nvarchar(50),@myphone1? nvarchar(50),@name? nvarchar(50),@gender? nvarchar(50),@address? nvarchar(50),@city? nvarchar(50),@state? nvarchar(50),@zip? nvarchar(50),@email? nvarchar(50),@birthday? nvarchar(50),@remark? nvarchar(50))ASUPDATE t_base_customer_info SET pricelevel = @pricelevel ,strachtype? = @strachtype? ,packuptype? = @packuptype WHERE id = @id;UPDATE?? t_base_person_info SET myphone1 = @myphone1,name = @name,gender = @gender,address = @address,city = @city,state = @state,zip = @zip,email = @email,birthday = @birthday,remark = @remark WHERE id = @personid;??
寫了一個WinForm程序,但是現在有個問題,我用存儲過程往數據庫里提交數據,在提交完成之后,我就刷新了一下DataGridView,修改后的數據也顯示在了DataGridView中,但是吧,數據庫中的數據并沒有修改,并且在關閉掉了窗口后,再打開窗口,數據還是沒有修改,這是個什么原因?我寫的存儲過程有問題么?我在存儲過程下面加了這句
?raiserror(N'done is over ',16,1)
報了錯誤,但是我并沒有找到錯誤,求大神指教
求大神看看我寫的存儲過程有問題么?
婷婷同學_
2018-12-07 12:57:24