Display/Show data on ComboBox in C# windows app from Sql database.
All the source code is available here!
///////////DBGeneral class code//////
using MetroFramework.Controls;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace BCSBatch9E.Database
{
class DBGeneral:DBConnection
{
public SqlCommand CMD;
//Display Data on Combo Box
public void display_on_combobox(string query, ComboBox cmb)
{
OpenConnection();
CMD.CommandText = query;
SqlDataAdapter ad = new SqlDataAdapter(CMD);
DataTable dt = new DataTable();
ad.Fill(dt);
cmb.DataSource = dt;
cmb.DisplayMember = "Name";
cmb.ValueMember = "ID";
CloseConnection();
}
}
}
////////////////////////////////////////////////
//////////////MainForm (InfoForm) code//////////////
private void Info_Load(object sender, EventArgs e)
{
Database.DBGeneral obj = new Database.DBGeneral();
obj.DisplayData("select * from TablePractice order by ID DESC",grdview);
obj.display_on_combobox("select * from TablePractice", cmbemployee);
}
///////////////////////////////////////////////////////////