Upload multiple images using asp.net?

Question

0.00/5 (No votes)

See more:

Dear All,
Upload multiple images using asp.net

Here uploading with images working properly but select one image not working please reply me any another way or examples.

C#

protected void btnPostAd_Click(object sender, EventArgs e)
    {
        if (ddlCategoryType.SelectedItem.Text != "--Select--")
        {
            if (FileUpload1.PostedFile.ContentLength != 0 && FileUpload2.PostedFile.ContentLength != 0)
            {
                string strimage = @"~\ProductImage\" + FileUpload1.FileName;
                string strimage2 = @"~\ProductImage\" + FileUpload2.FileName;
                FileUpload1.PostedFile.SaveAs(Server.MapPath(strimage));
                FileUpload2.PostedFile.SaveAs(Server.MapPath(strimage2));
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                String strInsert = "insert into ProductDetailsTable1(CategoriesType,Title,Description,State,City,ContactPhoto,ContactSPhoto,Price,ContactName,ContactEmail,ContactMobile) values('" + ddllist.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + strimage + "','" + strimage2 + "','" + txtPrice.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text + "',)";
                SqlCommand cmd = new SqlCommand(strInsert, con);
                try
                {
                    con.Open();
                    cmd.ExecuteNonQuery();
                    
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Posted Successfully')", true);
                    
                }
                catch (SqlException ex)
                {
                    string errorMessage = "Error in entering competition";
                    errorMessage += ex.Message;
                    throw new Exception(errorMessage);
                }
                finally
                {
                    con.Close();
                }
                Clear();
            }
            else
            {
                    string strimage = "NoImage.jpg";
                    string strimage2 = "NoImage.jpg";
                    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                    String strInsert = "insert into ProductDetailsTable1(CategoriesType,Title,Description,State,City,ContactPhoto,ContactSPhoto,Price,ContactName,ContactEmail,ContactMobile) values('" + ddllist.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + strimage + "','" + strimage2 + "','" + txtPrice.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text + "')";
                    SqlCommand cmd = new SqlCommand(strInsert, con);
                    try
                    {
                        con.Open();
                        cmd.ExecuteNonQuery();
                        
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Posted Successfully')", true);
                        
                    }
                    catch (SqlException ex)
                    {
                        string errorMessage = "Error in entering competition";
                        errorMessage += ex.Message;
                        throw new Exception(errorMessage);
                    }
                    finally
                    {
                        con.Close();
                    }
                    Clear();
                }
        }
        else
        {
            ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Select CategoryType')", true);
        }
    }}

Posted 15-Sep-14 1:52am

member1431

Updated 16-Sep-14 6:05am

Afzaal Ahmad Zeeshan

v4

Add a Solution

Comments

[no name] 15-Sep-14 7:55am

Learn how to use the debugger and you will see what the problem is. And you should do some research on SQL injection attacks and why your query is bad.

Suvabrata Roy 15-Sep-14 7:59am

Yes Wes, and also on coding stander

member1431 15-Sep-14 8:01am

Dear Adey,
here in database fields given contactphoto and contactsphoto

and here storing sepearetely, with images working properly but with one image and without image not storing

here sql query working fine please check and reply me please Adey

member1431 15-Sep-14 8:04am

any examples reply me

@p@richit 15-Sep-14 8:00am

keep in mind that adding the argument directly in the query is a bad practice and makes code vulnarable to attacks (SQL injections for example)

aarif moh shaikh 16-Sep-14 2:58am

First of All... Its a bad Practice code... you have to use Parameterized query to avoid SQL injection Problems..

and about your problem
use two separate if statement to done your code

member1431 16-Sep-14 3:09am

Dear aarif,
am already tried like that but output not coming properly please modify and reply above code please am waiting this reply please try to understand my problem please

member1431 16-Sep-14 4:48am

Dear aarif moh shaikh,
please reply me

aarif moh shaikh 16-Sep-14 8:56am

Look Solution 2 ...

member1431 17-Sep-14 0:57am

Dear aarif,
thanks for your reply thank you so much

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

@p@richit · Answer 1 · 2014-09-15T02:06:00

try this

HttpFileCollection hfc = Request.Files;
 for (int i = 0; i < hfc.Count; i++)
       {
           HttpPostedFile hpf = hfc[i];
           if (hpf.ContentLength > 0)
           {
               string FileName = hpf.FileName;
                   hpf.SaveAs(SavePath + "\\" + Path.GetFileName(FileName));

           }
           }

HttpFileCollection Provides access to and organizes files uploaded by a client.

aarif moh shaikh · Answer 2 · 2014-09-16T02:57:00

Just Copy & Paste This code on Your Page .. Defiantly it will Run

C#

if (ddlCategoryType.SelectedItem.Text != "--Select--")
        {
            string strimage2 = "NoImage.jpg";
            string strimage = "NoImage.jpg";
            if (FileUpload1.PostedFile.ContentLength != 0)
            {
                strimage= @"~\ProductImage\" + FileUpload1.FileName;
                FileUpload1.PostedFile.SaveAs(Server.MapPath(strimage));
            }
            if (FileUpload2.PostedFile.ContentLength != 0 ) 
            {
                strimage2 = @"~\ProductImage\" + FileUpload2.FileName;
                FileUpload1.PostedFile.SaveAs(Server.MapPath(strimage2));

            }
            if(FileUpload1.HasFile || FileUpload2.HasFile)
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                String strInsert = "insert into ProductDetailsTable1(CategoriesType,Title,Description,State,City,ContactPhoto,ContactSPhoto,Price,ContactName,ContactEmail,ContactMobile) values('" + ddllist.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + strimage + "','" + strimage2 + "','" + txtPrice.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text + "',)";
                SqlCommand cmd = new SqlCommand(strInsert, con);
                try
                {
                    con.Open();
                    cmd.ExecuteNonQuery();

                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Posted Successfully')", true);

                }
                catch (SqlException ex)
                {
                    string errorMessage = "Error in entering competition";
                    errorMessage += ex.Message;
                    throw new Exception(errorMessage);
                }
                finally
                {
                    con.Close();
                }
                
            }
            else
            {
                 
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                String strInsert = "insert into ProductDetailsTable1(CategoriesType,Title,Description,State,City,ContactPhoto,ContactSPhoto,Price,ContactName,ContactEmail,ContactMobile) values('" + ddllist.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + strimage + "','" + strimage2 + "','" + txtPrice.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text + "')";
                SqlCommand cmd = new SqlCommand(strInsert, con);
                try
                {
                    con.Open();
                    cmd.ExecuteNonQuery();

                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Posted Successfully')", true);

                }
                catch (SqlException ex)
                {
                    string errorMessage = "Error in entering competition";
                    errorMessage += ex.Message;
                    throw new Exception(errorMessage);
                }
                finally
                {
                    con.Close();
                }
            }
        }
        else
        {
            ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Select CategoryType')", true);
        }

Upload multiple images using asp.net?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Upload multiple images using asp.net?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us