DropDownList in ASP.Net GridView EditItemTemplate

web in asp.net+vb code+sql database

i hvae a database named anil and TABLE NAMED COURSE_IN fields are (gridview with regnumber,name,dtjoin, qual, OY, OTY,VDA) and another table course with (OY, OTY,VDA) fiedls. my grid view displays adata from databse with edit facility.

one dropdownlist out side grid selected value is displayed in gridview

DROPDOWNLIST OUTSIDE THE GRID

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
            DataSourceID="SqlDataSource1" DataTextField="ENTRY_COURSE"
            DataValueField="ENTRY_COURSE">
        </asp:DropDownList>

GRIDVIEW

<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
            AutoGenerateColumns="False" CellPadding="4" DataMember="DefaultView"
            DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None"
            style="font-family: Arial; font-size: small">
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <Columns>
                <asp:BoundField DataField="regno" HeaderText="regno" SortExpression="regno" >
                    <ItemStyle Width="8px" />
                </asp:BoundField>
                 <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />
               
                <asp:BoundField DataField="dtjoin" HeaderText="dtjoin" SortExpression="dtjoin" />
               <asp:BoundField DataField="qual" HeaderText="qual" SortExpression="qual" />
<asp:TemplateField HeaderText="OY">
<ItemTemplate>
<asp:DropDownList runat="server" AutoPostBack="true" ID="ID" DataSourceID="SqlDataSource3" DataTextField="COURSE" DataValueField="StateID" SelectedValue='<%#Bind("State") %>' OnSelectedIndexChanged="StateID_SelectedIndexChanged" ></asp:DropDownList>
                </ItemTemplate>
                </asp:TemplateField>

<asp:TemplateField HeaderText="OTY">
<ItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="YTO">
<ItemTemplate>
<asp:DropDownList ID="DropDownList3" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="VDA">
<ItemTemplate>
<asp:DropDownList ID="DropDownList4" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>

             <asp:BoundField DataField="rmk" HeaderText="rmk" SortExpression="rmk" />
               
                <asp:CommandField ShowEditButton="True" />
            </Columns>
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>

SQL DATASOURCE FOR GRIDVIEW

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>" 
            
            SelectCommand="SELECT REGNO,NAME,convert (varchar, DTJOIN,105) as [DTJOIN],QUAL,OY,OTY,VDA,RMK FROM [course_IN] WHERE ([ENTRY_COURSE] = @ENTRY_COURSE)" 
            UpdateCommand="UPDATE Course_intake SET OY = @OY, OTY=@OTY, VDA=@VDA WHERE PNUMB=@PNUMB">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" Name="ENTRY_COURSE" 
                    PropertyName="SelectedValue" Type="String" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="OY" />
                <asp:Parameter Name="OTY" />
                <asp:Parameter Name="VDA" />
                <asp:Parameter Name="REGNO" />
            </UpdateParameters>
        </asp:SqlDataSource>

SQL DATA SOURCE FOR DROPDOWN IN SIDE THE GRID

<asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>" 
            SelectCommand="SELECT * FROM [course]"></asp:SqlDataSource>

when THE DROPDOWNLIST OUT SIDE THE GRID VALUE IS CHANGED THE GRID IS DISPLAYING CORRECT DATA. AND WHEN I EDIT THE GRID DATA IT ALSO WORKS CORRECT. I TRID TO EDIT THE CODE FOR THE DROPDOWNLIST TEMPLETE BUT NOT GOT THROUGH. WHEN I CLICK EDIT IN THE GRID VIEW I WANT ONLY OY,OTY,VDA FIELDS OF GRID TO EDIT (OTHERS MUST NOT COME IN EDIT MODE) (NOW WHEN I CLICK EDIT THE ENTIRE ROW IS IN EDIT MODE AND THE COLOUMN GET WIDENED EDIT BOX SIZE IS HUGE).

 THE TABLE FROM DROPDOWNLIST DATA GET = COURSE A

 FIELDS ARE COURSE_ID,OY,OTY,VDA