I am attempting to insert a simple record with LinqDataSource from a
ListView, however I always get a message saying "....LinqDataSo urce
'dataSource' has no values to insert. Check that the 'values' dictionary
contains values...."
I am using a ListView with a DataSourceID of a LinqDataSource. When a new
row icon is clicked....the ListView properly enters into the
InsertItemTempl ate....however when the ImageButton with a CommandName of
"Update" is clicked....the above message is displayed. Data is properly
being bound, etc.
I have a simple project which reproduces the problem.
Please offer suggestions on what you think the problem is.
The C# source code is as follows...
using System;
using System.Collecti ons;
using System.Configur ation;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.H tmlControls;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Xml.Linq ;
public partial class Default : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{
}
protected void btnNewRow_Click (object sender, EventArgs e)
{
lvwList.EditInd ex = -1;
lvwList.InsertI temPosition = InsertItemPosit ion.FirstItem;
}
}
ASPX file is as follows....
<%@ Page Language="C#" AutoEventWireup ="true" CodeFile="Defau lt.aspx.cs"
Inherits="Defau lt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ListVi ew Insert Problem</title>
</head>
<body>
<form id="form1" runat="server">
<div style="margin-left: 100px; margin-top: 100px;">
<asp:ListView ID="lvwList"
DataSourceID="d ataSource"
DataKeyNames="A dvertiserCatego ry"
runat="server">
<LayoutTemplate >
<asp:ImageButto n ID="btnNewRow" runat="server"
CausesValidatio n="False"
OnClick="btnNew Row_Click"
ImageUrl="~/images/VSNet2008Action s/NewDocumentHS.p ng" />
<table runat="server"
cellspacing="0"
border="0">
<tr>
<th></th>
<th></th>
<th>Category</th>
<th>Description </th>
</tr>
<tr runat="server" id="itemPlaceho lder" />
</table>
</LayoutTemplate>
<ItemTemplate >
<tr>
<td align="center">
<asp:ImageButto n runat="server"
CausesValidatio n="False"
CommandName="Ed it"
ImageUrl="~/images/VSNet2008Action s/EditInformation HS.png" />
</td>
<td align="center">
<asp:ImageButto n runat="server"
OnClientClick=' showConfirm(thi s); return false;'
CausesValidatio n="False"
CommandName="De lete"
ImageUrl="~/images/VSNet2008Action s/DeleteHS.png" />
</td>
<td align="left">
<asp:Label runat="server" Text='<%# Eval("Advertise rCategory") %>' />
</td>
<td align="left">
<asp:Label runat="server" Text='<%# Eval("Advertise rCategoryDesc") %>'
/>
</td>
</tr>
</ItemTemplate>
<EditItemTempla te>
<tr>
<td colspan="2">
<asp:LinkButt on runat="server"
CausesValidatio n="True"
CommandName="Up date"
Text="Update"
style="margin-left: 2px;"
ToolTip="Click to Save Editing..."/>
<asp:LinkButt on runat="server"
CausesValidatio n="False"
CommandName="Ca ncel"
Text="Cancel"
style="margin-left: 5px; margin-right: 2px;"
ToolTip="Click to Cancel..." />
</td>
<td align="left">
<asp:Label ID="lblAdvertis erCategory" runat="server"
Text='<%# Bind("Advertise rCategory") %>' />
</td>
<td align="left">
<asp:TextBox ID="txtAdvertis erCategoryDesc" runat="server"
Text='<%# Bind("Advertise rCategoryDesc") %>'
Width="250px" />
</td>
</tr>
</EditItemTemplat e>
<InsertItemTemp late>
<tr runat="server">
<td colspan="2">
<asp:LinkButt on runat="server"
CausesValidatio n="True"
CommandName="In sert"
Text="Insert"
style="margin-left: 2px;"
ToolTip="Click to Insert New Item..."/>
<asp:LinkButt on runat="server"
CausesValidatio n="False"
CommandName="Ca ncel"
Text="Cancel"
style="margin-left: 5px; margin-right: 2px;"
ToolTip="Click to Cancel..." />
</td>
<td align="left">
<asp:TextBox ID="txtAdvertis erCategory" runat="server"
Text='<%# Bind("Advertise rCategory") %>'
Width="150px" />
</td>
<td align="left">
<asp:TextBox ID="txtAdvertis erCategoryDesc" runat="server"
Text='<%# Bind("Advertise rCategoryDesc") %>'
Width="250px" />
</td>
</tr>
</InsertItemTempl ate>
</asp:ListView>
<asp:LinqDataSo urce ID="dataSource " runat="server"
ContextTypeName ="SLCMS_DB_Data Context"
EnableDelete="T rue"
EnableInsert="T rue"
EnableUpdate="T rue"
TableName="SLCM S_AdvertiserCat egories">
</asp:LinqDataSou rce>
</div>
</form>
</body>
</html>
--
Philip
