gridview没法更新数据
gridview无法更新数据
SqlDataSource作为数据源,无法更新数据,点击后好事原来的
SqlDataSource作为数据源,无法更新数据,点击后好事原来的
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="PF_WD.aspx.cs" Inherits="LS_PF_WD" %>
<!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>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
EnableModelValidation="True">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="StudentID" HeaderText="StudentID"
SortExpression="StudentID" />
<asp:BoundField DataField="HD_TM" HeaderText="HD_TM" SortExpression="HD_TM" />
<asp:BoundField DataField="HD_KSHD" HeaderText="HD_KSHD"
SortExpression="HD_KSHD" />
<asp:BoundField DataField="GF" HeaderText="GF" SortExpression="GF" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:kaoshiConnectionString2 %>"
DeleteCommand="DELETE FROM [HD_TK] WHERE [StudentID] = @original_StudentID AND [TK_ID] = @original_TK_ID AND (([HD_TM] = @original_HD_TM) OR ([HD_TM] IS NULL AND @original_HD_TM IS NULL)) AND (([HD_CKDA] = @original_HD_CKDA) OR ([HD_CKDA] IS NULL AND @original_HD_CKDA IS NULL)) AND (([HD_KSHD] = @original_HD_KSHD) OR ([HD_KSHD] IS NULL AND @original_HD_KSHD IS NULL)) AND (([LessonID] = @original_LessonID) OR ([LessonID] IS NULL AND @original_LessonID IS NULL)) AND (([HD_RQ] = @original_HD_RQ) OR ([HD_RQ] IS NULL AND @original_HD_RQ IS NULL)) AND (([GF] = @original_GF) OR ([GF] IS NULL AND @original_GF IS NULL))"
InsertCommand="INSERT INTO [HD_TK] ([StudentID], [TK_ID], [HD_TM], [HD_CKDA], [HD_KSHD], [LessonID], [HD_RQ], [GF]) VALUES (@StudentID, @TK_ID, @HD_TM, @HD_CKDA, @HD_KSHD, @LessonID, @HD_RQ, @GF)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="select StudentID,HD_TM,HD_KSHD,GF from HD_TK where StudentID in(select StudentID from RKLS where LS_ID=4) "
UpdateCommand="UPDATE [HD_TK] SET [HD_TM] = @HD_TM, [HD_CKDA] = @HD_CKDA, [HD_KSHD] = @HD_KSHD, [LessonID] = @LessonID, [HD_RQ] = @HD_RQ, [GF] = @GF WHERE [StudentID] = @original_StudentID AND [TK_ID] = @original_TK_ID AND (([HD_TM] = @original_HD_TM) OR ([HD_TM] IS NULL AND @original_HD_TM IS NULL)) AND (([HD_CKDA] = @original_HD_CKDA) OR ([HD_CKDA] IS NULL AND @original_HD_CKDA IS NULL)) AND (([HD_KSHD] = @original_HD_KSHD) OR ([HD_KSHD] IS NULL AND @original_HD_KSHD IS NULL)) AND (([LessonID] = @original_LessonID) OR ([LessonID] IS NULL AND @original_LessonID IS NULL)) AND (([HD_RQ] = @original_HD_RQ) OR ([HD_RQ] IS NULL AND @original_HD_RQ IS NULL)) AND (([GF] = @original_GF) OR ([GF] IS NULL AND @original_GF IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_StudentID" Type="String" />
<asp:Parameter Name="original_TK_ID" Type="Int32" />