Embed image in excelsheet - ASP.NET Discussion Boards

nithydurai28-Apr-08 0:28

28-Apr-08 0:28

What is this error....

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

I used sandbox testing....
if need SSL/TLS certifite

Re: Question

eyeseetee28-Apr-08 0:40

eyeseetee

28-Apr-08 0:40

http://www.google.co.uk/search?hl=en&q=The+underlying+connection+was+closed%3A+Could+not+establish+trust+relationship+for+the+SSL%2FTLS+secure+channel.+&btnG=Google+Search&meta=">http://www.google.co.uk/search?hl=en&q=The+underlying+connection+was+closed%3A+Could+not+establish+trust+relationship+for+the+SSL%2FTLS+secure+channel.+&btnG=Google+Search&meta=

Re: Question

Vasudevan Deepak Kumar28-Apr-08 1:34

Vasudevan Deepak Kumar

28-Apr-08 1:34

Either you can not establish a HTTPS connection with the web server or the server certificate is not valid.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Re: Question

DJ1618-Mar-13 8:29

DJ16

18-Mar-13 8:29

This error appear for me on a web app because of a remote server certificate failure.
The certificate error blocked the web service saying SSL authentication error.

Try to dig the for some certificate supporting the web service which u have and this is ONE OF THE POSSIBILITY of this kind of error.

If solved dont forget to thxs $Shucks | :-\$

Copying large file using streaming

248912828-Apr-08 0:21

2489128

28-Apr-08 0:21

Hi! i want to copy a large file (1 gb) from source to destination using 5 mb buffer size with the help of streaming. can any one help me in this regards?

Re: Copying large file using streaming

N a v a n e e t h28-Apr-08 0:28

N a v a n e e t h

28-Apr-08 0:28

2489128 wrote:
copy a large file (1 gb) from source to destination using 5 mb buffer size with the help of streaming. can any one help me in this regards?

Using ASP.NET ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Copying large file using streaming

Vasudevan Deepak Kumar28-Apr-08 1:35

Vasudevan Deepak Kumar

28-Apr-08 1:35

Did you try the MTOM Uploader?

http://www.codeproject.com/KB/XML/MTOMWebServices.aspx[^]

Embed image in excelsheet

sidbaruah27-Apr-08 23:45

sidbaruah

27-Apr-08 23:45

Hi!
I have a peculiar situation.
I need to export an image and a gridview control to excel.

im using rendercontrol for image and datagrid, however, the image only exports it with a link to the actual location.
The code snippet is :
//Code starts
Response.AddHeader("content-disposition", "attachment; filename=Export.xls");
Response.ContentType = "Application/vnd.ms-excel";
Response.ContentType = "Application/vnd.ms-excel";
System.IO.StringWriter strW = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(strW);
HtmlImage himg = new HtmlImage();
System.Drawing.Image img = System.Drawing.Image.FromFile(Server.MapPath("Charts.aspx"));
himg.Src = Server.MapPath("Charts.jpg");
himg.RenderControl(htw);
HtmlTable tbl1 = new HtmlTable();
int intRows = 0;
while (intRows < 23)
{
HtmlTableRow hrow = new HtmlTableRow();
tbl1.Rows.Add(hrow);
intRows++;
}
tbl1.RenderControl(htw);
GridView1.RenderControl(htw);
Response.WriteFile(Server.MapPath("RRAT_Charts.jpg"));
Response.Write(strW.ToString());
Response.End();
//code ends
What i need is to embed the image on to the excelsheet.
How can i do that?
Any ideas?

Thanks in advance!!

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Re: Embed image in excelsheet

Vasudevan Deepak Kumar28-Apr-08 2:13

Vasudevan Deepak Kumar

28-Apr-08 2:13

Check this out:

http://www.codeproject.com/KB/COM/ComExcelImages.aspx[^]

Re: Embed image in excelsheet

sidbaruah28-Apr-08 2:42

sidbaruah

28-Apr-08 2:42

Thanks deepak for the reply..
ill try that out..

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Image question

Krazy Programmer27-Apr-08 23:01

Krazy Programmer

27-Apr-08 23:01

hi friends

I have stored image in my database now i have retrieved that image how to set it to a image control

Thank You

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Re: Image question

Abhijit Jana27-Apr-08 23:06

Abhijit Jana

27-Apr-08 23:06

it depends upin your store procedure . if you have sotore the image patg , just retrive the image path and give it to imagecontrol url.

Best Regards
-----------------
Abhijit Jana
Microsoft Certified Professional
"Success is Journey it's not a destination"

Re: Image question

Krazy Programmer27-Apr-08 23:11

Krazy Programmer

27-Apr-08 23:11

hi
I have stored it in the image format of sql server 2005 i want to know how to assign the datareader value to the image control

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Re: Image question

rahul.net1127-Apr-08 23:19

rahul.net11

27-Apr-08 23:19

is u r image control in grid or on page ahd have you stored image name to db?

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Re: Image question

Krazy Programmer27-Apr-08 23:22

Krazy Programmer

27-Apr-08 23:22

presently...its something like i need to show the icon into a page ...

Image is stored my a X user into the Database ...so how to show the icon in the page from the database

I hope i am clear

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Re: Image question

rahul.net1127-Apr-08 23:33

rahul.net11

27-Apr-08 23:33

These link will help you.

http://www.odetocode.com/Articles/172.aspx[^]

ry<br />
<br />
{<br />
<br />
con = new SqlConnection(constr);<br />
cmd = new SqlCommand("select photopath,Photo from employees where employeeid=14", con);<br />
                con.Open();<br />
                dr = cmd.ExecuteReader();<br />
                while(dr.Read())<br />
                {<br />
                    if (!dr.IsDBNull(1))<br />
                    {<br />
                        byte[] photo = (byte[])dr[1];<br />
                        MemoryStream ms = new MemoryStream(photo);<br />
                        image.Imageurl = Image.FromStream(ms);<br />
                    }<br />
                  <br />
                   <br />
                }<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                dr.Close();<br />
                cmd.Dispose();<br />
                con.Close();<br />
<br />
                MessageBox.Show(ex.Message);<br />
            }

or
http://www.developerfusion.co.uk/show/3933/[^]

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Re: Image question

Krazy Programmer27-Apr-08 23:46

Krazy Programmer

27-Apr-08 23:46

Image.FromStream(ms);

It is not working !

Image. doesnt have from stream

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Re: Image question

N a v a n e e t h28-Apr-08 0:21

N a v a n e e t h

28-Apr-08 0:21

rahul.net11 wrote:
image.Imageurl = Image.FromStream(ms);

I guess ImageURL takes string - Isn't it ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Image question

N a v a n e e t h28-Apr-08 0:19

N a v a n e e t h

28-Apr-08 0:19

Image control is rendered as HTML img tag. So you need to create a page which reads image from SQL server, load to a Bitmap instance and saves to Response.OutPutStream. Set this page URL as image controls URL.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Image question [modified]

Krazy Programmer28-Apr-08 0:31

Krazy Programmer

28-Apr-08 0:31

Thank You navneet ... i got it ...

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

modified on Monday, April 28, 2008 6:48 AM

maintain set focus between postbacks

Vinay Dornala27-Apr-08 22:50

Vinay Dornala

27-Apr-08 22:50

Hi,

How do we maintain focus of control between postbacks

Thanks n advance

Re: Duplicate Post Please Ignore

Abhijit Jana27-Apr-08 23:02

Abhijit Jana

27-Apr-08 23:02

Please dont post same question !!!!

Best Regards
-----------------
Abhijit Jana
Microsoft Certified Professional
"Success is Journey it's not a destination"

Re: Duplicate Post Please Ignore

Vinay Dornala28-Apr-08 0:02

Vinay Dornala

28-Apr-08 0:02

but iam trying this from long time that's the reason i have posted in different way,

Re: Duplicate Post Please Ignore

_AK_28-Apr-08 0:09

_AK_

28-Apr-08 0:09

You can make the changes there in the original post itself. It is meaningless to post the same twice. Because whoever will read the one will surely read the second one too.

Apurva Kaushal

Re: maintain set focus between postbacks

trish_28-Apr-08 1:25

trish_

28-Apr-08 1:25

try to use following lie of code in page load-

Page.SmartNavigation = true;

trish
http://AllJobSearch.blogspot.com

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.