ASP.NET - One Radio Button Selected in Gridview

ASP.NET does not allow you to place a radio button in a gridview row and have only a single radio button selected at a time.

I came across this post that solved by problem.

http://www.dotnetlearners.com/blogs/view/216/allow-only-single-radio-button-selection-in-aspnet-gridview.aspx

It uses this javascript function to change the other selected value:

<script language="javascript">
    function singleRbtnSelect(chb) {
        $(chb).closest("table").find("input:radio").prop("checked", false);
        $(chb).prop("checked", true);
    }
</script>

VB.NET - Reference for Working with PDF's using iTextSharp

I have found this blog useful for how to use iTextSharp when working with PDF's.

http://www.worldbestlearningcenter.com/index_files/csharp-combine-pdf-files.htm

SQL - Query Triggers in a Database

SELECT 
     o.name AS trigger_name 
    ,'x' AS trigger_owner 
    ,s.name AS table_schema 
    ,OBJECT_NAME(o.parent_obj) AS table_name 
    ,OBJECTPROPERTY(o.id, 'ExecIsUpdateTrigger') AS isupdate 
    ,OBJECTPROPERTY(o.id, 'ExecIsDeleteTrigger') AS isdelete 
    ,OBJECTPROPERTY(o.id, 'ExecIsInsertTrigger') AS isinsert 
    ,OBJECTPROPERTY(o.id, 'ExecIsAfterTrigger') AS isafter 
    ,OBJECTPROPERTY(o.id, 'ExecIsInsteadOfTrigger') AS isinsteadof 
    ,OBJECTPROPERTY(o.id, 'ExecIsTriggerDisabled') AS [disabled] 
FROM sysobjects AS o 

INNER JOIN sysobjects AS o2 
    ON o.parent_obj = o2.id 

INNER JOIN sysusers AS s 
    ON o2.uid = s.uid 

WHERE o.type = 'TR'

*Credit goes to the poster here: Stack Overflow - Get Triggers in Database

VB.NET - Execute Command Lines

To call a command prompt in one line, it can be done this way:

Process.Start("cmd", "/c cd " & m_strSignToolLocation & " & " & strSignCmd)

To call a command prompt with more options, such as running with the command prompt hidden, call this way:

Dim p As Process = New Process()

Dim pi As ProcessStartInfo = New ProcessStartInfo()

pi.Arguments = "/c cd " & m_strSignToolLocation & " & " & strSignCmd

pi.FileName = "cmd.exe"

pi.WindowStyle = ProcessWindowStyle.Hidden

p.StartInfo = pi

p.Start()

Here are what some of the command arguments mean:

'/k returns the command window

'/c terminates the command window

'& allows multi line execution on a single line

SQL - Find Stored Procedures that have been Renamed

The following script will determine if any stored procedures were renamed, rather than dropped and re-created (substitute [DATABASE NAME] with the name of your database):

     SELECT meta.ROUTINE_NAME, *

     FROM [DATABASE NAME].sys.sql_modules def,

           [DATABASE NAME].INFORMATION_SCHEMA.ROUTINES meta

     WHERE  SUBSTRING(def.definition,1,4000) = SUBSTRING(meta.ROUTINE_DEFINITION,1,4000)

AND def.definition NOT LIKE '%![' + meta.ROUTINE_NAME + '!]%' ESCAPE '!'   

order by 1