<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sqlConstr %>" SelectCommand="SELECT * FROM [Servers]"></asp:SqlDataSource>
<asp:DropDownList ID="ddlServer" runat="server" CssClass="dropdownlistLarge" Font-Size="10"
AutoPostBack="true" OnSelectedIndexChanged="ddlServer_SelectedIndexChanged" DataTextField="Server_Name"
DataValueField="Server_ID" DataSourceID="SqlDataSource1">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:sqlConstr %>" SelectCommand="SELECT * FROM [Services]"></asp:SqlDataSource>
<asp:DropDownList ID="ddlService" runat="server" CssClass="dropdownlistLarge" OnSelectedIndexChanged="ddlService_SelectedIndexChanged" AutoPostBack="true" Font-Size="10"
DataSourceID="SqlDataSource2" DataTextField="Service_Name"
DataValueField="Service_ID"></asp:DropDownList>
These are my two dropdownlist where in if i select ddlServer i should get list of Services applicable in a format like
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlConstr %>"
SelectCommand="SELECT Service_ID,Service_Name from Services where Applicable_Servers like '%1,%' ">
</asp:SqlDataSource>
and if second dropdownlist ddlService then i should get list of applicable servers
so how can i write select index code for this and this listview values to bind to my main table