I am testing a sample script. I have customized certain fields to suit me. It's a grid view with 3 filters. So, after i filter to desired course i want to, i am supposed to edit/update the \[code\]amount\[/code\] value. Right now, it isn't updating. Neither does it throw up any errors. Example: if i change the value from 20-30 and select update, it shows me 20 after the page loads.Here is my script.\[code\]<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head id="Head1" runat="server"><title>Filtering Data In A GridView Using a DropDownList</title></head><body><form id="form1" runat="server"> <b>Choose a Course:</b> <asp
ropDownList ID="DropDownList1" DataSourceID="SqlDataSource2" AutoPostBack="True" DataTextField="Course" Runat="server" DataValueField="Course" /> <asp:SqlDataSource ID="SqlDataSource2" Runat="server" SelectCommand="SELECT Distinct Course FROM tmdsi" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>" /> <b>Choose a Location:</b> <aspropDownList ID="DropDownList2" DataSourceID="SqlDataSource3" AutoPostBack="True" DataTextField="Location" Runat="server" DataValueField="Location" /> <asp:SqlDataSource ID="SqlDataSource3" Runat="server" SelectCommand="SELECT Distinct Location FROM tmdsi" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>" /> <b>Choose a Language:</b> <aspropDownList ID="DropDownList3" DataSourceID="SqlDataSource4" AutoPostBack="True" DataTextField="Language" Runat="server" DataValueField="Language" /> <asp:SqlDataSource ID="SqlDataSource4" Runat="server" SelectCommand="SELECT Distinct Language FROM tmdsi" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>" /> <br /> <br /> <asp:GridView ID="GridView1" AllowSorting="True" AllowPaging="True" Runat="server" DataSourceID="SqlDataSource1" AutoGenerateEditButton="True" AutoGenerateColumns="False"> <Columns> <asp:BoundField ReadOnly="true" HeaderText="Course" DataField="Course" /> <asp:BoundField ReadOnly="true" HeaderText="Location" DataField="Location" /> <asp:BoundField ReadOnly="true" HeaderText="Language" DataField="Language" /> <asp:BoundField HeaderText="Amount" DataField="Amount" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" Runat="server" SelectCommand="SELECT Course,Language, Location, Amount FROM tmdsi Where Course = @Course and Location = @Location and Language = @Language " UpdateCommand="UPDATE tmdsi SET Amount = @Amount where Course = @Course and Location = @Location and Language=@Language " ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>"> <SelectParameters> <asp:ControlParameter Name="Course" ControlID="DropDownList1" /> <asp:ControlParameter Name="Location" ControlID="DropDownList2" /> <asp:ControlParameter Name="Language" ControlID="DropDownList3" /> </SelectParameters> <UpdateParameters> <asp
arameter Name="Course" /> <asparameter Name="Location" /> <asparameter Name="Language" /> <asparameter Name="Amount" /> </UpdateParameters> </asp:SqlDataSource></form>\[/code\]
ropDownList ID="DropDownList1" DataSourceID="SqlDataSource2" AutoPostBack="True" DataTextField="Course" Runat="server" DataValueField="Course" /> <asp:SqlDataSource ID="SqlDataSource2" Runat="server" SelectCommand="SELECT Distinct Course FROM tmdsi" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>" /> <b>Choose a Location:</b> <aspropDownList ID="DropDownList2" DataSourceID="SqlDataSource3" AutoPostBack="True" DataTextField="Location" Runat="server" DataValueField="Location" /> <asp:SqlDataSource ID="SqlDataSource3" Runat="server" SelectCommand="SELECT Distinct Location FROM tmdsi" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>" /> <b>Choose a Language:</b> <aspropDownList ID="DropDownList3" DataSourceID="SqlDataSource4" AutoPostBack="True" DataTextField="Language" Runat="server" DataValueField="Language" /> <asp:SqlDataSource ID="SqlDataSource4" Runat="server" SelectCommand="SELECT Distinct Language FROM tmdsi" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>" /> <br /> <br /> <asp:GridView ID="GridView1" AllowSorting="True" AllowPaging="True" Runat="server" DataSourceID="SqlDataSource1" AutoGenerateEditButton="True" AutoGenerateColumns="False"> <Columns> <asp:BoundField ReadOnly="true" HeaderText="Course" DataField="Course" /> <asp:BoundField ReadOnly="true" HeaderText="Location" DataField="Location" /> <asp:BoundField ReadOnly="true" HeaderText="Language" DataField="Language" /> <asp:BoundField HeaderText="Amount" DataField="Amount" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" Runat="server" SelectCommand="SELECT Course,Language, Location, Amount FROM tmdsi Where Course = @Course and Location = @Location and Language = @Language " UpdateCommand="UPDATE tmdsi SET Amount = @Amount where Course = @Course and Location = @Location and Language=@Language " ConnectionString="<%$ ConnectionStrings:testConnectionString %>" ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>"> <SelectParameters> <asp:ControlParameter Name="Course" ControlID="DropDownList1" /> <asp:ControlParameter Name="Location" ControlID="DropDownList2" /> <asp:ControlParameter Name="Language" ControlID="DropDownList3" /> </SelectParameters> <UpdateParameters> <asparameter Name="Course" /> <asparameter Name="Location" /> <asparameter Name="Language" /> <asparameter Name="Amount" /> </UpdateParameters> </asp:SqlDataSource></form>\[/code\]