ASP.NET

10-Aug-08 23:11

Hi
I have used the following tutorial to create an autocomplete extender.
The problem is, it is not working. When I type text in the box nothing happens.
Is there something missing from the exampl code I have used.
I'm not sure where the string value gets filled which is shown in the tuturial.
Any help would be great
thanks!

http://www.aspdotnetcodes.com/AutoComplete_From_Database.aspx

Blue_Boy10-Aug-08 23:22

10-Aug-08 23:22

I think problem is in webservice.I had case like you and when I added third line (of lines down below) it worked.
Try this:

[WebService(Namespace = "http://tempuri.org/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
[System.Web.Script.Services.ScriptService]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

eyeseetee10-Aug-08 23:29

10-Aug-08 23:29

Thanks for the reply, but that didnt work.
Below is my code for extender control

<asp:textbox id="tb_description" runat="server" xmlns:asp="#unknown">
<atlas:autocompleteextender id="AutoCompleteExtender1" minimumprefixlength="1" runat="server" xmlns:atlas="#unknown">
<atlas:autocompleteproperties targetcontrolid="tb_description" servicemethod="GetactdescInfo" servicepath="~/autocomplete.asmx" enabled="True">

Is there anything wrong with that?

Blue_Boy10-Aug-08 23:33

10-Aug-08 23:33

this work for me and I am using in VS.NET 2005

<asp:ScriptManager id="ScriptManager1" runat="server"><br />
    </asp:ScriptManager><br />
    <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtTo"<br />
     ServicePath="WebService.asmx" Enabled="true" MinimumPrefixLength="1" ServiceMethod="MethodNameFromWebService"><br />
    </cc1:AutoCompleteExtender>

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

eyeseetee10-Aug-08 23:47

Re: autocomplete extender [modified]

10-Aug-08 23:47

OK, well there must be a problem with the web service then
The code is displayed below.When I type text in the box nothing appears
thanks

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class autocomplete : System.Web.Services.WebService {
[WebMethod(EnableSession = true)]
public string[] GetactdescInfo(string prefixText)
{

int count = 10;
string project = HttpContext.Current.Session["project"].ToString();
SqlConnection connectionString = new SqlConnection(ConfigurationManager.ConnectionStrings[project].ConnectionString);
connectionString.Open();
string sql = " SELECT description" +
" FROM act" +
" WHERE description like '" + prefixText + "' ";

//string description_condition = " AND description LIKE '%" + prefixText + "%'";
//sql += description_condition;

SqlDataAdapter dataAdapter1 = new SqlDataAdapter(sql, connectionString);
dataAdapter1.SelectCommand.Parameters.Add("@prefixText", SqlDbType.NVarChar, 2000).Value = prefixText + "%";
DataTable datatable1 = new DataTable();
dataAdapter1.Fill(datatable1);

string[] items = new string[datatable1.Rows.Count];
int i = 0;
foreach (DataRow datarow in datatable1.Rows)
{
items.SetValue(datarow["description"].ToString(), i);
i++;
}
return items;
}

}

Blue_Boy10-Aug-08 23:51

10-Aug-08 23:51

.netman wrote:
" WHERE description like '" + prefixText + "' ";

try to add precentage sign:

" WHERE description like '" + prefixText + "%' "

My webservice which works:

<%@ WebService Language="C#" Class="WebService" %><br />
<br />
using System;<br />
using System.Web;<br />
using System.Web.Services;<br />
using System.Web.Services.Protocols;<br />
<br />
[WebService(Namespace = "http://tempuri.org/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
[System.Web.Script.Services.ScriptService] <br />
<br />
public class WebService  : System.Web.Services.WebService {<br />
<br />
    [WebMethod]<br />
    public string[] GetUserName(string prefixText)<br />
    {<br />
<br />
        System.Data.DataSet dtst = new System.Data.DataSet();<br />
<br />
        System.Data.SqlClient.SqlConnection sqlCon = new System.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=BussinesTube;Integrated Security=True");<br />
<br />
        string strSql = "SELECT name+' ' +lastname +' ; < '+ username + ' > 'as [name] from users WHERE [name] LIKE '%" + prefixText + "%' ";<br />
<br />
        System.Data.SqlClient.SqlCommand sqlComd = new System.Data.SqlClient.SqlCommand(strSql, sqlCon);<br />
<br />
        sqlCon.Open();<br />
<br />
        System.Data.SqlClient.SqlDataAdapter sqlAdpt = new System.Data.SqlClient.SqlDataAdapter();<br />
<br />
        sqlAdpt.SelectCommand = sqlComd;<br />
<br />
        sqlAdpt.Fill(dtst);<br />
<br />
        string[] cntName = new string[dtst.Tables[0].Rows.Count];<br />
<br />
        int i = 0;<br />
<br />
        try<br />
        {<br />
<br />
            foreach (System.Data.DataRow rdr in dtst.Tables[0].Rows)<br />
            {<br />
<br />
                cntName.SetValue(rdr["Name"].ToString(), i);<br />
<br />
                i++;<br />
<br />
            }<br />
<br />
        }<br />
<br />
        catch { }<br />
<br />
        finally<br />
        {<br />
<br />
            sqlCon.Close();<br />
<br />
        }<br />
<br />
        return cntName;<br />
<br />
    }<br />
<br />
<br />
    <br />
}

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

eyeseetee11-Aug-08 0:53

11-Aug-08 0:53

Hi thanks for the response.
I have added that and it still doesnt work.
Should there be any additonal lines in my c# code for the page the textbox is on?

eyeseetee11-Aug-08 0:54

11-Aug-08 0:54

When does prefixtext get set?

datalist problem

umeshdaiya10-Aug-08 22:36

umeshdaiya

10-Aug-08 22:36

hi i am new user of asp.net using c#
problem is that i use a mater page which fill a datalist in iframe tag so open a new page and then goes to second page now when i click a datalist link button then i open a new mater page but that page is open on same td of mater page how i show a new page. every time when i clik on linkbutton its open in new datalist as a child of that form. while i want its open in a seprate page.
thanks in advance reply soon.

Re: datalist problem

nyeboy11-Aug-08 0:11

nyeboy

11-Aug-08 0:11

You try to open if in a parent page.

studing is processing in this life.

Re: datalist problem

umeshdaiya11-Aug-08 1:12

umeshdaiya

11-Aug-08 1:12

i understood what is the problem.
problem is that i am using iframe control but if i not use ifrmae than all value are comeout from my div tag what i use insted of iframe
thanks

title bar+form name

niki_nilu10-Aug-08 22:20

niki_nilu

10-Aug-08 22:20

hello
i am using master form.
and so how to write webform name on internet exlorer title bar.
pls help me.
gayatri

Gayatri

Re: title bar+form name

umeshdaiya10-Aug-08 22:52

umeshdaiya

10-Aug-08 22:52

when u insert a form using mater page then u should chnge the <title>your web page name
example

]]>

i think its helpful for u.

Re: title bar+form name

Blue_Boy11-Aug-08 0:06