Lg optimus black Recovery

You can go Back to Original Recovery by using the LG Mobile Updater

1. Download LG Mobile Updater (http://www.lg.com/de/support/mc-supp...p?countryCd=de)
2. Install Mobile Updater
3. Remove Battery from the phone and plug it to the Computer while Holding Vol-Up Button. Display should now show S/W Upgrade
4. Start the Mobile Updater, if needed install USB-Drivers
5. In the Menu of the Mobile Updater choose Customer Service -> Emergency Repair
6. Enter the IMEI of your Phone when the Updater asks for it and click Check
7. The Phone gets now reflashed. All Partitions except the Data Partition will be reflashed.

Multi level xml generation using XMLSerialization in C#.Net

//In memory XML generation using Serialization//

XmlSerializer srl = new XmlSerializer(typeof(UserLogin));

StringWriter sw = new StringWriter();

srl.Serialize(sw, oUserLogin);

string xml = sw.GetStringBuilder().ToString();

[Serializable]

[XmlRoot("Users")]

public class UserDetails

{

//First way to create inner XML nodes

[XmlArray("AddressDetails")]

public List AddressDetail { get; set; }

//Second way to create inner XML nodes

[XmlArray("ContactDetails")]

[XmlArrayItem("ContactDetail")]

public List ContactDetail { get; set; }

}

[Serializable]

[XmlType("AddressesDetail")]

public class AddressDetails

{

public string ........ (Properties)

}

[Serializable]

public class ContactDetails

{

public string ........ (Properties)

}

Cannot send E-Mails with large attachments (System.Net.Mail.SmtpClient, System.Net.Mail.MailMessage)

Please find the solution on following URL

https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=30226

msftesql and cisvc services error in MS CRM 4.0

While installing MSCRM 4.0 on Windows Server 2008, having SQL Server 2008 preinstalled, the installation verification fails and displays missing components msftesql and cisvc services.

1) msftesql (the sql server full text indexing service) has a different name against sql server 2008.

Just rename the registry key HKLM\System\CurrentControlSet\Services\MSSQLFDLauncher to msftesql to give an illusion to the MSCRM verification phase that services is present in the system so that it does not fail while installation.
Now restart the system and run the installation of MSCRM again.
After installation rename the HKLM\System\CurrentControlSet\Services\msftesql back to MSSQLFDLauncher.

2) To solve the cisvc services error, right click the MyComputer->Manage, now right click the Roles ->Add Roles and now install the file services role.


Ref:
http://msdynamicscrmblog.blogspot.com/2009/10/missing-msftesql-and-cisvc-services.html

All About Date Time in sql server

http://www.databasejournal.com/features/mssql/article.php/2191631/Working-with-SQL-Server-DateTime-Variables.htm

Good link for all about datetime in sql server

Get Starting of Current Week, Current Month, Current Year in Sql Server

declare @CurrentWeek date, @CurrentMonth date, @Year date, @LastWeek date, @LastMonth date, @LastYear date

Declare @DateValue DateTime = '3/24/2011'

select @CurrentWeek = DATEADD (wk, datediff( wk, 6, @DateValue ), 6 )

select @LastWeek = DATEADD(Wk, -1, (@CurrentWeek))

select @CurrentMonth = CONVERT(date, CONVERT(varchar, DatePart (M, @DateValue)) + '/1/' + convert(varchar, DATEPART(YEAR,@DateValue)))

select @LastMonth = CONVERT(date, DATEADD(M,-1 , @CurrentMonth), 106)

select @Year = CONVERT(date, CONVERT(varchar, '1/1/' + convert(varchar,DATEPART(YEAR,@DateValue))))

select @LastYear = CONVERT(date,DATEADD(YEAR, -1,@Year),106)

select @CurrentWeek,@LastWeek,@CurrentMonth,@LastMonth, @Year, @LastYear

SharePoint 2010 installation guide

Nice link for reference

http://mosshowto.blogspot.com/2009/11/installing-sharepoint-2010-windows-2008.html