Getting Image From DB Error?

Mar 30, 2006

Unsure why I am getting such an error when the image is there and the
search feature for the site is not working so that doesn't help so I'm
hoping some out there can offer why I maybe getting this and help me
with getting the image from the DB.



I use the code from the starter app for retrieving an image from the DB and I get the error message:

Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'



Here is the code and I am getting the error on the red line (Return New MemoryStream(CType(result, Byte()))):



Public Overloads Function GetPhoto(ByVal UserName As String) As Stream

        command.CommandText = "sp_Themes_GetUserThemeImage"

        command.Parameters.Add("@UserName", SqlDbType.VarChar, 50)

        command.Parameters(0).Value = UserName



        Dim result As Object = command.ExecuteScalar

        Try

            If result Is Nothing Then

               
Dim path As String =
HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings("siteImageDirectory"))

                path = (path + "noimageav.gif")



               
Return New FileStream(path, FileMode.Open, FileAccess.Read,
FileShare.Read)

            Else

                Return New MemoryStream(CType(result, Byte()))

            End If

        Catch e As ArgumentNullException

            Return Nothing

        End Try

    End Function



---this is the code from the imagehandler.ashx page----

Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest

       

        Dim userName As String

        Dim stream As IO.Stream = Nothing

        If ((Not (context.Request.QueryString("UserName")) Is Nothing) _

           AndAlso (context.Request.QueryString("UserName") <> "")) Then

           
userName = [Convert].ToString(context.Request.QueryString("UserName"))

            stream = (New PhotoManager).GetPhoto(userName)

       

            '
Get the photo from the database, if nothing is returned, get the
default "placeholder" photo

            'If (stream Is Nothing) Then

           
'    stream = (New PhotoManager).GetDefaultPhoto()

            'End If

            ' Write image stream to the response stream

            Dim buffersize As Integer = (1024 * 16)

            Dim buffer() As Byte = New Byte((buffersize) - 1) {}

            Dim count As Integer = stream.Read(buffer, 0, buffersize)

       

            Do While (count > 0)

               
context.Response.OutputStream.Write(buffer, 0, count)

               
count = stream.Read(buffer, 0, buffersize)

            Loop

        End If

    End Sub



---this is how I call it from the image.aspx page----



<img src='imageHandler.ashx?username=<%# Eval("UserName") %>'
style="border:2px solid white;height:40px;" alt='Thumbnail.' />



Thanks for all your help.

View 6 Replies


ADVERTISEMENT

Image Error In SQL

Sep 1, 2006

I have a seperate table that holds employees pictures in it and for some reason I am getting an error all the sudden when I try to insert a picture. I never got that before.. Can anyone help please??

View 2 Replies View Related

Image Replication Error . Please Help !!

May 16, 2002

Hello ,

I have configured a transactional replication from SQL 7.0 to SQL server 2000 .SQL 7.0 server is a publisher and SQL 2000 server is a subscriber .
When i try to insert image greater than 64 KB it gives me an error message that replication supports only 64 KB .
This specific replication works over the firewall . So i really don't know whether its a problem of the firewall or the SQL Server configuration at both the ends .

Any help would be appreciated .

Thank you very much .

Regards,
Jerry .

View 1 Replies View Related

Error During Execute Sp With IMAGE Parameter

Sep 17, 2006

Hello.
It is the first time that Im using IMAGE field type..

I created a stored procedure that should return an IMAGE field back to a
c-sharp program .
(@OutImg IMAGE declared as an output parameter of the procedure.)
(Select @OutImg = ImgFld from table)
Well,I can compile it , but when execute i get this error :
Msg 2739, Level 16, State 1, Line 14
The text, ntext, and image data types are invalid for local variable.

Is there something I can do ,OR should I use any cast/convert func to solve it ..?
Many thanks.:o

View 1 Replies View Related

Sending Uploaded Image To Data Access Class When Storing Image In SQL Server 2005

Apr 20, 2007

I am using the 3-tiered architecture design (presentation, business laws, and data acess layers). I am stuck on how to send the image the user selects in the upload file control to the BLL and then to the DAL because the DAL does all the inserts into the database. I would like to be able to check the file type in the BLL to make sure the file being uploaded is indeed a picture. Is there a way I can send the location of the file to the BLL, check the filetype, then upload the file and have the DAL insert the image into the database? I have seen examples where people use streams to upload the file directly from their presentation layer, but I would like to keep everything seperated in the three classes if possible. I also wasn't sure what variable type the image would be in the function in the BLL that receive the image from the PL. If there are any examples or tips anyone can give me that would be appreciated.

View 2 Replies View Related

Please Correct This Error While I Retriving Image From Database

Sep 4, 2007

private void Page_Load(object sender, System.EventArgs e){    // Put user code to initialize the page here    MemoryStream stream = new MemoryStream ();    SqlConnection connection = new       SqlConnection (@"...");    try    {        connection.Open ();        SqlCommand command = new           SqlCommand ("select Picture from Image", connection);        byte[] image = (byte[]) command.ExecuteScalar ();           stream.Write (image, 0, image.Length);        Bitmap bitmap = new Bitmap (stream);        Response.ContentType = "image/gif";        bitmap.Save (Response.OutputStream, ImageFormat.Gif);    }     finally    {        connection.Close ();        stream.Close ();    }
Error:       byte[] image = (byte[]) command.ExecuteScalar ();   
Unable to cast object of type 'System.Int32' to type 'System.Byte[]'.

View 1 Replies View Related

Error In Image Field When Using CASE Statement

Dec 7, 2004

I've this Stored procedure on a SQLserver 2000 SP3:


SELECT *,CASE immagine WHEN NULL THEN 0 ELSE 1 END AS hasImage
FROM Squadre WHERE squadra = @squadra

this is a flag that returns if the image field is present or not..
i've a lot of this type of stored procedures.. but this one returns me an error..

---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Errore 306: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
---------------------------
OK
---------------------------

An i can't save.. why?
reme,ber that in the same Db there's other Stored like this.. the same syntax and the same field or table.. can anyone help me??

View 2 Replies View Related

How To Save Image In Sql Server And Display That Image In Datagrid??

Jun 27, 2007

Hay Friend's
Can u plese send me the way how to save image in sql server and display that images in datagrid or other control also like Image control or Image control Button?? Plese send the coding in C#.
 Thank's
Amit

View 5 Replies View Related

How To Store Image In Image Field In Sql Server 2000

Jul 12, 2007



hi all,

i have created a table with image field in it. Now i just want to store a jpeg file in it but not finding any way to do so.



how can i store any image ? what are the steps???????





thanx in advance



View 5 Replies View Related

HOW To Retrieve An Image From Sql Server And Display It In ASP.net Using Imagemap Or Image ?

Jul 6, 2006

Ok, the problem is that , i have a field called "Attach" in sql of type image, when selecting it , the field is getting data of type BYTE(). which am being unable to display them on an Image on the panel.

using the following vb.net code:

'Dim sel2 As String

'Dim myCom As SqlCommand

'Dim conn As New SqlConnection

'Dim drr As SqlDataReader

'Dim image As System.Drawing.Image

'sel2 = "select * from attach where att_desc = '" & DropDownList1.SelectedItem().Text & "' and doc_code = " & w_doc_code & " and subcode = " & w_doc_subcode & " and doc_num= " & w_doc_num & " "

'conn.ConnectionString = ("server=developer01;uid=sa;password=aims;database=DVPSOC;timeout=45")

'myCom = New SqlCommand(sel2, conn)

'conn.Open()

'drr = myCom.ExecuteReader()

'If drr.Read Then

' Me.ImageMap1.ImageUrl = drr.Item("attach")

'End If

'conn.Close()

Am getting an exeption on the following line Me.ImageMap1.ImageUrl = drr.Item("attach")

saying: Conversion from type 'Byte()' to type 'String' is not valid.

knowing that i tried converting using ToString but it's not getting any output then.

thanks for your help.

View 4 Replies View Related

The Insert/update Of A Text Or Image Did Not Succeed (was SQL Error)

Jan 17, 2005

First I recieve this error when I upload a photo and click on the save button.
'ODBC - update on a linked table 'PersonMisc' failed.'

Then this error appears after I click ok.

[Microsoft][ODBC SQL Server Driver][SQL Server] The READTEXT and WRITETEXT statements cannot be used with views[#285][Microsoft][ODBC SQL Server Driver] Warning: Partial insert/update The insert/update of a text or image did not succeed.[#0].

Is there a size limit on the pictures I am uploading?

View 2 Replies View Related

Text, Ntext, Or Image Node Does Not Exist Error

Apr 17, 2006

Hai Friends...

I am using sql server 2000. i have one table with columns

empid notnull
empfname not null
empmname null
emplname not null

while i am writing a simple procedure to get the employee middel name(empmname) it is giving the error message like this


Server: Msg 7105, Level 22, State 6, Procedure emp_statistics, Line 11
Page (1:70), slot 18 for text, ntext, or image node does not exist.

Connection Broken



plase help me Urgent

Thanks and Regards

Krishna Mangamuri

View 8 Replies View Related

SQL ERROR - I Need DISTINCT But Can Use It With Image,ntext, Text - How To Work Aroud???

Oct 10, 2006

SQL ERROR - I need DISTINCT but can use it with image,ntext, text - How To work around???  ! more - How to Work around - MIN() I cant use it when having text in SELECT statement  The text, ntext, or image data type cannot be selected as DISTINCT.



Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The text, ntext, or image data type cannot be selected as DISTINCT.

Source Error:





An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below. 

View 2 Replies View Related

Throwing Error When Querying The Image Of Database In SQL Server 2000.

Oct 3, 2007



I created an Image for the Database in sqlserver 2000. When I am querying directly the database as "Select * from employee", it is returning the result set.

But, when I am querying Database image with same query. It is giving error

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'Employee'

It is expecting the Database Owner. If I do query like "Select * from [Owner].employee", it is working fine.

My requirement is not use owner in queries, it should be simple query ("Select * from employee").


Can any one, help me out.
Thanks in advance.
Bhupesh

View 1 Replies View Related

How Image Display From SqlServer To Image Control

Feb 13, 2007

I have learned lots of informative thing from your forums. I have little problem regarding “Display image from SQL Server on ASP.NET� I have done it and image display on my page from SQL Server. I have cleared you here I have adopt two different methods which are following for displaying picture.

1.Response.BinaryWrite(rd("picture"))
2.image.Save(Response.OutputStream, ImageFormat.Jpeg)

but in both above methods I have faced little problem when image display on my page all other information can not display and I also want to display picture on my specific location on the page. My second question is can use any web control like “Image1� to display image from SQL Server where my pictures are stored.

Hope you will help me.

Thanks and regards


Aftab Abbasi

View 4 Replies View Related

Inserted The Image In A Column----how Can I View The Image

Mar 7, 2006

hi,i have inserted the image present in mydocuments using alter commandcreate table aa(a int, d image)insert into aa values (1,'F:prudhviaba 002.jpg')when i doselect * from aai am getting the result in the column d as0x463A5C707275646876695C70727564687669203030322E6A 7067how i can i view the image?pls clarify my doubtsatish

View 2 Replies View Related

1st Image Control Shows Wrong Image

Jan 30, 2007

In my asp.net application I have a local report with an image control in thedetail row of the table and the Value attribute set as="File://" & Fields!FQPhotoFileName.ValueThe first row in the table always shows the wrong image and it's always thesame wrong image. The problem is there even when I change the sort order orthe criteria for the underlying dataset. For example, I ran a small testthat populated the dataset with 2 rows and 2 images. When I sort by anycolumn (e.g. ID) in ascending ascending order the ID=1 row (the 1st row)shows the wrong image and the ID=2 row shows the correct image. When I rerunthe report sorting in descending order the ID=2 row (which is now the 1strow) shows the wrong image and the ID=1 shows the correct image.Any suggestions?

View 1 Replies View Related

Image Located On Web, Url For Image Stored In Database

Aug 17, 2007



Hi,
I have a website and i am uploading the gif image to the database. i have used varchar(500) as the datatype and i am saving the file in the webserver so the path to it c:intepub....a.gif


my upload table has the folliwing feilds
UploadId Int Identity, Description, FileName, DiskPath varchar(500), weblocation varchar(500). I have a main sproc for the report where i am doing a inner join with other table to get the path of the gif..

So my question is how can i get a picture to show up on the report. .
What kinda datatype the gif file should be stored in the database? If it is stored as a varchar how can i access it and what is best way to reference that particular.

any help will appreciated....
Regards
Karen

View 9 Replies View Related

Inserting Image File Into Image Column In DB

Sep 20, 2006

I have inherited a VS 2005 database with a table that has a column of type IMAGE. I need to change the image for one of the rows in the table. I have the new image in a *.PNG file on my C: drive. What is the correct method for inserting this file into the IMAGE column.

Many thanks!

View 6 Replies View Related

Server Error: Object Reference Not Set To An Instance Of An Object. Trying To Upload Image In Database

Dec 17, 2007

Does any one has any clue for this error ? I did went through a lot of articles on this error but none helped . I am working in Visual studie 2005 and trying to upload image in sql database through a simple form. Here is the code
 
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.IO;
public partial class Binary_frmUpload : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{
}protected void btnUpload_Click(object sender, EventArgs e)
{if (FileUpload.HasFile == false)
{
// No file uploaded!lblUploadDetails.Text = "Please first select a file to upload...";
}
else
{string str1 = FileUpload.PostedFile.FileName;
 string str2 = FileUpload.PostedFile.ContentType; string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
//Initialize SQL Server Connection SqlConnection con = new SqlConnection(connectionString);
//Set insert query string qry = "insert into Officers (Picture,PictureType ,PicttureTitle) values(@ImageData, @PictureType, @PictureTitle)";
//Initialize SqlCommand object for insert. SqlCommand cmd = new SqlCommand(qry, con);
//We are passing Original Image Path and Image byte data as sql parameters. cmd.Parameters.Add(new SqlParameter("@PictureTitle", str1));
cmd.Parameters.Add(new SqlParameter("@PictureType", str2));Stream imgStream = FileUpload.PostedFile.InputStream;
int imgLen = FileUpload.PostedFile.ContentLength;byte[] ImageBytes = new byte[imgLen]; cmd.Parameters.Add(new SqlParameter("@ImageData", ImageBytes));
//Open connection and execute insert query.
con.Open();
cmd.ExecuteNonQuery();
con.Close(); //Close form and return to list or images.
 
}
}
}
 
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error:



Line 32:
Line 33: string str2 = FileUpload.PostedFile.ContentType;
Line 34: string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
Line 35:
Line 36: //Initialize SQL Server Connection Source File: c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs    Line: 34  
Stack Trace:




[NullReferenceException: Object reference not set to an instance of an object.]
Binary_frmUpload.btnUpload_Click(Object sender, EventArgs e) in c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs:34
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

View 2 Replies View Related

Error Inserting Image Into SQL Server2000 Table From Pocket PC Application Only When Using Stored Procedure In Table Adapter Wiz

Apr 24, 2008

My Pocket PC application exports signature as an image. Everything is fine when choose Use SQL statements in TableAdapter Configuration Wizard.


main.ds.MailsSignature.Clear();

main.ds.MailsSignature.AcceptChanges();


string[] signFiles = Directory.GetFiles(Settings.signDirectory);


foreach (string signFile in signFiles)

{


mailsSignatureRow = main.ds.MailsSignature.NewMailsSignatureRow();

mailsSignatureRow.Singnature = GetImageBytes(signFile); //return byte[] array of the image.

main.ds.MailsSignature.Rows.Add(mailsSignatureRow);

}


mailsSignatureTableAdapter.Update(main.ds.MailsSignature);

But now I am getting error "General Network Error. Check your network documentation" after specifying Use existing stored procedure in TableAdpater Configuration Wizard.


ALTER PROCEDURE dbo.Insert_MailSignature( @Singnature image )

AS

SET NOCOUNT OFF;

INSERT INTO MailsSignature (Singnature) VALUES (@Singnature);



SELECT Id, Singnature FROM MailsSignature WHERE (Id = SCOPE_IDENTITY())

For testing I created a desktop application and found that the same Code, same(Use existing stored procedure in TableAdpater Configuration Wizard) and same stored procedure is working fine in inserting image into the table.

Is there any limitation in CF?

Regards,
Professor Corrie.

View 3 Replies View Related

Showing Image Using Image Url

Apr 1, 2007

Hi,



I need to show images in the report based on the urls from the db. The images are stored within a folder and not in the db (only the url in db). I couldnt find any way to give an url in the report and show the image. I'm stuck here , could you please help?



Thanks,

Sonu.

View 10 Replies View Related

Ms Sql Image + Vb.net

May 22, 2006

Hi,could anyone help me how to get the images from ms sql database with asp.net (visual basic)?I have a field in the database with datatype image, and there are a couple of images in this table.Now I am wondering how to get this images and view them on my .aspx page?Thank you.

View 1 Replies View Related

Get Image From URL?

Nov 6, 2012

Is it possible to get Image from URL, in a stored Procedure and store the image in db?

View 2 Replies View Related

Getting An Image From A Url

Dec 24, 2007

I'd like to display our logo image from a local file rather than embedding it. RS doesnt seem to like it when I use the local hard drive as a URL for locating the .bmp image (I just enter c:filename.bmp). Is there a simple recipe for either relocating this file locally to a place (eg IIS) that RS will consider a valid URL or leaving it where it is but still entering the URL in a way that will allow RS to get it at run time from the c: drive?

View 4 Replies View Related

Db Url To Image

Aug 21, 2007

Hi All, I am pretty new to reporting services, but i have question regarding how to display an image when i pull the url from a database. I cannot seem to figure out how to do it and it seems pretty simple. If anyone has any ideas please let me know.

Thanks so much

josh

View 2 Replies View Related

How To Insert An Image To Sql Db?

Sep 27, 2006

Hi there! how to insert an image to sql db using FileUpload Control? I saw a data type named "image", so it means to say you are able to insert an image and not the path, am I right? I spent a lot of time to do this but still, I don't know how to store the image to the db. Please post your example code if you want... I will appreciate all your suggestions or comments about this. Thanks!

View 2 Replies View Related

Adding An Image To SQL

Dec 4, 2006

Looking for any help someone can offer on adding an image to SQL.Working on what will hopefully be quite a big site and the user will be asked for some details, one of which will be an image (jpg, gif or bmp).Rather than add the image to a folder on the server, a folder which could end up being quite large, I was hoping someone could give me some help, suggestions or even point me towards a tutorial on how to store the image in an SQL database.Any helps appreciated, thanks :)

View 2 Replies View Related

Upload An Image ....?!

Dec 24, 2006

I used upload image feature and below is the code that I used. The image is stored in a folder. I want to save the image in sql database. I create the database which is “database�, and I create a table which is “user�. User table has auto “id� field and “image� field. I want to save the image in the image field. I need your help to do the other codes.
 
I am using asp.net with VB
 
This is what I did so far:
============================
Partial Class upload
    Inherits System.Web.UI.Page
    Dim strFileName As String
 
    Protected Sub btnupload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnupload.Click
        UploadImage()
    End Sub
    Sub UploadImage()
 
        If Not (fileupload1.PostedFile Is Nothing) Then 'Check to make sure we actually have a file to upload
 
            Dim strLongFilePath As String = fileupload1.PostedFile.FileName
            Dim intFileNameLength As Integer = InStr(1, StrReverse(strLongFilePath), "")
            strFileName = Mid(strLongFilePath, (Len(strLongFilePath) - intFileNameLength) + 2)
 
            Select Case fileupload1.PostedFile.ContentType
                Case "image/pjpeg", "image/jpeg" 'Make sure we are getting a valid JPG image
                    FileUpload1.PostedFile.SaveAs(Server.MapPath(" estimages") & strFileName)
                    lbstatus.Text = strFileName & " was uploaded successfully to: " & Server.MapPath(" estimages") & strFileName
 
                Case Else
                    'Not a valid jpeg image
                    lbstatus.Text = "Not a valid jpeg image"
            End Select
 
            InsertToDatabase()
        End If
 
 
    End Sub

End class

View 1 Replies View Related

'Image ' Datatype

Apr 5, 2007

Hi,I created a table with one column being that of an 'image' data type. The problem is I don't know  how to insert an image into that column. Pleas Help.

View 1 Replies View Related

Image In DB Tout.

Apr 11, 2007

Does anyone know how to put images in side of a Grid View Database, or know of a torturial.??Thanks

View 1 Replies View Related

Image Control And DB

Sep 15, 2007

I wanna know how to retrieve & insert an image from/to a Sql Server database.
using image control or any other control 
I’ve done that with windows form picture box.
As that was explained in MS tutorials  
Code….
-------------------------------------------Dim ms As New MemoryStreamPictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)Dim arrImage() As Byte = ms.GetBuffer
ms.Close()   Dim strSQL As String = _            "INSERT INTO Emp (EmpName,EmpSalary,Picture)" & _            "VALUES (@EmpName,@EmpSalary,@Picture)"  Dim cmd As New SqlCommand(strSQL, ConnEmp) With cmd     .Parameters.Add(New SqlParameter("@Picture", _      SqlDbType.Image)).Value = arrImage       .Parameters.Add(New SqlParameter("@EmpName", _       SqlDbType.NVarChar)).Value = txtEmpName.Text        .Parameters.Add(New SqlParameter("@EmpSalary", _        SqlDbType.Decimal)).Value = txtEmpSalary.Text   End With 
 cmd.ExecuteNonQuery()
------------------------------------------- 
But with a web form’s image control I DO NOT know how to do it    
I real appreciate your help 
Thank you
 

View 1 Replies View Related

Show More Then One Image

Dec 9, 2007

Hello!
I'm trying to show one large image and up to five small images. I can not get this to work. The five small images is in a repeater, the big picture is not in the repeater. I Think I just paste the code so you can look at it, i think that is better than me trying to explain moore:) I thougth I could use one of the events of the repeater and bind the large image when the page loads but I dont know what to use SqlDataSourceStatusEventArgs or what? I hope you all aunderstand whatI mean.<table style="background-color: #E4F9DF; margin: 10px 0px 0px 0px; border: 1px solid green;width: 545px; border-collapse: collapse;"><tr><td class="BoldText" colspan="2" style="border-bottom: 1px solid green; background-color: #b0eda2; text-align: center;">Bilder</td></tr><tr><td style="text-align:center"><asp:Image ID="Image1" Width="530px" runat="server" /></td></tr><tr><td> <asp:Repeater ID="Repeater1" OnItemCommand="imgBtnChangePic_Click" DataSourceID="sqlGetAdPics" runat="server"><ItemTemplate> The images will not appear, the shown like the path is wrong.<asp:ImageButton ID="ImageButton1" CommandName="changePic" ImageUrl='graphics/Advertise/<%#Eval("advertisePic")%>' CommandArgument='<%#Eval("advertisePic") %>' runat="server"/></ItemTemplate></asp:Repeater></td> </tr></table>
Here is the code behind
protected void Page_Load(object sender, EventArgs e){// this works, but I have to get the mage from the database...Image Image1 = (Image)DetailsView1.FindControl("Image1");Image1.ImageUrl = "graphics/Advertise/sadel2.jpg"; }protected void sqlGetAdDetails_Selected(object sender, SqlDataSourceStatusEventArgs e){if (e.Exception != null)lblError.Text = e.Exception.Message.ToString(); }protected void imgBtnChangePic_Click(object sender, RepeaterCommandEventArgs e){// This method is working.if (e.CommandName == "changePic" && Page.IsPostBack){Image Image1 = (Image)DetailsView1.FindControl("Image1");Image1.ImageUrl = "graphics/Advertise/" + e.CommandArgument.ToString();}}

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved