利用DataGrid编辑、修改、删除记录

  if exists (select * from dbo.sysobjects where
  id = object_id(N''[dbo].[People]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
  drop table [dbo].[People]
  GO
  
  
  CREATE TABLE [dbo].[People] (
  [pkID] [int] IDENTITY (1, 1) NOT NULL ,
  [FirstName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
  [LastName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL
  ) ON [PRIMARY]
  GO
  
  
  EditDataGridCS.ASPx
  
  
  <%@ Page Language="C#" debug="true"%>
  <%@ Import Namespace="System.Data"%>
  <%@ Import Namespace="System.Data.SqlClient" %>
  
  
  <script runat="server">
  
  
  //make first sql
  String sql = "";
  String strCnn = "Data Source=.;Initial Catalog=aa;User Id=sa;Password=;";
  //create a datasource function
  public ICollection CreateDataSource () {
  SqlConnection conn = new SqlConnection(strCnn);
  
  
  SqlDataAdapter db_sqladaptor = new SqlDataAdapter(sql,conn);
  
  
  DataSet ds = new DataSet();
  db_sqladaptor.Fill(ds,"MyDataResult");
  
  
  DataView myView = ds.Tables["MyDataResult"].DefaultView;
  return myView;
  }
  
  
  
  //do page load
  
  
  public void Page_Load(Object sender, EventArgs e) {
  strCnn = "Data Source=.;Initial Catalog=aa;User Id=sa;Password=;";
  
  
  if (!IsPostBack)
  {
  sql = "Select * FROM People";
  People.DataSource = CreateDataSource();
  People.DataBind();
  }
  
  
  }
  
  
  public void Page_Grid(Object sender, DataGridPageChangedEventArgs e)
  {
  sql = "Select * FROM People";
  // Set CurrentPageIndex to the page the user clicked.
  People.CurrentPageIndex = e.NewPageIndex;

[1] [2] [3] [4] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:捕捉DataGrid的双击事件(C#版本)

下一篇:ASP.NET中用AxWebBrowser中提交表单