Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Please Help

Please Help

Scheduled Pinned Locked Moved ASP.NET
databasehelptutorial
3 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Malay1986
    wrote on last edited by
    #1

    Hello to all. I have one textbox which has a facility of autocomplete and the autocomplete criteria comes from the database. example: if i enter "a" in textbox the words starting from "a" appear in the listbox below the textbox.Now i have done coding in such a way that if i press enter in the listbox then the word in the listbox is filled in the textbox and the listbox disappears. sql tables used: Table1: AID int, AName varchar(50) Table2: Aid int, ADescription varchar(200) The text displayed in the listbox is AName. I want to display the no. of records of ADescription having Aid that has Aname from Table1. I want to display that records as soon as the value in the listbox is selected.In which event should i write the code. Please help me.

    P 1 Reply Last reply
    0
    • M Malay1986

      Hello to all. I have one textbox which has a facility of autocomplete and the autocomplete criteria comes from the database. example: if i enter "a" in textbox the words starting from "a" appear in the listbox below the textbox.Now i have done coding in such a way that if i press enter in the listbox then the word in the listbox is filled in the textbox and the listbox disappears. sql tables used: Table1: AID int, AName varchar(50) Table2: Aid int, ADescription varchar(200) The text displayed in the listbox is AName. I want to display the no. of records of ADescription having Aid that has Aname from Table1. I want to display that records as soon as the value in the listbox is selected.In which event should i write the code. Please help me.

      P Offline
      P Offline
      Parwej Ahamad
      wrote on last edited by
      #2

      You need write the code on post back of control mean set the auto postback true property of textbox. Each post back of text box get the record from the database via Like clause of select statement. Or you can use Ajax for implement it.

      Parwej Ahamad g.parwez@gmail.com

      M 1 Reply Last reply
      0
      • P Parwej Ahamad

        You need write the code on post back of control mean set the auto postback true property of textbox. Each post back of text box get the record from the database via Like clause of select statement. Or you can use Ajax for implement it.

        Parwej Ahamad g.parwez@gmail.com

        M Offline
        M Offline
        Malay1986
        wrote on last edited by
        #3

        Thanks. But i have used the textbox of html(input type="text") and i am using javascript function.Through javascript function i am passing value of textbox to the other aspx page and from there through querystring that value is fetched and then select query is fired. What should i do?

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups