Concatenation two column in one column using store procedure

See more:

C#

ASP.NET

SQL-Server

Hello All,

I have store procedure that concatenation two column in one column and get the result.
i have 2 field in Table 1) FirstName 2) LastName.
in store procedure in want to result in one column and bind in gridview.
here is Store Procedure.

ALTER PROCEDURE [dbo].[GetOrderList]


	-- Add the parameters for the stored procedure here
	@OrderID INT,
	@OrderStatus VARCHAR(100),
        @CustomerName VARCHAR(100)
AS
BEGIN
	
	SELECT
		OM.ID,
		OM.OrderID,
		OM.OrderDate,
		OM.OrderStatus,
                OM.FirstName + ' ' + OM.LastName As CustomerName,
		ZM.ZoneName,
		SM.StateName,
		CM.CityName,
		S.StoreName
	FROM
		dbo.OrderMaster OM
	INNER JOIN dbo.OrderProduct OP ON OM.OrderID=OP.OrderID
	INNER JOIN dbo.Zone ZM ON ZM.ID=OM.ZoneID
	INNER JOIN dbo.StateMaster SM ON SM.ID=OM.StateID
	INNER JOIN dbo.City CM ON CM.ID=OM.CityID
	INNER JOIN dbo.StoreMaster S ON S.ID=OM.StoreID
	
	WHERE
		OM.IsDeleted=0
		AND OM.OrderID = ISNULL(NULLIF(@OrderID,0),OM.OrderID)
		AND OM.FirstName + ' ' + OM.LastName like @CustomerName
		AND OM.OrderStatus like '%' + ISNULL(@OrderStatus,'') + '%'
END

but there is no bind in gridview :
here is GirdView BindDate :-

private void BindData(string SortExpression, string SortDirection, int OrderID,string OrderStatus,string CustomerName)
    {
        DatabaseHelper db = new DatabaseHelper();
        DataSet ds = db.GetOrderList(OrderID, OrderStatus,CustomerName);

        if (SortDirection != null && SortExpression != null)
        {
            DataView DView = new DataView(ds.Tables[0]);
            DView.Sort = SortExpression + " " + SortDirection;
            GrdOrder.DataSource = DView;
        }
        else
        {
            GrdOrder.DataSource = ds.Tables[0];
            GrdOrder.DataBind();
        }
    }

public DataSet GetOrderList(int OrderID,string OrderStatus,string CustomerName)
    {
        Database db = new SqlDatabase(this.ConnectionString);
        using (DbCommand objcmd = db.GetStoredProcCommand("dbo.GetOrderList"))
        {
            if (OrderID == null)
                db.AddInParameter(objcmd, "@OrderID", DbType.Int32, DBNull.Value);
            else
                db.AddInParameter(objcmd, "@OrderID", DbType.Int32, OrderID);

            if (CustomerName== null)
                db.AddInParameter(objcmd, "@CustomerName", DbType.String, DBNull.Value);
            else
                db.AddInParameter(objcmd, "@CustomerName", DbType.String, CustomerName);

            if (OrderStatus == null)
                db.AddInParameter(objcmd, "@OrderStatus", DbType.String, DBNull.Value);
            else
                db.AddInParameter(objcmd, "@OrderStatus", DbType.String, OrderStatus);

            DataSet ds = db.ExecuteDataSet(objcmd);
            return ds;
        }
    }

Where I am Wrong in this..!!

Thank You All