Create image from datatable

Manoj Kumar

11y2.8kLearn iOS Programming

How to Create image from datatable in C#

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Kumar11y ago
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 Suman11y ago
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 Kumar11y ago
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 Suman11y ago
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 Suman11y ago
So what now you want to show whole table in image?
Manoj Kumar11y ago
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 Suman11y ago
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 Kumar11y ago
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 Suman11y ago
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 Kumar11y ago
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 Menoth11y ago
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