----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: LovedJohnySmith Message 2 in Discussion Hi Sreejith, I had similiar kin of problem in past one year, Actually the problem is, In .NET doesn't provide any Image datatype, so wat you may need to achive this, Get Empty DataSet which one of the column in Image DataType in SQL Server. The following example will illustrates the operation. string strBLOBFilePath = @"C:\Sample.gif"; //Image Processing System.IO.FileStream fsBLOBFile = new System.IO.FileStream(strBLOBFilePath,FileMode.Open,FileAccess.Read); byte[] bytBLOBData = new byte[fsBLOBFile.Length - 1]; fsBLOBFile.Read(bytBLOBData,0, bytBLOBData.Length); fsBLOBFile.Close(); DataRow dr; DataColumn dc = new DataColumn(); //append into a table dr= dsBLOB.Tables[0].NewRow(); dr["SIGNATURE"] = bytBLOBData; // here Signature has DataType as Image in SQL Server Table. dsBLOB.Tables[0].Rows.Add(dr); dsBLOB.Tables[0].AcceptChanges(); Description: Your Table Structure like this Signature IMAGE SignPath VARCHAR Initially, You need to Get Empty DataSet(Using SELECT SIGNATURE FROM TBLNAME). Now Your DataSet has Signature Column which is Image DataType. You need to assign your ImageFile path to strBLOBFilePath, then Read Your Image File Content and convert into stream of bytes. then append this stream of bytes into your DataRow["SIGNATURE"]. Then you accede this DataSet into your Report. I hope this may clear, if not pls lemmi noe, ill guide you. Regards, Smith= ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
