View Complete Post
I have created forms in the past that have connected to a SQL Server database and done a variety of manipulations.
This time I have a static table in SQL server that I want to add to the project and load into an array without having to connect to SQL Server i.e. the windows form application will have this datatable embedded within it so any user can use it. How do I
add the table to the project in this way?
I know how to load the data into the array.
i have implementing one Windows application in that i need to get the Forex market quotes values form perticulat server how can i implement this i have some Php Code but i need to in C# application.
This is my Php code to receive the quotes form server;
define('T_HOST','220.127.116.11'); // MetaTrader Server Address
define('T_PORT',443); // MetaTrader Server Port
define('T_TIMEOUT',1); // MetaTrader Server Connection Timeout, in sec
define('T_QUOTES','GBPUSD,EURUSD,AUDUSD,NZDUSD,USDCHF,USDJPY,USDCAD,GBPJPY,GBPCHF,EURGBP,EURCHF,EURJPY,EURAUD,EURNZD,EURCAD,CHFJPY,CADJPY,CADCHF,AUDJPY,NZDJPY,'); // symbols list for publication
define('T_CACHEDIR','cache/'); // cache files directory
define('T_CACHETIME',1); // cache expiration time, in sec
define('T_CLEAR_DELNUMBER',1); // limit of deleted files, after which process of cache clearing should be stopped
$MQ_CLEAR_STARTTIME = 0; // time
$MQ_CLEAR_NUMBER = 0; // deleted files counter
// query quotes and parse result
$q = "QUOTES-".T_QUOTES;
$qRes = MQ_Query($q);
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
i'm using sql server 2005, sql server business intelligence development studio for my reports and deploy them in my wss3.0 site.
what i'm trying to do is i'm trying to restrict wich users can see specific data within a report.
now, the thing is. the report gets the data out of my DB1 database and my windows authenticated user are in the WSS_content database.
when i deploy my report in my wss3 site. it gets the user that is loged in. but of course it does not display any data because the tables are not in the same database.
does someone knows how to do this?
I have an application that requires windows authentication to login, the problem is that every time an user logs in under IE and win XP, the username is pre filled with the IP address of the server as instance and the username. I need to replace the server ip with XXXX instance name instead of doing this manually.
Could anyone pleas help me out with this one?
Thanks in advance,