How to create DataBase in Sql Server

 How to Create DataBase in Sql Server

You may be required to create a new Microsoft SQL database. This article explains how to create a new database on the following versions of Microsoft SQL Server:

• Microsoft SQL Server 2000
• Microsoft SQL Server 2005
• Microsoft SQL Server 2008

Microsoft SQL Server 2000

1. Open Microsoft SQL Management Studio
2. Expand the Microsoft SQL Server node where you want to create the database
3. Right click the Databases node and then click New Database  

 4.  Type the database name in the dialog box, for example,  Visualstudioexpert_demo , and then click OK

Microsoft SQL Server 2005

1. Open Microsoft SQL Management Studio
2. Connect to the database engine using database administrator credentials
3. Expand the server node
4. Right click Databases and select New Database

  5. Enter a database name and click on OK to create the database

Microsoft SQL Server 2008

1. Open Microsoft SQL Management Studio
2. Connect to the database engine using database administrator credentials
3. Expand the server node
4. Right click Databases and select New Database
5. Enter a database name and click OK to create the database

How Send Mail in ASP .Net

This tutorial will show you how to send a simple email message using ASP.NET 2.0 and C#

Introduction

Sending email is a very common task in any web application for many purposes.
Sending e-mails with ASP.NET is pretty straight forward. The .NET framework comes with an entire namespace for handling e-mails, the System.Net.Mail namespace. In the following examples, we will use two classes from this namespace: The MailMessage class, for the actual e-mail, and the SmtpClient class, for sending the e-mail. As you may be aware, mails are sent through an SMTP server, and to send mails with the .NET framework, you will need access to an SMTP server. If you're testing things locally, the company that supplies your with Internet access, will usually have an SMTP server that you can use, and if you wish to use one of these examples on your actual website, the company that hosts your website will usually have an SMTP server that you can use. Go through the support pages to find the actual address - it's usually something along the lines of smtp.your-isp.com or mail.your-isp.com.

First, you will need to import the System.Net.Mail namespace.

 protected void MailSendBtn_Click(object sender, EventArgs e)
    {
     
try
    {
        MailMessage mailMessage = new MailMessage();
        mailMessage.To.Add("your.own@mail-address.com");
        mailMessage.From = new MailAddress("another@mail-address.com");
        mailMessage.Subject = "ASP.NET e-mail test";
        mailMessage.Body = "Hello world,\n\nThis is an ASP.NET test e-mail!";
        SmtpClient smtpClient = new SmtpClient("smtp.your-isp.com");
        smtpClient.Send(mailMessage);
        Response.Write("E-mail sent!");
    }
    catch(Exception ex)
    {
        Response.Write("Could not send the e-mail - error: " + ex.Message);
    }
}