Federation Method

This is partially working, it’s bring back the result twice and the first record is always blank. Ex: Blank Line------- AA 123 BB 456 AA 123 BB 456 See my code below, thanks for your help!! string sqltext = "select dc, trans_group, part_number, part_name, serial_number, trans_number, trans_type, trans_name, created_by, state, call_ticket, created_on from P81M.dbo.min_transactions_all where serial_number = '" + masterserial + "';"; System.Data.OleDb.OleDbCommand com = new System.Data.OleDb.OleDbCommand(sqltext); com.Connection = myConnection; myConnection.Open(); System.Data.OleDb.OleDbDataReader myDataReader = com.ExecuteReader(); //create a MIN_Delivered_Transaction item Item res5 = this.newItem("MIN_Delivered_Transaction"); string newid = getNewID(); res5.setID(newid); res5 = res5.apply(); // int count = myDataReader.FieldCount; int count = 1; while (myDataReader.Read()) { for(int i = 0 ; i < count ; i++) { Item temp = this.newItem("MIN_Delivered_Transaction"); temp.setProperty("f_dc", myDataReader.GetString(0)); temp.setProperty("f_trans_group", myDataReader.GetString(1)); temp.setProperty("f_part_number",myDataReader.GetString(2)); temp.setProperty("f_part_name",myDataReader.GetString(3)); temp.setProperty("f_serial_number",myDataReader.GetString(4)); temp.setProperty("f_trans_number",myDataReader.GetString(5)); temp.setProperty("f_trans_type",myDataReader.GetString(6)); temp.setProperty("f_trans_name",myDataReader.GetString(7)); temp.setProperty("f_created_by",myDataReader.GetString(8)); temp.setProperty("f_state",myDataReader.GetString(9)); temp.setProperty("f_call_ticket",myDataReader.GetString(10)); res5.appendItem(temp); // Add a new item for each iteration of the loop } } myConnection.Close(); return res5;