Nouman Zakir

while (true) { Post.NewArticle(); }
posts - 13, comments - 12, trackbacks - 0

My Links

News

Archives

Post Categories

Personal Website

Monday, February 02, 2009

Find text in SQL stored procedures

Method to retrieve every text inside the stored procedures of a database

SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'

posted @ Monday, February 02, 2009 12:43 AM | Feedback (2) |

Launch browser to display HTML contents

You can launch the default browser to display HTML content using the Process.Start method in the System.Diagnostics namespace by specifying the URL as the argument. But I don't recommend this approach because sometimes the browser will launch behind your application.

A more reliable option is to use the Help.ShowHelp method to launch HTML content (even if the content is not on-line help). Call Help.ShowHelp with the active control as argument 1 (or use Form.Active Form). Specify the URL as argument 2, and be sure to include the prefix (file:///, http://, https://, etc).

posted @ Monday, February 02, 2009 12:13 AM | Feedback (0) |

Powered by: