Добрый день, уважаемые коллеги!
Вот фрагмент кода...
С#:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
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 System.Data;
using System.Data.SqlClient;

namespace workingWithDB
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}

private void Window_Loaded(object sender, RoutedEventArgs e)
{
//GridView1.Visible = true;
string cs = "user id=user; password=userpassword; server=server.domain.local; initial catalog=PrimeBase; integrated security=false";
SqlConnection sqlc = new SqlConnection();
sqlc.ConnectionString = cs;
sqlc.Open();
//Делаем выборку всех записей из БД
string sqlq = "select * from logins"; ;
SqlCommand sqlcmd = new SqlCommand(sqlq, sqlc);
SqlDataAdapter sqlda = new SqlDataAdapter();
sqlda.SelectCommand = sqlcmd;
DataSet ds = new DataSet();
sqlda.Fill(ds, "logins");
this.dataGrid1.DataContext = ds;
this.listBox1.DataContext = ds;
sqlc.Close();
}
}
}
XAML:
<Window x:Class="workingWithDB.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="MainWindow" Height="350" Width="525" Loaded="Window_Loaded" xmlns:my="clr-namespace:workingWithDB">
<Grid>
<DataGrid AutoGenerateColumns="False" Height="119" HorizontalAlignment="Left" Margin="12,12,0,0" Name="dataGrid1" VerticalAlignment="Top" Width="479" DataContext="{Binding}" />
<ListBox Height="135" HorizontalAlignment="Left" Margin="12,0,0,12" Name="listBox1" VerticalAlignment="Bottom" Width="479" />
</Grid>
</Window>

Моя цель - убедить элементы dataGrid1 и listBox1 отображать данные из БД PrimeBase...Пока не получается. :-( Очень прошу Вас помочь разобраться в этом вопросе! Заранее спасибо!

С уважением.