|
I answered this cross-post in the XML forum. Please don't cross-post.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
I now have several buttons on my Form, which process various Oracle select statements and even display the output in listboxes or labels. Can someone tell me if the items below are also possible in VB.NET?
1. Write a query to support using Join Statements that display data from Multiple Tables. (I was able to do a select statement from two tables and display the results in a textbox).
2. Write a query to support the project using Sub-queries.
3. Write a query to support the project using Reports and SQL statements.
4. Write code to support the project that creates and manages Tables, Tablespaces and Database Objects. (I tried editing the sample and by changing the "select department_name from departments where department_id = 10" to
create table emp2
(
emp_First_Name VARCHAR2 (100) PRIMARY KEY,
emp_Last_Name VARCHAR2 (100),
emp_years DATE,
emp_salary NUMBER (8,2)
)"
but this did not work and generated several syntax errors.
5. Create Users and Manage access to the Oracle Database. (Like add a user and the permissions for that user).
6. Code S-Q-L statements within P-L-/-S-Q-L, built-in S-Q-L functions, Cursors, subprograms, packages, triggers and error handling to support the project. ( I have found some examples on the net, but have not been able to make any work, like the ones in the samples from the link you provided).
7. Write code to employ Composite to support the project. (Is this possible?)
8. Employ and demonstrate Cursors.
As you can all see, my basic issue is that I am trying to process various queries using buttons in VB.NET and then display the results in a text box.
Any help with this, would be greatly appreciated.
Thanks again Joseph!!
vbsquire
|
|
|
|
|
Hello code Gods! I'm a newbie to VB.NET and really need some help. This may seem basic to you all, so please leave out the laughs. Lol
I'm trying build a basic VB.NET application that has a datagrid and 2 or 3 buttons. The buttons would be: CreateTable, Alter Table, Drop Table. I want to be able to run Oracle queries and perform these types of actions. I've tried 20 different samples from the net, but none seem to work. It would be great if someone could just help me with the code, for a button that would query the table and display the output in the datagrid. That would give me a great start.(Like select * from emp;). (Or create table store). Obviously I am years away from being able to provide the user the ability to enter the values, which take affect after the button is pressed, but for now, it would be a major win, if the values can at least be hard-coded.
This is really hard for a newbie and I'm starting to lose hope.
Thanks in advance to all of you! I've read many of your posts and I keep my hope.
vbsquire
|
|
|
|
|
|
Thanks so much!! I will have a look right now.
vbsquire
|
|
|
|
|
I have seen a few post on web regarding issues with getting a security update for .NET 1.1 SP1 - KB928366 to install correctly. I can not install it, as a result every reboot I get a Windows Update prompt to install it.
Has anyone had this problem and rectified it.
Thanks in advance.
|
|
|
|
|
Nope, haven't had the problem...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
A verbose Windows Installer log might help you track down the problem. Try setting the registry key described in this KB article[^]. Unfortunately the reason for failure is normally in the middle of the log file: it's followed by logs of all the operations performed to undo the actions that succeeded before the failure occurred. Search for the words 'Action ended'. The failure should appear just above that point.
|
|
|
|
|
Hello
On Windows XP ( maybe 2000/2003 also ) , if a layered window setup with SetLayeredWindowAttributes , when its size changes , the GetLayeredWindowAttributes doesn't work , the function returns false
What should i do to get window's alpha in that case ?
Thanks
Declare Function GetLayeredWindowAttributes Lib "user32.dll" (ByVal hwnd As IntPtr, ByRef crKey As Integer, ByRef bAlpha As Byte, ByRef dwFlags As LWA) As Boolean
Dim a As Byte
Dim Flags As LWA
If GetLayeredWindowAttributes(hWnd, 0, a, Flags) Then
If Flags And LWA.Alpha Then Return a
End If
|
|
|
|
|
Hello
I want each created System.Windows.Forms.NativeWindow run in its own thread
These native windows are message-only windows and created with this System.Windows.Forms.CreateParams :
Sub New()
Dim CP As New CreateParams
'CP.ClassName = "Message"
CP.Parent = HWND_MESSAGE
MyBase.CreateHandle(CP)
End Sub
How can i do ?
|
|
|
|
|
You can specify the procedure/sub in the CreateThread, me thinks. But, I'd be careful about multithreads over form controls since it is not really thread safe...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi All
This is my first ever post in a message board, so hoping for a warm welcome!
I am looking for a way to validate mpeg and avi video files without looking at the extension name. I have validated image files using the system.drawing.image class but I cant seem to find anything in .net 2 framework which will return the file type for a video file.
I would aprpreciate any pointers on this, but I dont know C, or C++
so any code example in C# or VB would be really good.
Thanking you in advance
Rai
|
|
|
|
|
The Video class in the managed Direct Show SDK ( part of the platform SDK now ) will load and play a video. Not sure if just trying to load a video with this class will verify it as being a video, or if you'd need to try and play it.
There's also the Windows Media Player control ( which doesn't require a download ), but then you would absolutely have to set it up to play a file, and you would not be able to tell if it was video or a still image.
Welcome BTW
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I am looking for a way to connect to another pc in the domain and then flash a message to them on the remote pc. Windows messenger is disabled. Is there a way to do this in the .netframework or WMI?
any help is appreciated.
Tomcoll67@msn.com
|
|
|
|
|
With the messenger service disabled, no.
You'd have to have another messaging client running on the machine to display the message.
|
|
|
|
|
|
That needs Internet connectivity and does not befit a closed LAN setup right?
|
|
|
|
|
If you have no access to the internet you would not be able to user web messenger. Sometimes, like in my case I have access to the internet, but the block the ports for instant messaging.
Ben
|
|
|
|
|
Hi,
From where i can find the help of Assembly Binding Log Viewer(Fuslogvw.exe)?
Best Regards,
Mushq
Mushtaque Ahmed Nizamani
Software Engineer
Ultimus Pakistan
"English is my second language, so please don't mind if i do some grammatical or spelling mistakes in my messages."
|
|
|
|
|
Easy if you know how to type "Fuslogvw" into MSDN. Like this[^].
|
|
|
|
|
how can i change the legend name ina pie chart if i have 2 categories?
thank you!
jyn
|
|
|
|
|
I have a windows application developed on Dot Net FrameWork 2.0 , on a 32 bit machine(using C#) , I am skeptical if it will work without any issues on a 64 bit machine with the same Dot Net Framework 2.0. Please let me know if my doubt is true. If it is true please let me know the solution.
Happy Programming!
Regards,
Nikhil Pagidala
|
|
|
|
|
As long as you have 32-bit versions of any third-party DLLs installed it should run just fine as a 32-bit application on Vista 64-bit. If you have the code, you can compile it to target the x64 architecture, in which case it will run as a native 64-bit application. The only restriction is that any third-party DLLs must also be 64-bit. You can't mix 64-bit and 32-bit assemblies in one application.
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
Hi,
if your app uses P/Invoke (e.g. to call native Win32 functions) you may get a couple
of minor surprises, since IntPtr now is 64-bit, so if you want to do arithmetic operations
on it, you need IntPtr.ToInt64(), not IntPtr.ToInt32(); also a lot of P/Invoke prototypes
available on the web are wrong in 64-bit environment, most notably SendMessage and the like
(they should use IntPtr, not int/long/whatever, for wParam, lParam and result; at least
that is how I understood it, I havent used Win64 yet).
|
|
|
|
|
Hi ,
Thanks a lot for the information,
Also if the project is compiled on a 64 bit machine , will it run on a 32 bit one?
Please let me know ,
Thank You ,
Warm Regards,
Nikhil Pagidala
Happy Programming!
Regards,
Nikhil Pagidala
|
|
|
|