Manipulating Data From An Oracle Temporary Table
Sep 7, 2010
I have a VB.Net application that populates an Oracle 11g global temporary table. I can see data in the temporary table by loading it into a grid and everything looks correct.However, when I call an Oracle stored procedure from VB.Net that would manipulate the data in this temporary table, the stored procedure reports that my temporary table is empty.I understood that data in an Oracle global temporary table should be visible to all sessions.
View 1 Replies
ADVERTISEMENT
Mar 15, 2008
i am using visual studio 2005 and database sql server 2000. i want to read table of database and readed data insert in temporary table again update that inserted record.
View 3 Replies
Feb 9, 2012
I am wanting to pull data out a select table and wanting to use it locally as Read Only data I am stuck on how to write the data to the local Temporary table[code]...
View 1 Replies
Mar 1, 2012
I need to code the following:
1.Connect to an Oracle database.
2.Execute a query.
3.Insert the query result into an Access database table.
View 7 Replies
Jun 11, 2009
I am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does anyone know a cleaner & more efficient way that looping through the ranges creating & executing insert statements?
View 3 Replies
Mar 3, 2009
I have a string array that contains the following:
(Date Type RequestNum)
3/3 xyz 3
3/3 abc 4
[code].....
View 1 Replies
Jun 21, 2010
I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 Replies
Apr 30, 2010
I'm creating a program that displays data from a Access database in DataGridView, and I'm able to "call" the database and display it in datagridview normally, but I need to be able to take the data from 3 separate columns and average them together, within VB.
My table basically displays 3 grades for a student, one column for the student's name and the other 3 columns for 3 separate grades, I need to be able to take the 3 grades from the same row and average them together, then display them in a separate column within DataGridView.
Here is my code so far, but this only displays all the records without the average:
Quote:
Public Class Form1
Sub UpdateGrid(ByVal sqlStr As String)
Dim dt As New DataTable()
[Code]....
View 3 Replies
Jan 10, 2012
I am using the Print Document to create the impression in vb.net...Anything I set a certain number of records per page however see the other pages just like the first,some help to handle these records correctly in the leaves?
View 4 Replies
Apr 26, 2010
I have developed an application using VB.NET, Visual Studio 2008 and the SQL Server database. Now I want to ignore the database (it has 1 table as customer (name,password,hour,minute)) as I don't want my client to install SQL Server separately or other overheads.I am planning to do the whole using file handling in VB.NET (manipulating the data in files itself, for example change username, password, etc.). As I am new I don't actually know the proper way and of course need assistance.
View 4 Replies
Oct 2, 2009
How knows how to create a temporary data file in vb.net without using sqlserver.
View 2 Replies
Apr 14, 2010
The products file contains data such as prices and the product used such as TV. I want to be able to manipulate the data in the product and location file so i can set different products to different location types.
View 5 Replies
Feb 22, 2012
looking for simple code for adding, deleting, editing, and updating data using binding navigator in vb 10. first time using, been using vb6 and code is totally different.
View 1 Replies
Aug 9, 2011
The DB has a field "end date" and 1753/1/1 is supposed to be the value representing nothing, as we cannot assign null to datatime in sql server..
In reporting application the select querry used, gets the data including those 1753 date values. good
Problem 1753 date causes hell with report calculations. there are a lot of calculations in the report and changing the code to ignore 1753 will be a headache, so i was thinking Is there a way to tell sql server,
SELECT *
FROM TABLE BUT IN END_DATE
WHERE VALUE='1753/1/1 01:00:00.000' REPLACE WITH PARAMETER1
CRUDE EDIT (donot have access to debugger currently)
i cannot remember but i get an error like "nothing should be mapped on something" when i insert record with null date! THIS HAPPENS ONLY WHEN USING VB.NET in csharp it works fine. do you know why??
View 5 Replies
Jun 26, 2011
I have to make files encrypt in my application. Now, I'm writing the encrypted data to temporary files (fsOutput in the code). I upload this file by FTP to the server. How should I rewrite my code if I want to upload without creating a temporary file and by using stream? My FTP client is able to upload from stream. My FTP client uses PutFile method to upload files ('Upload from stream by StarkSoft ftp.net in my code)
[Code]...
View 1 Replies
Jun 21, 2009
I'm trying to write a vb.net application that works with a 3rd party application called FuzzyTech. Unfortionalty FuzzyTech is quite old so the only way I can interact with it is buy using DDE. FuzzyTech acts as a DDE server. After a bit of research I found a library called NDde which enables me to use DDE. I understand that vb.net does not natively supprt it as it is an old technology.
Now fuzzyTech seems to only respond to the DDE connect and pokes when in debug mode. The only way I can find to get the program in to debug mode is from the menu bar (Debug > Interactive). So I have written an application that runs fuzzyTech, grabs the window and then accesses the menu to put it in to debug mode. My code can then use DDE. I have all of this working ok (although it does feel like a bit of a hack). The problem is I don't want users to be able to see this happening.
I want fuzzyTech to be hidden.After more research I found I could hide the window on startup by using fuzzypProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden. However when I do this my code to grab the window and send the menu commands then fails. I think this is because the window title becomes blank when hidden.So I need to know a way of controlling the program after it is hidden or hiding it after it is in debug mode. This is where I am stuck. I'm very new to programming and this has got me completely stumped.
Here is some of the code I am using:
Private fuzzypProcess As Process = New Process()
Private Sub LoadFuzzyTech()
Try
fuzzypProcess.StartInfo.FileName = projectPath & projectTitle & ".ftl"
[code]....
View 2 Replies
Sep 10, 2011
this is not really a code issue, more of an events issue with objects. I want to be able to generate an output as the user inputs into each text box under the "further invoice details" section. For example, if the user inputs a value to amountrequired text box. Then a gross total is auto generated without the need to click a button.
[Code]...
View 1 Replies
Apr 21, 2009
I have an project which was written in VB6 and made use of the Spread3.0 component to display multiple large data from database in spreadsheet. My objective is to convert this project into a VB.NET current version which would not use the third party component but can possibly use a freeware that does similar if not all the functionality.
My question is, are there any freeware that is available in .NET for such spreadsheet-like manipulation of data programatically? I have come across dsoFramer but this only allows the display of the data in an IE frame. I would like to jus embed the content into my existing form.
Also this freeware must be able to handle formula and user-editing as well as multiple cell type such as combobox/checkbox etc.
View 1 Replies
Sep 1, 2010
I have an project which was written in VB6 and made use of the Spread3.0 component todisplay multiple large data from database in spreadsheet. My objective is to convert this project into a VB.NET current version which would not use the third party component but can possibly use a freeware that does similar if not all the functionality
View 1 Replies
Jul 27, 2009
This is my first time working with VB, though I've been working with VBA for a couple years now to automate office routines at my work. At my last job, I saved about 3 hours a day with my automations, and at my current job, I'm shooting for about the same. The problem is, though I have a high affinity for computers and technology, I never studied to be a programmer, and so I really can only tweak code I find online, and then eventually build up enough of my own subroutines to accomplish the tasks at hand. This is why I'm posting here on this forum, I've reached my wits end for what I imagine is a relatively simple problem. This was initially written in VB 6, but I imported and converted it with Visual Studio 2008, and it runs fine. This demo code is set to populate a PDFwith some sample string text. What I want to do is to replace the string text with a reference to data in either an Access or SQL database - I prefer Access, but either will work. Here is a sample of the demo code I'm working with:
[code]...
On this last line, I want to replace the "1" sting text with a reference to a temporary 1-row table I'll be generating from an Access Query, with Field Names to match the Form Field names of the PDF, So I've setup an Access DB with the following configuration (in reference to the path, I'm using Vista x64):
[code]...
I have also imported this table as a dataset (my understanding is that the import into Visual Studio 2008 makes it a typed dataset?) so either referencing the access DB directly or the imported Dataset should work. I can also setup the Access DB as a SQL DB instead if it would make it easier. Now, if I was programming in VBA, I might do something like this:
[code]...
View 8 Replies
Jul 27, 2009
I want to create Table in Oracle database from my asp.net application by using ado.net
View 1 Replies
Oct 5, 2009
So hopefully this is a quick fix but for the life of me I can't figure out how to get my results from a OracleDataReader record set.Just trying to get all the users for a specific TNS into an array. I was able to do this easily before with ADODB, but thought I would try using ODP.net.Here is what I have so far and it definitely gets all the USERs for a given TNS. its when I get to the READ() part where the syntax is ??
View 1 Replies
Jun 9, 2011
Relatively new to VB.NET coding. Am creating a pretty simple console application that needs to insert over 50,000 records into an Oracle table (OleDB connection). I tried 3 different methods so far: Individual INSERT, insert using a dataset, & using INSERT ALL (commit every 25 records due to # of columns). It seemed like most articles/posts I read recommended the dataset approach, but the INSERT ALL code was definitely the fastest by far.
View 15 Replies
Jan 11, 2010
ODP.NET Query - Error manipulating data from Stored Procedure??
View 3 Replies
Apr 21, 2009
Ive completed this code, and it enters names into the combobox, but not any of the tables that i have created. I have checked that they have been created and they have. An ideas?
Dim DatabaseConn As OracleConnection
Dim DatabaseConnString As New OracleConnectionStringBuilder
With DatabaseConnString
.DataSource = "XE"
.UserID = "SYSTEM"
[Code]...
View 9 Replies
May 17, 2012
I have a table in Oracle with a column userid and i have a userid column in Active Directory. based on this i want to query the Network ID and update in one of the Group in the Active Directory.
View 1 Replies
Apr 17, 2012
have a table in Oracle with a column userid and i have a userid column in Active Directory.based on this i want to query the Network ID and update in one of the Group in the Active Directory.
View 1 Replies
Dec 18, 2008
how can I check if an oracle tabel is lock in VB .NET?
View 3 Replies
Jan 25, 2009
Reading binary file from hard drive in VB and writing to database.
View 3 Replies
Apr 29, 2009
If I have this to read from an access database, how could I translate it to read from an oracle database with the same table/field information? I know nothing about oracle but I assume I cannot use the oledbdataadapter that I am used to when connecting with an oracle DB.
[Code]...
View 6 Replies
