Database Operations for C #

1. Connect to database, check data

  New Mysqlconnection ("server=localhost;user Id=root;password=root123;database=bizmap; Charset=utf8; " );  Mycon. Open ();   New Mysqlcommand ("select * from Versioninfo where versionname= '"" " , mycon);   = myCMD. ExecuteReader ();  Mycon. Close ();

Inserting data

Mysqlconnection mycon = new Mysqlconnection ("server=localhost;user id=root;password=root123;database= Bizmap; Charset=utf8; "); Mycon. Open ();    
Mycon. Open (); String Sqlinsert1="INSERT into versioninfo values ('"+ Versionname +"', '"+ Updatedate +"', '"+ Description +"')";
Mysqlcommand mycmd = new Mysqlcommand ( Sqlinsert1,mycon);
//mycmd.commandtext=Sqlinsert1;
myCMD. ExecuteNonQuery ();
Mycon. Close ();

2. Optimization of time complexity

Database Open,close operations often take a lot of time, you can use the StringBuilder append method, splicing SQL statements, and finally execute

3. Using Startwith in string is lower than using contains complexity, try to use the former

4. Minimize the number of cycle layers, and the number of database operations

Database Operations for C #