Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 System.Data;
- using System.Data.SqlClient;
- namespace baza_danych1
- {
- /// <summary>
- /// Interaction logic for MainWindow.xaml
- /// </summary>
- public partial class MainWindow : Window
- {
- public MainWindow()
- {
- InitializeComponent();
- }
- private void Button_Click(object sender, RoutedEventArgs e)
- {
- logowanie_do_bazy();
- }
- private void logowanie_do_bazy()
- {
- string select = "SELECT * FROM nazwa_twojej_tabeli"; //nazwa_twojej_tabeli <- zastąp swoją nazwą
- string connetionString = null;
- SqlConnection cnn;
- //należy odpowiednio wpisać swoją nazwe komputera, nazwe bazy danych oraz haslo
- connetionString = "Data Source=LAPTOP-PC\\SQLEXPRESSDEV;Initial Catalog=nazwa_twojej_bazy;User ID=sa;Password=haslo";
- cnn = new SqlConnection(connetionString);
- try
- {
- cnn.Open();
- MessageBox.Show("Podłączony do serwera MS SQL 2014 ! ");
- // wyswietlenie danych na datagridview
- SqlDataAdapter dataAdapter = new SqlDataAdapter(select, cnn); //c.con is the connection string
- SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
- DataSet ds = new DataSet();
- DataTable dt = new DataTable("Pracownicy");
- dataAdapter.Fill(dt);
- dataGridView1.ItemsSource = dt.DefaultView;
- //dataGridView1.ReadOnly = true;
- //---
- cnn.Close();
- }
- catch (Exception ex)
- {
- MessageBox.Show("Problem z podłączeniem do serwera bazy danych MS SQL ! ");
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement