regarding to making gridview search facility

Hi,

You can see the below links to get Idea
http://www.codeproject.com/KB/webforms/SearchSortableGridView.aspx
http://www.codeproject.com/KB/custom-controls/GridViewSearch.aspx

I think It will fulfill your demand.

Thanks,
Arefin

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

yah i check link mention above
but this are not complete source
so if any i other plz inform

thanks

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

hi.. try this
Stored proc
====
create proc sp_SearchByCountry
@CountryName varchar(50)
as
begin
select * from Persons where PersonCountry=@CountryName
end
.cs
===
buttonSearch_click()
{
string country=txtCountry.text;
sqlconnection cnn=new sqlconnection("get connectionstring here");
sqlcommand cmd=new sqlcommand("sp_SearchByCountry",cnn);
cmd.commandtype=commandtype.storedprocedure;
cmd.parameters.addwithvalue("@country",PersonCountry);
sqldatadapter ada=new sqldataadapter(cmd);
dataset ds=new dataset();
gridperson.datasource=ds;
gridperson.databind();
}

Join Hands Change lives
Thanks & Regards
Straight Edge Society

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

Can you know tell me the gridview colmn you have , and on which column or columns you want to add search facility?

Thanks,
Sanjay

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

i want to add search on user name colum as well as mobile number

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

1.you can have dropdowns for user and mobileno outside gridview?
2.you can also have AutoComplete box and two radiobuttons and then use webservice to search and fill grid
Radiobutton1 is selected and if you start typing it should show user names
Radiobutto2 is selected and if you start typing it should show phone nos
3.Moreover you can have sorting both the columns on gridview.
4.Also keep an advance search option where you can accept user or mobile or both and search .

Thanks,
Sanjay

Thanks,
Sanjay

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