Wednesday, September 3, 2014

MS SQL server query to Find Columns or Fields in Database



SELECT t.name AS table_name, 
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%Your_Field_Name%'
ORDER BY schema_name, table_name

Sunday, February 9, 2014

Inject onload javascript function for aspx pages with master page

1. Add the using reference to the top of your pages .cs file

     using System.Web.UI.HtmlControls;

2. In your Page_Load function of the .cs file add

      ((HtmlGenericControl) this.Page.Master.FindControl("PageBody")).Attributes.Add("onload", "load()");


3. Make sure your master page BODY has the  the matching id from above. in this case: ID="PageBody" runat="server"

4. In your aspx file, add you load function.  something like

<script type="text/javascript">
        function load() {
            alert('page loaded');
        }
 </script>