Show MySQL Database data in DataGridView on C# Windows Form .NET Framework | PhpMyAdmin
Vložit
- čas přidán 27. 12. 2022
- Can you help me to buy a coffee:
www.buymeacoffee.com/coffeepr... In this video you will learn how to show data from MySQL database in phpMyAdmin in Visual Studio C# DataGridView
using MySql.Data.MySqlClient;
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;
namespace datagridview_mysql
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
loadData();
}
public void loadData() {
var database = new Database();
if (database.connect_db())
{
string query = "SELECT * FROM revenue";
MySqlCommand mySqlCommand = new MySqlCommand(query);
mySqlCommand.Connection = database.mySqlConnection;
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = mySqlCommand;
DataTable dt = new DataTable();
adapter.Fill(dt);
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = dt;
dataGridViewMyAllData.DataSource = bindingSource;
database.close_db();
}
else {
MessageBox.Show("Database error");
}
}
}
}
//Database class
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace datagridview_mysql
{
internal class Database
{
static readonly string server = "127.0.0.1";
static readonly string user = "root";
static readonly string password = "sUA*8q@TeDsjlNqy";
static readonly string database = "financial";
public static string connection_string = "server='" + server + "'; user= '"+ user +"'; database= '"+database+"'; password='"+password+"'";
public MySqlConnection mySqlConnection = new MySqlConnection(connection_string);
public bool connect_db()
{
try
{
mySqlConnection.Open();
return true;
}
catch (Exception ex)
{
return false;
}
}
public bool close_db()
{
try
{
mySqlConnection.Close();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
}
Awesomeeee anjay
please can you make a vid that shows how to show only an individual's information?