how to show 20 rows on datagrid each time?
<p>i show data on gridview like this:</p>

<pre><code>SQL = "SELECT * FROM MEN ";
                    dsView = new DataSet();
                    adp = new SqlDataAdapter(SQL, Conn);
                    adp.Fill(dsView, "MEN");
                    adp.Dispose();
                    GridView1.DataSource = dsView.Tables["MEN"];
                    GridView1.DataBind();
</code></pre>

<p>but i see along list... </p>

<p>how to show Every time only 10 rows ?</p>

<p>i work on asp.net and C#</p>
