Server Error in '/' Application.

The column 'Discount' was specified multiple times for 'table1'.
The column 'Discount' was specified multiple times for 'table2'.

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: The column 'Discount' was specified multiple times for 'table1'.
The column 'Discount' was specified multiple times for 'table2'.

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.

Stack Trace:


[SqlException (0x80131904): The column 'Discount' was specified multiple times for 'table1'.
The column 'Discount' was specified multiple times for 'table2'.]
   Connectdata.GetDataTable(String Commandtext) +213
   Connectdata.GetPageDataTableWithRowCount(Int32 rowcount, Int32 pageIndex, Int32 pageSize, String fields, String tableName, String conditions, String groupby, String orderField, Boolean isDesc) +3635
   home_product.LoadDataProductag(String Tags, String pi) +500
   home_product.Page_Load(Object sender, EventArgs e) +850
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1040