<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Richard Hane wrote:<br>
<blockquote
cite="mid1342713194.32464.YahooMailNeo@web181704.mail.ne1.yahoo.com"
type="cite">
<pre wrap="">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.
</pre>
</blockquote>
okay<br>
<blockquote
cite="mid1342713194.32464.YahooMailNeo@web181704.mail.ne1.yahoo.com"
type="cite">
<pre wrap="">
Has anyone tried to use Microsoft's .net screens and grids with filePro?
</pre>
</blockquote>
I have data that has been created/managed with filepro and now is used
differently with a .net app<br>
<blockquote
cite="mid1342713194.32464.YahooMailNeo@web181704.mail.ne1.yahoo.com"
type="cite">
<pre wrap="">
Where you able to do so without using a SQL program?
</pre>
</blockquote>
No. <br>
<blockquote
cite="mid1342713194.32464.YahooMailNeo@web181704.mail.ne1.yahoo.com"
type="cite">
<pre wrap=""> What success did you have?
</pre>
</blockquote>
I just export/import as needed into SQL Server 2005<br>
<br>
On the otherhand, you can use the filePro mySQL interface <a
href="http://www.fptech.com/Products/Docs/fpmanhtm/filepro_mysql/mysql_interface.htm">http://www.fptech.com/Products/Docs/fpmanhtm/filepro_mysql/mysql_interface.htm</a><br>
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...<br>
<br>
This looks exactly how I would do a connection to SQL Server 2005,
'cept below is for mySQL<br>
<br>
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">//
Get the MySQL connection string stored in the Web.config</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">string
cnnString = ConfigurationSettings.AppSettings["ConnectionString"];</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">//
Create a connection object and data adapter</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">MySqlConnection
cnx = new MySqlConnection(cnnString);</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">MySqlDataAdapter
adapter = new MySqlDataAdapter();</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">//
Create a SQL command object</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">string
cmdText = "usp_Verse_GetList";</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">MySqlCommand
cmd = new MySqlCommand(cmdText, cnx);</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">//
Set the command type to StoredProcedure</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">cmd.CommandType
= CommandType.StoredProcedure;</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">//
Create and fill a DataSet</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">DataSet
ds = new DataSet();</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">adapter.SelectCommand
= cmd;</span><br
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186);">
<span
style="color: rgb(48, 40, 33); font-family: monospace; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; background-color: rgb(207, 196, 186); display: inline ! important; float: none;">adapter.Fill(ds);</span><br>
<blockquote
cite="mid1342713194.32464.YahooMailNeo@web181704.mail.ne1.yahoo.com"
type="cite">
<pre wrap="">
If using .net as input screens how was the speed and flow with filePro?
</pre>
</blockquote>
Well a poorly written web page will be mangintudes harder and slower
for an end user.<br>
Well a poorly written filepro screen will be magnitudes harder and
slower for an end user<br>
<br>
I don't understand the question.<br>
</body>
</html>