|
But i need it using asp.net(C#)
|
|
|
|
|
Hello guys you really did the best for me.I am still new in programming world.
and Forgive me,for my poor English,I was successfully able to Upload my Binary file to the database but the challenging part came when I was trying to Download those binary file Like Pdf,doc FROM DATABASE
this is my DAtabase
CREATE TABLE ATTACHMENT
AttachmentID INT (PK),
FName varchar(50),
TYPE varchar(200),
Logo picture,
//Path varchar(200)
I don't want this code to download binary file from path all I need is to download from database as attachment,one of important thing,HOW TO use MemoryStream
this the code I used it on my website
protected void btnDownLoad_Click(object sender, EventArgs e)
{if (drpAttachmentID.Text != "select")
{SqlConnection cnn = null;
try{string display = " select Logo from Attachment where AttachmentID = '" + drpAttachmentID.Text + "'";
cnn = new SqlConnection(sqlcnstr);
SqlCommand cmd = new SqlCommand(display, cnn);
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{ reader.Read();
Response.ContentType = "application/octect-stream";
Response.BinaryWrite((byte[])reader["Logo"]);
Response.AddHeader("Content-Length", byteArray.Length.ToString());}
else{ this.RegisterClientScriptBlock("alertMsg", "<script>alert(no Image);</script>");
}reader.Close();}catch (Exception err)
{lblMsg.Text = err.Message;
}
}
else
{ lblMsg.Text += "Please select AttachmentID 1st ";}
}//end
THIS CODE IS ONLY ABLE TO DOWNLOAD THE PICTURE BUT CANNOT DOWNLOAD DPF,DOC
from kagisobk@gmail.com
THANKS FROM ALL OF YOU GUYS
<div class="ForumMod">modified on Thursday, February 07, 2008 2:49:27 AM</div>
|
|
|
|
|
Can you try using Response.WriteFile or Response.TransmitFile ?
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
|
|
|
|
|
Hi all
i have a doubt i.e
is it possible to call a function(not javascript function) on anchor tag onclick.
i wrote a function in aspx code page and i want to cal that function on anchor tag onclick.
can you plz help me...
thank you
siri
|
|
|
|
|
Hi,
Definately it is possible.
you have to make ur anchor tag as runat="server" than define onclick="function_name"
Hope this helps you.
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
thanku..
i will try this
siri
|
|
|
|
|
IN this case, best way to use Server Hyperlink control
|
|
|
|
|
Hi,
I am new to asp.net, I need help for u ,
gridview having more than one datakeys,
how do i get all datakeys correponding to selected row (by click on button)
in rowcommand event of gridview
modified on Thursday, February 07, 2008 2:46:42 AM
|
|
|
|
|
i have two qustions:
1: how do I refresh the page generally
2: I have a gridview and after I make changes in the data I want the datasource or the grid view to refresh them selves, briefly I want to know how to refresh the gridview content against the database \ datasource
Shimi
|
|
|
|
|
Hi,
I got ur Problem
tell Me whether you want to refresh the gridview with out rendering the page again or refreshing the whole page.
if u want to refresh the datasource of gridview whithout rendering the apge again do usse ajax object.
or do use javascript to refresh the whole page after certain period of time.
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
Hi Question 1:
<script language="javascript" type="text/javascript">
<!--
function refreshPage() {
window.setTimeout('window.location.href="sessionkeepalive.aspx";',300000);
}
//-->
</script>
and then in your body tag
<body onload="refreshPage()">
gridview refresh after any function like onindexchanged
put gridview.databind() after your action
|
|
|
|
|
For refresh no nead to write what page, just set location to the same location, for me it works ok on all browsers
function refreshPage() {
window.setTimeout('window.location.href=window.location.href;',300000);
}
|
|
|
|
|
when I insert a new row to the database (the adding controls are in the same page) I want after the adding action the grid view to retrieve the updated data from database
adding DataBind or GridView.DataBind() after the insertion does not do the trick.
Shimi
|
|
|
|
|
I think you want to refresh the page only when the user Changes the data in the Grid view Just do 2 things
1. Store the data Edited by the user
2. bind the grid view with data source
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
can you provide the line which refreshes the gridview against the database please?
(I'm using an ObjectDataSource to a webservice database, and the database is sometimes updated by other external applications, I want the user to have a refresh button which retrieves the data from db anew).
the GridView.DataBind() doesn't help.
I prefer to do it by the ASP.NET CLR code rather then by javascript.
best regards
Shimi
modified on Friday, February 8, 2008 2:13 AM
|
|
|
|
|
hi
what is sqldatahandler,it is avialable in ASP2.0 or SQL server 2000 or SQL server 2005
plz reply
regards
saravanan
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
|
Hi Friends.
I m using ASP.Net 2.0 to make a secure application which include giving permissions to a specific directory..
i m using FileIOPermission class to give permissions
FileIOPermission _FileIOPermission = new FileIOPermission(FileIOPermissionAccess.NoAccess, @"d:\");
_FileIOPermission.Demand(_FileIOPermission);
can anybody tell me y it is not working..and suggest me any alternative way to do this...
Thanx in Advance.
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
how can I rewrite url dynamically in .net Application.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
trilokharry wrote: rewrite url dynamically
What do you mean by rewrite dynamically ?
|
|
|
|
|
I want to show different URL in browser
which is not a original.
how can I do using glabal.asax
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Hi!
Look here[^]
May be this will help you.
Regards.
"Save water,It's precious"
|
|
|
|
|
hi,this is vasanthi,
i tried this one ,but i didn't get correct solution,i tried almost all the solutions,basically what i want is i don't want to display the query string value in the URL.i get that value from the database,then how can i hide or rewrite that url.pl z help me out
Thanks in advance.
|
|
|
|
|
hi all i have some audio file on my server i will retrive it and i want to play that in aspx page so how to do that i am working onn asp.net 2.0 using c#
please send me link where i will get example...please
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
Please don't post a message twice.
"Save water,It's precious"
|
|
|
|