Member Avatar for Amit_108

HELLO ALL !
I am new here and a Lerner,beginner. I need help from you all great mind in my project that i have a datatable dt. i retrieve data from sql to a data table named dt in vb.net. now i want to write result in notepad where user repeat on each header page and if user change then insert a line.
my format and code inside in notepad. please review.

Page No.1
Item Issued For Customer :102
----------------------------------------------		
Id		Item		Qty		Date
----------------------------------------------
101		Pen		10		10/05/2021
101		Copy		10		10/05/2021
101		Glue		1		10/05/2021
101		Cover		10		10/05/2021
----------------------------------------------
Total		4		31	
----------------------------------------------

						Page No.2
Item Issued For Customer :102
-----------------------------------------------			
Id		Item		Qty		Date
-----------------------------------------------		
102		Bag		1		09/06/2021
102		Pencil Box	2		09/06/2021
102		Cover		5		09/06/2021
----------------------------------------------
Total		3		8	
-----------------------------------------------
SubTotal	7		39	
------------------------------------------------


MY CODE IS 

Using sw As New StreamWriter(OutPutFile)
 For I As Integer = 0 To dt.Rows.Count - 1
 sw.WriteLine("------------------------------------------------------------")                            
            sw.WriteLine(dt.Rows(I).Item(0).ToString.PadRight(15) & vbTab & dt.Rows(I).Item(1).ToString().PadRight(25) & vbTab & dt.Rows(I).Item(2).ToString().PadRight(10) & vbTab & dt.Rows(I).Item(3).ToString())    
            Next
END USING
            Process.Start(OutPutFile)
Edited by Amit_108
  • 3 Contributors
  • 2 Replies
  • 154 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by Santanu.Das
Member Avatar for pritaeas

You'll need some variables for the total count, the subtotal count and to detect whether the customer ID has changed.

I suggest you try first and reply when you encounter any further problems.

Member Avatar for Santanu.Das

Suggestion:
Do it through SQL not from datagrid which could be more easier for you

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.