I'm using Xamrin.Forms Shared Project since I need to use System.Data.DataTable to connect to Remote SQL Server Database
I would like to know how to set DataTable as ItemsSource
Here is my code
<?xml version="1.0" encoding="utf-8"?>
<ContentPage xmlns="http://xamarin.com/schemas/2014/forms"
xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml"
xmlns:local="clr-namespace:Learning"
xmlns:sync="clr-namespace:Syncfusion.SfDataGrid.XForms;assembly=Syncfusion.SfDataGrid.XForms"
x:Class="Learning.LearningPage">
<ContentPage.Content>
<StackLayout>
<Button x:Name="btnGetData" Text="Get Data" Clicked="btn_Clicked"/>
<sync:SfDataGrid x:Name="LV1"/>
</StackLayout>
</ContentPage.Content>
</ContentPage>
C# Code
using Xamarin.Forms;
using System;
using System.Data;
namespace Learning
{
public partial class LearningPage : ContentPage
{
public LearningPage()
{
InitializeComponent();
}
void btn_Clicked(object sender, System.EventArgs e)
{
if (sender == btnGetData)
{
try
{
var db = new DB_SQL(BaseDBFileName);
db.CheckConn();
DisplayAlert(GSVar.AppName, "Connection Successful", "OK");
var dt = new DataTable();
dt = db.ReadDT("SELECT * FROM File_Details");
DisplayAlert(GSVar.AppName, dt.Rows.Count.ToString(), "OK");
LV1.AutoGenerateColumns = true;
LV1.ItemsSource = dt;
} catch (Exception ex) { DisplayAlert(AppName, ex.Message, "OK"); }
}
}
}
}