在itextsharp中使用数据库值

debugcn 发表于 Dev

汤姆

我有一个名为settingsTBL的表，其中只有一行数据（用作可存储的设置）。在此表中，它们是公司名称，地址等的列。

我正在使用iTextSharp从表单上的文本框生成发票。到目前为止，我已经将所有相关的文本框文本添加到PDF文档中，并希望在页面底部显示公司的详细信息，但是我很难从表格中获取到它的内容，也无法将其添加到PDF文档中的文本中。

我创建了字符串以尝试使用它们来生成文本。这是我的代码：

{
    string constring = @"Data Source=|DataDirectory|\LWADataBase.sdf";
    string Query = "select * from settingsTBL where Reference = 1; ";
    SqlCeConnection conDataBase = new SqlCeConnection(constring);
    SqlCeCommand cmdDataBase = new SqlCeCommand(Query, conDataBase);
    SqlCeDataReader myReader;
    try {
        conDataBase.Open();
        myReader = cmdDataBase.ExecuteReader();
        while (myReader.Read()) {
            string sCompany = myReader.GetString(myReader.GetOrdinal("Company Name"));
            string sAddress1 = myReader.GetString(myReader.GetOrdinal("Address Line 1"));
            string sAddress2 = myReader.GetString(myReader.GetOrdinal("Address Line 2"));
            string sPost = myReader.GetString(myReader.GetOrdinal("Post Code"));
            string sTelephone = myReader.GetString(myReader.GetOrdinal("Telephone Number"));
            string sEmail = myReader.GetString(myReader.GetOrdinal("Email Address"));
            string sRegistration = myReader.GetString(myReader.GetOrdinal("Registration Number"));
        }
        //displays a system error message if a problem is found
    }
    catch (Exception ex) {
        MessageBox.Show(ex.Message);
    }
}
Paragraph lwa = new Paragraph("WOULD LIKE TO INSERT COMPANY DETAILS INTO HERE");
lwa.Alignment = Element.ALIGN_BOTTOM;
invoice.Add(lwa);

汤姆

  string constring = @"Data Source=|DataDirectory|\LWADataBase.sdf";
            string Query = "select * from settingsTBL where Reference = 1; ";
            SqlCeConnection conDataBase = new SqlCeConnection(constring);
            SqlCeCommand cmdDataBase = new SqlCeCommand(Query, conDataBase);
            SqlCeDataReader myReader;

                conDataBase.Open();
                myReader = cmdDataBase.ExecuteReader();

                myReader.Read();

                    string sCompany = myReader.GetString(myReader.GetOrdinal("Company Name"));
                    string sAddress1 = myReader.GetString(myReader.GetOrdinal("Address Line 1"));
                    string sAddress2 = myReader.GetString(myReader.GetOrdinal("Address Line 2"));
                    string sPost = myReader.GetString(myReader.GetOrdinal("Post Code"));
                    string sTelephone = myReader.GetString(myReader.GetOrdinal("Telephone Number"));
                    string sEmail = myReader.GetString(myReader.GetOrdinal("Email Address"));
                    string sRegistration = myReader.GetString(myReader.GetOrdinal("Registration Number"));










        Paragraph lwa = new Paragraph(""+sCompany+ "\n " +sAddress1+ " " + sAddress2+"\n " +sPost+"\n Email Address: " + sEmail+ "\n Telephone: " +sTelephone+ "\n " +sRegistration+"" );

        lwa.Alignment = Element.ALIGN_LEFT;
        invoice.Add(lwa);

删除{}和while循环似乎可以正常工作。任何其他建议，请随时发表评论或回答。我一直在寻找更好的答案。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。