DataSource And Update

السلام عليكم.

لدي GridView ولها SqlDataSource

ال SqlDataSource ضفت لها تعليمة update واللتي لها Parameters

كما انني قمت باضافة خاصية EnableEditing لل GridView

والسؤال عندما اضغط على Edit ثم Update ذلك يؤدي الى خطأ.....بسبب عدم اسناد ال parameters بقيم...

كيف احل هذه المشكلة.

السؤال الثاني

نفس ماسبق.

ولكن عندما اضغط على Edit فان قيم العمود الثالث هي TextBox حاليا...ولكن اريدها ان تتحول الى DropDownList واللتي تأخد قيمها من SqlDataSource ثانية.

علما ان كود ال GridView وال SqlDataSource كما يلي.

<asp:GridView ID="GridView1" Width="100%" runat="server" AutoGenerateColumns="False"
            BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
            CellPadding="4" DataKeyNames="DoctorID" DataSourceID="SqlDataSource1">
            <RowStyle BackColor="White" ForeColor="#003399" />
            <Columns>
                <asp:BoundField DataField="DoctorID" HeaderText="DoctorID" InsertVisible="False"
                    ReadOnly="True" SortExpression="DoctorID" />
                <asp:BoundField DataField="DoctorName" HeaderText="DoctorName" SortExpression="DoctorName" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="Str" HeaderText="Str" SortExpression="Str" />
                <asp:BoundField DataField="StrRegion" HeaderText="StrRegion" SortExpression="StrRegion" />
                <asp:BoundField DataField="StringLevels" HeaderText="StringLevels" SortExpression="StringLevels" />
                <asp:BoundField DataField="Streat" HeaderText="Streat" SortExpression="Streat" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" />
                <asp:BoundField DataField="HomePhone" HeaderText="HomePhone" SortExpression="HomePhone" />
                <asp:BoundField DataField="ClinicPhone" HeaderText="ClinicPhone" SortExpression="ClinicPhone" />
                <asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" />
                <asp:BoundField DataField="address_details" HeaderText="address_details" SortExpression="address_details" />
                <asp:BoundField DataField="Expr1" HeaderText="Expr1" SortExpression="Expr1" />
                <asp:BoundField DataField="VisitPlaceStr" HeaderText="VisitPlaceStr" SortExpression="VisitPlaceStr" />
                <asp:CommandField ShowEditButton="True" />
            </Columns>
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
            <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
        </asp:GridView>







<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PCRM %>"
            SelectCommand="SP_BringAllDoctorInfoWithDetails" 
            SelectCommandType="StoredProcedure" ProviderName="System.Data.SqlClient" 
            UpdateCommand="SP_UpdateDoctor" UpdateCommandType="StoredProcedure">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="100" Name="DoctorId" QueryStringField="IDDoctor"
                    Type="Int32" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="CityID" Type="Int32" />
                <asp:Parameter Name="RegionID" Type="Int32" />
                <asp:Parameter Name="SectionID" Type="Int32" />
                <asp:Parameter Name="DoctorName" Type="String" />
                <asp:Parameter Name="VisitPlace" Type="Int32" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="Mobile" Type="String" />
                <asp:Parameter Name="HomePhone" Type="String" />
                <asp:Parameter Name="ClinicPhone" Type="String" />
                <asp:Parameter Name="Fax" Type="String" />
                <asp:Parameter Name="Personality" Type="String" />
                <asp:Parameter Name="address_details" Type="String" />
                <asp:Parameter Name="Doctor_Spec" Type="Int32" />
                <asp:Parameter Name="dgree_of_Corporation" Type="Int32" />
                <asp:Parameter Name="Doctor_level_by_work" Type="Int32" />
                <asp:Parameter Name="Work_in_hosiptal" Type="Int32" />
                <asp:Parameter Name="Street_Id" Type="Int32" />
                <asp:Parameter Name="WrittenToserver" Type="Int32" />
                <asp:Parameter Name="DoctorID" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>

جزاكم الله كل الخير