Chciałbym pobrać daną kolumnę z tabeli z bazy danych do kontrolki textblock. Niestety nigdzie nie mogłem znaleźć informacji na ten temat.
Udało mi się jedynie pobrać dane do data grid:
using System;
using System.Collections.Generic;
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.MySqlClient;
using System.Data;
namespace HomeComunicator
{
/// <summary>
/// Logika interakcji dla klasy MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
Connect();
}
private void connectbtn_Click(object sender, RoutedEventArgs e)
{
Connect();
}
public void Connect()
{
string myConnect = "server= localhost;" +
"database= homecom;" +
"uid= pawel;" +
"password= Haslodobazydanych1;";
string sql2 = "SELECT * FROM `dane` WHERE 1";
try
{
var pol = new MySqlConnection(myConnect);
pol.Open();
pol.Close();
using (MySqlCommand cmdSel = new MySqlCommand(sql2, pol))
{
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmdSel);
da.Fill(dt);
data_grid.ItemsSource = dt.DefaultView;
}
MessageBox.Show("Connected", "We managed to connect to database", MessageBoxButton.OK, MessageBoxImage.None);
}
catch (Exception ex)
{
MessageBox.Show("ERROR", "Failed to connect to database", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}