Thursday, June 7, 2012

ASP.NET Dropdown box event fire

Normally Dropdown box is not fire event. to fire any event of dropdown box you need to write the AutoPostBack="True" property in dropdown control.

ASPX File:

  <asp:DropDownList ID="regionWingDropDownList" runat="server" Height="30px" Width="217px"  
           DataValueField="WingId" DataTextField="WingName" AutoPostBack="True"  
           style="margin-top: 0px"   
           onselectedindexchanged="regionWingDropDownList_SelectedIndexChanged"   
          >  
         </asp:DropDownList>  

Codebehind:
 protected void regionWingDropDownList_SelectedIndexChanged(object sender, EventArgs e)  
     {  
       Wing wing = new Wing();  
       wing.WingId = Convert.ToInt32(regionWingDropDownList.SelectedItem.Value);  
       regionDivisionDropDownList.DataSource = _regionManagerObj.GetSelectedWingAllDiviSionName(wing);  
       regionDivisionDropDownList.DataBind();  
     }  

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...