Insert Data into SQL Database
||...Visual Basic .NET 2005 application that will do the following:
1.) Read a CSV text file with the same...different SQL insert statements for each record in the CSV file
3.) Copy the completed CSV file to a done...the Visual Basic language.
The database is a SQL 2000 database.
||PHP, Visual Basic, .NET, Engineering, SQL, Software Architecture, Software Testing, MySQL
||Jul 30, 2007
||Jul 30, 2007Ended
parse xml and update/insert into sql
||...program in .net that will read and parse multiple xml files and then insert/update data into the sql 2000 database...database.
We have about 9000 records currently in Sql server that are are incorrect and need to...good XML skills, good SQL server skills, good .net skills. Most of all, it will require good SQL ana...
||PHP, ASP, Visual Basic, .NET, Engineering, SQL, C# Programming, Software Architecture, Software Testing, MySQL, Anything Goes
||Jun 5, 2007
||Jun 5, 2007Ended
SQL to XML to ZIP (.NET)
||...small .NET Winforms executable which does the following:
1) Connects to a SQL Server database (configurable...(configurable via a config file).
2) Executes a number of INSERT, UPDATE and DELETE statements (to be defined...defined in a TXT file which the App can read). The statements include some CTE queries which start with
||XML, .NET, SQL, C# Programming
||Nov 26, 2012
||Nov 26, 2012Ended
VB Class To Create SQL Insert Stmts
||Create a VB 6.0 Class that reads data via ODBC from 1 or more tables and writes out ANSI Standard SQL Insert...statements for that data. Class has 4 methods: 1) Connect to database 2) Disconnect from database 3) Specify 1...tables that will be queried 4) Create the SQL insert text file, from the tables specified - with an argument
||PHP, Visual Basic, Windows Desktop, Engineering, SQL, Software Architecture, Microsoft Access, Software Testing, Microsoft, MySQL, Database Administration
||Feb 16, 2003
||Feb 16, 2003Ended
Private project or contest #1381701
||ASP, Visual Basic, .NET, Website Design, SQL
||Jan 11, 2012
||Jan 11, 2012Ended
database insert and retrive
||...postgres driver in .NET, this project can be done, without stored procedures, against SQL Server.
This...a postgres database in c#. Attached is the data types (c# source file) as well as the XML Schema generated...Specifically, the deliverables for this project are:
- database ddl
- class that has the following methods
||PHP, Engineering, SQL, C# Programming, Software Architecture, Software Testing, MySQL, Database Administration
||Nov 1, 2003
||Nov 1, 2003Ended
File Import and Database Insert / Export
||I need a .Net v2.0 VB.net app that uses SQL Server database and SSRS Reports.
I am looking to take...take a tab-delimited file, importing it using this new app, and break the data out into separate tables...as well as sample data, file layout specs, etc.
A few fields (Columns) of data include multiple value
||Visual Basic, SQL, Software Architecture
||May 15, 2013
||May 15, 2013Ended
Webservice .NET VB
||...webservice that will take XML file and insert, update or delete rows into a flat MS SQL table. Would like to...to be written in VB vs C#.
SHoudl be pretty simple. i have a ll the integration docs and test sites
||.NET, SQL, Software Architecture
||Apr 26, 2012
||Apr 26, 2012Ended
Add Functions to VB 2010 .NET Application
# I have a VB 2010 project that has one import function and needs additional functions to import similar...separated values (CSV) data. The program's purpose is:
1. Read settings from an XML file.
2. Read CSV...from the XML file).
3. Format the CSV data for insertion into a SQL Server table.
4. Insert the data
||Oct 10, 2012
||Oct 10, 2012Ended
Import XML to SQL database
||..."Console" for data input. This program creates a ZIP file for each listing. The ZIP contains an XML file with...listing data, and all of the images. What is required: 1. Create a way to read data from this ZIP file and...and insert it into the mySQL database 2.Copy ALL images from the ZIP to the server in a directory to be
||PHP, XML, Software Architecture, Software Testing, Website Testing, MySQL, XSLT, Website Management, Web Hosting
||Oct 8, 2009
||Oct 8, 2009Ended
VB, SQL, .Net Help
||...designed in VB and was published to an IIS server to run as aspx.
The site uses a SQL back-end for...for the database and stores information in XML as well. I will need help to sort drop down menu's from...from the SQL queries, change some gui on the screens (tables), repopulate form fields based on changed items
||XML, Visual Basic, .NET, SQL, IIS
||Apr 11, 2012
||Apr 11, 2012Ended
XML import into SQL database
||...import XML data files into an SQL database (MSDE) to create raw tables containing the xml tagged data. ...
Examples of XML files to import are:
<colgroup></colgroup> <col style="WIDTH: 48pt" width="64"...http://www.sec.gov/Archives/edgar/data/1800/000110465905016841/a4.xml |
||PHP, XML, Visual Basic, .NET, Engineering, SQL, Software Architecture, Software Testing, MySQL, XSLT
||Apr 26, 2005
||Apr 26, 2005Ended
Parsing XML for VB .NET
||...take an xml file and transfer the data into single records in a dataset. This needs to be done in VB .NET...
- Load the xml file
- The xml file contains registration data. The registration data needs to be turned...be placed in a data table.
I have uploaded the xml schema and a sample xml data
||PHP, XML, Visual Basic, .NET, Engineering, Software Architecture, Software Testing, MySQL, XSLT
||Sep 30, 2005
||Sep 30, 2005Ended
.Net Yahoo Store XML Order file project
||Needed .Net class to parse Yahoo Store XML order file and create an array of order objects.
The XML class...very generic and know how to insert its data into an SQL Server database.
‘ Using the objects might look...ID, fail and return false when the insert method is called.
Database structure etc will be given to succes...
||PHP, Visual Basic, .NET, Engineering, SQL, C# Programming, Software Architecture, Software Testing, MySQL
||Aug 19, 2003
||Aug 19, 2003Ended
XML Export from SQL Database
||...tables to XML.
MS Access 2003 already does the job perfect, using the relations defined in data model.
I...I want to integrate this in our own VB .NET software not using Access.
Maybe you already did the job
||Aug 29, 2012
||Aug 29, 2012Ended
569838 Insert data into a database
||I have an sql file and want to insert the data into a data base.
||PHP, Data Entry, SQL, Anything Goes, Database Administration
||Jun 7, 2012
||Jun 7, 2012Ended
Create XML through .Net (VB) Page
||...a asp.net (VB) page to create an xml file on the server that will be populated with data from a view...view on my SQL server. Here is the schema of the xml file:
<?xml version="1.0" encoding="utf-8"...Title</caption>
The file will be created on the Page Load event and...
||Jul 15, 2007
||Jul 15, 2007Ended
Employee TimeClock written in VB .NET
||...TimeClock for Employees, accessing a MS SQL Server database, with the ability to import timesheets and...TimeClock for Employees, accessing a MS SQL Server database
2. Log/update entries into the TIMECLOCK...flag in the current record in the TIMECLOCK_DATA data
5. Do not allow shifts longer than 24 hours
||PHP, Visual Basic, .NET, Windows Desktop, Engineering, SQL, Software Architecture, Software Testing, Microsoft, MySQL
||Mar 25, 2009
||Mar 25, 2009Ended
XML VB Script Query
||...generate a SQL query to MS SQL Server database.
3) The SQL results are then converted into XML data format...format and stored in an XML file.
I already have the parts of the script for 2) and 3) and it works...works on the demo Northwind database in SQL Server. What I need is for some one to complete 1) based on
||XML, Visual Basic, Script Install, Windows Desktop, Project Management, Engineering, Software Architecture, Software Testing, Shell Script, Microsoft, XSLT
||Jul 4, 2010
||Jul 4, 2010Ended
Read XML dataset and insert values in database
||...want to convert a XML resultset to HTML format and also store data being received in XML in a table in MSSQL2000...table. The code will be written in c# and the database to be used is MSSQL2000. The program should generate...table with necessary fields based on XML dataset. Sample XML file is enclosed.
This is a very simple
||PHP, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Amazon Web Services, Website Management, Web Hosting
||Jul 12, 2006
||Jul 12, 2006Ended