// este es el codigo del gridview
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px"
CellPadding="4" DataKeyNames="idNota,nie" DataSourceID="NOTASXMATERIA">
<Columns>
<asp:BoundField DataField="idNota" HeaderText="idNota" InsertVisible="False"
ReadOnly="True" SortExpression="idNota" Visible="False" />
<asp:BoundField DataField="nie" HeaderText="NIE" InsertVisible="False"
ReadOnly="True" SortExpression="nie" />
<asp:BoundField DataField="nombres" HeaderText="Nombres" ReadOnly="True"
SortExpression="nombres" />
<asp:BoundField DataField="apellidos" HeaderText="Apellidos" ReadOnly="True"
SortExpression="apellidos" />
<asp:BoundField DataField="n1" HeaderText="N1" SortExpression="n1" />
<asp:BoundField DataField="n2" HeaderText="N2" SortExpression="n2" />
<asp:BoundField DataField="n3" HeaderText="N3" SortExpression="n3" />
<asp:BoundField DataField="n4" HeaderText="N4" SortExpression="n4" />
<asp:BoundField DataField="promedio" HeaderText="Promedio" ReadOnly="True"
SortExpression="promedio" />
<asp:CommandField ShowEditButton="True" />
</Columns>
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
<RowStyle BackColor="White" ForeColor="#330099" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<SortedAscendingCellStyle BackColor="#FEFCEB" />
<SortedAscendingHeaderStyle BackColor="#AF0101" />
<SortedDescendingCellStyle BackColor="#F6F0C0" />
<SortedDescendingHeaderStyle BackColor="#7E0000" />
</asp:GridView>
// codigo del objeto slqdatasource
<asp:SqlDataSource ID="NOTASXMATERIA" runat="server"
ConnectionString="<%$ ConnectionStrings:local %>"
SelectCommand="mis_notas_x_materia" SelectCommandType="StoredProcedure"
UpdateCommand="editNotas" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="codGrado"
PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="DropDownList2" Name="codMateria"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:FormParameter FormField="n1" Name="n1" Type="String" />
<asp:FormParameter FormField="n2" Name="n2" Type="String" />
<asp:FormParameter FormField="n3" Name="n3" Type="String" />
<asp:FormParameter FormField="n4" Name="n4" Type="String" />
<asp:FormParameter FormField="idnota" Name="idnota" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>