Click here to Skip to main content
15,395,339 members
Home / Discussions / Database
   

Database

 
SuggestionRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 0:06
mveRichard MacCutchan11-Feb-15 0:06 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 1:32
MemberKipkoechE11-Feb-15 1:32 
GeneralRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 1:36
mveRichard MacCutchan11-Feb-15 1:36 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 1:41
MemberKipkoechE11-Feb-15 1:41 
AnswerRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 2:11
professionalGuyThiebaut11-Feb-15 2:11 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:23
MemberKipkoechE11-Feb-15 2:23 
GeneralRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 2:28
professionalGuyThiebaut11-Feb-15 2:28 
QuestionVB.NET ITEXTSHARP PDF REPORTS Pin
KipkoechE10-Feb-15 6:38
MemberKipkoechE10-Feb-15 6:38 
am creating pdf reports in vb.net Mysql Database but have problems retrieving more than more record...ANy suggestion Here is the code i have tried:

#query database

getClientDataFromTable()
#Add Another Table Here

Dim widths() As Single = {50, 70, 100, 100, 100, 100}
Dim ColumnHeaders() As String = {"No.", "ACCNO", "NAME", "COUNTY", "OCCUPATION", "PHONE"}
Dim ColumnDataExample() As String = {CUSTNO, CUSTName, COUNTY, DATEREGISTERED, PHONE}

Dim tbOther As New PdfPTable(widths)
With tbOther
.TotalWidth = 520
.LockedWidth = True ' lock width to prevent spreading out
.HorizontalAlignment = 1 ' centre align content
.SpacingAfter = 0
.SpacingBefore = 10
End With

'#Add Headers
For i As Integer = 0 To UBound(ColumnHeaders)
cell = New PdfPCell(New Phrase(ColumnHeaders(i), Fontwhite))
cell.BackgroundColor = New BaseColor(20, 120, 120)
cell.BorderColor = New BaseColor(0, 0, 0)
If (i > 3) Then
cell.HorizontalAlignment = 2
Else
cell.HorizontalAlignment = 0
End If
tbOther.AddCell(cell)
Next i

'# Add Data
For j As Integer = 0 To 3 - 1
cell = New PdfPCell(New Phrase((j + 1).ToString(), FontNormal))
tbOther.AddCell(cell)
For i As Integer = 0 To UBound(ColumnDataExample)
cell = New PdfPCell(New Phrase(ColumnDataExample(i), FontNormal))
cell.BorderColor = New BaseColor(20, 120, 120)
If (i > 3) Then
cell.HorizontalAlignment = 2
Else
cell.HorizontalAlignment = 0
End If
tbOther.AddCell(cell)
Next i
Next j

'#Add A Blank Line ---------It spans across all 5 columns and borderless i.e border=0
cell = New PdfPCell(New Phrase())
cell.Border = 0
cell.FixedHeight = 30
cell.Colspan = 6
tbOther.AddCell(cell)
'# Add A Separator Line
Dim separate As New PdfPCell()
separate.FixedHeight = 7 'Set Fixed Height To 7
separate.BorderWidthBottom = 4
'separate.BorderWidthTop = 0
separate.BorderColorTop = BaseColor.GREEN
separate.Colspan = 6 '#Use This to span across 3 columns
tbOther.AddCell(separate)
'add line
cell = New PdfPCell(New Phrase())
cell.Border = 2
cell.Colspan = 0
tbOther.AddCell(cell)

cell = New PdfPCell(New Phrase())
cell.Border = 2
cell.Colspan = 0
tbOther.AddCell(cell)


'# Add A line with a label and and line after
cell = New PdfPCell(New Phrase("Signature:", FontBold))
cell.Border = 0
cell.Colspan = 0
tbOther.AddCell(cell)

cell = New PdfPCell(New Phrase())
cell.Border = 2
cell.Colspan = 0
tbOther.AddCell(cell)
' another(line)
cell = New PdfPCell(New Phrase("Official Stamp:", FontBold))
cell.Border = 0
cell.Colspan = 1
tbOther.AddCell(cell)
cell = New PdfPCell(New Phrase())
cell.Border = 2
cell.Colspan = 4
tbOther.AddCell(cell)

doc.Add(tbOther)

'#Close PDF Document and Launch Document
doc.Close()
QuestionMySQL for MFC application Pin
Anu_Bala10-Feb-15 0:14
MemberAnu_Bala10-Feb-15 0:14 
AnswerRe: MySQL for MFC application Pin
Kornfeld Eliyahu Peter10-Feb-15 2:37
professionalKornfeld Eliyahu Peter10-Feb-15 2:37 
Questionvb.net with mysql Pin
KipkoechE8-Feb-15 17:04
MemberKipkoechE8-Feb-15 17:04 
AnswerRe: vb.net with mysql Pin
PIEBALDconsult8-Feb-15 17:33
professionalPIEBALDconsult8-Feb-15 17:33 
GeneralRe: vb.net with mysql Pin
KipkoechE8-Feb-15 18:56
MemberKipkoechE8-Feb-15 18:56 
GeneralRe: vb.net with mysql Pin
PIEBALDconsult9-Feb-15 3:47
professionalPIEBALDconsult9-Feb-15 3:47 
AnswerRe: vb.net with mysql Pin
ZurdoDev9-Feb-15 4:01
professionalZurdoDev9-Feb-15 4:01 
GeneralRe: vb.net with mysql Pin
Jörgen Andersson9-Feb-15 4:09
professionalJörgen Andersson9-Feb-15 4:09 
QuestionRe: vb.net with mysql Pin
Eddy Vluggen9-Feb-15 5:53
professionalEddy Vluggen9-Feb-15 5:53 
QuestionPopulate one table from another Pin
Corporal Agarn6-Feb-15 4:50
professionalCorporal Agarn6-Feb-15 4:50 
QuestionRe: Populate one table from another Pin
Wendelius6-Feb-15 5:23
mveWendelius6-Feb-15 5:23 
AnswerRe: Populate one table from another Pin
Corporal Agarn6-Feb-15 6:49
professionalCorporal Agarn6-Feb-15 6:49 
AnswerRe: Populate one table from another Pin
Jörgen Andersson9-Feb-15 21:29
professionalJörgen Andersson9-Feb-15 21:29 
GeneralRe: Populate one table from another Pin
Corporal Agarn10-Feb-15 0:42
professionalCorporal Agarn10-Feb-15 0:42 
GeneralRe: Populate one table from another Pin
Corporal Agarn10-Feb-15 2:23
professionalCorporal Agarn10-Feb-15 2:23 
GeneralRe: Populate one table from another Pin
Jörgen Andersson10-Feb-15 4:23
professionalJörgen Andersson10-Feb-15 4:23 
AnswerRe: Populate one table from another Pin
Rony8910-Feb-15 17:00
MemberRony8910-Feb-15 17:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.