<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>[ top posted ]</span></div><div><span></span> </div><div><span>Walter,</span></div><div><span></span> </div><div><span>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.</span></div><div><span></span> </div><div><span>I also like the 'grids' functions. I would love to be able to incorporate that in to filePro processing for my plant mgt software.</span></div><div><span></span> </div><div><span>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. </span></div><div><span></span> </div><div><span>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.</span></div><div><span></span> </div><div><span>Again thanks for the reply,</span></div><div><span></span> </div><div><span>Rick Hane</span></div><div><span>Controller</span></div><div><span>Deluxe Stitching Company Inc</span></div><div><span>ISP Stitching Products</span></div><div><span><a href="http://www.deluxestitcher.com/">http://www.deluxestitcher.com/</a></span></div><div><span></span> </div><div><span></span> </div><div><span></span> </div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font size="2"
face="Arial"> <div style="margin: 5px 0px; padding: 0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" class="hr" contentEditable="false" readonly="true"></div> <b><span style="font-weight: bold;">From:</span></b> Walter Vaughan <wvaughan@steelerubber.com><br> <b><span style="font-weight: bold;">To:</span></b> filePro <filepro-list@lists.celestial.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, July 19, 2012 4:05 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: fp and .net<br> </font> </div> <br>
Richard Hane wrote:<br><br>>I'd like to start a new thread. May be short if not possible but let's see.<br>> <br>>This would be mainly for those running fp on Windows.<br>> <br>><br>okay<br><br>> <br>>Has anyone tried to use Microsoft's .net screens and grids with filePro?<br>> <br>><br>I have data that has been created/managed with filepro and now is used <br>differently with a .net app<br><br>> <br>>Where you able to do so without using a SQL program?<br>> <br>><br>No.<br><br>> What success did you have?<br>> <br>><br>I just export/import as needed into SQL Server 2005<br><br>On the otherhand, you can use the filePro mySQL interface <br>http://www.fptech.com/Products/Docs/fpmanhtm/filepro_mysql/mysql_interface.htm<br>and use mySQL as the data store. You can't use LinQ (I think), but from <br>an application standpoint its just a different connection string...<br><br>This looks
exactly how I would do a connection to SQL Server 2005, 'cept <br>below is for mySQL<br><br>// Get the MySQL connection string stored in the Web.config<br>string cnnString = ConfigurationSettings.AppSettings["ConnectionString"];<br><br>// Create a connection object and data adapter<br>MySqlConnection cnx = new MySqlConnection(cnnString);<br>MySqlDataAdapter adapter = new MySqlDataAdapter();<br><br>// Create a SQL command object<br>string cmdText = "usp_Verse_GetList";<br>MySqlCommand cmd = new MySqlCommand(cmdText, cnx);<br><br>// Set the command type to StoredProcedure<br>cmd.CommandType = CommandType.StoredProcedure;<br><br>// Create and fill a DataSet<br>DataSet ds = new DataSet();<br>adapter.SelectCommand = cmd;<br>adapter.Fill(ds);<br><br>> <br>>If using .net as input screens how was the speed and flow with filePro?<br>> <br>> <br>><br>Well a poorly written web page will be mangintudes harder and slower for <br>an end
user.<br>Well a poorly written filepro screen will be magnitudes harder and <br>slower for an end user<br><br>I don't understand the question.<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120719/936e7e8a/attachment.html <br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br><br><br> </div> </div> </div></body></html>