private void Form1_Load(object sender, EventArgs e) { /* WebClient webClient = new WebClient(); webClient.DownloadFile("http://api.netflix.com/catalog/titles/full?v=2.0?oauth_consumer_key=vwhxtj7gjyze6mvddb28znjd&oauth_nonce=FlucT&oauth_signature=lujB0gjGYHdm2DCDQQ%2FYxCzjvR8%3D&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1328651121&oauth_version=1.0&output=xml", @"c:\netflix2.xml"); */ var conn = new MySqlConnectionInfo("localhost", "root", "Password01", "Netflix"); // int countdown = 250; using (_sql = new MySqlConnection(conn.ConnectionString)) { _sql.Open(); MySqlTransaction transaction = _sql.BeginTransaction(); _sql.NewCommandEx("DELETE FROM Title" ).ExecuteNonQuery(); _sql.NewCommandEx("DELETE FROM Category" ).ExecuteNonQuery(); _sql.NewCommandEx("DELETE FROM Link" ).ExecuteNonQuery(); _sql.NewCommandEx("DELETE FROM External" ).ExecuteNonQuery(); _sql.NewCommandEx("DELETE FROM Availability").ExecuteNonQuery(); var textReader = new XmlTextReader("C:\\netflix.xml"); // Read until end of file while (textReader.Read()) { XmlNodeType nType = textReader.NodeType; // if node type is an element if (nType == XmlNodeType.Element) { if (textReader.Name == "title_index_item") { ParseTitleIndexItem(textReader); //countdown--; //if (countdown == 0) // break; } } } transaction.Commit(); } return; }