代码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 DataGridDemoCS{ /// /// Demo1 的摘要说明。 /// public class DemoFinal : System.Web.UI.Page { protected System.Data.SqlClient.SqlConnection sqlConnection1; protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; //注意：dataset在编辑状态中将清空，所以可以将dataset申明为static，这样就可以保持dataset状态； //静态成员变量不可以用this来调用 protected DataGridDemoCS.dsCustomers dsCustomers1; protected DataGridDemoCS.dsCustomers.CustomersDataTable dsCustomerTable; protected DataGridDemoCS.dsCustomers.CustomersRow dsCustomerRow; 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 sqlConnection2; protected System.Web.UI.WebControls.Button Button1; protected System.Web.UI.WebControls.Button BtnInsertOneRow; protected System.Web.UI.WebControls.Button BtnDeleteGrouply; protected System.Web.UI.WebControls.Panel PnlPage; protected System.Data.DataView dv; protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2; protected System.Data.SqlClient.SqlConnection sqlConnection3; protected System.Web.UI.WebControls.DataGrid DataGrid1; public int ExpandedItem=7; public Unit HostColumnWidth; private DataGrid detailsGrid; const string ExpandText = '+'; protected System.Data.SqlClient.SqlCommand sqlSelectCommand2; protected System.Data.SqlClient.SqlCommand sqlInsertCommand2; protected System.Data.SqlClient.SqlCommand sqlUpdateCommand2; protected System.Data.SqlClient.SqlCommand sqlDeleteCommand2; protected System.Web.UI.WebControls.Button Button2; const string CollapseText = '-'; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (!Page.IsPostBack) { ExpandedItem = -1; testWorkFlow=''; ViewState['Sort']='CustomerID'; ViewState['orderby']='asc'; bindDate(); BtnDeleteGrouply.Attributes.Add('OnClick','javascript:DeleteGrouply();'); HostColumnWidth = Unit.Pixel(150); } } void bindDate() { testWorkFlow=''; sqlDataAdapter1.Fill(dsCustomers1,'Customers'); if ((string)(ViewState['Sort'])!='') dv.Sort=(string)ViewState['Sort']+' '+ViewState['orderby']; else dsCustomers1.Customers.DefaultView.Sort='CustomerID'; if ((string)(ViewState['alpha'])!='') { dv.RowFilter='CustomerID LIKE ''+(string)(ViewState['alpha'])+'%''; } DataGrid1.DataBind(); m_CreatePageTimes=0; } #region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// private void InitializeComponent() { this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection2 = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsCustomers1 = new DataGridDemoCS.dsCustomers(); this.dv = new System.Data.DataView(); this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection3 = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand(); ((System.ComponentModel.ISupportInitialize)(this.dsCustomers1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dv)).BeginInit(); this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated); this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand); this.DataGrid1.Init += new System.EventHandler(this.DataGrid1_Init); this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged); this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand); this.DataGrid1.PreRender += new System.EventHandler(this.DataGrid1_PreRender); this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand); this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand); this.DataGrid1.DataBinding += new System.EventHandler(this.DataGrid1_DataBinding); this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand); this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand); this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound); this.Button1.Click += new System.EventHandler(this.Button1_Click); this.BtnInsertOneRow.Click += new System.EventHandler(this.BtnInsertOneRow_Click); this.BtnDeleteGrouply.Click += new System.EventHandler(this.BtnDeleteGrouply_Click); // // 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'; // // 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.sqlConnection2; 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)(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)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((System.Byte)(0)), 'Country', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_Fax', System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'Fax', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_Phone', System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((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)(0)), ((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)(0)), ((System.Byte)(0)), 'Region', System.Data.DataRowVersion.Original, null)); // // sqlConnection2 // this.sqlConnection2.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.sqlConnection2; 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, 24, 'Phone')); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Fax', System.Data.SqlDbType.NVarChar, 24, 'Fax')); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = 'SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region,' + ' PostalCode, Country, Phone, Fax FROM Customers'; this.sqlSelectCommand1.Connection = this.sqlConnection2; // // sqlUpdateCommand1 // this.sqlUpdateCommand1.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 PostalCode 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.sqlConnection2; 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, 24, 'Phone')); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Fax', System.Data.SqlDbType.NVarChar, 24, 'Fax')); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_CustomerID', System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((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)(0)), ((System.Byte)(0)), 'Country', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_Fax', System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'Fax', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_Phone', System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((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)(0)), ((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)(0)), ((System.Byte)(0)), 'Region', System.Data.DataRowVersion.Original, null)); // // dsCustomers1 // this.dsCustomers1.DataSetName = 'dsCustomers'; this.dsCustomers1.Locale = new System.Globalization.CultureInfo('zh-CN'); // // dv // this.dv.Table = this.dsCustomers1.Customers; // // sqlDataAdapter2 // this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand2; this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2; this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2; this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping('Table', 'Orders', new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping('OrderID', 'OrderID'), new System.Data.Common.DataColumnMapping('OrderDate', 'OrderDate'), new System.Data.Common.DataColumnMapping('ShipName', 'ShipName'), new System.Data.Common.DataColumnMapping('ShipAddress', 'ShipAddress'), new System.Data.Common.DataColumnMapping('ShipCity', 'ShipCity'), new System.Data.Common.DataColumnMapping('CustomerID', 'CustomerID')})}); this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2; // // sqlDeleteCommand2 // this.sqlDeleteCommand2.CommandText = @'DELETE FROM Orders WHERE (OrderID = @Original_OrderID) AND (CustomerID = @Original_CustomerID OR @Original_CustomerID IS NULL AND CustomerID IS NULL) AND (OrderDate = @Original_OrderDate OR @Original_OrderDate IS NULL AND OrderDate IS NULL) AND (ShipAddress = @Original_ShipAddress OR @Original_ShipAddress IS NULL AND ShipAddress IS NULL) AND (ShipCity = @Original_ShipCity OR @Original_ShipCity IS NULL AND ShipCity IS NULL) AND (ShipName = @Original_ShipName OR @Original_ShipName IS NULL AND ShipName IS NULL)'; this.sqlDeleteCommand2.Connection = this.sqlConnection3; this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_OrderID', System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'OrderID', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_CustomerID', System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'CustomerID', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_OrderDate', System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'OrderDate', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_ShipAddress', System.Data.SqlDbType.NVarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'ShipAddress', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_ShipCity', System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'ShipCity', System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_ShipName', System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'ShipName', System.Data.DataRowVersion.Original, null)); // // sqlConnection3 // this.sqlConnection3.ConnectionString = 'workstation id=\'FANCY-FAMILY\';packet size=4096;user id=sa;data source=\'FANCY-FAMI' + 'LY\';persist security info=False;initial catalog=Northwind'; // // sqlInsertCommand2 // this.sqlInsertCommand2.CommandText = @'INSERT INTO Orders(OrderDate, ShipName, ShipAddress, ShipCity, CustomerID) VALUES (@OrderDate, @ShipName, @ShipAddress, @ShipCity, @CustomerID); SELECT OrderID, OrderDate, ShipName, ShipAddress, ShipCity, CustomerID FROM Orders WHERE (OrderID = @@IDENTITY)'; this.sqlInsertCommand2.Connection = this.sqlConnection3; this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@OrderDate', System.Data.SqlDbType.DateTime, 8, 'OrderDate')); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@ShipName', System.Data.SqlDbType.NVarChar, 40, 'ShipName')); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@ShipAddress', System.Data.SqlDbType.NVarChar, 60, 'ShipAddress')); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@ShipCity', System.Data.SqlDbType.NVarChar, 15, 'ShipCity')); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@CustomerID', System.Data.SqlDbType.NVarChar, 5, 'CustomerID')); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = 'SELECT OrderID, OrderDate, ShipName, ShipAddress, ShipCity, CustomerID FROM Order' + 's'; this.sqlSelectCommand2.Connection = this.sqlConnection3; // // sqlUpdateCommand2 // this.sqlUpdateCommand2.CommandText = @'UPDATE Orders SET OrderDate = @OrderDate, ShipName = @ShipName, ShipAddress = @ShipAddress, ShipCity = @ShipCity, CustomerID = @CustomerID WHERE (OrderID = @Original_OrderID) AND (CustomerID = @Original_CustomerID OR @Original_CustomerID IS NULL AND CustomerID IS NULL) AND (OrderDate = @Original_OrderDate OR @Original_OrderDate IS NULL AND OrderDate IS NULL) AND (ShipAddress = @Original_ShipAddress OR @Original_ShipAddress IS NULL AND ShipAddress IS NULL) AND (ShipCity = @Original_ShipCity OR @Original_ShipCity IS NULL AND ShipCity IS NULL) AND (ShipName = @Original_ShipName OR @Original_ShipName IS NULL AND ShipName IS NULL); SELECT OrderID, OrderDate, ShipName, ShipAddress, ShipCity, CustomerID FROM Orders WHERE (OrderID = @OrderID)'; this.sqlUpdateCommand2.Connection = this.sqlConnection3; this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@OrderDate', System.Data.SqlDbType.DateTime, 8, 'OrderDate')); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@ShipName', System.Data.SqlDbType.NVarChar, 40, 'ShipName')); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@ShipAddress', System.Data.SqlDbType.NVarChar, 60, 'ShipAddress')); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@ShipCity', System.Data.SqlDbType.NVarChar, 15, 'ShipCity')); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@CustomerID', System.Data.SqlDbType.NVarChar, 5, 'CustomerID')); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_OrderID', System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'OrderID', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_CustomerID', System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'CustomerID', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_OrderDate', System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'OrderDate', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_ShipAddress', System.Data.SqlDbType.NVarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'ShipAddress', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_ShipCity', System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'ShipCity', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@Original_ShipName', System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), 'ShipName', System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter('@OrderID', System.Data.SqlDbType.Int, 4, 'OrderID')); this.Button2.Click += new System.EventHandler(this.Button2_Click); this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dsCustomers1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dv)).EndInit(); } #endregion private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { testWorkFlow=''; DataGrid1.EditItemIndex=e.Item.ItemIndex; bindDate(); } private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex=-1; bindDate(); } private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { //注意：e.Item.Cells[0].Text ;是引用不到任何值的，即每次的状态改变都将引发该状态下的数据，不可以跨越状态的获取 //现在是处于编辑状态，所以只能通过类型转换来获取textbox里的值 //((TextBox)e.Item.Cells[1].Controls[0]).Text //CustomerID设置为只读，在编辑状态下，仍然处于label状态,只能用e.Item.Cells[0].Text;来获取单元格中的值 string strCustomerID=e.Item.Cells[1].Text; string strCompanyName=((TextBox)e.Item.Cells[2].Controls[0]).Text ; string strContactName=((TextBox)e.Item.Cells[3].Controls[0]).Text ; string strCity=((TextBox)e.Item.Cells[4].Controls[0]).Text ; //在编辑状态调用模版列有两种方式： //1）((TextBox)e.Item.Cells[4].Controls[1]).Text； 注意必须是Control[1]不是[0] control[0]是一个{System.Web.UI.LiteralControl}， Text: '\r\n\t\t\t\t\t\t\t\t' //2）((TextBox)e.Item.FindControl['控件id']).Text; FindControl可以查找该单元内的任何一个控件id string strCoutry=((TextBox)e.Item.Cells[5].Controls[1]).Text ; string strPhone=((TextBox)e.Item.Cells[6].Controls[0]).Text ; sqlDataAdapter1.Fill(dsCustomers1,'Customers'); dsCustomerRow=dsCustomers1.Customers.FindByCustomerID(strCustomerID); dsCustomerRow.CompanyName=strCompanyName; dsCustomerRow.ContactName=strContactName; dsCustomerRow.City=strCity; dsCustomerRow.Country=strCoutry; dsCustomerRow.Phone=strPhone; sqlDataAdapter1.Update(dsCustomers1,'Customers'); dsCustomers1.AcceptChanges(); DataGrid1.EditItemIndex=-1; bindDate(); //e.Item.ItemIndex } private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string CustomersID=e.Item.Cells[0].Text; } private void DataGrid1_DataBinding(object sender, System.EventArgs e) { Response.Write(e.ToString()); } private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if (e.CommandName=='alpha') { ViewState['alpha']=e.CommandArgument; m_CreatePageTimes=0; DataGrid1.CurrentPageIndex=0; bindDate(); } if (e.CommandName=='Cancle') { DataGrid1.ShowFooter=false; } if (e.CommandName=='Insert') { sqlDataAdapter1.Fill(dsCustomers1); dsCustomerRow=(dsCustomers.CustomersRow)dsCustomers1.Customers.NewRow(); dsCustomerRow.CustomerID=((TextBox)e.Item.Cells[1].Controls[0]).Text ; dsCustomerRow.CompanyName=((TextBox)e.Item.Cells[2].Controls[0]).Text; dsCustomerRow.ContactName =((TextBox)e.Item.Cells[3].Controls[0]).Text; dsCustomerRow.City=((TextBox)e.Item.Cells[4].Controls[0]).Text; dsCustomerRow.Country=((TextBox)e.Item.Cells[5].Controls[0]).Text; dsCustomerRow.Phone=((TextBox)e.Item.Cells[6].Controls[0]).Text; dsCustomers1.Customers.AddCustomersRow(dsCustomerRow); sqlDataAdapter1.Update(dsCustomers1,'Customers'); dsCustomers1.AcceptChanges(); DataBind(); DataGrid1.ShowFooter=false; } if (e.CommandName=='Expand') { ExpandItem(e.Item); } } private void ExpandItem(DataGridItem item) { if (item.ItemIndex == (ExpandedItem % DataGrid1.PageSize)) SetExpandedItem(item, false); else SetExpandedItem(item, true); } // Adjust the index of the expanded item private void SetExpandedItem(DataGridItem item, bool expand) { if (expand) ExpandedItem = (DataGrid1.PageSize*DataGrid1.CurrentPageIndex+item.ItemIndex); else ExpandedItem = -1; } private void DataGrid1_PreRender(object sender, System.EventArgs e) { } public string testWorkFlow=''; private int m_CreatePageTimes = 0; private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { testWorkFlow+=e.Item.ItemType.ToString()+'->'; if (e.Item.ItemType==ListItemType.Header) { //排序 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.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='插入'; lb.CommandName='Insert'; c.Controls.Add(lb); } else if (i==e.Item.Cells.Count-1) { lb=new LinkButton(); lb.Text='取消'; 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<65+25;i++) { l=new LinkButton(); LiteralControl lc=new LiteralControl(); lc.Text=' '; l.CommandName='alpha'; l.CommandArgument=Convert.ToChar(i).ToString(); l.Text=Convert.ToChar(i).ToString(); e.Item.Cells[0].Controls.Add(l); e.Item.Cells[0].Controls.Add(lc); } l=new LinkButton(); l.Text='All'; l.CommandName='alpha'; l.CommandArgument=''; e.Item.Cells[0].Controls.Add(l); m_CreatePageTimes ++; } else if(m_CreatePageTimes==1) { foreach(Control ct in e.Item.Cells[0].Controls) { switch(ct.GetType().ToString()) { case 'System.Web.UI.WebControls.Label': { Label l=(Label)ct; l.Text='当前页['+l.Text+']';
break; } case 'System.Web.UI.LiteralControl': { LiteralControl lc=(LiteralControl)ct; lc.Text='|';
break; } case 'System.Web.UI.WebControls.DataGridLinkButton': { LinkButton lb=(LinkButton)ct; if (e.Item.Cells[0].Controls.IndexOf(ct)==0 && lb.Text=='...') lb.Text='[向前翻页]'; else if(e.Item.Cells[0].Controls.IndexOf(ct)==e.Item.Cells[0].Controls.Count-1 && lb.Text=='...') lb.Text='[向后翻页]'; else lb.Text='第['+lb.Text+']页';
break; } } } } } } private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) { DataGrid1.CurrentPageIndex=e.NewPageIndex; m_CreatePageTimes=0; bindDate(); } private void Button1_Click(object sender, System.EventArgs e) { Response.Write(testWorkFlow+'End'); } private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { ViewState['Sort']=e.SortExpression; if ((string)ViewState['orderby']=='asc') ViewState['orderby']='desc'; else ViewState['orderby']='asc'; m_CreatePageTimes=0; bindDate(); } private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { } public void Check_Changed(object sender,System.EventArgs e) { CheckBox chk=(CheckBox)sender; DataGridItem dgi; dgi=(DataGridItem)chk.Parent.Parent; if (chk.Checked) { dgi.BackColor = DataGrid1.SelectedItemStyle.BackColor; dgi.ForeColor = DataGrid1.SelectedItemStyle.ForeColor; } else { dgi.BackColor = DataGrid1.ItemStyle.BackColor; dgi.ForeColor = DataGrid1.ItemStyle.ForeColor; } } private void BtnInsertOneRow_Click(object sender, System.EventArgs e) { DataGrid1.ShowFooter=true; } private void BtnDeleteGrouply_Click(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dsCustomers1,'Customers'); foreach (DataGridItem dgi in DataGrid1.Items) { CheckBox chk=(CheckBox)dgi.Cells[0].Controls[1]; if (chk.Checked==true) { string CustomerID=dgi.Cells[1].Text; dsCustomerRow=dsCustomers1.Customers.FindByCustomerID(CustomerID); dsCustomerRow.Delete(); } } sqlDataAdapter1.Update(dsCustomers1); dsCustomers1.AcceptChanges(); } private void Button2_Click(object sender, System.EventArgs e) { string CustomerID=''; foreach (DataGridItem dgi in DataGrid1.Items) { if (((CheckBox)dgi.Cells[0].FindControl('chkOne')).Checked==true) CustomerID+=dgi.Cells[1].Text; } Response.Write(CustomerID); } }}
