C#

public XmlNodeList XmlListesi()
       {
           XmlDocument doc = new XmlDocument();
           doc.Load("http://cekilis.millipiyango.gov.tr/haftalik_loto_bilgileri.xml");
           XmlElement root = doc.DocumentElement;
           XmlNodeList elemlist = root.GetElementsByTagName("haftalik_loto_bilgileri");
           return elemlist;
       }

       public  DataTable ConvertXmlNodeListToDataTable(XmlNodeList xnl)
       {
           DataTable tablo = new DataTable();
           int TempColumn = 0;

           foreach (XmlNode item in xnl.Item(0).ChildNodes)
           {
               TempColumn++;
               DataColumn dc = new DataColumn(item.Name, System.Type.GetType("System.String"));
               if (tablo.Columns.Contains(item.Name))
                   tablo.Columns.Add(dc.ColumnName = dc.ColumnName + TempColumn.ToString());
               else
                   tablo.Columns.Add(dc);
           }

           int ColumnsCount = tablo.Columns.Count;
           for (int i = 0; i < xnl.Count; i++)
           {
               DataRow dr = tablo.NewRow();
               for (int j = 0; j < ColumnsCount; j++)
               {
                   try
                   {
                       dr[j] = xnl.Item(i).ChildNodes[j].InnerText;
                   }
                   catch (Exception)
                   { }
               }
               tablo.Rows.Add(dr);
           }
           return tablo;
       }

       public  void  InsertSayisal(DataTable dt)
       {
           cmd = dal.InsertSayisal();
           cmd.Parameters.AddWithValue("@cek_no", System.Data.SqlDbType.Int);
           cmd.Parameters.AddWithValue("@cek_tarih", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@num1", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@num2", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@num3", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@num4", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@num5", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@num6", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@altibln", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@besbln", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@dortbln", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@ucbln", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@alti_ikr", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@bes_ikr", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@dort_ikr", System.Data.SqlDbType.NVarChar);
           cmd.Parameters.AddWithValue("@uc_ikr", System.Data.SqlDbType.NVarChar);

           for (int i = 0; i < dt.Rows.Count; i++)
           {
               cmd.Parameters["@cek_no"].Value = dt.Rows[i][0].ToString();
               cmd.Parameters["@cek_tarih"].Value = dt.Rows[i][1].ToString();
               cmd.Parameters["@num1"].Value = dt.Rows[i][4].ToString();
               cmd.Parameters["@num2"].Value = dt.Rows[i][5].ToString();
               cmd.Parameters["@num3"].Value = dt.Rows[i][6].ToString();
               cmd.Parameters["@num4"].Value = dt.Rows[i][7].ToString();
               cmd.Parameters["@num5"].Value = dt.Rows[i][8].ToString();
               cmd.Parameters["@num6"].Value = dt.Rows[i][9].ToString();
               cmd.Parameters["@altibln"].Value = dt.Rows[i][10].ToString();
               cmd.Parameters["@besbln"].Value = dt.Rows[i][11].ToString();
               cmd.Parameters["@dortbln"].Value = dt.Rows[i][12].ToString();
               cmd.Parameters["@ucbln"].Value = dt.Rows[i][13].ToString();
               cmd.Parameters["@alti_ikr"].Value = dt.Rows[i][14].ToString();
               cmd.Parameters["@bes_ikr"].Value = dt.Rows[i][15].ToString();
               cmd.Parameters["@dort_ikr"].Value = dt.Rows[i][16].ToString();
               cmd.Parameters["@uc_ikr"].Value = dt.Rows[i][17].ToString();
               try
               {
                   cmd.ExecuteNonQuery();
               }
               catch (SqlException)
               {
                   //MessageBox.Show(ex.Message);
               }
           }
       }