using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace Query2
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected void btnExecute_Click(object sender, EventArgs e)
        {
            string query = string.Empty;
            query = txtQuery.Text.Trim();
            ClsManager obj = new ClsManager();
            IExecuteQuery execute = (IExecuteQuery)obj;
            try
            {
                if (query.Length > 0)
                {
                    if (query.ToLower().StartsWith("select"))
                    {
                        DataSet ds = new DataSet();
                        ds = execute.GetQueryResult(query);
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            ViewState["SortExpr"] = null;
                            gv.DataSource = ds;
                            gv.DataBind();
                        }
                        else
                        {
                            lblMsg.Visible = true;
                            lblMsg.Text = "No Record Found";                
                        }
                    }
                    else
                    {
                        lblMsg.Visible = true;
                        lblMsg.Text = "Please Enter Valid Select Query.";        
                    }

                }
                else
                {
                    lblMsg.Visible = true;
                    lblMsg.Text = "Please Enter Query.";
                }
            }
            catch (Exception)
            {
                lblMsg.Visible = true;
                lblMsg.Text = obj.SqlEception;
            }
 
        }

        

        protected void gv_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            string query = string.Empty;
            query = txtQuery.Text.Trim();
            ClsManager obj = new ClsManager();
            IExecuteQuery execute = (IExecuteQuery)obj;
            gv.PageIndex = e.NewPageIndex;
            DataSet ds = new DataSet();
            ds = execute.GetQueryResult(query);
            if (ds.Tables[0].Rows.Count > 0)
            {
                gv.DataSource = ds;
                gv.DataBind();
            }
            else
            {
                lblMsg.Visible = true;
                lblMsg.Text = "No Record Found";
            }

        }

        protected void gv_Sorting(object sender, GridViewSortEventArgs e)
        {
            if (ViewState["sortexpre"] == null)
            {


                string[] sortorder = ViewState["sortexpre"].ToString().Split(',');
                if (sortorder[0] == e.SortExpression)
                {
                    if (sortorder[1] == "ASC")
                    {
                        ViewState["sortexpre"] = e.SortExpression + " " + "DESC";

                    }
                    else
                    {
                        ViewState["sortexpre"] = e.SortExpression + " " + "ASC";
                    }

                }
                else
                {
                    ViewState["sortexpre"] = e.SortExpression + " " + "ASC";
                }
                string query = string.Empty;
                query = txtQuery.Text.Trim();
                ClsManager obj = new ClsManager();
                IExecuteQuery execute = (IExecuteQuery)obj;
                DataSet ds = new DataSet();
                ds = execute.GetQueryResult(query);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    gv.DataSource = ds;
                    gv.DataBind();
                }
                else
                {
                    lblMsg.Visible = true;
                    lblMsg.Text = "No Record Found";
                }
            }
        }
    }
}

How to create dropdownlist with filter and multiselect.

In this article i have post for dropdownlist with multiple selection with filter using bootstrap.

this example also help for ASP.NET application. 
Add thease scripts and css on your page.

Add this div on your page.

Add this code in your c#(.cs) page.

 

 protected void Page_Load(object sender, EventArgs e)
 {
     ddlProduct.Attributes["multiple"] = "multiple";
     if (!Page.IsPostBack)
     {
        BindData();
     }
}

private void BindData()
{
    List product =new List();
    product.Add(new ProductDetails { Id = 1, Name = "Books" });
    product.Add(new ProductDetails { Id = 2, Name = "Shoes" });
    product.Add(new ProductDetails { Id = 3, Name = "Computer" });
    product.Add(new ProductDetails { Id = 4, Name = "Pen" });
    product.Add(new ProductDetails { Id = 5, Name = "LCD" });
    product.Add(new ProductDetails { Id = 6, Name = "TV" });
    product.Add(new ProductDetails { Id = 7, Name = "Laptop" });
    product.Add(new ProductDetails { Id = 8, Name = "Bags" });
    ddlProduct.DataSource = product;
    ddlProduct.DataTextField = "Name";
    ddlProduct.DataValueField = "Id";
    ddlProduct.DataBind();
}

public class ProductDetails
{
    public int Id { get; set; }

    public string Name { get; set; }
}

Preview Of this example.

Find nth highest salary from employee using sql query.

Hi Friend here i am provide you MSsql query to find nth highest salary. lots of example to find nth highest salary but here i am giving you a only two example. 1

  
         SELECT * FROM emp  Emp1
         WHERE ( n ) = (
                         SELECT COUNT( DISTINCT ( Emp2.salary ) )
                         FROM emp  Emp2
                         WHERE Emp2.salary >= Emp1.salary
                        )
    

  
    Select TOP 1 salary as '3rd Highest Salary' from (SELECT DISTINCT TOP 3 salary from emp ORDER BY salary DESC)
    a ORDER BY salary ASC 

Create Database Table Field Properties Using Sql Sciprt

This Script Is Help to you for Create Sql Server Database Table Field Properties for your project. And also help to create Entity for you table.

  
Use DatabaseName

DECLARE @TableName VARCHAR(MAX) = 'TableName'
DECLARE @TableSchema VARCHAR(MAX) = 'Schema'
DECLARE @result varchar(max) = ''

SET @result = @result + 'using System;' + CHAR(13) + CHAR(13) 

IF (@TableSchema IS NOT NULL) 
BEGIN
    SET @result = @result + 'namespace ' + @TableSchema  + CHAR(13) + '{' + CHAR(13) 
END

SET @result = @result + 'public class ' + @TableName + CHAR(13) + '{' + CHAR(13) 

SET @result = @result + '#region Properties' + CHAR(13)  

SELECT @result = @result + CHAR(13) 
    + ' public ' + ColumnType + ' ' + ColumnName + ' { get; set; } ' + CHAR(13) 
FROM
(
    SELECT  c.COLUMN_NAME   AS ColumnName 
        , CASE c.DATA_TYPE   
            WHEN 'bigint' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Int64?' ELSE 'Int64' END
            WHEN 'binary' THEN 'Byte[]'
            WHEN 'bit' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'bool?' ELSE 'bool' END            
            WHEN 'char' THEN 'string'
            WHEN 'date' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                        
            WHEN 'datetime' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                        
            WHEN 'datetime2' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                        
            WHEN 'datetimeoffset' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTimeOffset?' ELSE 'DateTimeOffset' END                                    
            WHEN 'decimal' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                    
            WHEN 'float' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Single?' ELSE 'Single' END                                    
            WHEN 'image' THEN 'Byte[]'
            WHEN 'int' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Int32?' ELSE 'Int32' END
            WHEN 'money' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                                
            WHEN 'nchar' THEN 'string'
            WHEN 'ntext' THEN 'string'
            WHEN 'numeric' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                                            
            WHEN 'nvarchar' THEN 'string'
            WHEN 'real' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Double?' ELSE 'Double' END                                                                        
            WHEN 'smalldatetime' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                                    
            WHEN 'smallint' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Int16?' ELSE 'Int16'END            
            WHEN 'smallmoney' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                                                        
            WHEN 'text' THEN 'string'
            WHEN 'time' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'TimeSpan?' ELSE 'TimeSpan' END                                                                                    
            WHEN 'timestamp' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                                    
            WHEN 'tinyint' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Byte?' ELSE 'Byte' END                                                
            WHEN 'uniqueidentifier' THEN 'Guid'
            WHEN 'varbinary' THEN 'Byte[]'
            WHEN 'varchar' THEN 'string'
            ELSE 'Object'
        END AS ColumnType
        , c.ORDINAL_POSITION 
FROM    INFORMATION_SCHEMA.COLUMNS c
WHERE   c.TABLE_NAME = @TableName and ISNULL(@TableSchema, c.TABLE_SCHEMA) = c.TABLE_SCHEMA  
) t
ORDER BY t.ORDINAL_POSITION

SET @result = @result + CHAR(13) + '#endregion Properties' + CHAR(13)  

SET @result = @result  + '}' + CHAR(13)

IF (@TableSchema IS NOT NULL) 
BEGIN
    SET @result = @result + CHAR(13) + '}' 
END

PRINT @result