C#

public class MyClassWithEvent
{
  public event EventHandler MyEvent


  protected virtual void OnMyEvent(EventArgs e)
  {
    if(MyEvent != null)
    {
       MyEvent(this,e);
    }
  }
}

public void DoSomethingAndRaiseMyEvent()
{
   // do something here
  this.OnMyEvent(EventArgs.Empty);
}

umaheshchandra wrote:

send me the code

field_name1 | field_name2 | field_name3
---------------------------------------
values      | values      | values

using Microsoft.Data.Odbc;
using System.Data;

....some code...

DataTable dt = new DataTable();
OdbcDataAdapter adapter;
OdbcConnection csvDB;

csvDB = new OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)}; Readonly=true;DBQ=[dir where is your file]");
adapter = new OdbcDataAdapter("SELECT * FROM [filename].csv", csvDB);
adapter.Fill(dt);

foreach(DataRow dr in dt.Rows)
{
    .....
    with INSERT queries put it to your SQL DB.
}