<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <link href="~/_layouts/SelfReportingService/Style/TableStyle.css" rel="stylesheet" type="text/css" /> <link href="/_layouts/SelfReportingService/Style/jquery-ui.css" rel="stylesheet" type="text/css" /> <script src="/_layouts/SelfReportingService/Script/jquery-1.8.3.js" type="text/javascript" language="javascript"></script> <script src="/_layouts/SelfReportingService/Script/jquery-ui.js" type="text/javascript" language="javascript"></script> <script type='text/javascript' language="javascript"> ExecuteOrDelayUntilScriptLoaded(LoadList,"sp.js"); _spBodyOnLoadFunctionNames.push("LoadList"); function _spBodyOnLoad() { LoadList(); }; function LoadList() { var ds=null; var txtclientid='#<%=txtAutoFillSearchVal.ClientID%>'; ds = <%=listFilter %>; $( txtclientid ).autocomplete({ source: ds }); } </script> </head> <body> <form id="form1" runat="server"> <div> <asp:Table runat="server"> <asp:TableRow> <asp:TableCell runat="server"> Searcher </asp:TableCell> <asp:TableCell runat="server"> <asp:TextBox ID="txtAutoFillSearchVal" Width="250px" runat="server"></asp:TextBox> </asp:TableCell> <asp:TableCell> <asp:Button runat="server" Text="Search" /> </asp:TableCell> </asp:TableRow> </asp:Table> </div> </form> </body> </html>
public partial class Pages_SearchBox : System.Web.UI.Page { public string listFilter = null; protected void Page_Load(object sender, EventArgs e) { listFilter = BindName(); } private string BindName() { DataTable dt = null; using (SqlConnection conn = new SqlConnection("ConnectionString")) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = @"Exec [SSR].[AutoLoadsp] @enterpriseid='setup',@searchtype='Engagement',@columnType='Engagement Name'"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { dt = new DataTable(); da.Fill(dt); } } } StringBuilder output = new StringBuilder(); output.Append("["); for (int i = 0; i < dt.Rows.Count; ++i) { output.Append("\"" + dt.Rows[i]["SearchValue"].ToString() + "\""); if (i != (dt.Rows.Count - 1)) { output.Append(","); } } output.Append("];"); return output.ToString(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)