How to add new user in sql server management studio 2008

Hei guys,
I was also suffering from this problem and finally I got succeeded so i am sharing my experience here.

Steps:
(This is a experience of doing it in windows 7 but should work in xp, vista and 2000 as well)

1. Open SQL management studio and log in
first as windows authentication mode.
(choose proper server name in which you want to add user)
as shown in figure










2. Extend security folder content which is located in right side if window. Right click on login tab (as shown in figure) and add new user.

3. put login name, click radio button to SQL Authencation,
put password
uncheck enforce password policy and select database as master as shown in figure










4. click on user mapping tab and click on master database and make it owner of database as shown in figure.

















5. Now you completed the process click ok and restart computer then try to login with your new user account. For sure it will work.

If you have any problem please feel free to ask me :)

Thank you
mebalkrishna@gmail.com

Difference between Stack and Heap

Stack

It used by value type. It can store fixed amout of data and stored in RAM.

Stack is used by Int, Array, Enumerator, Struct. Memory management is automatically done by program so we dont need to create desctructor.

Heap

It is Used by reference type. It has unlimited size. Data whose size can not be determined before execution of program and need to allocate dynamically in run time are fall in this category. For example if we need to read data of file then it may have any size so this type of date are stored in heap. It is stored in secondary memory i.e. harddisk.

String, Classes use heap for storing data. Program doesnot about memory status of heap so programmar him/herself need to destruct it.

Consuming WCF Services hosted in IIS7

To consume services we should conform before that whether there is services or not.
If Wcf services test it before using it with the command 'testwcfclient' along with hosted service path.

first.
1. Add the new website on the builded project and choose ASP.NET website Template
and Give appropriate name as you want.
2. Add reference of service which is hosted in IIS7 by clicking on "service reference"from add reference.

2. make simple asp page to access the services and write some code on .cs file of that page.
3. Dont forget to add reference in .cs page
eg. using ServiceReference1;

4. call services and use its function as in other class and object.
eg. MyCalculatorClient client = new MyCalculatorClient();

here MyCalulator is service name:

5. after writing some code to consume services, build the whole solution and then view the project on browser.

new page will be open in browser and you can use that service by putting the value and accessing result.

Thus you can use the WCF services hosted in II7.

Difference between string and String in C#

There is such difference in string and String. These can be apply for the same purpose. The only difference between these is String can be used as identifier but string can not.

System.ServiceModel.EndpointNotFoundException: Could not connect

Problem ( Took 2 days to Solve)

When You try to consume Self-hosted WCf services from Windows From in VS 2008. You might get this error quite often...

System.ServiceModel.EndpointNotFoundException: Could not connect to http://localhost:8731/Design_Time_Addresses/MyCalculatorService/MyCalculatorService/. TCP error code 10061: No connection could be made because the target machine actively refused it 127.0.0.1:8731. ---> System.Net.WebException: Unable to connect to the remote server --->

This error is due to the Behavior of WCF service. You need to make Singleton instance of that WCF Service.
so You need to add following code before start of Service Class in Service file.

[ServiceBehavior(InstanceContextMode = InstanceContextMode.Single)]

and again build service or whole solution and Run the Windows From then You get the answer.

Thank You.

Client program to consume Selfhosted WCF Services in Microsoft Visual Studio 2008

1. add new project by Right clicking on Solution
2. go to Windows tab
3. select Console Application then give some name for consuming name: e.g. CalCAreaClient then click ok.
4. Add System.ServiceModel as reference and also Add WCF Service as a Project reference
5. add using System.ServiceModel; on the program.cs
6. Add service Reference, and discover the service and add it.
7. Add that service reference on the code eg.
using CalcAreaClient.ServiceReference1;
8. Create proxy to access service.
eg.
namespace CalcAreaClient
{
class Program
{
static void Main(string[] args)
{
try
{
CalcAreaWcfServiceClient proxy = new CalcAreaWcfServiceClient();
double calcVal = proxy.CalcAreaSquare(5);
Console.WriteLine("Area of Square = {0}", calcVal);
Console.WriteLine("Press enter to terminate client");
Console.ReadLine();
}
catch (Exception e) {
Console.WriteLine("Error on client program");
Console.WriteLine("error {0}", e);
Console.ReadLine();
}
}
}
}

i thinkall te createria is fulfill. Now just run the serviceHost program first and then build this client program.
from visual studio command promt which is diffferent than normal command promt.

Selfhosting of WCF Services in Microsoft Visual Studio 2008

1. add new project by Right clicking on Solution
2. go to Windows tab
3. select Console Application then give some name for selfhosting name: e.g. CalCAreaWcf then click ok.
4. Add System.ServiceModel as reference and also Add WCF Service as a Project reference
5. add using System.ServiceModel; on the program.cs
6. copy App.Config file from Wcf Service folder to this folder
7. Write some code in program.cs for hosting service
you can write like this:

namespace CalcAreaWcf
{
class Program
{
static void Main(string[] args)
{
try{
ServiceHost CalculatingAreaService = new ServiceHost(typeof(CalcAreaWcfService));
CalculatingAreaService.Open();
Console.WriteLine("Cheers!!! Service is Running, Press Enter to close Serive");
Console.ReadLine();
CalculatingAreaService.Close();

}
catch(Exception e){
Console.WriteLine("Problem occur");
Console.WriteLine("Error {0}", e);
Console.ReadLine();
}
}
}
}

Now everything is done. You need to build the hostingservice by Rclicking on Hosting file.
I thing, now service is build u can go and see it from Command prompt of respective project location
projectfile\bin\debug\CalculatingAreaService.exe

Hurrey! Service is Running....