谁能帮我看下那里错了呢??GridVie用存储过程更新数据库
0
悬赏园豆：10
[已关闭问题]
关闭于 2008-07-31 17:13
<DIV class=cnblogs_code><!--<br><br>Code highlighting produced by Actipro CodeHighlighter (freeware)<br>http://www.CodeHighlighter.com/<br><br>-->
<DIV class=cnblogs_code><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #0000ff">protected</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #0000ff">void</SPAN><SPAN style="COLOR: #000000"> GridView1_RowUpdating(</SPAN><SPAN style="COLOR: #0000ff">object</SPAN><SPAN style="COLOR: #000000"> sender, GridViewUpdateEventArgs e)<BR><IMG id=Codehighlighter1_87_413_Open_Image onclick="this.style.display='none'; document.getElementById('Codehighlighter1_87_413_Open_Text').style.display='none'; document.getElementById('Codehighlighter1_87_413_Closed_Image').style.display='inline'; document.getElementById('Codehighlighter1_87_413_Closed_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align=top><IMG id=Codehighlighter1_87_413_Closed_Image style="DISPLAY: none" onclick="this.style.display='none'; document.getElementById('Codehighlighter1_87_413_Closed_Text').style.display='none'; document.getElementById('Codehighlighter1_87_413_Open_Image').style.display='inline'; document.getElementById('Codehighlighter1_87_413_Open_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif" align=top> </SPAN><SPAN id=Codehighlighter1_87_413_Open_Text><SPAN style="COLOR: #000000">{<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">int</SPAN><SPAN style="COLOR: #000000"> sub_id </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[</SPAN><SPAN style="COLOR: #800080">0</SPAN><SPAN style="COLOR: #000000">].Text.Trim());<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">string</SPAN><SPAN style="COLOR: #000000"> sub_name </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> ((TextBox)GridView1.Rows[e.RowIndex].Cells[</SPAN><SPAN style="COLOR: #800080">1</SPAN><SPAN style="COLOR: #000000">].FindControl(</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #800000">TextBox</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #000000">)).Text.ToString().Trim();<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">int</SPAN><SPAN style="COLOR: #000000"> result </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> sub_op.subject_update(sub_id,sub_name);<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> GridView1.EditIndex </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #000000">-</SPAN><SPAN style="COLOR: #800080">1</SPAN><SPAN style="COLOR: #000000">;<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">this</SPAN><SPAN style="COLOR: #000000">.wwdbind();<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif" align=top> }</SPAN></SPAN></DIV>
<DIV class=cnblogs_code><SPAN><SPAN style="COLOR: #000000">存储过程为:</SPAN></SPAN></DIV>
<DIV class=cnblogs_code><SPAN><SPAN style="COLOR: #000000">
<DIV class=cnblogs_code><!--<br><br>Code highlighting produced by Actipro CodeHighlighter (freeware)<br>http://www.CodeHighlighter.com/<br><br>--><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #0000ff">public</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #0000ff">int</SPAN><SPAN style="COLOR: #000000"> subject_update(</SPAN><SPAN style="COLOR: #0000ff">int</SPAN><SPAN style="COLOR: #000000"> subid,</SPAN><SPAN style="COLOR: #0000ff">string</SPAN><SPAN style="COLOR: #000000"> subname)<BR><IMG id=Codehighlighter1_61_616_Open_Image onclick="this.style.display='none'; document.getElementById('Codehighlighter1_61_616_Open_Text').style.display='none'; document.getElementById('Codehighlighter1_61_616_Closed_Image').style.display='inline'; document.getElementById('Codehighlighter1_61_616_Closed_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align=top><IMG id=Codehighlighter1_61_616_Closed_Image style="DISPLAY: none" onclick="this.style.display='none'; document.getElementById('Codehighlighter1_61_616_Closed_Text').style.display='none'; document.getElementById('Codehighlighter1_61_616_Open_Image').style.display='inline'; document.getElementById('Codehighlighter1_61_616_Open_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif" align=top> </SPAN><SPAN id=Codehighlighter1_61_616_Closed_Text style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff"><IMG src="http://space.cnblogs.com/images/dot.gif"></SPAN><SPAN id=Codehighlighter1_61_616_Open_Text><SPAN style="COLOR: #000000">{<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">int</SPAN><SPAN style="COLOR: #000000"> result </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #800080">0</SPAN><SPAN style="COLOR: #000000">;<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> wwd_dbproc wwdp </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #0000ff">new</SPAN><SPAN style="COLOR: #000000"> wwd_dbproc();<BR><IMG id=Codehighlighter1_173_331_Open_Image onclick="this.style.display='none'; document.getElementById('Codehighlighter1_173_331_Open_Text').style.display='none'; document.getElementById('Codehighlighter1_173_331_Closed_Image').style.display='inline'; document.getElementById('Codehighlighter1_173_331_Closed_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align=top><IMG id=Codehighlighter1_173_331_Closed_Image style="DISPLAY: none" onclick="this.style.display='none'; document.getElementById('Codehighlighter1_173_331_Closed_Text').style.display='none'; document.getElementById('Codehighlighter1_173_331_Open_Image').style.display='inline'; document.getElementById('Codehighlighter1_173_331_Open_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align=top> SqlParameter[] param </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN id=Codehighlighter1_173_331_Closed_Text style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff"><IMG src="http://space.cnblogs.com/images/dot.gif"></SPAN><SPAN id=Codehighlighter1_173_331_Open_Text><SPAN style="COLOR: #000000">{ wwdp.CreateInParam(</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #800000">@sub_id</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #000000">,SqlDbType.SmallInt,</SPAN><SPAN style="COLOR: #800080">4</SPAN><SPAN style="COLOR: #000000">,subid),<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align=top> wwdp.CreateInParam(</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #800000">@sub_name</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #000000">,SqlDbType.NVarChar,</SPAN><SPAN style="COLOR: #800080">20</SPAN><SPAN style="COLOR: #000000">,subname)}</SPAN></SPAN><SPAN style="COLOR: #000000">;<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">try</SPAN><SPAN style="COLOR: #000000"><BR><IMG id=Codehighlighter1_361_446_Open_Image onclick="this.style.display='none'; document.getElementById('Codehighlighter1_361_446_Open_Text').style.display='none'; document.getElementById('Codehighlighter1_361_446_Closed_Image').style.display='inline'; document.getElementById('Codehighlighter1_361_446_Closed_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align=top><IMG id=Codehighlighter1_361_446_Closed_Image style="DISPLAY: none" onclick="this.style.display='none'; document.getElementById('Codehighlighter1_361_446_Closed_Text').style.display='none'; document.getElementById('Codehighlighter1_361_446_Open_Image').style.display='inline'; document.getElementById('Codehighlighter1_361_446_Open_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align=top> </SPAN><SPAN id=Codehighlighter1_361_446_Open_Text><SPAN style="COLOR: #000000">{<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> result </SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000"> wwdp.wwdproc(</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #800000">wwdsp_subject_Update</SPAN><SPAN style="COLOR: #800000">"</SPAN><SPAN style="COLOR: #000000">, param);<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align=top> }</SPAN></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">catch</SPAN><SPAN style="COLOR: #000000">(Exception wwdex)<BR><IMG id=Codehighlighter1_494_579_Open_Image onclick="this.style.display='none'; document.getElementById('Codehighlighter1_494_579_Open_Text').style.display='none'; document.getElementById('Codehighlighter1_494_579_Closed_Image').style.display='inline'; document.getElementById('Codehighlighter1_494_579_Closed_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align=top><IMG id=Codehighlighter1_494_579_Closed_Image style="DISPLAY: none" onclick="this.style.display='none'; document.getElementById('Codehighlighter1_494_579_Closed_Text').style.display='none'; document.getElementById('Codehighlighter1_494_579_Open_Image').style.display='inline'; document.getElementById('Codehighlighter1_494_579_Open_Text').style.display='inline';" src="http://space.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align=top> </SPAN><SPAN id=Codehighlighter1_494_579_Open_Text><SPAN style="COLOR: #000000">{<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">throw</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #0000ff">new</SPAN><SPAN style="COLOR: #000000"> Exception(wwdex.Message.ToString(), wwdex);<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align=top> }</SPAN></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top> </SPAN><SPAN style="COLOR: #0000ff">return</SPAN><SPAN style="COLOR: #000000"> result;<BR><IMG src="http://space.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif" align=top> }</SPAN></SPAN></DIV></SPAN></SPAN></DIV><!--<br><br>Code highlighting produced by Actipro CodeHighlighter (freeware)<br>http://www.CodeHighlighter.com/<br><br>--></DIV>
所有回答(1)
0
提示什么？试试在updating最后加一行：
e.Cancel = true;