Click here to Skip to main content
15,920,110 members

Comments by sarfarazbhat (Top 84 by date)

sarfarazbhat 21-Apr-23 6:11am View    
Gerry Schmitz, thank you so much for showing me the right way. The problem got solved. Thank you once again.
sarfarazbhat 23-Oct-20 3:09am View    
Thank you for the reply, I will surely install MYSQL workbench and try.
Thanks
sarfarazbhat 15-Oct-20 10:46am View    
Thank you Mr. Richard MacCutchan for the reference.
I think that is a bit advanced but I started to learn the advance topics though I know the basics. It is just that I have never worked on relational database tables as yet.
Anyways, I need a bit clarifications on the primary and foreign keys.
I have created 8 tables in MYSQL as under

Candidate_Info
present_address
Permanent_address
Experience
Documents
10th
12th
Diploma

with

canid_id as PK in candidate_info table
present_add_id as PK in Present_address table
permanent_add_id as PK in Permanent_address table
experience_id as PK in experience table
doc_id as PK in documents table
matric_id as PK in matric table
plustwo_id as PK in plustwo table
diploma_id as PK in diploma table

with canid_id as foreign key in all the other tables except candidate_info table.

Is it a correct way to proceed or I am doing it wrong then please elaborate a bit.
Thank you
sarfarazbhat 22-Nov-17 8:36am View    
The issue is like I want the list of items to be on left side and then after some space like two tabs and then the rate of the items, but the issue is like if i use tabs the first item like ASO and its rate is ok but the next item like Blood Sugar and its rate is going two far with two tab space. I want them all in a line like we have when we have itemized bills at a shopping mall.
Hope it make sense.
sarfarazbhat 6-Oct-16 1:07am View    
I need to print a receipt where there are different details to be printed.
I am saving the details in a text file with the following code and Print the text file. Everything is going good but now i need to print an image (QR code) on the same paper where the text file is being printed.But when i try to print the image is being printed on a different page rather than on the page where the text file gets printed.
The code for text file is as under

Dim file As System.IO.StreamWriter
file = My.Computer.FileSystem.OpenTextFileWriter("digimate.txt", False)

Dim x As Integer
Dim total As Integer
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.Write("{0,-9}", "Bill No:")
file.Write("{0,-25}", txtbillno.Text)
file.Write("{0,10}", "Dated :")
file.Write("{0,-22}", dtpick.Text.ToString)
file.WriteLine()
file.Write("{0,-9}", "Name :")
file.Write("{0,-25}", frmcustomer.lblname.Text)
file.Write("{0,10}", "Address:")
file.Write("{0,-22}", frmcustomer.lbladdress.Text)
file.WriteLine()
file.Write("{0,-9}", "Contact:")
file.Write("{0,-25}", frmcustomer.lblcontact.Text)
file.Write("{0,10}", "Email :")
file.WriteLine("{0,-22}", frmcustomer.lblemail.Text)
file.WriteLine("-----------------------------------------------------------------")
file.Write("{0,-7}", "S.NO")
file.Write("{0,-30}", "ITEMS ORDERED")
file.Write("{0,7}", "RATE")
file.Write("{0,7}", "LENGTH")
file.Write("{0,7}", "WIDTH")
file.WriteLine("{0,7}", "TOTAL")
file.WriteLine("-----------------------------------------------------------------") '66
For x = 0 To dgselecteditems.Rows.Count - 1
file.Write("{0,-7}", x + 1)
file.Write("{0,-30}", dgselecteditems.Rows(x).Cells("itemname").Value)
file.Write("{0,7}", dgselecteditems.Rows(x).Cells("rate").Value)
file.Write("{0,7}", dgselecteditems.Rows(x).Cells("length").Value)
file.Write("{0,7}", dgselecteditems.Rows(x).Cells("width").Value)
file.Write("{0,7}", dgselecteditems.Rows(x).Cells("amount").Value)
total += dgselecteditems.Rows(x).Cells("amount").Value
file.WriteLine()
Next
file.WriteLine("-----------------------------------------------------------------")
file.Write("{0,-7}", "")
file.Write("{0,-30}", "Total Amount =")
file.WriteLine("{0,28}", total)
file.WriteLine("-----------------------------------------------------------------")
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.WriteLine()
file.Write("{0,58}", "Sales Tax @ 13.5% due :")
file.WriteLine("{0,7}", txttaxdue.Text)
file.Write("{0,58}", "Sales Tax @ 13.5% charged:")
file.WriteLine("{0,7}", txttaxcharged.Text)
'file.WriteLine("------------------------------------------------------------------")
file.WriteLine()
file.Write("{0,-9}", "Total due:")
tc = total + Val(txttaxcharged.Text)
' qrtotal = tc
Dim temp As String = RupeesToWord(tc)
file.Write("{0,45}", temp)
file.Close()

Do i have to save the pic in a text file which i know can not be saved then how to print the image.
Thank you