Use jQuery Autocomplete with C#

294 256MB

Hi all. I am NOT good at writing .NET code, however I have a text box I am using for a search box. I found a great tutorial on it for vb.net, but I can't find out how to get that to c# (I tried a converter).

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Exercise2.WebForm1" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<link href="Scripts/themes/smoothness/jquery.ui.all.css" rel="stylesheet" type="text/css" />

<body>

       <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True">

        </asp:ScriptManager>

    <form id="form1" runat="server">

    <div>
 
        <br />

        <br />

        &nbsp;<asp:LoginView ID="LoginView1" runat="server">

            <AnonymousTemplate>

              <strong>  You are not logged in. Please click the login link.</strong>

            </AnonymousTemplate>

            <LoggedInTemplate>

                <strong> Welcome, </strong><asp:LoginName ID="LoginName1" runat="server" /> </strong>

            </LoggedInTemplate>

        </asp:LoginView>

        <asp:LoginStatus ID="LoginStatus1" runat="server" />

        <br />

        <br />

        <br />

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

        <asp:TextBox ID="SearchBox" runat="server" ClientIDMode=Static Width="682px"></asp:TextBox>

        <asp:Button ID="SearchBtn" runat="server" Text="Search Course" />

        <script src="Scripts/jquery-1.9.1.js" type="text/javascript"></script>

        <script src="Scripts/jquery-1.9.1.js" type="text/javascript"></script>

        <script src="Scripts/ui/1.9.1/jquery-ui.js" type="text/javascript"></script>

        <br />

        <br />

    </div>

    <p>

        &nbsp;</p>

    <p>

        <br />

    </p>

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 

        DataKeyNames="ID" DataSourceID="SqlDataSource1" 

        EmptyDataText="There are no data records to display.">

        <Columns>

            <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" 

                SortExpression="ID" />

            <asp:CheckBoxField DataField="txtBook" HeaderText="txtBook" 

                SortExpression="txtBook" />

            <asp:BoundField DataField="numQuiz" HeaderText="numQuiz" 

                SortExpression="numQuiz" />

            <asp:BoundField DataField="courseDesc" HeaderText="courseDesc" 

                SortExpression="courseDesc" />

            <asp:CheckBoxField DataField="courseReq" HeaderText="courseReq" 

                SortExpression="courseReq" />

            <asp:BoundField DataField="courseRating" HeaderText="courseRating" 

                SortExpression="courseRating" />

            <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />

            <asp:BoundField DataField="course_Num" HeaderText="course_Num" 

                SortExpression="course_Num" />

            <asp:CheckBoxField DataField="Attendence" HeaderText="Attendence" 

                SortExpression="Attendence" />

            <asp:BoundField DataField="Grade" HeaderText="Grade" SortExpression="Grade" />

        </Columns>

    </asp:GridView>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>" 

        DeleteCommand="DELETE FROM [Review_tbl] WHERE [ID] = @ID" 

        InsertCommand="INSERT INTO [Review_tbl] ([txtBook], [numQuiz], [courseDesc], [courseReq], [courseRating], [Date], [course_Num], [Attendence], [Grade]) VALUES (@txtBook, @numQuiz, @courseDesc, @courseReq, @courseRating, @Date, @course_Num, @Attendence, @Grade)" 

        ProviderName="<%$ ConnectionStrings:ASPNETDBConnectionString1.ProviderName %>" 

        SelectCommand="SELECT [ID], [txtBook], [numQuiz], [courseDesc], [courseReq], [courseRating], [Date], [course_Num], [Attendence], [Grade] FROM [Review_tbl]" 

        UpdateCommand="UPDATE [Review_tbl] SET [txtBook] = @txtBook, [numQuiz] = @numQuiz, [courseDesc] = @courseDesc, [courseReq] = @courseReq, [courseRating] = @courseRating, [Date] = @Date, [course_Num] = @course_Num, [Attendence] = @Attendence, [Grade] = @Grade WHERE [ID] = @ID">

        <DeleteParameters>

            <asp:Parameter Name="ID" Type="Int32" />

        </DeleteParameters>

        <InsertParameters>

            <asp:Parameter Name="txtBook" Type="Boolean" />

            <asp:Parameter Name="numQuiz" Type="Int32" />

            <asp:Parameter Name="courseDesc" Type="String" />

            <asp:Parameter Name="courseReq" Type="Boolean" />

            <asp:Parameter Name="courseRating" Type="Double" />

            <asp:Parameter DbType="Date" Name="Date" />

            <asp:Parameter Name="course_Num" Type="String" />

            <asp:Parameter Name="Attendence" Type="Boolean" />

            <asp:Parameter Name="Grade" Type="String" />

        </InsertParameters>

        <UpdateParameters>

            <asp:Parameter Name="txtBook" Type="Boolean" />

            <asp:Parameter Name="numQuiz" Type="Int32" />

            <asp:Parameter Name="courseDesc" Type="String" />

            <asp:Parameter Name="courseReq" Type="Boolean" />

            <asp:Parameter Name="courseRating" Type="Double" />

            <asp:Parameter DbType="Date" Name="Date" />

            <asp:Parameter Name="course_Num" Type="String" />

            <asp:Parameter Name="Attendence" Type="Boolean" />

            <asp:Parameter Name="Grade" Type="String" />

            <asp:Parameter Name="ID" Type="Int32" />

        </UpdateParameters>

    </asp:SqlDataSource>

    </form>

</body>

</html>

Can someone tell me what I'm doing wrong?
I am clueless. If you need any other information from me, please let me know!

Oct 31 '13 #1

Subscribe Post Reply

2382

Frinavale

9,735

Expert Mod 8TB

I haven't used this myself but probably will be using it in the near future.

Did you see the documentation for the jQuery Autocomplete Widget?

I just glanced over it and you can apply the widget to elements with a specified css class. You haven't done so on your search text box.

Also there are two ways you can supply the source to the auto complete widget: an array (JavaScript array) of strings or a function.

Which do you plan on using?

-Frinny

Oct 31 '13 #2

mcupito

294

256MB

I plan on using a field in the database I am connecting to.

Does anyone have any suggestions?

Nov 5 '13 #3

by: bytesFTW99 | last post by:

i have this, $(function() { $('#input').autocomplete('test.php', {json: true}); }); that bring back values from the database here is my php section

Javascript

autocomplete in a textarea

by: pradeepjain | last post by:

http://www.electrictoolbox.com/jquery-count-words-textarea-input/ hi guys i want to build a autocomplete feature in a textarea . so i thought of like when ever the word count increases call the...

Javascript

How to use jQuery's formatItem with autocomplete?

by: BaseballGraphs | last post by:

Hello, I am trying to format the output of my data with the autocomplete function from jQuery. So far, I've been able to build the entire process, however, I want to limit the information I show...

Javascript

How to use jQuery's formatItem, formatMatch, & formatResult options for autocomplete?

by: BaseballGraphs | last post by:

Hello, I am making use of jQuery's .autocomplete plugin, and I would appreciate some assistance formating the results that show up in the dropdown menu that populates when text is written into the...

Javascript

jQuery UI Autocomplete not passing correct querystring to ashx...

by: C Sharper | last post by:

Setup: I have a RadioButtonList with two listitems (One Street, the other Schools). These define what type of search I want. I textbox with associated autocomplete. First you select which search...

Javascript

How do i consolidate jQuery repetitive code

by: Vivekneo | last post by:

Hi, I have a series of textbox wired up with jQuery Autocomplete feature, there are 12 textbox in total. is thr any way to avoid repetitive code, Any help, i will be very thankful. ...

Javascript

How to apply autocomplete in gridview (in asp.net3.5 with C#) using jquery?

by: rhtdmrai | last post by:

I want to apply autocomplete in gridview (in asp.net3.5 with C#) using jquery and this gridview is within the ajax update panel <asp:UpdatePanel ID="UpdatePanel1" runat="server"> ...

.NET Framework

JQuery 1.8.3 body.append() not working in IE 6.0 and above

by: ravishankarsm | last post by:

I have used jquery-1.8.3.js package for appending a table to body. It works good in Mozilla Firefox and Google Chrome >> But Not in IE 6.0 and above >> API used is body.append({table content})....

Javascript

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Use jQuery Autocomplete with C#

Similar topics