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.Windows.Forms;
- using MySql.Data.MySqlClient;
- namespace ReadDataFromMysql
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void button1_Click(object sender, EventArgs e)
- {
- string sql = " SELECT * FROM teacher ";
- MySqlConnection con = new MySqlConnection("host=localhost;user=root;password=859694;database=projekt;");
- MySqlCommand cmd = new MySqlCommand(sql, con);
- con.Open();
- MySqlDataReader reader = cmd.ExecuteReader();
- while (reader.Read()) {
- data2txt.Text = reader.GetString("id");
- datatxt.Text = reader.GetString("userId");
- }
- }
- private void btnclose_Click(object sender, EventArgs e)
- {
- Close();
- }
- }
- }
- data2txt.Text = string.Empty;
- datatxt.Text = string.Empty;
- while (reader.Read())
- {
- data2txt.Text += reader.GetString("id");
- datatxt.Text += reader.GetString("userId");
- }
- data2txt.Text = reader.GetString("id");
- datatxt.Text = reader.GetString("userId");
- varexample.Text += reader.GetString("id");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement