|
Hi Friends,
Actually I have two Pcs On a Lan(Pc1,Pc2).DotNet is installed on pc1 and oracle is installed on pc2...Now Using explorer(isqlplus) i can Access oracle installed on pc2 using(http://pc2/isqlplus).Now my question is how to use oracle in Vb.net on Pc1.If I am using ADO.Net then Connection string is simple
"Provider=OraOLEDB.Oracle; Data Source=oracle; User Id=hr; Password=hr;PLSQLRSet=1;"
But actually oracle is installed on Pc2 so please tell my how can I do this show me some example
|
|
|
|
|
I suggest that you use OracleConnection[^] if possible. If you want a little bit better support against Oracle you can also use ODP.NET provided by Oracle.
Set Data Source in connection string to the name you have defined in TNSNAMES.ORA at client side or use network address.
After that you should be able to connect to the databse.
|
|
|
|
|
Hi all,
I'm recently new to .NET, but have background in VB6 and also web technologies for some years already.
Currently I'm developing an application in VB.NET from which I would like to implement a plug-in architecture.
This would allow to add extra functionality to the application without the need to compile it over and over, and also the chance for 3rd parties to develop their own plug ins.
The idea:
In a very simplistic idea, what I have in mind is something like,the main application (let's say main.exe) and a folder with the plug-ins (in this case dlls, that are basically compiled classes).
main.exe (Main modules, classes, etc)
plugins\myplugin_hello.dll
plugins\myplugin_import.dll
(..etc)
Did some 'web' research and apparently this can be achieved with the Reflection method.
After checking some examples, the way I found to be the most simple to implement it was the following.
No need to add here, for now, the code to parse the plugin folders, just will use one as example.
The code:
(main.exe)
'Read dll
assembly = System.Reflection.Assembly.LoadFrom("myplugin_hello.dll")
For Each fileType As Type In assembly.GetTypes
If fileType.Name = "xPlugin" Then
'Create new instance of class
Dim plugin = Activator.CreateInstance(fileType)
End If
Next
(myplugin_hello.dll)
Public Class xPlugin
Public Sub New()
MsgBox("I am a plug-in !")
End Sub
End Class
Apparently this is what I want, after compiling the xPlugin class (myplugin_hello.dll) and running the main.exe code, a message box with "I am a plug-in!" will be displayed.
The problem:
Well, now the problem is that I need to have some 'interaction' with both pieces of code, the main.exe and the myplugin_hello.dll, without that it is almost useless to have a plug-in : /
How could I, for example, access to main.exe classes and modules from xPlugin class (myplugin_hello.dll) ?
Best regards,
Luís
|
|
|
|
|
There's plenty of plugin articles here on CP.
Basically, you have to establish some sort of the common interface between the main code and the plugin. Usually, you'd base this in, of all things, an Interface, that each plugin would have to implement. This establishes what methods and properties the main code is going to expect each plugin to respond to. The same is true in the opposite direction.
|
|
|
|
|
Dear Friends
how can i iterate through a subset of a datatable in vb.net. Following code is an eg which does not seems to work.
Dim MonthlyDT As DataTable
MonthlyDT = NewMonthlyReportData.MonthlyReportDataTable 'Class Object
Dim MyDataRow As DataRow
'Parent DataTable with Filtering
MonthlyDT.DefaultView.RowFilter = "[MYID]<=716100"
'Set the Clone to be of Parent table
Dim MonthlyDTClone As DataTable = MonthlyDT.Clone()
For Each MyDataRow In MonthlyDTClone.Rows
Select Case MyDataRow("Classification").ToString
Case "Classification1"
Classification1 += 1
Case "Classification2"
Classification2 += 1
Case "Classification3"
Classification3 += 1
End Select
Next
Your help.
|
|
|
|
|
What does 'does not work' mean ? Do you get Id's above 716100 ? Why is the id in [] ? That is not required.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Sorry for the trouble guys, I have sorted the Filtering problem as follow, but now have the issue of filtering the correct subset based on the month and year value of MemDateAdded (datetime field). Following code does not filter the data instead returns the entire records in the datatable. But if I use any other filtering instead of Date, it works perfectly eg. (STATE='VIC').
MyTableDataRows = MonthlyDT.Select(("Month(MemDateAdded)" = 12 & " AND Year(MemDateAdded)" = 2008)) 'Monthly Total Only
For Each dr As DataRow In MyTableDataRows
Select Case dr("Classification").ToString
Case "Classification1"
Classification1 += 1
Case "Classification2"
Classification2 += 1
Case "Classification3"
Classification3 += 1
End Select
Next
I want to iterate the subset of datatable based on user selected month and year passing to MemDateAdded. User month and year will come from a DateTime Picker control. Basically I want to sum different Classifications and passed them to the variables, which I want to use later on other applications like Excel for poking.
Your URGENT help on this....
|
|
|
|
|
Galle Guy wrote: ("Month(MemDateAdded)" = 12 & " AND Year(MemDateAdded)" = 2008)
what is this??
When not sorting Select() expects a single string, and your selection doesn't use variables, hence put double quotes at both ends, not inside the string and forget about ampersands.
|
|
|
|
|
what are you trying to do?
well, its early in the morning, but some notices to your code:
MonthlyDT.DefaultView.RowFilter = "[MYID]<=716100"
this line is useless in your context. you are filtering the view but later on,
you iterate the underlying datatable
Dim MonthlyDTClone As DataTable = MonthlyDT.Clone()
also useless. you clone the original datatable and iterate it. the method clone()
clones the schema and constraints NO data. use copy if you would like a "copy".
i just can think of what you will do:
Dim dtMonthly As DataTable = NewMonthlyReportData.MonthlyReportDataTable
Dim dvMonthly As DataView = dtMonthly.DataView
'filter wanted data
dvMonthly.RowFilter = "[MYID]<=716100"
'iterate the resulting data
For Each drvMonthly As DataRowView In dvMonthly
Select Case drvMonthly ("Classification").ToString
Case "Classification1"
Classification1 += 1
Case "Classification2"
Classification2 += 1
Case "Classification3"
Classification3 += 1
End Select
Next
|
|
|
|
|
Filtering the data should also eliminate the need for a copy unless you have a specific need for that.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
How to Change Drive later of disk?? It Possible Please Help me??
For Example I want to Change the drive name D to
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Were you asking in the wrong forum before, or are you still hoping to do this in ASP.NET ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
No, he's just hoping that someone will tell him it is possible, he doesn't want to accept the truth
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Well, it sure seems likely.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Let's just say that if you changed the drive letter of the System or Boot partitions, either Windows, or any installed apps would no longer work.
Check out the code in this[^] article. Have fun crashing your system!
|
|
|
|
|
Hello all
Does anybody know how to access the "Save As Text" in FF programmatically?
Thank you in advance
Chandra
|
|
|
|
|
Firefox is a nightmare when it comes to emulating through programming (I know from experience). I would abandon all hope of using firefox programmatically and look into finding another solution.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Hi
Thanks for your reply...
What was your experience working with FF? Did you get anywhere? Maybe if you could give me some pointers, I could go along that path... even though it is not what you recommend. Right now, this seems to be the only solution I have, unfortunately 
Chandra
|
|
|
|
|
The aspect that I was trying to alter was the proxy settings for a network. I tried keyboard emulation by first starting the process with System.Diagnostics.Process class and then sending keystrokes to it through the said class. Mozilla does not work well with this method at all; I could not send text to the address bar and could not navigate between windows/frames. To get around this I had to find the configuration file where everything is stored which is located in a particular place for a profile.
This link should be able to help you: http://www.vbforums.com/showthread.php?t=532442
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Thank you - I have been trying something like this too...
|
|
|
|
|
I'm a senior at Montour High School and we have to do projects in order to graduate. My project is to create a phone book and have it store contact information. Ive been contemplating different ways of doing this and i tried using strict txt files but thats very insecure. So my question is how do i go about using or creating a database to store this information (all in all there are aprox. 16 fields)
i know how to get the information from the fields and i know how to set he information in the fields. if more information is needed please ask.
Thanks
|
|
|
|
|
You can use MS-Access as the database engine to store the data and write the application in Visual Basic to access the data.
|
|
|
|
|
Ask your instructor if there are any limitations. Sometimes the DB is dictated/limited by the instructor.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
You can use SQL Express, its free and much better than Access.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I second that. There are times I wish Access would be a legacy product...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
