Hi Friend,

Actually the text area overrides the first record. To overcome this problem, create an array list and retrieve database data into it.Then convert the list into string and add the data to text area as we have done in the following code:

try
{
String name=tf6.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con3;
con3=DriverManager.getConnection("jdbc:odbc:access","","");
PreparedStatement stat3=con3.prepareStatement("select * from proj where name=?");
stat3.setString(1,name);
ResultSet res=stat3.executeQuery();
String strVal="";
while(res.next()){

ArrayList al = new ArrayList();
al.add(res.getString(1));
al.add(res.getString(2));
al.add(res.getString(3));
al.add(res.getString(4));
Iterator itr = al.iterator();
while(itr.hasNext())
{
strVal+= itr.next().toString()+" ";
}
}
ta1.setText(strVal);
con3.close();
}
catch(Exception exp3)
{
JOptionPane.showMessageDialog(p2,"Error Code 3: Can't Search may be you have entered an invalid name");
}

Thanks