public void MyAction() { Dataxml data = new Dataxml(); data.AfisareStatics(); }
static void Main() { try { XmlDocument xml = new XmlDocument(); xml.Load("https://portal.vietcombank.com.vn/Usercontrols/TVPortal.TyGia/pXML.aspx"); string cnnstr; SqlConnection cnn; cnnstr = "Data Source=LAPTOP310\\SQLLUANTT;Initial Catalog='';Integrated Security=True"; cnn = new SqlConnection(cnnstr); cnn.Open(); XmlNodeList DateTimexml; DateTimexml = xml.SelectNodes("/ExrateList/DateTime"); XmlNodeList Dataxml; Dataxml = xml.SelectNodes("/ExrateList/Exrate"); for (int i = 0; i <= Dataxml.Count - 1; i++) { SqlDataAdapter da = new SqlDataAdapter("INSERT INTO TEST..VCB_EXCHANGE_RATE(DATETIME, CODE, NAME, BUY, TRANSFER, SELL) values('" + DateTimexml.Item(0).InnerText + "','" + Dataxml.Item(i).Attributes["CurrencyCode"].InnerText + "','" + Dataxml.Item(i).Attributes["CurrencyName"].InnerText + "'," + Double.Parse(Dataxml.Item(i).Attributes["Buy"].InnerText.Replace("-", "0")) + "," + Double.Parse(Dataxml.Item(i).Attributes["Transfer"].InnerText.Replace("-", "0")) + "," + Double.Parse(Dataxml.Item(i).Attributes["Sell"].InnerText.Replace("-", "0")) + ")", cnn); DataSet ds = new DataSet(); da.Fill(ds); } //MessageBox.Show("Data were added to sql server successful!"); cnn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }