openSource

We had a need to create URL link of our project on users's desktop using a script. First stage the users had enough rights on their PC's so we included the required icon file also with the script and passed the following VBScript to users to click on it to create the desktop icon link. ' Definie shell object Set objWSHShell = WScript.CreateObject("Wscript.Shell") strDesktop = objWSHShell.SpecialFolders("Desktop") ' Copy the icon file to windows Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFileCopy = objFSO.GetFile( objWSHShell.CurrentDirectory&"\icon.ico") objFileCopy.Copy ("C:\WINDOWS\system32\") ' Define link properties and create link strShortcutName = "Log In" ' Shortcut Name - Edit for the wanted name strShortcutPath = "http://thesystem.com/Login.aspx" ' Link URL - Edit to the wanted URL strIconPath = "C:\WINDOWS\syst

By default the ASP.NET login page and controls are bound with default methods and its bit uneasy to work with ( at least for some ppl like me). We could make use of same controller and pages with our own mechanism of logging in. 1. Changes on web.config <location path="Login.aspx">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <location path="Styles">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <location path="Images">     <system.web>       <authorization>         <allow users="*" />       </authorization>     </system.web>   </location>   <system.web>     <authorization>       <d

I was on a need of creating datagrid object on my page with sorting, filtering, updating needs. You could make use of below example for some complex cases (Dropdown, Date selector update columns for relational data table updates, filters, multiple update queries)     <table border="0" cellspacing="0">         <tbody> <tr>         <th>Owner_Name</th>         <th>OS</th>         <th>Type</th>         <th>Status</th>         <th>Action Type</th>         </tr> <tr>         <td><asp:dropdownlist appenddatabounditems="true" autopostback="true" datasourceid="dsPopulateOwner_Name" datatextfield="UNAME" datavaluefield="UID" font-size="11px" id="ddlOwner_Name" runat="server" width="130px">             <asp:listitem text="*" value="%">&

Got a request to create a data table get from some existing data to some required data formatting. The Source data is like 'C10 L1_B21773197D.xls', 'EV1 L1_B21773602F.xls', 'EV116 L1_B21773659G.xls', etc. The following were the requirements. CategoryCode No NVARCHAR(10) C Contained in legacy data file name Sample legacy data file name : “ C 10 L1_B21773197D ” 1.        Alphabets prior to Numeric characters) FolderNo No VARCHAR(10) C001 Contained in legacy data file name Sample legacy data file name : “ C 10 L1_B21773197D ” 1.        convert numeric characters prior to “white space” to a 3 digit number (e.g. “1” --> “001”) 2.        Append 3 digit number to Category Code VolumeNo No VARCHAR(10) C001L01 Contained in legacy data file name Sample legacy data file name : “ C10 L1_B21773197D ” 1.        Extract the 2 nd occurrence of an Alphabets in Fil