Transferring Data Between Two SQL Servers Using VB?
Jun 12, 2011
The title of this thread perhaps does not explain my problem correctly.Actually i am developing a financial software for a company.The software is similar to a banking system. The software is being developed using VB 2008 and SQL Server 2008.The company has its branches located at different locations. They are having a centralized SQL Server at their Head Office.The branches are connected to Head Office using a VPN.Now what we are worried about is when the VPN gets disconnected.For that we will be having a SQL server installed at each of the branches.When VPN is connected the the details entered will be directly at the Head Office database,Meanwhile a program will be executed which will get details from the Head Office database at each of the branches in a XML file.When a branch gets disconnected from the VPN another program will get the XML details into the Sql Server installed at the branch. When the branch is connected again Another application will create a xml file from the local server and insert its details into the HO server.The sizes of the XML are reaching upto around 150 to 200 mb. I am using Dataset.WriteXML and Dataset.ReadXMl. I have tested this on my local machine it is taking upto 30-40 secs.I dont know how much it will take when the actual application is installed. How can i speed things up ? Does anyone have any idea on how i can do the whole process more smoothly and faster?
View 5 Replies
ADVERTISEMENT
Sep 29, 2011
I don't really know how to code but am pretty good at tweaking. I'm trying to set up a script that I can run to delete a single file, multiple files, a folder or multiple folders on a list of servers.I was thinking that the script could read the files to be deleted from a .txt file and apply the deletion to a list of servers in another .txt file.Example:
FilesToBeDeleted.txt:
\(insert_server_name_from_list)c$Program FilesBINexample_file.rpt
or
[code].....
View 1 Replies
Jan 7, 2010
I have the following code in place: Protected Sub btnBuy_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnBuy.Click Session("ShoppingList").add(New OrderInfo(txtQuantity.Text)) Server.Transfer("ShoppingCart.aspx") End Sub
View 5 Replies
Jan 3, 2006
I wanted to write a small piece of vb code to synchronize a few FoxPro dbf tables to SQL tables that having the same structure or at least a few fields that i selected. I had tried a code which I found on the net that running row by row and column by column to update the SQL tables but this code is too slow. In my dbf table it contains around 3000 records at least.
View 12 Replies
Jun 17, 2011
i want 2 copy some part of one table into another but getting error @ this line
sqlCmd = New SqlCommand("insert into name_table(name) values ('" & ds.Tables(0).Rows(1).Item(0) & "'", sqlCnn)
View 4 Replies
Jun 12, 2011
I'm doing a project that requires me to create a book ordering form. I have the books displayed in a listbox named bookselectionlistbox, and when a book is selected, it displays the price of that book in a label named bookpricelabel1. I have a button named addbutton that allows the user to add the book to the shopping cart. The shopping cart is in the form of a combobox named shoppingcartcombobox. Lastly, there is a receipt button that transfers ALL the books from the shopping cart to a seperate label called label3, not just the selected book. The last thing I need to do is have the price of each book also transfer to the receipt section. This needs to be done either on the same label3 on the same line as the book title, or on a seperate label that is adjacent to label3, I have temporarily placed a label there named label5. I am using a case statement for the bookselectionlistbox to say that when a certain book is selected, the bookpricelabel1 will display "$xx". I also have an IF statement under the addbutton label that generates a total price for all the books in the shopping cart, here is an example of the code I used for one of the books:
[Dim visualbasic As Decimal]
[If shoppingcartComboBox.Items.Contains("Visual Basic") Then]
[visualbasic = 55]
[Code].....
View 4 Replies
May 18, 2012
I would like everything in listbox1 to transfer to listbox2. I didn't paste my whole project because it is messy and lengthy but I was able to re-create the scenario with this code:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
bottom line, I want everything in listbox 1 into list box 2 when combo box = a and button is pushed. when I try to execute, only one or less go into the second list-box and the rest stays there!
View 4 Replies
Jun 6, 2011
I'm developing a project for gathering customer feedback using a Samsung Q1 Ultra, a cheap touchscreen PC. The project consists of two parts: a PC based application that builds the survey and stores the info on an SQL Server, and a survey viewer on the Samsung device which downloads survey data from the SQL Server and stores it on a SQL Server Compact 3.5 database.
My question is, how best can I transfer survey data from the SQL Server to the handheld device's database? Writing a tonne of code to copy data from one database to another seems overcomplicated - is there a handy function or somesuch that I can use to copy data from identical tables on these two separate databases?
View 2 Replies
Aug 3, 2009
My assignment involves wrinting an airline reservation brogram where the user can hit a make reservation button and the user can then input passenger name departure city and arrival city, all of this has to print to a multiline textbox, the professor also wants a find reservation button and a cancel reservation button.
Public Class Form1
Sub get_data()
Dim passengername As String = InputBox("please enter passsenger name")
Dim departure As String = InputBox("please enter departure city")
[code].....
View 5 Replies
Jan 17, 2010
How would I go about transfering data within textboxes on 1 page, to the same textboxes, but on another new page.
Basically, I already have coding that caluclates distance time, price per litre of petrol (it's a bus firm company application), and put's it into textboxes within a group box on my page. Basically I just want a bit of coding which will transfer this info, to different texboxes, but on a different new page, the idea is that I can then do fresh coding on that page without it interfering the coding on the current page.
View 2 Replies
May 4, 2011
Visual Basic 2010.I excel in transferring reports on problems in formulas..[code]
View 3 Replies
Mar 7, 2011
I want to transfer my data from one list box to an other and save the data and display it at the same time with the TIME, Name, and the Quantity. For example, if I have a movie ticket, and says I bought one ticket thats 10 dollars. If I did type all the calculations with tax it should be 10.10 for the 10% tax. This will show on first of my list box. Secondly if I press something like Enter, it will show that 10.10 number and also put it in the other lstbox. I have 3 list box. One to show the current transaction, one to show the history of them and the total amount of all transaction.
View 8 Replies
Dec 28, 2010
I am new to ADO.Net and I mistakenly using the dataset as how we use recordsets in ADO., I know that it is possible to create a Datatable which will only reside in the memory and hold data. What I need to create is like this.
1. Create Datatable.
2. Fill it with sample data at least 3 lines.
3. Transfer the data from datatable to database (access,sqlsrvr etc).
View 2 Replies
May 27, 2009
I have 2 forms in this application. One form is just a simple SQL statement that is generated into a grid. It displays columns/rows. From there I want to be able to click on a row and have the first column of that row transferred to another form. In the second form I want it inputted into a text box. So, the user doesn't have to copy the record back out of the form then open the other form and paste.
The form opening and closing is not the problem. The problem is getting the data to transfer from one form to another!! I am not sure how to do it.. I have only been coding in VB for a few days and no formal training. I am aware of global variables and would be willing to assign the data to a variable and then have it transferred into the textbox of a the second form.
I do not know how global variables work in VB. This is what I got so far............
'The user clicked the transfer button.
Dim obj As System.Data.DataRowView = grid.Current
MsgBox(obj.Item(0), vbInformation, "Selected Data")
[Code] .....
View 2 Replies
Dec 19, 2010
I m working with a appliction in VB.net
I have a three forms .Menu form which i have set IsMdiContainer as true
Through this form I m opening a new form named " Query"
This form has two drop down and one textbox and some other controls
When user selects ths first dropdown (States)second gets filled with City
When use selects a city I wat to open a New form named as parameter.parameter
form has two textbox and user will enter the paramater and click the submit button.
I want the text of these two textboxes in My "Query" forms 's text box and I want the drop down as it is(filled with city and states)
View 3 Replies
Jun 7, 2011
I have a listview and Contextmenustrip control. Listview contains one coloumb. How to transfer ListView data to ContextMenuStrip?
View 2 Replies
Jun 28, 2010
I have written a VBA code in EXCEL that updates my tables in Access. The code is fully functionnal when I am entering new data but I don't know how to make it work when a data (primary key) already exists and that I need this data for another table. I would like to find a code in this format (DAO) :
If value exists in table Then
Return the value.code (not the value but the code related to this value)
else
.addnew
here is what I have tried but does not work:
Code:
Function Find_Last_EngineCode() As Integer
Dim cn_engine As ADODB.Connection, rs_engine As ADODB.Recordset, feuille As Worksheet, plage As Range, last_record As Integer
Set feuille = Application.ThisWorkbook.Worksheets("To_Access")
[code]....
View 1 Replies
Apr 5, 2009
I have a psychology experiment that has users respond to specific text or pictures by pressing either a button for "similar" or a button for "opposite" and then the program records the time from the presentation of the stimuli to the time they press one of the buttons as the latency. I have the information ans some other data successfully exporting to a text document but would like to have just the latency data also go into an excel spreadsheet for easier analysis. Here is the code for one of my buttons that currently writes to the text document:
[Code]...
View 3 Replies
Apr 16, 2009
I'm developing a management program for a driving school, where information about all students is stored and accessed.
The thing is, this school has got two branches, so I need some way for those two computers to share files with each other in order to keep a common database. I would like to use the same program in both computers, to keep simplycity to the maximum.
I know it's using TCP, but I haven't got the lesser clue of how i can achieve that. I've looked around, but I haven't found much of how to acchieve something like that. The files both computers would be sharing are text files.
About the IPs, I'm thinking of using NoIP or one of those to always know both IPs.
View 1 Replies
Aug 23, 2010
I'm developing a program that handles money, and there is a pre-made excel spreadsheet that I am to be transfering data into specific cells. How can I go about telling my program to write specifc data into specific cell numer in excel? Also, how can I get my program to write into specific areas of a MS Word Template (my program will generate letter with the same template just different names/addresses/valus)?
View 1 Replies
Mar 4, 2011
My app is a fairly simple and im sure with the right knowledge this would take 2 minutes.. but sadly iv been at it for hours. So my scenario here is a huge network with 20+ file servers all with data spread out across them it can take hours to find the folder required.
Hence this app.. so it consist of a input box, progress bar and a button, using FileSystemObject I plan to interrogate a directory to see if a folder exists (folder specified by user input) however it need to check multiple directories, in my old app I used a list box which wrote to a text file allowing the user to add additional directories then using if statements proceeded through the servers.. however they have added that much that my IF's have ran out really because i know it should have been a loop
Imports System
Imports System.IO
Public Class Frm_main
Private Const FILE_NAME As String = "C:directories.txt"
Dim objReader As New System.IO.StreamReader(FILE_NAME)
Dim Lines() As String = IO.File.ReadAllLines(FILE_NAME)
Dim Dir As String
[CODE]...................
View 1 Replies
May 16, 2011
Is it possible in VB to truncate a larger data type ( an int with a value greater than 255) to a smaller one, say a Byte (which only goes up to 255) in a way such that the 8LSBs of the integer are copied to the newly created byte. I have tried this using CType with the following code, however it does not work.
Dim TestByte As Byte = CType(Test, Byte)
Where the variable "Test" is an integer with a value of 419. This code always results in the Overflow exception.
[code].....
View 2 Replies
Aug 22, 2011
I created a VBA project in Excel. I would like to figure out how to transfer the data back in forth to make a more presentable and user-friendly program in VB Studio.Basically, I need my form in VB to input data to into an excel �workbook.data�, where the calculations are preformed. Then I need to copy the finished excel data cells �workbook.results� and paste them into an end result form in VB. I have tried looking at threads and cannot come up with a solution. There is no data saved each time the program runs, so I don't have a database.
View 14 Replies
Dec 8, 2010
I currently have a bunch of numbers separated by tabs saved in a text file. Is there an easy way to copy the information from that file into .xls file and add additional information (like row and column names). I need the information to be in a report format. I am not sure the best way to go about doing this.
View 12 Replies
Mar 16, 2012
im using vb.net 2008 and i would like to ask if is it possible that if i click a data in my listview then it would go to another listview and using a db
View 6 Replies
Dec 6, 2009
The first form in my project is a simple form for a shop selling cars. At the end of the form is a text box called txtTotal.text, this is the total cost of each sale. When I press the print button I not only want to print a sales invoice(I have that bit done) but I also want the total in txtTotal.text to be added to lblDaysTakings on my second form called frmAudit. Ive searched the web far and wide and cant find anything either suitable or within my level of understanding.
Ive tried code such as
Private Sub cmdPrint_Click()
Dim curTotal As Currency
Dim curDaysTakings As Currency
[code]....
and several other combinations but Im obviously a mile and a half off track as Im not getting anywhere?s a lot bigger than just the print button but I didnt see the point in posting the rest as I have everything else sorted out, its just transfering the numbers from one form to the other thats getting me.
View 5 Replies
May 14, 2012
In an attempt to find more or less understandable tutorial I have spent the last 2 days googling and reading, and still couldn't find the answer to my question. So that I decided to ask here:I am intermediate in VBA. I have been programming the tool in Excel, that takes some data from Oracle DB and manages it, stores in tables, shows in forms, creates new SQL-Queries, extracts further data from DB etc.
Couple of days ago it was decided that this tool should be a separate executable multi-user application (cause it actually doesn't have to do anything with Excel). Being still a student, I have downloaded the Visual Studio 2010 for free, bought couple of books and that was it... being stuck at the beginning..My problem is: I have absolutely no idea where to start from. I could have started drawing forms with controls, but I am concerned this ain't a right way. What about the GUI? What about the functionality scatch? What shall I start from, having code in VBA?
View 3 Replies
Aug 30, 2011
I'm using the details on connecting to a server from a client here: [URL]
It's quite out dated but I just need it for a quick project. I need the client to auto-connect. This program will be running on the LAN only, is there a way to find on what computer the server is running on (i.e. all computers hosting the specific server on port x). I've seen it on a couple of games that run on LAN. Without access to the internet, they manage to display all available games on the local LAN. I'm doing this with VB.net.
View 1 Replies
May 22, 2012
I am using the following code to get the Disk I/O on various servers. For now I am just retrieving the DiskReadsPerSec to get a feel for it. The return data gives a uint32 for each drive on the server and a total. My questions is what is the time frame that this represents? Is this at the second that my code polls the drive or is this over the last few seconds or do I need to do multiple runs to get an average.
My intention is to build a graph for each drive so I wonder how often I need to poll the drive to get a acurate value.
Public Shared Function GetDriveIO(ByVal strip As String) As Boolean
Dim oConn As New ConnectionOptions()
Dim lnglist As New List(Of Long)
[Code]....
View 1 Replies
Apr 2, 2010
Ive got a problem transferring files over TCP. On the server side I send a file (100kb) to the client side, and there it comes with about 10mb xDD
Sender:
client_send("---receivefile---")
client_send(OpenPathDialog.SafeFileName)
Dim SIZE As Int16 = 1024
[Code]....
View 1 Replies
