.A_ID and .A_ID have conflicting properties: DataType property mismatch.

See more:

ASP.NET

hai sir,

my code is

protected void Page_Load(object sender, EventArgs e)
       {
           ReportDocument rptDoc = new ReportDocument();
           DataSet2 ds = new DataSet2(); // .xsd file name
           DataTable dt = new DataTable();

           // Just set the name of data table
           dt.TableName = "Crystal Report Example";
           dt = getAllOrders(); //This function is located below this function
           ds.Tables[0].Merge(dt);

           // Your .rpt file path will be below
           rptDoc.Load(Server.MapPath("../Trial/CrystalReports3.rpt"));

           //set dataset to the report viewer.
           rptDoc.SetDataSource(ds);
           CrystalReportViewer1.ReportSource = rptDoc;
       }
       public DataTable getAllOrders()
       {
           //Connection string replace 'databaseservername' with your db server name

           SqlCommand cmd = new SqlCommand();
           DataSet ds = null;
           SqlDataAdapter adapter;
           try
           {
               conn1.Open();
               //Stored procedure calling. It is already in sample db.
               cmd.CommandText = "getAllOrders";
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.Connection = conn1;
               ds = new DataSet();
               adapter = new SqlDataAdapter(cmd);
               adapter.Fill(ds, "Users");
           }
           catch (Exception ex)
           {
               throw new Exception(ex.Message);
           }
           finally
           {
               cmd.Dispose();
               if (conn1.State != ConnectionState.Closed)
                   conn1.Close();
           }
           return ds.Tables[0];
       }

when i execute this code ,i get the error
<target>.A_ID and .A_ID have conflicting properties: DataType property mismatch.

in ds.Tables[0].Merge(dt); this line.

give a solution ,plz help