Asp.net with c# sqlserver2005 local host image not store

Question

1.00/5 (1 vote)

See more:

I'm designing my web page i want store image location and then customer record i am doing photo studio management studio system image location not store...

namespace photoshops
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            onflbload(sender, e);
        }
        public void onflbload(object sender, EventArgs e)
        {
            string filename = Server.MapPath("~/photo") + FileUpload.PostedFile.FileName;
            FileUpload.PostedFile.SaveAs(filename);
            SqlConnection connection = new SqlConnection();
            connection.ConnectionString =@"Data Source=DEVI\SQLEXPRESS; Initial Catalog =cat; Integrated Security=SSPI";
               
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand("insert into tblphotosettings "
                 + "(BillNo,CustomerName,Address,StartDate,EndDate,Systemurl,Numberofcopies,Amount,Total ) values (@BillNo,@CustomerName,@Address,@StartDate,@EndDate,@Systemurl,@Numberofcopies,@Amount,@Total)", connection);
                cmd.Parameters.Add("@BillNo", SqlDbType.NVarChar).Value = TextBox1.Text;
                cmd.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = TextBox2.Text;
                cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = TextBox3.Text;
                cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar).Value = Rdbsdate.SelectedDate;
                cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar).Value = Rdbddate.SelectedDate;
                cmd.Parameters.Add("@Systemurl", SqlDbType.VarChar).Value = filename;
                cmd.Parameters.Add("@Numberofcopies", SqlDbType.NVarChar).Value = TextBox7.Text;
                cmd.Parameters.Add("@Amount", SqlDbType.NVarChar).Value = TextBox8.Text;
                cmd.Parameters.Add("@Total", SqlDbType.NVarChar).Value = TextBox9.Text;
                cmd.ExecuteNonQuery();
            }
            
            finally
            {
                connection.Close();
            }
        }
    }
}

My error
page is run .i have click the browser controle choose a file window open select the photo folder but path is in correct

Posted 3-Apr-11 22:42pm

vimal22 2

Updated 4-Apr-11 20:43pm

v7

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

mukesh.mr03 · Answer 1 · 2011-04-03T22:48:00

Solution 1

you have to change your Systemurl field to 'Binary'

Posted 3-Apr-11 22:48pm

mukesh.mr03

Comments

vimal22 2 4-Apr-11 4:55am

only i have store picture location(path)ex (D:divya/k.jpeg) and customer record.... change any code?

mukesh.mr03 4-Apr-11 4:58am

Ok then there is no need to pass 'myImagePathOnDisk' to insert command. You just upload your file to a server folder, get the file path and pass to the insert command parameter.

vimal22 2 4-Apr-11 5:05am

thank you.how do i because i am beginner

Balwant.mnd · Answer 2 · 2011-04-03T23:09:00

hi when you want to store only the image path then why you used the image stream.
just get the image path(absolute path) from the posted file and save the image in the temp folder(optional) and save the image path into the database.
suppose your image has path c:\picture\hen.jpeg the the absolute path becomes hen.jpeg and you can just store the absolute path and make use of it any where in your project.

Thanks.
Balwant

mukesh.mr03 · Answer 3 · 2011-04-03T23:11:00

Solution 3

public void onflbload(object sender, EventArgs e)
        {
            
      
string filename=Server.MapPath("~\YourUploadFolder")+FileUpload.PostedFile.FileName;
FileUpload.PostedFile.SaveAs(filename);
            SqlConnection connection = new SqlConnection();
            connection.ConnectionString =@"Data Source=DEVI\SQLEXPRESS; Initial Catalog =cat; Integrated Security=SSPI";
               
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand("insert into tblphotosettings "
                 + "(BillNo,CustomerName,Address,StartDate,EndDate,Systemurl,Numberofcopies,Amount,Total ) values (@BillNo,@CustomerName,@Address,@StartDate,@EndDate,@Systemurl,@Numberofcopies,@Amount,@Total)", connection);
                cmd.Parameters.Add("@BillNo", SqlDbType.NVarChar).Value = TextBox1.Text;
                cmd.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = TextBox2.Text;
                cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = TextBox3.Text;
                cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar).Value = Rdbsdate.SelectedDate;
                cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar).Value = Rdbddate.SelectedDate;
                cmd.Parameters.Add("@Systemurl", SqlDbType.VarChar).Value = filename;
                cmd.Parameters.Add("@Numberofcopies", SqlDbType.NVarChar).Value = TextBox7.Text;
                cmd.Parameters.Add("@Amount", SqlDbType.NVarChar).Value = TextBox8.Text;
                cmd.Parameters.Add("@Total", SqlDbType.NVarChar).Value = TextBox9.Text;
                cmd.ExecuteNonQuery();
            }
            
            finally
            {
                connection.Close();
            }
        }

Check whether the code works.

Posted 3-Apr-11 23:11pm

mukesh.mr03

Comments

vimal22 2 4-Apr-11 5:26am

thank you
but error is

Error 1 Unrecognized escape sequence C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\photoshops\photoshops\photosetting.aspx.cs 33 47 photoshops

vimal22 2 4-Apr-11 5:30am

string filename=Server.MapPath("~\YourUploadFolder")+FileUpload.PostedFile.FileName

this line error.the error is ("~\YourUploadFolder"

mukesh.mr03 4-Apr-11 5:31am

string filename=Server.MapPath("~/YourUploadFolder")+FileUpload.PostedFile.FileName

vimal22 2 4-Apr-11 5:45am

The error is

Error 1 An object reference is required for the non-static field, method, or property 'System.Web.UI.WebControls.FileUpload.PostedFile.get'

Error 2 An object reference is required for the non-static field, method, or property 'System.Web.UI.WebControls.FileUpload.PostedFile.get' C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\photoshops\photoshops\photosetting.aspx.cs 33 13 photoshops

mukesh.mr03 4-Apr-11 5:47am

can post the code now using or send the code file then i can check what is the actual problem.

vimal22 2 4-Apr-11 5:54am

i had post

mukesh.mr03 4-Apr-11 5:56am

in this line
string filename = Server.MapPath("~/YourUploadFolder") + FileUpload.PostedFile.FileName;

"YourUploadFolder" is the name of the folder where you want to upload the files. keep your folder name there instead of "YourUploadFolder"

vimal22 2 4-Apr-11 6:06am

string filename = Server.MapPath("~/D:\photo") + FileUpload.PostedFile.FileName;

but error this line
Error 1 Unrecognized escape sequence

mukesh.mr03 4-Apr-11 6:11am

Never use a local system folder to upload. see this is a web application and its running on a web server right? so do like this
1. Create a new folder in your solution explorer and name it photo
2. Use the above line of code like this - string filename = Server.MapPath("~/photo") + FileUpload.PostedFile.FileName;
3. The uploaded file will be saved to the folder - "photo"

vimal22 2 4-Apr-11 6:24am

Error 1 An object reference is required for the non-static field, method, or property 'System.Web.UI.WebControls.FileUpload.PostedFile.get' C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\photoshops\photoshops\photosetting.aspx.cs 32 59 photoshops

Error 2 An object reference is required for the non-static field, method, or property 'System.Web.UI.WebControls.FileUpload.PostedFile.get' C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\photoshops\photoshops\photosetting.aspx.cs 33 13 photoshops

vimal22 2 4-Apr-11 6:46am

the page is run but file upload control is click then open the local window

vimal22 2 4-Apr-11 6:50am

the page is run but choose a file window open how to store the image

kailash solanki · Answer 4 · 2011-04-04T20:52:00

You can store only path of Image in database like ~\foldername\image1.gif
the concat both string variable directoryname and image name then send it as parameter of command . when you want to retrive then u will get the Path of image from solution it assign to image control.it's use three variable and use it.

and you can store Image in Binary format of image in database convert image into 64bit then you can store it .but i First solution is very easy.
and