How to use Lamda Expression in list.FindIndex() c# to find the index of a charater in chracter array?.

The below code will help you to find the index of a charatecte from the list or array


string[] alphabet = {"A", "B", "C", "D","E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O","P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z","1","2","3","4","5","6","7","8","9","0"};

int index= alphabet.ToList().FindIndex(s => s == "G");.

X will contain the index of the character G in the list or array.

You can find more infomration regarding lamda expression from the below link

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

How to split a string with more than one delimiter in c#?

The below code will help you to split a string with more than one charatesrs

string Formula = "((1200+2300)4000)";

char[] delimiters = new char[] { '(', ')','+','-','=' };

string[] AcountCodes;

AcountCodes =formula.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);

Message: HTML Parsing Error: Unable to modify the parent container element before the child element is closed (KB927917)

This issues happens when modifying document while it's being loaded (when browser hasn't "seen" closing tag for this element) . This causes very tricky situation in the parser and in IE it's not allowed For more explanation please vists the IE blog

http://blogs.msdn.com/b/ie/archive/2008/04/23/what-happened-to-operation-aborted.aspx

http://stackoverflow.com/questions/301484/problem-with-html-parser-in-ie

How to covert an xml values to a table in SQL server 2005?

The below code will read xml data from a variable and will covert it to a temporary table.


declare @InputTable xml set @InputTable ='<emaillist CustomerId="1" DepartmentID="1" DepartmentName="Chandelier Male" InvocieId="12009 " InvAmount="6985.00" SettledAmt="0.00" BalanceAmt="6985.00" Age="304" Due=" > 90 " Processed="0" CurrencyName="Rufiyaa" Symbol="MRF" /> <emaillist CustomerId="1" DepartmentID="1" DepartmentName="Chandelier Male" InvocieId="12425 " InvAmount="36.00" SettledAmt="0.00" BalanceAmt="36.00" Age="297" Due=" > 90 " Processed="0" CurrencyName="Rufiyaa" Symbol="MRF" /> <emaillist CustomerId="1" DepartmentID="1" DepartmentName="Chandelier Male" InvocieId="14723 " InvAmount="669.00" SettledAmt="0.00" BalanceAmt="669.00" Age="261" Due=" > 90 " Processed="0" CurrencyName="Rufiyaa" Symbol="MRF" /> <emaillist CustomerId="1" DepartmentID="1" DepartmentName="Chandelier Male" InvocieId="15353 " InvAmount="140.00" SettledAmt="0.00" BalanceAmt="140.00" Age="249" Due=" > 90 " Processed="0" CurrencyName="Rufiyaa" Symbol="MRF" />' Declare @TempTable table ( CustomerId int, DepartmentID int, DepartmentName varchar(50), InvocieId nchar(20), InvAmount numeric(18,2), SettledAmt numeric(18,2), BalanceAmt numeric(18,2), Age int, Due char(10), Processed bit, CurrencyName nvarchar(40), Symbol nvarchar(40), Invoicedate datetime, Invoiceno varchar(50), Referenceno varchar(100), remarks varchar(1000) ) insert into @TempTable SELECT Tbl.Col.value('@CustomerId', 'INT'), Tbl.Col.value('@DepartmentID', 'INT'), Tbl.Col.value('@DepartmentName', 'varchar(50)'), Tbl.Col.value('@InvocieId', 'nchar(20)'), Tbl.Col.value('@InvAmount', 'numeric(18,2)'), Tbl.Col.value('@SettledAmt', 'numeric(18,2)'), Tbl.Col.value('@BalanceAmt', 'numeric(18,2)'), Tbl.Col.value('@Age', 'INT'), Tbl.Col.value('@Due', 'char(10)'), Tbl.Col.value('@Processed', 'bit'), Tbl.Col.value('@CurrencyName', 'nvarchar(40)'), Tbl.Col.value('@Symbol', 'nvarchar(40)'), Tbl.Col.value('@Invoicedate', 'datetime'), Tbl.Col.value('@Invoiceno', 'varchar(50)'), Tbl.Col.value('@Referenceno', 'varchar(100)'), Tbl.Col.value('@remarks', 'varchar(1000)') FROM @InputTable.nodes('//EmailList') Tbl(Col) order by Tbl.Col.value('@Age','INT') select * from @TempTable Regards Rajesh Kamalakshan

How to attach a mdf file to a database in SQL server 2005?

You can use the below command to attach a mdf file to a database in SQL Server 2005.

sp_attach_single_file_db @dbname= 'adminv2', @physname= C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\adminv2.mdf'