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(); } }