I need to implement a simple search function to lookup order information in
a SQLserver table. The code below works fine for a search to the ³OrderID²
column. However, I¹d like to offer the user the ability to select 3 possible
columns to search from. I added a dropdownlist to select the column. My
question is, how do I dynamically modify the SQL command <String selectCmd =
"select * from Orders where OrderID = @OrderID";> to take the input from the
dropdownlist?
Also, can I assign a different Value to <asp:listitem>O rder
ID</asp:listitem> than ³Order ID²? I¹d like to display the parameter with a
space but have its Value = OrderID (no space) since that¹s the column name
in the SQL table.
Thank you,
Stephan.
<%@ Page Language="C#" ContentType="te xt/html" ResponseEncodin g="iso-8859-1"
%>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.SqlClie nt" %>
<html>
<script language="C#" runat="server">
public void GetOrder(Object sender, EventArgs E)
{
String selectCmd = "select * from Orders where OrderID = @OrderID";
SqlConnection myConnection = new SqlConnection(" server =
'LMM-MB-DATA,25886';Dat abase = 'Oligo_Order'; Trusted_Connect ion=Yes");
SqlDataAdapter myCommand = new SqlDataAdapter( selectCmd,
myConnection);
myCommand.Selec tCommand.Parame ters.Add(new SqlParameter("@ OrderID",
SqlDbType.NVarC har));
myCommand.Selec tCommand.Parame ters["@OrderID"].Value =
SearchString.Te xt;
DataSet ds = new DataSet();
myCommand.Fill( ds, "Orders");
MyDataGrid.Data Source= ds.Tables["Orders"].DefaultView;
MyDataGrid.Data Bind();
}
</script>
<body style="font: 10pt verdana">
<form runat="server">
<p> Search previously placed order by:
<asp:dropdownli st ID="SearchSelec t" runat="server">
<asp:listitem>O rder ID</asp:listitem>
<asp:listitem>L ast name</asp:listitem>
<asp:listitem>C omments</asp:listitem>
</asp:dropdownlis t>
<asp:textbox id="SearchStrin g" MaxLength="50" runat="server"
TextMode="Singl eLine" />
</p>
<input type="submit" OnServerClick=" GetOrder" Value="Get Orders"
runat="server"/><p>
<ASP:DataGrid id="MyDataGrid " runat="server"
Width="700"
BackColor="#ccc cff"
BorderColor="bl ack"
ShowFooter="fal se"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaa add"
EnableViewState ="false"
/>
</form>
</body>
</html>
