|
please help me
i need how to read CSV file in to vb.net and insert the csv datas in to oracle database using vb.net coding to upload the data content from csv to oracle database
it is possible means
send reply some coding to for connection string for csv in oledb connection string
|
|
|
|
|
You may not have to read the CSV at all. MySQL, and SQL Server (so I hope Oracle does too) can perform a restore operation from a CSV file in the SQL statement. It's simply a matter of connecting to the db and executing it.
Jeremy Falcon
|
|
|
|
|
Hello,
I wrote a .Net class library. The library contains a com class and windows form with three textboxes and a button. When I use this form in VB6, the events of the textboxes don't work e.g. pressing TAB in one box has no effect, entering text is okay. What's wrong? PLEASE help me.
Greets
Patrick
|
|
|
|
|
Did you creat event handlers to wrap the .NET ones in your COM object using With Events?
Jeremy Falcon
|
|
|
|
|
.Net-Form:
<br />
Public Class ImportMain<br />
Inherits System.Windows.Forms.Form<br />
<br />
#Region " Vom Windows Form Designer generierter Code "<br />
<br />
Public Sub New()<br />
MyBase.New()<br />
<br />
' Dieser Aufruf ist für den Windows Form-Designer erforderlich.<br />
InitializeComponent()<br />
<br />
' Initialisierungen nach dem Aufruf InitializeComponent() hinzufügen<br />
<br />
End Sub<br />
<br />
' Die Form überschreibt den Löschvorgang der Basisklasse, um Komponenten zu bereinigen.<br />
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)<br />
If disposing Then<br />
If Not (components Is Nothing) Then<br />
components.Dispose()<br />
End If<br />
End If<br />
MyBase.Dispose(disposing)<br />
End Sub<br />
<br />
' Für Windows Form-Designer erforderlich<br />
Private components As System.ComponentModel.IContainer<br />
<br />
'HINWEIS: Die folgende Prozedur ist für den Windows Form-Designer erforderlich<br />
'Sie kann mit dem Windows Form-Designer modifiziert werden.<br />
'Verwenden Sie nicht den Code-Editor zur Bearbeitung.<br />
Friend WithEvents TextBox1 As System.Windows.Forms.TextBox<br />
Friend WithEvents TextBox2 As System.Windows.Forms.TextBox<br />
Friend WithEvents TextBox3 As System.Windows.Forms.TextBox<br />
Friend WithEvents Button1 As System.Windows.Forms.Button<br />
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()<br />
Me.TextBox1 = New System.Windows.Forms.TextBox<br />
Me.TextBox2 = New System.Windows.Forms.TextBox<br />
Me.TextBox3 = New System.Windows.Forms.TextBox<br />
Me.Button1 = New System.Windows.Forms.Button<br />
Me.SuspendLayout()<br />
'<br />
'TextBox1<br />
'<br />
Me.TextBox1.Location = New System.Drawing.Point(15, 10)<br />
Me.TextBox1.Name = "TextBox1"<br />
Me.TextBox1.TabIndex = 0<br />
Me.TextBox1.Text = ""<br />
'<br />
'TextBox2<br />
'<br />
Me.TextBox2.Location = New System.Drawing.Point(15, 35)<br />
Me.TextBox2.Name = "TextBox2"<br />
Me.TextBox2.TabIndex = 1<br />
Me.TextBox2.Text = ""<br />
'<br />
'TextBox3<br />
'<br />
Me.TextBox3.Location = New System.Drawing.Point(15, 60)<br />
Me.TextBox3.Name = "TextBox3"<br />
Me.TextBox3.TabIndex = 2<br />
Me.TextBox3.Text = ""<br />
'<br />
'Button1<br />
'<br />
Me.Button1.Location = New System.Drawing.Point(125, 10)<br />
Me.Button1.Name = "Button1"<br />
Me.Button1.TabIndex = 3<br />
Me.Button1.Text = "Button1"<br />
'<br />
'ImportMain<br />
'<br />
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)<br />
Me.ClientSize = New System.Drawing.Size(212, 93)<br />
Me.Controls.Add(Me.Button1)<br />
Me.Controls.Add(Me.TextBox3)<br />
Me.Controls.Add(Me.TextBox2)<br />
Me.Controls.Add(Me.TextBox1)<br />
Me.Name = "ImportMain"<br />
Me.Text = "ImportMain"<br />
Me.ResumeLayout(False)<br />
<br />
End Sub<br />
<br />
#End Region<br />
<br />
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
Dim i, j As Double<br />
i = CDbl(TextBox1.Text)<br />
j = CDbl(TextBox2.Text)<br />
TextBox3.Text = CStr(i + j)<br />
End Sub<br />
<br />
End Class<br />
And the ComClass:
<br />
<ComClass(ComClass1.ClassId, ComClass1.InterfaceId, ComClass1.EventsId)> _<br />
Public Class ComClass1<br />
<br />
#Region "COM GUIDs"<br />
' Diese GUIDs stellen die COM-Identität für diese Klasse <br />
' und ihre COM-Schnittstellen bereit. Wenn Sie sie ändern, können <br />
' vorhandene Clients nicht mehr auf die Klasse zugreifen.<br />
Public Const ClassId As String = "368652A3-F7FB-428B-8EFF-F37374EC1E8F"<br />
Public Const InterfaceId As String = "F7831566-FD11-4F79-B58D-A64C0FEC657C"<br />
Public Const EventsId As String = "8F1418A0-9C89-4D7F-AF2B-4B77A5B87890"<br />
#End Region<br />
<br />
' Eine erstellbare COM-Klasse muss eine Public Sub New() <br />
' ohne Parameter haben. Andernfalls wird die Klasse möglicherweise nicht <br />
' in der COM-Registrierung registriert und kann nicht über <br />
' ein CreateObject erstellt werden.<br />
Public Sub New()<br />
MyBase.New()<br />
End Sub<br />
<br />
Public Sub showImportForm()<br />
Dim importForm As New ImportMain<br />
importForm.Show()<br />
importForm.Activate()<br />
End Sub<br />
<br />
End Class<br />
Greets
Patrick
|
|
|
|
|
Hi,
has nobody an idea? Eventually anybody has an example for using a .Net-Control in VB6!? By now thanks for your efforts.
Greets
Patrick
|
|
|
|
|
hi,
Can anyone tell me how to set breakpoints to a ActiveX project...
Actually i want to see how it works when i am calling from another Vb Application.
plz help me.
bye
Paritosh
|
|
|
|
|
You set them just like any other breakpoint in your code.
You have to then attach the Debugger to the process that's loading and calling your .DLL.
Please don't post the same question over and over again...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi
I want to set a breakpoint to the dll-class
and want to debug it...when another application calls that dll.
plz help me
Paritosh
|
|
|
|
|
Do u have source code of the dll class?
<< >>
|
|
|
|
|
|
you just include the dll project into caller project (I mean main project) and debug...
<< >>
|
|
|
|
|
hi...just see the upper question in the forum.
thats my requirement.
bye
Paritosh
|
|
|
|
|
When ANY other application runs your dll, or do you know the specific app?
You can't just open your .DLL project, set a breakpoint, then wait for the breakpoint to be caught. The debugger has to be attached to the process that is loading your .DLL. Go to the Debug Menu, then pick Processes (or Attach to Process).
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Does any simple method is provided in VB.NET to chage a string to URL format?
just like the method in js: URIencode
Thank you?
|
|
|
|
|
Please do a search on google next time:
click
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
I have a long string is going to search.
For example, the string is
How can I using the regular expression to find the image location
"./html/img/abc%20def.jpg"
and replace it to
"abc%20def.jpg"
What I know is there must be
|
|
|
|
|
Please help me, i am not the best programmer and i need some help.
Is it possible to capture a (comma separated text string send by HTTP and store into a Access database?
The most difficult part for me is how to capture the data.
Peter
|
|
|
|
|
Is the comma separated string sent in a request or in a response?
---
b { font-weight: normal; }
|
|
|
|
|
The string is as far as i know send in a response, there are no requestes.
|
|
|
|
|
There is never ever a response without a request. A web server can not send a response without getting a request so that it knows what response to send, and where.
If the string is sent in a response, just get the contents of the response body.
---
b { font-weight: normal; }
|
|
|
|
|
That is exactly what i want to know, how can i do that (continously).
|
|
|
|
|
If you manage to get the response, what is the problem with getting the response body? What do you mean by continously?
---
b { font-weight: normal; }
|
|
|
|
|
I shall try to be more specific. I am completly new on this subject. A GPS receiver is sending a string, in http to my Ip address to a specific port. I try to figure out how to look at the port and pickup the string and after that put it into a text file or a Access database. Because i am completly new on this subject i asked for help. For you this is some basic stuff i think, but i have no idea where to start. With continously, i ment that the GPS receiver sends every 20 or 30 seconds a new string.
Thanks for your patience.
|
|
|
|
|
Hi Everyone,
Can we use ADODB and ADODC in the same porject?
Is there any chance of conflict?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
