Dear All,

Can anyone tell me what is the ways of implementing the following operations:

Allow user to insert new row from jsp to database.
Database Table has 5 columns
User is able insert a blank row by pressing the button "Add Row", type in the data, and press the button "Save" to save all data to the database.

Thanks

hi,

if u want to insert the blank row then u can set that field alone "allow nulls" in database.suppose u want to add new row in your database...u can use the following code...

<%
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection cn=DriverManager.getConnection("jdbc:odbc:democms" ,"sa","sa");
      Statement st=cn.createStatement();
      String str1,str2;
      str1=request.getParameter("namet2");
       str2=request.getParameter("desigt3");
       String query = "insert into democms1 values('"+str1+"','"+str2+"')";
       int rs=st.executeUpdate(query);
       if(rs!= 0)
        {
             out.println("Entry successfully Inserted");
        }
        else
        {
            out.println("Error! Please try again.");
        }
       st.close();
       cn.close();
    %>

its working..so try this one..
i dont know whether i am getting your question or not.....for my understanding, i am sending this...am i right?