Hello Krishna,
since I see that you're joining tables BRD and PRD on their common field PRD_ID (I'm guessing that BRD.PRD_ID is a foreign key reference to table PRD), are you really sure that the join would return values?
Maybe the join of both tables is already empty.
Please try this:
MySqlCommand cmd=new MySqlCommand("SELECT PRD.PRD_IDY,BAT_NME,bat_idy FROM BRD, PRD WHERE BRD.PRD_IDY = PRD.PRD_IDY", con);
reader = cmd.ExecuteReader();
if(reader.HasRows)
{
reader.Read();
MessageBox.Show(reader.GetValue(0).ToString());
}
Does this return results?
Modification:
Ok. You said code I pasted above does also return no records. This means the join of both tables on their common column PRD_ID is empty.
This means in effect that both tables do not have a common value in column PRD_ID.
End Modification
Cheers
Manfred