//xaml
<Window x:Class="WpfApp216.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:WpfApp216"
mc:Ignorable="d"
Title="MainWindow" Height="450" Width="800">
<Grid>
<DataGrid x:Name="dg"/>
</Grid>
</Window>
//cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace WpfApp216
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
MySQLReadWriteUpdateDelete();
}
private void MySQLReadWriteUpdateDelete()
{
string connStr = "Server=localhost;Database=information_schema;Uid=Uidvalue;Pwd=PwdValue;";
using(MySqlConnection conn=new MySqlConnection(connStr))
{
conn.Open();
string selectStr = "select * from information_schema.engines;";
using (MySqlDataAdapter adapter = new MySqlDataAdapter(selectStr, conn))
{
DataSet ds = new DataSet();
adapter.Fill(ds);
int rowsCount = ds.Tables[0].Rows.Count;
int colsCount = ds.Tables[0].Columns.Count;
List<MySqlModel> modelsList = new List<MySqlModel>();
for(int i=0;i<rowsCount;i++)
{
modelsList.Add(new MySqlModel()
{
ENGINE = ds.Tables[0].Rows[i][0].ToString(),
SUPPORT = ds.Tables[0].Rows[i][1].ToString(),
COMMENT = ds.Tables[0].Rows[i][2].ToString(),
TRANSACTIONS = ds.Tables[0].Rows[i][3].ToString(),
XA = ds.Tables[0].Rows[i][4].ToString(),
SAVEPOINTS = ds.Tables[0].Rows[i][5].ToString(),
});
}
dg.ItemsSource = modelsList;
}
}
}
}
public class MySqlModel
{
public string ENGINE { get; set; }
public string SUPPORT { get; set; }
public string COMMENT { get; set; }
public string TRANSACTIONS { get; set; }
public string XA { get; set; }
public string SAVEPOINTS { get; set; }
}
}
![]()