C#

MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
try
{
    connection.Open();
    Console.WriteLine("Connected to DB");
}
catch (Exception e)
{
    Console.WriteLine("Failed to connect to DB");
    return;
}
command.CommandText = "truncate table test_tb";
command.ExecuteNonQuery();
connection.Close();


StreamReader sr = new StreamReader("somefile.txt", Encoding.GetEncoding(1251));
string line, query;
string[] data;
byte[] temp = new byte[10000];
int j = 0;
while ((line = sr.ReadLine()) != null && j < 10)
{
    data = line.Split('~');

    query = "insert into test_tb (name, id) values(N'" + data[2] + "'," + j.ToString() + ")";
    /*Some parsing was done here, data[2] contains 1251 encoded string*/
    temp = ASCIIEncoding.GetEncoding(1251).GetBytes(query);
    command.CommandText = ASCIIEncoding.GetEncoding(1251).GetString(temp);
    connection.Open();
    command.ExecuteNonQuery();
    connection.Close();
    ++j;
}

protected virtual void OnClick(EventArgs e)

// UserControl with TextBox dropped on and handlng the textBox's Click event
public partial class MyUserControl : UserControl
{
    public MyUserControl()
    {
        InitializeComponent();
    }

    private void textBox_Click(object sender, EventArgs e)
    {
        OnClick(e);
    }
}

//Form with MyUserControl dropped on and handling the myUserControl's Click event
public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }

    private void myUserControl_Click(object sender, EventArgs e)
    {
        MessageBox.Show("Click Event");
    }
}

TimWallace wrote:

Thanks for your reply, but you missed my point. I'm trying to design the mechanism that determines the time has been reached to process the subset of clients whose "closeout time" (a time of day) has been reached.