How to Databind to ListBox

Question

List of detail how to show listbox coding method asp.net

deva nathan · Answer

private void second() { SqlConnection d = new SqlConnection(Data Source=pits12-PC;Initial Catalog=devaexample;Persist Security Info=True;User ID=sa;Password=test); d.Open(); //It will show all data of Students into DataGridView. SqlCommand cmd = new SqlCommand(SELECT age FROM centre d); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds centre); SqlDataReader dr = cmd.ExecuteReader(); //listBox1.DataSource = ds; DataTable myDataTable = ds.Tables[0]; DataRow tempRow = null; if (dr.HasRows) { foreach (DataRow tempRow_Variable in myDataTable.Rows) { tempRow = tempRow_Variable; listBox1.Items.Add((tempRow[age])); //listBox1.Items.Add((tempRow[id] +  ( + tempRow[name] + ) +  ( + tempRow[Country] + ) +  ( + tempRow[City] + ))); } //listBox1.Items.Add(dr[age].ToString()); } d.Close(); }