Update Error

msomar · May 6th, 2010, 10:02 AM

When I click button Update this error is cccurred :

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

my SqlDataSource is:

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>

the parameter :

Code:

<asp:Parameter Name="EmailAddress"   />

is a session parameter.

I am waiting please guide me.

gbianchi · May 6th, 2010, 10:53 AM

You are in the wrong forum.. you problem is with asp.net, not SQL..

Anyway, I don't see anywhere a problem. Could be in other place? Does that query alone work by itself???