GridView Update not updating data

[Dabbler]

I have a GridView with a couple of TemplateFields. When I click the update
link the Gridview returns to display mode with no errors but the data from
bound text fields or dropdown list isn't updated in the table. I'm stumped
and any help would be appreciated.

Thanks much.

My GridView:

<asp:GridView ID="VanListGrid View" runat="server"
AutoGenerateDel eteButton="True " AutoGenerateEdi tButton="True"
CellPadding="3" GridLines="Hori zontal"
DataSourceID="s dsVans" DataKeyNames="V anId"
AutoGenerateCol umns="False" CssClass="waGri dView"
AllowPaging="Tr ue" ShowFooter="tru e"
HorizontalAlign ="Center">
<FooterStyle CssClass="waFoo terStyle" />
<RowStyle CssClass="waRow Style" />
<EmptyDataTempl ate>
<asp:HyperLin k ID="HyperLink1 " runat="server" CssClass="waLin k"
NavigateUrl="Va nDetail.aspx">N ew</asp:HyperLink>
The table is empty.</EmptyDataTempla te>
<SelectedRowSty le CssClass="waSel ectedRowStyle" />
<PagerStyle CssClass="waPag erStyle" HorizontalAlign ="Right" />
<HeaderStyle CssClass="waHea derStyle" />
<AlternatingRow Style CssClass="waAlt ernatingRowStyl e" />
<Columns>
<asp:BoundFie ld DataField="VanI d" ReadOnly="true"
HeaderText="Id" SortExpression= "VanId" />
<asp:BoundFie ld DataField="Vend orVanNo" HeaderText="Ven dor
Van#" SortExpression= "VendorVanN o" />
<asp:TemplateFi eld HeaderText="Ven dorCode" ItemStyle-Width="60">
<ItemTemplate >
<asp:literal ID="Literal1" runat="server" Text='<%#
Eval("VendorCod e") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlVendors " runat="server"
DataSourceID="s dsVendors" DataTextField=" VendorCode"
DataValueField= "VendorCode " Width="80"
SelectedValue=' <%# Bind("VendorCod e") %>'>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>
<asp:BoundFie ld DataField="Stat us" HeaderText="Sta tus"
SortExpression= "Status">
<ItemStyle Width="100" />
</asp:BoundField>
<asp:TemplateFi eld HeaderText="Act ive">
<ItemTemplate >
<asp:CheckBox ID="ActiveCheck Box" runat="server"
Checked='<%# Eval("Active") %>' CssClass="waChe ckBox" />
</ItemTemplate>
<EditItemTempla te>
<asp:CheckBox ID="ActiveCheck Box" runat="server"
Checked='<%# Bind("Active") %>' CssClass="waChe ckBox" />
</EditItemTemplat e>
</asp:TemplateFie ld>
<asp:BoundFie ld DataField="Star tDate" HeaderText="Sta rt"
SortExpression= "StartDate"
DataFormatStrin g="{0:d}" HtmlEncode="fal se" />
<asp:BoundFie ld DataField="EndD ate" HeaderText="End "
SortExpression= "EndDate" DataFormatStrin g="{0:d}" HtmlEncode="fal se" />
</Columns>
</asp:GridView>

My Primary Vendors table SQL data source

<asp:SqlDataSou rce ID="sdsVans" runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:myDB %>"
SelectCommand=" SELECT VanId, VendorVanNo, VendorCode, StartDate,
EndDate, Status, Active FROM dbo.Vans order by VanId"
UpdateCommand=" Update dbo.Vans set VendorVanNo=@Ve ndorVanNo,
VendorCode=@Ven dorCode, Status=@Status, Active=@Active, StartDate=@Star tDate,
EndDate=@EndDat e where VanId=@VanId"
DeleteCommand=" Delete from dbo.Vans where VanId=@VanId">
</asp:SqlDataSour ce>

DataSource for dropdownlist:
<asp:SqlDataSou rce ID="sdsVendors " runat="server"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:cobbcc %>"
SelectCommand=" SELECT VendorCode FROM dbo.Vendors order by VendorCode">
</asp:SqlDataSour ce>

[agapeton]

Doesn't look like you have an UpdateCommand set.

David Betz
WinFX Harmonics Blog
http://www.davidbetz.net/winfx/

[Dabbler]

I am using this update command:
UpdateCommand=" Update dbo.Vans set VendorVanNo=@Ve ndorVanNo,
VendorCode=@Ven dorCode, Status=@Status, Active=@Active, StartDate=@Star tDate,
EndDate=@EndDat e where VanId=@VanId"

"ag******@gmail .com" wrote:

Doesn't look like you have an UpdateCommand set.

David Betz
WinFX Harmonics Blog
http://www.davidbetz.net/winfx/

[Phillip Williams]

The delete method in your code uses the same WHERE condition as the Update.
If the update were not working, I would expect that the Delete would not work
either. Can you verify? If so, try defining an UpdateParameter s collection
where you typecast each parameter using the proper "Type" (use the other post
in which I explained to you the use of the UpdateParameter s) and try it again.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I am using this update command:
UpdateCommand=" Update dbo.Vans set VendorVanNo=@Ve ndorVanNo,
VendorCode=@Ven dorCode, Status=@Status, Active=@Active, StartDate=@Star tDate,
EndDate=@EndDat e where VanId=@VanId"

"ag******@gmail .com" wrote:

Doesn't look like you have an UpdateCommand set.

David Betz
WinFX Harmonics Blog
http://www.davidbetz.net/winfx/

[q]

My mistake I misunderstood your question (and read your code wrong!)
What result are you looking for?

David Betz
WinFX Harmonics Blog
http://www.davidbetz.net/winfx/

[Dabbler]

Thanks for your reply David. I was just lamenting the fact that the
UpdateCommand did nothing. No errors and no update in the table. I have since
gven up on editing with the GridView and instead use the SelectCommand to
redirect to antoher page with a DetailsView for the edit.

Spending too much time trying to fathom the mysteries of binding to
SqlDataSource and not enough time producing results ;)
"q" wrote:

My mistake I misunderstood your question (and read your code wrong!)
What result are you looking for?

David Betz
WinFX Harmonics Blog
http://www.davidbetz.net/winfx/

[Dabbler]

Yes the DeleteCommand worked.

I have since given up on editing the table with the GridView and instead use
the SelectCommand to redirect to another page with a DetailsView for the edit.

From my posts I'm sure you can see I'm spending too much time trying to
fathom the mysteries of binding to SqlDataSource and not enough time
producing results, probably should have stuck with the old style of coding a
dataset/dataadapter solution as in ASP.NET v1 ;)

Thanks for your ongoing assistance.

"Phillip Williams" wrote:

The delete method in your code uses the same WHERE condition as the Update.
If the update were not working, I would expect that the Delete would not work
either. Can you verify? If so, try defining an UpdateParameter s collection
where you typecast each parameter using the proper "Type" (use the other post
in which I explained to you the use of the UpdateParameter s) and try it again.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I am using this update command:
UpdateCommand=" Update dbo.Vans set VendorVanNo=@Ve ndorVanNo,
VendorCode=@Ven dorCode, Status=@Status, Active=@Active, StartDate=@Star tDate,
EndDate=@EndDat e where VanId=@VanId"

"ag******@gmail .com" wrote:

Doesn't look like you have an UpdateCommand set.

David Betz
WinFX Harmonics Blog
http://www.davidbetz.net/winfx/