I 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 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 RepliesIs 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 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]...
am an computer engineering student, & these days engaged in a project, the front end tool is vb.net 2008 & the back end tool is oracle10g... am using windows xp as OS.... am not getting option of connecting oracle10g.. i guess, oracle10g is properly installed in my system... then so am not able connect it...
View 1 RepliesI have some stored procedures to execute that use dbms_output.put_line() to put data into the output buffer.I know I need to use dbms_output.get_line(:line, :status) to retrieve that output.I'm using ystem.Data.OracleClient to avoid headaches with Oracle deployment.So what am I doing wrong with the code below?
Dim cmdSproc As OracleCommand = cnOracle.CreateCommand()
Dim strOracle As New OracleString()
Dim opaLine As New OracleParameter("lineOut", OracleType.VarChar, 255)
[code]....
can 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 RepliesI need to insert a row with a DATE value. How do I set its default value to Now() or similar?
View 1 RepliesThe following code works fine. However, it only inserts on TextBox1, one filename. I would like to be in aposition to add more than one filename. Can anyone please tell me how I can achieve that.. code below; Private Sub BtnFolder_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnFolder.Click
[Code]...
which is that my checkboxes will only insert one record at a time. The modal pops up and I click on 2 checkboxes, yet only one is inserted into my database and displayed on my page. I have to check boxes 1 at a time, and I have many, many checkboxes. Here is the code I have.
<!-- Add a Feature -->
<li>
<asp:LinkButton ID="FeatureButton" runat="server">Feature</asp:LinkButton>
<asp:Panel ID="FeaturePanel" runat="server" CssClass="modalPopup" Style="display:none">
[code]....
so I have chosen to add the database to my vb project when the connection was being set up in Visual Studios 2010. so the code below inserts it to dataset, but database doesnt seem to be updated, I am trying to add new records to Business and Login tables and have defined two functions to assign the value of text boxes to the fields on the records: [Code]
View 6 RepliesI have a while loop where it fetches record from csv and inserts to sql table. Now csv may contain many rows.What I want is if one row fails just log to a file and continue with next record.I was thinking of try and catch but that will exit the program.
while (csv.readnextline)
'assign csv columns to objects
try[code].....
I have the following code which works fine with a listview called LvwColProc;. This inserts the value to textbox TxtColType. TxtColType.Text = LvwColProc.Items(0).SubItems(1).Text
Now I have a datagridview, called DgvActiveProjects..How will change the above code to enter the same value to TxtColType textbox.
I am writing a windows service that will read records from one table and write them to another table. Problem is when i declare cmd = New SqlCommand(l_sSQL) the code stop executing but the service will still be running. I can insert into the other table using the service but i cant read from the other table.
Code Sample:
Private Sub dbcon()
Dim con As New SqlConnection
Dim cmd As New SqlCommand
Dim adapter As New SqlDataAdapter
[code]...
My textbox is supposed to enter one value and enters about 8 of the same thing.
<li class="item">
<asp:LinkButton ID="FeatureButton" runat="server">Feature</asp:LinkButton>
<asp:Panel ID="FeaturePanel" runat="server" CssClass="modalPopup"
[Code]....
I have an application that inserts data to a sql server db when it receives input. The problem is that i see many duplicate entries in the table. I have checked my code and it shouldn't do that:
[Code]...
I have a modal popup that allows an admin to choose from a variety of checkboxes to add features to a specific product. If there is a checkbox that an admin believes should be available but isn't because that feature is not in the database, I have added a textbox so that user can add a new feature to the product.
Once I added the textbox, it stopped allowing inserts. At first it was in the same If Else as the checkbox for each loop, but I have recently changed it so the textbox is in it's own for each loop. I have an underline under the words txtFeature.Text that says Value of type 'Char' cannot be converted to 'System.Web.UI.WebControl.Textbox.'
vb code:
For Each feature As ListItem In cbxAddFeature.Items
If feature.Selected Then
Dim strSQL As String = "INSERT INTO Marketing
[code]....
TableAdapter.Update(...) Inserts NULL Values in all columns for a new record?
View 4 RepliesSo, today I was programming, and then right clicked and noticed a 'Insert Snippet' option. I've seen it before, but never clicked it. I thought this was an amazing thing. It had predefined code which auto inserts. Was just letting some of our other members know, that it does include some predefined things such as 'Write to a text file', etc.
View 4 RepliesNow i got it to work but the bulk copy is inserting the rows twice, instead of once and i know the table has the correct rows because i can see it in the gridview correctly I FIXED THIS PART my program works fine when i run it in debug mode but not when i place it on the server, it doesnt run the stored procedure when i put it on my server.
Label1.Visible = True
Dim tourid As New List(Of String)
tourid.Add(TextBox1.Text)
Dim tasktype As New List(Of String)
[code].....
bulk update in datagridview
[Code]...
In my windows application i am inserting bulk insertion in a table for that i am using
Dim da As New SqlDataAdapter("select empno,name,sal from Emp", con)
Dim ds As New DataSet
da.Fill(ds, "emp")
[Code]....
I am using VB.NET with LINQ to MS SQL.I have two following tables. Now I want to insert multiple items in Tags Table using LINQ, but also wants to check that if any of tag exists in Tags table. It doesn't insert it again and bring the TagID in both cases (if inserted or if found existed)[code]What's the best way to acheive this using LINQ?
View 1 Repliesutilizing the whole LINQ to SQL method?
I've got a DB with about 7 tables I'm trying to link some .net pages to and as much as I can qry most of these tables, I'm having a heck of a time inserting into them. One complex scenerio I am finding revolves around the use of a GUID and how to get that particular GUID to propogate over into another table...
1) how to send bulk email using asp.net.. , have you googled this it has so many softwares but i have to implement in .net. ie: if i send the email to 10,000 users so i have send email at a time , each user should get personalized email on TO address , suppose if the email doesnt exist or not working etc. so i have to show the status of each and every userid whether email is send or not..
2) And i have one doubt suppose if am sending the email to some 100 user, in the middle ie : 50 userid will not exist at that time whether loop will be continuing or it will stopped.
I'm using sqlbulkcopy to load data into a sql2008 database, and we're getting timeout errors loading larger tables. Some tables which were loading OK are failing since indexes have been added to them. The source data is a Informix datareader. I've tried setting large values in both the connection timeout and the sqlbulkcopy.bulkcopytimeout, but the timeout usually occurs within 60 seconds, well below the timeout values I've set (240 secs). I've tried setting the .bulcopytimeout property to zero but it makes no difference. Very occasionally a load will take place - the last large table to load took 7 minutes. I've reduced the batch size to 500.
The documentation on bulkcopytimeout that I have found does not describe what the property actually means - is it the maximum time to complete the entire copy or to complete one batch or what ?Here's some extracts from my error log - the first shows a successful large table load, follow by timeout failures.
24/11/2009 10:59:01
Level : Information
MISLoad - Starting load from Mach4 to ParagonMIS of all selected tables
[code]....
I am looking a way to insert hundreds of string into vb6 res file. Spent 2 hours of searching.Is it available at all?
View 2 RepliesWhen I double click on a form control while in the design view in a Web Application project within Visual Studio 2010, say a 'button' or a 'submit' for example, it inserts a javascript function into my .aspx file. When I do this at work it automatically creates an event handler for the control in the code-behind.How do I change this to that setting?I don't want to type those event handler subroutines every time!
View 1 RepliesIm 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 have hundreds of .pdfs that I downloaded that have names that are not helpful at first glance. Part of the download was a 'key' that lets me know which file belongs to which person (I have this in excel). I'd like to know if there is a vb script out there (or one I could get help writing) that would look in a folder and rename the files based on the accompanying spreadsheet.
View 5 Replies
