How to bind data toa combobox from a table in SQL server WPF C#

Question

0.00/5 (No votes)

See more:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;


namespace Restaurant_Application
{
    /// <summary>
    /// Interaction logic for Employe_page.xaml
    /// </summary>
    public partial class Employe_page : Window
    {
        string ConnectionString = @"Data Source=DESKTOP-89MGP64;Initial Catalog=new_restaurant_application;Integrated Security=True";
        public Employe_page()
        {
            InitializeComponent();
            WindowState = WindowState.Maximized;
            WindowStyle = WindowStyle.None;
            BindComboBox();
            buffercombo();
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {

            try
            {
                SqlConnection con = new SqlConnection(ConnectionString);
                con.Open();
                int id = int.Parse(txtUserId.Text);
                string branch = cmboBranch.SelectedValuePath, emp_name = cmboSelEmp.Text, user_type = cmboSelUser.Text, user_name = txtUsername.Text, password = txtPassword.Password.ToString();
                SqlCommand cmd = new SqlCommand(" insert_user '" + id+"','"+user_name+"','"+password+"','"+user_type+"','"+branch+"','"+ emp_name + "'", con);
                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("user_id", txtUserId.Text);
                //cmd.Parameters.AddWithValue("emp_id", cmboSelEmp.SelectedValue);
                //cmd.Parameters.AddWithValue("emp_name", cmboSelEmp.Text);
                //cmd.Parameters.AddWithValue("user_type", cmboSelUser.Text);
                //cmd.Parameters.AddWithValue("privilege", cmboSelUser.SelectedValue);
                //cmd.Parameters.AddWithValue("user_name", txtUsername.Text);
                //cmd.Parameters.AddWithValue("password", txtPassword.Password.ToString());
                //cmd.Parameters.AddWithValue("branch", cmboBranch.Text);
               
                cmd.ExecuteNonQuery();
                con.Close();

                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("user_id", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(txtUserId.Text) ? DBNull.Value : (object)txtUserId.Text;
                //cmd.Parameters.AddWithValue("emp_id", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelEmp.Text) ? DBNull.Value : (object)cmboSelEmp.SelectedValue;
                //cmd.Parameters.AddWithValue("emp_name", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelEmp.Text) ? DBNull.Value : (object)cmboSelEmp.Text;
                //cmd.Parameters.AddWithValue("user_type", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelUser.Text) ? DBNull.Value : (object)cmboSelUser.Text;
                //cmd.Parameters.AddWithValue("privilege", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelUser.Text) ? DBNull.Value : (object)cmboSelUser.SelectedValue;
                //cmd.Parameters.AddWithValue("user_name", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(txtUsername.Text) ? DBNull.Value : (object)txtUsername.Text;
                //cmd.Parameters.AddWithValue("password", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(txtPassword.Password) ? DBNull.Value : (object)txtPassword.Password;
                //cmd.Parameters.AddWithValue("branch", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboBranch.Text) ? DBNull.Value : (object)cmboBranch.Text;
                //cmd.ExecuteNonQuery();
                //con.Close();
               
                MessageBox.Show("Saved");
            


            }
            catch ( SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }

        }
      
        private void BindComboBox()
        {
            //try
            //{
            //    using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-89MGP64;Initial Catalog = new_restaurant_application;Integrated Security = True"))
            //    {
            //        conn.Open();
            //        SqlDataAdapter ProjectTableTableAdapter = new SqlDataAdapter("SELECT eid FROM add_employee", conn);
            //        DataSet ds = new DataSet();

            //        ProjectTableTableAdapter.Fill(ds, "add_employee");

            //        cmboSelUser.ItemsSource = ds.Tables["add_employee"].DefaultView;
            //        cmboSelUser.DisplayMemberPath = "name";
            //        cmboSelUser.SelectedValuePath = "eid";
            //    }
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.ToString());
            //}
           

            SqlConnection con = new SqlConnection(ConnectionString);
            cmboSelUser.Items.Clear();
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select privilege  from user_privilege";
            cmd.ExecuteNonQuery();
            DataTable dt = new DataTable();
            
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            
            foreach (DataRow dr in dt.Rows)
            {
                cmboSelUser.Items.Add(dr["privilege"].ToString());
                cmboSelUser.ItemsSource = ((IListSource)dt).GetList();
                cmboSelUser.DisplayMemberPath = "privilege";
                cmboSelUser.SelectedValuePath = "id";
               
            }
         
            con.Close();
        }
        private void buffercombo()
        {
            SqlConnection con = new SqlConnection(ConnectionString);
            cmboSelEmp.Items.Clear();
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select name  from add_employee";
            cmd.ExecuteNonQuery();
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            foreach (DataRow dr in dt.Rows)
            {
                cmboSelEmp.Items.Add(dr["name"].ToString());
                cmboSelEmp.DisplayMemberPath = "name";
                cmboSelEmp.SelectedValuePath = "eid";

            }
            con.Close();
        }

    private void Button_Click1(object sender, RoutedEventArgs e)
        {
            this.Close();
        }

    }

}

What I have tried:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;


namespace Restaurant_Application
{
    /// <summary>
    /// Interaction logic for Employe_page.xaml
    /// </summary>
    public partial class Employe_page : Window
    {
        string ConnectionString = @"Data Source=DESKTOP-89MGP64;Initial Catalog=new_restaurant_application;Integrated Security=True";
        public Employe_page()
        {
            InitializeComponent();
            WindowState = WindowState.Maximized;
            WindowStyle = WindowStyle.None;
            BindComboBox();
            buffercombo();
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {

            try
            {
                SqlConnection con = new SqlConnection(ConnectionString);
                con.Open();
                int id = int.Parse(txtUserId.Text);
                string branch = cmboBranch.SelectedValuePath, emp_name = cmboSelEmp.Text, user_type = cmboSelUser.Text, user_name = txtUsername.Text, password = txtPassword.Password.ToString();
                SqlCommand cmd = new SqlCommand(" insert_user '" + id+"','"+user_name+"','"+password+"','"+user_type+"','"+branch+"','"+ emp_name + "'", con);
                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("user_id", txtUserId.Text);
                //cmd.Parameters.AddWithValue("emp_id", cmboSelEmp.SelectedValue);
                //cmd.Parameters.AddWithValue("emp_name", cmboSelEmp.Text);
                //cmd.Parameters.AddWithValue("user_type", cmboSelUser.Text);
                //cmd.Parameters.AddWithValue("privilege", cmboSelUser.SelectedValue);
                //cmd.Parameters.AddWithValue("user_name", txtUsername.Text);
                //cmd.Parameters.AddWithValue("password", txtPassword.Password.ToString());
                //cmd.Parameters.AddWithValue("branch", cmboBranch.Text);
               
                cmd.ExecuteNonQuery();
                con.Close();

                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("user_id", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(txtUserId.Text) ? DBNull.Value : (object)txtUserId.Text;
                //cmd.Parameters.AddWithValue("emp_id", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelEmp.Text) ? DBNull.Value : (object)cmboSelEmp.SelectedValue;
                //cmd.Parameters.AddWithValue("emp_name", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelEmp.Text) ? DBNull.Value : (object)cmboSelEmp.Text;
                //cmd.Parameters.AddWithValue("user_type", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelUser.Text) ? DBNull.Value : (object)cmboSelUser.Text;
                //cmd.Parameters.AddWithValue("privilege", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboSelUser.Text) ? DBNull.Value : (object)cmboSelUser.SelectedValue;
                //cmd.Parameters.AddWithValue("user_name", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(txtUsername.Text) ? DBNull.Value : (object)txtUsername.Text;
                //cmd.Parameters.AddWithValue("password", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(txtPassword.Password) ? DBNull.Value : (object)txtPassword.Password;
                //cmd.Parameters.AddWithValue("branch", SqlDbType.NVarChar).Value = string.IsNullOrWhiteSpace(cmboBranch.Text) ? DBNull.Value : (object)cmboBranch.Text;
                //cmd.ExecuteNonQuery();
                //con.Close();
               
                MessageBox.Show("Saved");
            


            }
            catch ( SqlException ex)
            {

                MessageBox.Show(ex.Message);
            }

        }
      
        private void BindComboBox()
        {
            //try
            //{
            //    using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-89MGP64;Initial Catalog = new_restaurant_application;Integrated Security = True"))
            //    {
            //        conn.Open();
            //        SqlDataAdapter ProjectTableTableAdapter = new SqlDataAdapter("SELECT eid FROM add_employee", conn);
            //        DataSet ds = new DataSet();

            //        ProjectTableTableAdapter.Fill(ds, "add_employee");

            //        cmboSelUser.ItemsSource = ds.Tables["add_employee"].DefaultView;
            //        cmboSelUser.DisplayMemberPath = "name";
            //        cmboSelUser.SelectedValuePath = "eid";
            //    }
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.ToString());
            //}
           

            SqlConnection con = new SqlConnection(ConnectionString);
            cmboSelUser.Items.Clear();
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select privilege  from user_privilege";
            cmd.ExecuteNonQuery();
            DataTable dt = new DataTable();
            
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            
            foreach (DataRow dr in dt.Rows)
            {
                cmboSelUser.Items.Add(dr["privilege"].ToString());
                cmboSelUser.ItemsSource = ((IListSource)dt).GetList();
                cmboSelUser.DisplayMemberPath = "privilege";
                cmboSelUser.SelectedValuePath = "id";
               
            }
         
            con.Close();
        }
        private void buffercombo()
        {
            SqlConnection con = new SqlConnection(ConnectionString);
            cmboSelEmp.Items.Clear();
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select name  from add_employee";
            cmd.ExecuteNonQuery();
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            foreach (DataRow dr in dt.Rows)
            {
                cmboSelEmp.Items.Add(dr["name"].ToString());
                cmboSelEmp.DisplayMemberPath = "name";
                cmboSelEmp.SelectedValuePath = "eid";

            }
            con.Close();
        }

    private void Button_Click1(object sender, RoutedEventArgs e)
        {
            this.Close();
        }

    }

}

Posted 30-Aug-22 20:19pm

prashanth manoj

Add a Solution

Comments

CHill60 31-Aug-22 3:22am

That's a lot of code and your sql is at risk of SQL Injection attack. What is your question, where is the problem in your code?

prashanth manoj 31-Aug-22 3:59am

BindComboBox()
buffercombo()

how to data bring from databse to other table coloumn in c# wpf

prashanth manoj 31-Aug-22 4:15am

stored procedure insert on button click,
and bind comcobox
how to retrieve data from other table

[no name] 31-Aug-22 12:26pm

Setting the .ItemSource, repeatedly, in a for loop, is illogical.
Adding an item to the CB, then setting the .ItemSource, in a for loop, is also illogical.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

How to bind data toa combobox from a table in SQL server WPF C#

Add your solution here

Preview 0

How to bind data toa combobox from a table in SQL server WPF C#

Add your solution here

Preview 0

Existing Members

...or Join us