我想在形式组合框索引更改事件的组合框中的数据库名称 [英] i want to database name in combobox at form combobox indexed change event

问题描述

我想改变name ='gaurav'，而不是在我的文本中更改下面的visualizer plz帮助我！

i want to change name= 'gaurav' like that instead of below in my text visualizer plz help me!

SELECT id from employeemaster where name='System.Data.DataRowView'

if (comboBox1.SelectedIndex != -1)
          {
              DataTable dt = new DataTable();
              SqlCommand tempcmd = new SqlCommand("SELECT id from employeemaster where name='" + comboBox1.SelectedValue.ToString() + "'", con);
              SqlDataAdapter adp = new SqlDataAdapter(tempcmd);
              adp.Fill(dt);
              if (dt.Rows.Count > 0)
              {
                  label4.Text = dt.Rows[0]["id"].ToString();
                 // comboBox1.Text = dt.Rows[0]["specification"].ToString();

              }
              else
              {
                  label4.Text = "";
              }

推荐答案

int comboBoxID = comboBox1.SelectedIndex;
            string strId = this.comboBox1.Items[comboBoxID].ToString();

            MessageBox.Show("Select Text Is :" + strId);

您好b $ b

试试此代码..

Hi
Try this code..

private void Form1_Load(object sender, EventArgs e)
       {

           DataTable dt = new DataTable();
           dt.Columns.Add("Name", typeof(string));
           dt.Columns.Add("ID", typeof(int));
           dt.Rows.Add("aaaa", 1);
           dt.Rows.Add("bbbb", 2);
           dt.Rows.Add("cccc", 3);
           dt.Rows.Add("ddd", 4);
           dt.Rows.Add("eeee", 5);


           comboBox1.DataSource = dt.DefaultView;
           comboBox1.ValueMember = "ID";
           comboBox1.DisplayMember = "Name";



       }

       private void button1_Click(object sender, EventArgs e)
       {
           string name = ((DataRowView)comboBox1.Items[comboBox1.SelectedIndex]).Row["Name"]+"";
           int id = (int) ((DataRowView)comboBox1.Items[comboBox1.SelectedIndex]).Row["ID"];

       }

这篇关于我想在形式组合框索引更改事件的组合框中的数据库名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！