How to create a Text box from Control class
I need to make a control from the control class. it means that i need to make a text box from scratch.
i need to create a class which i can customise and add new features ..
please let me know how or where i can get some good info or tutorials to start working on this.
Manoj
Answers (3)
0
<b> Report Date: 2016-11-21 Optometrist: start Time: Consultant: Dr.suresh</b>
0
Hi,
Please try below query -
- DECLARE @x XML = '<table WIDTH="100%" CELLPADDING="1" CELLSPACING="1">
-
- <tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
- <td><b>Report Date : </b>2016-11-21 </td>
- <td><b>Optometrist : </b> </td>
- <td><b>Start Time : </b> </td>
- </tr>
-
- <tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
- <td><b>Consultant : </b>Dr.Suresh </td>
- </tr>
-
- </table>'
-
- SELECT t.c.value('.', 'NVARCHAR(MAX)')
- FROM @x.nodes('*') t(c)
Reference :
https://stackoverflow.com/questions/38868364/sql-remove-all-html-tags-in-a-string