private async void HomeGridView_PullToRefreshRequested(object sender, EventArgs e)
{
PaginableItemsSource.Clear();
await PaginableItemsSource.LoadMoreItemsAsync(40);
HomeGridView.CompletePullToRefresh();
}
protected void ShowGrid()
{
SqlConnection conn = new SqlConnection(@"data source = localhost; integrated security = true; database = northwind");
SqlCommand cmd = null;
SqlDataReader rdr = null;
string sqlsel = "SELECT * FROM Magician";
try
{
conn.Open();
cmd = new SqlCommand(sqlsel, conn);
rdr = cmd.ExecuteReader();
HomeGridView.DataSource = rdr;
HomeGridView.DataBind();
Message.Text = "Data fetched successfully!";
}
catch (Exception err)
{
Message.Text = err.Message;
}
finally
{
conn.Close();
}
}
/// #######################################################################################
/// (Left/Right) Click handlers
private void homeListView_Click(object sender, ItemClickEventArgs e)
{
/// Connected animation
HomeGridView.PrepareConnectedAnimation("toCoinDetails", e.ClickedItem, "HomeGridView_Element");
var card = ((HomeCard)e.ClickedItem);
this.Frame.Navigate(typeof(CoinDetails), card);
}
private void RefreshGridView()
{
HomeGridView.DataSource = GetRandomProducts();
HomeGridView.DataBind();
}
