How to store image to sql database using Data Access Layer (asp.net)

Question

I have a Data Access Layer

public void AddPartyAsIndividual(AddAnIndividual Student)
{
    using (SqlConnection con = new SqlConnection(ConnString))
    {
        SqlCommand cmd = new SqlCommand("AddIndividualParty", con);
        cmd.CommandType = CommandType.StoredProcedure;

        md.Parameters.AddWithValue("@Student_Image", STudent.StudentImage);

        if (con.State == ConnectionState.Closed)
        {
            con.Open();
            cmd.ExecuteNonQuery();
        }
    }

a DAL, is an extra library that we use to help us with the database actions. Now your question is very poor, nether I see any dal. What error did you have ? where this is not work ?. what is the store procedure ? what DAL did you use ? — Aristos
– Aristos, Commented May 26, 2013 at 22:23

Joshua H · Accepted Answer · 2013-05-27 02:55:20Z

1

Take a look at the following Codeproject article. It demonstrates how to store and retrieve images via SQL Server. The example used is a Winforms client, but the code can be adapted to any project type.

Storing and Retrieving Images from SQL Server Using Strored Procedures and C#.net

answered May 27, 2013 at 2:55

Joshua H

83712 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to store image to sql database using Data Access Layer (asp.net)

I have a Data Access Layer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

I have a Data Access Layer

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related