DataBinding with Combobox

Hi Everyone,

i got this Article from C-Sharpconer.com with the link https://www.c-sharpcorner.com/UploadFile/718fc8/databinding-with-combobox-in-ado-net/

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.SqlClient;
namespace DataBindingWIthComBox
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
SqlDataAdapter dadpter=new SqlDataAdapter("select * from student_detail","server=.;database=student;user=sa;password=wintellect");
DataSet dset = new DataSet();
dadpter.Fill(dset);
comboBox2.DataSource = dset.Tables[0];
comboBox2.DisplayMember = "rollno"; // to display roll no. in combobox
comboBox2.ValueMember = "name"; // to store name as value of combobox for selected roll no.
}
private void comboBox2_SelectedIndexChanged(object sender,EventArgs e)
{
label2.Text = comboBox2.SelectedValue.ToString();
}
}
}

i have few question with regrad to this, hope someone can help me.

Q1: in comboBox2.DataSource = dset.Tables[0]; what does Table[0] means

Q2: how do i display Two Column of data from Database in a combobox where if i select from combobox the other related data of that record should be populated to a textbox

Example:

i have a Table Name FileFolderPath with Id, Product, FolderPath. i need Id and Product to be shown in the combobox in Two columns and when i select a record from the combobox FolderPath has to be shown in the textbox or in a variable

Kindly someone please help me on this.

Hello Ifraz,

First thing first you need to understand concept of dataset and datatable. Dataset is the collection of datatable where as datatable is the collection of a table i.e., collection of rows and column in that single table.

dset.Tables[0]

Here dset is the dataset which can contain multiple datatable. Here indexing of table start with 0 hence you are going to access first table so it is at index 0.

If you want the value of any row to put it into a textbox then you can write it as below

txtName.Text = Convert.ToString(Tables[0][0]["Name"]);

Here second 0 is for row number. As a textbox can contain a single value so in datatable only one row should be return. Again row number index is starting with 0 so the first row is [0] and ["Name"] is the name of column.

Thanks

Suraj

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
Hello Ifraz,

First thing first you need to understand concept of dataset and datatable. Dataset is the collection of datatable where as datatable is the collection of a table i.e., collection of rows and column in that single table.

dset.Tables[0]

Here dset is the dataset which can contain multiple datatable. Here indexing of table start with 0 hence you are going to access first table so it is at index 0.

If you want the value of any row to put it into a textbox then you can write it as below

txtName.Text = Convert.ToString(Tables[0][0]["Name"]);

Here second 0 is for row number. As a textbox can contain a single value so in datatable only one row should be return. Again row number index is starting with 0 so the first row is [0] and ["Name"] is the name of column.

Thanks

Suraj