AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
I'm working upon a project in which I need to enter some initial data (more than 50 records) and display them with DataGrid control. I have to let users bring changes in the records and add new records as well. I'm using the MS SQL DBMS to prepare the application. I run the application and then enter records which save changes in the database when I call update method. I want to know, is it necessary that MS SQL is installed on the user's machine to use this application? Can I do something while deploying the application that user is free of installing MS SQL DBMS? If yes, can you guide me please through the deployment process?
Best Regards,
Adeel Rauf
adeel.rauf@hotmail.com
Answer SQL Server needs to installed on client machine or as a sep. server at client side to run the application.
It is always better to setup SQL Server manually rather than looking for some automated deployment procedure you will be wasting time looking for it.
And as far as entering initial data is concerned you can run sql scripts to get that data into sql server at the time of your application installation (ofcourse sql server has to be installed already for that to happpen).
