GridView数据绑定+存储过程调用

界面：

        <div style=" margin-top:30px; margin-left:-300px;">
   <asp:GridView ID="GridView1" runat="server" >
        <Columns>
        <asp:TemplateField HeaderText="Brand_ID">
        <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='<%# Eval("Brand_ID") %>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Brand_Name">
        <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='<%# Eval("Brand_Name") %>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="SearchEngine_Name">
        <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='<%# Eval("SearchEngine_Name") %>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="KeyWord">
        <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='<%# Eval("KeyWord") %>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>
        </Columns>
        </asp:GridView>
         </div> 

后台：

 private void BindData()
    {
        GridView1.DataSource = GetData();
        GridView1.AutoGenerateColumns = false;
        GridView1.DataBind();
    }
    private SqlDataReader GetData()
    {
      
        //测试的连接串
        string StrCon = "server=.;uid=sa;pwd=1;database=Task;Timeout=36000;Max Pool Size=200;";
        DataTable dt = new DataTable();
        SqlConnection conn = new SqlConnection(StrCon);
        try
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandTimeout = 1000;
            //cmd.ResetCommandTimeout();
            cmd.Connection = conn;
            cmd.CommandText = "pr_InquireRealTimeCaptureBrandAndMedia";//需要调用的存储过程
            cmd.CommandType = CommandType.StoredProcedure;
            conn.Open();
            //获得数据
            SqlDataReader sqlDate = cmd.ExecuteReader(CommandBehavior.CloseConnection);//执行完后关闭连接
            return sqlDate;
        }
        catch (Exception e)
        {
            return null;
        }
        finally
        {
            //sqlconn.Close();

        }
    }