HyugaPaolo

Import Data From txt to sql from c#

Oct 22nd, 2018
564
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.44 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.Data;
  7. using System.Data.Sql;
  8. using System.Data.SqlClient;
  9. using System.Data.SqlTypes;
  10. using System.IO;
  11.  
  12. namespace copiareDaFile
  13. {
  14.     class Program
  15.     {
  16.         static void Main(string[] args)
  17.         {
  18.  
  19.             string fn = Environment.GetFolderPath(Environment.SpecialFolder.Desktop)+@"\dati2.txt";
  20.             string[] arrLines = File.ReadAllLines(fn);
  21.             SqlConnection cnn = new SqlConnection("...");
  22.             cnn.Open();
  23.             for (int i = 1; i < arrLines.Length; i++)
  24.             {
  25.                 string[] arr = arrLines[i].Split(';');
  26.  
  27.                 string n = arr[0];
  28.                 string c = arr[1];
  29.  
  30.                 string s = "INSERT INTO TempCN(Nome,Cognome) VALUES(@Nome,@Cognome)";
  31.  
  32.                 SqlCommand cmd = new SqlCommand(s, cnn);
  33.                 cmd.Parameters.AddWithValue("@Nome", n);
  34.                 cmd.Parameters.AddWithValue("@Cognome",c);
  35.                 cmd.ExecuteNonQuery();
  36.  
  37.                 //SqlCommand cmd2 = new SqlCommand("TempCN_INS", cnn);
  38.                 //cmd2.CommandType = CommandType.StoredProcedure;
  39.  
  40.                 //cmd2.Parameters.AddWithValue("@Nome", n);
  41.                 //cmd2.Parameters.AddWithValue("@Cognome", c);
  42.                 //cmd2.ExecuteNonQuery();
  43.             }
  44.             cnn.Close();
  45.         }
  46.     }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment