程序博客网 > tomcat1和apache整合

利用datagrid编辑

来源：互联网 发布：tomcat1和apache整合 编辑：程序博客网 时间：2024/05/17 23:34

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;


// Rebind the data.
People.DataSource = CreateDataSource();
People.DataBind();


}


public void People_Edit(Object sender, DataGridCommandEventArgs e)
{
sql = "Select * FROM People";


People.EditItemIndex = e.Item.ItemIndex;
People.DataSource = CreateDataSource();
People.DataBind();


}


public void People_Cancel(Object sender, DataGridCommandEventArgs e)
{
sql = "Select * FROM People";
People.EditItemIndex = -1;
People.DataSource = CreateDataSource();
People.DataBind();


}


public void People_Update(Object sender, DataGridCommandEventArgs e)
{
string FirstName = ((TextBox)e.Item.Cells[1].Controls[1]).Text;
string LastName = ((TextBox)e.Item.Cells[2].Controls[1]).Text;


SqlConnection connUpdate = new SqlConnection(strCnn);
connUpdate.Open();
String sql_edit = "UPDATE People " +
"SET FirstName = ''" + FirstName.Replace("''","''''")+ "''," +
"LastName = ''" + LastName.Replace("''","''''")+ "''" +
" WHERE pkID = " + e.Item.Cells[0].Text;


SqlCommand sqlCommandUpdate = new SqlCommand(sql_edit,connUpdate);
sqlCommandUpdate.ExecuteNonQuery();
connUpdate.Close();


sql = "Select * FROM People";
People.EditItemIndex = -1;
People.DataSource = CreateDataSource();
People.DataBind();


}


public void People_Delete(Object sender, DataGridCommandEventArgs e) {


SqlConnection connDel = new SqlConnection(strCnn);
connDel.Open();
String sql_Del = "DELETE FROM People " +
" WHERE pkID = " + e.Item.Cells[0].Text;


SqlCommand sqlCommandDel = new SqlCommand(sql_Del,connDel);
sqlCommandDel.ExecuteNonQuery();
connDel.Close();


sql = "Select * FROM People";
People.EditItemIndex = -1;
People.DataSource = CreateDataSource();
People.DataBind();


}


</script>


<font face="arial" size="3">
<b>Edit People</b>
</font>
<br>


上一篇： 利用WebClient和WebRequest类获得网页源代码
下一篇： 如何在域控制器上安装asp.net?
<form runat="server">


<ASP:DataGrid id="People" runat="server"
BorderColor="green"
Width="640"
PageSize="5"
AllowPaging="true"
OnPageIndExchanged="Page_Grid"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
ShowHeader="true"
Visible="true"


OnEditCommand="People_Edit"
OnCancelCommand="People_Cancel"
OnUpdateCommand="People_Update"
OnDeleteCommand="People_Delete">


<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>


<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>


<EditItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="7"
Font-Bold="False" HorizontalAlign="Center"/>


<PagerStyle Mode="NumericPages" Font-Size="8"/>


<Columns>


<asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="pkID"/>


<asp:TemplateColumn>


<HeaderTemplate>
<b> First Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Text=''<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>

 

<EditItemTemplate>
<asp:TextBox id="FirstName" Text=''
<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:TemplateColumn>


<HeaderTemplate>
<b> Last Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Width="200"
Text=''<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>


<EditItemTemplate>
<asp:TextBox id="LastName" Text=''<br>
<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:EditCommandColumn
ButtonType="LinkButton"
CancelText="Cancel"
EditText="Edit"
UpdateText="Update" />


<asp:ButtonColumn Text= "Delete" CommandName="Delete"></asp:ButtonColumn>


</Columns>


</asp:DataGrid>


</form>

 


上一篇： 捕捉DataGrid的双击事件(C#版本)
下一篇： asp.net中显示DataGrid控件列序号的几种方法

<form runat="server">


<ASP:DataGrid id="People" runat="server"
BorderColor="green"
Width="640"
PageSize="5"
AllowPaging="true"
OnPageIndExchanged="Page_Grid"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
ShowHeader="true"
Visible="true"


OnEditCommand="People_Edit"
OnCancelCommand="People_Cancel"
OnUpdateCommand="People_Update"
OnDeleteCommand="People_Delete">


<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>


<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>


<EditItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="7"
Font-Bold="False" HorizontalAlign="Center"/>


<PagerStyle Mode="NumericPages" Font-Size="8"/>


<Columns>


<asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="pkID"/>


<asp:TemplateColumn>


<HeaderTemplate>
<b> First Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Text=''<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>

 

<EditItemTemplate>
<asp:TextBox id="FirstName" Text=''
<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:TemplateColumn>


<HeaderTemplate>
<b> Last Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Width="200"
Text=''<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>


<EditItemTemplate>
<asp:TextBox id="LastName" Text=''<br>
<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:EditCommandColumn
ButtonType="LinkButton"
CancelText="Cancel"
EditText="Edit"
UpdateText="Update" />


<asp:ButtonColumn Text= "Delete" CommandName="Delete"></asp:ButtonColumn>


</Columns>


</asp:DataGrid>


</form>

 


上一篇： 捕捉DataGrid的双击事件(C#版本)
下一篇： asp.net中显示DataGrid控件列序号的几种方法

<form runat="server">


<ASP:DataGrid id="People" runat="server"
BorderColor="green"
Width="640"
PageSize="5"
AllowPaging="true"
OnPageIndExchanged="Page_Grid"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
ShowHeader="true"
Visible="true"


OnEditCommand="People_Edit"
OnCancelCommand="People_Cancel"
OnUpdateCommand="People_Update"
OnDeleteCommand="People_Delete">


<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>


<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>


<EditItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="7"
Font-Bold="False" HorizontalAlign="Center"/>


<PagerStyle Mode="NumericPages" Font-Size="8"/>


<Columns>


<asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="pkID"/>


<asp:TemplateColumn>


<HeaderTemplate>
<b> First Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Text=''<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>

 

<EditItemTemplate>
<asp:TextBox id="FirstName" Text=''
<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:TemplateColumn>


<HeaderTemplate>
<b> Last Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Width="200"
Text=''<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>


<EditItemTemplate>
<asp:TextBox id="LastName" Text=''<br>
<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:EditCommandColumn
ButtonType="LinkButton"
CancelText="Cancel"
EditText="Edit"
UpdateText="Update" />


<asp:ButtonColumn Text= "Delete" CommandName="Delete"></asp:ButtonColumn>


</Columns>


</asp:DataGrid>


</form>

 


上一篇： 捕捉DataGrid的双击事件(C#版本)
下一篇： asp.net中显示DataGrid控件列序号的几种方法

<form runat="server">


<ASP:DataGrid id="People" runat="server"
BorderColor="green"
Width="640"
PageSize="5"
AllowPaging="true"
OnPageIndExchanged="Page_Grid"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
ShowHeader="true"
Visible="true"


OnEditCommand="People_Edit"
OnCancelCommand="People_Cancel"
OnUpdateCommand="People_Update"
OnDeleteCommand="People_Delete">


<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>


<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>


<EditItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="7"
Font-Bold="False" HorizontalAlign="Center"/>


<PagerStyle Mode="NumericPages" Font-Size="8"/>


<Columns>


<asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="pkID"/>


<asp:TemplateColumn>


<HeaderTemplate>
<b> First Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Text=''<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>

 

<EditItemTemplate>
<asp:TextBox id="FirstName" Text=''
<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:TemplateColumn>


<HeaderTemplate>
<b> Last Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Width="200"
Text=''<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>


<EditItemTemplate>
<asp:TextBox id="LastName" Text=''<br>
<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:EditCommandColumn
ButtonType="LinkButton"
CancelText="Cancel"
EditText="Edit"
UpdateText="Update" />


<asp:ButtonColumn Text= "Delete" CommandName="Delete"></asp:ButtonColumn>


</Columns>


</asp:DataGrid>


</form>

 


上一篇： 捕捉DataGrid的双击事件(C#版本)
下一篇： asp.net中显示DataGrid控件列序号的几种方法

<form runat="server">


<ASP:DataGrid id="People" runat="server"
BorderColor="green"
Width="640"
PageSize="5"
AllowPaging="true"
OnPageIndExchanged="Page_Grid"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
ShowHeader="true"
Visible="true"


OnEditCommand="People_Edit"
OnCancelCommand="People_Cancel"
OnUpdateCommand="People_Update"
OnDeleteCommand="People_Delete">


<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>


<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>


<EditItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="7"
Font-Bold="False" HorizontalAlign="Center"/>


<PagerStyle Mode="NumericPages" Font-Size="8"/>


<Columns>


<asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="pkID"/>


<asp:TemplateColumn>


<HeaderTemplate>
<b> First Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Text=''<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>

 

<EditItemTemplate>
<asp:TextBox id="FirstName" Text=''
<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:TemplateColumn>


<HeaderTemplate>
<b> Last Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Width="200"
Text=''<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>


<EditItemTemplate>
<asp:TextBox id="LastName" Text=''<br>
<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:EditCommandColumn
ButtonType="LinkButton"
CancelText="Cancel"
EditText="Edit"
UpdateText="Update" />


<asp:ButtonColumn Text= "Delete" CommandName="Delete"></asp:ButtonColumn>


</Columns>


</asp:DataGrid>


</form>

 


上一篇： 捕捉DataGrid的双击事件(C#版本)
下一篇： asp.net中显示DataGrid控件列序号的几种方法

<form runat="server">


<ASP:DataGrid id="People" runat="server"
BorderColor="green"
Width="640"
PageSize="5"
AllowPaging="true"
OnPageIndExchanged="Page_Grid"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
ShowHeader="true"
Visible="true"


OnEditCommand="People_Edit"
OnCancelCommand="People_Cancel"
OnUpdateCommand="People_Update"
OnDeleteCommand="People_Delete">


<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>


<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>


<EditItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="7"
Font-Bold="False" HorizontalAlign="Center"/>


<PagerStyle Mode="NumericPages" Font-Size="8"/>


<Columns>


<asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="pkID"/>


<asp:TemplateColumn>


<HeaderTemplate>
<b> First Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Text=''<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>

 

<EditItemTemplate>
<asp:TextBox id="FirstName" Text=''
<%# DataBinder.Eval(Container.DataItem, "FirstName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:TemplateColumn>


<HeaderTemplate>
<b> Last Name </b>
</HeaderTemplate>


<ItemTemplate>
<asp:Label
Width="200"
Text=''<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server"/>
</ItemTemplate>


<EditItemTemplate>
<asp:TextBox id="LastName" Text=''<br>
<%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>''
runat="server" Width="100%"/>
</EditItemTemplate>


</asp:TemplateColumn>


<asp:EditCommandColumn
ButtonType="LinkButton"
CancelText="Cancel"
EditText="Edit"
UpdateText="Update" />


<asp:ButtonColumn Text= "Delete" CommandName="Delete"></asp:ButtonColumn>


</Columns>


</asp:DataGrid>


</form>

 


上一篇： 捕捉DataGrid的双击事件(C#版本)
下一篇： asp.net中显示DataGrid控件列序号的几种方法

 

 

tomcat1和apache整合 tomcat1和apache整合
原创粉丝点击
热门IT博客
mac 沙盒mac 沙盒
淘宝开放平台开发实例淘宝开放平台开发实例
做数据分析工作怎么样
软件开发技术总结
c语言break用法if
qq代理服务器ip和端口
祖冲之序列密码算法
linux 循环打开文件
淘宝客加入条件
南京 中兴软创 大数据
中国博士与英国知乎
德文布克数据
商业分析师 知乎
按键精灵输入文字源码
小榕软件实验室
mac照片图库导出
商标查询软件
女生电脑包 知乎
淘宝怎么打造单品爆款
js 字符串换行符
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 妄想性仮想人格障害 仰 仰焊 仰止 后仰 唐言蹊陆仰止 陆仰止唐言蹊 唐言蹊陆仰止免费全文 高山仰止 高山仰止景行行止 痛仰黄三 仰人鼻息 唐言溪陆仰止章节目录 唐言蹊陆仰止免费阅读 高山仰 陆仰止唐言蹊免费阅读 仰阿莎 高山仰止意思 痛仰txt 仰视读数偏大还是偏小 唐言蹊陆仰止目录 战术后仰 仰怎么读 后仰跳投 高山仰止什么意思 高山仰止景行行止意思 陆止仰唐言蹊 仰之弥高 痛仰番外婚后 崂山仰口景区 仰月唇 仰不愧天 仰郁症 仰拼音 陆仰止 灵感仰 唐言溪陆仰止全文免费阅读 高山仰止景行行止什么意思 仰光 缅甸仰光 仰光大金塔

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里