Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Data;
- using System.Data.Sql;
- using System.Data.SqlClient;
- using System.Data.SqlTypes;
- using System.IO;
- namespace copiareDaFile
- {
- class Program
- {
- static void Main(string[] args)
- {
- string fn = Environment.GetFolderPath(Environment.SpecialFolder.Desktop)+@"\dati2.txt";
- string[] arrLines = File.ReadAllLines(fn);
- SqlConnection cnn = new SqlConnection("...");
- cnn.Open();
- for (int i = 1; i < arrLines.Length; i++)
- {
- string[] arr = arrLines[i].Split(';');
- string n = arr[0];
- string c = arr[1];
- string s = "INSERT INTO TempCN(Nome,Cognome) VALUES(@Nome,@Cognome)";
- SqlCommand cmd = new SqlCommand(s, cnn);
- cmd.Parameters.AddWithValue("@Nome", n);
- cmd.Parameters.AddWithValue("@Cognome",c);
- cmd.ExecuteNonQuery();
- //SqlCommand cmd2 = new SqlCommand("TempCN_INS", cnn);
- //cmd2.CommandType = CommandType.StoredProcedure;
- //cmd2.Parameters.AddWithValue("@Nome", n);
- //cmd2.Parameters.AddWithValue("@Cognome", c);
- //cmd2.ExecuteNonQuery();
- }
- cnn.Close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment