Web Forms :: Showing Images From A SQL Database With A GridView?
Mar 21, 2010
I'm trying to show images that come from a sql query into a GridView column, the problem is that the best solution found in the web searches the database twice for each row.
This solution says that we have to first create a handler (ImageHandler.ashx),
It will receive the ID of the row that contains the image, and then query the database with that ID.
Then it will finally perform something like "context.Response.BinaryWrite((byte[])dReader["Photo"]);" (in this case the handler uses a DataReader, I guess we could use another approach)
We also have to declare the image column in the markup as:
<asp:TemplateField HeaderText="Image">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "ImageHandler.ashx?ID=" + Eval("ID")%>' />
</ItemTemplate>
</asp:TemplateField>
The problem is that, the Grid is bound to a SqlDataSource with a SelectCommand like: "Select ID, Name, Photo FROM Employees", that is already querying the database, then the GridView will execute the handler with the ID in it's query string, so the handler will query the database again for the same row, to extract the image.
Isn't there a way to send the image to the handler, so that it only performs the instruction "context.Response.BinaryWrite..." without having to query the database again?
View 7 Replies
Similar Messages:
Dec 2, 2010
i'm trying to show data in gridview through this code but everything appears except the images. I saved the image in sqlserver2005 as Image datatype and when i try to bind the gridview to the db by wizard the images appear when i press test query but nothing when running the app
In Class Named Admin: public DataTable Select_writer(string writer_name)
[Code]....
View 2 Replies
Nov 19, 2010
A user has multiple images which is stored in database(datatype varbinary ).I want to show all the images of that particular user in gridview.Can you people guide me how to achieve this?(Asp.net with c#)
View 4 Replies
Feb 8, 2010
i am trying to bind image column from database to a control (tried with gridview) to show images in one single row showing 3 images at a time with a scroll bar...can anyone let me know if there is any way of doing this with javascript but not with jquery??
View 7 Replies
Jun 29, 2012
protected void btnExportPDF_Click(object sender, EventArgs e) {
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
[Code] ....
Unable to cast object of type 'iTextSharp.text.html.simpleparser.CellWrapper' to type 'iTextSharp.text.Paragraph'. this error came how can i solve?
View 1 Replies
Aug 20, 2010
I've got a problem with showing images on a page, that i hope someone might help with.
I have two sites like this;
C:WebsitesWebsite - Main Site
C:WebsitesAdmin - Admin site for main site
There is a table in the database that has a link to an image in a folder like this;
C:WebsitesImages - image store
The problem i am having is that when i view the page, the images don't show up. But if connect to the images folder using Windows Explorer then view the page again the images are visible.
Is there a way to have an image store and then all images be availabe to both sites?
I have though about the possibility of using a structure like this; (but i'd rather not)
C:WebsitesWebsite - Main Site
C:WebsitesWebsiteAdmin - Admin site for main site
C:WebsitesWebsiteAdminImages - Image Store
And reference them like this;
Main Site '~/Admin/Images'
Admin Site~/Images
View 3 Replies
Apr 19, 2010
I have a sql database and want to store the image format into the database. I want to then display the image in a gridview. For the database I have entered the location of the image and not sure if this is the right thing to do. I'm not very good at this stuff so could you make it as simple as possible.
View 3 Replies
Feb 27, 2010
I have two columns in database name of the image(varchar) and image(BLOB) and i have inserted images into database.now i need to display on grid-view control. am banging my head since one day by searching and i have used handler but no use.
View 16 Replies
Apr 29, 2010
[Code]....
i am using asp.net with c#, i have table images
shop nvarchar(50),
imgc image
imgo image
iam saving images in a database but while retreving it is showing blank images. i want to display as thumb nail images
View 1 Replies
Dec 3, 2010
In my web application I have a separate folder for Images and MasterPages and I am using forms authentication. Thus if I will not allow anonymous access for Images folder the login page will not be able to show any image.
guide me if this is what we should be doing or is there any other way to handle the scenario. Also, let me know is there any drawback of this technique.
View 6 Replies
Dec 1, 2010
images not showing to google crawlers?
View 1 Replies
Dec 22, 2010
I am developing a web app which uses images. Because there are lots of images, I decided to store them in a location out of the web site, maybe they can reside in a different unit (g:Pictures for example, where g: is a drive that belongs to a disk array which is part of the web site infraestructure).
At the beginning, such pictures were saved in a folder within the web site project so it was easy to show them using the asp:image control's ImageURL property but now that they are outside, things get complicated.
View 4 Replies
Mar 21, 2010
i hv added a treeview control on the .aspx page, when i try to browse it from web server, the image is showing as broken image, where the image link is showing like this [URL]
View 1 Replies
Jan 5, 2011
I have a menue which is being generated from a DB table by help of the following XSLT :
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" encoding="utf-8"/>
[Code]....
View 2 Replies
Jul 17, 2015
I am working on URL Rewriting using RegisterRoutes.
its working fine but all css ,js and image not working when i redirect page using URL Rewrite.
my code is in global ascx is below
public static void RegisterRoutes(RouteCollection routeCollection) {
routeCollection.MapPageRoute("RouteForcategory", "Product/{Cat_Id}/{Cat_Name}", "~/ProductDetailss.aspx");
}
My image path is
<img src="images/logo.png" alt="logo">
But when i run then url and image path looking like below
http://localhost:49936/Product/3/Fruits
And my image path looked
http://localhost:49936/Product/3/images/logo.png
but above is not correct path .
When I redirect page from home page to Productdetailss.aspx then images css, directory root path are changed and its also rewrite. I dont want to rewrite css,js,and image path .
I am also used resloved url code but not working .
View 1 Replies
Jan 28, 2011
I want to make a website which showing thumbnail images be taken from local folder,say,'thumbnails' inside the root folder like listview items.Below each thumbnails,the name of the file would be displayed with check boxes for selecting any thumbnail images.Clicking on any thumbnails will redirect to another page where the thumbnails and the original image(with the same name in some other local folder say 'Original') would be displayed.
View 3 Replies
Nov 29, 2010
i need to show images from url wich i have in my behind code. For example i have listview control :
<asp:ListView ID="ListView1" runat="server">
View 14 Replies
Apr 14, 2010
I use a Masterpage.master and inside there are two images who are pointing to different pages, which I have coded as follows:
<!-- Header masterpage -->
<td>
<a href="default.aspx"><img src="~/images/hello.jpg" alt="hello1" /></a>
</td>
<td>
<a href="dhc/default.aspx"><img src="images/dhc.jpg" alt="hello2" /></a>
</td>
As you can see, i have two choices to go inside the root folder or inside the DHC folder.
Both folders should get their images from the IMAGE/ folder inside the root.
My problem is as follows:When i'm in the root part, the images of the masterpage.master are shown, but when i'm in the dhc/ folder part the images of the masterpage.master are not shown.
View 2 Replies
Apr 2, 2013
I need an asp.net project to save data in the gridview image and display the image with data and database
View 1 Replies
Mar 15, 2010
i have the following scenario, i have a column of a gridview that shows me a text telling me is the user is allowed or not to access to some page, but now i just showing allow and deny, but i wanna show images that represent me the action, how can i do that?
View 3 Replies
Oct 3, 2013
How to save images into the database as in MS SQL and how to show it into the gridview or anywhere?
View 1 Replies
Nov 10, 2010
I am using the ajax slideshow which retrives an Image URL from my database table/ It works fine but as soon as I started using the Intelligencia.UrlRewriter, images are not showing. all my code is below.
Code Behind
private static DataTable tblData = new DataTable();
string sName = Request.QueryString["Id"];
<query string param is UserId>
string strSQL = "SELECT [ImageUrl],[FirstName], [LastName] FROM [Images] WHERE ([FootballerId] = @FootballerId)";
SqlConnection conn = new SqlConnection("Data Source=xxxxxxxxxxxxxxxxxx");
conn.Open();
SqlCommand comm = new SqlCommand(strSQL, conn);
comm.Parameters.Add("@FootballerId", SqlDbType.NVarChar).Value = sName;
SqlDataAdapter da = new SqlDataAdapter(comm);
tblData = new DataTable();
da.Fill(tblData);
conn.Close();
// set the initial image
if (tblData.Rows.Count > 0)
{
imgShowImage.ImageUrl = tblData.Rows[0]["ImageUrl"].ToString();
imageLabel1.Text = tblData.Rows[0]["FirstName"].ToString();
}
}
}
[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public static AjaxControlToolkit.Slide[] GetSlides()
{
AjaxControlToolkit.Slide[] slides = new AjaxControlToolkit.Slide[tblData.Rows.Count];
for (int i = 0; i < tblData.Rows.Count; i++)
{
DataRow dr = tblData.Rows[i];
slides[i] = new AjaxControlToolkit.Slide(
dr["ImageUrl"].ToString(),
dr["FirstName"].ToString(),
dr["LastName"].ToString());
}
return slides;
}
ASPX
<cc1:SlideShowExtender
ID="slideshowextend1"
TargetControlID="imgShowImage"
SlideShowServiceMethod="GetSlides"
AutoPlay="true"
ImageDescriptionLabelID="imageLabel1"
NextButtonID="nextButton"
PlayButtonText="Play"
StopButtonText="Stop"
PreviousButtonID="prevButton"
PlayButtonID="playButton"
Loop="true"
runat="server"
Enabled="True">
</cc1:SlideShowExtender>
<div
class="GridRight">
<asp:Image
ID="imgShowImage"
runat="server"
Height="300px"
ImageAlign="Middle"
/>
</div>
SQL Database Path
/Footballer/sandra//Horses.jpg
Web Config
<rewriter>
<rewrite url="~/Sandra" to="~/CMC/PublicProfile.aspx?Id=dff12c6b-e37c-4591-97ae-a65c27c1de1d"/>
</rewriter>
rewriter>
<
View 2 Replies
May 7, 2015
If in one form upload image form we enter ID in textbox againts ID label and upload an image file using fileuploadcontrol when we click on upload button image save in DB and in next form view image when we enter ID in textbox againts label enter ID. Images show in GRIDVIEW having columns (ID,images) ...
View 1 Replies
Mar 8, 2011
I recently learnt of a method to display binary images, from a sql table, that requires that the image's ImageUrl be a url of a second page with a querystring value. For example, if I have two pages, Page1 and Page2, If my image is on Page1, the imageUrl would be something like page2.aspx?ImgID= ImageID(The Querystring value passed to Page2 from Page1) . This method displays the image perfectly in the local host but then only the red X icon, that replaces a missing image, shows up when I run my application online.
Why are the images not displaying and how may I correct this? I have my codes below.
Image on Page1:
[Code]....
And this code displays the image on page1 but is the same on page2:
[Code]....
View 1 Replies
Apr 13, 2010
this is probably something really simple but I cant see what! Any images I have in a masterpage aint showing in child pages, all i get is the box with the red cross in it. Dont think Ive done anything different from usual and its not something thats happened in other sites so im kinda scratchin my head with it.
View 5 Replies