Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Providers.mdb" DeleteCommand = "DELETE * From [tbl_Providers] WHERE [ID] = ?" UpdateCommand="UPDATE [tbl_Providers] SET [Provider_Type] = ?, [Last_Name] = ?, [First_Name] = ?, [Prof_Designation] = ?, [Group_Business_Name] = ?, [Specialty] = ?, [Specialty2] = ?, [Address] = ?, [Address2] = ?, [City] = ?, [State] = ?, [Zip] = ?, [Phone] = ?, [Fax] = ? WHERE [ID] = ? " SelectCommand="SELECT [Id],[First_Name],[Last_Name],[Prof_Designation], [Specialty], [Specialty2],[Address], [Address2], [City], [State], [Zip], [Phone], [Fax],[Provider_Type],[Group_Business_Name] FROM [tbl_Providers] Where (@IdParam IS NULL OR [ID]=@IdParam ) OR (@SpecialtyParam IS NULL OR [Specialty]=@SpecialtyParam ) " CancelSelectOnNullParameter="False"> <SelectParameters> <asp:ControlParameter ControlID="NameDropDown" Name="IdParam" PropertyName="SelectedValue" ConvertEmptyStringToNull="true" /> <asp:ControlParameter ControlID="specialityDropDown" Name="SpecialtyParam" PropertyName="SelectedValue" ConvertEmptyStringToNull="true" /> </SelectParameters>
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!