[ajaxpro] Re: unable to implement AutoComplete example...?

Fri, 08 Sep 2006 01:56:26 -0700


hey kevin
i m sending u d exact code bt u hav to alter it acc to ur requirement and in web service do change the elements of string array acc to ur requirement hope it helps u out. hey do let me knw if it helped u.

 
On 9/7/06, Kevin <[EMAIL PROTECTED]> wrote:

thanks to both of you for the replys...   I am extremely frustrated
like Jon in that I cannot get this working in mmy application.
Harpreet - Id love to look at any sample code you have working as Any
means to a possible solution would be fantastic...


Does anyone else have example code for the autocomplete that works?  Or
can see a problem with my code above?  If I can get these issues
resolved I'd like to post a "complete" copy of the code so other could
use it...

Michael S. - can you see anything wrong with my implementation?


thanks -
Kevin



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ajax.NET Professional" group.

To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]

For more options, visit this group at http://groups.google.com/group/ajaxpro

The latest downloads of Ajax.NET Professional can be found at http://www.ajaxpro.info/

Don't forget to read my blog at http://weblogs.asp.net/mschwarz/
-~----------~----~----~----~------~----~------~--~---

Attachment: AutoCompleteService.asmx
Description: application/xml

Attachment: Web.config
Description: application/xml

Attachment: Default.aspx
Description: application/xml

using System;
using System.Data;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page
{
    Class1 c1 = new Class1();
    protected void Page_Load(object sender, EventArgs e)
    {
       // SqlDataSource1.SelectCommand = "select user_name from tblContestant 
where user_id='" + txtEmailId.Text + "'";
    }


    protected void txtEmailId_TextChanged(object sender, EventArgs e)
    {
        System.Data.SqlClient.SqlConnection con = new 
System.Data.SqlClient.SqlConnection("server=10.10.1.100;uid=sa;pwd=anetcorp!!;database=OnlineContest_Development");
        System.Data.SqlClient.SqlDataAdapter adp = new 
System.Data.SqlClient.SqlDataAdapter("select 
User_Name,Phone,Address,Organization from tblContestant where User_ID='" + 
txtEmailId.Text + "'", con);
        System.Data.DataSet ds = new System.Data.DataSet();
        adp.Fill(ds, "pp");
        if (ds.Tables[0].Rows.Count > 0)
        {
            lblError.Text = "";
            lblNameData.Text = ds.Tables[0].Rows[0][0].ToString();
            lblPhoneData.Text = ds.Tables[0].Rows[0][1].ToString();
            lblAddData.Text = ds.Tables[0].Rows[0][2].ToString();
            lblInsComData.Text = ds.Tables[0].Rows[0][3].ToString();
        }
        else
        {
            lblNameData.Text = "";
            lblPhoneData.Text = "";
            lblAddData.Text = "";
            lblInsComData.Text = "";
            lblError.Text = "Invalid User ID";

        }
    }



    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }
}

Reply via email to