Creation and use of custom controls in ASP.NET

/// Get record set

///

///

Public DataSet getData ()

{

String straType = NULL;

String strsty = null;

String SQL;

Switch (psorttype)

{

Case SortType.employeeiD:

Strtype = "EmployeeID";

Break;

Case SortType.birthdate:

Strtype = "birthdate";

Break;

Case SortType.FirstName:

Strtype = "firstname";

Break;

Case SortType.lastname:

Strtype = "lastname";

Break;

Case SortType.title:

Strtype = "Title";

Break;

Case SortType.TitleOfCourtesy:

Strtype = "TitleOfcourteesy";

Break;

DEFAULT:

Strtype = "undefine";

Break;

}

Switch (psortstyle)

{

Case SortStyle.asc:

strStyle = "ASC";

Break;

Case SortStyle.Desc:

strStyle = "DESC";

Break;

DEFAULT:

strStyle = "undefine";

Break;

}

SQL = "SELECT * from Employees Order by" strtype " strStyle;

SqlConnection Con = New SqlConnection ("Server = Accp-lzh; UID = SA; PWD = Sasa; Database = Northwind");

SQLCommand cmd = con.createcommand ();

cmd.commandtype = commandtype.text;

cmd.comMandText = SQL;

SqlDataAdapter ada = new sqldataadapter ();

Ada.selectcommand = cmd;

DataSet DS = New Dataset ();

C.Open ();

Ada.fill (DS, "Employees");

C. close ();

Return DS;

}

}

}

2. After saving, compile this file as the assembly, compile command to: CSC / T: library /r :system.dll ,system.web.dll c: /inetpub/wwroot/teachshow/charpter9/ReturndataSet/datasetClass.cs. Where: c: /inetpub/wwwroot/teachshow/charpter9/retataSet/DataSetClass.cs is the path where the file is located. If the compilation is successful, a DataSetClass.dll file will be generated.

3. Create a new web form to join DataSetClass.dl into the toolbox. The method is: Open the toolbox, find the Web Form tab, click Right click, select Add / Delete Item, click the "Browse" button, find the DataSetClass.dll file, and then automatically add it to the tab. Control name is class name: datasetClass4, start using this control: Draw a list of two lines, put a DataSetClass on a row, and put a DataGrid control to display data.

5, the code is as follows:

Test.aspx content:

<% @ Register tagprefix = "cc2" namespace = "teachshow.charpter9.ReturndataSet" Assembly = "DatasetClass"%>

<% @ Page language = "c #" codebehind = "test.aspx.cs" autoeventwireup = "false" inherits = "teachshow.charpter9.returndataset.test"%>