Friday, August 28, 2009

Create EXE or Setup File in .NET Windows Application

1>First create a project and make the application
2>Do unit testing so as to the application run correct.
After you have developed your windows apllication,now you want to make a can?
These steps are gives the guidance to you…
3>Go to file menu > click Add > new project >now "Add New Project" Dialog appear

4.Select "Other Project Types" and click "Setup and Deployment' projects,Choose "Setup Project" give name project name in name text box finally click OK.

5.New project appear in solution explorer,for example you give the name "TestAddition" will display with this name.
6.Right click the TestAddition > go View > click "File System"

7.You can see the "File System on TargetMachine" under three folders Application Folder, User’s Desktop, User’s Program Menu.

8.Select Application Folder and right click Add>Project Output>select Primary output

9.Select User’s Desktop richt click on the second window>click create new shortcut>select output file from Application folder>change the file name from primary output name to MyEXE.Click on next >> same procedure follows the user’s program menu also
9.If you want to change the Manufactures name for exe,just right click the project go to properties change the properties as per you requirement

10>Finally Build the new project After successfully Build the project myEXE(Setup) will be appear in Application Debug or Release folder(depend upon the properties settings)

EXE available @ this location
To find your exe location go the project folder.there have one more folder created with the name of your exe.
Enter the folder there you find Debug folder.Now you found your exe or set up file.

When you want to install the EXE on the client machine,you should be installed .NET Framework on that mc because,Applications and controls written for the .NET Framework version 2.0 require the .NET Framework Redistributable Package version 2.0 to be installed on the computer where the application or control runs.

How To add windows service into the service list
1>First create a windows service application.
2>project/bin/debug folder exe will be created .
3>Open the visual studio command prompt
4>Navigate to the service exe path

5>Type Installutil SERVICENAME.exe

How To de register windows service from the service list
1>Go to command prompt and type
2>sc delete SERVICENAME

Sunday, August 16, 2009

How do I import Access Database into SQL Database(2000)

1.Right click on any database
2.Select ALL TASKS and then select IMPORT DATA after clicking
3.One dialog box will appear,click NEXT
4. And choose MICROSOFT ACCESS as DATA SOURCE, what displayed on the following picture.

Then BROWSE ur access file then click NEXT(keep username and password blank)
5.Chosse the DESTINATION[SQL native client].Click on properties

6.Chosse Data Source(localhost),select a specific username and password.
(With sa sa),Chosse Database from Initial Catalog.Click Ok.
7.Click Next.

8.Select copy tables and views from source database then click next
9.Select all tables,click Next.
10.Check run immediately,click Next.
11.Click finish.