Insert data from Excel to SQL Server 2005 by using copy and paste commands

http://www.mssqltips.com/tip.asp?tip=1430

how to reset you sqlserver password

hi anybody forget or lost sqlserver password, dont worry

follow these steps:-
1)open sql query analyzer
2)click on windows authentication
3)click connect
4)enter this command
sp_password null,’new password’,'username’

ex:-sp_password null,’hello’,’sa’

simple

now your password is reset now connect to sa user to this password

note:-if you are using vista open query analyzer ‘run as admin’

How do I send a web page

System.Net.Mail does not natively support sending a web page. However, using the WebRequest class, you can screen scrape web pages, and pass the resulting Html string to the MailMessage object. The following example demonstrates this technique.

public static void EmailWebPage()
{
//create the mail message
MailMessage mail = new MailMessage();

//set the addresses
mail.From = new MailAddress(”me@mycompany.com”);
mail.To.Add(”you@yourcompany.com”);

//set the content
mail.Subject = “This is an email”;

//screen scrape the html
string html = ScreenScrapeHtml(”http://localhost/example.htm”);
mail.Body = html;
mail.IsBodyHtml = true;

//send the message
SmtpClient smtp = new SmtpClient(”127.0.0.1″);
smtp.Send(mail);

}
public static string ScreenScrapeHtml(string url)
{
WebRequest objRequest = System.Net.HttpWebRequest.Create(url);
StreamReader sr = new StreamReader(objRequest.GetResponse().GetResponseStream());
string result = sr.ReadToEnd();
sr.Close();
return result;
}

WCF

I am very new to WCF this link is very useful who are learn to WCF

http://msdn.microsoft.com/en-us/netframework/cc512374.aspx

vs2010

Microsoft released 2010 beta 1

http://blogs.msdn.com/jasonz/default.aspx

how to get distinct values particular column database

hi

this is post is used people who want to get the distinct values of particulare column like this

sno sname qualification

1     kiran       mca

2  kick            mba

3   kiran        b.tech

now i want to only like this

1 kiran mca

2 kick mba

query is

select min(sno) as id,sname,max(qua) from kiran group by sname

C# Anonymous Types

http://bellouti.wordpress.com/2008/01/20/c-30-anonymous-types/

We only use Anaonymouse types in local variables we are not use in function return types and function parameters

what is database mirroring???

http://msdn.microsoft.com/en-us/library/ms177412.aspx

http://msdn.microsoft.com/en-us/library/cc966458.aspx

http://technet.microsoft.com/en-us/library/ms189852.aspx

Code name for Microsoft Products

http://en.wikipedia.org/wiki/List_of_Microsoft_codenames

code names for Visual Studio

Visual Studio 2003 –>Quattro
Visual Studio 2005 –>Whidbey
Visual Studio 2008 –>Orcas
Visual Studio 2010 –>Rosario