How to retrieve a column from database using SQL query

Question

I’m using database utility and in this example I’m inserting some records

DBUtil.ExecuteNonQuery(@"if not exists(select * from UserTemplate)
   begin
     insert into UserTemplate
     select id, 8,1,….{TemplateCode} ….
     from User
  end”);

how can I extend this query to select UsersImage column from UserTemplate table?

P.S. UsersImage is of varbinary(MAX) datatype.

That does not return a result set. You will need to rewrite the SQL statement and use a different method of `DBUtil`. — Crowcoder, Jan 02 '16 at 12:40
maybe I left something in a hurry, but question is how to extend the query to select UsersImage from UserTemplate table knowing that UsersImage is varbinary(MAX)? — panjo, Jan 02 '16 at 13:27

score 0 · Answer 1 · answered Jan 02 '16 at 14:03

Without knowing what DBUtil is, or if you want one specific image or all of them, I would guess you want something like this. Execute a reader that gets all images, read the varbinary field into a byte array, do something with the byte array.

using(SqlDataReader rdr = DBUtil.ExecuteReader("SELECT [UsersImage] FROM [UserTemplate]"))
{
    while(rdr.Read())
    {
        btye[] img = (byte[])rdr[0];
        //do something with img
    }
}

How to retrieve a column from database using SQL query

1 Answers1