description
Code
/
Checkboxcolumn.cs
///
/
Using
System;
Using
System.Web;
Using
System.Web.ui.WebControls;
Namespace
MSDN
{
///
///
CHECKBOXCOLUMN abstract illustration.
///
public
Class
CheckboxColumn: DataGridColumn
{
Private
String
m_alltext;
public
Checkboxcolumn ()
{
CheckboxallText
=
"
select all
"
;
}
public
String
CheckboxallText
{
get
{
Return
m_alltext;
set
{m_alltext
=
Value;
}
public
Override
Void
Initializecell (Tablecell Cell,
int
ColumnIndex, ListItemType ItemType)
{
Base
.Initializecell (Cell, ColumnIndex, ItemType);
IF
(ItemType
==
ListitemType.Header)
{
Checkbox chk
=
New
Checkbox ();
Label L
=
New
Label ();
L.Text
=
CheckboxallText;
Chk.attributes.add (
"
Onclick
"
,
"
JavaScript: SelectAllCheckboxes (this);
"
);
Cell.Controls.Add (CHK);
Cell.Controls.Add (L);
}
IF
(ItemType
==
ListItemType.Item
||
ItemType
==
ListItemType.alternatingItem)
{
Checkbox chk
=
New
Checkbox ();
//
Chk.checkedchanged = New EventHandler (chK_CHECKEDCHANGED);
Chk.autopostback
=
False
;
Chk.attributes.add (
"
Onclick
"
,
"
JavaScript: Selectonerow (this);
"
);
Cell.Controls.Add (CHK);
}
}
Private
Void
Chk_checkedchanged
Object
Sender, Eventargs E)
{
//
((CHECKBOX) (Checkbox) .parent.namingcontainer .ite .ite
}
}
}
/Usuperdatagrid.cs
///
Using
System;
Using
System.Web.ui;
Using
System.Web.ui.WebControls;
Using
System.data;
Using
System.drawing;
Using
System.collections;
Using
System.Text;
Namespace
MSDN
{
public
Class
SuperdataGrid: system.web.ui.webcontrols.datagrid
{
Private
int
m_createpagetimes
=
0
;
Private
Color M_MouseOver
=
Color.empty;
Private
Color M_Mouseout
=
Color.empty;
Private
Static
DataView M_DataView;
public
SuperDataGrid ():
Base
()
{
Allowpaging
=
True
;
PageIndexchanged
=
New
DataGridPageChangeDeventHandler (HyperDataGrid_pageIndexchanged);
ItemCommand
=
New
DataGridCommandeventHandler (HyperDataGrid_ItemCommand);
Itemcreated
=
New
DataGriditeMeventHandler (HyperDataGrid_Itemcreated);
ItemDatabase
=
New
DataGriditeMeventHandler (HyperDataGrid_ItemDatabase;
SortCommand
=
New
DataGridSortCommandeventHandler (HyperDataGrid_sortCommand);
}
public
Void
SetCheckboxClintscript ()
{
Page.RegisterClientScriptblock
"
SELECTONEROW
"
Registerscript (color.pink);
}
String
Registerscript (Color Color)
{
StringBuilder Str
=
New
Stringbuilder ();
Str.Append
""
);
Return
Str.toString ();
}
//
Declare DataView
public
DataView M_DataView
{
get
{
Return
M_DataView;}
set
{m_dataview
=
Value;
}
public
Color OnMouseOverColor
{
get
{
Return
m_mouseover;}
set
{M_MouseOver
=
Value;
}
public
Color OnMouseoutColor
{
get
{
Return
m_mouseout;
set
{m_mouseout
=
Value;
}
public
Event
EventHandler UpdateView;
//
Fire DataBinding Event
public
Event
EventHandler InsertView;
Private
Void
OnUpdateView ()
{
IF
(UpdateView
! =
NULL
)
UpdateView
THIS
Eventargs.empty;
}
Private
Void
OnInsertview ()
{
IF
(InsertView
! =
NULL
)
INSERTVIEW
THIS
Eventargs.empty;
}
Private
Void
HyperDataGrid_pageIndexchanged (
Object
Source, DataGridPageChangeDeventargs E)
{
DataGrid de TGRID
=
DataGrid) Source;
Detgrid.currentpageIndex =
E.NEWPAGEINDEX;
m_createpagetimes
=
0
;
OnupdateView ();
}
Private
Void
HyperdataGrid_ItemCommand
Object
Source, DataGridCommandeventArgs E)
{
IF
(e.commandname
==
"
alpha
"
)
{
ViewState [
"
alpha
"
]
=
E.COMMANDARGUMENT;
m_createpagetimes
=
0
;
CurrentPageIndex
=
0
;
OnupdateView ();
}
IF
(e.commandname
==
"
CANCLE
"
)
{
Showfooter
=
False
;
}
IF
(e.commandname
==
"
Insert
"
)
{
OnInsertView ();
Showfooter
=
False
;
}
}
Private
Void
HyperDataGrid_Itemcreated
Object
Sender, DataGriditeMeventArgs E)
{
IF
(E.Item.itemType
==
ListitemType.Header)
{
//
Sort
Foreach
(TableCell C
in
E.Item.cells)
{
IF
(C.Controls.count
>
0
&&&&
C.Controls [
0
] .Gettype (). TOSTRING ()
==
"
System.Web.ui.WebControls.DataGridLinkButton
"
)
{
IF
((LinkButton) C.Controls [
0
]). TEXT
==
(
String
ViewState [
"
Sort
"
])
{
Label L
=
New
Label ();
L.Font.name
=
"
Webdings
"
;
IF
(("
String
ViewState [
"
ORDERBY
"
]
==
"
ASC
"
)
L.Text
=
"
5
"
;
Else
L.Text
=
"
6
"
;
C.Controls.Add (L);
}
}
}
}
IF
(E.Item.itemType
==
ListItemType.Item
||
E.Item.itemType
==
ListItemType.alternatingItem)
{
//
System.drawing.color color color color.fromargb ((int) E.Item.backcolor.r, (int) E.Item.backcolor.g, (int) E.Item.backcolor.b)
//
String str = E.Item.backcolor;
IF
(OnMouseOverColor)
==
Color.empty)
OnMouseOverColor
=
SelectEdItemSty.BackColor;
IF
(OnMouseOutcolor)
== Color.empty)
OnMouseoutColor
=
ItemStyle.backcolor;
/ *
E.Item.attributes.add ("onmouseover", "this.style.BackgroundColor = 'pink'"); // " onmouseover "
E.Item.attributes.add ("onmouseout", "this.style.backcoundColor = '#" Converthex (onmouseoutColor) ""); // " onmouseoutcolor "
* /
}
IF
(E.Item.itemType
==
ListItemType.footer)
{
int
i
=
0
LinkButton LB;
Foreach
(TableCell C
in
E.Item.cells)
{
IF
(i
==
0
)
C.Controls.add (
New
Checkbox ());
Else
IF
(i
==
E.Item.cells.count
-
2
)
{
LB
=
New
LinkButton ();
lb.text
=
"
insert
"
;
lb.commandname
=
"
Insert
"
;
C.Controls.Add (lb);
}
Else
IF
(i
==
E.Item.cells.count
-
1
)
{
LB
=
New
LinkButton ();
lb.text
=
"
cancel
"
;
lb.commandname
=
"
CANCLE
"
;
C.Controls.Add (lb);
}
Else
C.Controls.add (
New
Textbox ());
i
;
}
}
IF
(E.Item.itemType
==
ListItemType.pager)
{
IF
(m_createpagetimes
==
0
)
{
E.Item.cells [
0
] .Controls.clear ();
LinkButton L;
for
(
int
i
=
65
i
Webform4
&
NBSP;
"
DataKeyfield =
"
Customerid
"
AllowPaging =
"
True
"
Barowsorting =
"
True
"
AutogenerateColumns =
"
False
"
BorderStyle =
"
None
"
Borderwidth =
"
1px
"
Backcolor =
"
WHITE
"
Bordercolor =
"
# Cc9966
"
Cellpadding =
"
4
"
OnmouseoutColor =
"
WHITE
"
ONMOUSEOVERCOLOR =
"
255
,
204
,
102
"
>
/
// Call the background code of the component .cs
/
//
Using
System;
Using
System.collections;
Using
System.componentmodel;
Using
System.data;
Using
System.drawing;
Using
System.Web;
Using
System.Web.SessionState;
Using
System.Web.ui;
Using
System.Web.ui.WebControls;
Using
System.Web.ui.htmlControls;
Namespace
DataGridddemocs
{
///
///
Abstract description of WebForm4.
///
public
Class
Webform4: System.Web.ui.page
{
protected
System.data.sqlclient.sqldataadapter SqlDataAdapter1;
protected
System.data.sqlclient.sqlcommand sqlselectcommand1;
protected
System.data.sqlclient.sqlcommand sqlinsertcommand1;
protected
System.data.sqlclient.sqlcommand sqlupdateCommand1;
protected
System.data.sqlclient.sqlcommand sqldeleteCommand1;
protected
System.data.sqlclient.sqlConnection SqlConnection1;
protected
DataGriddemocs.dscustomers dscustomers1;
protected
Msdn.superDataGrid SuperDataGrid1;
protected
System.Data.DataView DV;
//
Protected hyperdatagrid hyperdatagrid2;
//
HyperDataGrid hyperdatagrid1;
Private
Void
Page_load
Object
Sender, System.EventArgs E)
{
//
Place the user code here to initialize the page
IF
(
!
Page.ispostback)
{
Binddata ();
}
}
#REGION
Code generated by web form designer
Override
protected
Void
OnInit (Eventargs E)
{
//
//
Codegen: This call is required for the ASP.NET Web Form Designer.
//
InitializationComponent ();
Base
.Onit (e);
}
///
///
Designer supports the required method - do not modify using code editor
///
This method is content.
///
Private
Void
InitializeComponent ()
{
THIS
. SqldataAdapter1
=
New
System.data.sqlclient.sqldataadapter ();
THIS
.sqldeleteCommand1
=
New
System.data.sqlclient.sqlcommand ();
THIS
. SqlConnection1
=
New
System.data.sqlclient.sqlconnection ();
THIS
.sqlinsertcommand1
=
New
System.data.sqlclient.sqlcommand ();
THIS
. SqlselectCommand1
=
Newsystem.data.sqlclient.sqlcommand ();
THIS
.sqlupdateCommand1
=
New
System.data.sqlclient.sqlcommand ();
THIS
.dscustomers1
=
New
DataGridDemocs.dscustomers ();
THIS
.dv
=
New
System.Data.DataView ();
(System.comPonentModel.isupportInitialize)
THIS
.dscustomers1)))). Begininit ();
(System.comPonentModel.isupportInitialize)
THIS
.dv)). Begininit ();
THIS
. SuperDataGrid1.updateView
=
New
System.eventhandler
THIS
. SuperDataGrid1_updateview);
//
//
SqlDataAdapter1
//
THIS
. SqldataAdapter1.deleteCommand
=
THIS
. SqlDeleteCommand1;
THIS
. SqldataAdapter1.insertCommand
=
THIS
. SqlinsertCommand1;
THIS
. SqldataAdapter1.selectCommand
=
THIS
.sqlselectcommand1;
THIS
. SqldataAdapter1.tablemappings.addrange (
New
System.data.common.DataTableMapping [] {
New
System.data.common.DataTableMapping (
"
TABLE
"
,
"
Customers
"
,
New
System.data.common.datacolumnmapping [] {
New
System.data.common.datacolumnmapping (
"
Customerid
"
,
"
Customerid
"
),
New
System.data.common.datacolumnmapping (
"
CompanyName
"
,
"
CompanyName
"
),
New
System.data.common.datacolumnmapping (
"
ContactName
"
,
"
ContactName
"
),
New
System.data.common.datacolumnmapping (
"
ContactTitle
"
,
"
ContactTitle
"
),
New
System.data.common.datacolumnmapping (
"
Address
"
,
"
Address
"
),
New
System.data.common.datacolumnmapping (
"
CITY
"
,
"
CITY
"
),
New
System.data.common.datacolumnmapping (
"
Region
"
,
"
Region
"
),
New
System.data.common.datacolumnmapping (
"
Postalcode
"
,
"Postalcode
"
),
New
System.data.common.datacolumnmapping (
"
COUNTRY
"
,
"
COUNTRY
"
),
New
System.data.common.datacolumnmapping (
"
Phone
"
,
"
Phone
"
),
New
System.data.common.datacolumnmapping (
"
Fax
"
,
"
Fax
"
)})});
THIS
. SqldataAdapter1.UpdateCommand
=
THIS
. SQLUPDATECOMMAND1;
//
//
SqlDeleteCommand1
//
THIS
. SqlDeleteCommand1.commandtext
=
@ "
DELETE FROM Customers WHERE (CustomerID = @Original_CustomerID) AND (Address = @Original_Address OR @Original_Address IS NULL AND Address IS NULL) AND (City = @Original_City OR @Original_City IS NULL AND City IS NULL) AND (CompanyName = @Original_CompanyName) AND (ContactName = @Original_ContactName OR @Original_ContactName IS NULL AND ContactName IS NULL) AND (ContactTitle = @Original_ContactTitle OR @Original_ContactTitle IS NULL AND ContactTitle IS NULL) AND (Country = @Original_Country OR @Original_Country IS NULL AND Country IS NULL) AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND (Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL) AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL AND PostalCode IS NULL) AND (Region = @ Original_region or @ORIGINAL_REGION IS NULL AND Region is NULL)
"
;
THIS
. SqlDeleteCommand1.connection
=
THIS
. SqlConnection1;
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_CUSTOMERID
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
5
System.Data.ParameterDirection.Input,
False
((System.byte) (0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Customerid
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_ADDRESS
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
60
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Address
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_CITY
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
CITY
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_COMPANYNAME
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
40
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
CompanyName
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_ContactName
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
ContactName
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_ContactTitle
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
ContactTitle "
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_COUNTRY
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
COUNTRY
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_FAX
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Fax
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_PHONE
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Phone
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_POSTALCODE
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
10
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Postalcode
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlDeleteCommand1.Parameters.Add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_REGION
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Region
"
System.Data.DataRowVersion.original,
NULL
));
//
//
SqlConnection1
//
THIS
. SqlConnection1.connectionstring
=
"
WorkStation ID = / "fancy-family /"; packet size = 4096; user ID = sa; data source = / "fancy-fami
"
"
LY / "; persist security info = false; initial catalog = northwind
"
;
//
//
SqlinsertCommand1
//
THIS
.sqlinsertcommand1.commandtext
=
@ "
INSERT INTO Customers (CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) VALUES (@CustomerID, @CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region, @ PostalCode, @Country, @Phone, @Fax); SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID = @CustomerID)
"
;
THIS
. SqlinsertCommand1.connection
=
THIS
. SqlConnection1;
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Customerid
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
5
,
"
Customerid
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Companyname
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
40
,
"
CompanyName
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ContactName
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
,
"
ContactName
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ContactTitle
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
,
"
ContactTitle
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter ("
@Address
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
60
,
"
Address
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@CITY
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
,
"
CITY
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Region
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
,
"
Region
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Postalcode
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
10
,
"
Postalcode
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Country
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
,
"
COUNTRY
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Phone
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
,
"
Phone
"
));
THIS
. SqlinsertCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Fax
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
,
"
Fax
"
));
//
//
SqlselectCommand1
//
THIS
.sqlselectcommand1.commandtext
=
"
Select Customerid, CompanyName, ContactName, ContactTitle, Address, City, Region,
"
"
Postalcode, Country, Phone, Fax from Customers
"
;
THIS
. SqlselectCommand1.connection
=
THIS
. SqlConnection1;
//
//
SQLUPDATECOMMAND1
//
THIS
. SQLUPDATEXT1.COMMANDTEXT
=
@ "
UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName, ContactName = @ContactName, ContactTitle = @ContactTitle, Address = @Address, City = @City, Region = @Region, PostalCode = @PostalCode, Country = @Country, Phone = @Phone, Fax = @Fax WHERE (CustomerID = @Original_CustomerID) AND (Address = @Original_Address OR @Original_Address IS NULL AND Address IS NULL) AND (City = @Original_City OR @Original_City IS NULL AND City IS NULL) AND (CompanyName = @Original_CompanyName) AND (ContactName = @Original_ContactName OR @Original_ContactName IS NULL AND ContactName IS NULL) AND (ContactTitle = @Original_ContactTitle OR @Original_ContactTitle IS NULL AND ContactTitle IS NULL) AND (Country = @Original_Country OR @Original_Country IS NULL AND Country IS NULL ) AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND (Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL) AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL AND Po stalCode IS NULL) AND (Region = @Original_Region OR @Original_Region IS NULL AND Region IS NULL); SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID = @ Customerid) "
;
THIS
. SQLUPDATECOMMAND1.CONNECTION
=
THIS
. SqlConnection1;
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Customerid
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
5
,
"
Customerid
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Companyname
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
40
,
"
CompanyName
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ContactName
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
,
"
ContactName
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ContactTitle
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
,
"
ContactTitle
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Address
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
60
,
"
Address
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@CITY
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
,
"
CITY
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Region
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
,
"
Region
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Postalcode
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
10
,
"
Postalcode
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Country
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
,
"
COUNTRY
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Phone
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
,
"
Phone
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@Fax "
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
,
"
Fax
"
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_CUSTOMERID
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
5
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Customerid
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_ADDRESS
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
60
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Address
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_CITY
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
CITY
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_COMPANYNAME
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
40
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
CompanyName
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_ContactName
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
ContactName
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_ContactTitle
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
30
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
ContactTitle
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_COUNTRY
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
COUNTRY
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_FAX
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Fax
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_PHONE
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
twenty four
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Phone
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter
"
@ORIGINAL_POSTALCODE
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
10
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Postalcode
"
System.Data.DataRowVersion.original,
NULL
));
THIS
. SqlupdateCommand1.parameters.add (
New
System.data.sqlclient.sqlparameter ("
@ORIGINAL_REGION
"
SYSTEM.DATA.SQLDBTYPE.NVARCHAR,
15
System.Data.ParameterDirection.Input,
False
((System.byte) (SYSTEM.BYTE)
0
)), ((System.byte) ((SYSTEM.BYTE)
0
))
"
Region
"
System.Data.DataRowVersion.original,
NULL
));
//
//
DSCUSTOMERS1
//
THIS
.dscustomers1.datasetname
=
"
DSCustomers
"
;
THIS
.dscustomers1.locale
=
New
System.globalization.cultureInfo
"
EN-CN
"
);
//
//
DV
//
THIS
.dv.table
=
THIS
.dscustomers1.customers;
THIS
.Load
=
New
System.eventhandler
THIS
.Page_load);
(System.comPonentModel.isupportInitialize)
THIS
.dscustomers1)).
(System.comPonentModel.isupportInitialize)
THIS
.dv)). Endinit ();
}
#ndregion
Void
Binddata ()
{
SqlDataAdapter1.fill (dscustomers1);
//
DataView DV = New DataView (dscustomers1.customers);
SuperDataGrid1.m_dataview
=
DV;
SuperdataGrid1.datasource
=
DSCUSTOMERS1;
SuperdataGrid1.databind ();
SuperdataGrid1.setCheckboxClintscript ();
}
Private
Void
SuperDataGrid1_updateView
Object
Sender, System.EventArgs E)
{
Binddata ();
}
}
}
