Search This Blog

May 30, 2013

Create Folder Programatically with Database


string appPath = Request.PhysicalApplicationPath.ToString();

            DirectoryInfo newDirectory = new DirectoryInfo(appPath + txtName.Text);
            BAL obj1 = new BAL();
            DataTable dt = new DataTable();
            SqlParameter []p =new SqlParameter[1];
            p[0]=new SqlParameter("@FName",txtName.Text);
            string chk= obj1.ExecuteScaler("SP_CreateFolder", p);
            if (!newDirectory.Exists)
            else if (chk == "1")
                ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Already Exists');</script>");

May 21, 2013

SQL Server Ranking Functions

SQL Server 2005 introduced new ranking functions. This article is tailored as an introduction to these functions, difference between them and when to use each and a few examples.
Related Posts Plugin for WordPress, Blogger...