How? Bulleted Text via Web Form to SQL Database to Powerpoint 2010 Slide's Textbox



I am trying to update textbox sections of each slide but limit the user to only that textbox size and font regardless of how many bullets or sub-bullets they put in.


The data will be entered via a .NET web based form and stored in a SQL database. I should try to limit the user as to the size of what they can put in at the point of entry on the web form, but it is not based on chars. I am not sure if I can store format (bulleted outline/list) in a database field unless it is xml. Then the text (formatted?) will be pushed into the corresponding slide's textbox.


So for example you have a slide for each employee. On the top of the slide you show a productivity chart on the bottom is a text box area where they might enter something like this in the web form(but they could have no sub-bullets or many, or the lines for one bullet may wrap to the next line):



-Hobbies
-Disc Golf (this line could even wrap down to the next line if long enough text)
-Racing
-Marathons (this line could even wrap down to the next line if long enough text)
-Awards
-Education
-BA in General Arts


I did a search and came up with a couple of pieces that will get me started:


***Textbox size (powerpoint 2013 vba resize text in slide mode), ***Level of bullet list (Determine level of bullet list entry), ***A little bit on saving xhtml to DB (Formating lost while pasting content in PowerPoint using VSTO)


These pieces parts may get me started but I was wondering if anyone had a more complete solution or code snippets on each part (1. From Web to SQL with text formatting and limiting user on web form based on space not chars. & 2. Output via C# to Powerpoint). If anyone has done this before or has a reference or link I would greatly appreciate any assistance.


I also plan on downloading Open XML SDK, which may help. I cannot use Interop.


Thank you.


No comments:

Post a Comment