August 29, 2008 10:10pm pdt

1. TheLearn... 115,130
2. jaime_oliv... 104,158
3. Dhaest 102,945
4. apeter 99,850
5. jpaulino 70,179
6. emoreau 61,118
7. angelIII 52,750
8. Fernando... 48,454
9. jcoehoorn 48,325
10. naspinski 34,000
11. elimesika 33,645
12. mlmcc 32,230
13. graye 31,830
14. GreenGho... 28,795
15. PockyMas... 28,698
16. TimCottee 28,359
17. Idle_Mind 24,515
18. gregoryyo... 23,000
19. VBRocks 22,360
20. p_davis 22,240
21. dweppen... 22,050
22. kaylanreilor 21,150
23. PaulHews 21,040
24. ZachSmith 21,010
25. chapmandew 20,175

1. TheLearn... 303,165
2. Dhaest 154,958
3. jaime_oliv... 144,445
4. jpaulino 111,409
5. Fernando... 107,981
6. angelIII 104,055
7. emoreau 101,037
8. apeter 99,850
9. Idle_Mind 92,605
10. gregoryyo... 91,132
11. VBRocks 72,430
12. Sancler 68,120
13. mlmcc 58,395
14. jaiganesh... 57,145
15. jcoehoorn 56,700
16. graye 54,480
17. p_davis 44,460
18. surajguptha 44,050
19. vbturbo 41,797
20. igor_alpha 39,180
21. naspinski 34,000
22. TimCottee 33,959
23. elimesika 33,645
24. GreenGho... 33,295
25. PaulHews 33,000

07.24.2008 at 07:18AM PDT, ID: 23592153

	[x] Attachment Details

Handles clause requires a withevents variable defined within the container type or one of its base types

Asked by mconti41 in .Net Editors & IDEs, Visual Studio 2008, .NET Framework 3.x versions

I am trying to accomplish a simple SQL Insert to DB2 db table based on a button click event. I am including code for an experts review. I am desperate to resolve.Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

           
           
             Aspx:
<asp:SqlDataSource ID="SqlDataSourceDependent" runat="server" 
              ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
              ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                      InsertCommand="INSERT INTO ENROLL.ENR02(E2GRP, E2SSN, E2DSSN, E2NAML, E2NAMF, E2NAMM, E2DOB, E2EFF, E2TRM, E2SEXC, E2RELC, E2QEVN, E2OTHI, E2FTS, E2FTSE, E2FTST) VALUES (,,,,,,,,,,,,,,,)">
               <InsertParameters>
                   <asp:QueryStringParameter Name="newparameter" QueryStringField="grpId" />
                   <asp:QueryStringParameter Name="newparameter" QueryStringField="memId" />
               </InsertParameters>
               
        </asp:SqlDataSource>  
        
         <table align="left"bgcolor="ffff99" width="75%">
               <tr bgcolor="ffff99">
				 <td colspan="4" align="center"><asp:Button ID="ButtonAddDepend" 
                         onclick="Dependent_Inserted" runat="server" Text="Add Dependent" 
                        Height="25px" Width="102px" 
                        /></td>
                        
			    </tr>
		</table>
 
Code Behind:
Protected Sub Dependent_Inserted(ByVal sender As Object, ByVal e As System.EventArgs) Handles Dependent.Inserted
 
        SqlDataSourceDependent.Insert()
 
    End Sub

           
         

Keywords: Handles clause requires a withevents …

	Title
1	DB2 table documentation
2	db2 export table data to spreadsheet
3	WithEvents
4	What are differences between oracle …
5	Discovering unused tables within a DB…
6	update a table in db1 from a table in db2

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Handles clause requires a withevents variable defined within the container type or one of its base types

Asked by mconti41 in .Net Editors & IDEs, Visual Studio 2008, .NET Framework 3.x versions

About this solution