<asp:GridView ID="TestGridView" runat="server" 
        AllowSorting="True" AutoGenerateColumns="False" 
        DataSourceID="TestSqlDataSource" ondatabound="TestGridView_DataBound" 
        onrowdatabound="TestGridView_RowDataBound">
        <Columns>
            <asp:BoundField DataField="Test1" HeaderText="Test1" 
                SortExpression="Test1" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="TestSqlDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:SqlService %>" SelectCommand="TEST1" 
        SelectCommandType="StoredProcedure" 
        onselected="TestSqlDataSource_Selected" 
        onselecting="TestSqlDataSource_Selecting">
        <SelectParameters>
            <asp:Parameter DefaultValue="" Name="Parameters" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

USE [NameDB]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[TEST1]
  -- Add the parameters for the stored procedure here
  @Parameters varchar(50)
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

    -- Insert statements for procedure here
  SELECT Test.Test1 as 'Test1' FROM Test
  RETURN
END

GO