Click here to Skip to main content
15,902,636 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
This is my code
C#
public void InsertData(string nim, string name,string angkatan, string thn_msk, string kota_asal)
        {
            using (OleDbConnection con = new OleDbConnection(ConString))
            {
                CmdString = "INSERT INTO MHS (NIM, Nama, Angkatan, [Tahun Masuk], [Kota Asal], [Jenis Kelamin]) VALUES (@NIM, @Nama, @Angkatan, @([Tahun Masuk]), @([Kota Asal]))";
                OleDbCommand cmd = new OleDbCommand(CmdString, con);
                cmd.Parameters.AddWithValue("@NIM", nim);
                cmd.Parameters.AddWithValue("@Nama", name);
                cmd.Parameters.AddWithValue("@Angkatan", angkatan);
                cmd.Parameters.AddWithValue("@([Tahun Masuk])", thn_msk);
                cmd.Parameters.AddWithValue("@([Kota Asal])", kota_asal);
                try
                {
                con.Open();
                MessageBox.Show("Sukses");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(Convert.ToString(ex));
                }
                cmd.ExecuteNonQuery();
                con.Close();

can someone help me or explain me why?
Posted

1 solution

Your insert query is wrong

Look at this:
SQL
INSERT INTO MHS (NIM, Nama, Angkatan, [Tahun Masuk], [Kota Asal], [Jenis Kelamin]) 
        VALUES (@NIM, @Nama, @Angkatan, @([Tahun Masuk]), @([Kota Asal]))


There are 6 columns but value you are passing is 5
 
Share this answer
 
v2
Comments
Maciej Los 31-Mar-14 3:20am    
Hawk eye ;)
Tom Marvolo Riddle 31-Mar-14 3:30am    
Thank you Maciej Los :)
King Fisher 31-Mar-14 3:24am    
nice catch
Tom Marvolo Riddle 31-Mar-14 3:31am    
:)
Famsila 31-Mar-14 3:48am    
nice sir :)
thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900