Browse Prior Art Database

Method and System for Performing Column Level Operations in a Data Table of a Database

IP.com Disclosure Number: IPCOM000194682D
Publication Date: 2010-Apr-07
Document File: 1 page(s) / 42K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method and system for performing column level operations in a data table of a database.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 88% of the total text.

Page 1 of 1

Method and System for Performing Column Level Operations in a Data Table of a

Method and System for Performing Column Level Operations in a Data Table of aMethod and System for Performing Column Level Operations in a Data Table of a

Database

DatabaseDatabase

A method and system is disclosed for performing column level operations in a data

table of a database. The method and system facilitates performing operations such as ,

but not limited to, selection certain columns from a data table , merging tow columns of

a data table and formatting column of a data table .

In an exemplary implementation of the method and system , SQL Select statement can

be passed and a desire result in terms of a data table is obtained . Following is the

code for performing the operations:

DataTable Clientdt = new DataTable ();

DataTable destinationTable = new DataTable ();

string selectQuery = "Select cc1 as cc1,cc2 as cc2,cc3+cc4 as cc3, SubString(cc1|0|1

) +

'$' as cc4 from table" ;

DataColumn column1, column2, column3, column4;

column1 = new DataColumn ( "CC1"

);

column2 = new DataColumn ( "CC2"

);

column3 = new DataColumn ( "CC3"

);

column4 = new DataColumn ( "CC4"

);

Clientdt.Columns.

Add(column1

);

Clientdt.Columns.

Add(column2

);

Clientdt.Columns.

Add(column3

);

Clientdt.Columns.

Add(column4

);

for ( int

x

= 0;

x

< 10;

x++)

{

DataRow dr = Clientdt.NewRow();

dr[ "CC1"

] =

x+

"1" ;

dr[ "CC2"

+ "2" ;

dr[ "CC3"

] =x + "3" ;

] =x + "4" ;

Clientdt.Rows.

] =xAdd(dr

dr[ "CC4"

);

}

SelectQ...