How to create Setup in visual studio ?

How to create Setup in visual studio?

1. Open the project for which you need to create a setup
2. Right click the Project name(topmost) in Solution Explorer and select Add->New->Project
3. Select Setup and Deployment as the project type and enter the setup name & click Ok.
4. Right Click Application Folder in the Left Pane and Select Add->Project Output
5. Select Primary Output and click Ok.
6. Select User’s Desktop in Left Pane and in Right Pane Right click and select Create New shortcut
7. In the dialog that opens double click Application folder and Select Primary Output and Click Ok.
8. Now a shortcut appears in right name, Rename it as you wish and this name will appear in the desktop when you install.
9. Right click the shortcut and select Properties window. Change the icon Property to a image that you wish to have for ur appln. Before that add that image to the application folder.
10. Select User’s Programs menu in Left pane and repeat the process you did for User’s Desktop so that an entry for your application appears in the start menu.

Finally In Solution Explorer Right Click Setup1 and click Build. Setup will be created in the applications containing folder.

Login Failed for user ‘sa’.Reason:Not associated with a trusted SQL connection

How to connect to a remote SQL database using c# windows application?

1.First Ensure that Mixed mode authentication is enabled on your SQL Server.

To Enable Mixed Mode authentication Open ENTERPISE MANAGER

a)Right Click the Server under the SQL Server Group node                                (eg. (Local (Windows NT)) and select Properties

b) Under the Security tab Select SQL Sever and Windows and click ok.

2.Create a new login

a) Open Enterprise Manager

b)Open SQL Server Group->Server (Local)(Windows NT)

->Security->Login

c)Right Click Login and Select New Login

d)In General Tab Enter a Login Name & Select SQL Server Authentication and enter a password

e)Under Server Roles tab check all the Roles

f)Under Database Access tab Select the database u want to access remotely and select all database roles except denydatareader & denydatawriter.

g)Click ok to finish.

3.Change the Firewall Settings

a)Goto Control Panel and Select Windows Firewall

b)Under the exceptions tab click Add Program button.

c)In the Add a Program dialog click Browse button and select ProgramFiles ->Microsoft SQLServer->MSSQL1.1->MSSQL->Binn->sqlservr.exe

also select ProgramFiles ->Microsoft SQLServer->90->Shared->sqlbrowser

4.In the client machine goto Control Panel & Select Administrative Tools

a)Select Data Sources(ODBC)

b)In the dialog box that opens click ADD button & select SQL Server & Finish

c)Enter the Database name in the name txtbox and enter the server name & click Next

d)Select SQL Server Auth & Click Client configuration Button.In the Dialog box that opens select Named Pipes radiobutton and click Ok.

e)Enter Login ID & Password u created in step 2 and click Next

5.Use the Follwing Connection String in ur c# appln

connectionString=”Data Source=ServerName;Initial Catalog=DatabaseName;User ID=ssss;password=ssss;”

To find ServerName Goto Programs->MicrosoftSQLServer->ServiceManager

Give the User id and password you created in step 2

Now Run the application

Udhaya

Pisquare

How to make TextBox accept only Deecimal Values?

How to make textbox to allow decimal values in textbox in c#.net windows forms.

private void txtRate_KeyPress(object sender, KeyPressEventArgs  e)

{

    if (!char.IsDigit(e.KeyChar) && !char.IsControl(e.KeyChar) &&   !(e.KeyChar.Equals('.')))
          e.Handled =true;

}

Udhaya

PiSquare

Customizing TextBox

Allowing Only numbers in TextBox

Insert this code in KeyPress event of textBox

private void txtYear_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsDigit(e.KeyChar) && !char.IsControl(e.KeyChar))
e.Handled = true;
}

Allowing Only Letters & White Space in TextBox

private void cmbAuthor_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsLetter(e.KeyChar) && !char.IsControl(e.KeyChar) && !char.IsWhiteSpace(e.KeyChar))
e.Handled = true;
}

Setting Maximum Length of TextBox

Select the Text Box and Change the Max Length Propety

Udhaya

PiSquare