Sunday, June 10, 2012

ASP.NET Dropdown item selected as my given value

if we want set the selected item of a drop down box from my given value we can use follow the code. here i am taking a gridview value and set it as selected item of the drop down. cosider the image

aspx :

Wing Dropdown :
 <asp:DropDownList ID="regionWingDropDownList" runat="server" Height="30px" Width="217px"  
           DataValueField="WingId" DataTextField="WingName" AutoPostBack="True" Style="margin-top: 0px"  

Division Dropdown

 <asp:DropDownList ID="regionDivisionDropDownList" runat="server" Height="30px" DataValueField="DivisionId"  
           DataTextField="DivisionName" Width="217px">  

Region Gridview

 <asp:GridView ID="regionGridView" runat="server" Width="457px"   
              <asp:BoundField DataField="RegionId" HeaderText="ID" />  
             <asp:BoundField DataField="RegionCode" HeaderText="Region Code" />  
             <asp:BoundField DataField="RegionName" HeaderText="Region Name" />  
             <asp:BoundField DataField="WingId" />  
             <asp:BoundField DataField="Wingname" HeaderText="Wing Name" />  
             <asp:BoundField DataField="DivisionId" />  
             <asp:BoundField DataField="DivisionName" HeaderText="Division Name" />  
             <asp:CommandField ShowSelectButton="True" />  

Code behind :

  protected void regionGridView_SelectedIndexChanged(object sender, EventArgs e)  
       if (regionGridView.SelectedIndex>-1)  
// setting value on dropdown
         for (int i = 0; i < regionWingDropDownList.Items.Count; i++)  
           ListItem wing = regionWingDropDownList.Items[i];  
           if (wing.Text == regionGridView.SelectedRow.Cells[4].Text)  
             regionWingDropDownList.SelectedIndex = i;  
         for (int i = 0; i < regionDivisionDropDownList.Items.Count; i++)  
           ListItem division = regionDivisionDropDownList.Items[i];  
           if (division.Text == regionGridView.SelectedRow.Cells[6].Text)  
             regionDivisionDropDownList.SelectedIndex = i;  
         regionCodeTextBox.Text = regionGridView.SelectedRow.Cells[1].Text;  
         regionNameTextBox.Text = regionGridView.SelectedRow.Cells[2].Text;  
         regionIdLabel.Text = regionGridView.SelectedRow.Cells[0].Text;  
         regionSaveButton.Text = "update";  

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link.