Posted on: 10/25/2012 12:14:03 AM | Views : 237

Hello,
I have  an SQLDatasource, with FormParameters to update my DB.  One textbox is returning null, and after a couple of days of googling and angst, I still can't figure out why.  My code follows.  I've highlighted the offending items in bold.  Note that the other textboxes in the same Formview, at the same level in the page hierarchy are working fine.
Thanks much.
<asp:SqlSource ID="sqlDS" runat="server" ConnectionString="<%$ ConnectionStrings:prospectsConnectionString %>" SelectCommand="SELECT endUsers.ProjectID, endUsers.numEndUsers, endUsers.endUserGrowth, endUsers.numChangeRequestsPerMonth, endUsers.Agreements, endUsers.softwareAgreements, endUsers.clickThruSignup, proStatus.proStatus, proStatus.ID AS proStatID, Recipients.Recipient, Recipients.ID AS RecipID FROM Project INNER JOIN endUsers ON Project.ID = endUsers.ProjectID INNER JOIN Recipients ON Project.ID = @projectID AN ...

Go to the complete details ...