linkbutton

DataList的用法

---------------

<一>数据库绑定：

();

SqlDataAdaptersda=newSqlDataAdapter();

Command=newSqlCommand("select*fromperson",con);

DataSetds=newDataSet();

(ds,"person");

yField="pid";

urce=["person"];

nd();

<二>Datalist属性生成器

编辑更新，删除，取消的CommandName分别是editupdatedeletecancel,这样在datalist

的事件中就可以直接响应这些事件，以便进行操作。

样式有列表如下：

OnEditCommand="DataList1_EditCommand"

OnCancelCommand="DataList1_CancelCommand"

OnUpdateCommand="DataList1_UpdateCommand">

查

看详细信息

OnClick="LinkButton2_Click">编辑

删

除<%#(em,"pname")%><%

#(em,"psex")%>

<%#(em,"pid","序列号：{0}")%>

<%#(em,"pname")%>

<%#(em,"psex")%>

CommandName="cancel">取消

CommandName="update">保存

(em,"pname")%>'>

Font-Overline="False"

Font-Strikeout="False"Font-Underline="False"ForeColor="Maroon"/>

Font-Strikeout="False"

Font-Underline="False"ForeColor="Green"/>

程序代码：

protectedvoidDataList1_ItemCommand(objectsource,DataListCommandEventArgse)

{

if(dName=="select")

{

edIndex=dex;//选择

nd();

}

}

protectedvoidDataList1_EditCommand(objectsource,DataListCommandEventArgse)

{

emIndex=dex;//编辑

nd();

}

protectedvoidDataList1_CancelCommand(objectsource,DataListCommandEventArgse)

{

emIndex=-1;//取消

nd();

}

protectedvoidDataList1_UpdateCommand(objectsource,DataListCommandEventArgse)//

更新

{

stringpid=ys[dex].ToString();

stringname=((TextBox)ntrol("TextBox1")).Text;

SqlConnectioncon=();

();

SqlCommandcmd=newSqlCommand("updatepersonsetpname='"+name+"'where

pid='"+pid+"'",con);

eNonQuery();

emIndex=-1;

nd();

(pid+name);

}

}