C#

private int? _id;

private void btnentrata_Click(object sender, EventArgs e)
{
    using (OleDbConnection cn = DataBase.CreaConnessione())
    using (OleDbCommand cmd = cn.CreateCommand())
    {
        cmd.CommandText = "INSERT INTO operai (cognome, nome, entrata) VALUES (?, ?, ?)";
        cmd.CommandType = CommandType.Text;

        // OleDbCommand doesn't use named parameters, so the names don't matter here; only the order.
        cmd.Parameters.AddWithValue("p0", txtcognome.Text);
        cmd.Parameters.AddWithValue("p1", txtnome.Text);
        cmd.Parameters.AddWithValue("p2", DateTime.Now);

        cn.Open();
        cmd.ExecuteNonQuery();
        
        cmd.CommandText = "SELECT @@IDENTITY";
        cmd.Parameters.Clear();
        _id = (int)cmd.ExecuteScalar();
    }
}

private void btuscita_Click(object sender, EventArgs e)
{
    if (_id == null)
    {
        throw new InvalidOperationException("Row not created!");
    }
    
    using (OleDbConnection cn = DataBase.CreaConnessione())
    using (OleDbCommand cmd = cn.CreateCommand())
    {
        cmd.CommandText = "UPDATE operai SET uscita = ? WHERE ID = ?";
        cmd.CommandType = CommandType.Text;

        // OleDbCommand doesn't use named parameters, so the names don't matter here; only the order.
        cmd.Parameters.AddWithValue("p0", DateTime.Now);
        cmd.Parameters.AddWithValue("p1", _id);

        cn.Open();
        cmd.ExecuteNonQuery();
    }
}

// VS2008:
tmpArr[i] = new DataClass { DoubleValue = seed++ };

// VS2005:
DataClass temp = new DataClass();
temp.DoubleValue = seed++;
tmpArr[i] = temp;

<pre>
Your code here
</pre>

Or:

```
Your code here
```

webBrowser1.Navigate("http://173.194.67.106"); 

hapiten wrote:

Can you help me?

hapiten wrote:

How to spoof ip when I click specific link on "some website" with proxy ip list
on my computer ? I have implemented the code with webBroswer control like
above but I don't know how to spoof the ip with proxy ip lists.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

private void updateIndex(int id)
{
    string update = "UPDATE questions SET indexrow=@idintrebare WHERE id=@idintrebare;";
    using (var connection = Conexiune.getConnection())
    using (SQLiteCommand cmd = new SQLiteCommand(update, connection))
    {
        connection.Open();
        cmd.Parameters.AddWithValue("@idintrebare", id);
        cmd.ExecuteNonQuery();
    }
}

string update = "UPDATE questions SET indexrow=@idintrebare WHERE id=@idintrebare;";
            using (var connection = Conexiune.getConnection())
            using (SQLiteCommand cmd = new SQLiteCommand(update, connection))
            {
                connection.Open();
                cmd.Parameters.AddWithValue("@idintrebare", idintrebare);
                cmd.ExecuteNonQuery();
            }

private static string conn = @"Data Source=database.db;Pooling=true;FailIfMissing=false;Version=3;";
        public static SQLiteConnection connect = null;
        private Conexiune() { }
        public static SQLiteConnection getConnection()
        {
            SQLiteConnection connect = null;
            try
            {
                connect = new SQLiteConnection(conn);
                connect.Open();
                return connect;
            }
            catch (SQLiteException e)
            {
                throw new Exception("Cannot connect", e);
            }
        }

string selectareLicenta = "SELECT licenta FROM licente WHERE licenta = '" + maskedTextBox1.Text + "'";
            using (SQLiteCommand cmd = new SQLiteCommand(selectareLicenta, Conexiune.getConnection()))
            {
                using (SQLiteDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (read.Read())
                    {
                        SimulatorManager.Licenta = read["licenta"].ToString();
                    }
                    read.Close();
                }
            }

string selectareLicenta = "SELECT licenta FROM licente WHERE licenta = '" + maskedTextBox1.Text + "'";
using (SQLiteConnection conn = Conexiune.getConnection())
using (SQLiteCommand cmd = new SQLiteCommand(selectareLicenta, conn))
using (SQLiteDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
    if (read.Read())
    {
        SimulatorManager.Licenta = read["licenta"].ToString();
    }
    // no need to explicitly close the reader when used in a using-block
}