将组合框中的值成员插入C＃中的数据库 [英] Insert value member from combobox to database in C#

问题描述

我的数据库。



tbldepartment - deptcode [PK]，dept_desc

tlbcourse - coursecode，course_desc，deptcode [FK]



即使我的insertRecord（）方法有问题，请帮忙。

新手..



我尝试过：

 void loadDeparment（）
 {
尝试
 {
 SqlConnection con = new SqlConnection（cs.getConnectionString（））; 
 con.Open（）; 
 string query =SELECT deptcode，dept_desc FROM tbldepartment; 
 SqlCommand cmd = new SqlCommand（query，con）; 
 SqlDataReader dr = cmd.ExecuteReader（）; 
 DataTable dt = new DataTable（）; 
 dt.Load（dr）; 
 cbodepartment.DisplayMember =dept_desc; 
 cbodepartment.ValueMember =deptcode; 
 cbodepartment.DataSource = dt; 
} 
 catch（exception ex）
 {
 MessageBox.Show（ex.ToString（））; 
} 
} 
 
 void insertRecord（）
 {
 try 
 {
 SqlConnection con = new SqlConnection（cs.getConnectionString （））; 
 con.Open（）; 
 string query =INSERT INTO tblcourse（coursecode，course_desc，dept_code）VALUES（@ 1，@ 2，@ 3）; 
 SqlCommand cmd = new SqlCommand（query，con）; 
 cmd.Parameters.AddWithValue（@ 1，txtcoursecode.Text）; 
 cmd.Parameters.AddWithValue（@ 2，txtcoursedesc.Text）; 
 cmd.Parameters.AddWithValue（@ 3，cbodepartment.ValueMember.ToString（））; 
 cmd.ExecuteNonQuery（）; 
 MessageBox.Show（SAVED！）; 
} 
 catch（exception ex）
 {
 MessageBox.Show（ex.ToString（））; 
} 
} 
 

解决方案

 string s = Convert.ToInt32 （comboBox1.SelectedValue.ToString（））; 
 strConn = ConfigurationManager.ConnectionStrings [DefaultConnection]。ConnectionString; 
 using（SqlConnection conn = new SqlConnection（strConn））
 {
 conn.Open（）; 
 using（IDbCommand command = new SqlCommand（stp_AddComboToDatabase，conn））
 {
 command.CommandType = CommandType.StoredProcedure; 
 command.Parameters.Add（new SqlParameter（@ ID，s））; 

 cmd.Parameters。 AddWithValue（ @ 3，cbodepartment.SelectedValue）; 

my db.

tbldepartment - deptcode[PK], dept_desc
tlbcourse - coursecode, course_desc, deptcode[FK]

im having trouble with my insertRecord() method, please help.
newbie..

What I have tried:

void loadDeparment()
{
    try
    {
        SqlConnection con = new SqlConnection(cs.getConnectionString());
        con.Open();
        string query = "SELECT deptcode,dept_desc FROM tbldepartment";
        SqlCommand cmd = new SqlCommand(query, con);
        SqlDataReader dr = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        dt.Load(dr);
        cbodepartment.DisplayMember = "dept_desc";
        cbodepartment.ValueMember = "deptcode";
        cbodepartment.DataSource = dt;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.ToString());
    }
}

void insertRecord()
{
    try
    {
        SqlConnection con = new SqlConnection(cs.getConnectionString());
        con.Open();
        string query = "INSERT INTO tblcourse (coursecode,course_desc,dept_code)VALUES(@1,@2,@3)";
        SqlCommand cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithValue("@1",txtcoursecode.Text);
        cmd.Parameters.AddWithValue("@2",txtcoursedesc.Text);
        cmd.Parameters.AddWithValue("@3",cbodepartment.ValueMember.ToString());
        cmd.ExecuteNonQuery();
        MessageBox.Show("SAVED!");
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.ToString());
    }
}

解决方案

string s = Convert.ToInt32(comboBox1.SelectedValue.ToString());
strConn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();
                    using (IDbCommand command = new SqlCommand("stp_AddComboToDatabase", conn))
                    {
                        command.CommandType = CommandType.StoredProcedure;
                        command.Parameters.Add(new SqlParameter("@ID",s));

cmd.Parameters.AddWithValue("@3",cbodepartment.SelectedValue);

这篇关于将组合框中的值成员插入C＃中的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！