.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Uploading an image to a SQL DB via a SQLDataSource parameter

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :ASP.Net

Hi all,

I've got a bit of a problem that I can't figure out.  I've got a SQL data source on a create user page that uploads the user data to a SQL database when the person creating the account clicks the "Next" button.  One of the columns in the DB is an "image" data type and I'm using the FileUpload control to do that.  Here is the ds and its info on the actual page:

<asp:SqlDataSource ID="sqldsAddMember" runat="server" ConnectionString="<%$ ConnectionStrings:myCS %>" InsertCommand="INSERT INTO [Member] ([UserName], [MemberImage]) VALUES (@UName, @Photo)">
        <asp:Parameter Name="UName" ConvertEmptyStringToNull="true" />
        <asp:Parameter Name="Photo" DbType="Binary" ConvertEmptyStringToNull="true" />

In the code-behind I have the following (it's something I found elsewhere on the web):

    Protected Sub CreateUserWizardStep1_Deactivate(ByVal sender As Object, ByVal e As System.EventArgs) Handles CreateUserWizardStep1.Deactivate
        sqldsAddMember.InsertParameters("UName").DefaultValue = Session("UserName&

View Complete Post

More Related Resource Links

Capture posted image from Flash/swf for uploading

This is the first time I've come across this kind of problem before and I'm having trouble approaching it.  I have a swf developed by someone else that posts an image and I have to create a handler of some kind to capture it, name it, then upload it to a directory.  I've tried a couple ways and nothing is working.  this is a quick an dirty approach, just an aspx file<%@ Page Language="C#" %><%@ Import Namespace="Components" %><%@ Import Namespace="System.IO" %><script runat="server">    public partial class upload : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {            string uploadDirectory;            uploadDirectory = Server.MapPath(@"images/");            string imageName = "image.jpg";            string uploadPath = uploadDirectory + imageName;                        //FileUpload imageUpload =

SqlDataSource - Update Parameter with javascript

Hello, It's possible change the DefaultValue of Parameter with javascript?   Tks

Winnovative:Could not save image. Parameter is not valid.

while running website,the image get extracted from pdf document but still an exception named pdfimgextractexception appears at the end of an application.please give me the solution regarding this problem. code as follows: pdfImgExtractor.ExtractImages(srcPdfFile,true); which calls an eventhandler: pdfImgExtractor.ImageExtractedEvent += new ImageExtractedEventHandler(pcmd.pdfImgExtractor_ImageExtractedEvent); where the definition is: {   try { System.Drawing.     ographics = ographics.DrawImage(extractedBitmap, extractedBitmap.Dispose(); extractedBitmap = obitmap;     ographics.DrawString( ographics.Dispose(); ofont.Dispose(); oBrush.Dispose(); extractedBitmap.Save( extractedBitmap.Dispose(); }   {   }   Bitmap extractedBitmap = args.ExtractedBitmap;Graphics ographics;Bitmap obitmap = new Bitmap(extractedBitmap.Width, extractedBitmap.Height);Graphics.FromImage(obitmap);new Rectangle(0, 0, obitmap.Width, obitmap.Height), 0, 0, extractedBitmap.Width, extractedBitmap.Height, GraphicsUnit.Pixel);SolidBrush oBrush = new SolidBrush(Color.Black);Font ofont = new Font("Arial", 8);"Some text to write", ofont, oBrush, 10, 10);"D:\\example.jpeg", System.Drawing.Imaging.ImageFormat.Jpeg);catch (Exception err)HttpContext.Current.Response.Write(err.Message); } thanks in advance.

trying to show new image in ajax slidehow extender immediately after uploading it

 hi,   On my aspx page I have a slidshow extender.   In the code behind I am filling a data table from the datbase and using GetSlides() Method to show the images in the slideshow. The problem is I have a file upload control on the page as well. When I upload  a new file I am expecting it to show in the slideshow after postback but it does not. Only when I click refresh again or cause another postback the second time does the new image show.   My code behind    private static DataTable tblData = new DataTable(); protected void Page_Load(object sender, EventArgs e)         string strSQL = "(my select query is here";        SqlConnection conn = new SqlConnection("Data Source=(mydatasource here");        conn.Open();            SqlDataAdapter da = new SqlDataAdapter(comm);        tblData = new DataTable();        da.Fill(tblData);         conn.Close();           // set the initial image        if (tblData.Rows.Count > 0)        {    

Bulk Image Uploading


Dear all,

I want to Upload bulk images from client to server using web service...

I already create web service for uploading images but it does not support well.. i have used byte array for that..

If any idea then tell me..



Image Uploading Error in Hosted Application at WebServer


Hi All……!

I am Working on Web Application in my Application there is one Folder Named “RestaurantImages”

My Web Application is Hosted on My Local Server and also on WebServer.

When I Upload Images, It stored in “RestaurantImages” Folder.

When I Upload Images on Local Server Hosted Application Its Working Good, but

I have a Problem When I Upload Image in my Hosted Application on WebServer its not working and

Gives an Error Like Following………

Please Help me……………!

Thanks in Advanced……..!

deafault iamge dispaly when user not uploading the image


hi this is my code ...iam storing & retrieving image from db using gridview but now i got stuc..how to dispaly default imag ewhen user is not uploading the iamge...

here is my code...plaese help me ...

this is insert image to db......

  Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim arrcontent As Byte()
        Dim LEN As Integer
        Dim FN As String = String.Empty
        Dim EXT As String = String.Empty

        If Fu1.HasFile Then

            FN = Fu1.PostedFile.FileName
            Dim ityp = Fu1.PostedFile.ContentType
            Len = Convert.ToInt32(Fu1.PostedFile.InputStream.Length)
            EXT = FN.Substring(FN.LastIndexOf("."))
            EXT = EXT.ToLower()
            If EXT = ".jpg" Or EXT = ".bmp" Or EXT = ".gif" Or EXT = ".png" Or EXT = ".jpeg" Then
                ReDim arrcontent(Len)
                Fu1.PostedFile.InputStream.Read(arrcontent, 0, Len)
                If INSTAB(TB1.Text.Trim, arrcontent, Len, ityp) = True Then
                    L3.Text = "DATA ADDED SUCCECFULLY"
                    L3.Text = "ERROR IN INSERTING DATA"
                End If
                L1.Text = "Only gif,b

image extension changed after uploading



        I have a requirement  where image has to be uploaded  to a folder and show it in image control. When uploading the image i have resized the image through code and saved it in a folder. The code is as follow

Stream src = fuUpload.PostedFile.InputStream;
                        string dest = Server.MapPath("~/folder/" + filename);                        
                        System.Drawing.Image img = System.Drawing.Image.FromStream(src);

 Bitmap target = new Bitmap(width, height);
                        Graphics graphics = Graphics.FromImage(target);
                        graphics.SmoothingMode = SmoothingMode.HighQuality;
                        graphics.CompositingQuality = CompositingQuality.HighQuality;
                        graphics.InterpolationMode = InterpolationMode.High;
                        Rectangle rectDestination = new Rectangle(0, 0, width, height);
                        graphics.DrawImage(img, rectDestination, 0, 0, srcWidth, srcHeight, GraphicsUnit.Pixel);

Everything is alright upto here. But when i right click on image control and try to save the pic, the

How to delete an image after uploading


Dear friends

I apply a watermark to an uploaded image.

After that I want to save the changes, but I am not able to delete the original file nor can I rename it because I get the following error.

The process cannot access the file because it is being used by another process.

I have searched for a solution for 3 days but I haven't found any.


I have already disposed all objects related to the "watermarking process".

It seems that the uploaded file is being locked by IIS for a period of time while I need to manipulate & save the file right after uploading.

Could you please help?

uploading Image from client to server without using fileupload control



I have a requirement to read an image from client machine and to save the same in server, the path and filename of the image is fixed, i want to

done this task without using a fileupload control. Is there any way to accomplish this task?

Assign values to SqlDataSource Parameter from drop down list in InsertItemTemplate


Good Afternoon;

I have a Detailsview grid with an SqlDatasource, this DVG is only going to be used to insert records. The primary purpose of the DS is to populate a DDL control in the insertItem Template that I created my code is this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:testdbConnectionString %>"
            InsertCommand="INSERT INTO tblSelections(sTesterID, sTestDate) VALUES (@TesterID, @TestDate)"
        SelectCommand="SELECT tName, tExternalID FROM tblTesters">
                <asp:Parameter Name="TesterID" />
                <asp:Parameter Name="TestDate" />

The DDL control populates correctly, but when I try to modify the  INSERTCommand property in my DS, I try to assign the value to my parameters "TesterID" and "TesterDate" but the only options for controls to pick from, is the DGV but not the DDL in it. I assume it has to do with the InsertItem template but even if I reset it I still cannot pick

"Parameter is not valid" for tif image(JPEG cpmpressed)


I am agetting the "Parameter is not valid" message while converting the tif image (jpeg compressed) to the Bitmap

FileStream stream =new FileStream(strFilePath, FileMode.Open, FileAccess.Read); 
Bitmap bmp = (Bitmap)Bitmap.FromStream(stream); //here the exception occurs... 

System.Drawing.Image.FromStream() ArgumentException: Parameter not valid.


I am getting an ArgumentException: Parameter is not valid.

Does anyone know what's wrong with my code here?

        ImgService obj = new ImgService();

        byte[] data = obj.ShowImg(6);

        Int32 offset = 78;

        MemoryStream memStream = new MemoryStream();

        memStream.Write(data, offset, data.Length - offset);

        System.Drawing.Image img = System.Drawing.Image.FromStream(memStream);

        img.Save(Server.MapPath("image.jpg"), System.Drawing.Imaging.ImageFormat.Jpeg);


        Image1.ImageUrl = Server.MapPath("image.jpg");


        ImgService obj = new ImgService();

        byte[] data = obj.ShowImg(6);
        Int32 offset = 78;

Parameter is not valid exception on image.fromstream() method



      i have written a code for resizing the images and its working good except for some images that too the issue is occuring only on locolhost(IIS). I have asynchronous file upload contorl and two button  controls. when clicked on first button  the asynchronous file upload control is saved in session using the following code

Session["myupload"] = AsyncFileUpload1.PostedFile;

The image is resized and saved in a folder when second button clicked. The following code will execute when clicked the second button.

HttpPostedFile hif = (HttpPostedFile)Session["myupload"]                        
                        if (hif.ContentLength <= 20000000)
                            if (checkfiletype(hif.FileName))
                                string spacefileName = hif.FileName;                                
                                string storePath = Server.MapPath("~") + "/Docs";
                                //MemoryStream source = hif.InputStream;
                                Stream source = hif.InputStream;
                                //source =(MemoryStream)hif.InputStream;
                                byte[] input=new byte[hif.ContentLength

System.Drawing.Image.FromStream() get a Parameter is not valid


Anyone help fix Parameter is not valid errors , when i tried rename and save a file using fileupload to server

my code here :

if (fupImage.PostedFile.FileName != "")
                if (!Utitlties.Instance.CheckImageFileType(fupImage.PostedFile.FileName))
                    lblMessageForfupImage.Visible = true;
                    lblMessageForfupImage.Text = "Image file only accept *.jpg, *.png, *.bmp, *.gif Extensions !";
                    evt.ImageURL = Utils.Instance.SaveImage(fupImage.PostedFile.InputStream, fupImage.PostedFile.FileName, true);

anh here is methos SaveImage :


public string SaveImage(Stream stream, string filename, bool IsImageFile/*, bool CreateThumImage*/)
        string ImgUrl = string.Empty;
        string d = Utitlties.Instance.MakeFolderName();
        System.Drawing.Image img;
        string dirToSave = HttpContext.Current.Server.MapPath("Images/Uploads") + "/" + d + "/";
        string dir = "Images/Uploads/" + d + "/";
            if (IsImageFile == true)

Built-in Functions - Text and Image Functions in SQL Server

Text and image functions operate on TEXT, NTEXT and IMAGE data types. These data types are deprecated with SQL Server 2005 and should be replaced by VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) when possible. Alternatively you can also consider storing large string values using XML data type. Text and image functions are nondeterministic.

Future versions of SQL Server will not support TEXT, NTEXT and IMAGE data types. Columns with TEXT / NTEXT data type do not support commonly used string functions such as LEN, LEFT, RIGHT, etc. Furthermore, due to the large size of TEXT data you''re likely to see performance issues if you store such data in the database. However, at times you can''t help but use the TEXT / NTEXT / IMAGE data types (for example when supporting 3rd party databases when you cannot change the schema) - this is when text and image functions come in handy.

Web Service for uploading documents into SharePoint

WS UploadService is a web service written for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 and is meant for uploading documents into SharePoint. I have just uploaded the zip file to GotDotNet.com so it will take some time before the zip file appears in the list of downloads. For the time being, you can download the zip file from the following location
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend