Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using MySql.Data.MySqlClient;
- namespace AplikacjaIO
- {
- public partial class Form2 : Form
- {
- public Form2()
- {
- InitializeComponent();
- }
- private void button1_Click(object sender, EventArgs e)
- {
- string connectionString = "datasource=127.0.0.1;port=3306;username=zyrc;password=eloelo67;database=biblioteka";
- MySqlConnection connectDataBase = new MySqlConnection(connectionString);
- MySqlCommand cmdDataBase = new MySqlCommand("SELECT * FROM ksiazka", connectDataBase);
- try
- {
- MySqlDataAdapter sda = new MySqlDataAdapter();
- sda.SelectCommand = cmdDataBase;
- DataTable dbtataset = new DataTable();
- sda.Fill(dbtataset);
- BindingSource bSource = new BindingSource();
- bSource.DataSource = dbtataset;
- dataGridView1.DataSource = bSource;
- sda.Update(dbtataset);
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- }
- private void button2_Click(object sender, EventArgs e)
- {
- this.Hide();
- Form3 ss = new Form3();
- ss.Show();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement