16,018,318 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by UCP_2005 (Top 9 by date)
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
Show More