|
Displaying the image from the Sql
Hi,
I am trying to display image on the page stored in the SQL DB.
Image is store in the <BinaryData> format in the DB. I am display in the DataGrid its working fine, problem with page.
SqlCommand Cmd = new SqlCommand(Query, myconnection);
SqlDataReader dr = Cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
lblProdName.Text = Product;
lblProdDesc.Text = dr[0].ToString();
lblPrice.Text = dr[3].ToString();
byte[] Photo = (byte[])dr[5];
Response.ContentType = "image/jpeg";
Response.OutputStream.Write(Photo, 0, Photo.Length);
}
dr.Close();
only image is displayed on the page without any other content ,
if I comment lines
All the contents are displayed except the image.
what is the proper way to display the image on the page using SQL ??
Please help me with this.
Thanking you,
Naveen.
|
|
|
|
|
try this
Response.ContentType = "image/jpeg" ;<br />
Response.BinaryWrite(dr["ImageField"])) ;
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
Basically, you want to push a complete web page to a browser, but browsers are designed to pull pages.
I don't think you can send two streams like that for one display page (text + image).
However, if you programmatically create a ".mht" page, you cvould probably do what you're tryign to do. Maybe something in this article will give you an idea: Convert HTML to MHTML using ASP.NET[^]
|
|
|
|
|
GenJerDan wrote: you want to push a complete web page to a browser
What? No, the page is being rendered in response to a request. It's not like the web server is randomly connecting to some machine and trying to send content.
GenJerDan wrote: I don't think you can send two streams like that
There is only one stream. The images is being placed within that stream.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Mark Nischalke wrote: What? No, the page is being rendered in response to a request. It's not like the
web server is randomly connecting to some machine and trying to send
content.
Yes, but, basically, a browser requests something and the server delivers it in the stream, i.e. a pull, not a push. Then the browser "looks" at what it got and says to itself Ah-hah! I need to get the image for this. I better request another stream for it. It doesn't all come in one clump. Trying to send two streams when the broweser is only capable of requesting one at a time is not going to work.
Mark Nischalke wrote: There is only one stream. The images is being placed within that stream.
Nope. There needs to be multiple responses, one for each discrete item. Or there needs to be something on the browser itself that can take a multiplexed stream and demux it. An ActiveX control could do that....but there are too many problems there, the least of which is convincing the user to load yet another plugin. But the MHTML process is already built-in, which is why I suggested it. The only difficulty is in creating the MHTML object in your server code.
You can downvote me all you want, but it won't change the way browsers work.
|
|
|
|
|
GenJerDan wrote: There needs to be multiple responses, one for each discrete item.
Correct, one at a time.
What the OP was asking to is insert the image into the ONE stream along with the text, all of which which would be streamed to the requesting browser as one chunk of binary data. It is possible and is done quite frequently.
GenJerDan wrote: it won't change the way browsers work.
No but I think you need to change your understanding how things work. The down vote was justified because you are incorrect in your views and what you are suggesting is just plain wrong.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Oh, really? So what Content-Type type is text with embedded image that a browser can handle, other than as an email client? Other than the MHTML, of course.
Or should we all start worrying every web page out there being able to piggyback whatever they want in a content stream?
|
|
|
|
|
OK - what you're doing here is explicitly telling the browser that what's coming is an image in jpeg format (Response.ContentType), and that the content itself is the bytestream (Response.OutputStream.Write).
With those lines in place, you're NOT rendering anything else to the browser - just the image.
The default Response.ContentType is (IIRC) text/html - which is effectively a webpage, so with the lines commented, you're basically saying "do the normal thing", and not writing anything explicitly.
To render the image with the text, you need to set the Source of an Image control that's part of the page.
Something similar to the following...
byte[] imageData = (byte[])dr[5];
MemoryStream memStream = new MemoryStream(imageData);
image = Image.FromStream(memStream);
Which incidentally is pretty much ripped off wholesale from the top link in Google[^]
C# has already designed away most of the tedium of C++.
|
|
|
|
|
Hi,
I don't know if you have sorted this out but the last person who commented got it right though unclear.
What he/she meant is that have an already existing img/image on you page that it's src comes from another page like so:
<img id="theImageFromSQL" runat="server" alt="theImageFromSQL" src="ImagesPage.aspx?id=someId" />
//when a browser loads the image it will call ImagesPage.aspx and this page will write back JUST an image which is what you want (i guess)
You can leave the other controls on the 'main' page which could be Home.aspx/Default.aspx and ofcourse your img/image will be in this same main page.
shout if u need more help
Morgs
|
|
|
|
|
Hi,
im not able to find ActionLink<> in vs 2010 ..please help me..
what is the workaround for <%=Html.ActionLink<HomeController>(x => x.Index(),"Home")%>as the above line throws..error..bcos Strongly typed ActionLink is not present
|
|
|
|
|
|
I am trying to find the url of webservice from a page inside a subdirectory in my website. I am using a separate script file referenced in my page. This does not work in the script file
var pgUrl='<%= ResolveUrl("~/assets/WebServices/Admin/UsrRoleService.asmx") %>';
How do I find the application url in the script file ?
|
|
|
|
|
How about having script file in a .ASHX (Generic handler) so that ASP.NET can pre-process and send it...
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!
|
|
|
|
|
Try this code below
var pgUrl='<%= this.Page.ResolveUrl("~/assets/WebServices/Admin/UsrRoleService.asmx") %>';
|
|
|
|
|
This will not work. The OP is trying to call ASP.NET code from an actual .JS file... that's not going to work.
|
|
|
|
|
By "script file", I assume you mean JavaScript file. You can't call server-side functions from a JavaScript file. You will have to find a way to pass the URL to the JavaScript. One way would be to pass the URL in via the constructor (you would presumably call the JavaScript constructor from an ASPX page in a script block).
Though, I have found that I don't typically need to pass the URL of web services to the JavaScript if I am calling one of the methods using AJAX. Instead, I can add a service reference to the page's script manager (or in the case of a user control, the script manager proxy), then I can call the web service by name (e.g., ProjectName.UsrRoleService.SomeMethod(someParameter, function (resultData) { alert(resultData); });).
|
|
|
|
|
Hello All,
I have a datagrid, which has the paging and sorting option set up.
After sorting, the first page looks correct. Then when I click on the second page, I lose the sort and it does not show consistent results. How to maintain the sort order thru out the grid?
I have this set up for paging, nothing new,
public void Datagrid_page(object sender, DataGridPageChangedEventArgs e)
{
dgOBHires.CurrentPageIndex = e.NewPageIndex;
dgOBHires.DataBind();
}
|
|
|
|
|
Before binding the data, get the data, sort it and then bind the data. Can use view state to remember the sort expression.
Naina
|
|
|
|
|
hi all
I am using a third party gateway. The third party gateway does not support query-string , so i will need to post the form to pass the values to the given URL and another thing is that they don't expose the web-services so we need to use their page and that means we need to host it in an iframe in asp.net
so what i did is that i have hidden fields that will be used as parameters as depicted below
<input type="hidden" name="p1" value='4635' />
<input type="hidden" name="p2" value='Reference_test' />
<input type="hidden" name="p3" value='Purchase credits' />
<input type="hidden" name="p4" value='500' />
<input type="hidden" name="m_1" value='142' />
<input type="hidden" name="m_2" value='720' />
and i will have a button to demonstrate what i want and i have an iframe as depicted below
<asp:Button ID="Button1" runat="server" Text="Proceed" PostBackUrl="https://www.vcs.co.za/vvonline/ccform.asp" />
<iframe id="iframe1" src=""
style="width: 744px; height: 333px; margin-top: 16px; margin-bottom: 0px;">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
now on form load i have this
<body onload="Loadiframe()"
and the Javascript looks like this
<script type="text/javascript">
function Loadiframe() {
document.getElementById("iframe1").src = "https://www.vcs.co.za/vvonline/ccform.asp"
return false;
}
</script>
now the purpose of this , is to load the iframe after the page load event of the asp.net gets fired.
Now my problem here is that when the iframe loads , it does not pass the parameters to the url that is being set in the iframe.
I have attached the example, project. (2kb)
When you run the project you will notice when the iframe loads there is an Error
"NO VCS ID"
now this means that the parameters were not passed when the Iframe loads , i can understand because it seems like iframe does not do a full form post. so to demonstrate what i want, click the proceed button and you will notice it will give you a page with no errors and it will be a page where credit card details are required , i want to iframe to load that the first time.
Example Project[^]
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi,
I tried many ways to redirect Unauthorized Page on "401.2 - Access Denied".
but its not working.
plz help on this.
Regards,
Beula.
|
|
|
|
|
How about you share the many ways you have tried so we are not telling you the same thing or can point out why it didn't work
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
<customErrors defaultRedirect="ErrorPage.asp*x" mode="On">
<error statusCode="401" redirect="AccessDenied.aspx" />
</customErrors>
protected void Application_EndRequest(Object sender,
EventArgs e)
{
HttpContext context = HttpContext.Current;
if (context.Response.Status.Substring(0, 3).Equals("401"))
{
Response.Redirect("UnauthorisedPage.aspx");
}
}
if (!Request.IsAuthenticated)
{
Response.Redirect("UnauthorisedPage.aspx");
}
IIS > Virtual Directory properties > Custom Errors page > 401;2 > Properties
|
|
|
|
|
I have a simple textbox with an initial text, when I type some other text in the textbox it and click my submit button, I see that the textbox.Text value stays the old initial value and the information which I typed has lost. How can I fix it?
|
|
|
|
|
It sounds like the text is being re-initialised each postback. Try the following (in VB):
If not Page.IsPostback
// Initialise textbox
End If
|
|
|
|
|
Have your verified EnableViewState is on for this control? Is the control being re-initialized during the postback?
I know the language. I've read a book. - _Madmatt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
