ExecuteNonQuery 溢出错误？

Question

我一直在试图找出代码有什么问题。

我想做的是有两个用于性别的单选按钮，男性和男性。女性...

我希望当单击“男性”单选按钮时，将文本“男性”保存到性别字段中的数据库中（如果是文本类型），但我收到了溢出错误...

在添加单选按钮和 [性别] 字段，一切正常...

那么有什么帮助吗？

    using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace OfflineRF
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        string gender;

        private void button1_Click(object sender, EventArgs e)
        {
            string ORF1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\\OfflineRF.mdb";
            OleDbConnection conn = new OleDbConnection(ORF1);
            conn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            cmd.CommandText = "INSERT INTO OFFRF([Fname], [Lname], [NIC], [Gender], [HomeTel], [Cellphone], [Passengers], [From], [To])VALUES('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + textBox7.Text + textBox8.Text +"','"+gender+"','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + comboBox1.Text + "','" + comboBox2.Text + "')";
            cmd.ExecuteNonQuery();
            conn.Close();
            System.Windows.Forms.MessageBox.Show("Form Saved Successfully !", "Caption", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);

            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            textBox6.Text = "";
            textBox7.Text = "";
            textBox8.Text = "";
            comboBox1.SelectedIndex = -1;
            comboBox2.SelectedIndex = -1;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (comboBox1.Text == "Karachi")
            {
                comboBox2.Items.Clear();
                comboBox2.Items.Add("Sukkur");
                comboBox2.Items.Add("Hyderabad");
            }
            else if (comboBox1.Text == "Sukkur")
            {
                comboBox2.Items.Clear();
                comboBox2.Items.Add("Karachi");
                comboBox2.Items.Add("Hyderabad");
            }
            else
            {
                comboBox2.Items.Clear();
                comboBox2.Items.Add("Karachi");
                comboBox2.Items.Add("Sukkur");
            }
        }

        private void Male_CheckedChanged(object sender, EventArgs e)
        {
            if (Male.Checked)
                gender = "Male";
            else
                gender = "Female";
        }

    }
}

Answer 1

你有一个无限循环。当组合框更改时，将引发 selectedindex 事件，然后更改组合框并再次触发该事件。

编辑...

在按钮事件处理程序的末尾，您再次更改组合框索引，导致事件触发的无限循环以及随后的堆栈溢出

Answer 2

除了通过在连接的字符串中添加值来进行 SQL 注入的可能性之外，如果有人输入像“O'Conner”这样的名称值，其中名称中的引号会终止字符串并抛出休息一下。

查看 OleDbParameter 对象并设置它们。如果没有精确的语法，你会做类似的事情

string ORF1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\\OfflineRF.mdb";
OleDbConnection conn = new OleDbConnection(ORF1);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO OFFRF( Fname, Lname, NIC, Gender, HomeTel, "
           + "Cellphone, Passengers, [From], [To] ) VALUES "
           + "(  ?, ?, ?, ?, ?, ?, ?, ?, ? )";
// Add parameters in same ordinal position as the "?" place-holders
// the first parameter is more of generic description of WHAT it is for and 
// does NOT have to exactly match the column name, the second parameter is
// the actual value that should be put into the database.  This same context
// is used for performing other SQL actions (select, delete, update, etc)
// to help prevent SQL injection.
cmd.Parameters.Add( "valForFName", textBox1.Text );
cmd.Parameters.Add( "valForLName", textBox2.Text );
cmd.Parameters.Add( "valForNIC", textBox3.Text + textBox7.Text + textBox8.Text );
// Not sure of syntax here, but get proper text from your radio choice of gender into string
gender = YourForm.RadioForGender.SelectedItem.Text;  
cmd.Parameters.Add( "valForGender", gender );
cmd.Parameters.Add( "valHomePhone", textBox4.Text );
cmd.Parameters.Add( "valCell", textBox5.Text );
cmd.Parameters.Add( "howmany", textBox6.Text );
cmd.Parameters.Add( "forFromValue", comboBox1.Text );
cmd.Parameters.Add( "forToValue",  comboBox2.Text );
cmd.ExecuteNonQuery();
conn.Close();