The RadPanel is not binding the data to my sqlDataSource. I keep getting "field cannot be NULL" when trying to insert the data to the db.
Here is my part of my code:
Thanks,
Gunjan
Here is my part of my code:
<asp:SqlDataSource ID="sqlDSProjInfo" runat="server" |
ConnectionString="<%$ ConnectionStrings:JOBTRAKConnectionString %>" |
InsertCommand="INSERT INTO [CASE_PROJ_INFO] ([JOB_ID], [CASE_NAME], [MEDIA], [MEDIA_LOC], [MEDIA_AVAIL], [MEDIA_SIZE]) VALUES (@JOB_ID, @CASE_NAME, @MEDIA, @MEDIA_LOC, @MEDIA_AVAIL, @MEDIA_SIZE)" |
SelectCommand="SELECT * FROM [CASE_PROJ_INFO] WHERE [JOB_ID] = @JOB_ID" |
UpdateCommand="UPDATE [CASE_PROJ_INFO] SET [CASE_NAME] = @CASE_NAME, [MEDIA] = @MEDIA, [MEDIA_LOC] = @MEDIA_LOC, [MEDIA_AVAIL] = @MEDIA_AVAIL, [MEDIA_SIZE] = @MEDIA_SIZE WHERE [JOB_ID] = @JOB_ID"> |
<UpdateParameters> |
<asp:SessionParameter Name="CASE_NAME" SessionField="CASE_NAME" Type="String" /> |
<asp:SessionParameter Name="MEDIA" SessionField="MEDIA" Type="String" /> |
<asp:SessionParameter Name="MEDIA_LOC" SessionField="MEDIA_LOC" Type="String" /> |
<asp:SessionParameter Name="MEDIA_AVAIL" SessionField="MEDIA_AVAIL" Type="String" /> |
<asp:SessionParameter Name="MEDIA_SIZE" SessionField="MEDIA_SIZE" Type="String" /> |
<asp:SessionParameter Name="JOB_ID" SessionField="JOB_ID" Type="String" /> |
</UpdateParameters> |
<InsertParameters> |
<asp:Parameter Name="JOB_ID" Type="String" /> |
<asp:SessionParameter Name="CASE_NAME" SessionField="CASE_NAME" Type="String" /> |
<asp:SessionParameter Name="MEDIA" SessionField="MEDIA" Type="String" /> |
<asp:SessionParameter Name="MEDIA_LOC" SessionField="MEDIA_LOC" Type="String" /> |
<asp:SessionParameter Name="MEDIA_AVAIL" SessionField="MEDIA_AVAIL" Type="String" /> |
<asp:SessionParameter Name="MEDIA_SIZE" SessionField="MEDIA_SIZE" Type="String" /> |
</InsertParameters> |
<SelectParameters> |
<asp:Parameter Name="JOB_ID" Type="String" /> |
</SelectParameters> |
</asp:SqlDataSource> |
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Height="554px" Width="742px"> |
<telerik:RadPanelBar ID="RadPanelBar1" Runat="server" Height="100%" DataSourceID="sqlDSProjInfo" |
Width="100%" AllowCollapseAllItems="True" ExpandMode="SingleExpandedItem"> |
<CollapseAnimation Duration="100" Type="None" /> |
<Items> |
<telerik:RadPanelItem Expanded="true" Text="Project Information" runat="server"> |
<Items> |
<telerik:RadPanelItem runat="server" Value="Project Information"> |
<ItemTemplate> |
<div> |
<p> |
<table style="width: 100%"> |
<tr> |
<td> |
<asp:Label ID="lblCaseName" runat="server" Text="Case Name" /> |
</td> |
<td colspan="3"> |
<asp:TextBox ID="CASE_NAME" runat="server" Text='<%# Eval("CASE_NAME") %>' /> |
</td> |
</tr> |
<tr> |
<td> |
<asp:Label ID="lblMedia" runat="server" Text="Media:" /> |
</td> |
<td> |
<asp:TextBox ID="MEDIA" runat="server" Text='<%# Eval("MEDIA") %>' /> |
</td> |
<td> |
<asp:Label ID="lblMediaAvail" runat="server" Text="Media Availability:" /> |
</td> |
<td> |
<asp:TextBox ID="MEDIA_AVAIL" runat="server" Text='<%# Eval("MEDIA_AVAIL") %>' /> |
</td> |
</tr> |
<tr> |
<td> |
<asp:Label ID="lblMediaLoc" runat="server" Text="Media Location:" /> |
</td> |
<td> |
<asp:TextBox ID="MEDIA_LOC" runat="server" Text='<%# Eval("MEDIA_LOC") %>' /> |
</td> |
<td> |
<asp:Label ID="lblMediaSize" runat="server" Text="Media Size (GB):" /> |
</td> |
<td> |
<asp:TextBox ID="MEDIA_SIZE" runat="server" Text='<%# Eval("MEDIA_SIZE") %>' /> |
</td> |
</tr> |
</table> |
</p> |
</div> |
</ItemTemplate> |
</telerik:RadPanelItem> |
</Items> |
</telerik:RadPanelItem> |
</Items> |
<ExpandAnimation Duration="100" Type="None" /> |
</telerik:RadPanelBar> |
Thanks,
Gunjan