asp.net C # connection to MySQL database program code

The code is as follows

Copy Code

#include <stdio.h> #include <stdlib.h> #include <mysql/mysql.h> int main (void) { const char *host = "localhost"; const char *user = "root"; const char *pass = "YourPassword"; const char *db = "MySQL"; /* Define mysql variable * * MySQL MySQL; Mysql_res *rs; Mysql_row ROW; Mysql_init (&mysql); /* Initialize * * /* Connection Database * * if (!mysql_real_connect (&mysql, host, user, pass, DB, 0, NULL, 0)) { printf ("%s", Mysql_error (&mysql)); } Get more result test /* Char *sql = "Select User,host from User"; if (mysql_query (&mysql, SQL)!=0) {//Query printf ("%s", Mysql_errno (&mysql), Mysql_error (&mysql)); } rs = Mysql_store_result (&mysql); Get query Results while (row = Mysql_fetch_row (RS)) {//Get each line record printf ("%s----%SN", row[0], row[1]); } */ Get one result test Char *sql = "Select User from user where host= ' 127.0.0.1 '"; if (mysql_query (&mysql, SQL)!=0) {//Query 1,7 Top if (mysql_query (&mysql, SQL)!=0) {//Query printf ("%s", Mysql_errno (&mysql), Mysql_error (&mysql)); } rs = Mysql_store_result (&mysql); Get query Results Row=mysql_fetch_row (RS); printf ("%sn", row[0]); //*/ Mysql_free_result (RS); /* Release result set * * Mysql_close (&mysql); /* Close Connection * * return 1; }