Click here to Skip to main content
15,889,281 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Dropdown Pin
Tripat Bala Singh10-Oct-13 17:33
Tripat Bala Singh10-Oct-13 17:33 
RantIE and time to vent Pin
L Viljoen9-Oct-13 0:21
professionalL Viljoen9-Oct-13 0:21 
GeneralRe: IE and time to vent Pin
Richard MacCutchan9-Oct-13 0:50
mveRichard MacCutchan9-Oct-13 0:50 
Questionhow to split an excel workbook into two in C# Pin
antony beula8-Oct-13 21:23
antony beula8-Oct-13 21:23 
AnswerRe: how to split an excel workbook into two in C# Pin
Richard MacCutchan8-Oct-13 23:24
mveRichard MacCutchan8-Oct-13 23:24 
Questionhey frnds help me out . Pin
Mr.VJ8-Oct-13 21:06
Mr.VJ8-Oct-13 21:06 
AnswerRe: hey frnds help me out . Pin
thatraja8-Oct-13 21:12
professionalthatraja8-Oct-13 21:12 
Questioni have prblrm in ajex auto complite text box need help plz Pin
eng.mohamed ali8-Oct-13 13:33
eng.mohamed ali8-Oct-13 13:33 
1 - i make text box with auto complicate extended
2- i pot my connection string

"
XML
<connectionStrings>
        <add name="conn" connectionString="Data Source=.;Initial Catalog=Tranning;Integrated Security=True" providerName="System.Data.SqlClient"/>
        <add name="tempdbConn" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\tempdb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>

"
and i make method

C#
[System.Web.Script.Services.ScriptMethod()]
        [System.Web.Services.WebMethod]
        public static List<string> SearchCustomers(string prefixText, int count)
        {
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager
                        .ConnectionStrings["conn"].ConnectionString;
                using (SqlCommand cmd = new SqlCommand())
                {
                    //cmd.CommandText = "select ContactName from Customers where " +
                    //"ContactName like @SearchText + '%'";
                    cmd.CommandText = "select No_Trainee from Annual_Plan where No_Trainee like @SearchText + '%' ";
                    cmd.Parameters.AddWithValue("@SearchText", prefixText);
                    cmd.Connection = conn;
                    conn.Open();
                    List<string> customers = new List<string>();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            customers.Add(sdr["No_Trainee"].ToString());
                        }
                    }
                    conn.Close();
                    return customers;
                }
            }
        }


and still my text Box not get values from database


Please need help !!!
QuestionRe: i have prblrm in ajex auto complite text box need help plz Pin
Deflinek10-Oct-13 3:25
Deflinek10-Oct-13 3:25 
QuestionAsp.net Identity MVC5 + Nhibernate Pin
roscez7-Oct-13 6:47
roscez7-Oct-13 6:47 
QuestionProblem reading from sql server view Pin
Member 93288477-Oct-13 6:24
Member 93288477-Oct-13 6:24 
AnswerRe: Problem reading from sql server view Pin
Richard Deeming7-Oct-13 7:22
mveRichard Deeming7-Oct-13 7:22 
GeneralRe: Problem reading from sql server view Pin
Member 93288479-Oct-13 15:39
Member 93288479-Oct-13 15:39 
QuestionEncrypting Parameter value from Right Click Source Code Pin
alok00007-Oct-13 0:13
alok00007-Oct-13 0:13 
QuestionHow to bind multiple rows from data table to single row in Gridview Pin
priyaahh6-Oct-13 23:14
priyaahh6-Oct-13 23:14 
Questionhow to increase performance Pin
antony beula6-Oct-13 21:36
antony beula6-Oct-13 21:36 
AnswerRe: how to increase performance Pin
thatraja6-Oct-13 22:54
professionalthatraja6-Oct-13 22:54 
AnswerRe: how to increase performance Pin
ais076-Oct-13 23:00
ais076-Oct-13 23:00 
SuggestionRe: how to increase performance Pin
Richard Deeming7-Oct-13 1:44
mveRichard Deeming7-Oct-13 1:44 
QuestionHow call secure web service using Jquery Pin
ais076-Oct-13 19:41
ais076-Oct-13 19:41 
QuestionPrincipalContext & UserPrincipal Pin
JD866-Oct-13 19:22
JD866-Oct-13 19:22 
QuestionHey Friends..plz help me out... Pin
Member 103122576-Oct-13 18:57
Member 103122576-Oct-13 18:57 
AnswerRe: Hey Friends..plz help me out... Pin
Member 103122576-Oct-13 18:59
Member 103122576-Oct-13 18:59 
AnswerRe: Hey Friends..plz help me out... Pin
Blikkies6-Oct-13 20:27
professionalBlikkies6-Oct-13 20:27 
AnswerRe: Hey Friends..plz help me out... Pin
ais076-Oct-13 20:39
ais076-Oct-13 20:39 

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.