1 2 3 4 5 6 7 8 9 10 11
|
<asp:SqlDataSource ID="SqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:TBEXConnectionString %>"
SelectCommand="SELECT * FROM [Contact]"
FilterExpression="[DUTY] like '{0}%' and [DEPT] like '{1}%'"
UpdateCommand="UPDATE [Contact] SET [FIRSTNAME] = @FIRSTNAME, [LASTNAME] = @LASTNAME, [JOBTITLE] = @JOBTITLE, [BUSINESSPHONE] = @BUSINESSPHONE, [MOBILEPHONE] = @MOBILEPHONE, [DEPT] = @DEPT, [DUTY] = @DUTY WHERE [ID] = @ID"
InsertCommand="INSERT INTO [Contact] ([ID], [FIRSTNAME], [LASTNAME], [JOBTITLE], [BUSINESSPHONE], [MOBILEPHONE], [DEPT], [DUTY]) VALUES (@ID, @FIRSTNAME, @LASTNAME, @JOBTITLE, @BUSINESSPHONE, @MOBILEPHONE, @DEPT, @DUTY)">
<FilterParameters>
<asp:ControlParameter Name="Duty" ControlID="ddlDuty" PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter Name="Dept" ControlID="ddlDept" PropertyName="SelectedValue" Type="String" />
</FilterParameters> |
Partager