public void listdata()
{
SqlDataReader reader = null;
listView1.Items.Clear();
listView1.Columns.Clear();
listView1.Columns.Add("ID Kategori", 70, HorizontalAlignment.Left);
listView1.Columns.Add("Nama Pupuk", 150, HorizontalAlignment.Left);
listView1.Columns.Add("Rumus 1", 150, HorizontalAlignment.Left);
listView1.Columns.Add("Rumus 2", 150, HorizontalAlignment.Left);
listView1.Columns.Add("Rumus 3", 150, HorizontalAlignment.Left);
listView1.Columns.Add("Rumus 4", 150, HorizontalAlignment.Left);
listView1.Columns.Add("WS1", 150, HorizontalAlignment.Left);
listView1.Columns.Add("WS2", 150, HorizontalAlignment.Left);
listView1.Columns.Add("P205", 150, HorizontalAlignment.Left);
listView1.Columns.Add("CaO Total", 150, HorizontalAlignment.Left);
listView1.Columns.Add("RK", 150, HorizontalAlignment.Left);
listView1.Columns.Add("K20", 150, HorizontalAlignment.Left);
listView1.Columns.Add("RCA", 150, HorizontalAlignment.Left);
listView1.GridLines = true;
listView1.FullRowSelect = true;
listView1.Activation = ItemActivation.TwoClick;
listView1.View = View.Details;
listView1.MultiSelect = false;
System.Data.SqlClient.SqlConnection conn = konn.GetConn();
try
{
conn.Open();
string sql = "select * from tbl_perumusan";
SqlCommand command = new SqlCommand(sql, conn);
command.ExecuteNonQuery();
reader = command.ExecuteReader();
while (reader.Read())
{
ListViewItem item1 = new ListViewItem(reader["id_kategoripupuk"].ToString(), 0);
item1.SubItems.Add(reader["nama_pupuk"].ToString());
item1.SubItems.Add(reader["rumus1"].ToString());
item1.SubItems.Add(reader["rumus2"].ToString());
item1.SubItems.Add(reader["rumus3"].ToString());
item1.SubItems.Add(reader["rumus4"].ToString());
item1.SubItems.Add(reader["ws1"].ToString());
item1.SubItems.Add(reader["ws2"].ToString());
item1.SubItems.Add(reader["p205"].ToString());
item1.SubItems.Add(reader["cao_total"].ToString());
item1.SubItems.Add(reader["rk"].ToString());
item1.SubItems.Add(reader["k20"].ToString());
item1.SubItems.Add(reader["rca"].ToString());
listView1.Items.Add(item1);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
conn.Close();
}
}
