I have been tasked with converting Foxpro programs and forms into Visual Basic .NET and web application. Does anybody know of a tool I can use to convert Foxpro programs and forms and dbf into Visual Basic.net?
View 3 Replies
2 VB programs connect to the same ms access database, if 2 programs are open then in the 1st program u add data , i want that data will show on the list view of the another program
View 3 RepliesI am sure this can be done, as Visual Studio is basically built this way. What I want to do is simply make a class that my other workmates can use. But rather than have it in a code form, I want to build it (partially), and then my workmate can add it into their programs (sort of, like the add reference for the .NET stuff).
View 4 RepliesI build my first Project composed of several forms and it�s working just fine. Id like now to redesign the project as a MDI Application. Once created the parent form, I can create child forms but thats not what I need. What I would need is convert my already designed and working forms to MDI child forms. How can that be done?
View 1 Repliesi have to start out saying that I have never used VFP before, so this is all new to me. However, I am running into issues that seems to have nothing to do with logic or reason. Let me explain.
[Code]...
I'm trying to connect foxpro table (dbf) to VB.NET. I'm trying to display the records of that table to listview in VB.NET. Here is my code:I got an error message here, the error says "cannot open the file"
Imports System.Data.SqlClient
Imports System.Data.OleDb
Public Class Form3
[code]....
I am creating a VB.NET application that will use a FoxPro database as it's main datasource.The problem I've got is that I can browse existing databases and pull out data with no problems at all but as soon as I try and create my own database I get an error message saying "One or more errors occurred during processing of command." (which is helpfully vague).[code]
View 1 RepliesI want to create an index on a foxpro table. I used the following command
Code:fcn = New ADODB.Connection fcn.ConnectionString = "provider=VFPOLEDB.1;Data Source=" & tablefolderpath fcn.Open() fcn.Execute("INDEX on D:myfoldersales.dbf (BRAND)")But i get Command contains unrecognized phrase/keyword. message
I am trying to index on the brand field of sales.dbf table?
Consume a regular asmx web service in a dll projectI would like to open DBF-files, including the NTX-indexes in VB.NET which are used in FoxPro / Alaska Xbase. how to open both DBF nd NTX, because only open DBF-files would result in corrupt index (NTX) files.
View 2 RepliesI 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 RepliesI dusted off VB.net, and now im trying to connect to a local FoxPro DB. Problem is, its not working. Ive been at this for about an hour or so, trying many misc things, but without any luck. [Code]. 'C:aaaCF21000.DBF' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Suggestions? That path is 100% valid, I can copy/paste that and open up the Database without error. I also tried other code I found on the web, some of them I cant even get them to run.
View 5 RepliesI started with VB 6.0 back when i was 14, I was mostly into coding programs that interacted with other programs. Recently I installed VB.net 2005 pro i got from school, and i grabbed few source codes that teach show interaction, I feel so dumb, i dont remember anything lol. It be great if you guys can share some source codes and other stuff in this field. also other day i was in dream spark and i am able to get copy of VS.net 2010 ultimate edition, are there a lot of major changes, cause i got 2 thick book for VB.net 2005..
View 1 RepliesWhen you've finished a program and you're trying to distribute it to the mass public. How is the best way to go about doing this? What sites would you post your program on and getting the word out that there is a new program on the block and it does xyz. This is directed to freeware so there wouldn't be any advertising.
Sorry for not explaining it very well the first time.
I'm using VB.NET 2008 with a DataGridView and I'm interfacing to a Visual Foxpro 6 database using the vfpoledb.1 driver. When I change a value in the description field, it changes in the DataGridView but the database never gets updated. Do I need to use code to force the changes to take place?Here's the code I'm using:
Imports System.Data.OleDb
Public Class Form1
Dim sConString As String = "Provider=vfpoledb.1;Data Source=C:MyDatabase.dbc;Mode=3;"
Dim con As OleDbConnection = New OleDbConnection(sConString)[code].....
So, I have successfully loaded dbf's into my VB project.What I need to know now is how exactly do I utilize the VFP language in addition to SQL?
Say I wanted to replace all fields (REPLACE ALL field1 WITH field2) with another field, how would I send that instruction to the DBF utilizing the VFPOLEDB.dll?
I think what I have here is an environmental issue. When I attempt to fill a dataset from a VFP table I am getting an error message that says "Index Not Found". The reason I feel its environmental is because the process was working perfectly fine last week. The client I am trying to run this program for runs it once per month to integrate one of their FoxPro systems with SQL. It's been in working order since November of last year, but suddenly now I'm getting this error. Some things I have looked at already are updating VFP drivers for both OleDB and ODBC.
'--- FOX variables
Dim cnFOX As OleDbConnection
Dim cmdFOX As OleDbCommand
[code].....
I have a foxpro table <b> INVENT.DBF</b> linked in MS ACCESS. When I tried to do a search in the table from vb.net application, it is taking a long time. So I want to index the foxpro table and then use it for search.
Here is the sample code I wrote in vb.net <i>
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:database.mdb;Persist Security Info=False")
cn.open()
cmd = New OleDbCommand("Create INDEX itmno_idx ON INVENT(ITEM_NO) ", cn)
cmd.ExecuteNonQuery()</i>
But I am getting error "Cannot execute data definition statements on linked data sources"
What needs to be done to index a linked foxpro table using VB.NET.
As part of a larger application, I need to IMPORT (not link) a FoxPro 2.6 DBF into a Access DB.I toyed with using a Access MODULE and in the module, using the docmd.TransferDatabase method.I have looked for days at different samples and I cannot seem to find the answer.This application is intended to be distributed with NO ASSURANCE the user will have the FoxPro OLE driver installed. Knowing that the ODBC driver will most likely be installed as part of MDAC, it is pretty safe to use the ODBC driver that is already installed - Visual FoxPro Tables
View 1 RepliesI am new to VB and trying to use it to update and merge some foxpro free tables. I have a connection and trying to use the update command but getting an exception. Once the code hits the ExecuteNonQuery line it throws the exception {"Command contains unrecognized phrase/keyword."} Do I need to create the command using parameters? Just not sure. Is the connection string correct - I did not get any issue with the cn.Open
[Code]...
i am using vb/vb.net and the database is visual foxpro 6.0 then i want to create the tables from the application using sql statement.i need to add the number field into the table. i can not add the number field in the tableres.open "CREATE TABLE Customer ( CustName char(50), CustId int(2))",conXavier
View 2 RepliesSo Im working on updating our company's program from Visual FoxPro to VB and this is the first step. I can access and read data from the table
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
I am not able to find the Exclude Command in VB 2010 Express. I have no idea which version of Visual Studio it is working with. I've got one 217MB VB 2010 Express file and many 2008 VB Express files with one of them measuring 31 MB. There many other SQL files and .Net Files.
View 4 RepliesVS 2010, VB.NET, WINFORMS. In my app i have a need to import foxpro database tables and exclude the deleted records. The problem is that FOXPRO tables keep deleted items inside the same table. I have tried using DELETED=NO in the connection string but vb throws "Format of the initialization string does not conform to the OLE DB specification."
My function is as follows:
Dim _DBConn1 As String = "provider=vfpoledb.1; Data Source = " & file1 & ";DELETED=NO"
Dim _DBConn2 As String = "provider=vfpoledb.1; Data Source = " & file2 & ";DELETED=NO"
Dim _DBConn3 As String = "provider=vfpoledb.1; Data Source = " & file3 & ";DELETED=NO"
Google results pointed me in the direction of DELETED=NO but its throwing that exception error now that I have added it..
I've been converting all kinds of other things, classes, interfaces, ASP.NET MVC apps, and WPF applications, but I am stumped as to how to convert a windows forms application, as the whole structure seems to be different. Does anyone have any advice on how to tackle this problem?
I see essentially that you have two files, Form1.cs and Form1.Designer.cs. Literally translating them from C# to VB doesn't work because of some intricacies or other of how Visual Basic works. I think you /might/ be able to convert Form1.cs in this way, as it's just a constructor plus event handlers, but the designer contains the references to the controls etc. and I am not sure how to go about doing that
i am working on a time limiter application, and i need to work out how to convert a time i.e. 01:19:15 into minutes.
View 2 RepliesIs it possible to convert a form to bitmap. Actually i have a form on which different things( labels, grapg etc) are drawn at run time. So what i want is that when everything is drawn it is converted to a bitmap. i tried myBmp = me.creategraphics but it didnt work
View 1 RepliesI have a MaskedTextBox which is like below;
30/01/2011 08:42
I would like to convert this to DateTime, Is there a way to do it?
well i convert a certain image to an icon file and when i upload it its just a white rectangle in the corner of my app instead of the actual icon???
View 2 RepliesI am developing an application which initially allows the user to browse and select a save location. The selected path is assigned to a public variable which is used with concatenation to crate folder for saving user input data. How can I change the path string to a constant so the user can run the program again without having to run setup routine unless they want to change the save location?
View 1 Repliesi havent found much info on this, Basically i would like to convert from Xvid to FLV in my program...?
View 5 Replies
