i have sql-server-2008 database that contain image field that hold picture.
i have pictureBox control in my webform.
how to put picture from database to pictureBox control ?
(I work with C# asp.net FW3.5)
can i get any sample code or program ?
how to put picture from dtatabase to pictureBox in asp.net ?
View 2 RepliesI want to crop a picture in a picturebox by allowing the user to selecta rectangular region like you get in software like Photoshop.
Or User Will select a region in pircture box and then region will be saved as a individual picture.
Is it possible using C#.
i'm new to c# and i wanted to know how can i allow user to upload a picture from a text box and a button??
after uploading the picture, how can i save the picture in the database??
**note**the picture i allow user to upload need to be in a fixed size.
I am inserting a picture into a database, using the following code.
strFileType = Path.GetExtension(filImage.PostedFile.FileName).ToLower();
switch (strFileType)
{
case ".gif":
strMimeType = "image/gif";
break;
case ".jpg":
case ".jpeg":
case ".jpe":
strMimeType = "image/jpeg";
break;
case ".png":
strMimeType = "image/png";
break;
}
//Store the content length
int iDocLength = filImage.PostedFile.ContentLength;
byte[] bDocBuffer = new byte[iDocLength];
//Get stream object
Stream streamImage;
streamImage = filImage.PostedFile.InputStream;
streamImage.Read(bDocBuffer, 0, iDocLength);
cmPerson.CommandText = "INSERT INTO photos VALUES(@referenceid, @image, @imgtype)";
cmPatient.Parameters.AddWithValue("@referenceid", iPersonID.ToString("000000"));
cmPerson.Parameters.AddWithValue("@image", bDocBuffer);
cmPerson.Parameters.AddWithValue("@imgtype", strMimeType);
cmPerson.ExecuteNonQuery();
If in case that the user, did not browser for a picture, then, I have to use the nopho.jpg that is stored in the images/folder of my web app. How am I be able to do this?
I have this code to insert a picture from database into an ImageControl on my ASP.NET form:
strConnString = "server=" + Server + ";database=" + DataBase + ";UID=" + UID + ";password=" + PASS + ";";SqlConnection MyConnection = new SqlConnection(strConnString);SqlCommand MyCommand = new SqlCommand("SELECT Pic FROM MEN WHERE ID=5", MyConnection);MyConnection.Open();SqlDataReader MyReader = MyCommand.ExecuteReader();if (MyReader.Read()){ byte[] m_MyImage = (byte[])MyReader["Pic"]; Response.BinaryWrite(m_MyImage);}
And I have this ImageControl on the form:
<asp:Image Width="88" Height="100" Runat="server" ID="m_Image" NAME="m_Image" />
but when I run the code, I see the picture big on the screen and not in my ImageControl.
i also put this in the form_load:
m_Image.ImageUrl = "MyPhoneBook.aspx?m_Image";my control is: m_Imagemy control ID is: m_Imagemy namespace is MyPhoneBook
but still dont work
I have a webform with 2 Textbox (ID & Name), 2 grouped radio button (Male-female), and a Picturebox (Photo).
I need to display/Load Details into the given controls from the ID number. I am using VS2008 SP1, C# and MS SQL.
I am uploading member's picture into my database. However, there are instances that the member will not upload its photo. In this case, I'd like to upload instead a picture that is stored in my web app's folder. How am I going to get the picture and store it in my database.
View 4 RepliesI have a SQL Server 2008 database that has image field which contains a picture.
I have a gridview in my ASP.NET web program, and I need to show the picture in:
my gridview
my image control that I have in the form
Can I get any sample code ?
I have a Report a Bug page added to a small site; I have a text box where a user can type a text that will be submitted to a table in my db; how do I implement the upload of a picture, let's say a screen capture? the most convenient way (for the user) would be to be able to press the Print Scrn button and then paste it to my text box ... well, I'm sure this won't work ...
View 2 RepliesI have a picture that i would like to upload to a database. I am really new to this so i am not sure what to do. I have been using the following code below to upload and retrieve the picture, looks like its uploading ok, but i cant retrieve it. The code i am using comes from this site,
http://www.dotnetcurry.com/%28X%281%29S%28e2mwozemizhla24555f41uzz%29%29/ShowArticle.aspx?ID=129&AspxAutoDetectCookieSupport=1.
Uploading Content to database
try
{
if (cmboTopic.Text == "Blu-Ray Movie")[code].....
i use visual studio 2010 i have stored image into sql server in binary format and how to retrive that image(which is in binary format) and display in image contro
View 1 RepliesI want to add picture to my SQL database using file Upload control but I don't know which attribute should I use also I don't know how to add it in the stored procedure,
View 3 Replieswhen i click the picture that is displayed in the detailsView ImageField, the jquery lightbox pops up, but does not show the picture. it shows a red x in the middle of the lightbox. the same thing happens with the asp:Image control shown in the code below. The picture is stored in a SQL database Image datatype. Using master pages.
[code]....
i have sql-server-2008 database that contain image field that hold picture.
i have pictureBox control in my webform.
how to put picture from database to pictureBox control ?
(i work with C# asp.net FW3.5)
can i get any sample code or program ?
how to show picture in grid view from sql server database
View 4 RepliesI obtained the facebook profile details of an user.Now I need to store the profile details including profile picture in my local database.
View 1 Replieswhen i click the picture that is displayed in the detailsView ImageField, the jquery lightbox pops up, but does not show the picture. it shows a red x in the middle of the lightbox. the same thing happens with the asp:Image control shown in the code below. The picture is stored in a SQL database Image datatype. Using master pages.
[Code]....
[Code]....
[Code]....
I ve an application dat am working on. The section of the upload picture works perfectly on the development environment and also on a test server but the issue comes up when it was hosted life. I started geting an error dat says picture could not be attached. I ve a folder cald Passport and dis ve been working for me on befor now but i dont now the reason y its not working now.
protected void btnUpload_Click1(object sender, EventArgs e)
{
Boolean fileOK = false;
String fileExtension = string.Empty;
String path = Server.MapPath("~/Passport/");
if (fuPassport.HasFile)
{
fileExtension = System.IO.Path.GetExtension(fuPassport.FileName).ToLower();
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
if (allowedExtensions.Contains(fileExtension))
{
fileOK = true;
}
}
else
{
Utilities.PortalMessage = "Please attach an image file.";
return;
}
if (fileOK)
{
try
{..............................
when i click the picture that is displayed in the detailsView ImageField, the jquery lightbox pops up, but does not show the picture. it shows a red x in the middle of the lightbox. the same thing happens with the asp:Image control shown in the code below. The picture is stored in a SQL database Image datatype. Using master pages.
[Code]....
[Code]....
[Code]....
In order to avoid having to pass Data that goes in the master page of my site before every view in every controller I have created an ApplicationController that sets the data on its constructor... the problem with this approach is that one of the viewdatas I must pass is the url of the profile Image of the current logged in user.
[Authorize(Roles = "Administrator")]
public abstract class AdministratorController : Controller
{
private IPortalAdministratorServices _servicioPortalAdministrator;
public AdministratorController()
{
_servicioPortalAdministrator = new PortalAdministratorServices();
ViewData["associates"] = _servicioPortalAdministrator.getAssociates();
ViewData["picture"] = _servicioPortalAdministrator.GetPic();
public AdministratorController(IPortalAdministratorServices service)
{
_servicioPortalAdministrator = service;
}
}
and so my companies Controllers wich inherits from AdministratorController now doesnt have to set all that Data upon every View Call.
[Authorize(Roles = "Administrator")]
public class CompaniesController : AdministratorController
{
private ICompaniasServices _service;
public CompaniesController()
{
_service = new CompaniasServices(new ModelStateWrapper(this.ModelState));
}
public CompaniesController(ICompaniasServices service)
{
_service = service;
}
The problem is this: When I try to manually access the Companies Controller without actually being logged in the method GetPic() wont actually be able to get the picture url cause no one is logged in.. and these method is getting called in spite of the Authorize attribute....so now, even after being logged in the ViewData for the picture url has been permanently set to "unknown.png" Some of this code isnt mine.. I just discovered the bug but cant figure out how to fix it.
i add Image control to my WebForm.i insert picture to App_Data.i connect the picture to my Image control in the ImageUrlit seen like this:
<asp:Image ID="Image1" runat="server" Height="94px"
ImageUrl="~/App_Data/Tulips.jpg" Width="209px" />
in the design i see this picture, but when i run the project i dont see the picture.
i'm trying to build a picture of the day in c#
string m1 ;
Image1.ImageUrl = "~/PictureOfTheWeekImages/+"m1"+.jpg";
and i want to insert the name of the file as a variable that changes with the date ...
my way not working .... i'm sure it somthing like this,
and i'm not sure how to write the url right ..
I am unable to get the background picture to show in my pages. I am trying to do this in the master page using CSS.I have a CSS which contains the following:
body {
background-image: url(../images/background.jpg) no-repeat;
background-attachment: fixed;
margin-top: 0px;
}
I know the CSS is being read because all other styles defined in it are working on the .aspx pages... except of course the background image, the background remains white. (This works perfectly fine in .php pages by the way.)I have been searching online like crazy and all the answers I find, say the above CSS code is the answer... but it is not working!I am using the following:
Microsoft Visual Studio 2008 Version 9.0.30729.1 SP
Microsoft .NET Framework Version 3.5 SP 1
Firefox Version 3.6.6
In one page I have image controls that are showing pics from the web site. This works fine but sometimes, and randomly some pics are not shown. I guess this issue could happen because Im using the IIS 5.1 in my development enviroment and it could be denying some requests. Anyway, I dont know exactly what is happening, so i request help of those who have workaround this fixture.
View 1 Replies