c# - C# GridView 中的 DateTime 更新字段

Question

我想拆分一个 DateTime，以便在 GridView 中显示和更新。如何在 SqlDataSource 的 UpdateParameters 中重新组合它们？

例如

<asp:SqlDataSource ID="uxTravelTripMeetingDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MGO %>" 
            ProviderName="<%$ ConnectionStrings:MGO.ProviderName %>" 
            SelectCommand="select * from v_travel_meeting t where travel_trip_id = :travel_trip_id" 
            UpdateCommand="update travel_prospect set person = :person, meeting_date = :meeting_date where prospect_id = :prospect_id and travel_trip_id = :travel_trip_id "
            <SelectParameters>
                <asp:QueryStringParameter Name="travel_trip_id" QueryStringField="id" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="person" />
                <asp:Parameter Name="prospect_id" />
                <asp:Parameter Name="travel_trip_id"/>
                <asp:Parameter Name="meeting_date" Type="DateTime" />
            </UpdateParameters>
        </asp:SqlDataSource>

        <asp:GridView ID="uxTravelTripMeetingGridView" runat="server" 
            DataSourceID="uxTravelTripMeetingDataSource" AutoGenerateColumns="False" 
            DataKeyNames="travel_trip_id,prospect_id">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:TemplateField HeaderText="Prospect">
                <ItemTemplate>
                   <a href="something.aspx?prospectid=<%# Eval("prospect_id") %>&height=500&width=600" title="caption" class="thickbox" ><%# Eval("prospect_name")%>
                </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="person" HeaderText="Person" />                    
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" 
                            Text='<%# Bind("meeting_date", "{0:d}") %>'></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox3" runat="server" 
                            Text='<%# Bind("meeting_date", "{0:d}") %>' />
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" 
                            Text='<%# Bind("Meeting_time") %>'></asp:Label>&nbsp;
                        <asp:Label ID="Label4" runat="server" 
                            Text='<%# Bind("Meeting_am_pm") %>'></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                                <asp:ObjectDataSource ID="ds15Min" runat="server" OldValuesParameterFormatString="original_{0}"
            SelectMethod="DDLFifteenMin" TypeName="App" />

                        <asp:DropDownList ID="DropDownList2" runat="server" 
                        DataSourceID="ds15Min" DataTextField="time" DataValueField="display" 
                            SelectedValue='<%# Bind("meeting_date","{0:t}") %>' >
                              <asp:ListItem Value=" "> </asp:ListItem>
                            </asp:DropDownList>
                    </EditItemTemplate>
                </asp:TemplateField>
            </Columns>

        </asp:GridView>

谢谢!

Answer 1

更新命令:

update travel_prospect set person = :person, meeting_date = DATEADD(n,@Date,@Time) 
where prospect_id = :prospect_id and travel_trip_id = :travel_trip_id

更新参数:

<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="Time" Type="String" />

现在这个解决方案意味着您必须以分钟为单位输入或计算日期的时间部分(这就是 DATEADD 中 n 的意思)才能正确创建它。如何做到这一点取决于您。