Comments by khushi mamtora

khushi mamtora 16-Mar-12 4:26am View

No, m not getting any error! Is there any alternative? I need to have a control like this. any other solution?

khushi mamtora 14-Mar-12 0:55am View

the cursor is not going into webservice file....

khushi mamtora 13-Mar-12 3:26am View

its still not working!
nothing happens when I enter text in textbox.

khushi mamtora 13-Mar-12 1:59am View

Yes, I have! I checked it 2 times!
data is in currect formate!
i tried it with new application also.

khushi mamtora 13-Mar-12 1:52am View

There is my code Can you help now?

khushi mamtora 13-Mar-12 1:27am View

I did it. Bus Still not working sir!
Nothing happens when i write in text box!

khushi mamtora 13-Mar-12 1:13am View

sir, its not working. Do I send you my code?
M not able to find error.
Would you be able to?

<asp:TextBox ID="txt_search" runat="server" Width="250px">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

<asp:AutoCompleteExtender CompletionInterval="100" Enabled="true" CompletionSetCount="1"
MinimumPrefixLength="1" TargetControlID="txt_search" ID="AutoSuggestion" runat="server"
ServicePath="~/Lib_BookSearch.asmx" ServiceMethod="AutoDescription">

public string[] AutoDescription(string pretext)
{
SqlConnection cn=new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\khushboo\sem 6\running NEW on C59\LIVE\App_Data\libdata.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand("select des from Table1 where des LIKE @pretext", cn);
cn.Open();
cmd.Parameters.AddWithValue("@pretext", pretext);
cmd.ExecuteNonQuery();

cn.Close();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.SelectCommand.Parameters.Add("@pretext", SqlDbType.VarChar, 50).Value = pretext + "%";
adp.Fill(ds);
string[] arr = new string[ds.Tables[0].Rows.Count];
for (int i = 0; i < arr.Length; i++)
arr[i] = ds.Tables[0].Rows[i][0].ToString();
return arr;
}

Comments by khushi mamtora (Top 7 by date)