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