how to get the image dimesion without using bitmap or graphics object in .net

Question

i want to create SQL CLR integrated function from Visual C#, now my requirement is user will pass a folder path as a paramter, and the function should get all the image file from the the folder, and get its basic property like FileSize, dimension etc.. but it seems SQL project does not supports System.Drawing Namespace... as i created the same function in normal project it worked fine, as i was able to use System.Drawing Namespace, but here i cannot use, System.Drawing Namespace.. so is there any other way to get the image dimension...

below is the code i have used in my normal project.

public DataTable InsertFile(string FolderPath)  
{   
    DataTable dt = new DataTable();  
    DataColumn[] col = new DataColumn[] { new DataColumn("FileName",   typeof(System.String)), new DataColumn("FileSize", typeof(System.Int32)), new   DataColumn("FilePath", typeof(System.String)), new DataColumn("Width",   typeof(System.Int32)), new DataColumn("Height", typeof(System.Int32)) };  
    dt.Columns.AddRange(col);  
    FileInfo info= null;  
    Bitmap bmp = null;  
    foreach (String s in Directory.GetFiles(FolderPath, "*.jpg"))  
    {  
        info = new FileInfo(s);  
        bmp = new Bitmap(s);  
        DataRow dr = dt.NewRow();  
        dr["FileName"] = Path.GetFileName(s); 
        dr["FileSize"] = info.Length / 1024;    
        dr["FilePath"] = s;  
        dr["Width"] = bmp.Width;  
        dr["Height"] = bmp.Height;  
        dt.Rows.Add(dr);  
    }  
    return dt;  
}

does anyone have any idea how to get image dimension without using System.Drawing Namespace.

Whats the error/exception you are getting inside the SQL project? — Christoph Fink
– Christoph Fink, Commented Jun 17, 2011 at 16:41
Actually in Sql Project, there is no way to import(using System.Drawing) Namespace.. neither it allows to add reference for System.Drawing — Abbas
– Abbas, Commented Jun 17, 2011 at 16:48

Mike Miller · Accepted Answer · 2011-06-17 19:35:44Z

1

wow never seen anyone try this before, but if using Drawing in a SQL project isn't allowed try reading the header info like this http://www.codeproject.com/KB/cs/ReadingImageHeaders.aspx

Edit included the code, with the change to remove the dependency on Size.

while (binaryReader.ReadByte() == 0xff)
        {
            byte marker = binaryReader.ReadByte();
            ushort chunkLength = binaryReader.ReadLittleEndianInt16();

            if (marker == 0xc0)
            {
                binaryReader.ReadByte();

                int height = binaryReader.ReadLittleEndianInt16();
                int width = binaryReader.ReadLittleEndianInt16();
                return new int[] { width, height };
            }

            binaryReader.ReadBytes(chunkLength - 2);
        }

edited Jun 17, 2011 at 19:35

answered Jun 17, 2011 at 16:53

Mike Miller

16.6k1 gold badge22 silver badges27 bronze badges

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

2 Comments

Abbas Over a year ago

thats great article, but the end, its also using bitmap object.. as i said above, SQL Project does not support using System.Drawing Namespace, anything else i can do..

Christoph Fink Over a year ago

@Abbas: Only as a fallback - if you check the DecodeJfif-method you see the manual attempt.

Justin C · Accepted Answer · 2011-06-17 17:22:30Z

0

Is the Image object any better for you?

System.Drawing.Image forSize = System.Drawing.Image.FromFile(s);
dr["Width"] = forSize.Width;

and so forth.

That any better or same problem?

answered Jun 17, 2011 at 17:22

Justin C

1,9244 gold badges28 silver badges43 bronze badges

Collectives™ on Stack Overflow

how to get the image dimesion without using bitmap or graphics object in .net

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related