Broklyne Bridge

Creating a single field from multiple row results

select stud_id , group_concat(paper_id) as i from tb
group by id

Original Table:
stud_id paper_id
1 1
1 2
1 3
1 4
2 2
2 3
3 1
4 2

Output:
stud_id paper_id
1 1,2,3,4
2 2,3
3 1
4 2

Fast Folder Access

Fast Folder Access is a shell enhancement that gives you fast access to your favorite folders in Common Open/Save dialogs, in Windows Explorer, the desktop and the Start Button.

It’s also an add-on for viewing images in Windows Explorer that lets you right-click on an image file to bring up a miniature image and image file information

Features

1 Fast access to folders in comman Open/Save -dialogs.

2 Fast access to folders in Windows Explorer and the desktop

SeaMonkey

Web-browser, advanced e-mail and newsgroup client, IRC chat client, and HTML editing made simple — all your Internet needs in one application.

he SeaMonkey^® Project

The SeaMonkey project is a community effort to develop the SeaMonkey all-in-one internet application suite (see below). Such a software suite was previously made popular by Netscape and Mozilla, and the SeaMonkey project continues to develop and deliver high-quality updates to this concept. Containing an Internet browser, email & newsgroup client, HTML editor, IRC chat and web development tools, SeaMonkey is sure to appeal to advanced users, web developers and corporate users.

Under the hood, SeaMonkey uses much of the same Mozilla source code which powers such successful siblings as Firefox, Thunderbird, Camino, Sunbird and Miro. Legal backing is provided by the Mozilla Foundation.

Number To English

NumberToEnglish conWord = new NumberToEnglish();

dt.Columns.Add(“AmountInWord”, Type.GetType(“System.String”));

DataRow row2;

row2 = dt.Rows[0];

row2["AmountInWord"] = conWord.changeCurrencyToWords(sTHeadAmount.ToString());

Compute Function for data table

int TotalAmount = Convert.ToInt32(dtTotalAmt.Compute(“SUM(amount_pay)”, “amount_pay > 0″));

RemAmount = RemAmount – HeadTotalAmount;