How to delete a row of a table in Ms Access which contains JTextFields, JComboboxes etc..
We have to delete it using java connectivity.I mentioned :
try
{
String s;
s=tmid.getText();
//Here tmid is JTextField which contains mid i.e. member id. I've made it primary key in table.String qry="Delete from sport where Mid = "+s+" ";
//sport is the name of my table.smt.executeUpdate(qry);
}
catch(SQLException e)
{
System.out.println(e);
}
When I run this program it gives a SQLException and says "too few parameteres.".
I took tmid as String .
Plz help me.
Ad Choices