Sunil's Blog

how to convert a dataset to excel?

2010-05-10T03:04:00.000-07:00

public Stream ConvertDatsetToExcel(DataSet dataset)

{

Stream attachment = null;

string excelContent = "";

excelContent += "<>";if (dataset.Tables[0].Rows.Count > 0){excelContent += "<>";for (int index = 0; index < dataset.Tables[0].Columns.Count; index++){excelContent += "<>";}excelContent += "<>";for (int rowNo = 0; rowNo < dataset.Tables[0].Rows.Count; rowNo++){excelContent += "<>";for (int colNo = 0; colNo < dataset.Tables[0].Columns.Count; colNo++){excelContent += "<>";}excelContent += "<>";}}else{excelContent += "<>";for (int index = 0; index < dataset.Tables[0].Columns.Count; index++){excelContent += "<>";}excelContent += "<>";}excelContent += "

";

excelContent += dataset.Tables[0].Columns[index].ColumnName;

excelContent += "

";

excelContent += dataset.Tables[0].Rows[rowNo][colNo].ToString();

excelContent += "

";

excelContent += dataset.Tables[0].Columns[index].ColumnName;

excelContent += "

";

attachment = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(excelContent));

return attachment;

}

for further information visit
http://www.scribd.com/groups/discussion/40777-how-to-convert-a-datset-to-excel-content-using-c-net

Free Website

2009-09-15T21:06:00.000-07:00

For creating a website in just three steps at free of cost, visit http://thenewidentity.com/

Data Hiding

2009-08-25T04:51:00.000-07:00

If a subclass is having a data member with same name as superclass data member then inside subclass, subclass data member hides superclass data member.
class Sample{
int a = 5;
}
class SubSample extends Sample{
int a = 6;
void display(){
System.out.println("\n a="+a);
}
}
class InheritanaceDemo14{
public static void main(String[] args){
   SubSample s = new SubSample();
   s.display();
   System.out.println("\n s.a="+s.a);
}
}
output:
a = 6
s.a = 6
Explanation:

A super class object can refer its subclass object

2009-08-25T04:21:00.000-07:00

class Sample{
}
class SubSample extends Sample{
}
class InheritanaceDemo8{
public static void main(String[] args){
Sample s1 = new Sample();
Sample s2 = new SubSample();
System.out.println("s1 = " + s1);
System.out.println("s2 = " + s2);
}
}
output:
s1 = Sample@010b30a7
s2 = SubSample@1a758cb

Explanation:

Saddleback publishing Factoscope Ebooks - Rapidshare Link

2009-08-22T14:45:00.000-07:00

Download Saddleback Factoscope e-books.

RapidShare Link downlaod

Quality Ebooks

2009-08-19T23:13:00.000-07:00

These books are high quality PDF files.
These books are very good for anyone. These have images explaining every concept.

http://books.google.co.in/books?q=saddleback+educational+publishing&spell=1&lr=&sa=N&start=90

Using Smart Phones to Access Site S[pecifyc Services - a Mini Project

2009-08-15T19:06:00.000-07:00

This is a mini project which has both code and documentation available.

This work investigates how smart phones can augment site specific services that are electronic services or application that resides in a specific location. Service provider runs MST server on Bluetooth enable PC’s or mobiles located in the store, restaurant, cinema and access them via their mobile service explores (MSE) enable smart phones. The service could push dynamic information updates to the phone via TEXT and MMS. This is to develop a push-based location aware advertising system using Bluetooth. This lets users receive advertisements on their smart phones based on their proximity to particular shops. At a minimum, we need is a single Bluetooth enabled PC to advertise a range of products.

Download Docmentation & code here

Enrique Iglesias Lyrics

2009-08-07T23:35:00.000-07:00

http://www.scribd.com/share/upload/14371537/7daaf3cm8d0j8n72qys
http://www.scribd.com/share/upload/14371985/2lk6ycghytc8r560xk3b

Interview Questions

2008-10-13T21:25:00.000-07:00

You can solve problems on C,C++,Java etc..
click here

PolybeianCipher

2008-07-24T11:07:00.000-07:00

Java code for polybean cipher

download the code from click here to download

Information Extraction using Fuzzy Logic

2008-07-24T10:51:00.000-07:00

It's an efficient and intelligent search algorithm submitted as mini project for my B.Tech course
Download code from
downolad code here
download the documentation from
downolad documentation here

Steganography Technique

2008-07-24T09:56:00.000-07:00

A message is hidden in an image and send to the recipient. The recipient again uses the same technique to extract the message from the image.
I used EXOR operation of each and every bit in message with the least significat bit of pixels in the image. So that after encryption there wont be any modifications in the image so that an observer can not differentiate the original image and the encrypted image.So a secured transmission of message can be achieved.
download the code here

About Rohan Kingdom

2008-07-09T02:24:00.002-07:00

Rohan was the kingdom of the Rohirrim, horse riders, who were fierce in battle. They had survived many years against the orcs but were now to be besieged by both Mordor and Isengard. They loved horses and rode them into battle.

Home City: Edoras
Ruler: Theoden, King of the Mark

* Rohan Peasant: A fast gathering villager, akin to the settler wagon.
* Spearman: A spear carrying infantry, good against cavalry.
* Rohan Warrior: A halberd carrying infantry, good against other infantry.
* Axeman: A axe carrying infantry, good against uruk-hai especially.
* Rider of Rohan: A basic cavalry unit, it is buildable in blocks.
* Horse Archer: An archer on a horse. Good against infantry.
* Crossbowman: Ranged infantry with a strong attack. Good against infantry.
* Knight of the Wold: Knights from the wold of Rohan, especially good at countering ranged infantry.
* Horselord: The most expert horsemen of the Rohirrim. Good at countering infantry.

* Marshall of the Riddermark: A Lord of the Rohirrim, only four are builadable. However, they have a very strong attack, especally against infantry and buildings, and are stealthy with a large aura effect.

You can get more details click here

Lord of the Rings Photos

2008-04-15T10:29:00.000-07:00