TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Davin Martyn
NA
7.5k
3m
Problem with AutoCompleteExtender control?
Jun 18 2012 3:23 AM
Hello Sir i am working in ajax and use AutoCompleteExtender control with WebService. I want to output in single TextBox like when we write A word then all "a" type related record show.
MyWebService:
[WebMethod]
public static List<string> Record (string s)
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection("database=asha;server=.;integrated security=true");
SqlCommand cmd = new SqlCommand("select* from manish WHERE Name LIKE '" + s + "%' ", con);
cmd.Parameters.AddWithValue("@Name", s);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
List<string> name = new List<string>();
for (int i = 1; i < dt.Rows.Count; i++)
{
name.Add(dt.Rows[i][0].ToString());
}
return name;
}
}
Default.aspx code;
<
asp
:
ScriptManager
ID
="ScriptManager1"
runat
="server">
<
Services
>
<
asp
:
ServiceReference
Path
="~/WebService.asmx"
/>
</
Services
>
</
asp
:
ScriptManager
>
<
div
>
<
asp
:
TextBox
ID
="TextBox1"
runat
="server"></
asp
:
Te
<
asp
:
AutoCompleteExtender
ID
="AutoCompleteExtender1"
runat
="server"
TargetControlID
="TextBox1"
ServiceMethod
="Record"
ServicePath
="~/WebService.asmx"
MinimumPrefixLength
="1"
EnableCaching
="true"
CompletionSetCount
="1"
CompletionInterval
="1000"
>
</
asp
:
AutoCompleteExtender
>
</
div
>
When we run the program then only textbox show and write any word then no related record find.
Reply
Answers (
3
)
What are the Frameworks for .Net?
CalenderExtender Was not showing all dates.