Question with Ajax AutoCompleteExtender

Question

0.00/5 (No votes)

See more:

I have 2 textbox's first one called txtCountry and the second one called txtRegion work with AutoCompleteExtender to fetching data from database when you type any country or any region so the problem is i want to fetch only the region when the text box country = country in the database but the method that i use it doesn't take the txtCountry.text in the parameter and also i got error i will put it .

In database:
there are 2 tables called , Country and Region

and Country table related with Region as primary key table

This is page code:

ASP.NET

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication2.WebForm1" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<!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>
    <link href="Style/StyleSheet.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:ScriptManager ID="ScriptManager1" runat="server"
EnablePageMethods = "true">
</asp:ScriptManager>
 
        <asp:TextBox ID="txtCountry" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ServiceMethod="SearchCountry"
    MinimumPrefixLength="2"
    CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
    TargetControlID="txtCountry"
    ID="AutoCompleteExtender1"  runat="server" FirstRowSelected = "false"   CompletionListCssClass="autocomplete_completionListElement"
  CompletionListItemCssClass="autocomplete_listItem"
  CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</cc1:AutoCompleteExtender>
<br />
<br />
        <asp:TextBox ID="txtRegion" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ServiceMethod="SearchRegion"
    MinimumPrefixLength="2"
    CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
    TargetControlID="txtRegion"
    ID="AutoCompleteExtender2"  runat="server" FirstRowSelected = "false"   CompletionListCssClass="autocomplete_completionListElement"
  CompletionListItemCssClass="autocomplete_listItem"
  CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</cc1:AutoCompleteExtender>
    </div>
    </form>
</body>
</html>

And this is the C# code with 2 methods called SearchCountry and SearchRegion:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace WebApplication2
{
    public partial class WebForm1 : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        [System.Web.Script.Services.ScriptMethod()]
        [System.Web.Services.WebMethod]
        public static List<string> SearchCountry(string prefixText, int count)
        {
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager
                        .ConnectionStrings["Jobs_DBConnectionString"].ConnectionString;
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = "select * from Country where " +
                    "Country like @SearchCountry + '%'";
                    cmd.Parameters.AddWithValue("@SearchCountry", prefixText);
                    cmd.Connection = conn;
                    conn.Open();
                    List<string> Countries = new List<string>();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            Countries.Add(sdr["Country"].ToString());
                        }
                    }
                    conn.Close();
                    return Countries;
                }
            }
        }

        [System.Web.Script.Services.ScriptMethod()]
        [System.Web.Services.WebMethod]
        public static List<string> SearchRegion(string prefixText,int count)
        {
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager
                        .ConnectionStrings["Jobs_DBConnectionString"].ConnectionString;
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = "select * from Reigon where Country = @Country AND " +
                    "Reigon like @SearchRegion + '%'";
                    cmd.Parameters.AddWithValue("@Country", txtCountry.text);
                    cmd.Parameters.AddWithValue("@SearchRegion", prefixText);
                    cmd.Connection = conn;
                    conn.Open();
                    List<string> Reigons = new List<string>();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            Reigons.Add(sdr["Reigon"].ToString());
                        }
                    }
                    conn.Close();
                    return Reigons;
                }
            }
        }
    }
}

The error:
Error 1 An object reference is required for the non-static field, method, or property 'WebApplication2.WebForm1.txtCountry' C:\Users\Abdul\Documents\Visual Studio 2010\Projects\WebApplication2\WebApplication2\WebForm1.aspx.cs 62 61 WebApplication2

Posted 31-Oct-13 5:56am

Abdulmohsen Alshaya

Updated 31-Oct-13 5:59am

v2

Add a Solution

7 solutions

Solution 1

C#

conn.ConnectionString = ConfigurationManager.ConnectionStrings["Jobs_DBConnectionString"].ConnectionString;

You are trying to access an object in a static method. To make this work in a static method, try passing the connection string as a parameter.

Posted 31-Oct-13 11:28am

Foothill

Solution 2

hi
i tried to make it like that but the second method wont work . but the probelm was in this line of code

C#

cmd.Parameters.AddWithValue("@Country", txtCountry.text);

i can not access to txtCountry

i don't think it's from the connection string

thank you

Posted 2-Nov-13 4:43am

Abdulmohsen Alshaya

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Nov-13 7:42am

Please delete this as this is not an answer. If you want to comment to any answer, then click on Have a Question or Comment in that answer box itself.

Solution 3

You should consider passing the textbox text value as a parameter in your static webmethod since accessing the textbox.Text needs to be an instance method.

So you can add one for parameter into your static method as

C#

public static List<string> SearchRegion(string prefixText,int count,string Country)
{
....
}

By the way its txtCountry.Text not txtCountry.text

Hope this helps

Posted 2-Nov-13 21:53pm

JoCodes

Updated 2-Nov-13 21:55pm

v2

Solution 4

hi
i did this but then nothing showing in txtRegion because string Country parameter is null.i think it has to take a value from txtCountry.

thank you

Posted 3-Nov-13 1:20am

Abdulmohsen Alshaya

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Nov-13 7:42am

Please delete this as this is not an answer. If you want to comment to any answer, then click on Have a Question or Comment in that answer box itself.

Solution 6

Thank you so much
finally get it to work ... can i add third parameter ??? lets see

Posted 3-Nov-13 2:45am

Abdulmohsen Alshaya

Solution 7

hi
i tried to add the third parameter but i can't. do you have any idea ??

Posted 3-Nov-13 3:53am

Abdulmohsen Alshaya

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-11-03T01:56:00

Solution 5

You have to send additional parameters to the Static Method using UseContextKey = "true".

See the Example - ASP.NET AJAX AUTOCOMPLETEEXTENDER: PASS ADDITIONAL PARAMETER TO WEBMETHOD USING CONTEXTKEY[^]

Posted 3-Nov-13 1:56am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)