Wednesday, 20 June 2012

Bind DDL In Design page

<asp:DropDownList ID="ddlScreen" runat="server" CssClass="ddlOVT" DataSourceID="SQLDSScreen"
                                DataTextField="ScreenName" DataValueField="ScreenID" OnDataBound="ddlScreen_DataBound"
                                AutoPostBack="true" OnSelectedIndexChanged="ddlScreen_SelectedIndexChanged">
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SQLDSScreen" runat="server" ConnectionString="<%$ ConnectionStrings:SheetPlusConnectionString %>"
                                SelectCommand="SELECT [ScreenID], [ScreenName] FROM [t_SP_Screen] ORDER BY [OrderLevel]">
                            </asp:SqlDataSource>