Creating software along with database

[Toshi Trivedi]

Hi,

I am developing a software for Hospital Management. I want to develop it's exe file along with it's database so that it can be used for demonstration. How to create it. Please help me.

Thanks in avance

[vivek kapile]

Hi Toshi

Which developing software are you using.
If you are using VB6.0 then goto File menu->Click on Make Exe and you can give a demonstrate.

Or

If you are using Visual studio.
You created the standar webapplication1 using VS and have just the standard webform1.aspx.

Copy webform1.aspx, web.config, global.asax into the virtual directory on the new server.
Copy the bin folder and paste it into the virtual directory on the new server.
Open IIS (start->run->inetmgr) on the new server
right click on the new virtual directory and hit properties.
In the application section hit the button that says create.
Then click on the documents tab and make sure your start page (default.aspx or whatever you called is listed in that box.
Hit ok and close out of IIS.

Or

You have the .exe for Windows Based Application either from C# or VB.Net.

When ever you build your project it will create the .exe in debug or release folder. So create Project and build that project, you will get that Exe in debug folder where you are saving your project.

[Toshi Trivedi]

Thanks Vivek. I created the .exe file in the same way as i am developing software in c# but when i am executing the exe file on another system it is neither finding the database nor the path of the server. How to include database in it so that when it is run on another system the user can add, remove and update records to check the software.
Please guide me as i am fresher for this developing software.
Thanks once again

[vivek kapile]

Hi Toshi

If You are using ASP.net add a connection string in web.config file and if you are using windows application add a connection string in App.config file.

<connectionStrings>
<add name="Name"
providerName="System.Data.ProviderName"
connectionString="Valid Connection String;" />
</connectionStrings>

Add .cs file

static void GetConnectionStrings()
{
ConnectionStringSettingsCollection settings =
ConfigurationManager.ConnectionStrings;

if (settings != null)
{
foreach(ConnectionStringSettings cs in settings)
{
Console.WriteLine(cs.Name);
Console.WriteLine(cs.ProviderName);
Console.WriteLine(cs.ConnectionString);
}
}
}
Definitely it will work

[Antony Nadan]

Hi Toshi Trivedi,

I know what you are trying to do. Even i was wondering when i was a fresher. Use sdf Local database,this can be added to your project file by just a right click and add new item .Define the table you want in your application in the sdf file. And while moving to another system, make sure u copy the entire bin folder, coz the exe uses the dll which are present in bin folder. Hope this ll work.

Regards,
Antony Nadan

[Antony Nadan]

Hi Trivedi,

If u didnt understand please Get back to me.

Regards,
Antony Nadan