An exception was caught during the execution of a retrieval query: The multi-part identifier \"LLLL.COLOR_CODE\" could not be bound.\r\nThe multi-part identifier \"SSSS.ITEM_CODE\" could not be bound.. Check InnerException, QueryExecuted and Paramete

ResultsetFields dtFields = new ResultsetFields(2);

            dtFields.DefineField(LotFields.ColorCode, 0, "Color Code","LLLL");

            dtFields.DefineField(StockFields.ItemCode, 1,"KK","SSSS");

            IRelationPredicateBucket filterBucket = new RelationPredicateBucket();

            filterBucket.Relations.Add(new EntityRelation(LotFields.ItemCode, StockFields.ItemCode, RelationType.ManyToOne),"LLLL","SSSS", JoinHint.Inner);


            DataAccessAdapter adp = new DataAccessAdapter(@"data source=.\sqlexpress;initial catalog=ShopData;integrated security=SSPI;persist security info=False;packet size=4096");

            DataTable dt = new DataTable();

            adp.FetchTypedList(dtFields, dt, filterBucket);

            this.dataGridView1.DataSource = dt;

This is a warning. You've posted a couple of threads now, and I've pointed you to a thread with essential information. You refuse to obey to the points in that thread.

This means that we can't help you until you comply to the points in that thread. I also moved your thread to a forum which is more appropriate. The thread I was talking about is linked below.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7722

I also chopped up the thread heading as you pasted the complete error exception + stacktrace in there. Don't do that.