Disable button on form submit using jQuery

JQuery

<script>
    $('form').submit(function () {
        $(this).children('[type=submit]').prop('disabled', true);
    });
</script>

How to get list of available SQL Servers instances using C#

/// <summary>
/// Get SQL Server Instances if possible
/// </summary>
private static string[] GetSQLServerInstances()
{
    List<string> instances = new List<string>();
    try
    {
        System.Data.Sql.SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
        System.Data.DataTable table = instance.GetDataSources();
 
        foreach (System.Data.DataRow row in table.Rows)
        {
            instances.Add(row[0] + "\\" + row[1]);
        }
    }
    catch (Exception)
    {
 
    }
    return instances.ToArray();
}

Deserialization error in XML document(1,1)

Use StreamReader instead of StringReader

Generate C# class from XML

Using XSD

from visual studio tools menu run "Developer Command Prompt for VS2013" as administrator

switch to the directory where your xml file exists using "cd yourxmlfolder"
then type

d:\yourxmlfolder> xsd yourxmlfile.xml


this will generate a yourxmlfile.xsd

then type

d:\yourxmlfolder> xsd yourxmlfile.xsd /classes

and your done

How to get the 4(n) right / left most numbers from an integer SQl SERVER

n right most numbers from an integer

SELECT CAST(RIGHT(CAST(Int AS VARCHAR(20)), [n]) AS BIGINT)

n left most numbers from an integer

SELECT CAST(LEFT(CAST(Int AS VARCHAR(20)), [n]) AS BIGINT)