Retrieving image from sql table using a file path, code error

Question

A nice chap called Darin kindly provided me with some code in order for me to retrieve an image by its file path.

However, when I attempt to execute the code, I receive a "NullReferenceException was unhandled by user code; Use the 'new' keyword to create an object instance" on the first var line.

The code can be found below:

   var connectionString = ConfigurationManager.ConnectionStrings["SomeCN"].ConnectionString;
        using (var cn = new SqlConnection("Data Source=STRSQL04;Initial Catalog=PDC;Integrated Security=True"))
        using (var cmd = cn.CreateCommand())
        {
            cn.Open();
            cmd.CommandText = "Select imageID from accounts where MemberID = FM00012";
            cmd.Parameters.AddWithValue("FM00012",5);
            using (var reader = cmd.ExecuteReader())
            {
                if (reader.Read())
                {
                    var filepath = reader.GetString(0);
                Image1.ImageUrl = filepath;
                }
            }
        }

Can someone point out the error in my ways please?

Apologies as always for asking, what I suspect are, ridiculous questions.

Neil Barnwell · Accepted Answer · 2009-12-02 11:48:32Z

1

You don't have a connection string called "SomeCN" (or whatever you're using for real) in your app config, so when you try to access the ConnectionString.ConnectionString parameter, it throws a nullref.

Can you post the contents of your app.config, or at least the ConnectionStrings element, so we can see?

Modifying application settings on MSDN (when you try it, you'll see one of the settings types in the dropdown of the settings editor is "ConnectionString").

edited Dec 2, 2009 at 11:48

answered Dec 2, 2009 at 11:09

Neil Barnwell

42.3k31 gold badges156 silver badges228 bronze badges

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

2 Comments

MrDean Over a year ago

Ok cool, so I need to set up my connection string in my config. I'll go research how to do that!

MrDean Over a year ago

Sorted, it was in my webconfig file anyway. Top stuff, thank you for pointing/pushing me in the right direction!

Collectives™ on Stack Overflow

Retrieving image from sql table using a file path, code error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related