How to call the MYSQL class

lidaoying · Posted on 9/28/2018 7:27:40 PM

winform window program

In the database, there are name and pass
                     123       abc
How WinForm reads this ABC into a textbox

MySQLConn con = new MySQLConn();
         string sql = "select * from user where name='123'";
         dataGridView1.DataSource  = con. ExecuteQuery(sql);

I wrote this wrong
MySQLConn con = new MySQLConn();
         string sql = "select * from user where name='123'";
         textbox1  = con. ExecuteQuery(sql);

Little scum · Posted on 9/29/2018 9:23:03 AM

The ExecuteQuery method is in java jdbc

According to your previous code, if you execute the ExecuteQuery method, it should return a DataTable

So, the code is changed to:

textbox1. Text = con. ExecuteQuery(sql). Rows[0]["pass"]. ToString(); Try

Murong Ziying · Posted on 11/2/2018 8:58:43 AM

We recommend using Dapper and Dapper's SimpleCURD

[New Issue] How to call the MYSQL class

Sections viewed