Re size image or Generate Thumbnail in asp.net

Code for  re size image in asp.net, It also maintain the aspect ratio and image quality.

private void GenerateThumbnail(byte[] byteArray, int thumbnailSize)

        {

            // Convert byte array into stream

            Stream fStream = new MemoryStream(byteArray);

            Bitmap photo = new Bitmap(fStream);

            // maintain aspect ratio

            int width, height;

            if (photo.Width > photo.Height)

            {

                width = thumbnailSize;

                height = photo.Height * thumbnailSize / photo.Width;

            }

            else

            {

                width = photo.Width * thumbnailSize / photo.Height;

                height = thumbnailSize;

            }

            Size resizeImageSize = new Size(width, height);

            System.Drawing.Image img = System.Drawing.Image.FromStream(fStream);

            System.Drawing.Image thumbnailImage = img.GetThumbnailImage(resizeImageSize.Width, resizeImageSize.Height, null, IntPtr.Zero);

            // use high quality conversion

            using (Graphics graphic = Graphics.FromImage(thumbnailImage))

            {

                graphic.CompositingQuality = CompositingQuality.HighQuality;

                graphic.SmoothingMode = SmoothingMode.HighQuality;

                graphic.InterpolationMode = InterpolationMode.HighQualityBicubic;

                Rectangle rect = new Rectangle(0, 0, resizeImageSize.Width, resizeImageSize.Height);

                graphic.DrawImage(thumbnailImage, rect);

                using (MemoryStream imageStream = new MemoryStream())

                {

                    thumbnailImage.Save(imageStream, System.Drawing.Imaging.ImageFormat.Jpeg);

                    // convert back into byte array

                    byte[] imageContent = new Byte[imageStream.Length];

                    imageStream.Position = 0;

                    imageStream.Read(imageContent, 0, (int)imageStream.Length);

                   

                    context.Response.ContentType = "image/jpeg";

                    context.Response.OutputStream.Write(imageContent, 0, imageContent.Length);

                }

            }

        }

Image file validation in File upload control ASP.NET

<!-- file Upload Control -->

 <asp:FileUpload ID="fuMainImage" runat="server" />

<!-- Image file validator -->

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="fuMainImage"   ErrorMessage="Invalid Image File (supported file type are .JPEG, .PNG, .GIF) "  ValidationExpression="^([0-9a-zA-Z :\\-_!@$%^&*()])+(.jpg|.JPG|.jpeg|.JPEG|.png|.PNG|.gif|.GIF)$">

</asp:RegularExpressionValidator>

Query to know Foreign key (FK) column in your database MSSQL

SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id,
fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id,
fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id

Query to know Primary key column in your database MSSQL

Query to know Primary key column in your database MSSQL...

SELECT i.name AS IndexName,

OBJECT_NAME(ic.OBJECT_ID) AS TableName,

COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName

FROM sys.indexes AS i

INNER JOIN sys.index_columns AS ic

ON i.OBJECT_ID = ic.OBJECT_ID

AND i.index_id = ic.index_id

WHERE i.is_primary_key = 1 order by OBJECT_NAME(ic.OBJECT_ID)

Query to know identity column in your database MSSQL

Query to know identity column in your database MSSQL

select COLUMN_NAME, TABLE_NAME

from INFORMATION_SCHEMA.COLUMNS

where TABLE_SCHEMA = 'dbo'

and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1 order by TABLE_NAME