NEED storedproc for searching records on dropdownlist value and textbox

Posted by Parthibansk under Sql Server on 1/21/2013 | Points: 10 | Views : 793 | Status : [Member] | Replies : 3
i got a dropdownlist with

1)id
2)name
3)date

and a textbox.. have 2 choose a category from dropdownlist and enter keyword in textbox and bind in gridview..

how to write storedproc for the above




Responses

Posted by: Sourabh07 on: 1/22/2013 [Member] Starter | Points: 25

Up
0
Down
hi...try this...

Create proc BindGrid_SP(

@id int,
@name varchar(100),
@date datetime,
@textboxValue varchar(100)
)
begin
Select * from Table_Name where id=@id and name=@name and date=@date and textboxValue=@textboxValue
order by id
end




Sourabh07

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pavanandey on: 1/23/2013 [Member] Bronze | Points: 25

Up
0
Down
can you explain you requirement clearly

Thanks
Pavan Kumar
Mark Answer if this fits the need

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arul44ece on: 1/29/2013 [Member] Starter | Points: 25

Up
0
Down
Hi Parthiban,

Can u pls explain your question clearly.



Regards,

Arul R
arul44.ece@gmail.com

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response