Is it possible to access local machine form webpage without IE/ActiveX? For example, can I execute an exe file on a local machine? Or, If viewer's machine hosts a webservice, can i invoke it through webpage?

Is it possible to access local machine form webpage without IE/ActiveX? For example, can I execute an exe file on a local machine? Or, If viewer's machine hosts a webservice, can i invoke it through webpage?

Is it possible to access local machine form webpage without IE/ActiveX? For example, can I execute an exe file on a local machine? Or, If viewer's machine hosts a webservice, can i invoke it through webpage?

Any idea how to visualize a tree in C#? Like treeview but in graphical form, circles and links. Any libraries, controls maybe as I don't have much time? It seems correct visualization of any tree is not an easy thing :(

Hello, I have a sql (t-sql) question. I have two tables Orders and Agents. Each agent does a transaction (bying or selling) and transactions are recorded in Orders table. Columns in table "Orders": ItemId, bla, bla, bla, Seller, Buyer Columns buyer and seller are ID of responsible agent. Columns in table "Agents": AgentName, AgentSecondName, ID, bla, bla, bla NOW i want to display list of all agents alongside with numbers of sold and bought items, in a new table like this: AGentName, AgentSecondName, AgentId, Bought, Sold My query is SELECT AgentName, AgentSecondName, ID (SELECT COUNT(*) FROM Orders WHERE (Seller = Agents.ID)) AS SOLD, (SELECT COUNT(*) FROM Orders WHERE (Buyer = Agents.ID)) AS BOUGHT FROM Agents but itąs damn slow with a few millions of records that i have (although its still milliseconds its too slow), any idea how to speed it up?

Hello, I am creating a desktop database application with C# and MS SQL SERVER 2008 EXPRESS, and I have a few Q's about it. Let's suppose we have the table customers, with structure like this: Customers: |ID|Nmae |SecondName | Adres |ShipID|Promoted | ------------------------------------------------------ |1 |John |axxx | ytutyt | 5 | false | |2 |Adam |bxxx | qwefsd 18 | 23 | false | |3 |Eddie |cxxx | fsdfssf 7 | 28 | true | |4 |Eddie |dxxx | fsadsdf 42| 14 | true | |5 |Mark |exxx | hdgdssf 2 | 33 | true | |6 |Mathew|fxxx | xcvxzx 75 | 45 | false | I am new in the Database programming, but knowing the goal of my application, I suppose in the future I will experience at least 2 kinds of problems: 1) I guess every month I will have even 100 000 new records but there are necessary only for two months. After that time I would like to move the unncessessarty records somewhere else than in the customers table in order to avoid performance loss, but I'd like to have access to them on demand. Whats the best way to do it? To create other table with schema like Customers, and every two months move data from Customers to that new table, so that customers will always contain data maximally 2 months old? 2) I would like a new logical table PromotedCustomers containing every record from Customers that has "Promoted" value set to true. What is essential here, is that I would like searching in this new table faster than searching in Cusotmers table. For example, supposing I have Customers table like above: SELECT Name FROM Customers WHERE Promoted = true AND Name = Eddie returns 2 records, but has to search 6 rewcords (whole Customers table) If I had PromotedCustomers table the way I want, I could write: SELECT Name FROM PromotedCustomers WHERE Name = Eddie It also returns 2 records, query is a little bit shorter, but whats most important for me: ONLY 3 RECORDS HAS TO BE SEARCHED, and performance is important in my app. Is it possible to create such a table? Thanx for any help :)

Hello, I am building C# desktop application (client) that will connect to SQL Server on remote machine. There will be many clients connecting to the database at the same time. What do you advise me to do? a) Schould every client connect directly to the remote SQL server? b) Should I create some middle-tier between application and the SQL server, for example some webservice? If yes, whats the best way to communicate between the middle tier and the client? SOAP? I'm just new to .NET and I wonder what are drawbacks of either approach. The most important thing for me is simplicity of the solution , I need to finish thins app as soon as possible. Thanx :)