public ArrayList createTable() { ArrayList values = new ArrayList(); SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "select * from Prelevatori Where 1=1"; if (Prelevator.Text.Trim().Length > 0) cmd.CommandText += " AND NumePrelevator Like '%" + Prelevator.Text.Trim() + "%'"; if (CodPrelevator.Text.Trim().Length > 0) cmd.CommandText += " AND CodPrelevator =" + CodPrelevator.Text.Trim(); cmd.CommandText += "ORDER BY CodPrelevator DESC"; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); int nrrec = 0; while (reader.Read()) { Prelevatori pv = new Prelevatori(); pv.id = Convert.ToString(reader["ID"]); pv.codprelevator = Convert.ToString(reader["CodPrelevator"]); pv.numeprelevator = Convert.ToString(reader["NumePrelevator"]); values.Add(pv); // add to values nrrec++; } lcount.Text = nrrec + " prelevatori"; reader.Close(); cnn.Close(); return values; }
public ArrayList createTable() { ArrayList values = new ArrayList(); SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "select * from Prelevatori Where 1=1"; if (Prelevator.Text.Trim().Length > 0) { cmd.CommandText += " AND NumePrelevator Like '%" + Prelevator.Text.Trim() + "%'"; } if (CodPrelevator.Text.Trim().Length > 0) { cmd.CommandText += " AND CodPrelevator =" + CodPrelevator.Text.Trim(); } cmd.CommandText += "ORDER BY CodPrelevator DESC"; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); int nrrec = 0; while (reader.Read()) { Prelevatori pv = new Prelevatori(); pv.id = Convert.ToString(reader["ID"]); pv.codprelevator = Convert.ToString(reader["CodPrelevator"]); pv.numeprelevator = Convert.ToString(reader["NumePrelevator"]); values.Add(pv); // add to values nrrec++; } lcount.Text = nrrec + " prelevatori"; reader.Close(); cnn.Close(); return(values); }