Hi mod7609,
I have created a sample which full fill your requirement you need to modify the code according to your need.
SQL
CREATE TABLE Computers(Items VARCHAR(50),GPU INT,CPU INT,[H.D.D] INT,RAM INT,Screen INT)
INSERT INTO Computers VALUES('Game computer',10,8,5,8,10)
INSERT INTO Computers VALUES('Office computer',3,4,4,3,3)
INSERT INTO Computers VALUES('Design computer',9,7,6,6,9)
INSERT INTO Computers VALUES('Home computer',3,3,3,3,3)
HTML
<div>
please select which one of devices are important for you to choose a computer, then
we suggest you which model is better for you :<br />
<br />
Please select based on the priority.<br />
<br />
first priority is
<asp:DropDownList ID="ddlFirstPriority" class="dropDown" runat="server">
<asp:ListItem Value="5" Text="GPU"></asp:ListItem>
<asp:ListItem Value="5" Text="HDD"></asp:ListItem>
<asp:ListItem Value="5" Text="SCREEN"></asp:ListItem>
<asp:ListItem Value="5" Text="RAM"></asp:ListItem>
<asp:ListItem Value="5" Text="CPU"></asp:ListItem>
</asp:DropDownList>
<asp:HiddenField ID="hfFirstPriority" runat="server" />
<br />
<br />
second priority is
<asp:DropDownList ID="ddlSecondPriority" class="dropDown" runat="server">
<asp:ListItem Value="4" Text="GPU"></asp:ListItem>
<asp:ListItem Value="4" Text="HDD"></asp:ListItem>
<asp:ListItem Value="4" Text="SCREEN"></asp:ListItem>
<asp:ListItem Value="4" Text="RAM"></asp:ListItem>
<asp:ListItem Value="4" Text="CPU"></asp:ListItem>
</asp:DropDownList>
<asp:HiddenField ID="hfsecondPriority" runat="server" />
<br />
<br />
third priority is
<asp:DropDownList ID="ddlThirdPriority" class="dropDown" runat="server">
<asp:ListItem Value="3" Text="GPU"></asp:ListItem>
<asp:ListItem Value="3" Text="HDD"></asp:ListItem>
<asp:ListItem Value="3" Text="SCREEN"></asp:ListItem>
<asp:ListItem Value="3" Text="RAM"></asp:ListItem>
<asp:ListItem Value="3" Text="CPU"></asp:ListItem>
</asp:DropDownList>
<asp:HiddenField ID="hfThirdPriority" runat="server" />
<br />
<br />
forth priority is
<asp:DropDownList ID="ddlFourthPriority" class="dropDown" runat="server">
<asp:ListItem Value="2" Text="GPU"></asp:ListItem>
<asp:ListItem Value="2" Text="HDD"></asp:ListItem>
<asp:ListItem Value="2" Text="SCREEN"></asp:ListItem>
<asp:ListItem Value="2" Text="RAM"></asp:ListItem>
<asp:ListItem Value="2" Text="CPU"></asp:ListItem>
</asp:DropDownList>
<asp:HiddenField ID="hfFourthPriority" runat="server" />
<br />
<br />
fifth priority is
<asp:DropDownList ID="ddlFifthPriority" class="dropDown" runat="server">
<asp:ListItem Value="1" Text="GPU"></asp:ListItem>
<asp:ListItem Value="1" Text="HDD"></asp:ListItem>
<asp:ListItem Value="1" Text="SCREEN"></asp:ListItem>
<asp:ListItem Value="1" Text="RAM"></asp:ListItem>
<asp:ListItem Value="1" Text="CPU"></asp:ListItem>
</asp:DropDownList>
<asp:HiddenField ID="hfFifthPriority" runat="server" />
<br />
<br />
<asp:Button ID="btnSuggest" OnClick="Suggest" runat="server" Text="SUBMIT TO SHOW SUFFICIENT MODEL" />
<asp:Label ID="lblErrorMessage" runat="server" />
<br />
<br />
<asp:GridView ID="gvComputers" runat="server" />
</div>
<div>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
$(function () {
$('[id*=btnSuggest]').click(function () {
$('[id*=hfFirstPriority]').val($('[id*=ddlFirstPriority] option:selected').text());
$('[id*=hfsecondPriority]').val($('[id*=ddlSecondPriority] option:selected').text());
$('[id*=hfThirdPriority]').val($('[id*=ddlThirdPriority] option:selected').text());
$('[id*=hfFourthPriority]').val($('[id*=ddlFourthPriority] option:selected').text());
$('[id*=hfFifthPriority]').val($('[id*=ddlFifthPriority] option:selected').text());
});
});
</script>
</div>
C#
protected void Suggest(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = "SELECT Items,((" + hfFirstPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*5)+(" + hfsecondPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*4)+(" + hfThirdPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*3)+(" + hfFourthPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*2)+(" + hfFifthPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*1)) AS Suggest FROM Computers ORDER BY Suggest DESC";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
gvComputers.DataSource = dt;
gvComputers.DataBind();
}
VB.Net
Protected Sub Suggest(sender As Object, e As EventArgs)
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Dim query As String = "SELECT Items,((" + hfFirstPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*5)+(" + hfsecondPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*4)+(" + hfThirdPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*3)+(" + hfFourthPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*2)+(" + hfFifthPriority.Value.ToUpper().Replace("HDD", "[H.D.D]") + "*1)) AS Suggest FROM Computers ORDER BY Suggest DESC"
Dim con As New SqlConnection(constr)
Dim cmd As New SqlCommand(query, con)
Dim sda As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
sda.Fill(dt)
gvComputers.DataSource = dt
gvComputers.DataBind()
End Sub
ScreenShot
