使用组合框插入值的问题 [英] problem in inserting value using combobox

问题描述

private void button3_Click(object sender, EventArgs e)
        {
            
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\imran\Documents\Visual Studio 2010\Projects\CompleteProject\CompleteProject\Garments.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            con.Open();
            SqlCommand cmd = new SqlCommand(" INSERT INTO OrderStyle (OrderNo,ProductId,SizeId,ColorId,Description) VALUES ('" + comboBox1.SelectedItem.ToString() + "','" + comboBox2.SelectedItem.ToString() + "','" + comboBox3.SelectedItem.ToString() + "','" + comboBox4.SelectedItem.ToString() + "','" + textBox1.Text + "')", con);
            cmd.ExecuteNonQuery();
            con.Close();
            displayRecords();

        }

请帮助任何人无法使用此代码使用combobox将数据插入数据库。

please help anyone i can't able to insert data into database using this code using combobox.

推荐答案

private void button3_Click(object sender, EventArgs e)
        {
            
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\imran\Documents\Visual Studio 2010\Projects\CompleteProject\CompleteProject\Garments.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            con.Open();
            SqlCommand cmd = new SqlCommand(" INSERT INTO OrderStyle (OrderNo,ProductId,SizeId,ColorId,Description) VALUES (@OrderNo,@ProductId,@SizeId,@ColorId,@Description)", con);

cmd.Parameters.Add(@OrderNo,SqlDbType.Int);
cmd.Parameters.Add(@ProductId,SqlDbType.Int);
cmd.Parameters.Add(@SizeId,SqlDbType.Int);
cmd.Parameters.Add(@ColorId,SqlDbType.Int);
cmd.Parameters.Add(@Description,SqlDbType.NVarChar);
cmd.Parameters["@OrderNo"].Value=int.Parse(comboBox1.SelectedValue.ToString());
cmd.Parameters["@ProductId"].Value=int.Parse(comboBox2.SelectedValue.ToString());
cmd.Parameters["@SizeId"].Value=int.Parse(comboBox3.SelectedValue.ToString());
cmd.Parameters["@ColorId"].Value=int.Parse(comboBox4.SelectedValue.ToString());
cmd.Parameters["@Description"].Value=textBox1.Text;

            cmd.ExecuteNonQuery();
            con.Close();
            displayRecords();
 
        }

这篇关于使用组合框插入值的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！