Advertisement

12.19.2007 at 09:17PM PST, ID: 23035205
[x]
Attachment Details

update or delete links on formview no longer work

Asked by bd9000 in Programming for ASP.NET, .NET, Microsoft Visual Basic.Net

Tags: delete, formview, link, update

I have yet another problem with the FormView - it no longer Updates or Deletes records.
This was working just fine and I have no clue as where to begin to look for problems as no errors are displayed.
The update and delete SQL queries have been checked and re-checked - perfect!
The validators work fine too, so I know that it is not cliet-side script that is the culprit.
I can't find anything wrong with any of the code - it worked, now it does not though only template changes were made.  I rebuilt the SQLdatasource completely with no luck, so it must be in the ASPX file. The SQL statements I checked manually - they return exactly what they are supposed to.


 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:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:

The code behind:
 
    Partial Class affiliatecommpymt
        Inherits System.Web.UI.Page
 
        Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
            Me.SqlDSaffcommpymt.ConnectionString = DB.GetDBConn
            Me.SqlDScommsummdetails.ConnectionString = DB.GetDBConn
        End Sub
 
        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            'Response.CacheControl = "private"
            'Response.Expires = 0
            'Response.AddHeader("pragma", "no-cache")  
 
            If Not Page.IsPostBack Then
                ViewState.Add("AffiliateID", CommonLogic.QueryString("AffiliateID"))
                ViewState.Add("TotalCommOwed", CommonLogic.QueryString("TotalCommOwed"))
            End If
        End Sub
 
        Protected Sub fvAffCommPymts_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles fvAffCommPymts.DataBound
            If fvAffCommPymts.PageCount = 0 Then
                fvAffCommPymts.ChangeMode(FormViewMode.Insert)
            End If
        End Sub
 
        Protected Sub fvAffCommPymts_ItemCreated(ByVal sender As Object, ByVal e As System.EventArgs) Handles fvAffCommPymts.ItemCreated
            If fvAffCommPymts.CurrentMode = FormViewMode.Insert Then
                Dim tbAffiliateID As TextBox = DirectCast(Me.fvAffCommPymts.Row.FindControl("AffiliateIDTextBox"), TextBox)
                If tbAffiliateID IsNot Nothing Then
                    tbAffiliateID.Text = ViewState("AffiliateID").ToString
                End If
                Dim tbpymttype As TextBox = DirectCast(Me.fvAffCommPymts.Row.FindControl("pymttypeTextBox"), TextBox)
                If tbpymttype IsNot Nothing Then
                    tbpymttype.Text = "check"
                End If
                Dim tbpymtdate As TextBox = DirectCast(Me.fvAffCommPymts.Row.FindControl("pymtdateTextBox"), TextBox)
                If tbpymtdate IsNot Nothing Then
                    tbpymtdate.Text = FormatDateTime(Now, DateFormat.ShortDate)
                End If
                'TotalCommOwed
                Dim tbtotalcommowed As TextBox = DirectCast(Me.fvAffCommPymts.Row.FindControl("PymtAmtTextBox"), TextBox)
                If tbtotalcommowed IsNot Nothing Then
                    tbtotalcommowed.Text = ViewState("TotalCommOwed").ToString
                End If
            End If
        End Sub
 
 
    End Class
 
 
 
 
************************************
The ASPX Source:
 
<asp:FormView ID="fvAffCommPymts" runat="server" DataKeyNames="AffiliateID" DataSourceID="SqlDSaffcommpymt" AllowPaging="True" CellPadding="4" ForeColor="#333333" HorizontalAlign="Left" BorderStyle="Solid" BorderWidth="1px">
                                                <EditItemTemplate>
                                                    <table border="0" cellpadding="4" cellspacing="0" style="width: 400px; height: 104px">
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: #ffffcc; text-align: left">
                                                                Pymt ID:</td>
                                                            <td style="width: 1px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: #ffffcc; text-align: left">
                                                    <asp:Label ID="CommPymtIDLabel1" runat="server" Text='<%# Eval("CommPymtID") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: white; text-align: left">
                                                                Affiliate ID:</td>
                                                            <td style="width: 1px; height: 15px; background-color: white; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: white; text-align: left">
                                                    <asp:TextBox ID="AffiliateIDTextBox" runat="server" Text='<%# Bind("AffiliateID") %>' CausesValidation="True"></asp:TextBox>
                                                                <asp:RequiredFieldValidator ID="validAffiliateID" runat="server" ControlToValidate="AffiliateIDTextBox" ErrorMessage="Affiliate ID is required.">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator ID="regexvalidAffiliateID" runat="server"
                                                                        ControlToValidate="AffiliateIDTextBox" ErrorMessage="Enter a valid ID." ValidationExpression="[0-9]*">*</asp:RegularExpressionValidator></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: #ffffcc; text-align: left">
                                                                Pymt #:</td>
                                                            <td style="width: 1px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: #ffffcc; text-align: left">
                                                    <asp:TextBox ID="PymtNumTextBox" runat="server" Text='<%# Bind("PymtNum") %>' CausesValidation="True"></asp:TextBox>
                                                                <asp:RequiredFieldValidator ID="validPymtNum" runat="server" ControlToValidate="PymtNumTextBox" ErrorMessage="Payment Number is required.">*</asp:RequiredFieldValidator></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: white; text-align: left">
                                                                Type:</td>
                                                            <td style="width: 1px; height: 15px; background-color: white; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: white; text-align: left">
                                                    <asp:TextBox ID="PymtTypeTextBox" runat="server" Text='<%# Bind("PymtType") %>' CausesValidation="True"></asp:TextBox>
                                                                <asp:RequiredFieldValidator ID="validPymtType" runat="server" ControlToValidate="PymtTypeTextBox" ErrorMessage="Payment Type is required.">*</asp:RequiredFieldValidator></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: #ffffcc; text-align: left">
                                                                Amount:</td>
                                                            <td style="width: 1px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: #ffffcc; text-align: left">
                                                    <asp:TextBox ID="PymtAmtTextBox" runat="server" Text='<%# Bind("PymtAmt","{0:###.##}") %>' CausesValidation="True"></asp:TextBox>
                                                                <asp:RequiredFieldValidator ID="validPymtAmount" runat="server" ControlToValidate="PymtAmtTextBox" ErrorMessage="Payment Amount is required.">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator ID="RegularExpressionValidator1"
                                                                        runat="server" ControlToValidate="PymtAmtTextBox" ErrorMessage="Enter a valid amount." ValidationExpression="[-+]?[0-9]*\.?[0-9]+">*</asp:RegularExpressionValidator></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: white; text-align: left">
                                                                Date:</td>
                                                            <td style="width: 1px; height: 15px; background-color: white; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: white; text-align: left">
                                                    <asp:TextBox ID="PymtDateTextBox" runat="server" Text='<%# Bind("PymtDate","{0:d}") %>' CausesValidation="True"></asp:TextBox>
                                                                <asp:RequiredFieldValidator ID="validPymtDate" runat="server" ControlToValidate="PymtDateTextBox" ErrorMessage="Payment Date is required.">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator ID="regexvalidPymtDate" runat="server"
                                                                        ControlToValidate="PymtDateTextBox" ErrorMessage="Enter a valid Date" ValidationExpression="^((0?[13578]|10|12)(-|\/)(([1-9])|(0[1-9])|([12])([0-9]?)|(3[01]?))(-|\/)((19)([2-9])(\d{1})|(20)([01])(\d{1})|([8901])(\d{1}))|(0?[2469]|11)(-|\/)(([1-9])|(0[1-9])|([12])([0-9]?)|(3[0]?))(-|\/)((19)([2-9])(\d{1})|(20)([01])(\d{1})|([8901])(\d{1})))$">*</asp:RegularExpressionValidator></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: #ffffcc; text-align: left">
                                                                Approved:</td>
                                                            <td style="width: 1px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: #ffffcc; text-align: left">
                                                    <asp:CheckBox ID="PymtApprovedCheckBox" runat="server" Checked='<%# Bind("PymtApproved") %>' /></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: white; text-align: left">
                                                                Issued:</td>
                                                            <td style="width: 1px; height: 15px; background-color: white; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: white; text-align: left">
                                                    <asp:CheckBox ID="PymtIssuedCheckBox" runat="server" Checked='<%# Bind("PymtIssued") %>' /></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 85px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                            <td style="width: 1px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                            <td style="width: 190px; height: 15px; background-color: #ffffcc; text-align: left">
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="3" style="height: 15px; background-color: white; text-align: left">
                                                    <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update">
                                                    </asp:LinkButton>&nbsp;
                                                    <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel">
                                                    </asp:LinkButton></td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="3" style="height: 15px; background-color: white; text-align: left">
                                                                <asp:ValidationSummary ID="ValidationSummary1" runat="server" Width="100%" />
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </EditItemTemplate>
                                                <InsertItemTemplate><table border="0" cellpadding="4" cellspacing="0" style="width: 400px; height: 104px">
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                            Affiliate ID:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:TextBox ID="AffiliateIDTextBox" runat="server" Text='<%# Bind("AffiliateID") %>' CausesValidation="True"></asp:TextBox>
                                                            <asp:RequiredFieldValidator ID="validAffiliateID" runat="server" ControlToValidate="AffiliateIDTextBox" ErrorMessage="Affiliate ID is required.">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator
                                                                ID="regexvalidAffiliateID" runat="server" ControlToValidate="AffiliateIDTextBox" ErrorMessage="Enter a valid ID." ValidationExpression="[0-9]*">*</asp:RegularExpressionValidator></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                            Pymt #:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:TextBox ID="PymtNumTextBox" runat="server" Text='<%# Bind("PymtNum") %>' CausesValidation="True"></asp:TextBox>
                                                            <asp:RequiredFieldValidator ID="validPymtNum" runat="server" ControlToValidate="PymtNumTextBox" ErrorMessage="Payment Number is required.">*</asp:RequiredFieldValidator></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                            Type:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:TextBox ID="PymtTypeTextBox" runat="server" Text='<%# Bind("PymtType") %>' CausesValidation="True"></asp:TextBox>
                                                            <asp:RequiredFieldValidator ID="validPymtType" runat="server" ControlToValidate="PymtTypeTextBox" ErrorMessage="Payment Type is required.">*</asp:RequiredFieldValidator></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                            Amount:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:TextBox ID="PymtAmtTextBox" runat="server" Text='<%# Bind("PymtAmt","{0:###.##}") %>' CausesValidation="True"></asp:TextBox>
                                                            <asp:RequiredFieldValidator ID="validPymtAmount" runat="server" ControlToValidate="PymtAmtTextBox" ErrorMessage="Payment Amount is required.">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator
                                                                ID="RegularExpressionValidator1" runat="server" ControlToValidate="PymtAmtTextBox" ErrorMessage="Enter a valid amount."
                                                                ValidationExpression="[-+]?[0-9]*\.?[0-9]+">*</asp:RegularExpressionValidator></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                            Date:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:TextBox ID="PymtDateTextBox" runat="server" Text='<%# Bind("PymtDate","{0:d}") %>' CausesValidation="True"></asp:TextBox>
                                                            <asp:RequiredFieldValidator ID="validPymtDate" runat="server" ControlToValidate="PymtDateTextBox" ErrorMessage="Payment Date is required.">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator
                                                                ID="regexvalidPymtDate" runat="server" ControlToValidate="PymtDateTextBox" ErrorMessage="Enter a valid Date" ValidationExpression="^((0?[13578]|10|12)(-|\/)(([1-9])|(0[1-9])|([12])([0-9]?)|(3[01]?))(-|\/)((19)([2-9])(\d{1})|(20)([01])(\d{1})|([8901])(\d{1}))|(0?[2469]|11)(-|\/)(([1-9])|(0[1-9])|([12])([0-9]?)|(3[0]?))(-|\/)((19)([2-9])(\d{1})|(20)([01])(\d{1})|([8901])(\d{1})))$">*</asp:RegularExpressionValidator></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                            Approved:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:CheckBox ID="PymtApprovedCheckBox" runat="server" Checked='<%# Bind("PymtApproved") %>' /></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                            Issued:</td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:CheckBox ID="PymtIssuedCheckBox" runat="server" Checked='<%# Bind("PymtIssued") %>' /></td>
                                                    </tr>
                                                    <tr>
                                                        <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                        </td>
                                                        <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                        </td>
                                                        <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="3" style="height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert">
                                                    </asp:LinkButton>&nbsp;
                                                    <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel">
                                                    </asp:LinkButton></td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="3" style="height: 15px; background-color: #ffffff; text-align: left">
                                                            <asp:ValidationSummary ID="ValidationSummary1" runat="server" Width="100%" />
                                                        </td>
                                                    </tr>
                                                </table>
                                                </InsertItemTemplate>
                                                <ItemTemplate>
                                                    <table border="0" cellpadding="4" cellspacing="0" style="width: 400px; height: 104px">
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                                Pymt ID:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:Label ID="CommPymtIDLabel" runat="server" Text='<%# Eval("CommPymtID") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                                Affiliate ID:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:Label ID="AffiliateIDLabel" runat="server" Text='<%# Bind("AffiliateID") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                                Pymt #:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:Label ID="PymtNumLabel" runat="server" Text='<%# Bind("PymtNum") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                                Type:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:Label ID="PymtTypeLabel" runat="server" Text='<%# Bind("PymtType") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                                Amount:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:Label ID="PymtAmtLabel" runat="server" Text='<%# Bind("PymtAmt","{0:c}") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                                Date:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:Label ID="PymtDateLabel" runat="server" Text='<%# Bind("PymtDate","{0:d}") %>'></asp:Label></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                                Approved:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffcc">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffcc; text-align: left;">
                                                    <asp:CheckBox ID="PymtApprovedCheckBox" runat="server" Checked='<%# Bind("PymtApproved") %>' Enabled="false" /></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                                Issued:</td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:CheckBox ID="PymtIssuedCheckBox" runat="server" Checked='<%# Bind("PymtIssued") %>' Enabled="false" /></td>
                                                        </tr>
                                                        <tr>
                                                            <td style="WIDTH: 85px; height: 15px; background-color: #ffffff; text-align: left;">
                                                            </td>
                                                            <td style="WIDTH: 1px; height: 15px; background-color: #ffffff">
                                                            </td>
                                                            <td style="WIDTH: 190px; height: 15px; background-color: #ffffff">
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="3" style="height: 15px; background-color: #ffffff; text-align: left;">
                                                    <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit">
                                                    </asp:LinkButton>&nbsp;
                                                    <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" >
                                                    </asp:LinkButton>&nbsp;
                                                    <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New">
                                                    </asp:LinkButton></td>
                                                        </tr>
                                                    </table>
                                                </ItemTemplate>
                                                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                                                <PagerStyle BackColor="#5D7B9D" ForeColor="White" HorizontalAlign="Center" Wrap="False" />
                                                <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                                <EditRowStyle BackColor="#999999" />
                                            <PagerSettings FirstPageText="&amp;lt;&amp;lt;First Page" LastPageText="Last Page&amp;gt;&amp;gt;" Mode="NextPreviousFirstLast" />
                                            </asp:FormView>
 
 
 
 
 
 
        <asp:SqlDataSource ID="SqlDSaffcommpymt" runat="server" DeleteCommand="DELETE FROM [AffiliateCommPymt] WHERE [CommPymtID] = @CommPymtID"
            InsertCommand="INSERT INTO [AffiliateCommPymt] ([AffiliateID], [PymtNum], [PymtType], [PymtAmt], [PymtDate], [PymtIssued], [PymtApproved]) VALUES (@AffiliateID, @PymtNum, @PymtType, @PymtAmt, @PymtDate, @PymtIssued, @PymtApproved)"
            ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [AffiliateCommPymt] WHERE ([AffiliateID] = @AffiliateID)"
            UpdateCommand="UPDATE [AffiliateCommPymt] SET [AffiliateID] = @AffiliateID, [PymtNum] = @PymtNum, [PymtType] = @PymtType, [PymtAmt] = @PymtAmt, [PymtDate] = @PymtDate, [PymtIssued] = @PymtIssued, [PymtApproved] = @PymtApproved WHERE [CommPymtID] = @CommPymtID">
            <SelectParameters>
                <asp:QueryStringParameter Name="AffiliateID" QueryStringField="AffiliateID" Type="Int32" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="CommPymtID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="AffiliateID" Type="Int32" />
                <asp:Parameter Name="PymtNum" Type="String" />
                <asp:Parameter Name="PymtType" Type="String" />
                <asp:Parameter Name="PymtAmt" Type="Decimal" />
                <asp:Parameter Name="PymtDate" Type="DateTime" />
                <asp:Parameter Name="PymtIssued" Type="Boolean" />
                <asp:Parameter Name="PymtApproved" Type="Boolean" />
                <asp:Parameter Name="CommPymtID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="AffiliateID" Type="Int32" />
                <asp:Parameter Name="PymtNum" Type="String" />
                <asp:Parameter Name="PymtType" Type="String" />
                <asp:Parameter Name="PymtAmt" Type="Decimal" />
                <asp:Parameter Name="PymtDate" Type="DateTime" />
                <asp:Parameter Name="PymtIssued" Type="Boolean" />
                <asp:Parameter Name="PymtApproved" Type="Boolean" />
            </InsertParameters>
        </asp:SqlDataSource>
[+][-]12.19.2007 at 09:30PM PST, ID: 20505004

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.20.2007 at 08:29AM PST, ID: 20507869

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.20.2007 at 08:44AM PST, ID: 20508018

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.20.2007 at 09:18AM PST, ID: 20508297

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Programming for ASP.NET, .NET, Microsoft Visual Basic.Net
Tags: delete, formview, link, update
Sign Up Now!
Solution Provided By: bd9000
Participating Experts: 2
Solution Grade: B
 
 
[+][-]12.20.2007 at 02:17PM PST, ID: 20510365

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.26.2007 at 05:02PM PST, ID: 20531811

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628