fp and .net

[Richard Hane]

[ top posted ]
 
Walter,
 
Thanks for the feed back.  I raised the question because I was trying to find an less time consuming way to get quality GUI / web screens for use with fp.  The version of our new ERP system is totally .net framework and I really like the way it looks and feels.
 
I also like the 'grids' functions.  I would love to be able to incorporate that in to filePro processing for my plant mgt software.
 
However, the use of SQL (MySQL or Microsoft SQL server) really defeats the purpose (IMHO).  I don't want to use another data base as a bridge only because fp has not progressed over the past 15 years, again IMHO.  
 
I really like fp programming and don't want to relearn the wheel, as it where, of a new database with vba, etc.  At this point I'll just stick to using html screens.
 
Again thanks for the reply,
 
Rick Hane
Controller
Deluxe Stitching Company Inc
ISP Stitching Products
http://www.deluxestitcher.com/
 
 
 
 

________________________________
 From: Walter Vaughan <wvaughan at steelerubber.com>
To: filePro <filepro-list at lists.celestial.com> 
Sent: Thursday, July 19, 2012 4:05 PM
Subject: Re: fp and .net
  
Richard Hane wrote:

>I'd like to start a new thread.  May be short if not possible but let's see.
> 
>This would be mainly for those running fp on Windows.
>  
>
okay

> 
>Has anyone tried to use Microsoft's .net screens and grids with filePro?
>  
>
I have data that has been created/managed with filepro and now is used 
differently with a .net app

> 
>Where you able to do so without using a SQL program?
>  
>
No.

> What success did you have?
>  
>
I just export/import as needed into SQL Server 2005

On the otherhand, you can use the filePro mySQL interface 
http://www.fptech.com/Products/Docs/fpmanhtm/filepro_mysql/mysql_interface.htm
and use mySQL as the data store. You can't use LinQ (I think), but from 
an application standpoint its just a different connection string...

This looks exactly how I would do a connection to SQL Server 2005, 'cept 
below is for mySQL

// Get the MySQL connection string stored in the Web.config
string cnnString = ConfigurationSettings.AppSettings["ConnectionString"];

// Create a connection object and data adapter
MySqlConnection cnx = new MySqlConnection(cnnString);
MySqlDataAdapter adapter = new MySqlDataAdapter();

// Create a SQL command object
string cmdText = "usp_Verse_GetList";
MySqlCommand cmd = new MySqlCommand(cmdText, cnx);

// Set the command type to StoredProcedure
cmd.CommandType = CommandType.StoredProcedure;

// Create and fill a DataSet
DataSet ds = new DataSet();
adapter.SelectCommand = cmd;
adapter.Fill(ds);

> 
>If using .net as input screens how was the speed and flow with filePro?
> 
>  
>
Well a poorly written web page will be mangintudes harder and slower for 
an end user.
Well a poorly written filepro screen will be magnitudes harder and 
slower for an end user

I don't understand the question.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120719/936e7e8a/attachment.html 
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120720/05f34bc3/attachment.html