问到MySql数据库的连接字符串

EN

    <add name="DatastoreDataContextConnectionString" connectionString=" Data         
    Source=localhost; User Id=root;Database=datastore;Persist Security Info=True"
    />

string consString = ConfigurationManager.ConnectionStrings["DatastoreDataContextConnectionString"].ConnectionString;

using (SqlConnection con = new SqlConnection(consString))
{
    using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
    {
        //Set the database table name
        sqlBulkCopy.DestinationTableName = "dbo.storedata";
        con.Open();
        sqlBulkCopy.WriteToServer(table);
        con.Close();
    }
}