Update query Error

msomar · May 3rd, 2010, 06:15 AM

I have this SqlDataSource:

Code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>" 
            SelectCommand="SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] , AdCampaign.Status FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)" 
            UpdateCommand="UPDATE AdCampaign SET DailyBudget = 30 FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)">
            <SelectParameters>
                <asp:SessionParameter Name="EmailAddress" SessionField="EmailAddress" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="EmailAddress"   />
            </UpdateParameters>
            </asp:SqlDataSource>

But when I click Button Update this error occurred:

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.

om_prakash · May 3rd, 2010, 07:22 AM

Try using following update command

UpdateCommand="UPDATE AdCampaign SET DailyBudget = 30 FROM AdCampaign INNER JOIN AccountON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)">