Combobox值到数据库sql [英] Combobox value to database sql

问题描述

您好，



我正在尝试使用3层业务逻辑将组合框值传递给数据库。目前，我的表单页面如下所示：

Hello,

I am trying to pass combobox value to a database, using a 3 tier business logic. Currently my form page looks like this:

private void Savebtn_Click(object sender, EventArgs e)
        {
            try
            {
                SaveRole(tbroledesc.Text, /*combobox selected item gets passed here*/);
                MessageBox.Show("Club role saved successfully");
            }
            catch (Exception er)
            {
                MessageBox.Show(er.Message.ToString());
            }
        }

        public void SaveRole(string RoleDesc, /*combobox selecteditem*/)
        {
            ClubRoles cr = new ClubRoles();
            RoleCreatedBy = Convert.ToInt32(lstcreatedby.SelectedItem);

            cr.insertingclubroles(RoleDesc, RoleCreatedBy);

            gettingclubroles();     //refresh the list   
        }

我如何将组合框中选择的内容作为参数传递给它？



我正在填充组合框这个：

How can I pass what ever is selected in the combobox drop down as the parameter?

I am filling the combobox like this:

private void loadclient()
        {           
            DataSet dsloadclient;
            dsloadclient = new ClubRoles().createdby();

            //need fix duplicate values
            DataTable dt = dsloadclient.Tables[0].DefaultView.ToTable(true, "ClientName", "ClientId");
            lstcreatedby.DataSource = dt;
            lstcreatedby.DisplayMember = "ClientName";
            lstcreatedby.ValueMember = "ClientId";
        }

任何帮助将不胜感激。



谢谢。

Any help will be appreciated.

Thanks.

推荐答案

像这样修改代码................. 。

获取你应该只使用SelectedValue的值因为你只在值字段中绑定ClientId

Modify your code like this way..................
to get the values you should use only SelectedValue because you bind the ClientId in value field only

public void SaveRole(string RoleDesc, /*combobox selecteditem*/)
      {
          ClubRoles cr = new ClubRoles();
         if (lstcreatedby.SelectedIndex > 0)
              {
        RoleCreatedBy = Convert.ToInt32(lstcreatedby.SelectedValue);
         cr.insertingclubroles(RoleDesc, RoleCreatedBy);
           }

      

        gettingclubroles();     //refresh the list
    }

private void loadclient()
        {           
            DataSet dsloadclient;
            dsloadclient = new ClubRoles().createdby();
 
            //need fix duplicate values
            DataTable dt = dsloadclient.Tables[0].DefaultView.ToTable(true, "ClientName", "ClientId");
            lstcreatedby.DataSource = dt;
            lstcreatedby.DataTextField= "ClientName";
            lstcreatedby.DataValueField= "ClientId";
        }

您可以使用intellisense学到很多东西。



要获取所选项目，请使用SelectedItem属性 http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.selecteditem（v = vs.110） .aspx [ ^ ]

You can learn a lot by using intellisense.

To get the selected item, use the SelectedItem property, http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.selecteditem(v=vs.110).aspx[^]

这篇关于Combobox值到数据库sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！