Hello All,I am using Visual Studio 2008 and I am getting the following error message : Ambiguous column name 'Currency'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Ambiguous column name 'Currency'.Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. <asp:SqlDataSource ID="Currency" runat="server" ConnectionString="<%$ ConnectionStrings:FABConnectionString %>" SelectCommand="SELECT [Currency], [Currency] + ' ' + [Currency_Name] AS Currency FROM [Currency Master]ORDER BY [Currency]"> </asp:SqlDataSource> <asp:SqlDataSource ID="Exchange" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:FABConnectionString %>" DeleteCommand="DELETE FROM [Exchange Rate] WHERE [Exchange Group] = @original_Exchange_Group AND [Currency Master.Currency] = @original_Currency AND [RateDate] = @original_RateDate AND [Exchange Rate] = @original_Exchange_Rate" InsertCommand="INSERT INTO [Exchange Rate] ([Exchange Group], [Currency], [RateDate], [Exchange Rate]) VALUES (@Exchange_Group, @Currency, @RateDate, @Exchange_Rate)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Exchange Rate] ORDER BY [Currency]" UpdateCommand="UPDATE [Exchange Rate] SET [RateDate] = @RateDate, [Exchange Rate] = @Exchange_Rate WHERE [Exchange Group] = @original_Exchange_Group AND [Currency] = @original_Currency AND [RateDate] = @original_RateDate AND [Exchange Rate] = @original_Exchange_Rate"> <DeleteParameters>I have tried using brackets. column and no luck any ideas out there?
Ambiguous column detected
Posted - 2010-12-13 : 14:53:16
