评论会员:游客 时间:2012/02/06
SanjeevSingh:您好,检查内容的行数(之前绑定源的DataTable/DataRow中/DataReader的不管你使用的)。如果计数大于零,则只能绑定其他可以显示消息。感谢sanjeev
马亨德兰杀敌:编码:
使用系统;
使用System.Collections.Generic
使用System.Linq的;
使用的System.Web;
CSDN社区 -
使用System.Web.UI.WebControls;
使用System.Data.SqlClient的
使用System.Data;
公共部分类DeleteSample的System.Web.UI.Page
{
SqlConnection的CON =新的SqlConnection("数据源= MAJ-056 \ SQLEXPRESS的初始目录=采样;集成安全性= TRUE")
保护无效的Page_Load(对象发件人,EventArgs的五)
{
0; }
保护的无效LinkButton1_Click(对象发件人,EventArgs的五)
{
60; SqlCommand的CMD =新的SqlCommand()
&
#160;cmd.CommandType = CommandType.StoredProcedure;
; cmd.CommandText ="getexception_delete";
0; cmd.Connection = CON;
0; SqlParameter的参数=新的SqlParameter()
0; param.ParameterName ="@ ExceptionLogID"的
160; param.SqlDbType = SqlDbType.Int;
0; param.Direction = ParameterDirection.Input;
160; LinkButton的LNK =(LinkButton的)发件人;
param.Value = lnk.CommandArgument;
cmd.Parameters.Add(参数)
con.Open()
60;SqlDataReader的博士= cmd.ExecuteReader();
; 如果(dr.Read())
{
&
#160; CMD1 =新的SqlCommand的SqlCommand()
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.CommandText ="insert_DeleteTable的";
60; cmd1.Connection = CON;
&
#160; SqlParameter的PARAM1 =新的SqlParameter()
60; param1.ParameterName ="@ ExceptionLogID"的
param1.SqlDbType = SqlDbType.BigInt;
param1.Direction = ParameterDirection.Input;
160; param1.Value =博士["TicketId"]
cmd1.Parameters.Add(PARAM1)
con.Close()
con.Open()
160; cmd1.ExecuteNonQuery()
0; con.Close()
}
&
#160; }
保护无效中button1_Click(对象发件人,EventArgs的五)
{
SqlCommand的CMD =新的SqlCommand()
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText ="EXCEPTION_LOG_Select";
60; cmd.Connection = CON;
SqlParameter的参数=新的SqlParameter()
60;param.ParameterName ="@ ExceptionLogID"的
&
#160; param.SqlDbType = SqlDbType.Int;
60; param.Direction = ParameterDirection.Input;
&
#160; param.Value = TextBox1.Text;
; cmd.Parameters.Add(参数)
SqlDataAdapter的DA =新的SqlDataAdapter(CMD);
160; 的DataSet DS =新的DataSet();
da.Fill(DS)
如果(ds.Tables [0] Rows.Count> 0)
{
0; GridView1.DataSource = DS;
GridView1.DataBind()
}
其他
{
con.Open()
160; CMD1 =新的SqlCommand的SqlCommand()
0; cmd1.CommandType = CommandType.StoredProcedure;
cmd1.CommandText ="DELETE_TABLE_Select";
0; cmd1.Connection = CON;
160; SqlParameter的PARAM1 =新的SqlParameter()
0; param1.ParameterName ="@ ExceptionLogID"的
param1.SqlDbType = SqlDbType.Int;
param1.Direction = ParameterDirection.Input;
60; param1.Value = TextBox1.Text;
; cmd1.Parameters.Add(PARAM1)
60; SqlDataReader的博士= cmd1.ExecuteReader()
如果(dr.Read())
{
160; ("没有会话")
160; }
其他
{
60; 回复于("无效");
}
con.Close()
}
60; }
}
设计:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DeleteSample.aspx.cs" Inherits="DeleteSample" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="style1">
<tr>
<td>
Enter Ticket Id</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" CommandArgument='<%# Eval("ID") %>' runat="server" onclick="LinkButton1_Click">Delete</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
SQL:
创建:PROC getexception_delete
@ ExceptionLogID INT 选择从EXCEPTION_LOG的* ID = @ ExceptionLogID
删除EXCEPTION_LOG ID = @ ExceptionLogID
创建:PROC insert_DeleteTable
@ ExceptionLogID BIGINT 插入的delete_table值(ExceptionLogID)
创建:PROC EXCEPTION_LOG_Select
@ ExceptionLogID BIGINT 选择*从EXCEPTION_LOG TicketId = @ ExceptionLogID
创建:PROC DELETE_TABLE_Select
@ ExceptionLogID BIGINT 选择从的delete_table *其中TicketId = @ ExceptionLogID
CREATE TABLE [dbo].[DELETE_TABLE](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TicketId] [bigint] NULL,
CONSTRAINT [PK_DELETE_TABLE] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO