JDBC and insert in VJ#

From: Sunder Balachander via .NET 247 (anonymous_at_dotnet247.com)
Date: 08/06/04

  • Next message: Mads Pedersen: "RE: JDBC and insert in VJ#" 
    Date: Thu, 05 Aug 2004 18:58:21 -0700

    (Type your message here)

    --------------------------------
    From: Sunder Balachander

    I have a problem the corresponding code works fine with Java but the sam I am not able to in VJ# i am using VJ# 2005 beta express Edition . I am not able insert into MS-Access database using the following code in VJ# can anyone help me. I dont get any errors.

    public String Insert(String user , String pass , String first , String last , String dept)throws SQLException
            {
                    String b=" ";

                    try
                    {
                            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                            Connection con = DriverManager.getConnection("jdbc:odbc:HelloWorld",
                                                     "", "");
                            Statement stmt = con.createStatement();
                            String str = "INSERT INTO user(User,pass,first,last,dept) VALUES ('" + user + "', '" + pass + "', '" + first + "', '" + last + "', '" + dept + "')";

                            System.out.print(str);
                            int result = stmt.executeUpdate(str);

                            if (result != 0)
                            {
                                    b = "Succesfully added";

                            }
                            else
                            {
                                    b = "failed";
                            }

                            System.out.println(result);

                            con.commit();
                            stmt.close();
                            con.close();

                            
                    }
                    catch (Exception e)
                    {
                            e.printStackTrace();
                    }
                    return b;
            }
    }

    -----------------------
    Posted by a user from .NET 247 (http://www.dotnet247.com/)

    <Id>vkUk+peYaEW4JqcdpDXz3w==</Id>

  • Next message: Mads Pedersen: "RE: JDBC and insert in VJ#"
    Loading