使用表单将数据插入Access数据库时出现C＃语法错误 [英] C# Syntax Error When Insert Data Using a Form into a Access Database

问题描述

尝试使用以下代码插入数据时出现语法错误可以帮助解决此问题吗？

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

        }

推荐答案

尝试调试源代码。这应该可以让您了解错误是什么以及错误发生的位置。这可以帮助您跟踪问题的根源。

Try debugging your source code. That should give you an idea on what the error is and where it occurs. This could help you track the root of the problem.

这篇关于使用表单将数据插入Access数据库时出现C＃语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！