Is there a way to transfer huge amount of data in a single shot from vb.net to Oracle database? I have a couple of thousands of records in my vb.net code which I want to update to Oracle database. What I do currently is, call a stored procedure in database once for each of those records. This would end up calling the stored proc couple of thousand times, which is highly inefficient.
View 2 RepliesI am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 RepliesI am inserting a block of 5000 records at a time, one block right after the other. The commands are created in a seperate DLL and can call anyone of 4 different stored procedures. Is there a bulk insert method that might speed this up. Currrently it takes about 1.5 MS per record and would like to get this down to about .7 MS.
[Code]...
I am working on a desktop application in VB.Net (4.0) There will a lot of SQL scripts which contains a lot of insert queries Currenlty we are running the scripts using SMO (http://msdn.microsoft.com/en-us/library/ms162557.aspx)For performance, we have planned to change the sql scripts to xml file ( instead of insert queries, it will have xml data with a proper xsd defined )Loads xml to dataSet and Using SQL Bulk Copy we are trying to insert to SQL Server.
[Code]...
Im trying to bulk update. I want to use viewmodel pattern. I read this article and create program. Program show Database value and html looks ok. But After submit, Controller couldn't get values. Every values are 'Nothing' please point me where I missunderstanding.
Public Class users
Public id As String
Public username As String
I am saving the bulk data to the database using xml format from vb.net windows application this is the procedure
[Code]......
i found that the error is comming because of passing "F&I" value in the parameter value if i pass only "FI" i am not getting error means the error comming because of passing "&" in the parameter value so if i want to save the values like "F&I" how can i save into the database using xml
How can I bulk copy a datagridview that has csv data imported, then export to SQL
Private Shared Sub CopyData(ByVal sourceTable As DataGridView, ByVal SQLDESTINATION As SqlConnection)
' column mappings example:
[Code].....
I have a problem regarding inserting many data into ms access.
View 2 RepliesI have a VB.NET application that creates a dataview from sql table and exports it as an excel file. Now, the data is inserted value by value. Instead, I want to insert the data from the dataview as a bulk insert on to the excel file. The data insert should happen from the third row, as I need to use the first two rows for column insert and data formating (which is done later in the program using excel macro.).Heres the code I wish to upgrade :
Dim strConn As String = "Data Source = LV-SQL2; Initial Catalog = TC_MASTER; user id = SQL2JOB; password = ******** "
Dim strSql1 As String = "Select Customer_id_1, file_name from customer_list_DA order by customer_id_1"
Dim da1 As New SqlDataAdapter(strSql1, strConn)
[code]....
I'm making an app where people need to log in, these data are on a Oracle 10g XE DB, I know how to access the data, but I don't know how to validate is the query returns something or doesn't (to validate the username and password, of course). I'm using an ODBC with VB.net to connect the DB.
View 1 Repliescan you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 RepliesHow to fetch data from SAP r3 to Oracle with .net?
View 1 RepliesI have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID1 52 83 5
e.g. SQL Table name DispTbl
[Code].....
How to access data from Ms-Acess and oracle?
View 4 RepliesI developed an application with old VB form and binding the data from Oracle database into VB form. Actually, I tried to bind the data more than 35000 records in to grid. But, it takes more than half an hour and also form was hanged and there is no output. Can you please let me know the solution to fix it and bind the data without any hang in my application. What are the steps to be followed to fix it?
View 1 RepliesI will try and explain my problem as simply as I can
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
CODE:
What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.
I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.
Below is the code for doing this in the same datasource:
Code:
I am using VB.Net 2005, just for info
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID
1 5
2 8
3 5
[code]....
So I have an application that queries a database for something like a social security number. Originally, the connection was established programmatically using ODBC. Now, I want to use the data source option built into Visual Studio.
View 2 RepliesI will use the Background Intelligent Transfer Service (BITS) to transfer files from a client (laptop) to a shared folder on a server within our local network.The problem is a very slow network bandwith, if we transfer a file, the other clients canīt work, all requests to other clients (application) or viewing internet pages needs a long time.My idea is to use BITS in my tool to copy/transfer a file from client to server, also I hope to get more performance for the internet requests.
View 2 RepliesI have 7 variables and i need to transfer them in a dataset I have already create the file with extension .xsd and i have already a report file .rdlc I see the Dataset "DataTable"in my rdlc file but i can't see any field It gives me error of "No Dataset is Linked to the document" From the other hand it sees the dataset in the selection dataset
View 1 RepliesSo, I'm making a log in page for 'student'. I've two forms. 1) frmStudentRegister 2) frmStudentHome
in frmStudentRegister page, student will enter his first name, last name, email, major etc and will create his profile. When he clicks on 'register' button, the information he entered on the text box will transfer to the second from frmStudentHome.
I've this codes:
lblFname.Text = frmStudentRegister.txtFname.Text
lblLname.Text = frmStudentRegister.txtLname.Text
lblEmail.Text = frmStudentRegister.txtEmail.Text
lblMajor.Text = frmStudentRegister.txtMajor.Text
But when I debug it, frmStudentHome won't show those entries. It's just blank !
I have a sequence that reads the selected Excel-file and displays the first row of the columns in the Excel. (The first Excel row has the column names)
Dim cmd As OleDbCommand = New OleDbCommand("select * from [" & tableName & "$]", MyConnection)
Dim dr As System.Data.IDataReader
Dim dt As New System.Data.DataTable
dr = cmd.ExecuteReader
dt.Load(dr)
With the above code I can read the the first rows of the Excel table and choose the names of the columns I like to keep. (By populating the first row to my ComboBoxes)
So, at the moment my DataTable dt has all the table header names but on the first row. And as the header names it has F1, F2, F3, ... F13.
How can I make my new DataTable dt2 take the first row of dt and make it the column names row? How can I choose which columns do I want to transfer from dt to dt2 ???
I have tried the following (Doesn't work):
Dim dt2 As System.Data.DataTable
dt2 = dt.Copy.Columns("F1", "F2", "F3", "F4")
DataGridView1.DataSource = dt2
I am working in Vb Express with MsAccess as database. I have a form with Listview data from Listview is transferred to the TableCustomer it is retrieved from that table back to ListView and after some additions is stored back in Tabloe Customer.I have another table Transaction in the same database which has some common fields of Customer Table in addition to its own fields. My two questions are :. How the data of one table can be automatically transferred to other table in MsAccess?
View 7 RepliesI am developing a windows app and i have a form in which i have 2 datagridviews..
dgv1 is the main gridview with checkbox column and when the user checks the box, that row should be visible in dgv3 (other datagridview)..
The code i used is :
Imports System.Data
Imports System.Data.OleDb
Imports System.EventArgs
[Code].....
can any one tell me how to transfer data through gprs to a oracle server using vb .net
i am using this coding below
IPHostEntry ServerEntry;
TcpClient Client = new TcpClient();
Stream SocketStream;
Byte[] InputData = new Byte[256];
[Code]...
i have a form with two list boxes and two buttons to transfer data between the list boxes.one button is the add and the other the remove. some code for these two buttons?
View 18 RepliesI'm currently working on a simple Jeopardy game in visual basic. My selection choices are made from picking the proper radio buttons. Questions is; how do I connect the two forms (form_1 & form_2) so that is will show the proper points after answering a question? I'm using lbl or txtbox for bank total after each question.
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
'contestestant "Max" choice
If RadioButton1.Checked Then
[Code] .....
Basically I want to take My Client.Then for example Lets say in my client I have "A = 1" Then my 2nd file which has random data in it.So Client= My Client File = The File which I want in the end result
How could I Inject "A = TextBox1.Text" from Client to File.I heard it's called "End Of File" or something like that.
I am trying to transfer data from one subroutine to another. This is not working "ByVal J(1) As Double, ByVal Max(2) As Double".
Private
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
...code
Call Data(ByVal J(1) As Double, ByVal Max(2) As Double)
[code]....
i'm working on visual studio 2005 vb.net language windows application.and i'm using MS access database with 2 tables customers and stopped. i have a form that the user will enter the IP and the stop date and when i press the button stop i want the all fields that r related to this IP to be transfered from customers to stoppedi wrote this code but i'm getting syntax error but i couldn't recognize the error. please i need help and how to slove it. this is my code:
[Code]...