Comments by Anuj Mehta

Anuj Mehta 25-Jan-19 5:30am View

I Added it for Just checking code.

Without converting result is same (no change)
double Upper = 1.8415;
double meanObject = Math.Round((Upper), 3);

Result = 1.841

Anuj Mehta 3-Nov-17 1:54am View

I want to Set Width of Columns Name & Value Like this,

COl-1(Verry Small)|COl-12(Big) | COl-3(Medium) | COl-4(Verry Small)| COl-5(Med)

Anuj Mehta 3-Nov-17 1:46am View

yes Sure done..

Anuj Mehta 3-Nov-17 1:32am View

I tried
property like width and rowspan is not working

Anuj Mehta 27-Oct-17 6:22am View

 thank you very much its working using your code 

  for (int i = 0; i < dt2.Columns.Count; i++)
                        {
                            string width = i == 0 ? "2" : "1"; // first column will be 50% and others 20%
                            sb.Append("<td colspan=" + width + " rowspan='0' style = 'background-color: #e7e7e7;color:#000000'>");
                            sb.Append(dt2.Columns[i].ColumnName);
                            sb.Append("</td>");
                        }

Anuj Mehta 26-Oct-17 8:21am View

 not working sir plzz check screenshot hear

http://websitedevelopervadodara.blogspot.in/2017/10/change-width-of-product-description-hsn.html

Anuj Mehta 26-Oct-17 6:43am View

                        sb.Append("<table style='width:10px;' border = '1'>");
                        sb.Append("<tr>");

                        //foreach (DataColumn column in dt2.Columns)
                        //{
                        //    sb.Append("<th style = 'width:40%;background-color: #e7e7e7;color:#000000'>");
                        //    sb.Append(column.ColumnName);
                        //    sb.Append("</th>");
                        //}
                        for (int i = 0; i < dt2.Columns.Count; i++)
                        {
                            string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
                            sb.Append("<th width=" + width + " style = 'background-color: #e7e7e7;color:#000000'>");
                            sb.Append(dt2.Columns[i].ColumnName);
                            sb.Append("</th>");
                        }

                        sb.Append("</tr>");
                        foreach (DataRow row in dt2.Rows)
                        {
                            sb.Append("<tr>");
                            foreach (DataColumn column in dt2.Columns)
                            {
                                for (int i = 0; i < dt2.Rows.Count; i++)
                                {
                                    string width = i == 0 ? "'50%'" : "'20%'";
                                    sb.Append("<td  width=" + width + ">");
                                    sb.Append(row[column]);
                                    sb.Append("</td>");
                                }
                            }
                            sb.Append("</tr>");
                        }
 sb.Append("</table>");

Anuj Mehta 26-Oct-17 6:25am View

i tried it but its not working.

Anuj Mehta 26-Oct-17 6:12am View

yes exporting it to pdf

Anuj Mehta 26-Oct-17 5:37am View

 using (StringWriter sw = new StringWriter())
                {
                    using (HtmlTextWriter hw = new HtmlTextWriter(sw))
                    {
                        StringBuilder sb = new StringBuilder();
                        //Generate Invoice (Bill) Header.                       
                        sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>");
                        
                        sb.Append("<table style='width:10px;' border = '1'>");
                        sb.Append("<tr>");
                        for (int i = 0; i < dt2.Columns.Count; i++)
                        {
                            string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
                            sb.Append("<th width=" + width + " style = 'background-color: #e7e7e7;color:#000000'>");
                            sb.Append(dt2.Columns[i].ColumnName);
                            sb.Append("</th>");
                        }
                        sb.Append("</tr>");
                        foreach (DataRow row in dt2.Rows)
                        {
                            sb.Append("<tr>");
                            foreach (DataColumn column in dt2.Columns)
                            {

                                sb.Append("<td style='width:80px;'>");
                                sb.Append(row[column]);
                                sb.Append("</td>");
                            }
                            sb.Append("</tr>");
                        }
                        sb.Append("<tr colspan = '5' rowspan ='3'>");
                        sb.Append("<td align='center'>");
                        sb.Append(objPurchaseOrderBO.TotalInWord);
                        sb.Append("</td>");
                        sb.Append("<th colspan = '3'> Total TAX");
                        sb.Append("</th>");
                        sb.Append("<td>");
                        sb.Append(totalTaxValue.Text);
                        sb.Append("</td>");
                        sb.Append("</tr>");
                        sb.Append("</table>");

                        //Export HTML String as PDF.
                        StringReader sr = new StringReader(sb.ToString());
                        Document pdfDoc = new Document(PageSize.A3, 40f, 40f, 20f, 0f);
                        HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
                        PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
                        pdfDoc.Open();
                        htmlparser.Parse(sr);
                        pdfDoc.Close();
                        Response.ContentType = "application/pdf";
                        Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + orderNo + ".pdf");
                        Response.Cache.SetCacheability(HttpCacheability.NoCache);
                        Response.Write(pdfDoc);
                        Response.End();
                    }
                }

Anuj Mehta 26-Oct-17 5:26am View

because value between <" "> is not displaying.

Anuj Mehta 26-Oct-17 4:56am View

Deleted

using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();

sb.Append("<div class=\"col-sm-12 col-md-12\">");
sb.Append("<div class=\"box\">");
sb.Append("<div class=\"box-content\">");
sb.Append("<div class=\"form-group\">");
sb.Append("<div class=\"row\">");
sb.Append("<div class=\"col-md-6\">");
sb.Append("PURCHASE ORDER");
sb.Append("");
sb.Append("<div class=\"col-md-2\">");
sb.Append("PURCHASE ORDER");

//Generate Invoice (Bill) Header.
sb.Append("");
//sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("Order Sheet

PURCHASE ORDER

");
sb.Append("");
sb.Append(" ");
sb.Append("

HEM TECHSYS PRIVATE LIMITED

");
sb.Append(" GST TIN : 24AACCH1767L1ZG ");
sb.Append("484/B/2, G.I.D.C, INDUSTRIAL AREA,");
sb.Append(" ");
sb.Append("MAKARPURA, VADODARA-390 010.");
sb.Append(" Supplier: ");
sb.Append(dt4.Rows[0]["Address"].ToString());
sb.Append("PO NO.: ");
sb.Append(dt4.Rows[0]["PurchaseOrderNumber"].ToString());
sb.Append("");
sb.Append("Date: ");
sb.Append(dt4.Rows[0]["Date"].ToString());
sb.Append("GST NO.: ");
sb.Append(dt4.Rows[0]["GSTno"].ToString());
sb.Append("Your Quotation No: ");
sb.Append(dt4.Rows[0]["QuotationOrderNo"].ToString());
sb.Append("");
sb.Append("");

sb.Append("");
sb.Append("");

//foreach (DataColumn column in dt2.Columns)
//{
// sb.Append("");
//}
for (int i = 0; i < dt2.Columns.Count; i++)
{
string width = i == 0 ? "50%" : "10%"; // first column will be 50% and others 20%
sb.Append("");
}
sb.Append("");
foreach (DataRow row in dt2.Rows)
{
sb.Append("");
foreach (DataColumn column in dt2.Columns)
{

sb.Append("");

//for (int i = 0; i < dt2.Columns.Count; i++)
//{
// string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
// sb.Append("");

Anuj Mehta 26-Oct-17 4:55am View

Deleted

using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//Generate Invoice (Bill) Header.
sb.Append("");

sb.Append("");
sb.Append("");
for (int i = 0; i < dt2.Columns.Count; i++)
{
string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
sb.Append("");
}
sb.Append("");
foreach (DataRow row in dt2.Rows)
{
sb.Append("");
foreach (DataColumn column in dt2.Columns)
{

sb.Append("");
}
sb.Append("");
}
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append(dt2.Columns[i].ColumnName);
sb.Append("");
sb.Append(row[column]);
sb.Append("");
sb.Append(objPurchaseOrderBO.TotalInWord);
sb.Append(" Total TAX");
sb.Append("");
sb.Append(totalTaxValue.Text);
sb.Append("");

//Export HTML String as PDF.
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A3, 40f, 40f, 20f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + orderNo + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
}
}

Anuj Mehta 26-Oct-17 4:53am View

Deleted

using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//Generate Invoice (Bill) Header.
sb.Append("");

sb.Append("");
sb.Append("");
for (int i = 0; i < dt2.Columns.Count; i++)
{
string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
sb.Append("");
}
sb.Append("");
foreach (DataRow row in dt2.Rows)
{
sb.Append("");
foreach (DataColumn column in dt2.Columns)
{

sb.Append("");
}
sb.Append("");
}
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append(dt2.Columns[i].ColumnName);
sb.Append("");
sb.Append(row[column]);
sb.Append("");
sb.Append(objPurchaseOrderBO.TotalInWord);
sb.Append(" Total TAX");
sb.Append("");
sb.Append(totalTaxValue.Text);
sb.Append("");

//Export HTML String as PDF.
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A3, 40f, 40f, 20f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + orderNo + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
}
}

Anuj Mehta 26-Oct-17 4:49am View

Deleted

using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//Generate Invoice (Bill) Header.
sb.Append("");

sb.Append("");
sb.Append("");
for (int i = 0; i < dt2.Columns.Count; i++)
{
string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
sb.Append("");
}
sb.Append("");
foreach (DataRow row in dt2.Rows)
{
sb.Append("");
foreach (DataColumn column in dt2.Columns)
{

sb.Append("");
}
sb.Append("");
}
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append(dt2.Columns[i].ColumnName);
sb.Append("");
sb.Append(row[column]);
sb.Append("");
sb.Append(objPurchaseOrderBO.TotalInWord);
sb.Append(" Total TAX");
sb.Append("");
sb.Append(totalTaxValue.Text);
sb.Append("");

//Export HTML String as PDF.
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A3, 40f, 40f, 20f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + orderNo + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
}
}

Anuj Mehta 26-Oct-17 4:46am View

Deleted

using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//Generate Invoice (Bill) Header.
sb.Append("");

sb.Append("");
sb.Append("");
for (int i = 0; i < dt2.Columns.Count; i++)
{
string width = i == 0 ? "'50%'" : "'20%'"; // first column will be 50% and others 20%
sb.Append("");
}
sb.Append("");
foreach (DataRow row in dt2.Rows)
{
sb.Append("");
foreach (DataColumn column in dt2.Columns)
{

sb.Append("");
}
sb.Append("");
}
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append("");
sb.Append(dt2.Columns[i].ColumnName);
sb.Append("");
sb.Append(row[column]);
sb.Append("");
sb.Append(objPurchaseOrderBO.TotalInWord);
sb.Append(" Total TAX");
sb.Append("");
sb.Append(totalTaxValue.Text);
sb.Append("");

//Export HTML String as PDF.
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A3, 40f, 40f, 20f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + orderNo + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
}
}

Anuj Mehta 26-Oct-17 1:05am View

Same output, no change on my width,
it's not working, please give me any other suggestion .

Comments by Anuj Mehta (Top 17 by date)

PURCHASE ORDER

HEM TECHSYS PRIVATE LIMITED