날짜조회하기 및 데이타그리드뷰에 mysql open하지 않고 뷰하기

날짜조회하기 및 데이타그리드뷰에 mysql open하지 않고 뷰하기

namespace Fetch

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        //MySqlConnection conn = new MySqlConnection("");

        private MySqlConnection myConn = new MySqlConnection("datasource=localhost;port=3306;username=root;password=1234");

        private void button1_Click(object sender, EventArgs e)

        {

            MySqlDataAdapter mdf = new MySqlDataAdapter("select * from wdata_mdb.connect_history where date between '"+dateTimePicker1.Value.ToString()+"' and '"+dateTimePicker2.Value.ToString()+"' ", myConn);

            DataTable sd = new DataTable();

            mdf.Fill(sd);

            dataGridView1.DataSource = sd;

        }

    }

}