hanusoft 0 Newbie Poster

Here we are uploading images in File System and storing path in the database.

Code (ImageUpload.aspx.cs) :-
private void Button1_Click(object sender, System.EventArgs e)
        {
    //  Here I am uploading images in Images folder of C drive.
int intResult=0;
string strPath = @"c:\Images\"+Path.GetFileName(File1.PostedFile.FileName);
SqlConnection con = new SqlConnection("server=.;uid=sa;database=pubs;pwd=");
SqlCommand com = new SqlCommand("Insert into Category(name,imagepath) values(@name,@imagepath)",con);
            com.Parameters.Add("@name",TextBox1.Text);
            com.Parameters.Add("@imagepath",strPath);
            con.Open();
            intResult =  Convert.ToInt32(com.ExecuteNonQuery());
            if(intResult != 0)
            {
                File1.PostedFile.SaveAs(strPath);
                Response.Write("Record Inserted.");
            }
        }