DATASETS LISTVIEW DROPDOWN SELECTBOX

C# Tutorials

DATASETS LISTVIEW DROPDOWN SELECTBOX

Learn Tutorials

How to use a dataset and display that data in a listview dropdown list select box.

Example code for Datasets listview dropdown selectbox:
public DataSet getDataSet(string query, string tableName)
   {

      SqlDataAdapter da = new SqlDataAdapter();

      SqlCommand cmd = new SqlCommand(query);

      DataSet ds = new DataSet();

      //load the data into the dataset
      da.Fill(ds,tableName);
      return ds;
   }


   //dump the dataset returned into the listview
   foreach (DataRow dr in ds.Tables["Data"].Rows)
   {
      lvi=new ListViewItem();
      lvi.Text=dr["Title"].ToString();
      DateTime date =(DateTime)dr["dateInserted"];
      lvi.SubItems.Add(date.DayOfWeek.ToString());
      lvi.SubItems.Add(dr["dateInserted"].ToString());

      bottomListView.Items.Add(lvi);
   }

Home

CSHARP

Arrays in c sharp

C sharp array objects

C sharp separators context menu

Compare dates csharp datetime

Context menu c sharp

Context menus csharp example

Controls c sharp dynamically

Database access c sharp

Database access with ADO NET

DataGrid c sharp

Datagrid dataset csharp NET

Datagrid Styles data grid

Datasets listview dropdown selectbox

Dialogbox csharp dialog box

Drag and drop csharp

Listview combo box csharp

Looping through hashtable NET

NET collections tutorial

NET crawler safe url

One row from dataset

Output datetime csharp

Popup form csharp

Try catch c sharp