Comments by GoggatjieLiesl

GoggatjieLiesl 24-Sep-12 5:07am View

Thanks hope the question update helps

GoggatjieLiesl 23-Sep-12 6:34am View

I have tried this but still when i press button to generate report it only shows Invoice number in textbox but nothing in my BBF textbox

GoggatjieLiesl 18-Sep-12 13:45pm View

Thanks

GoggatjieLiesl 18-Sep-12 12:37pm View

Hey Its the normal reportviewer that comes with c#

i have tried the following

this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report2.rdlc";
ReportParameter rp = new ReportParameter("InvoiceNumber", this.textBox2.Text);
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });

this.reportViewer1.RefreshReport();

now i get error missing namespace or a assembly reference?
How do i fix this

GoggatjieLiesl 16-Sep-12 3:13am View

Hey, Can i ask you one more question in this table i have a foreign key aswell, now the form again doesnt want to run how do i fix the foreign key issue i tried the same way with identity but only allowed one identity per table. In my foreign key main table i did specify it as identity

GoggatjieLiesl 16-Sep-12 3:05am View

create proc GenerateInvoice
@StartDate date,
@EndDate date,
@Payee varchar(30)

AS

SELECT Waybills.WaybillNumber Waybills.SenderName, Waybills.SenderAddress, Waybills.SenderContact, Waybills.ReceiverName, Waybills.ReceiverAddress,
Waybills.ReceiverContact, Waybills.UnitDescription, Waybills.UnitWeight, Waybills.DateReceived, Waybills.Payee,
Payments.Amount, Payments.PaymentDate, Cycle.CycleNumber, Cycle.StartDate, Cycle.EndDate
FROM Waybills CROSS JOIN
Payments CROSS JOIN
Cycle
WHERE Waybills.ReceiverName = @Payee
AND (Waybills.DateReceived BETWEEN (@StartDate) AND (@EndDate))

Insert Into Invoices (InvoiceNumber, InvoiceDate, BalanceBroughtForward, OutstandingAmount)
Values (@InvoiceNumber, @InvoiceDate, @BalanceBroughtForward, @ OutstandingAmount)

go

This is how far i get but it doesnt seem right

GoggatjieLiesl 15-Sep-12 12:05pm View

Deleted

CREATE TABLE [dbo].[Waybills](
[WaybillID] [int] IDENTITY(1,1) NOT NULL,
[SenderName] [varchar](50) NULL,
[SenderAddress] [varchar](50) NULL,
[SenderContact] [int] NULL,
[ReceiverName] [varchar](50) NULL,
[ReceiverAddress] [varchar](50) NULL,
[ReceiverContact] [int] NULL,
[UnitDescription] [varchar](50) NULL,
[UnitWeight] [int] NULL,
[DateReceived] [date] NULL,
[Payee] [varchar](50) NULL,
[CustomerID] [int] NULL,
PRIMARY KEY CLUSTERED

CREATE TABLE [dbo].[Customer](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[customerName] [varchar](30) NULL,
[CustomerAddress] [varchar](30) NULL,
[CustomerContact] [varchar](30) NULL,
[VatNo] [int] NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
)
CREATE TABLE [dbo].[Cycle](
[CycleID] [int] IDENTITY(1,1) NOT NULL,
[CycleNumber] [int] NULL,
[StartDate] [date] NULL,
[EndDate] [date] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Payments](
[PaymentID] [int] IDENTITY(1,1) NOT NULL,
[Amount] [money] NULL,
[PaymentDate] [date] NULL,
[CustomerID] [int] NULL,
PRIMARY KEY CLUSTERED

Create table Invoices
(
InvoiceID int IDENTITY(1,1),
InvoiceNumber int,
InvoiceDate date,
BalanceBroughtForward money,
OutstandingAmount money,
CustomerID int,
WaybillID int,
PaymentID int,
CycleID int
PRIMARY KEY (InvoiceID),
FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID),
FOREIGN KEY (WaybillID) REFERENCES Waybills(WaybillID),
FOREIGN KEY (PaymentID) REFERENCES Payments(PaymentID),
FOREIGN KEY (CycleID) REFERENCES Cycle(CycleID)
)

This is my tables with relationships, does it look better, will you be able to help me now

GoggatjieLiesl 12-Sep-12 6:05am View

Great it works just the way i wanted it to.
Thanks

GoggatjieLiesl 11-Sep-12 7:28am View

Thanks its working

GoggatjieLiesl 11-Sep-12 5:41am View

Hey i tried changing my code to if (dataGridView1.Rows.Count >= 1 && dataGridView1.SelectedRows[0].Index == dataGridView1.Rows.Count - 1) now the program just keeps on running when i press delete button, it doesnt even want to exit application. please help

GoggatjieLiesl 7-Sep-12 2:36am View

Thank you very much for the quick answer back

GoggatjieLiesl 6-Sep-12 5:12am View

Hey, I wil link my tables now with relationships but thank you very much for your answer it gives me a good idea on were to begin. Thanks again

GoggatjieLiesl 6-Sep-12 4:58am View

Busy studying, still new

GoggatjieLiesl 6-Sep-12 4:57am View

ok i will do so and how do i go from there then

GoggatjieLiesl 6-Sep-12 4:51am View

no i dont have any relations, will i have to put relations?

GoggatjieLiesl 4-Sep-12 1:32am View

Thank you very much for this answer and for helping me out and helping me right. Im still a beginner and it is nice to see that there is still ppl that are patient enough to help us out. Thanks Amit

GoggatjieLiesl 3-Sep-12 8:15am View

Thanks will check it out, thanks for the quick reply

GoggatjieLiesl 3-Sep-12 7:31am View

What code you looking for, the form or report code

Comments by GoggatjieLiesl (Top 18 by date)