Inserting value in database

Question

I'm trying to give seconden(seconds) the start value 0 in my database. This happens when I insert a row, so the seconds are set to 0.

This is what I tried:

string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|Project.mdb";
        string SqlString = "Insert Into App (Naam, Site, Plaatje, Seconden) Values (?,?,?,0)";
        try
        {
            using (OleDbConnection conn = new OleDbConnection(connect))
            {
                using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Parameters.AddWithValue("Naam", Voernaamin.Text);
                    cmd.Parameters.AddWithValue("Site", Voersitein.Text);
                    cmd.Parameters.AddWithValue("Plaatje", Voerplaatjein.Text);
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    Response.Redirect("Ingelogd2.aspx");
                }
            }

And also tried doing this: (also not working)

int nul = 0;
        string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|Project.mdb";
        string SqlString = "Insert Into App (Naam, Site, Plaatje, Seconden) Values (?,?,?,?)";
        try
        {
            using (OleDbConnection conn = new OleDbConnection(connect))
            {
                using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Parameters.AddWithValue("Naam", Voernaamin.Text);
                    cmd.Parameters.AddWithValue("Site", Voersitein.Text);
                    cmd.Parameters.AddWithValue("Plaatje", Voerplaatjein.Text);
                    cmd.Parameters.AddWithValue("Seconden", nul);
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    Response.Redirect("Ingelogd2.aspx");
                }
            }

Can someone help me out so I can Seconden to 0? Its a numeric in the database itself btw.

Answer 1

Try this..

int nul = 0;
    string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|Project.mdb";
    string SqlString = "Insert Into App (Naam, Site, Plaatje, Seconden) Values (@Naam,@Site,@Plaatje,@Seconden)";
    try
    {
        using (OleDbConnection conn = new OleDbConnection(connect))
        {
            using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
            {
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("@Naam", Voernaamin.Text);
                cmd.Parameters.AddWithValue("@Site", Voersitein.Text);
                cmd.Parameters.AddWithValue("@Plaatje", Voerplaatjein.Text);
                cmd.Parameters.AddWithValue("@Seconden", "0");
                conn.Open();
                cmd.ExecuteNonQuery();
                Response.Redirect("Ingelogd2.aspx");
            }
        }