Create image from datatable

Question

How to Create image from datatable in C#

Manoj Kumar · Answer

Thanks for reply ... I just want to create a restfull web service which get the text data from database and return in image format only ..

Sujeet Suman · Answer

Then it's ok use then use my previous reply & draw table at runtime. By the way what is your requirement. Why you are doing dike this? In which scenario you are using this?

Manoj Kumar · Answer

thanks for reply Yes i want to show whole table in image(like .jpeg )? using restfull webservice. i checked below link. http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/ but it's showing in html . pls help.

Sujeet Suman · Answer

Manoj please once go through below link. This may help you: http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/ If this is helpful for you then please accept my Answer .

Sujeet Suman · Answer

So what now you want to show whole table in image?

Manoj Kumar · Answer

Thanks Sujeet for your reply .. i am tried second (02 ) method . it show all data in one line in image, but i want to show data in tabular form. Is that possible in image format. pls reply.

Sujeet Suman · Answer

Manoj you are able to fetch text from your database. So now use below code: (01.) If you having image in your application. Then use below: string m_FetchedText; var image = Image.FromFile("d:\temp\image01.jpg"); using (var graphics = Graphics.FromImage(image)) { var font = new Font(FontFamily.GenericSansSerif, 16.0f); graphics.DrawString(m_FetchedText, font, Brushes.Red, new Point(10, 10)); } image.Save("d:\temp\image_image02.jpg"); (02.) If you don't have image in your application. Then use below: private Image CreateImage(String text, Font font, Color textColor, Color backColor) { //first, create a dummy bitmap just to get a graphics object Image img = new Bitmap(1, 1); Graphics drawing = Graphics.FromImage(img); //measure the string to see how big the image needs to be SizeF textSize = drawing.MeasureString(text, font); //free up the dummy image and old graphics object img.Dispose(); drawing.Dispose(); //create a new image of the right size img = new Bitmap((int) textSize.Width, (int)textSize.Height); drawing = Graphics.FromImage(img); //paint the background drawing.Clear(backColor); //create a brush for the text Brush textBrush = new SolidBrush(textColor); drawing.DrawString(text, font, textBrush, 0, 0); drawing.Save(); textBrush.Dispose(); drawing.Dispose(); return img; } If this is helpful for you then please accept my Answer .

Manoj Kumar · Answer

Thanks Sujeet, But my question is not about for the your answer. My question is - How to fecth text data record from the database and show in the image format . Then pls let me know..

Sujeet Suman · Answer

Manoj it's ok your are fetching image from database but on UI where you would like to show? Either on GridView or Image/PictureBox? If you would likw to show on GridView then please once go through below link: http://www.codeproject.com/Articles/20782/Displaying-Images-from-a-Database-in-a-GridView http://www.dotnetfox.com/articles/store-images-to-database-and-bind-to-gridview-in-Asp-Net-1114.aspx http://www.aspdotnet-suresh.com/2014/11/retrieve-images-from-path-stored-in-database-in-aspnet.html If you would likw to show on Image/PictureBox then please once go through below link: http://www.aspsnippets.com/Articles/Display-image-from-database-in-Image-control-without-using-Generic-Handler-in-ASPNet.aspx http://www.codeproject.com/Questions/499613/C-plushowplustoplusretrieveplusimageplusfromplus If this is helpful for you then please accept my Answer .

Manoj Kumar · Answer

Hi ! i want to fecth data record from the database and show in data record in image format . Is That possible. if yes then pls let me know..

Rajeesh Menoth · Answer

Hi, Can you explain more..!! Just check the following reference : https://social.msdn.microsoft.com/Forums/vstudio/en-US/b952e1b9-122e-4306-86a4-e30f92056dbc/adding-image-to-the-datatable