C How do I add a table to a MySQL database???? Please see the details

Do you send out your sql part to take a look? Report any errors?

1. Use different connection objects to access the database, and each specific connection object needs to import a different namespace. c The name of the sqlconnection that accesses the SQL Server database is as follows.

2. Use SQL Server authentication mode to create a connection.

3. After creating a connection through sqlconnection, c has not really connected to the sql server database; Next, to open the connection; Really establish a closed connection to the database with an empty shout.

4. After establishing a data connection, send SQL command to the database, then you can use the sqlcommand object: sqlcommand cmd = new sqlcommand(sql, conn);.

5. For C to send SQL command to the database and return the result set, you need to use the sqldataadapter object: sqldataadapter adp = new sqldataadapter(sql, conn); Returns the result set Crack.

6. C After completing the operation on the SQL Server database, remember to close the data connection of SQL Connection: ;

This one is simple.

Define database connection global variables.

const string connstring = @"data source=theman-pc; database=wpgl;user id=sa;password=admins";

private void button4_click(object sender, eventargs e)

sqlconnection conn = new sqlconnection(connstring);

string mysql = "Insert database operations will do the trick";

sqlcommand cmd = new sqlcommand(mysql, conn);;

If you study it, you will understand.