fp and .net

[Walter Vaughan]

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