Comments by UCP_2005 - CodeProject

UCP_2005 30-Sep-19 15:48pm View

Hi Richard, Thanks for replying. I changed the code as you suggested. But still its showing only one record from SalesInvoicesInventoryRowDetails table. I think problem is somewhere in the report as the dataset is filled with the required data in debugged mode.

UCP_2005 20-Jul-19 12:58pm View

Hi Dave, Thanks for your reply. It was really a guess.
I have inserted separate datarows in each loop.

While sreader.Read
Dim Dr as Datarow=dt.NewRow
subtotal = BasicSalary

All employees are shown now but the problem is its creating new row for every new Pay head (Like Basic Salary, Transport allowance). I want to show the payheads of each employee in its respective row. Please suggest me a way to show all payheads of any employee in a row. Thanks.

UCP_2005 20-Jul-19 4:09am View

Thanks Dave,
I added a new DataRow In the deduction area of the code.
It shows the record from EmployeeID to Gross Total in first row and then in second row
the record from EmployeeID to Gross Total is empty and it shows the Monthly Deduction (Deduction type) and NET Salary of the first employee.

Can you please help.

Thanks and Regards,

UCP_2005 9-Feb-18 6:49am View

Thanks david, I will try.

UCP_2005 9-Feb-18 2:02am View

Thanks for your reoly david

I have debugged the code, its saving all data like text except the image only using above code. This is a simple code to save the record of a passenger with flight details.

When I check the table in database. The image field is NULL. Previously the code was working fine and image was saving into table as well. When image is saved into table then the column the text in the column was "Binary data". Do you find anything wrong in the code?

I will amend my post by commenting the code.

UCP_2005 5-Mar-17 14:33pm View

Hi Graeme,
I was getting trouble in settings values from textedit to the GridControl columns.
This code works fine with the datagridview but not with DevEx Gridcontrol.
Can you please give me the link of existing discussion related to this? Thanks.

UCP_2005 5-Mar-17 14:22pm View

Thanks Graeme.

I checked the links but I created the grid columns through code.

SqlStr = "SELECT TRANSCODE,transdate as [Invoice Date],qutono as [Invoice No],(select top 1 ledgername from StockInvoiceDetails where StockInvoiceDetails.transcode=StockInvoiceRowItems.transcode) AS [Customer Name], SUM(N1) AS [NET PRFIT] FROM StockInvoiceRowItems " & Wherestr & " AND VOUCHERNAME IN ('POS','SD','SR') "

Will it work if I create the columns manually in GridControl by giving the same Name and captions?
Thanks for your support.

UCP_2005 7-Feb-14 14:12pm View

Thank you bosssssssss !!!! it workeddddddddd

Thanks again.... :)am happy

UCP_2005 7-Feb-14 12:55pm View

Thanks for the help G-code101.

Stockcode in database is already set to Yes (Duplicates OK).

Now it is accepting to save data but without the BranchName check. I mean, it is only detecting the stockcode if same data already exists it gives message MsgBox("The Stock Item Already exists, Please Try Again") otherwise it saves data with all data provided by the user.

Please help me . it should save data even if the same stockcode is already available in the ProductsTable but with different BRANCHNAME parameter.

Thanks

Comments by UCP_2005 (Top 9 by date)