Inserting images into Mysql database:

Question

i googld som codes for this,

but didtnt work well!!

M in Website: and i need profile iamges of each user to be stored in databse:

so in my form i put file [browse button] and an asp button for saving :

can post codes for this?

MYsql and C#.net

pls help me!!!

Rujuta · Answer

First create a database column with datatype image Now use this code Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} HttpPostedFile img; img = FileUpload.PostedFile; Byte [] bt = new Byte [img.ContentLength]; img.InputStream.Read(bt, 0, img.ContentLength); when you use the insert query for the column with image datatype insert the value bt! Hope this helps you.......

Lalit M · Answer

You can use this code sample public class DataAccess { private string _strConn = @" Driver= {MySQLODBC 3.51 Driver};SERVER=localhost;DATABASE=test;" ; private OdbcConnection _objConn; public DataAccess() { this ._objConn = new OdbcConnection( this ._strConn); } // This function adds the Images to database public string addImage( byte [] buffer, string extension) { string strSql = " SELECT * FROM File" ; DataSet ds = new DataSet( " Image" ); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql, this ._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds, " Table" ); try { this ._objConn.Open(); DataRow objNewRow = ds.Tables[ " Table" ].NewRow(); objNewRow[ " Extension" ] = extension; objNewRow[ " Data" ] = buffer; ds.Tables[ " Table" ].Rows.Add(objNewRow); // trying to update the table to add the image tempAP.Update(ds, " Table" ); } catch (Exception e){ return e.Message;} finally { this ._objConn.Close();} return null ; } // This function to get the image data from the database public byte [] getImage( int imageNumber) { string strSql = " SELECT * FROM File" ; DataSet ds = new DataSet( " Image" ); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql, this ._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds, " Table" ); try { this ._objConn.Open(); byte [] buffer = ( byte [])ds.Tables[ " Table" ].Rows[imageNumber][ " Data" ]; return buffer; } catch { this ._objConn.Close(); return null ;} finally { this ._objConn.Close();} } // Get the image count public int getCount() { string strSql = " SELECT COUNT(Data) FROM File" ; DataSet ds = new DataSet( " Image" ); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql, this ._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds, " Table" ); try> { this ._objConn.Open(); int count = ( int )ds.Tables[ " Table" ].Rows[ 0 ][ 0 ]; return count; } catch { this ._objConn.Close(); return 0 ;} finally { this ._objConn.Close();} } } Show reference Show here more info