<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SchoolConnectionString %>"
DeleteCommand="DELETE FROM [T_sanguoban] WHERE [id] = @id"
InsertCommand="INSERT INTO [T_sanguoban] ([Name], [Age], [Image], [Gender]) VALUES (@Name, @Age, @Image, @Gender)"
SelectCommand="SELECT * FROM [T_sanguoban]"
UpdateCommand="UPDATE [T_sanguoban] SET [Name] = @Name, [Age] = @Age, [Image] = @Image, [Gender] = @Gender WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Age" Type="Int32" />
<asp:Parameter Name="Image" Type="String" />
<asp:Parameter Name="Gender" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Age" Type="Int32" />
<asp:Parameter Name="Image" Type="String" />
<asp:Parameter Name="Gender" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1"
onrowcommand="GridView1_RowCommand" onrowdatabound="GridView1_RowDataBound1">
<Columns>
<asp:BoundField DataField="id" HeaderText="编号" InsertVisible="False"
ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="Name" HeaderText="姓名" SortExpression="Name" />
<asp:BoundField DataField="Age" HeaderText="年龄" SortExpression="Age" />
<asp:ImageField DataImageUrlField="Image" HeaderText="图片">
<ControlStyle Height="70px" Width="70px" />
</asp:ImageField>
<asp:BoundField DataField="Gender" HeaderText="性别" SortExpression="Gender" />
<asp:ButtonField CommandName="delete" Text="删除" />
<asp:ButtonField CommandName="edit" Text="编辑" />
<asp:ButtonField CommandName="update" Text="更新" />
<asp:ButtonField CommandName="chushihua" Text="初始化密码" />
</Columns>
</asp:GridView>
</div>
后台:
后台需要用gridview属性的一个方法 RowDataBound
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.DataRow) {
return;
}
string name = e.Row.Cells[1].Text;
LinkButton lbtn = (LinkButton)e.Row.Cells[5].Controls[0]; // 这就是找到这个单元格里第一个控件
if (lbtn != null)
{
lbtn.Attributes.Add("onclick", "return confirm('你确定要删除-"+name+"-么?');");
}
}