Import Data From The Internet And Manipulate It?
Feb 4, 2010i want to import data about cigarettes from the internet. i don't know terminology so i'm having a hard time starting.
View 1 Replies
ADVERTISEMENT
Record Data From RS 5000 To PC - Manipulate Data Using VB?
Sep 16, 2011I've got a tough one today and need a lot of with it. I hope someone out there has some experience in a manufacturing environment or at least point me to somewhere that will have an answer. So, the company I work for has RS 5000 (also have RS Linx) by Rockwell Automation. I need to record process test values to a file on a server and then use VB to manipulate that data. First off, I am trying to figure out how to get the data off of the PLC Can I export data to a file or do I have to retrieve data from a processor?
View 10 RepliesManipulate Data In Worksheets?
Aug 24, 2009Is it possible to manipulate data in worksheets?[code]...
what i want to do is round off the time in if the time is greater than 6:00 example please look at the data date 8/2 and 8/3. i would like to modify it and make the 6:01 to 6:15, and 6:16 to 6:30 , every 1-15min late the time would round off to the nearest 15mins.. my question is how can i make loop in the column "time in" and every time the program sees a "late IN" it will round it up to the nearest 15mins.
C# - SELECT, Manipulate Data Temporary Using SQL SERVER
Aug 9, 2011The 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??
Read And Manipulate Data Within Excel Sheet?
Mar 4, 2009I have an excel sheet that contains 25000 phone numbers listed in one cell with no sorting order. I want to create a small windows application that can read the sheet and return the total number of the phone numbers and how many duplicate numbers as well as the number of times of repetitions. How I can resolve this issue? What is the best way to approach it? I'm using VS 2008 and VB.Net.
View 14 RepliesForms :: Access Websites And Manipulate Data From Application
Nov 8, 2009Basically I want to know how to access a particular website from my application. I have used System.Net Namespace to request HTML from a website, It returns a complete HTML code which is used by Browsers to render the content on the screen but what i want is to interact with the website only without the use of a browser. I currently dont know how to do that.
I have a application which displays a Image when a user enters a keyword, lets say user enters a word "Envelope", the application will go to Google Images and search for this keyword. Now google returns images as results, the application now needs to download the first result ( which is a image) and display it on a form ). Everything here is done without a browser but via my application.
Manipulate Data From An Access Database To ListView In VB2008 Express
Jan 16, 2010I'm trying to retrieve data from an Access database - a simple one. (Just a single table with one column) My task is to view these records through a 'ListView'. No need to manipulate or anything. Just to retrieve data with a simple SQL statement and display via a ListView.
View 4 RepliesIDE :: Pull Data From Source Database, Manipulate It And Push It Into The Destination Database?
Jan 22, 2009I have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
View 1 RepliesDB / Reporting :: Import Excel Data To Data Table
Feb 8, 2009I am currently using vb 2008 and access 2003 as back end database. I am trying to import excel data to a data table. my excel and access table header & columns are same. I was trying to do this.........
[Code]...
Import Xlsx Data Into Data Grid View?
Sep 28, 2011I just started using Visual Basic and Visual studio and I was wondering how can I import .xlsx data into the data grid view.
View 18 RepliesImport/Merge A Particular Column With Data From One Data Table To Another?
Apr 6, 2011I want to merge or import a column of data from one data table created in VB.NET to another data table's 'same-named' column.The destination data table has all the required columns created before hand but the source data table contains one column at a time, whose name is the same as that of one of the columns in destination data table.Whatever coding I have done for the same till now, results in blank rows at starting. The destination data table looks like this:And I want it to be displayed it as:
View 1 RepliesRead In A Csv File, Manipulate The Data And Then Update The Existing File?
Nov 24, 2010I have a csv file that needs to be automatically updated on a daily basis. I am writing a vb.net app to accomplish this. However, Im having issues with the entire process.I need to be able to read in a csv file, manipulate the data and then update the existing file. I have dabbled with using the Excel objects but I need some assistance.
View 6 RepliesC# - Load A File, Manipulate The Data, And Write A New File?
Mar 6, 2012I have an issue where I need to load a fixed-length file. Process some of the fields, generate a few others, and finally output a new file. The difficult part is that the file is of part numbers and some of the products are superceded by other products (which can also be superceded). What I need to do is follow the superceded trail to get information I need to replace some of the fields in the row I am looking at. So how can I best handle about 200000 lines from a file and the need to move up and down within the given products? I thought about using a collection to hold the data or a dataset, but I just don't think this is the right way.[code]....
View 1 RepliesPass Data To Dialog - Manipulate And Pass Back?
Jan 15, 2010Just started VB programming this week and have found a wealth of information about what I'm trying to do. Problem is, some of it is more complete than others.Here's what I'm trying to do:In Form1 (my main form), I want to instantiate a class that contains a couple of properties (speed setpoint and position setpoint). When I click a button, I want to pass this data to Form2 and populate two textboxes on Form2 with the properties of this object. I want to manipulate the property values on Form2 and click an OK button which closes the dialog and returns the manipulated data, updating the property values of the object. Here's the algorithm I'm following:1) On Form1, instantiate the class2) On Form1's "Pass Data" button click event handler, instantiate a Form2 object and invoke the ShowDialog method, passing the object as a parameter.
3) On Form2, overload the ShowDialog method to accept the object as a parameter and modify the method so that it returns the manipulated class data.4) On Form2, in the ShowDialog method, populate the textboxes with the class data that was passed in.Here's where I get stuck. If I press the OK button on Form2 (DialogResult.OK), it returns me to Form1, but what hook do I have in Form1 to receive the manipulated class data that the ShowDialog method is returning?Here's an example of what I'm thinking about:
Code:
Public Class Form1
Dim clsController1 As New MotionController
[code].....
I'm sure it's probably a very elementary question, but every explanation I've found seems to be incomplete.
Grabbing Data From The Internet?
Jun 9, 2010At the moment I'm developing an application (Similar to Swiftkit.net's) that will aid users when playing Runescape.My next major project on the program is to Make a highscores look-up. (If you dont know about the Runescape highscores, HERE)Now, i want to grab data from that webpage, and add it to a form on my application. The form in particular, will display a specified persons levels on that form under labels.First of all, i have NO IDEA on grabbing stuff from the web in VB. Second, i have searched far and wide for something similar, but everyone that has something similar is not very willing to part with their hard earned code.
View 10 RepliesImport Data From One MDB To Other MDB?
Dec 14, 2011I have 2 MDB files (ms access) with some set of tables in both the MDB file with same table/varibale structure.Now I want to append records from second MDB file tables to first MDB file tables.
Note: the table name and structure in both the MDB file is same.
Program That Load Some Data From Internet?
May 17, 2012I have a little problem whit passing delegates. I have a program that load some data from internet. When the loading starts i create new thread for this. What I want is, when the loading ends I want to call one procedure in my form. So when I initializing class I want to pass that procedure. But I have problems with implementation. This is the pseudo code off my class and how it should look like.
Public Class GetArtistInfo
Public Delegate Sub RefreshInfoSub()
Public RefreshSub As RefreshInfoSub
Public Sub New(ByVal RefreshInfo As RefreshInfoSub)
RefreshSub = Address Of RefreshInfo
End Sub
[Code]...
Sending Data Via Internet To Another Computer
Oct 14, 2009I was recently working on a project involving data transfer(transferring of a text file) from my pc to another pc via the internet. I've already created a site but I don't know how to transfer the file.
View 4 RepliesC# - Import Data Into Database?
Mar 14, 2012I need to import data from a file into a Microsoft SQL Server database.
The file is roughly structured (inconsistent number of fields but the data needed is available in all rows) The file can contain up to 600'000 records The first field is identifies a record
The import of the data contains updating existing records in the database with the new values or inserting a new record if the record could not be found.
What is the best approach to accomplish that?
(Reading the file line by line, executing a SELECT and UPDATE or INSERT from my .NET Application doesn't truly satisfy me, because this way it processes around 35 records per second, which leads to several hours of processing time...)
A first option might be to combine the select and update/insert commands in a stored procedure, but this would still take a lot of time.
Is there something like MySQL INSERT ... ON DUPLICATE UPDATE?
Is it possible to pass a list/array of records (multiple columns) to a stored procedure?
How To Import Excel Data Into Sql
Sep 14, 2011I'm trying to imports excel data into sql database. I'm using excel 2007 connecting to sql 2005. my code:
Dim myPath As String = "c:\sample.xlsx"
Dim dsData As New DataSet
Dim dt As New DataTable
[Code].....
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Import And Export Data?
Dec 9, 2011I have been facing a problem since last two days, actually i want to import some data from a file (file can be csv, txt, sql, xls etc) and after some filtration, export it into csv file. Basically i want to know whether a tool which provides an environment to import different types of file or data where we can perform filtration of data with the help of sql query and then data could be save into file(file can be csv, txt, sql, xls etc).
View 2 RepliesImport Data From A CSV File?
May 12, 2011I have a situation at work where I need to import data from a CSV file, do some manipulation on it before saving it into a SQL table.
I read the data from the CSV into a DataTable and then populate a GridView with it. The contents of the GridView are then checked by the User and the results saved to the database. The DataTable / GridView has the columns:
[code...]
I need to populate the "ManagerEmail" column of the GridView by looking up the corresponding details for the person using the "ManagerEmployeeNumber" from the datatable BUT.
Import Data From A Xml File?
Feb 16, 2011I am trying to import data from an xml file. It works fine for string (nvar and nvarchar) values but I can't get the date and numeric values to come in. I think it is bombing on null values.
Private Sub Insert_eFieldsReports(ByVal textReader As XmlTextReader)
'Sub Insert_eFieldsReports gathers and inserts the project level data of an eFields
' xml file report into the SQL Server
[Code]...
Oh yeah the remarks one doesn't work either because that is an nvarchar(MAX) data type.
Import Data From Excel To Sql?
Nov 9, 2010I need to import data from excel to sql. I use Microsoft SQL serverManagement Studio Express(2005) and Visual Studio 2010.
I have tried many sql queries but nothing works for me.
using this: INSERT INTO dbo.MyTable SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:Documents and SettingsMyNameDesktopmyspreadsheet.xls', [Sheet1$])
Import Data From One Application To Another/
Jul 25, 2009I would like to know if there is a way to import data from one application to another? If so, what functions do I use?
View 1 RepliesImport Data Into SQL From An Array?
Mar 30, 2012Here is my objective. I have a text file, delimited. Data sample below
1140001074,03/06/12,0001000016,03/07/12,0412652694,1150000309
1140001074,03/06/12,0001000016,03/07/12,0412652695,1150000369
I need to import this data into a table, that is already created in sql. I'm not updating, just a simple insert.I thought the way I would do this is read the file, put that into an array, then from the array import into the table.My code below for reading the text file, and placing it into an array
Private Sub ReadtxtFile()
Dim lista As New Collections.ArrayList
Dim input As String
If File.Exists("C:filetestBol Test.txt") Then
[code]....
Import Data To Sql 2005 From A Different PC
Dec 9, 2009Ok, here's my issue I need to import an xml file into SQL, I tested everything out using Bulk Insert to my local SQL Server which worked great, however the application that I will be using is on a different PC then the Production SQL server. I would prefer not to have to grant special permissions to a shared drive for the SQL server to read the files.
[Code]...
XML Data Import Export?
Nov 23, 2011I am developing an application in which data will be handled offline and then fed back into the main application. Hence need the facility of Export & Import of data.I am using WriteXML to export desired data from the server database using dataset.
The data is imported back, into the Client module. During the day client may modify/insert records in the imported data. At the end of day, the client exports back the modified data and which needs to be imported back into the system's main database.Now what I want is, if new record is entered by the client then it should be inserted into the dataSet and if original record is modified during offline mode then the Original data should be updated with the new value. I think, its similar to the DataSet and Database concept i.e when dataSet is updated. But am not able to do this.
At present, if I import then all data is imported irrespective of whether the data already exist or not.And if I implement Primary Key in the dataset then for modified data it gets stuck with constraint.
Bandwidth Calculation (Internet Data Transfer)?
Jan 11, 2011I have used the following code to get bandwidthIt works but i have following doubts1.I need Total Internet Data transferred in MB, how do i convert?, total data transferred (download+upload) varies with other bandwidth monitoring applications. how do i get exact data transferred?2.I need to exclude file transfer in local LAN in Data Transfer, The follwoing method includes internet data transfer + Local file transfer
Option Explicit
Public Enum OperationalStates
MIB_IF_OPER_STATUS_NON_OPERATIONAL = 0
[code].....
Initiate Internet Data Connection On WM6 Devices?
Jun 22, 2010I am currently porting (well really totally re-writing) a project to run on WM6 devices. I need to initiate a GPRS data connection (or any internet data connection really, shouldn't matter if its GSM or CDMA) before I can get the data I need (actually sync. a database over the cell network - Sybase via Mobilink) because right now its basically saying I have no network connection when I make the call to sync the db.
If I open Internet Explorer on the device, it initiates the data connection, and I can then go back into my program and get the data no problem. This isn't an acceptable solution however.
How can I initiate the internet data connection?