usef.e1364
سه شنبه 11 بهمن 1390, 10:04 صبح
با سلام.
بچه ها من ميخوام كاربر يكي از مقادير دلخواه را از dropdown انتخاب كرده(نام، كد، شماره دفترچه) و بر اساس انتخابش، مقدار مورد نظر را در textbox تايپ كرده و جستجو كند.
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVgAAABECAIAAAB LbbpDAAAM80lEQVR4nO2da1MaWRrH/QrzMVbuBrzES9BJZnZra+bF7geYyput2po3W7tVm6sXNEbjLYk KihcyWzNJjAaNoCJeMqOJ0E13I8bA6CTGMKlIokjF+6Ub2Rftd JBLi41ADM+v/i+a0885z/HhnH8jid0pPgAAkp6URE8AAIDEA0YAAAAYAQAAYATRU9xuBMVB iX6fP3PACKIF1mgcgCLHGjCCaKHX6MuFnZ6Jdb15ox/ZMlg2DJaNQWxzCF8ftW79bNv+2bb9dHrLMrMz9dq74KESPeWTB xhBrAEjiBZ6jRrRtRHr7vg0NeGgkBkSmSEts17rC69tjpp67Z1 67X3upH5b2HMu7k299iZ6yicPMIJYA0YQLfQaHcLXR6y7j23U+ DQ1QctOoTMUbQfWF96pV96ZN9RvC3uWmZ1ET/nIpKSkpKQkcqnEwQi+EMtjGv+JA0YQLfQaHcHXRqy7w1Yvo8c2 CrGT6AxFi3hB0Z8Lnk5vJXrKkZJykOhH49w3ciPgvD/BCICoYIxgiKCGCMpIkN+cLx8iqGGrF3GQtL45X26Z9VrnvLY56 mfbdqKnfAj0jo3GAiLpwmQJ6BKyb7IZAT14PL0GjCBaGCMwEiT tArSMBDls9aIzFNNCvKCIF9SoNfGfCCLcqJyv4dFc/KM0As7EzQi+EMv9+9Ivj2XPRzMUGEG0MN8RGAnSQFAD1o9eMDb 98dgy47XMeNEZahDbTPSUQ2w2/5aAY/bgkO3BI4TsEjJpnI2A2TYR7h/2+IDG4BiW7ty2cbhpHHUoMIJooddoP7rWT+wOWMkBKznqt/9pTdgpRn1I4o3AF7TfwhnBocEh21m2PYvjsPQ9FiMIuA6HO+Ac z9KLZRwOfY86jUgAI4gWeo3qkY1ebFc3STL66AIOitH4NNVr/hyMIGTMoUYQSdJj/I6A5fr8qRlB8AWcsxFw++0AjCBa6DWqQ9Z7sN0egtRPUYZpyjB NDT2nvjlfPm6n9jVNjU9Tj22U9kmCjSCFE5EMciwpYmoE/p+ZQ+69kDEh41mMgP2TeUAW/8hw2dnnE3KoowJGEC30Gu01rWnRnR6C1E2SA1PkwBRpmKZGp8n HNorW2DPysY0aIj5RI/BvD46JZByWs+HyBiRlwoJzcfvV4NBrbCw46ncNiZ0GAxhBtNBr 9NHEajeypUV3erFdHUHqCHKAII2T5Ih1l5HRShqwna6x9URP+e TB+TuC6C+VR80V0BJuPiG7x3ByhwFGEC30Gp19s/loYrXXtKZD1vXIBq1BdNWIrjEaRFcNppUXbz6t/0eQEvQdHofusQb+i3GsASOIFlijcQCKHGvACKIl4X+onyRK9Pv 8mQNGAAAAGAEAAGAEAAD4wAgAAPCBEQAA4AMjAADAB0YAAIAPj AAAAB8YAQAAPjACAAB8YAQAAPjACAAA8IERAADgAyMAAMB3vEZ AkuT29vZmQtne3iZJ8hh/KABIBo7BCDY3N1dXVz0ez9LSksvlWkgoLpdrcXHR4/GsrKxsbGzs7e1F/wMCwGdPVEZAUdTq6urc7wt3ntiv6qzf3bNkt2IhldmIpNebs5r DBnBXC5apQtPrzfTL7+5jV3WEenQSt//mcrk+fPiwu7t7XMUCgM8V7kaws7Pj8XiMky//qsHy24kCTWjltxPyVjxHieaq0HBh+e2EvA2Xt+J5aiy3yZKrQn ObLHlqTN6Ky9twlsELNES+hpC34blNloCMZ5uRZiP++vVrt9u9 sbFxjCUDgM8PjkZAUZTH47k99Cy/CfvqjvXP/5sMp69/mDzbiuc3Y+c0YcPOtRMFaiy/CctvshwUVqDGzrUTX/8QdnxmhJAZ/9VNzM7OLi0t7ezE6mHkCb+HV5IoRm8fQMPFCPb29lZWVoan5s4 o0fxmy7k71q9+CKuzGkLeZAkXdk5DFLRgZ1SovMmSr8a+bMPPa ghaX7YT+WpM3mShT53VEOfCZ/EfPCBjoxF/9eqVx+Pxer3HXj4f3FczLkCRYw0XI9jc3Hz5+9u/tKA5jYi8FSu4Q3wZXvI2PEeJnGkJEVagIc6oLTlKJK8JlbfhBR rCP6bgDlGgIfLb8LxmS64KzWtC89vxcLkKwmc8p8FG0cmFhYW1 tbVjL58P1mhcgCLHGi5GsLKyono8fboBOd2InGnD8zVEOMk1RG 6zJTtUmLydyGvBshuRHBV6pg2Xhx9B3k7kqrFsJZrTZJG3h83F krFUj/3666/Ly8vHXj4frNG4AEWONUc2gr29veXl5X934pm3zaeVaG4LlteGh 1UrfroRyWpAQoS14lkNSFa9ObcFy2vdb8lrxXNbsI8tfsHZSjS rAclRB52KIOM/OvBnz54tLS3FooKwRuMAFDnWHNkISJJcXFz8exuSfsucrcZyWv Cc1vBqwTPqkYx6JDjsdDOWcduc2YAwLdlqLEuJZjYgmY3o6SZL QJfsZiyjHslsQLLV2FEznm3DJicn3717F4sKwhqNA8lc5Pg8Cu 3IRrC9ve1yuaQ3TbJ6c5Yay2phU6baIr1tDhmZoUSlt0zpSnS/RY3J6s3SmybpTZP0lkl6y5TegGQ2Wz52UWPpjYj0tvlAY8QZcR xfWFiIRQWTeY3GjWQociTPWWcJiNIvjmwEm5ubCwsLaTcnZCo0 Q21hV3ozeuqW6dQtU3pz4ClpI5J2c0LWiOy3NFuk9ea0mxPSer OsETl125R2c0LKnFVbMtQWmQo90OUoGcEITjTJUGTORnAscDWC uqcypTm9CWGXTIWk1T1Nq3siUwWektabJLVPTtWbHPPO9CbEMe +UqRCZ0ixTIekqRNpoltQ+Sat7mu7XUaY0S2qfnLo1wSEjGMGJ JpmLHOETltlbDoWjEZxqmJCpTIdLaZLUjUtqxqTKwFOnGibENW OSunFZ0CmZyiRtnJDUjklqD3SUKk2S2rBd2DOCEZxokq3I/tuY3QiYlywHkcDRCASlD4Vlh8gx73TMO/lXO1Iv/CQo6aRfOuad9FmBoiv1wt0//fcnQXEn08hIUNKZevEu79I9JpFj3ilQdKVevMu7fC9gqAAxGf0 bwQhONElYZJb9HNImEmMEomvd7HLMO5mD1Av3+IWdorKPp4SlW se8k1/YmXrhHu/ifce8U6jQisq6aQkVWse8k3fxvqCw038coULLu3iff/WB/1D+uWgJSx4GZBSVdYMRnGiSociHXupZItmtIRK4GIHL5cqv1Yn Ke1jkmHcyB7zLHbzLHYKSh/yiLv7VB/TFnHe5g3epI/Xi/dQL9x3zTt6lDv7VTkFRl6Coi3flgWPeyb/yQFja7T+OUKHlXeoQFHf5Z2ECGAlLuwMyiq50gBGcaJKhyOxGQ O92Zs8HvPRv8cXnO4Ld3d13796dbzOKK3rZxXyAj51C5hVdeyQ ofsi7/IDRtzW9BEG4XK6j/rCRkAxrNOEkYZHj848FDEc2Aq/X63a7r/c8EVfqD1XAvuUXaQWKnuD9LAxqFJY+2t/qfwwiKj/gLAFZmGPRdZ1A0cO7+pB3pYt3pYvO+J8fR6emphYXF2NRwSRco/EnqYrM4XoePVz+1uDDhw+jlilplV58oy+k/Hcsr1DLL9Tyi7S8Qq1A0SO6HqpXZZ+oQi+6rhOWPRIUd/MKtbxCrbBcJ6rQiyv3YwSlj/hFWuG1XnFlmLyVfaIKvUDRE5zxzuBTu90Of2twcoEixxouRrC+ vv727dtr3eOSqoGQ8vsI0CMo7hFX9Ikr+oSKXkFxj2PeKa7sD9 dRUjUgudEvut4nKOrhF/UIy3Tiyv79luJHQkUvS19xZb+wTBec8Z+aEavV6nQ6V1ZWjr18 PlijcQGKHGu4GIHX6/V4PHNzc39TD0uqBwNVNSiuNAjL9PziXmGpXlxpkFQZJFWD4soB QYlOUKITlfeLbxgkVUEd/+guqTLQwfziXmGZXlTeL1TohAqduGIgbK/qwZAZ5ZV9YyZ0dnbW7XbH6KamsEbjABQ51nC8Q9HOzs7S0tLUt P3SgzFJjfGAqgeF1/r5JTqBQi++MejXbhRXGoRlfQKFXljWJ640SKoHA/v6SXzDIFDo+SU6foluf3tXhw2W1BiDM37/4y9jZvT58+cul2t9ff14C8eQ8Fv3JIli9PYBNNzvWbi2tra4uP jy5cuHv1i+vzv2bfNIWt1wWu2wuMooKO0TlvVLqofSaofT6vxU OyypHhJVGIRl/cKyftF1em8PSWqG0vwkqRmSVA+JbwwKr/ULFHqBQi+qMEhqhg4MFSQm47fNI9/fHbtjNFmt1tnZWfoWpnA7YwBgIaq7GG9tbXk8njdv3tjtdpvNR hAE/glAEITNZrPb7U6n0+12r6+vgwsAADvRPteAvqP58vLy+/fvE/5QA4b379+73W64lzkARAg88gwAADACAADACAAA8IERAADgAyMA AMAHRgAAgA+MAAAAn8/3f3ezmPi7k6WEAAAAAElFTkSuQmCC
كوئري اش را اينجوري نوشتم ولي جواب نميده:
create procedure srch2(@input nvarchar(40),@input2 nvarchar(40))
as
select *
from tbl_Inf
where @input=@input2
بچه ها من ميخوام كاربر يكي از مقادير دلخواه را از dropdown انتخاب كرده(نام، كد، شماره دفترچه) و بر اساس انتخابش، مقدار مورد نظر را در textbox تايپ كرده و جستجو كند.
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVgAAABECAIAAAB LbbpDAAAM80lEQVR4nO2da1MaWRrH/QrzMVbuBrzES9BJZnZra+bF7geYyput2po3W7tVm6sXNEbjLYk KihcyWzNJjAaNoCJeMqOJ0E13I8bA6CTGMKlIokjF+6Ub2Rftd JBLi41ADM+v/i+a0885z/HhnH8jid0pPgAAkp6URE8AAIDEA0YAAAAYAQAAYATRU9xuBMVB iX6fP3PACKIF1mgcgCLHGjCCaKHX6MuFnZ6Jdb15ox/ZMlg2DJaNQWxzCF8ftW79bNv+2bb9dHrLMrMz9dq74KESPeWTB xhBrAEjiBZ6jRrRtRHr7vg0NeGgkBkSmSEts17rC69tjpp67Z1 67X3upH5b2HMu7k299iZ6yicPMIJYA0YQLfQaHcLXR6y7j23U+ DQ1QctOoTMUbQfWF96pV96ZN9RvC3uWmZ1ET/nIpKSkpKQkcqnEwQi+EMtjGv+JA0YQLfQaHcHXRqy7w1Yvo8c2 CrGT6AxFi3hB0Z8Lnk5vJXrKkZJykOhH49w3ciPgvD/BCICoYIxgiKCGCMpIkN+cLx8iqGGrF3GQtL45X26Z9VrnvLY56 mfbdqKnfAj0jo3GAiLpwmQJ6BKyb7IZAT14PL0GjCBaGCMwEiT tArSMBDls9aIzFNNCvKCIF9SoNfGfCCLcqJyv4dFc/KM0As7EzQi+EMv9+9Ivj2XPRzMUGEG0MN8RGAnSQFAD1o9eMDb 98dgy47XMeNEZahDbTPSUQ2w2/5aAY/bgkO3BI4TsEjJpnI2A2TYR7h/2+IDG4BiW7ty2cbhpHHUoMIJooddoP7rWT+wOWMkBKznqt/9pTdgpRn1I4o3AF7TfwhnBocEh21m2PYvjsPQ9FiMIuA6HO+Ac z9KLZRwOfY86jUgAI4gWeo3qkY1ebFc3STL66AIOitH4NNVr/hyMIGTMoUYQSdJj/I6A5fr8qRlB8AWcsxFw++0AjCBa6DWqQ9Z7sN0egtRPUYZpyjB NDT2nvjlfPm6n9jVNjU9Tj22U9kmCjSCFE5EMciwpYmoE/p+ZQ+69kDEh41mMgP2TeUAW/8hw2dnnE3KoowJGEC30Gu01rWnRnR6C1E2SA1PkwBRpmKZGp8n HNorW2DPysY0aIj5RI/BvD46JZByWs+HyBiRlwoJzcfvV4NBrbCw46ncNiZ0GAxhBtNBr 9NHEajeypUV3erFdHUHqCHKAII2T5Ih1l5HRShqwna6x9URP+e TB+TuC6C+VR80V0BJuPiG7x3ByhwFGEC30Gp19s/loYrXXtKZD1vXIBq1BdNWIrjEaRFcNppUXbz6t/0eQEvQdHofusQb+i3GsASOIFlijcQCKHGvACKIl4X+onyRK9Pv 8mQNGAAAAGAEAAGAEAAD4wAgAAPCBEQAA4AMjAADAB0YAAIAPj AAAAB8YAQAAPjACAAB8YAQAAPjACAAA8IERAADgAyMAAMB3vEZ AkuT29vZmQtne3iZJ8hh/KABIBo7BCDY3N1dXVz0ez9LSksvlWkgoLpdrcXHR4/GsrKxsbGzs7e1F/wMCwGdPVEZAUdTq6urc7wt3ntiv6qzf3bNkt2IhldmIpNebs5r DBnBXC5apQtPrzfTL7+5jV3WEenQSt//mcrk+fPiwu7t7XMUCgM8V7kaws7Pj8XiMky//qsHy24kCTWjltxPyVjxHieaq0HBh+e2EvA2Xt+J5aiy3yZKrQn ObLHlqTN6Ky9twlsELNES+hpC34blNloCMZ5uRZiP++vVrt9u9 sbFxjCUDgM8PjkZAUZTH47k99Cy/CfvqjvXP/5sMp69/mDzbiuc3Y+c0YcPOtRMFaiy/CctvshwUVqDGzrUTX/8QdnxmhJAZ/9VNzM7OLi0t7ezE6mHkCb+HV5IoRm8fQMPFCPb29lZWVoan5s4 o0fxmy7k71q9+CKuzGkLeZAkXdk5DFLRgZ1SovMmSr8a+bMPPa ghaX7YT+WpM3mShT53VEOfCZ/EfPCBjoxF/9eqVx+Pxer3HXj4f3FczLkCRYw0XI9jc3Hz5+9u/tKA5jYi8FSu4Q3wZXvI2PEeJnGkJEVagIc6oLTlKJK8JlbfhBR rCP6bgDlGgIfLb8LxmS64KzWtC89vxcLkKwmc8p8FG0cmFhYW1 tbVjL58P1mhcgCLHGi5GsLKyono8fboBOd2InGnD8zVEOMk1RG 6zJTtUmLydyGvBshuRHBV6pg2Xhx9B3k7kqrFsJZrTZJG3h83F krFUj/3666/Ly8vHXj4frNG4AEWONUc2gr29veXl5X934pm3zaeVaG4LlteGh 1UrfroRyWpAQoS14lkNSFa9ObcFy2vdb8lrxXNbsI8tfsHZSjS rAclRB52KIOM/OvBnz54tLS3FooKwRuMAFDnWHNkISJJcXFz8exuSfsucrcZyWv Cc1vBqwTPqkYx6JDjsdDOWcduc2YAwLdlqLEuJZjYgmY3o6SZL QJfsZiyjHslsQLLV2FEznm3DJicn3717F4sKwhqNA8lc5Pg8Cu 3IRrC9ve1yuaQ3TbJ6c5Yay2phU6baIr1tDhmZoUSlt0zpSnS/RY3J6s3SmybpTZP0lkl6y5TegGQ2Wz52UWPpjYj0tvlAY8QZcR xfWFiIRQWTeY3GjWQociTPWWcJiNIvjmwEm5ubCwsLaTcnZCo0 Q21hV3ozeuqW6dQtU3pz4ClpI5J2c0LWiOy3NFuk9ea0mxPSer OsETl125R2c0LKnFVbMtQWmQo90OUoGcEITjTJUGTORnAscDWC uqcypTm9CWGXTIWk1T1Nq3siUwWektabJLVPTtWbHPPO9CbEMe +UqRCZ0ixTIekqRNpoltQ+Sat7mu7XUaY0S2qfnLo1wSEjGMGJ JpmLHOETltlbDoWjEZxqmJCpTIdLaZLUjUtqxqTKwFOnGibENW OSunFZ0CmZyiRtnJDUjklqD3SUKk2S2rBd2DOCEZxokq3I/tuY3QiYlywHkcDRCASlD4Vlh8gx73TMO/lXO1Iv/CQo6aRfOuad9FmBoiv1wt0//fcnQXEn08hIUNKZevEu79I9JpFj3ilQdKVevMu7fC9gqAAxGf0 bwQhONElYZJb9HNImEmMEomvd7HLMO5mD1Av3+IWdorKPp4SlW se8k1/YmXrhHu/ifce8U6jQisq6aQkVWse8k3fxvqCw038coULLu3iff/WB/1D+uWgJSx4GZBSVdYMRnGiSociHXupZItmtIRK4GIHL5cqv1Yn Ke1jkmHcyB7zLHbzLHYKSh/yiLv7VB/TFnHe5g3epI/Xi/dQL9x3zTt6lDv7VTkFRl6Coi3flgWPeyb/yQFja7T+OUKHlXeoQFHf5Z2ECGAlLuwMyiq50gBGcaJKhyOxGQ O92Zs8HvPRv8cXnO4Ld3d13796dbzOKK3rZxXyAj51C5hVdeyQ ofsi7/IDRtzW9BEG4XK6j/rCRkAxrNOEkYZHj848FDEc2Aq/X63a7r/c8EVfqD1XAvuUXaQWKnuD9LAxqFJY+2t/qfwwiKj/gLAFZmGPRdZ1A0cO7+pB3pYt3pYvO+J8fR6emphYXF2NRwSRco/EnqYrM4XoePVz+1uDDhw+jlilplV58oy+k/Hcsr1DLL9Tyi7S8Qq1A0SO6HqpXZZ+oQi+6rhOWPRIUd/MKtbxCrbBcJ6rQiyv3YwSlj/hFWuG1XnFlmLyVfaIKvUDRE5zxzuBTu90Of2twcoEixxouRrC+ vv727dtr3eOSqoGQ8vsI0CMo7hFX9Ikr+oSKXkFxj2PeKa7sD9 dRUjUgudEvut4nKOrhF/UIy3Tiyv79luJHQkUvS19xZb+wTBec8Z+aEavV6nQ6V1ZWjr18 PlijcQGKHGu4GIHX6/V4PHNzc39TD0uqBwNVNSiuNAjL9PziXmGpXlxpkFQZJFWD4soB QYlOUKITlfeLbxgkVUEd/+guqTLQwfziXmGZXlTeL1TohAqduGIgbK/qwZAZ5ZV9YyZ0dnbW7XbH6KamsEbjABQ51nC8Q9HOzs7S0tLUt P3SgzFJjfGAqgeF1/r5JTqBQi++MejXbhRXGoRlfQKFXljWJ640SKoHA/v6SXzDIFDo+SU6foluf3tXhw2W1BiDM37/4y9jZvT58+cul2t9ff14C8eQ8Fv3JIli9PYBNNzvWbi2tra4uP jy5cuHv1i+vzv2bfNIWt1wWu2wuMooKO0TlvVLqofSaofT6vxU OyypHhJVGIRl/cKyftF1em8PSWqG0vwkqRmSVA+JbwwKr/ULFHqBQi+qMEhqhg4MFSQm47fNI9/fHbtjNFmt1tnZWfoWpnA7YwBgIaq7GG9tbXk8njdv3tjtdpvNR hAE/glAEITNZrPb7U6n0+12r6+vgwsAADvRPteAvqP58vLy+/fvE/5QA4b379+73W64lzkARAg88gwAADACAADACAAA8IERAADgAyMA AMAHRgAAgA+MAAAAn8/3f3ezmPi7k6WEAAAAAElFTkSuQmCC
كوئري اش را اينجوري نوشتم ولي جواب نميده:
create procedure srch2(@input nvarchar(40),@input2 nvarchar(40))
as
select *
from tbl_Inf
where @input=@input2