Click here to Skip to main content
15,897,371 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Sending mail in ASP.NET Pin
Waleed Eissa11-Aug-08 1:25
Waleed Eissa11-Aug-08 1:25 
GeneralRe: Sending mail in ASP.NET Pin
Christian Graus11-Aug-08 1:52
protectorChristian Graus11-Aug-08 1:52 
Questionautocomplete extender Pin
eyeseetee10-Aug-08 23:11
eyeseetee10-Aug-08 23:11 
AnswerRe: autocomplete extender Pin
Blue_Boy10-Aug-08 23:22
Blue_Boy10-Aug-08 23:22 
GeneralRe: autocomplete extender Pin
eyeseetee10-Aug-08 23:29
eyeseetee10-Aug-08 23:29 
GeneralRe: autocomplete extender Pin
Blue_Boy10-Aug-08 23:33
Blue_Boy10-Aug-08 23:33 
GeneralRe: autocomplete extender Pin
eyeseetee10-Aug-08 23:47
eyeseetee10-Aug-08 23:47 
GeneralRe: autocomplete extender [modified] Pin
Blue_Boy10-Aug-08 23:51
Blue_Boy10-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."

GeneralRe: autocomplete extender Pin
eyeseetee11-Aug-08 0:53
eyeseetee11-Aug-08 0:53 
GeneralRe: autocomplete extender Pin
eyeseetee11-Aug-08 0:54
eyeseetee11-Aug-08 0:54 
Questiondatalist problem Pin
umeshdaiya10-Aug-08 22:36
umeshdaiya10-Aug-08 22:36 
AnswerRe: datalist problem Pin
nyeboy11-Aug-08 0:11
nyeboy11-Aug-08 0:11 
GeneralRe: datalist problem Pin
umeshdaiya11-Aug-08 1:12
umeshdaiya11-Aug-08 1:12 
Questiontitle bar+form name Pin
niki_nilu10-Aug-08 22:20
niki_nilu10-Aug-08 22:20 
AnswerRe: title bar+form name Pin
umeshdaiya10-Aug-08 22:52
umeshdaiya10-Aug-08 22:52 
AnswerRe: title bar+form name Pin
Blue_Boy11-Aug-08 0:06
Blue_Boy11-Aug-08 0:06 
QuestionWhich is a best way to create Bloggings in the site. Pin
coolsatty10-Aug-08 21:47
coolsatty10-Aug-08 21:47 
AnswerRe: Which is a best way to create Bloggings in the site. Pin
Christian Graus10-Aug-08 22:06
protectorChristian Graus10-Aug-08 22:06 
AnswerRe: Which is a best way to create Bloggings in the site. Pin
nyeboy11-Aug-08 0:09
nyeboy11-Aug-08 0:09 
Questionquality of the image Pin
pavni200410-Aug-08 21:26
pavni200410-Aug-08 21:26 
AnswerRe: quality of the image Pin
K V Sekhar10-Aug-08 21:37
K V Sekhar10-Aug-08 21:37 
AnswerRe: quality of the image Pin
eyeseetee10-Aug-08 21:46
eyeseetee10-Aug-08 21:46 
AnswerRe: quality of the image Pin
Christian Graus10-Aug-08 22:03
protectorChristian Graus10-Aug-08 22:03 
GeneralRe: quality of the image Pin
pavni200410-Aug-08 22:35
pavni200410-Aug-08 22:35 
GeneralRe: quality of the image Pin
Christian Graus10-Aug-08 22:45
protectorChristian Graus10-Aug-08 22:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.