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