AJAX TOOLKIT in ASP.NET 4.0 question ..?

A

ApurvA

New member
JAI MATADI .. .

hello .. i m working on AJAX TOOLKIT in ASP.NET 4.0 in which i m working on AUTOCOMPLETEEXTENDER

in this i want to fetch the "PERSON NAME" through SQL DATABASE in my "TextBox" as different suggestions if the person name/s is/are there as the user writes anything in that "TextBox"

but when i m running my webpage .. m getting no prob with my written code .. everything goin well but yet i m not able to get anything after typing something similar name which i stored in my database ..

i have used "WEBSERVICE" in this and here is my code ..

---------------------------------------------------------
form.aspx
--------------------------

<form id="form1" runat="server">
<div>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>

Enter Name : <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" ServiceMethod="GetProducts" ServicePath="~/WebService.asmx" TargetControlID="TextBox1">
</asp:AutoCompleteExtender>
</div>
</form>
------------------------------------------------


---------------------------------------------------------
webservice.asmx
--------------------
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Web.Script.Services;


public string[] GetProducts(string prefixText)
{
string sql = "Select * from Table1 Where pname like @prefixText";

SqlDataAdapter da = new SqlDataAdapter(sql, @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Chandrik Tools\My Documents\Visual Studio 2010\WebSites\ajax toolkit websites\App_Data\Database.mdf;Integrated Security=True;User Instance=True");

da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText + "%";

DataTable dt = new DataTable();

da.Fill(dt);

string[] items = new string[dt.Rows.Count];

int i = 0;

foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["pname"].ToString(), i);
i++;
}
return items;
}

}

---------------------------------------------------------


i have tried this in IE and MOZILLA browsers but nothing happening ..

is there anything wrong in my code or whtt ..
i have also tried this code instead of above ..

public String[] GetProducts(string prefixText)
{
string sql = "Select * from Table1 Where pname like @prefixText";
SqlDataAdapter da = new SqlDataAdapter(sql, @"my database connection string");
da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText + "%";
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["pname"].ToString(), i);
i++;
}
return items;
}

}

-------------------------------

but still the same .. m getting no name suggestions :(
 
Back
Top