允许通过组合框下拉列表添加新记录-解网

问：

我有 Combobox，这是来自客户表的数据源

combo_customers.DataSource = AddingDebit_con.Get_All_Customers();
combo_customers.DisplayMember = "customer_fullname";
combo_customers.ValueMember = "customer_id";

AddingDebit_con是 .cs 文件包含以下代码

public DataTable Get_All_Customers()
{
    DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
    DAL.Open();
    DataTable dt = new DataTable();
    dt = DAL.SelectData("All_customers", null);
    return dt;
}

DAL是包含 sql-connection 的文件夹DataAccessLayer.cs

All_customers是一个 SQL 服务器过程，如下所示

ALTER proc [dbo].[All_customers] AS select customer_fullname,customer_id from Customers

上面的一切都按照我的意愿工作，但客户问我是否可以直接从组合框添加新客户，以防客户未在表源中列出（组合框下拉列表）

Combobox 显示成员（Customer_name）但插入值 （customer_id） 的问题！

C# SQL 服务器

if (combo_customers.SelectedValue == null )
{
    // first get the value of new customer's ID which = last ID+1
    int amount = Convert.ToInt32(CustomersMangment.dgv_search.Rows[CustomersMangment.dgv_search.Rows.Count - 2].Cells[0].Value);
    int total = amount + 1;
     
    addingCustomers.tb_phone.Text = "";
    addingCustomers.comb_addess.Text = "text";
    addingCustomers.tb_CustomerName.Text = combo_customers.Text;
    addingCustomers.dtp_addingDate.Value = DateTime.Now;
    AddingDebit_con.InsertCustomer(addingCustomers.tb_CustomerName.Text, addingCustomers.tb_phone.Text, addingCustomers.comb_addess.Text, addingCustomers.dtp_addingDate.Value);
    //2nd reload the form to reload combobox items
    AddinDebits_Load(null, EventArgs.Empty);
    combo_customers.SelectedValue = total;

    // Adding cmd
    AddingDebit_con.AddingNewDebit(int.Parse(combo_customers.SelectedValue.ToString()), dtp_addingDebit.Value, Convert.ToInt32(tb_amount.Text));
    MessageBox.Show("done");
    tb_amount.Text = "";
    tb_date.Text = "";
    dtp_addingDebit.Value = DateTime.Now;

    //Refresh 
    this.dgv_withdraw.DataSource = AddingDebit_con.DataGrid_Withdraw();
    lbl_total.Text = combo_withdrawTotal.Text;
 }

 else { 
     AddingDebit_con.AddingNewDebit(int.Parse(combo_customers.SelectedValue.ToString()), dtp_addingDebit.Value, Convert.ToInt32(tb_amount.Text));

     MessageBox.Show("done");
     tb_amount.Text = "";
     tb_date.Text = "";
     dtp_addingDebit.Value = DateTime.Now;

     //Refresh 
     this.dgv_withdraw.DataSource = AddingDebit_con.DataGrid_Withdraw();
      lbl_total.Text = combo_withdrawTotal.Text;
 }

感谢您对 Stack Overflow 社区的贡献。这可能是一个正确的答案，但提供代码的额外解释，以便开发人员能够理解你的推理，这将是非常有用的。这对于不熟悉语法或难以理解概念的新开发人员特别有用。为了社区的利益，您能否编辑您的答案以包含其他详细信息？

上一个：为什么 Visual Studio 2022 建议IDE0251将方法设置为只读？

下一个：实体框架问题中的 OUTPUT 子句

允许通过组合框下拉列表添加新记录

Allow add new record through combobox dropdown list

评论

评论