- 1PS提示：因为图层已锁定，无法编辑图层的处理方法
- 2Adobe Illustrator CS5 序列号大全
- 3picacg苹果版怎么找不到|picacg ios版是不是下架了介绍
- 4ACDsee注册码免费分享（含ACDsee18、ACDsee10等版本）
- 5苹果iphone自动时间不准确的多种校正方法
- 6PDF浏览器能看3D文件吗？PDF浏览器看3D文件图文详细教程
- 7眼萌app怎么色弱测试 眼萌app色弱测试图文说明教程
- 8百度安全卫士好用么_百度安全卫士技巧说明
- 9Potato(马铃薯聊天)怎么注册不了|Potato不能注册处理方法介绍
- 10Potato(土豆聊天)怎么换头像|Potato app更改头像方法介绍
- 11ipad版office如何激活? office365激活的图文说明教程
- 12最新的Adobe Illustrator CS4序列号大全
[摘要]<%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.SQL" %> <html><script language="...
<%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.SQL" %>
<html>
<script language="VB" runat="server">
Dim MyConnection As SQLConnection
Sub Page_Load(Src As Object, E As EventArgs)
MyConnection = New SQLConnection("server=YOUR-SERVER;uid=joeuser;pwd=joeuser;database=pubs")
If Not (IsPostBack)
BindGrid()
End If
End Sub
Sub MyDataGrid_Delete(Sender As Object, E As DataGridCommandEventArgs)
Dim MyCommand As SQLCommand
Dim DeleteCmd As String = "DELETE from Authors where au_id = @Id"
MyCommand = New SQLCommand(DeleteCmd, MyConnection)
MyCommand.Parameters.Add(New SQLParameter("@Id", SQLDataType.VarChar, 11))
MyCommand.Parameters("@Id").Value = MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
MyCommand.ActiveConnection.Open()
Try
MyCommand.ExecuteNonQuery()
Message.InnerHtml = "<b>Record Deleted</b><br>" & DeleteCmd
Catch Exp As SQLException
Message.InnerHtml = "ERROR: Could not delete record"
Message.Style("color") = "red"
End Try
MyCommand.ActiveConnection.Close()
BindGrid()
End Sub
Sub BindGrid()
Dim DS As DataSet
Dim MyCommand As SQLDataSetCommand
MyCommand = New SQLDataSetCommand("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.FillDataSet(DS, "Authors")
MyDataGrid.DataSource=DS.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<body style="font: 10pt verdana">
<form runat="server">
<h3><font face="Verdana">Deleting a Row of Data</font></h3>
<span id="Message" MaintainState="false" style="font: arial 11pt;" runat="server"/><p>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="800"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
DataKeyField="au_id"
OnDeleteCommand="MyDataGrid_Delete"
>
<property name="Columns">
<asp:ButtonColumn Text="Delete Author" CommandName="Delete"/>
</property>
</ASP:DataGrid>
</form>
</body>
</html>
推荐资讯 总人气榜
最新教程 本月人气
- 1小恩爱聊天记录如何删除？聊天记录删除图文说明教程
- 2图吧导航离线破解版2014下载地址 图吧导航破解版2014下载
- 3图吧导航如何？好用吗？手机图吧导航技巧评测
- 4猎豹清理大师降温如何用？cpu降温技巧使用方法
- 5靠谱助手我的视频如何用？我的视频技巧使用图文说明教程
- 6圈圈助手如何用？圈圈助手使用图文说明教程
- 7圈圈助手ios源地址 圈圈助手ios软件源
- 8小恩爱如何叫对方起床？小恩爱叫对方起床图文说明教程
- 9itunes11.3.1官方版下载中文版：itunes 11.3.1下载
- 10打印机驱动如何安装？打印机驱动下载后安装图文说明教程
- 11京东全民种红包如何用？全民种红包使用方法
- 12京东全民种红包如何种？京东全民种红包图文说明教程
相关文章
