Windows LiveWindows Live™
 
 
Jagadish's profileJagadish Pulakhandam'sPhotosBlogListsMore Tools Help

Blog
    March 30

    Part 2: More about variables, IF and CASE in Transact-SQL

    Hai,
     
    You can find part 2 of the series focusing on "database interactions with Transact-SQL" here at http://www.aspfree.com/c/a/MS-SQL-Server/How-to-Use-Variables-IF-and-CASE-in-Database-Interactions-with-TransactSQL/
     
    Enjoy,
    Jag
    9:09 AM | Add a comment | Permalink | Blog it | SQL Server 2005
    March 26

    Part 1: Transact-SQL Tutorial: Working with Variables

    Hai,
     
    Started a new tutorial series to completely cover Transact-SQL Programming (right from its basics).  The first is here:
     
     
    enjoy and let me know if you want any topic..
     
    thanks
    Jag
    11:33 AM | Add a comment | Permalink | Blog it | SQL Server 2005
    March 21

    Extending ASP.NET TextField User Control

    Hello guys,
     
    I Added few more features to the already contributed ASP.NET TexField User Control.  New version is here http://www.aspfree.com/c/a/MS-SQL-Server/Extending-the-ASPNET-TextField-User-Control/
     
     
    Enjoy,
    Jag
    9:44 PM | Add a comment | Permalink | Blog it | ASP.NET
    March 19

    TIP: Open a new browser window using ASP.NET button (server control)

    New browser windows are generally opened using hyperlink with "target" attribute set to "_blank".  Sometime, it may be necessary to process something at server and then open a new window (which cannot be accomplished using hyperlinks). 
     
    To solve such problems, we can still opt for ASP.NET Button (Server control) to process some task (at server) and then open a window dynamically as following:
     
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            '----------------------------
            'process something here
            '----------------------------
     
     
            'open new window using dynamic javascript
            Dim strRedirectScript As String
            strRedirectScript = "<script language =javascript>"
            strRedirectScript += "window.open('http://www.yahoo.com',null,'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=1,resizable=1,width=600,height=400,left=50,top=50');"
            strRedirectScript += "</script> "
            Response.Write(strRedirectScript)
    End Sub
    You can also register the above Javascript using "Page", according to your requirements.
     
    Hope this helps you...
    thanks
    Jag
    9:54 AM | Add a comment | Read comments (1) | Permalink | Blog it | ASP.NET
    March 15

    Enhancing the features of ASP.NET 2.0 TextBox control

    Hello guys,
     
    I contributed a new article which focuses mainly on the following:
     
    • Introduction to User controls in ASP.NET 2.0
    • Developing a composite user control
    • Enhancing the existing ASP.NET 2.0 TextBox control with more flexible features.

    The article got published here http://www.aspfree.com/c/a/ASP.NET/Developing-a-Wonderful-ASPNET-TextField-Control/

    Any suggestions, bugs or errors are appreciated here.

    thanks

    Jag

    10:36 PM | Add a comment | Permalink | Blog it | ASP.NET