I've got an XML file which is a pain to manually update. So I was thinking of creating a small app which synchronizes this data for me based on data from an Excel Sheet or something.
The XML schema looks like this:
<Data>
<Level1 value="Canada">
</Level1>
<Level1 value="Chile">
[code]....
I am having two databases for the same application , one in windows and the other is web based.Since web based one have few functionalities I can't opt for a single database.At the same time I want to share Both databases to be updated with other's data so as to work error free with my module of appointment fixing.
View 2 Replieshave anyone tried importing specific column of an excel sheet to an sql database?i have tried importing data from excel and it worked but my problem is i want to import only specific columns from my excel file not necesarily importing all the columns..
View 3 RepliesI am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the button is clicked, it does frmProcess(). The first row is header in excel. I start to read data from 2nd row.
----------------------------------
Private Sub frmProcess()
Dim app As New Application()
Dim book As Workbook
[code]....
I am creating a Library Cataloging program for a local charity using Visual Basic.I have built the basic data table into the VB Project and I would like to populate it with the existing data that I have in the excel sheet containing the current catalogue. There are approximately 1000 records to import and I don't fancy inputing them by hand so I was wondering if anyone knows an easy way of porting the data across.
View 1 Replieshow can i import a Excel sheet Data into my oracle10g Database using vb.net coading..
View 1 RepliesI am new to VB.NET. How to import data from excel spread sheet into database (SQL Server Management Studio Express 2005) by clicking a button in windows form application using VB codes (visual studio 2010).
View 1 RepliesI have an access databse, but the data is link to excel, so i cant changes the data inside access database. However, i just want to retrieve the data inside the access database using VB datagridview, but the system pop out an error said 'cannot find the input table or query'Is it because the data is link with excel, so access databse cannot direct take the data? Below is my code:
Dim myconnectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb"
myconnection = New OleDbConnection(myconnectionstring)
[Code]....
I am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does anyone know a cleaner & more efficient way that looping through the ranges creating & executing insert statements?
View 3 RepliesI'm using a access database to store my data. I want to export the data in the access database to a excel 2007 file using VB.Net.
View 1 RepliesIs there a routine that will allow me to import data from an excel spreadsheet into a database within my project? I only need to do this to populate the the database I have created in my project.
While the project was being developed I used junk test data for testing and debugging but now I wan to populate the database with the actual records.
Here is the skinny:
In the project database I have the following fields:
ItemID - Primary key
SamCode
[Code].....
Column B contains the Full Name Data where B1 in a column header Column C contains the UPC Numbers needed where C1 is a column header
As stated this is a one time deal and not something I need to run as part of the application.
I have some trouble with opening a excel sheet and getting some data out of it.
I want my program to have a button, when pressed, gives a "select excel file" popup and then load the data from some cells into my sql database.
So, when opening a excel file the program should get the data from cell D3 to D8 and put that into the sql database.
I now have the following, but that will only open the excel file.
Public Class Form1
Dim oConn As ADODB.Connection
Private Sub ConnectDB()
[Code]....
I'm trying to write data from an excel spreadsheet to an Access database. When i run my program a message appears saying that the correct number of records have been saved, however when i check my access database no records have been written to the database table.
The following is a copy of my code (sorry i've just edited it to get rid of the white space that was added when i included it here for some reason.The code for writing to database:
Public Class Form1
Dim connection As OleDbConnection
Dim Command As OleDbCommand
[code]....
I want to read data from excel sheets and write into tables in database visual basic 2010. I am usinq Oracle 9i for database.and my objective is that user should select excel file and if button is pressed then I want to extract data from excel sheet and store in a already created tables.
View 5 Repliesi Have Used Database file for storing Data in my Application.Now I want to take backup of data in Access, Excel or in Any other Format.
View 1 Repliesim currently doing my special project in software development
[Code]...
[Code]....
synchronizing a combobox with a textfield. I have a form with a textfield and a combobox. The combobox is populated with the department name from the database when the form loads. I would like the textbox to display the corresponding department number when the user selects a department name from the combobox. I have tried using the SelectedIndexChanged event of the combobox but I can't seem to code it to work. This is the code I'm trying to use but it is displaying "DEPARTMENT" in the textbox. Department Code is the primary key of the table.
strSQL = "SELECT * FROM DEPARTMENT"
Dim da = New OracleDataAdapter(strSQL, cn)
da.Fill(dSet, "DEPARTMENT" )
[Code]....
I'm trying to get my application to restore the default values of my application settings but every time I click the Synchronize button it says:
No user.config files were found in any of the following locations.
I have never before tried to synchronize this application and am working with Visual Studio 2010. [URL].
I have a small application in ms access for student information. which is on my sever.now I have same application in .net and sql server which is online in my website, while access application is on my pc...Now I want that, If i make changes in my access application, the data must be copied to my online application automatically,Same thing i want vice versa,means if i make changes in my online application, the data must be copied to my desktop database.
View 1 RepliesPrivate Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If ListBox1.Text = "kg" And ListBox2.Text = "lbs" Then
[code]....
I have my client app installed in many computers, each computer is connected via LAN. Each Client app uses its own SQL database. I need to synchronize the databases in each computer so that every client app has the same data. How can I achieve this using VB.net (VS 2010 , Winforms)
View 1 RepliesI have two datagridview with same columns. When user resize the column of one of the datagridview during run time, then another datagridview column will synchronize to resize as well..
View 2 RepliesWith my program I wanted to change the fixed connection string to a User entered one. So in the application settings I added DBConnectionString as a user define String. If the string if empty, it shows the window where one can add the server, database and user name / password. If you press the OK button, it saves the settings:
Private Sub LDBOKBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LDBOKBtn.Click
' ----- Server name is required.
If (Trim(LDBServer.Text) = "") Then
MsgBox("The Server or Host name is required.", _
[code]....
The problem is that when you press the same button to show the System Settings again, the ConnectionString is empty again. So nothing was saved.
I have written a stupid backup utility that copies new or modified files. That's fantastic until I come across files that are 11 GB in size that have been modified. I have a feeling I can compare the file to be backed up and the file that will be over-written (old version of file) and "synchronize" the file instead of copying the entire 11 GB.
View 6 RepliesHow can i synchronize dragged controls (in my application), so they maintain their relative position to each other? is there some API function or .net method that can do this?
View 5 RepliesI am trying to retrieve the data from EXCEL 2003 spreadsheet from row 8 onwards because from Row 1 to Row 7 the row is merged columns from A1 to K1, A2 to K2, A3 to K3, A4 to K4, A5 to K5, A6 to K6, A7 to K7.
View 28 RepliesI am trying to read excel data (Excel 2007 SP1, on Windows XP SP3) with visual basic .net 2008 (VB 9.0 SP1). I have tried several attempts and whatever I do I am getting the following error message: System.Runtime.InteropServices.COMException was unhandled ErrorCode=-2147319784 Message="Altes Format oder ungültige Typbibliothek. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" Source="Microsoft.Office.Interop.Excel" Message="Altes Format oder ungültige Typbibliothek." Translated: Old format or unknown type libraryI have added the reference "Microsoft Excel 12.0 Object Library" to my project. I am assuming that I might have to add a different or an additional reference, but I do not have any clue which one to use. List of things I have already done:- Searched other forums- Altered the language settings- Tried it on an other Computer (Win XP SP3, Excel 2007, Visual Basic 2008 Express)- Ran the diagnostics tool in Excel - Updated all updates etc...- Reinstalled Visual BasicI really do not have any clue why it should not work?
Imports excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim xlsApp As excel.Application
[code]....
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 RepliesI have a class that contains a List(of T) used in a multithreaded application. I have three methods Get, Add and Remove where these access and modify the List(of T). I was using SyncLock to lock m_List any time I queried it for the desired object as well as when I added or removed objects. However I'm curious as to if there is a performance gain by simply locking m_List when I add an object or remove an object as opposed to when I'm searching for a desired object?
[Code]...
I sometimes come across patterns or common practices that I do not agree with. I have a clear opinon of what is considered "good design", which is mainly based on my understanding of abstraction and creating layers.IMO, the core of an application is it's object model. It's a hierarchic model where one object references other objects or lists of them. That's a memory-internal model. For example, a house object references a list of rooms referencing lists of furniture.An object is identified by it's reference. There are no IDs or PKs in that layer.Saving/Loading data is an additional feature. Sure, no application will do without, but it's based on top of the core of the application. I could write an application that works very well without loading/saving, and for version 2 I will think about whether to save data to a database or an XML file. Merely this fact proves that a database layer is not the lowest. I've never agreed with that three-tier model - even if you call me unteachable.
In addition to all application objects, there are Datasets - and that's my problem now. They can be considered as a copy of what is already present in the application's object model. Its from a different, table-oriented view. As both structures exist in parallel, there's the need to synchronize the DataSet with the (rest of the) application's objects.That's the task that I am always struggling with, and I ask how you handle it. I know this is a major design question but, fortunatelly, I could quite get around this problem so far.The only solution I can imagine is maintaining additional relation lists. For example, whenever the property of a room object changes, that change must be reflected in the associated DataRow in the DataSet. For this purpose, I need a look-up table that tells me the PK of the given room in the database. It requires a lot of additional efforst to do all the synchronization.Again, the house or room object itself does not have a PK and it won't get one because on that layer, it doesn't even know that a database exists.
