storing image in database

[indusurya]

how to store a file in database(MS SQL 2000)?

[r035198x]

how to store a file in database(MS SQL 2000)?

Read and find out what a BLOB is.

[rameshkumarc]

try the following code:

File imageFile = new File("ur imgpath");
Class.forName("give ur driver here").newInstance();
Connection con = DriverManager.getConnection("give ur dsn with tablename,un,pwd here");
PreparedStatement pstmt = con.prepareStatement("INSERT INTO tablename VALUES( ?, ? )" );
pstmt.setString( 1,"fir");
InputStream is = new FileInputStream(imageFile);
pstmt.setBinaryStream( 2, is, (int)(imageFile.length()));
pstmt.executeUpdate();