mysql connection string c# app.config bind datagridview asp.net4.6

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

thank u so much,
it helped me a lot to solve an error.

itzelsantos
Автор

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 System.Configuration;
using MySql.Data.MySqlClient;

namespace NewSqlConnection
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
string mainconn =
MySqlConnection mysqlconn = new MySqlConnection(mainconn);
string sqlquery = "SELECT * FROM tablefields";
MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn);
mysqlconn.Open();
MySqlDataAdapter sdr = new MySqlDataAdapter(sqlcomm);
DataTable dt = new DataTable();
sdr.Fill(dt);
dataGridView1.DataSource = dt;
mysqlconn.Close();
}
}
}

AsimAli-pogy
welcome to shbcf.ru