string filepath = @"C:\Documents and Settings\jitendra\Desktop\RIC_SELL_080209.csv";
            int i = 0;         
            StreamReader sr = new StreamReader(filepath);
            string line = sr.ReadLine();
            string[] value = line.Split(',');
            DataTable dt = new DataTable();
            DataRow row ;
            foreach (string dc in value)
            {
                dt.Columns.Add(new DataColumn());
            }
            do
            {
                row = dt.NewRow();
                row.ItemArray = line.Split();
                dt.Rows.Add(row);
                i = i + 1;
                line = sr.ReadLine();
            }
            while (line != string.Empty);
            SqlBulkCopy bc = new SqlBulkCopy(con.ToString(), SqlBulkCopyOptions.TableLock);
            bc.DestinationTableName = "mytable";
            bc.BatchSize = dt.Rows.Count;
            con.Open();
            bc.WriteToServer(dt);
            bc.Close();
            con.Close();

private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=SHAWHP\SQLEXPRESS;Initial Catalog=FOO;Persist Security Info=True;User ID=sa");
            string filepath = "C:\\params.csv";
            StreamReader sr = new StreamReader(filepath);
            string line = sr.ReadLine();
            string[] value = line.Split(',');
            DataTable dt = new DataTable();
            DataRow row;
            foreach (string dc in value)
            {
                dt.Columns.Add(new DataColumn(dc));
            }
 
            while ( !sr.EndOfStream )
            {
                value = sr.ReadLine().Split(',');
                if(value.Length == dt.Columns.Count)
                {
                    row = dt.NewRow();
                    row.ItemArray = value;
                    dt.Rows.Add(row);
                }
            }
            SqlBulkCopy bc = new SqlBulkCopy(con.ConnectionString, SqlBulkCopyOptions.TableLock);
            bc.DestinationTableName = "tblparam_test";
            bc.BatchSize = dt.Rows.Count;
            con.Open();
            bc.WriteToServer(dt);
            bc.Close();
            con.Close(); 
        }

 
 static void Main(string[] args)
        {
            string connectionstring = @"Data Source=ACC-222\SQLEXPRESS;Initial Catalog=mydata;Integrated Security=True";
 
            SqlConnection con = new SqlConnection(connectionstring);
            con.Open();
 
            SqlCommand mycount = new SqlCommand("select count(*) from dbo.mytable",con);
 
            long countstart = Convert.ToInt32(mycount.ExecuteScalar());
 
            Console.WriteLine("stating row count={0}", mycount);
 
 
 
            DbConnectionStringBuilder csb = new DbConnectionStringBuilder();
 
            csb["Provider"] = "Microsoft.Jet.OLEDB.4.0";
 
            csb["Data Source"] = @"C:\Documents and Settings\jitendra\Desktop";
 
            csb["Extended Properties"] = "Text;HDR=NO";
 
            string cs = csb.ConnectionString;
 
            OleDbConnection txtconnection = new OleDbConnection(cs);  
 
            txtconnection.Open();  
 
            OleDbCommand mycommand = new OleDbCommand("Select * from RIC_customer_20080318.csv", txtconnection);
 
            OleDbDataReader dr = mycommand.ExecuteReader(CommandBehavior.SequentialAccess);
 
            SqlConnection seccon = new SqlConnection(connectionstring);
 
            seccon.Open();
 
            SqlBulkCopy bc = new SqlBulkCopy(seccon);
 
            bc.DestinationTableName = "dbo.mytable";
 
            try
            {
                bc.WriteToServer(dr);
 
            }
            catch (SqlException se)
            {
                StreamWriter sr = new StreamWriter(@"C:\error.txt");
 
                Console.WriteLine(se.ToString());
                sr.WriteLine(se.ToString());
                Console.ReadLine();
            }
            dr.Close();
 
            long countend = Convert.ToInt32(mycount.ExecuteScalar());
 
            Console.WriteLine("Ending row count = {0}", countend);
 
            Console.WriteLine("{0} rows were added.", countend - countstart);
 
        }