Retriving records of table in Combo Box

Question

Dear All

I have started working with .net now. I want to know how can i Load records like User Names from Access table to Combo box writing manual code. I have successfully established a connection with database but cannot proceed further. Kindly help me.

Regards
Amrinder Singh

Amrinder Singh · Answer

Hi SatyaPriya I am sending the code which i have written on Button Click which can help you. Connection setting is done succesfully but Error comes while loading Records from Data into Listbox Following is code written on Button click :- Dim conn As New OleDb.OleDbConnection Dim a As String Dim b As String a = Provider=Microsoft.jet.oledb.4.0; b = data source=C:\Logic\CompanyInfo.mdb conn.ConnectionString = a & b conn.Open() MsgBox(Connected) Dim qry As String Dim rs As New ADODB.Recordset qry = select place_name from cities rs.Open(qry conn ADODB.CursorTypeEnum.adOpenDynamic ADODB.LockTypeEnum.adLockOptimisticWhat should be used here i done know) Do While Not rs.EOF ListBox1.Items.Add(rs(0)) rs.MoveNext() Loop rs = Nothing

Satyapriya Nayak · Answer

Hi Amrinder Try this... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Combobox_names_from_db { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { comboBox1.Text=Choose Names; OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from emp; com = new OleDbCommand(str con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader[ename]); } } } } Thanks If this post helps you mark it as answer