I have a grid view that display a list of adverts that I have in the database. I was wondering if it is possible to delete an image from the database (the advet image) when I delete the row of a grid view.
When I delete the adverts how can I delete the image from the database too?
I am tring deleting the image in the gridview and in folder where it locate . My page in the update panel
write a funtion to delete in the delete button event , it not working in update panel when i comment the
update panel then it working properly.
I've been googling for 2 days for the solution, but I couldn't find something useful. The problem is that I have GridView that is connected to the SQL database and that is how it is being populated. I added EDIT and DELETE buttons in the columns, but as far as I can see the event which handles them is empty.
[Code]....
i have a database with several paths looking like the one below
C:S&M Site ProjectNEWSMAASitePhotos2GUY093GUY093-Tulips.jpg..
What i aim to do is load the images into a gallery control (if one exist)the users viewing the images should be able to do either of the following:
-Double click on an image to see it bigger or some large predefined size.(thats the viewing part of it)
-Select those images the want and then extract it as a single PDF file to any location on the user machine.
-print all selected images.
-Remove all selected images from the gallery as well as the image path from the database.
I know this might sound like a simple quesiton, but I am having problems allowing me to upload images along with other information (name, image, biography, wbsite links) to a sql server database, as well as showing images from the database using a drop list control feature. I am using [URL] for hosintg. VB language.
View 2 Replieshow to retrieve database image to the image control?
in the database, i have a column in database that store the url for the images. and how am i going to retrieve it to the form?
[Code]....
the "dtrSelect["Food_Pic].ToString()" is the url for the image.
how can i store image into database and view it in grid view?
View 3 RepliesI am attaching an image to a listview from code behind, the image depends on a value from the database and there are 5 different images.It sometimes works fine and then will randomly come up with an error, when nothing has changed, the error is:[Code]....
It doesn't seem to make sense to me because ImageUrl IS a member of image. Here is my code:
[Code]....
And code behind: [Code]....
Deleting image from directory?
View 3 RepliesI have div In my page that in this div I put image control
<div id="DLogos">
<asp:Image ID="imglogo" runat="server" CssClass="ILogos" /> </div>
according to below code
<div id="Dart1_I1" visible='<%# !string.IsNullOrEmpty(Eval("image1").ToString())%>'>
If in database was image it show div and if there wasn't any image it didn't show div but above code is for div that I put in datalistnow I want do some thing like that for Div that I don't put it in datalist I should write code for that in behindecode page but I don't know How I can do it?behind code
SqlCommand _cmd = new SqlCommand("storeinfo1", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@behcode", data);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
[code]....
I have to insert default image into databse..when no image is selected from fileupload control.. Here is code...not working for default image...
if (FileUpload1.HasFile){string FileName = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(Server.MapPath("~/UPLOADEDFILES/" + FileName));
feedBack.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileName));
} else {
string filename="~/images/"+ "sun.gif";filename.pPropertyImage = filename;FileUpload1.SaveAs(MapPath(filename));}
<asp:ImageField DataImageUrlField="photo" > <ItemStyle Width="50px" Height ="50px"
HorizontalAlign="Center" VerticalAlign="Middle" ></ItemStyle>
</asp:ImageField>
i need to display image from database in gridview. i have the above html and a select query executed from code behind which displays the image.
i am storing the image path in the database table and image in a folder.
Queries related to above
1. image size not able to set
2. the gridview image column will display image if the column data is not blank. but if its blank i have 2 default images male image and female image
so if the field is blank i need to display one of the default images depending on the gender selected
3. if the image is clicked it should show enlarged image as popup
How to show defalut image in datalist untill large image fully loaded in same datalist ?
View 1 RepliesI Have a Image Tags In My Web Application. I Upload The Image Path and stored In Database. How To Retrieve the Image Path Into Images Tags Using Database in Asp.Net..
View 1 Replieshow to display images in my page from SQL database.
View 1 RepliesI have been able to save an image in the database but i can not preview it
View 4 RepliesHow do I view rows in a table and then be able to update the image stored on the database for that specifc row?
View 1 RepliesMy database table contains the image file path which will be stored from a file upload control.The image path in the table will be like "C:ProjectsprojectnameprojectfolderFiles1_129308367798080000_images1.jpg"
I am trying to display that image through a datalist control as follows
<asp:DataList ID="cobrandlogolist" runat="server">
<ItemTemplate>
<asp:Image id="CobrandLogo" ImageUrl='<%# DataBinder.Eval(Container.DataItem, "CobrandLogo") %>' Height="100px" Width="100px"
runat="server"/>
</ItemTemplate>
</asp:DataList>
and i am retrieving the image names from the db and assigning as datasource of this datalist in the load event as follows
DataTable dt = new DataTable();
DataRow dr = dt.NewRow();
dt.Columns.Add(new DataColumn("CobrandLogo", typeof(String)));
dr["CobrandLogo"] = m_Organization.CobrandLogo;
dt.Rows.Add(dr);
cobrandlogolist.DataSource = dt;
cobrandlogolist.DataBind();
But it is not displaying the image in the form.
How to Retrieve image from database into gridview
View 1 Replieshow to show image in gridview from sql database
View 2 RepliesI need to resize a photo selected by a user with a fileUpload control and upload to a database. What i can just do now is upload the image to a database table. Imjust trying to find out how to code the image resizing part and when i say resize, i mean the dimensions and file size.
This is my current code to upload to the database
[Code]....
Maybe I'm looking for an easy way that just isn't there, but I'm trying to display the images I store in my SQL database in a GridView, and I just can't seem to get it right. I've readlots of different articles on the web about it (including this one from this forum), but most (if not all) of the examples I've read look like their doing a "double hit" to the database (that is, one stored procedure call to get the entire record, and a second one in the Handler to get just the image of the record).
[Code]....
I have 1 image & 1 label in page
I bind lable from database that show my users website address i want if user insert their website address in database and it show in lable image1.visible=true
and if in website column users don't insert any data image1.visible=false
I am uploading images to database....but only error that I am getting at this point when I run it is for.....
DataSource.InsertParameters.Add("MIMEType", MIMEType)
The error for the above line is Object not set to an instance of an Object look over the code an see if you can see what is wrong.
Protected Sub Button_Insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button_Insert.Click
'Make Sure a file has been successfully Uploaded
If FileUpload_Image1.PostedFile Is Nothing OrElse String.IsNullOrEmpty(FileUpload_Image1.PostedFile.FileName) OrElse FileUpload_Image1.PostedFile.InputStream Is Nothing Then
Label_ErrorMessage.Text = "Error"
Else
Label_ErrorMessage.Text = "No Error"
'Exit Sub
End If
'Make sure we are dealing with a JPG or GIF file
Dim extension As String = Path.GetExtension(FileUpload_Image1.PostedFile.FileName).ToLower()
Dim MIMEType As String = Nothing
Select Case extension
Case ".gif"
MIMEType = "Image/gif"
Case ".jpeg", ".jpe"
MIMEType = "Image/jpeg"
Case ".png"
MIMEType = "Image/png"
Case Else
Label_ErrorMessage.Text = "Invalid Type"
'Exit Sub
End Select
Dim DataSource As New SqlDataSource()
DataSource.ConnectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ToString
DataSource.InsertCommandType = SqlDataSourceCommandType.Text
DataSource.InsertCommand = "Insert Into ClassifiedImages (Title, DateUploaded, MIMEType, ClassifiedId) Values (@Title, @DateUploaded, @MIMEType, @ClassifiedId)"
DataSource.InsertParameters.Add("Title", "Images For Classified Ad" & " " & Request.QueryString("ClassifiedId"))
DataSource.InsertParameters.Add("DateUploaded", DateTime.Now)
DataSource.InsertParameters.Add("MIMEType", MIMEType)
DataSource.InsertParameters.Add("ClassifiedId", Request.QueryString("ClassifiedId"))
Dim ImageBytes(FileUpload_Image1.PostedFile.InputStream.Length) As Byte
FileUpload_Image1.PostedFile.InputStream.Read(ImageBytes, 0, ImageBytes.Length)
DataSource.InsertParameters.Add("ImageData", ImageBytes.ToString)
Dim RowsAffected As Integer = 0
Try
RowsAffected = DataSource.Insert()
Catch ex As Exception
Response.Redirect("AddImagesProblem.aspx")
End Try
If RowsAffected <> 1 Then
Response.Redirect("AddImagesProblem.aspx")
Else
Response.Redirect("AddImagesSuccess.aspx")
End If
End Sub
I have a database, one field is named "clicked" with values 0 or 1.
When the gridview is displayed I would like to show the value from the field "clicked" to be displayed as an image (example: instead of 0 to display and for 1 to display)
Is it possible?
