Connectionless database filling listview #iq18but18cm
SqlConnection konekcija = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\SkolaDB.mdf;Integrated Security =True");
private void PrikaziPodLView()
{
listView1.View = View.Details;
listView1.GridLines = true;
listView1.Items.Clear();
string sql = null;
sql = "Select * from Ucenici";
try
{
SqlCommand komanda = new SqlCommand(sql , konekcija);
SqlDataAdapter adapter = new SqlDataAdapter(komanda);
DataTable dt = new DataTable();
adapter.Fill(dt);
// DataTable dt = new DataTable();
// dt = ds.Tables[0]; ili
//fillling of lv can be done on more ways
// 1st way
//
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// DataRow dataRow = dt.Rows[i];
// ListViewItem listItem = new ListViewItem (dataRow["UcenikID"].ToString());
// listItem.SubItems.Add(dataRow["Ime"].ToString());
// listItem.SubItems.Add(dataRow["Prezime"].ToString());
// listItem.SubItems.Add(dataRow["Generacija"].ToString());
// listItem.SubItems.Add(dataRow["OdeljenjeID"].ToString());
// listView1.Items.Add(listItem);
// }
// PRIMER 2
//
foreach (DataRow row in dt.Rows)
{
ListViewItem listItem = new ListViewItem(row["UcenikID"].ToString());
listItem.SubItems.Add(row["Ime"].ToString());
listItem.SubItems.Add(row["Prezime"].ToString());
listItem.SubItems.Add(row["Generacija"].ToString());
listItem.SubItems.Add(row["OdeljenjeID"].ToString());
listView1.Items.Add(listItem);
adapter.Dispose();
komanda.Dispose();
}
}
catch (Exception)
{
MessageBox.Show();
}
#iq18but18cm