C#

jacobjordan wrote:

user32 dll

jacobjordan wrote:

doesn't allow me to invoke these methods

jacobjordan wrote:

GetWindowText, and GetForegroundWindow

jacobjordan wrote:

or if nobody is logged on

jacobjordan wrote:

no matter who is logged on

if (Sender is form1)
    {
    form1 temp = (form1)Sender;
    form1.login()
}

class Login
    {
    //strings and ints here
    Form CurrentForm;

public class MyForm1 : Form, IMyCommonFormFunctionality { ... }

public interface IMyCommonFormFunctionality {
    void login();
}

IMyCommonFormFunctionality CurrentForm;
...
CurrentForm=sender as IMyCommonFormFunctionality;

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;
}