incorrect records from two tables using join

Question

I have two tables 

first table

QuestionTarget whose columns are

(

[Id] [bigint] IDENTITY(0,1) NOT NULL,

[QT_ID] [bigint] NOT NULL,

[Question_ID] [int] NOT NULL,

[QuestionTarget] [bigint] NULL,

[QT_FormMen] [bigint] NULL,

[QT_ForWomen] [bigint] NULL,

[QT_ForGirl] [bigint] NULL,

[QT_ForBoy] [bigint] NULL,

[User_Id] [tinyint] NULL,

[District] [tinyint] NULL,

[CommunityCodes] [tinyint] NULL,

[Year] [tinyint] NULL,

[Quarter] [tinyint] NULL,

[User_Name] [nvarchar](50) NULL,

[User_Types] [tinyint] NULL,

[IsActive] [bit] NULL,

[SiteCultureId] [tinyint] NULL,

[IsSubmitted] [bit] NULL,

[IsReseted] [bit] NULL,

[Status] [char](1) NULL,

[Comments] [nvarchar](500) NULL,

[AttemptCount] [bigint] NULL,

[DateCreated] [smalldatetime] NULL,

[DateModified] [smalldatetime] NULL,

CONSTRAINT [PK_QuestionTarget] PRIMARY KEY CLUSTERED

)

second Table AnswersNew(

[id] [bigint] IDENTITY(1,1) NOT NULL,

[AnswerID] [bigint] NOT NULL,

[Question_ID] [int] NULL,

[QTotal] [bigint] NULL,

[QT_ForMen] [bigint] NULL,

[QT_ForWomen] [bigint] NULL,

[QT_ForBoy] [bigint] NULL,

[QT_ForGirl] [bigint] NULL,

[CDF_ID] [tinyint] NULL,

[CdfPErsonName] [nvarchar](50) NULL,

[DistrictId] [tinyint] NULL,

[UserTypes] [tinyint] NULL,

[Year] [tinyint] NULL,

[Quarter] [tinyint] NULL,

[CommunityCodes] [tinyint] NULL,

[CDPDeveloped] [bit] NULL,

[CDF_Comments] [nvarchar](2000) NULL,

[CDC_Comments] [nvarchar](2000) NULL,

[Reporting_Name] [nvarchar](50) NULL,

[IsActive] [bit] NULL,

[LastLoginDate] [smalldatetime] NULL,

[IsVisible] [bit] NULL,

[IsFinalized] [bit] NULL,

[AttemptCount] [bigint] NULL,

[Status] [char](1) NULL,

[VillagesId] [bigint] NULL,

[Date_Created] [smalldatetime] NULL,

[Date_Modified] [smalldatetime] NULL,

CONSTRAINT [PK_AnswersNew] PRIMARY KEY CLUSTERED

)

Now listen me In my first table i am saving the Target value for question and when i insert one row in first table the second table should contain 16 rows for one row in first table so if i insert four rows in first table then in second table there would be 16*4 Rows , Now i want to calculate the sum of a column from second table and the issue is that when i used inner join it takes value from first table for all 16 rows and make a total of it weather it must take one value because against one record there are 16 records in second table so inner join gives values to all 16 rows  

Answer 1

I have best answer for you :

 

https://stackoverflow.com/questions/31668595/how-to-insert-header-and-footer-to-existing-pdf-document-using-itextsharp-witho

 

https://www.aspsnippets.com/Articles/iTextSharp-Add-Page-numbers-to-existing-PDF-using-C-and-VBNet.aspx

 

http://www.nullskull.com/q/10105908/itextsharp--adding-footers.aspx

 

Thanks 

Answer 2

Hi,

 

https://www.aspsnippets.com/Articles/iTextSharp-Add-Page-numbers-to-existing-PDF-using-C-and-VBNet.aspx

 

Hope it helps...

Answer 3

It seems that this question has been asked in many different forums. I googled and find the most proper one for you, in which no external PDF creator or PDF reader SDK is required. Hope it can help you a little.

" Have a look at chapter 6 of iText in Action, 2nd edition, especially at subsection 6.4.1: Concatenating and splitting PDF documents.
Listing 6.22, ConcatenateStamp.java, shows you how you should create a PDF from copies of pages (in your case: all pages) of multiple other PDFs; the sample additionally adds a new "Page X of Y" footer; this demonstrates how you can add content at given positions on the pages while merging the source files.

"

The answer is from http://stackoverflow.com/questions/13465657/itext-add-content-to-the-bottom-of-an-existing-page

Answer 4

Hi Rahul,
Maybe it cannot be implemented directly, here is a kind of method to help draw the footer in existing pdf file. Of course, it need to use another component but not iTextSharp, it's Spire.PDF. Try the code below,
private static void DrawPageNumber(PdfPageCollection section, PdfMargins margin, int startNumber, int pageCount)
{
foreach (PdfPageBase page in section)
{
page.Canvas.SetTransparency(0.5f);
PdfBrush brush = PdfBrushes.Black;
PdfPen pen = new PdfPen(brush, 0.75f);
PdfTrueTypeFont font = new PdfTrueTypeFont(new Font("Arial", 10f, FontStyle.Bold), true);
PdfStringFormat format = new PdfStringFormat(PdfTextAlignment.Right);
format.MeasureTrailingSpaces = true;
float space = font.Height * 0.75f;
float x = margin.Left;
float width = page.Canvas.ClientSize.Width - margin.Left - margin.Right;
float y = page.Canvas.ClientSize.Height - margin.Bottom + space;
page.Canvas.DrawLine(pen, x, y, x + width, y);
y = y + 1;
String numberLabel
= String.Format("{0} of {1}", startNumber++, pageCount);
page.Canvas.DrawString(numberLabel, font, brush, x + width, y, format);
page.Canvas.SetTransparency(1);
}
}
article:
http://www.e-iceblue.com/Knowledgebase/Spire.PDF/Program-Guide/Add-PDF-Footer.html

Answer 5

Thanks & Regards,

Praveen Nelge