I am a textfile of 8 Mb with line records,if The line = "#CHLI" then the next 40 lines are = 40 database fields and insert to the database (Access).
In total 20.000 records with 40 fields to insert,the code is place to backgroundworker buth de insert is 1 hour to do complete !!!
The code :
If...
How can i with Crystal reports values of time fields with "0:00" surpress ?
With a formula ?
Thanks
Eric
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
You are missing this :
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
myConnectionInfo.ServerName = ServerName
myConnectionInfo.DatabaseName = "Q-Cycle"
myConnectionInfo.UserID = "sa"
myConnectionInfo.Password = "sa"
Eric De...
Set de server machine for intranet (netwerk) tot FullTrust.
Framwork 2.0 config
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
nobody that have a sample listview grouping with VB.Net 2005 Beta2 ?
Thanks
ps:not in C#
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
Declare CommandBuilder for Update and Acceptchanges
Private bob As OdbcCommandBuilder = New OdbcCommandBuilder(DataAdapter)
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
Its start the site in de linlabel
Private Sub lblWebsite_LinkClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.LinkLabelLinkClickedEventArgs) Handles lblWebsite.LinkClicked
System.Diagnostics.Process.Start(lblWebsite.Text)
End Sub
Eric De Decker
Visit The...
What is now the question ? The ENTER key or validation !
And what is emits ?
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
Why not :
Private Sub NumericUpDown1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles NumericUpDown1.KeyPress
If e.KeyChar = Microsoft.VisualBasic.Chr(13) Then
SendKeys.Send(vbTab)
End If
End Sub
Eric De Decker
Visit...
Public conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\QTrace.mdb;Persist Security Info=False;"
Public oledbcon As New OleDbConnection(conn)
Records tonen :
oledbcon.Open()
Dim adapterRelaties As New OleDbDataAdapter("Select * from Relaties"...
Dim path As String = "c:\MyDir"
Dim di As DirectoryInfo = Directory.CreateDirectory(path)
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
Like this :
Dim commbld As OleDbCommandBuilder = New OleDbCommandBuilder(adapterRelaties)
adapterRelaties.Update(datasetRelaties, "Relaties")
datasetRelaties.AcceptChanges()
Eric De Decker
Visit The Belgium "Visual Basic Group" at http://www.vbgroup.org
What version of SQL server you works ?
If it is 2000 then you most after de servername the servernamaspace like : QUAL-PC01\QUALITYSOFTWARE (you can see this in the interprise manager wat the spacename is)
Have you make a windows User ?
SQL server 7.0 connection like this ...
in my App.Config are the SQLserver settings like this :
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key ="SQLserver" value ="integrated security=SSPI;server=QUAL-PC01\QUALITYSOFTWARE;persist security info=False;initial catalog=Q-Cycle"></add>
<add key...
To Christiaan Baes !
Ken jij de de Belgische "Visual Basic Group" ? ,indien nee ben je welkom en kan je je kennis delen met Belgische programmeurs.
zie http://www.vbgroup.org en meld je aan (onze site word vernieuwd en vergeet het lidgeld wat er staat,vanaf Mei is het gratis voor iedereen)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.