UserDefine_2 Class Reference

User Defined skyline query: data upload, bilk add and computation. More...

List of all members.

Protected Member Functions
void	Page_Load (object sender, EventArgs e)
void	Button1_Click (object sender, EventArgs e)
Private Member Functions
void	InitializeDataSetDdl ()
	Initialize the drop down list on UserDefine_2.aspx with name of data table in DB.
void	InitializeData (string strSchemaID)
	Read data schema from DB, according the ID of schema user selected in the previous page.
DataTable	GetDataSet (string strDataTableName)
	Read data from DB according to the user's selection on data table in the drop down list.
DataTable	ReadFile2Table (string[] strFileContent, DataTable dtData)
	Read data from the user text file and also do the bulk upload if necessary.
bool	blnBulk2DB (DataTable dtSource, string strTblName)
	Bulk add data using SqlBulkCopy in .NET 2.0.

---

Detailed Description

User Defined skyline query: data upload, bilk add and computation.

<author>Jarod Wen</author> <Date>20:18pm, Nov 26th, 2006</Date>

---

Member Function Documentation

void UserDefine_2.Page_Load	(	object	sender,
		EventArgs	e
	)			[protected]

void UserDefine_2.InitializeDataSetDdl

(

)

[private]

Initialize the drop down list on UserDefine_2.aspx with name of data table in DB.

void UserDefine_2.InitializeData

(

string

strSchemaID

)

[private]

Read data schema from DB, according the ID of schema user selected in the previous page.

Parameters:

strSchemaID

Schema ID

void UserDefine_2.Button1_Click	(	object	sender,
		EventArgs	e
	)			[protected]

DataTable UserDefine_2.GetDataSet

(

string

strDataTableName

)

[private]

Read data from DB according to the user's selection on data table in the drop down list.

Parameters:

strDataTableName

Returns:

DataTable UserDefine_2.ReadFile2Table	(	string[]	strFileContent,
		DataTable	dtData
	)			[private]

Read data from the user text file and also do the bulk upload if necessary.

Parameters:

	strFileContent	Contents of the file user uploaded
	dtData	The structure of the table for storing

Returns:

Data table filled with data.

bool UserDefine_2.blnBulk2DB	(	DataTable	dtSource,
		string	strTblName
	)			[private]

Bulk add data using SqlBulkCopy in .NET 2.0.

Parameters:

	dtSource	Data Table containing data which will be added into database
	strTblName	The name of table user want to store as.

Returns:

Whether the bulk add succeeds

---

The documentation for this class was generated from the following file:

• E:/Documents and Settings/LeeWinnie/My Documents/Visual Studio 2005/WebSites/SkylineWebSite/UserDefine_2.aspx.cs

---