Hello,
You can use
SQLCommand[
^] to do this. Below code snippet will give you an idea.
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
namespace ConsoleApplication10
{
class Program
{
static void Main(string[] args)
{
SqlConnection con;
SqlCommand cmd;
var reader = new StreamReader(File.OpenRead(@"c:\users\afshandc\documents\visual studio 2012\Projects\ConsoleApplication10\ConsoleApplication10\ex.csv"));
List headers = new List();
con = new SqlConnection(conString);
cmd = new SqlCommand("INSERT INTO Currency(code, buying, selling) VALUES(@ccyCode, @buyRate, @sellRate)", con);
cmd.Parameters.Add("@ccyCode", SqlDbType.VarChar);
cmd.Parameters.Add("@buyRate", SqlDbType.Decimal);
cmd.Parameters.Add("@sellRate", SqlDbType.Decimal);
con.Open();
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(',');
Console.WriteLine(values[0].ToString() + "," + values[1].ToString() + "," + values[2].ToString());
cmd.Parameters[0].value = values[0];
cmd.Parameters[1].value = Convert.ToDecimal(values[1]);
cmd.Parameters[2].value = Convert.ToDecimal(values[2]);
cmd.ExecuteNonQuery();
}
Console.ReadLine();
con.Close();
}
}
}
TODO :Add necessary error handling
Regards,