Very large amount of data on gridview in asp.net
I have a large amount of data (a sql query with 20000 records) and filling my datagrid with that amount of data takes like 10 minutes, this is my gridview definition

    <asp:GridView ID="g" runat="server" Height="113px" Width="817px" 
    BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" 
    CellPadding="3" GridLines="Vertical" AllowPaging="True" Font-Size="Small" 
    	 PageSize="30">
    	<AlternatingRowStyle BackColor="#DCDCDC" />
    	<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
    	<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
    	<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
    	<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
    	<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
    	<SortedAscendingCellStyle BackColor="#F1F1F1" />
    	<SortedAscendingHeaderStyle BackColor="#0000A9" />
    	<SortedDescendingCellStyle BackColor="#CAC9C9" />
    	<SortedDescendingHeaderStyle BackColor="#000065" />
    	<PagerStyle cssClass="gridpager" HorizontalAlign="Left" />  
    
    </asp:GridView>

As you can see I have enabled to true the AllowPaging property

this is how I bind the data

	DataSet dts = new DataSet();
	OracleDataAdapter oad = new OracleDataAdapter(query, co.conn);

	cmd.CommandText = query;
	cmd.CommandType = CommandType.Text;

	cmd.CommandText = query;
	cmd.CommandType = CommandType.Text;
	OracleDataReader reader = cmd.ExecuteReader();

	oad.Fill(dts);


	g.DataSource = dts.Tables[0];
	g.DataBind();
Very large amount of data on gridview in asp.net
===

I have a large amount of data (a sql query with 20000 records) and filling my datagrid with that amount of data takes like 10 minutes, this is my gridview definition

    <asp:GridView ID="g" runat="server" Height="113px" Width="817px" 
    BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" 
    CellPadding="3" GridLines="Vertical" AllowPaging="True" Font-Size="Small" 
    	 PageSize="30">
    	<AlternatingRowStyle BackColor="#DCDCDC" />
    	<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
    	<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
    	<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
    	<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
    	<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
    	<SortedAscendingCellStyle BackColor="#F1F1F1" />
    	<SortedAscendingHeaderStyle BackColor="#0000A9" />
    	<SortedDescendingCellStyle BackColor="#CAC9C9" />
    	<SortedDescendingHeaderStyle BackColor="#000065" />
    	<PagerStyle cssClass="gridpager" HorizontalAlign="Left" />  
    
    </asp:GridView>

As you can see I have enabled to true the AllowPaging property

this is how I bind the data

	DataSet dts = new DataSet();
	OracleDataAdapter oad = new OracleDataAdapter(query, co.conn);

	cmd.CommandText = query;
	cmd.CommandType = CommandType.Text;

	cmd.CommandText = query;
	cmd.CommandType = CommandType.Text;
	OracleDataReader reader = cmd.ExecuteReader();

	oad.Fill(dts);


	g.DataSource = dts.Tables[0];
	g.DataBind();