if a person does not select image in website in database null value go. when we retrieve data for that person i want if image is null then i want to show blank face image. for storing and retrieve image im using handler.ashx but not able to do the part that i have explained .
View 7 RepliesI am working on a website, using C# with a SQL backend. I'm using the Varbinary data type to store my images because the Image data type is eventually going away. I got the images into the DB and can pull them back out to display on the website. My question is how can I put the images from the DB into an Image control on the website? The images will be different sizes, so I need to keep them confined in one space on the site. I also need to randomly display the images, one at a time, on the website. The user needs to be able to hit the Next button to see the next image when they are ready. The user will only view the images, not make any changes and send data back to the DB.
Since the image will be confined within the image control, how can I allow the user to click on the image and open in a new window? The image needs to be bigger to allow the user to see more detail. Or would it be easier to allow the user to zoom in on the image within the current window?I am using VWD Express, C# 2010 Express & SQL 2005 Express.
I have some textbox and Dropdownlist in my page and bind it from database
BindDropDownList(DDL3, "Guidcenter", "Centername","id");
DDL3.Items.Insert(0, new ListItem(" please select ", "0"));
I have button in my page that when user click on it insert data into database
Here when users didn't select Item from dropdownlist it insert "please select" ( text that I define for DDL ) into database but I want when users didn't select Item from database it insert NULL in database....
protected void ImageButton2_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code] ......
I send newsletter to all the members of my website, usually i just create simple newsletter with text and hyperlinks
So my times i tried adding images to it but whenever i add images in the newsletter e-mail, the users who are using different mailboxes, either my mail goes in their SPAM folder or if my mail goes in their INBOX then image doesn't show up, it shows a blank space
what's the issue ? what's causing the issue ? code ? or Exchange server on which my website mailbox is for sending e-mail ?
How to solve this issue ?
Almost everyday we recieve newsletters from many websites/companies (there newsletter includes images, colors full templates etc) and still we receive in our inbox and all the images are visible. how ?
URL.... When I wrote this code in other page with different SP It didn't worked correctly I change SP in new SP I used INSERT code instead of UPDATE now when users didn't select Item from ddl3 it insert 'please select' in table these are my code
protected void ImageButton2_Click1(object sender, ImageClickEventArgs e) {
SqlCommand _cmd = new SqlCommand("insertSreg", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[code]....
I am unsure on how to perform this task, what i need to do is make a gallery with tagging. I need this as it is a requirement for the project. Each user will have there own gallery and be able to upload and delete images from there gallery. I already know how to insert and select images from a database. I will then display the gallery using a data repeator with paging, I am sure i can google an article for data repeator with paging.
My challenge is, when the user wants to save a image to there gallery, he must 1st upload the image and then i must some how display the image, when the image is displayed, i will have a text box where they can add tags, this textbox will save in the tag table for that user_id, picture_id and the tag will have an id also. I am unsure on how to do this When he clicks save, i wanna insert the image into the table, and the tag. If he does not click save, then nothing should be saved. Now the 2nd part.
In the data repeator, i want a modal window to popup when they click an image, this modal will have the image and the respective tags that where saved for this image, I am unsure how to this.
here is my code which is working fine to read batabase image from database but if there is NULL value in database so how can i read physical path noimage.jpg
[Code]....
I hv a master page with image field which displays the profile pic of the user. now i want to display this image to the image field on the master page as and when the user logs in (like in fb) i hv used http handler to display the image from db. i m able to imsert and display image from db.but how can i write a select query to display the users image.i m using sql server 2008 and asp.net vb
View 1 Replies I want to achive on functionallity like below.
I want to Dispaly image after image selection.so Users can see image at that moment.
I have a database with images in it and now I want to randomly select an image from the database and view it on the aspx page.I know how to read images from a database depending on the id.Database I am using MS Sql and c# programming.
View 4 RepliesI want to read from database where I've stored a image in binary field and display a image.
while (reader.Read())
{
byte[] imgarr = (byte[])reader["file"];
Stream s = new MemoryStream(imgarr);
System.Drawing.Image image = System.Drawing.Image.FromStream(s);
Graphics g = Graphics.FromImage(image);
g.DrawImage(image, new Point(400, 10));
image.Save(Response.OutputStream, ImageFormat.Jpeg);
g.Dispose();
image.Dispose();
}
con.Close();
This piece of code doesn't work:
System.Drawing.Image image = System.Drawing.Image.FromStream(s);
I tried the code from this article. And I got the same mistake " the parameter is not valid ". Maybe I'm not aware of something, some setting in sql server or webconfig or sth else. Anyone else who has experience from fetching images from database? The parameter is not valid is the error message. db table contains data. What am I doing wrong?
I have setup my business object to have a create_date and edit_date members both datetime datatypes. My company want to display the create_date and edit_date fields in a gridview for each transaction. The problem i have is that after insterting a record it will have a valid create_date but no edit_date and when displayed in the gridview it defaults to datetime.minvalue (My default). How on earth do i show an empty field in my gridview for a null datetime field in the database?
I am using similar architecture to the Imar Spaanjaars example of a tiered solution. With a few small tweeks it has worked well for me for ages. I am passing a List<Database> to my object datasource which connects to my gridview.
I'm no expert with Image controls, or dynamically adding anything, but I seem to have some problem when dynamically adding image controls
When the page loads the images are "there", but they don't actually show an image...just an image "box" I guess you could call it. It's not the "broken" image or "invalid" image display, but a friendlier one that doesn't make sense to me why it's there.
I look at the page's source and literally everything's fine, but I'm not sure what's going wrong. I can show you my code, and hopefully someone will point out the dumb thing I'm doing wrong:
[Code]....
[Code]....
So, it takes all the .JPG files in the folder "Pictures" of my project's folder and creates an Image control to be put into Panel1 with the ImageURL as its filename (with Directory Path) and even set the ID to its filename (so no duplicate IDs). Again, the source is exactly how it should be, but no image is shown.
I have an sproc which selects data out of my table. The column can return integer or NULLs.
I get the 'failed to enable constraints error' when databinding. If I go to my tableadapter and select my column there is a NullValue property which has 'Throw Exception, Null, Empty'. If I try and unset the exception option it tells me only strings are allowed this. However the 'AllowDBNull' option is set to TRUE.
What is the alternative and will this be fixed in 2010?
i am developing a small website where on one page user selects an image [selected image id is passed to another page] and on the next page logo is selected which is passed onto next page [selected logoid is passed]..now in third web-page actual watermark happens where user can select the postion where watermarking is needed to do ...
the problem is the third webpage...here i know the imageid and logoid..but dont know how to select imagecontent and logocontent using both the ids....because as per my knowledge i think using sql-query i can select columns of only one table...
If the datavalue which is empty and not exist in the dropdownlist data source, it will prompt error. How to overcome??I want it will show 'Select Country' when data value is empty or is null.
<asp:DropDownList ID = "ddllabelCountry"
DataSourceID="objCountry"
DataTextField="CountryName"
DataValueField="CountryCode"
EnableViewState="true"
[code]...
I'm currently developing a web application where everything works fine in the visual studio web server. It authenticates the user, access the database, writes to it, etc.
After I wrestled yesterday to publish it to my local iis, a subject I admit I have little to no experience of doing, suddenly the membership of the website started to not authenticate the users.
At first I suspected maybe the app wasn't accessing SQLServer, or that the data with the users I had in the asp.net membership database was erased when I uploaded the website.
So I stopped iis, i attached the db file to my local sql server, and I can see that all the users are there just like I uploaded them. I also can see the website can access another database with micellaneous contents just fine.
The loging controls don't tell me there's any problem either, they just show a message telling the user that the login attempt wasn't successful.
So, here's what I remember I did to make the app work as it wasn't even doing that when I first uploaded it.
I used the asp.net_regiis tool to copy website scripts to the website.
aspnet_regiis -sn <path>
then I deleted the website, uploaded again from VS. this time it shows in the browser but it doesn't authenticate the users.
The application isn't precompiled, I just uploaded it.
Ive got an ASP:Menu in my page and want to display a background image for each item, and have that background change when the user hovers over, or selects it.
However, the UnselectedTab style applies when the page loads but then the style doesnt change on either select or hover, ...
Code in my asp.net page...
[code]...
I have a problem with an asp.net project.I have a default.aspx page with a webusercontrol ascx inside.I have one combobox in my default.aspx and another combobox inside usercontrol.If I fire up my simple application, I noticed that when I select an item in one of the comboboxes, the selectionindexchaged event doesn't fire and le dropdown doesn't close.I have AutoPostBack="True" an all combo.
View 3 Replies I have store procedure and I want to when I execute this procedure , Select field list in my gridview. But store procedure dont show every field(it doesnt show relation table.?)
This is my Store Procedure
ALTER PROCEDURE [dbo].[rps_CarePlan3]
@PatientName nvarchar = NULL,
@PatientTypeId int = NULL,
@StartDate datetime = NULL,
@EndDate datetime = NULL,
[Code]....
I see only BakimDestekDto(cause it is part of TblBakimDestek but other field isnt part of TblBakimDestek it is relation field). Why dont I see relation table field? Maybe public IList<TblBakimDestek> GetByStoreProcedure(string startDate) I use inside IList TblBakimDestek?
using vb.net/asp.net 2005
I've been tasked with creating a page where the user can do the following in this order:
1. browse to and select a jpg image
2. preview the image that the user just selected
3. if the user is happy with the preview then click the GO button to load the image to the Image folder.Does anyone have any good examples or sample code of how to do this?
I have the below stored procedure witch has an error I cann't figure out.
What I want: Gets rankOrder. If rankOrder doesn't have a value (= null) the @num should be insertet as 1 as value. If there is a row and a rankOrder is should set the @num to insert the value + 1. The last one works perfect. But when the row I select is emty = null value the value is set to null in the insert command.
Stored procecure:
[Code]....
how can insert null value in image column.i using sql server 2005 and in my database i have column image and datafield id image.when i browse a image and insert it then it is working but when i insert it without image then it is not saved.an error ocure-Operand type clash: nvarchar is incompatible with image.
I INSERT LIKE
[Code]....
image control doesn't seem to load image? Path name is set in db to a picture on my desktop.
OdbcCommand cmd = new OdbcCommand("SELECT User.FirstName, User.SecondName, User.Aboutme, User.DOB, Pictures.picturepath FROM User LEFT JOIN Pictures ON User.UserID = Pictures.UserID WHERE User.UserID=1", cn);
OdbcDataReader reader = cmd.ExecuteReader();
[Code].....
My designer.cs file of all the SQL tables is generated by LINQ-TO-SQL. The class and attribute in question is like this.
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Transfers")]
public
partial
class
Transfer :INotifyPropertyChanging,[code]...
I need to assign a null to the attribute so that the value 0 does not get save to the database.