I get a syntax error when try to insert datas using following code can any help to solve this problem?
con = new OleDbConnection(cs);
con.Open();
string cb = "insert into Users(UserID,UserName,UserType,Cluster,Password,Email) VALUES (@d1,@d2,@d3,@d4,@d5,@d6)";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add(new OleDbParameter("@d1", OleDbType.Char, 30, "UserID"));
cmd.Parameters.Add(new OleDbParameter("@d2", OleDbType.Char, 30, "UserName"));
cmd.Parameters.Add(new OleDbParameter("@d3", OleDbType.Char, 10, "UserType"));
cmd.Parameters.Add(new OleDbParameter("@d4", OleDbType.Char, 30, "Cluster"));
cmd.Parameters.Add(new OleDbParameter("@d5", OleDbType.Char, 30, "Password"));
cmd.Parameters.Add(new OleDbParameter("@d6", OleDbType.Char, 30, "Email"));
cmd.Parameters["@d1"].Value = TxtUID.Text.Trim();
cmd.Parameters["@d2"].Value = TxtUname.Text;
cmd.Parameters["@d3"].Value = CmbUtype.Text;
cmd.Parameters["@d4"].Value = CmbCluster.Text;
cmd.Parameters["@d5"].Value = TxtPw.Text;
cmd.Parameters["@d6"].Value = TxtEml.Text;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("Successfully Registered", "User", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}