using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

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

        private void Form1_Load(object sender, EventArgs e)
        {
            string strCon = "Data Source=localhost;Database=csharp;Uid=root;Pwd=abc123;";//定义数据库连接字符串
            MySqlConnection sqlcon;//声明MySqlConnection对象
            MySqlDataAdapter sqlda;//声明MySqlDataAdapter对象
            DataSet myds;//声明DataSet数据集对象
            sqlcon = new MySqlConnection(strCon);//实例化数据库连接对象
            sqlda = new MySqlDataAdapter("select * from tb_Salary", sqlcon);//实例化数据库桥接器对象
            myds = new DataSet();//实例化数据集对象
            sqlda.Fill(myds, "tb_Salary");//填充DataSet数据集
            var query = from salary in myds.Tables["tb_Salary"].AsEnumerable()//使用LINQ从数据集中查询所有数据
                        select salary;
            DataTable myDTable = query.CopyToDataTable<DataRow>();//将查询结果转化为DataTable对象
            dataGridView1.DataSource = myDTable;//显示查询到的数据集中的信息
        }
    }
}