I have a sqldatasource (code listed below) whose insert Paramaters are control parameters. My aspx page has a textbox and a submit button. the button onclick runs the sqdatasource1.insert.
What I get is every other insert inserts the text in textbox2 and every other insert enters nothing for the namecust value. I have a required field validator which correctly prevents submission if textbox2 is empty.
How do I fix this?
:<code>
<asp:PanelID="Panel1"runat="server"Height="50px"Width="548px">
<asp:ButtonID="Button1"runat="server"Text="New Prospect"ValidationGroup="insertCust"/>
<asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="TextBox2"
ErrorMessage="Prospect Name can not be blank"ValidationGroup="insertCust"></asp:RequiredFieldValidator>
<asp:TextBoxID="TextBox2"runat="server"Width="330px"ValidationGroup="insertCust"></asp:TextBox></asp:Panel>
<asp:SqlDataSourceID="SqlDataSource2"runat="server"ConnectionString="<%$ ConnectionStrings:AccPac2ConnectionString %>"
SelectCommand="SELECT DISTINCT CODETERR FROM dbo.F_arcus() AS F_arcus_1 WHERE (DATEINAC = 0) AND (rtrim(CODETERR) <>'')">
</asp:SqlDataSource>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:AccPac2ConnectionString %>"
InsertCommand="INSERT INTO dbo.BudgetProspects(NameCust, CodeTerr) VALUES (@.Namecust, @.codeterr)"
SelectCommand="SELECT CustomerID, NameCust FROM dbo.BudgetProspects WHERE (CodeTerr = @.codeterr)"
UpdateCommand="UPDATE dbo.BudgetProspects SET NameCust = @.namecust">
<UpdateParameters>
<asp:ParameterName="namecust"/>
</UpdateParameters>
<SelectParameters>
<asp:ControlParameterControlID="RadioButtonList1"Name="codeterr"PropertyName="SelectedValue"/>
</SelectParameters>
<InsertParameters>
<asp:ControlParameterControlID="textbox2"Name="Namecust"PropertyName="text"/>
<asp:ControlParameterControlID="RadioButtonList1"Name="codeterr"PropertyName="SelectedValue"/>
</InsertParameters>
</asp:SqlDataSource>
</code>
codebehind button_click:
<code>
ProtectedSub Button1_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles Button1.Click
IfNot TextBox2.TextIsNothingThen
SqlDataSource1.Insert()
TextBox2.Text =""
EndIf
EndSub
</code>
Never mind, complete stupidity on my part the altenate row style had white background and white text.![Embarrassed [:$]](http://pics.10026.com/?src=/emoticons/emotion-10.gif)
No comments:
Post a Comment