Small Data volume CSV file Data import Database (IDEA)

Write a general idea, because SQL Server provides a graphical interface that can be imported directly.

1, private static string GetConnectionString (String folderpath)//folder path

{

string [email protected] "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" [email protected] "\; Extended properties= ' Text; ';

return connectionString;

}

2, String sql= "select from 1.csv";

DataTable dt=oledbhelper.query (@ "C:\Users\Administrator\Desktop", SQL);

StringBuilder sb=new StringBuilder ();

String portcode=string. Empty;

String namecode=string. Empty;

if (Dt!=null&&dt. ROWS.COUNT>0)

{

foreach (DataRow dr in Dt. Rows)

{

portcode=dr["Portcode"]. ToString ();

namecode=dr["Namecode"]. ToString ();

Sb. Appendline ("INSERT into TableName (Portcode,namecode) VALUES ('" +portcode+ "', '" +namecode+ "')");

}

String RESULT=SB. ToString ();

}

Dbhelper.executesql (result);

　　

Small Data volume CSV file Data import Database (IDEA)