how to save image data in database?

first create table with 1 field then create SP and take fileupload control and 1 button double click on button and write this code
{
string img = FileUpload1.FileName.ToString();
SqlConnection con1 = new SqlConnection("Data Source=shashi-pc;Initial Catalog=offer;User ID=sa;Password=omsairam");
        SqlCommand cmd1 = new SqlCommand();
        cmd1.Connection = con1;
        con1.Open();
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.CommandText = "SP_insertImage";
        cmd1.Parameters.AddWithValue("@image","~/images/"+img);
        int i = cmd1.ExecuteNonQuery();
        con1.Close();

if (i > 0)
        {
            Label1.Text = "posted successful";
            FileUpload1.PostedFile.SaveAs(MapPath("~/images/" + img));
        }
        else
            Label1.Text = "pls fill correct";

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dinkar Chavhan15y ago
first create table with 1 field then create SP and take fileupload control and 1 button double click on button and write this code
{
string img = FileUpload1.FileName.ToString();
SqlConnection con1 = new SqlConnection("Data Source=shashi-pc;Initial Catalog=offer;User ID=sa;Password=omsairam");
        SqlCommand cmd1 = new SqlCommand();
        cmd1.Connection = con1;
        con1.Open();
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.CommandText = "SP_insertImage";
        cmd1.Parameters.AddWithValue("@image","~/images/"+img);
        int i = cmd1.ExecuteNonQuery();
        con1.Close();

if (i > 0)
        {
            Label1.Text = "posted successful";
            FileUpload1.PostedFile.SaveAs(MapPath("~/images/" + img));
        }
        else
            Label1.Text = "pls fill correct";
Krishna Garad15y ago
Check put the article in Our Recommended Articles Section right side of this post.