----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Sreejith Message 3 in Discussion Thanks for the help Johnson. I searched Microsoft sql community yesterday and found a simple solution which worked for me. Here is the link. http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&query=image+field+in+footer&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=b4325c33-826b-4329-8f6e-2fde154a1e6a&mid=644ccf05-c3cf-40f6-8949-7311fc4b9892 <http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&query=image+field+in+footer&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=b4325c33-826b-4329-8f6e-2fde154a1e6a&mid=644ccf05-c3cf-40f6-8949-7311fc4b9892> Thanks again. Sreejith ________________________________ From: LovedJohnySmith [mailto:[EMAIL PROTECTED] Sent: Fri 21-Jan-05 1:38 AM To: BDOTNET Subject: Re: Image from DB in footer of SQL Report New Message on BDOTNET <http://groups.msn.com/bdotnet> Image from DB in footer of SQL Report <http://groups.msn.com/bdotnet/_notifications.msnw?type=msg&action=showdiscussion&parent=1&item=23632> Reply <mailto:[EMAIL PROTECTED]> Reply to Sender <mailto:[EMAIL PROTECTED]> Recommend <http://groups.msn.com/bdotnet/_notifications.msnw?type=msg&action=recommend&parent=1&item=23646> Message 2 in Discussion From: LovedJohnySmith <http://groups.msn.com/bdotnet/profile?user=LovedJohnySmith%E2%9C%93> 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 = View other groups in this category. <http://groups.msn.com/Browse?CatId=26> Also on MSN: Start Chatting <http://g.msn.com/2GRENUS/2_8085_01> | Listen to Music <http://g.msn.com/2GRENUS/2_8085_02> | House & Home <http://g.msn.com/2GRENUS/2_8085_03> | Try Online Dating <http://g.msn.com/2GRENUS/2_8085_04> | Daily Horoscopes <http://g.msn.com/2GRENUS/2_8085_05> 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 <http://groups.msn.com/contact> page. 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. Remove my e-mail address from BDOTNET. <mailto:[EMAIL PROTECTED]> ----------------------------------------------------------- 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]
