UcitajAutomobil.cs
public class UcitajAutomobil
{
public void UcitajUListview()
{
listViewRaspolozivi.Items.Clear();
DataSet ds = new DataSet();
string upit = "Select * from Vozilo";
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.RentCarConnStr))
{
SqlDataAdapter da = new SqlDataAdapter(upit, conn);
da.Fill(ds);
}
DataTable tblVozilo = ds.Tables[0];
foreach (DataRow dr in tblVozilo.Rows)
{
ListViewItem lvi = new ListViewItem(dr["ID_vozila"].ToString());
lvi.SubItems.Add(dr["Marka"].ToString());
lvi.SubItems.Add(dr["Boja"].ToString());
lvi.SubItems.Add(dr["Godiste"].ToString());
lvi.SubItems.Add(dr["Registracija"].ToString());
listViewRaspolozivi.Items.Add(lvi);
}
if (listViewRaspolozivi.SelectedItems.Count == 0)
{
return;
}
string query = "Select * from Vozilo Where ID_vozila = '" +
listViewRaspolozivi.SelectedItems[0].Tag.ToString() + "'";
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.RentCarConnStr))
{
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
Automobil car = new Automobil();
car.ID = (int)dr[0];
car.Marka = dr[1].ToString();
car.Boja = (string)dr[2];
car.Godiste = (string)dr[3];
car.Registracija = (string)dr[4];
dr.Close();
conn.Close();
voziloBindingSource.DataSource = car;
}
}
}
Glavna.cs
public partial class Glavna : UcitajAutomobil
{
public Glavna()
{
InitializeComponent();
}
private void ucitajToolStripMenuItem_Click(object sender, EventArgs e)
{
UcitajAutomobil ucitaj = new UcitajAutomobil();
ucitaj.UcitajUListview();
}
}
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire