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. Search Page

Search Page

Scheduled Pinned Locked Moved ASP.NET
databasehelpjavascriptlearning
10 Posts 5 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.
  • S Offline
    S Offline
    scottichrosaviakosmos
    wrote on last edited by
    #1

    Please solve my issue . i want to develope a search form for which will search the values from a table and fetch the values from the table and show that value in the a gridview. now i am going t describe everything:. i have a table suppose tbl_update which having following coloums: tb_id int file_id int App_Type nvarchar(50) Role_id int Field_Name nvarchar(50) Old_Value nvarchar(50) New_Value nvarchar(50) Form_Name nvarchar(50) Cycle nvarchar(50) Date datetime(50) Now about the form: In the form i have 5 Dropdowns whose id's are: 1)ApplicationType ( should populate from App_Type coloum of table and appname should be distinct) 2)case name (should populate from File_id coloum of table) 3)Cycle (should populate from cycle coloum of table) 4)formName (should populate from form_name coloum of table) 5)fieldname (should have to populate from field_ name column of table) now the conditions are as : 1) when i click applicationtype dropdown then case name should be populated and value should change by selecting value of applicationtype dropdown, and also when i select cycle the case name should be changed and affected or should be populated. 2) Also when i select ApplicationType then the formname dropdownlist should be populated and then when i select formname dropdownlist then fieldname dropdown should be populated. And then when all dropdown is populated as by the mentioned condition above then there will be a button on the form named "SEARCH ", when clicking on the button search the searched value will be shown in a gridview. please help me in making database handling in this form , i mean if using stored procedure then help me in making that also .. i mean i want everything from scratch , since i dont know ohw to write a storedprocedure or query also and to write logical query. I Hope Someone can help me , since i am a fresher to programming and learning so finding very difficult to handle . i am attaching the snapshot of the database table so that a clear view can be made. Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever he/she finds suitable for validations can add that also. Please , this is very urgent.... hope will get support from members. Thank You.

    N M P 3 Replies Last reply
    0
    • S scottichrosaviakosmos

      Please solve my issue . i want to develope a search form for which will search the values from a table and fetch the values from the table and show that value in the a gridview. now i am going t describe everything:. i have a table suppose tbl_update which having following coloums: tb_id int file_id int App_Type nvarchar(50) Role_id int Field_Name nvarchar(50) Old_Value nvarchar(50) New_Value nvarchar(50) Form_Name nvarchar(50) Cycle nvarchar(50) Date datetime(50) Now about the form: In the form i have 5 Dropdowns whose id's are: 1)ApplicationType ( should populate from App_Type coloum of table and appname should be distinct) 2)case name (should populate from File_id coloum of table) 3)Cycle (should populate from cycle coloum of table) 4)formName (should populate from form_name coloum of table) 5)fieldname (should have to populate from field_ name column of table) now the conditions are as : 1) when i click applicationtype dropdown then case name should be populated and value should change by selecting value of applicationtype dropdown, and also when i select cycle the case name should be changed and affected or should be populated. 2) Also when i select ApplicationType then the formname dropdownlist should be populated and then when i select formname dropdownlist then fieldname dropdown should be populated. And then when all dropdown is populated as by the mentioned condition above then there will be a button on the form named "SEARCH ", when clicking on the button search the searched value will be shown in a gridview. please help me in making database handling in this form , i mean if using stored procedure then help me in making that also .. i mean i want everything from scratch , since i dont know ohw to write a storedprocedure or query also and to write logical query. I Hope Someone can help me , since i am a fresher to programming and learning so finding very difficult to handle . i am attaching the snapshot of the database table so that a clear view can be made. Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever he/she finds suitable for validations can add that also. Please , this is very urgent.... hope will get support from members. Thank You.

      N Offline
      N Offline
      NeverHeardOfMe
      wrote on last edited by
      #2

      Come on, you can be a little more Enterpriseing that that, can't you.. StarT rekoning these things out for yourself, eh... can I call you Scotty for short?

      L 1 Reply Last reply
      0
      • N NeverHeardOfMe

        Come on, you can be a little more Enterpriseing that that, can't you.. StarT rekoning these things out for yourself, eh... can I call you Scotty for short?

        L Offline
        L Offline
        led mike
        wrote on last edited by
        #3

        Phil Uribe wrote:

        Come on, you can be a little more Enterpriseing that that, can't you

        Rhetorical question? :laugh: I mean if he could then you wouldn't have the post to reply to right? ;)

        Phil Uribe wrote:

        can I call you Scotty for short?

        Wouldn't it make more sense to call someone Shorty for Short? :-\

        led mike

        N 1 Reply Last reply
        0
        • L led mike

          Phil Uribe wrote:

          Come on, you can be a little more Enterpriseing that that, can't you

          Rhetorical question? :laugh: I mean if he could then you wouldn't have the post to reply to right? ;)

          Phil Uribe wrote:

          can I call you Scotty for short?

          Wouldn't it make more sense to call someone Shorty for Short? :-\

          led mike

          N Offline
          N Offline
          NeverHeardOfMe
          wrote on last edited by
          #4

          You do get his name, don't you..? Try reading it carefully... I do know how to spell, by the way...

          L 1 Reply Last reply
          0
          • S scottichrosaviakosmos

            Please solve my issue . i want to develope a search form for which will search the values from a table and fetch the values from the table and show that value in the a gridview. now i am going t describe everything:. i have a table suppose tbl_update which having following coloums: tb_id int file_id int App_Type nvarchar(50) Role_id int Field_Name nvarchar(50) Old_Value nvarchar(50) New_Value nvarchar(50) Form_Name nvarchar(50) Cycle nvarchar(50) Date datetime(50) Now about the form: In the form i have 5 Dropdowns whose id's are: 1)ApplicationType ( should populate from App_Type coloum of table and appname should be distinct) 2)case name (should populate from File_id coloum of table) 3)Cycle (should populate from cycle coloum of table) 4)formName (should populate from form_name coloum of table) 5)fieldname (should have to populate from field_ name column of table) now the conditions are as : 1) when i click applicationtype dropdown then case name should be populated and value should change by selecting value of applicationtype dropdown, and also when i select cycle the case name should be changed and affected or should be populated. 2) Also when i select ApplicationType then the formname dropdownlist should be populated and then when i select formname dropdownlist then fieldname dropdown should be populated. And then when all dropdown is populated as by the mentioned condition above then there will be a button on the form named "SEARCH ", when clicking on the button search the searched value will be shown in a gridview. please help me in making database handling in this form , i mean if using stored procedure then help me in making that also .. i mean i want everything from scratch , since i dont know ohw to write a storedprocedure or query also and to write logical query. I Hope Someone can help me , since i am a fresher to programming and learning so finding very difficult to handle . i am attaching the snapshot of the database table so that a clear view can be made. Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever he/she finds suitable for validations can add that also. Please , this is very urgent.... hope will get support from members. Thank You.

            M Offline
            M Offline
            Mike Ellison
            wrote on last edited by
            #5

            Wow, that's really a lot of different things you are asking for, isn't it? Which one of those things are you currently working on and having some trouble? I think you'll have more success with better answers if you ask a specific question about a particular roadblock you're experiencing, rather than posting what amounts to a requirements document and asking someone to build it.

            1 Reply Last reply
            0
            • S scottichrosaviakosmos

              Please solve my issue . i want to develope a search form for which will search the values from a table and fetch the values from the table and show that value in the a gridview. now i am going t describe everything:. i have a table suppose tbl_update which having following coloums: tb_id int file_id int App_Type nvarchar(50) Role_id int Field_Name nvarchar(50) Old_Value nvarchar(50) New_Value nvarchar(50) Form_Name nvarchar(50) Cycle nvarchar(50) Date datetime(50) Now about the form: In the form i have 5 Dropdowns whose id's are: 1)ApplicationType ( should populate from App_Type coloum of table and appname should be distinct) 2)case name (should populate from File_id coloum of table) 3)Cycle (should populate from cycle coloum of table) 4)formName (should populate from form_name coloum of table) 5)fieldname (should have to populate from field_ name column of table) now the conditions are as : 1) when i click applicationtype dropdown then case name should be populated and value should change by selecting value of applicationtype dropdown, and also when i select cycle the case name should be changed and affected or should be populated. 2) Also when i select ApplicationType then the formname dropdownlist should be populated and then when i select formname dropdownlist then fieldname dropdown should be populated. And then when all dropdown is populated as by the mentioned condition above then there will be a button on the form named "SEARCH ", when clicking on the button search the searched value will be shown in a gridview. please help me in making database handling in this form , i mean if using stored procedure then help me in making that also .. i mean i want everything from scratch , since i dont know ohw to write a storedprocedure or query also and to write logical query. I Hope Someone can help me , since i am a fresher to programming and learning so finding very difficult to handle . i am attaching the snapshot of the database table so that a clear view can be made. Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever he/she finds suitable for validations can add that also. Please , this is very urgent.... hope will get support from members. Thank You.

              P Offline
              P Offline
              Paul Conrad
              wrote on last edited by
              #6

              scottichrosaviakosmos wrote:

              this is very urgent....

              That's considered to be rude here. Please don't do that again.

              scottichrosaviakosmos wrote:

              hope will get support from members.

              Folks help if they can.

              "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

              S 1 Reply Last reply
              0
              • N NeverHeardOfMe

                You do get his name, don't you..? Try reading it carefully... I do know how to spell, by the way...

                L Offline
                L Offline
                led mike
                wrote on last edited by
                #7

                Phil Uribe wrote:

                You do get his name, don't you..?

                Nope.

                Phil Uribe wrote:

                Try reading it carefully...

                I tried and failed :)

                Phil Uribe wrote:

                I do know how to spell, by the way...

                No idea why you said that, I didn't make any comments related to spelling. :-D

                led mike

                N 1 Reply Last reply
                0
                • L led mike

                  Phil Uribe wrote:

                  You do get his name, don't you..?

                  Nope.

                  Phil Uribe wrote:

                  Try reading it carefully...

                  I tried and failed :)

                  Phil Uribe wrote:

                  I do know how to spell, by the way...

                  No idea why you said that, I didn't make any comments related to spelling. :-D

                  led mike

                  N Offline
                  N Offline
                  NeverHeardOfMe
                  wrote on last edited by
                  #8

                  Oh good grief.. :-) ok, I'll spell it out for you... scottichrosaviakosmos scotti chrosa via kosmos scotty cross via cosmos Scotty crosses the cosmos Scotty = chief engineer on the Starship Enterprise, Star Trek hence I wrote: You can be more Enterpriseing than that, can't you.. StarT rekoning these things out for yourself, eh... can I call you Scotty for short god that was hard work! bedtime now...

                  1 Reply Last reply
                  0
                  • P Paul Conrad

                    scottichrosaviakosmos wrote:

                    this is very urgent....

                    That's considered to be rude here. Please don't do that again.

                    scottichrosaviakosmos wrote:

                    hope will get support from members.

                    Folks help if they can.

                    "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                    S Offline
                    S Offline
                    scottichrosaviakosmos
                    wrote on last edited by
                    #9

                    folks i was not asking for u to do allt this things , but since i am a fresher so i was expecting that i ll be getting help in steps , ie what to do and how to do . the first problem i m facing is to fetch tha data from table i dont know hoe to fetch and if somehow fetch then how to populate according to demand. but i m realy upset people making fun of my problem , but u people had also been freshers one stage , anyway, if u cannot help then please dont make fun of someone .

                    P 1 Reply Last reply
                    0
                    • S scottichrosaviakosmos

                      folks i was not asking for u to do allt this things , but since i am a fresher so i was expecting that i ll be getting help in steps , ie what to do and how to do . the first problem i m facing is to fetch tha data from table i dont know hoe to fetch and if somehow fetch then how to populate according to demand. but i m realy upset people making fun of my problem , but u people had also been freshers one stage , anyway, if u cannot help then please dont make fun of someone .

                      P Offline
                      P Offline
                      Paul Conrad
                      wrote on last edited by
                      #10

                      Well, it is not about you being a fresher or newbie, or whatever you want to call it. It is more about the approach you are using. If you are so new to this, the inquiry you are trying to take care of is really beyond beginner level.

                      "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                      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