<asp:GridView ID="GridView1" runat="server" CellPadding="1"
DataSourceID="TreatResult" Width="568px" AllowPaging="True" BackColor="White" BorderColor="RoyalBlue" BorderStyle="None" BorderWidth="1px" Height="301px" HorizontalAlign="Center">
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<Columns>
<asp:BoundField DataField="Hospital_Name" HeaderText="Hospital_Name" SortExpression="Hospital_Name" />
<asp:BoundField DataField="Country_Name" HeaderText="Country_Name" SortExpression="Country_Name" />
<asp:BoundField DataField="City_Name" HeaderText="City_Name" SortExpression="City_Name" />
<asp:BoundField DataField="URL" HeaderText="URL" SortExpression="URL" />
</Columns>
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<PagerStyle BackColor="AliceBlue" ForeColor="#003399" HorizontalAlign="Left" />
<HeaderStyle BackColor="AliceBlue" Font-Bold="True" ForeColor="RoyalBlue" />
</asp:GridView>
<asp:SqlDataSource ID="TreatResult" runat="server" ConnectionString="<%$ ConnectionStrings:OTA_DBConnectionString %>"
SelectCommand="SELECT Hospital_Specialization.Hospital_Name, Partener.Country_Name, Partener.City_Name, Partener.URL FROM Hospital_Specialization INNER JOIN Hospital ON Hospital_Specialization.Hospital_Name = Hospital.Hospital_Name INNER JOIN Partener ON Hospital.Hospital_Name = Partener.Partenter_Name WHERE (Hospital_Specialization.Specialest_Name = '{0}') ORDER BY Hospital_Specialization.Score DESC">
<FilterParameters>
<asp:ControlParameter Name="Specialest_Name" ControlID="DropDownList11" PropertyName="SelectedValue"/>
</FilterParameters>
</asp:SqlDataSource>أنا عندي DropDownList11" راح يختار منها اليوزر بعدين راح تطلع النتيجة بــGridView
عندي 3 جداول أبغى أربط بينهم الي هي
partneral
Hospit
Hospit_specialization
بحيث تحقق الشرط
Selected value.Hospital_Specialization.Specialest_Name =DropDownList11.selected value
المشكله عندي إن قيمة الالباراميتر الي راح يختارها ماتضبط بالتالي يطلع الــ GridView فاضي
