Thinking of upgrading to Standard. Anyone know how C#.net works with remote databases over WAN links. Is it still better to create an asp.net hosted application or do executables created with .net cope quite well with bandwidth limitations like asp hosted apps do
Another quick question, say I have a panel with a datagrid in it. If the panel if Enabled is set to False does everything within the panel also disabled
And also if a datagrid is set to Enabled = False. When the program runs does it pre fetch the query attached to it What I'm trying to achieve is that the query only occurs when that particular panel is chosen and to unload the data when another a panel is chosen.
Thanks
Visual C# and SQL Server
Nino Benvenuti
Hi Paul,
if you need to access the remote SQL server, just use the same remote IP address as you are using the LAN. you need to check if the SQL Server port is allowed (default 1433) otherewise, you need to open it in the remote machine/Network. Also, you can use many techniques such as .NET Remoting through TCP to make your connection more reliablitiy & stability, check the ISPs to give you for example (expensive) Frame-Relay connection with VPN to have more security and bandwidth. you some of .NET strategy, using Object Pool & Just-In-Time execution for more performance in addition to Ad hoq queries. Those are not the only idea, you can think of more if you wish.
yup, you can try if you wish.
third question, you can made a global variables (flags) that can be used to distinguish between loaded datagrids using Switch - Case (for example)