pdf - Printing data of datatable with itextsharp and c# -


because through code see first record in print checked in debug mode variables assigned regularly .. not go out .. arrg ... response

this function retrieve data

//recupero dati cliente datatable getcliitems() {    try    {        con.connectionstring = "server=localhost;user id=root;password=cassano;database=cedas";        //con.open();         //query per la visualizzazione di tutti clienti        string query = "select nome, cognome, indirizzo, telefono, cellulare, referente, note clienti rif_agente ='" + combobox1.text + "'";        //adapter per eseguire la query        adapter = new mysqldataadapter(query, con);        dataset ds = new dataset();         //restituisce il risultato della query nel dataset        adapter.fill(ds);         return ds.tables[0];    }    catch (exception ex)    {        messagebox.show("errore durante il recupero delle informazioni.\n\n" + ex.message, "errore", messageboxbuttons.ok, messageboxicon.error);    }    { con.close(); }     return null; } 

and itextsharp print

for (int = 0; < dtcliag.rows.count; i++) {     string nome = dtcliag.rows[i]["nome"].tostring();     string cognome = dtcliag.rows[i]["cognome"].tostring();     string indirizzo = dtcliag.rows[i]["indirizzo"].tostring();     string telefono = dtcliag.rows[i]["telefono"].tostring();     string cellulare = dtcliag.rows[i]["cellulare"].tostring();     string referente = dtcliag.rows[i]["referente"].tostring();     string note = dtcliag.rows[i]["note"].tostring();      pdfpcell[] cellscli = new pdfpcell[] { new pdfpcell(new phrase(nome, fontstampatable)),                                            new pdfpcell(new phrase(cognome, fontstampatable)),                                            new pdfpcell(new phrase(indirizzo, fontstampatable)),                                            new pdfpcell(new phrase(telefono, fontstampatable)),                                            new pdfpcell(new phrase(cellulare, fontstampatable)),                                            new pdfpcell(new phrase(referente, fontstampatable)),                                            new pdfpcell(new phrase(note, fontstampatable))};      (int j = 0; j < 7; j++)     {        cellscli[j].horizontalalignment = 0;        cellscli[j].paddingbottom = 3f;        cellscli[j].border = 0;     }      pdfprow rowcli = new pdfprow(cellscli);     tabellacliente.rows.add(rowcli); 


Comments

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -