存储过程:
ALTER PROCEDURE [dbo].[CompDev_Select]
AS
BEGIN
SET NOCOUNT ON;
SELECT [WC].[CompID]
, [WC].[NewDevCount]
, [WC].[DevelopmentName]
, [WC].[City]
, [WC].[State]
, [WC].[ZipCodeofNewDev]
, [WC].[ProjectStatus]
, [WC].[ShoppingCenter]
, [WC].[ProjectStartDate]
, [WC].[ProjectDescription]
, [WC].[ProposedAnchorTenants]
, [WC].[GLA]
, [WC].[EstCompDate]
, [WC].[Developer]
, [WC].[BusinessUnit]
, [WC].[BU]
, [WC].[CenterName]
, [WC].[MSA]
, [WC].[BrixmorMSARank]
, [WC].[Count]
, [WC].[Region]
, [WC].[DistancefromNewDev]
FROM [dbo].[WestCompetition] AS WC
SET NOCOUNT OFF;
END
GO
ALTER PROCEDURE [dbo].[CompDev_Update]
( @CompID INT
, @NewDevCount NCHAR(10) = NULL
, @DevelopmentName NVARCHAR(255) = NULL
, @City NVARCHAR(255) = NULL
, @State NVARCHAR(255) = NULL
, @ZipCodeofNewDev NCHAR(10) = NULL
, @ProjectStatus NVARCHAR(255) = NULL
, @ShoppingCenter NVARCHAR(255) = NULL
, @ProjectStartDate FLOAT = NULL
, @ProjectDescription NVARCHAR(255) = NULL
, @ProposedAnchorTenants NVARCHAR(255) = NULL
, @GLA NCHAR(10) = NULL
, @EstCompDate FLOAT = NULL
, @Developer NVARCHAR(255) = NULL
, @BusinessUnit NCHAR(10) = NULL
, @BU NCHAR(10) = NULL
, @CenterName NVARCHAR(255) = NULL
, @MSA NVARCHAR(255) = NULL
, @BrixmorMSARank NCHAR(10) = NULL
, @Count NCHAR(10) = NULL
, @Region NVARCHAR(255) = NULL
, @DistancefromNewDev NCHAR(10) = NULL )
AS
BEGIN
SET NOCOUNT ON;
UPDATE WC
SET NewDevCount = @NewDevCount
, DevelopmentName = @DevelopmentName
, City = @City
, [State] = @State
, ZipCodeofNewDev = @ZipCodeofNewDev
, ProjectStatus = @ProjectStatus
, ShoppingCenter = @ShoppingCenter
, ProjectStartDate = @ProjectStartDate
, ProjectDescription = @ProjectDescription
, ProposedAnchorTenants = @ProposedAnchorTenants
, GLA = @GLA
, EstCompDate = @EstCompDate
, Developer = @Developer
, BusinessUnit = @BusinessUnit
, BU = @BU
, CenterName = @CenterName
, MSA = @MSA
, BrixmorMSARank = @BrixmorMSARank
, [Count] = @Count
, Region = @Region
, DistancefromNewDev = @DistancefromNewDev
FROM [dbo].[WestCompetition] AS WC
WHERE ( [WC].CompID = @CompID );
SET NOCOUNT OFF;
END
GO
ALTER PROCEDURE [dbo].[CompDev_Insert]
( @NewDevCount NCHAR(10) = NULL
, @DevelopmentName NVARCHAR(255) = NULL
, @City NVARCHAR(255) = NULL
, @State NVARCHAR(255) = NULL
, @ZipCodeofNewDev NCHAR(10) = NULL
, @ProjectStatus NVARCHAR(255) = NULL
, @ShoppingCenter NVARCHAR(255) = NULL
, @ProjectStartDate FLOAT = NULL
, @ProjectDescription NVARCHAR(255) = NULL
, @ProposedAnchorTenants NVARCHAR(255) = NULL
, @GLA NCHAR(10) = NULL
, @EstCompDate FLOAT = NULL
, @Developer NVARCHAR(255) = NULL
, @BusinessUnit NCHAR(10) = NULL
, @BU NCHAR(10) = NULL
, @CenterName NVARCHAR(255) = NULL
, @MSA NVARCHAR(255) = NULL
, @BrixmorMSARank NCHAR(10) = NULL
, @Count NCHAR(10) = NULL
, @Region NVARCHAR(255) = NULL
, @DistancefromNewDev NCHAR(10) = NULL )
AS
INSERT INTO [dbo].[WestCompetition]
( [NewDevCount]
, [DevelopmentName]
, [City]
, [State]
, [ZipCodeofNewDev]
, [ProjectStatus]
, [ShoppingCenter]
, [ProjectStartDate]
, [ProjectDescription]
, [ProposedAnchorTenants]
, [GLA]
, [EstCompDate]
, [Developer]
, [BusinessUnit]
, [BU]
, [CenterName]
, [MSA]
, [BrixmorMSARank]
, [Count]
, [Region]
, [DistancefromNewDev] )
VALUES ( @NewDevCount
, @DevelopmentName
, @City
, @State
, @ZipCodeofNewDev
, @ProjectStatus
, @ShoppingCenter
, @ProjectStartDate
, @ProjectDescription
, @ProposedAnchorTenants
, @GLA
, @EstCompDate
, @Developer
, @BusinessUnit
, @BU
, @CenterName
, @MSA
, @BrixmorMSARank
, @Count
, @Region
, @DistancefromNewDev );
GO
ALTER PROCEDURE [dbo].[CompDev_Delete] ( @CompID INT )
AS
BEGIN
SET NOCOUNT ON;
DELETE WC
FROM [dbo].[WestCompetition] AS WC
WHERE [WC].[CompID] = @CompID
SET NOCOUNT OFF;
END
GO
前端代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:ListView ID="ListView1" runat="server" DataKeyNames="CompID" DataSourceID="SqlDataSource1" InsertItemPosition="LastItem">
<ItemTemplate>
<tr style="background-color: rgba(246, 129, 33, 1); border: 1px solid rgba(153, 153, 153, 1);">
<td><asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" /></td>
<td><asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" /></td>
<td><asp:Label ID="CompIDLabel" runat="server" Text='<%# Eval("CompID") %>' /></td>
<td><asp:Label ID="NewDevCountLabel" runat="server" Text='<%# Eval("NewDevCount") %>' /></td>
<td><asp:Label ID="DevelopmentNameLabel" runat="server" Text='<%# Eval("DevelopmentName") %>' /></td>
<td><asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' /></td>
<td><asp:Label ID="StateLabel" runat="server" Text='<%# Eval("State") %>' /></td>
<td><asp:Label ID="ZipCodeofNewDevLabel" runat="server" Text='<%# Eval("ZipCodeofNewDev") %>' /></td>
<td><asp:Label ID="ProjectStatusLabel" runat="server" Text='<%# Eval("ProjectStatus") %>' /></td>
<td><asp:Label ID="ShoppingCenterLabel" runat="server" Text='<%# Eval("ShoppingCenter") %>' /></td>
<td><asp:Label ID="ProjectStartDateLabel" runat="server" Text='<%# Eval("ProjectStartDate") %>' /></td>
<td><asp:Label ID="ProjectDescriptionLabel" runat="server" Text='<%# Eval("ProjectDescription") %>' /></td>
<td><asp:Label ID="ProposedAnchorTenantsLabel" runat="server" Text='<%# Eval("ProposedAnchorTenants") %>' /></td>
<td><asp:Label ID="GLALabel" runat="server" Text='<%# Eval("GLA") %>' /></td>
<td><asp:Label ID="EstCompDateLabel" runat="server" Text='<%# Eval("EstCompDate") %>' /></td>
<td><asp:Label ID="DeveloperLabel" runat="server" Text='<%# Eval("Developer") %>' /></td>
<td><asp:Label ID="BusinessUnitLabel" runat="server" Text='<%# Eval("BusinessUnit") %>' /></td>
<td><asp:Label ID="BULabel" runat="server" Text='<%# Eval("BU") %>' /></td>
<td><asp:Label ID="CenterNameLabel" runat="server" Text='<%# Eval("CenterName") %>' /></td>
<td><asp:Label ID="MSALabel" runat="server" Text='<%# Eval("MSA") %>' /></td>
<td><asp:Label ID="BrixmorMSARankLabel" runat="server" Text='<%# Eval("BrixmorMSARank") %>' /></td>
<td><asp:Label ID="CountLabel" runat="server" Text='<%# Eval("Count") %>' /></td>
<td><asp:Label ID="RegionLabel" runat="server" Text='<%# Eval("Region") %>' /></td>
<td><asp:Label ID="DistancefromNewDevLabel" runat="server" Text='<%# Eval("DistancefromNewDev") %>' /></td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color: rgba(255, 255, 255, 1);">
<td><asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" /></td>
<td><asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" /></td>
<td><asp:Label ID="CompIDLabel" runat="server" Text='<%# Eval("CompID") %>' /></td>
<td><asp:Label ID="NewDevCountLabel" runat="server" Text='<%# Eval("NewDevCount") %>' /></td>
<td><asp:Label ID="DevelopmentNameLabel" runat="server" Text='<%# Eval("DevelopmentName") %>' /></td>
<td><asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' /></td>
<td><asp:Label ID="StateLabel" runat="server" Text='<%# Eval("State") %>' /></td>
<td><asp:Label ID="ZipCodeofNewDevLabel" runat="server" Text='<%# Eval("ZipCodeofNewDev") %>' /></td>
<td><asp:Label ID="ProjectStatusLabel" runat="server" Text='<%# Eval("ProjectStatus") %>' /></td>
<td><asp:Label ID="ShoppingCenterLabel" runat="server" Text='<%# Eval("ShoppingCenter") %>' /></td>
<td><asp:Label ID="ProjectStartDateLabel" runat="server" Text='<%# Eval("ProjectStartDate") %>' /></td>
<td><asp:Label ID="ProjectDescriptionLabel" runat="server" Text='<%# Eval("ProjectDescription") %>' /></td>
<td><asp:Label ID="ProposedAnchorTenantsLabel" runat="server" Text='<%# Eval("ProposedAnchorTenants") %>' /></td>
<td><asp:Label ID="GLALabel" runat="server" Text='<%# Eval("GLA") %>' /></td>
<td><asp:Label ID="EstCompDateLabel" runat="server" Text='<%# Eval("EstCompDate") %>' /></td>
<td><asp:Label ID="DeveloperLabel" runat="server" Text='<%# Eval("Developer") %>' /></td>
<td><asp:Label ID="BusinessUnitLabel" runat="server" Text='<%# Eval("BusinessUnit") %>' /></td>
<td><asp:Label ID="BULabel" runat="server" Text='<%# Eval("BU") %>' /></td>
<td><asp:Label ID="CenterNameLabel" runat="server" Text='<%# Eval("CenterName") %>' /></td>
<td><asp:Label ID="MSALabel" runat="server" Text='<%# Eval("MSA") %>' /></td>
<td><asp:Label ID="BrixmorMSARankLabel" runat="server" Text='<%# Eval("BrixmorMSARank") %>' /></td>
<td><asp:Label ID="CountLabel" runat="server" Text='<%# Eval("Count") %>' /></td>
<td><asp:Label ID="RegionLabel" runat="server" Text='<%# Eval("Region") %>' /></td>
<td><asp:Label ID="DistancefromNewDevLabel" runat="server" Text='<%# Eval("DistancefromNewDev") %>' /></td>
</tr>
</AlternatingItemTemplate>
<EditItemTemplate>
<tr>
<td><asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" /></td>
<td><asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" /></td>
<td><asp:Label ID="CompIDLabel1" runat="server" Text='<%# Eval("CompID") %>' /></td>
<td><asp:TextBox ID="NewDevCountTextBox" runat="server" Text='<%# Bind("NewDevCount") %>' /></td>
<td><asp:TextBox ID="DevelopmentNameTextBox" runat="server" Text='<%# Bind("DevelopmentName") %>' /></td>
<td><asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' /></td>
<td><asp:TextBox ID="StateTextBox" runat="server" Text='<%# Bind("State") %>' /></td>
<td><asp:TextBox ID="ZipCodeofNewDevTextBox" runat="server" Text='<%# Bind("ZipCodeofNewDev") %>' /></td>
<td><asp:TextBox ID="ProjectStatusTextBox" runat="server" Text='<%# Bind("ProjectStatus") %>' /></td>
<td><asp:TextBox ID="ShoppingCenterTextBox" runat="server" Text='<%# Bind("ShoppingCenter") %>' /></td>
<td><asp:TextBox ID="ProjectStartDateTextBox" runat="server" Text='<%# Bind("ProjectStartDate") %>' /></td>
<td><asp:TextBox ID="ProjectDescriptionTextBox" runat="server" Text='<%# Bind("ProjectDescription") %>' /></td>
<td><asp:TextBox ID="ProposedAnchorTenantsTextBox" runat="server" Text='<%# Bind("ProposedAnchorTenants") %>' /></td>
<td><asp:TextBox ID="GLATextBox" runat="server" Text='<%# Bind("GLA") %>' /></td>
<td><asp:TextBox ID="EstCompDateTextBox" runat="server" Text='<%# Bind("EstCompDate") %>' /></td>
<td><asp:TextBox ID="DeveloperTextBox" runat="server" Text='<%# Bind("Developer") %>' /></td>
<td><asp:TextBox ID="BusinessUnitTextBox" runat="server" Text='<%# Bind("BusinessUnit") %>' /></td>
<td><asp:TextBox ID="BUTextBox" runat="server" Text='<%# Bind("BU") %>' /></td>
<td><asp:TextBox ID="CenterNameTextBox" runat="server" Text='<%# Bind("CenterName") %>' /></td>
<td><asp:TextBox ID="MSATextBox" runat="server" Text='<%# Bind("MSA") %>' /></td>
<td><asp:TextBox ID="BrixmorMSARankTextBox" runat="server" Text='<%# Bind("BrixmorMSARank") %>' /></td>
<td><asp:TextBox ID="CountTextBox" runat="server" Text='<%# Bind("Count") %>' /></td>
<td><asp:TextBox ID="RegionTextBox" runat="server" Text='<%# Bind("Region") %>' /></td>
<td><asp:TextBox ID="DistancefromNewDevTextBox" runat="server" Text='<%# Bind("DistancefromNewDev") %>' /></td>
</tr>
</EditItemTemplate>
<EmptyDataTemplate>
<table runat="server" style="">
<tr>
<td>No data was returned.</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td><asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" /></td>
<td><asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" /></td>
<td> </td>
<td><asp:TextBox ID="NewDevCountTextBox" runat="server" Text='<%# Bind("NewDevCount") %>' /></td>
<td><asp:TextBox ID="DevelopmentNameTextBox" runat="server" Text='<%# Bind("DevelopmentName") %>' /></td>
<td><asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' /></td>
<td><asp:TextBox ID="StateTextBox" runat="server" Text='<%# Bind("State") %>' /></td>
<td><asp:TextBox ID="ZipCodeofNewDevTextBox" runat="server" Text='<%# Bind("ZipCodeofNewDev") %>' /></td>
<td><asp:TextBox ID="ProjectStatusTextBox" runat="server" Text='<%# Bind("ProjectStatus") %>' /></td>
<td><asp:TextBox ID="ShoppingCenterTextBox" runat="server" Text='<%# Bind("ShoppingCenter") %>' /></td>
<td><asp:TextBox ID="ProjectStartDateTextBox" runat="server" Text='<%# Bind("ProjectStartDate") %>' /></td>
<td><asp:TextBox ID="ProjectDescriptionTextBox" runat="server" Text='<%# Bind("ProjectDescription") %>' /></td>
<td><asp:TextBox ID="ProposedAnchorTenantsTextBox" runat="server" Text='<%# Bind("ProposedAnchorTenants") %>' /></td>
<td><asp:TextBox ID="GLATextBox" runat="server" Text='<%# Bind("GLA") %>' /></td>
<td><asp:TextBox ID="EstCompDateTextBox" runat="server" Text='<%# Bind("EstCompDate") %>' /></td>
<td><asp:TextBox ID="DeveloperTextBox" runat="server" Text='<%# Bind("Developer") %>' /></td>
<td><asp:TextBox ID="BusinessUnitTextBox" runat="server" Text='<%# Bind("BusinessUnit") %>' /></td>
<td><asp:TextBox ID="BUTextBox" runat="server" Text='<%# Bind("BU") %>' /></td>
<td><asp:TextBox ID="CenterNameTextBox" runat="server" Text='<%# Bind("CenterName") %>' /></td>
<td><asp:TextBox ID="MSATextBox" runat="server" Text='<%# Bind("MSA") %>' /></td>
<td><asp:TextBox ID="BrixmorMSARankTextBox" runat="server" Text='<%# Bind("BrixmorMSARank") %>' /></td>
<td><asp:TextBox ID="CountTextBox" runat="server" Text='<%# Bind("Count") %>' /></td>
<td><asp:TextBox ID="RegionTextBox" runat="server" Text='<%# Bind("Region") %>' /></td>
<td><asp:TextBox ID="DistancefromNewDevTextBox" runat="server" Text='<%# Bind("DistancefromNewDev") %>' /></td>
</tr>
</InsertItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table id="itemPlaceholderContainer" runat="server" border="0" style="">
<tr runat="server" style="background-color: rgba(122, 21, 1, 1); font-weight: bold; color: rgba(255, 255, 255, 1);">
<th runat="server"></th>
<th runat="server"></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton1" style="color: rgba(255, 255, 255, 1);" Text="CompID" CommandName="Sort" CommandArgument="CompID" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton2" style="color: rgba(255, 255, 255, 1);" Text="NewDevCount" CommandName="Sort" CommandArgument="NewDevCount" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton3" style="color: rgba(255, 255, 255, 1);" Text="DevelopmentName" CommandName="Sort" CommandArgument="DevelopmentName" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton4" style="color: rgba(255, 255, 255, 1);" Text="City" CommandName="Sort" CommandArgument="City" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton5" style="color: rgba(255, 255, 255, 1);" Text="State" CommandName="Sort" CommandArgument="State" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton6" style="color: rgba(255, 255, 255, 1);" Text="ZipCodeofNewDev" CommandName="Sort" CommandArgument="ZipCodeofNewDev" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton7" style="color: rgba(255, 255, 255, 1);" Text="ProjectStatus" CommandName="Sort" CommandArgument="ProjectStatus" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton8" style="color: rgba(255, 255, 255, 1);" Text="ShoppingCenter" CommandName="Sort" CommandArgument="ShoppingCenter" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton9" style="color: rgba(255, 255, 255, 1);" Text="ProjectStartDate" CommandName="Sort" CommandArgument="ProjectStartDate" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton10" style="color: rgba(255, 255, 255, 1);" Text="ProjectDescription" CommandName="Sort" CommandArgument="ProjectDescription" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton11" style="color: rgba(255, 255, 255, 1);" Text="ProposedAnchorTenants" CommandName="Sort" CommandArgument="ProposedAnchorTenants" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton12" style="color: rgba(255, 255, 255, 1);" Text="GLA" CommandName="Sort" CommandArgument="GLA" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton13" style="color: rgba(255, 255, 255, 1);" Text="EstCompDate" CommandName="Sort" CommandArgument="EstCompDate" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton14" style="color: rgba(255, 255, 255, 1);" Text="Developer" CommandName="Sort" CommandArgument="Developer" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton15" style="color: rgba(255, 255, 255, 1);" Text="BusinessUnit" CommandName="Sort" CommandArgument="BusinessUnit" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton16" style="color: rgba(255, 255, 255, 1);" Text="BU" CommandName="Sort" CommandArgument="BU" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton17" style="color: rgba(255, 255, 255, 1);" Text="CenterName" CommandName="Sort" CommandArgument="CenterName" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton18" style="color: rgba(255, 255, 255, 1);" Text="MSA" CommandName="Sort" CommandArgument="MSA" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton19" style="color: rgba(255, 255, 255, 1);" Text="BrixmorMSARank" CommandName="Sort" CommandArgument="BrixmorMSARank" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton20" style="color: rgba(255, 255, 255, 1);" Text="Count" CommandName="Sort" CommandArgument="Count" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton21" style="color: rgba(255, 255, 255, 1);" Text="Region" CommandName="Sort" CommandArgument="Region" /></th>
<th runat="server"><asp:LinkButton runat="server" ID="LinkButton22" style="color: rgba(255, 255, 255, 1);" Text="DistancefromNewDev" CommandName="Sort" CommandArgument="DistancefromNewDev" /></th>
</tr>
<tr id="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server" style="background-color: rgba(237, 45, 34, 1); color: rgba(0, 0, 0, 1); text-align: left;">
<td runat="server">
<asp:DataPager ID="DataPager1" runat="server">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
</Fields>
</asp:DataPager>
</td>
</tr>
</table>
</LayoutTemplate>
</asp:ListView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CnnStr %>" DeleteCommand="CompDev_Delete" DeleteCommandType="StoredProcedure" InsertCommand="CompDev_Insert" InsertCommandType="StoredProcedure" SelectCommand="CompDev_Select" SelectCommandType="StoredProcedure" UpdateCommand="CompDev_Update" UpdateCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="CompID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="NewDevCount" Type="String" />
<asp:Parameter Name="DevelopmentName" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="ZipCodeofNewDev" Type="String" />
<asp:Parameter Name="ProjectStatus" Type="String" />
<asp:Parameter Name="ShoppingCenter" Type="String" />
<asp:Parameter Name="ProjectStartDate" Type="Double" />
<asp:Parameter Name="ProjectDescription" Type="String" />
<asp:Parameter Name="ProposedAnchorTenants" Type="String" />
<asp:Parameter Name="GLA" Type="String" />
<asp:Parameter Name="EstCompDate" Type="Double" />
<asp:Parameter Name="Developer" Type="String" />
<asp:Parameter Name="BusinessUnit" Type="String" />
<asp:Parameter Name="BU" Type="String" />
<asp:Parameter Name="CenterName" Type="String" />
<asp:Parameter Name="MSA" Type="String" />
<asp:Parameter Name="BrixmorMSARank" Type="String" />
<asp:Parameter Name="Count" Type="String" />
<asp:Parameter Name="Region" Type="String" />
<asp:Parameter Name="DistancefromNewDev" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="CompID" Type="Int32" />
<asp:Parameter Name="NewDevCount" Type="String" />
<asp:Parameter Name="DevelopmentName" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="ZipCodeofNewDev" Type="String" />
<asp:Parameter Name="ProjectStatus" Type="String" />
<asp:Parameter Name="ShoppingCenter" Type="String" />
<asp:Parameter Name="ProjectStartDate" Type="Double" />
<asp:Parameter Name="ProjectDescription" Type="String" />
<asp:Parameter Name="ProposedAnchorTenants" Type="String" />
<asp:Parameter Name="GLA" Type="String" />
<asp:Parameter Name="EstCompDate" Type="Double" />
<asp:Parameter Name="Developer" Type="String" />
<asp:Parameter Name="BusinessUnit" Type="String" />
<asp:Parameter Name="BU" Type="String" />
<asp:Parameter Name="CenterName" Type="String" />
<asp:Parameter Name="MSA" Type="String" />
<asp:Parameter Name="BrixmorMSARank" Type="String" />
<asp:Parameter Name="Count" Type="String" />
<asp:Parameter Name="Region" Type="String" />
<asp:Parameter Name="DistancefromNewDev" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>
所以 - 我做了什么:
我设置了一个简单的列表视图,连接到 web.config 中的连接字符串。列表视图有一个连接到该连接字符串的 SQL 数据源,并且它使用上面的存储过程进行数据 CRUD 操作。我什至添加了你的款式,让 LV 看起来就像你的 GV 一样。
如果您不接受这个答案,我也没关系,因为我没有从技术上解决您的 gridview 问题,而是替换它们。也就是说,使用此解决方案将使您的工作顺利进行。 :)