Pablo Baena wrote:
Before I post a bug report, can you spot some stupid mistake in this code? Because the table that I'm querying has lots of records and it is showing only one.
THanks
<html> <script language="C#" runat="server">
void BindGrid() { string connectionString = "server=localhost;database=somedatabase;user id=root;password=;";
MySqlConnection dbcon; dbcon = new MySqlConnection(connectionString); dbcon.Open();
string sql = "SELECT numero, nombre " + "FROM clientes";
MySqlDataAdapter adapter = new MySqlDataAdapter(sql, dbcon); DataSet dataset = new DataSet (); adapter.Fill (dataset, "clientes"); MyDataGrid.DataSource = dataset.Tables["clientes"].DefaultView; MyDataGrid.DataBind(); ShowStats(); }
void Page_Load(Object sender, EventArgs e) { if (chk1.Checked) { MyDataGrid.PagerStyle.Mode=PagerMode.NumericPages; } else { MyDataGrid.PagerStyle.Mode=PagerMode.NextPrev; }
BindGrid(); }
void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs e) { MyDataGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid(); }
void ShowStats() { lblCurrentIndex.Text = "CurrentPageIndex is " + MyDataGrid.CurrentPageIndex; lblPageCount.Text = "PageCount is " + MyDataGrid.PageCount; }
</script>
<body>
<h3><font face="Verdana">Basic Paging with DataGrid</font></h3>
<form runat=server>
<ASP:DataGrid id="MyDataGrid" runat="server" AllowPaging="True" PageSize="10" PagerStyle-Mode="NumericPages" PagerStyle-HorizontalAlign="Right" PagerStyle-NextPageText="Next" PagerStyle-PrevPageText="Prev" OnPageIndexChanged="MyDataGrid_Page" BorderColor="black" BorderWidth="1" GridLines="Both" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="#eeeeee" />
<p> <asp:Checkbox id="chk1" runat="server" Text="Show numeric page navigation buttons" Font-Name="Verdana" Font-Size="8pt" AutoPostBack="true" />
<p> <table bgcolor="#eeeeee" cellpadding="6"><tr><td nowrap><font face="Verdana" size="-2">
<asp:Label id="lblCurrentIndex" runat="server" /><br> <asp:Label id="lblPageCount" runat="server" /><br>
</font></td></tr></table> </form>
</body> </html>
_______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list