I am trying to build a webform with gridview.
The feature of gridview are;
>> load data
>> edit link field in each row
>> search data based on multiple fields on search button click and show data in the same grid
I tried to search in internet but can not found appropriate examples. All the examples are based on "search as you type" or only single text box field search option.
My table is
CREATE TABLE [dbo].[client](
[client_id] [int] IDENTITY(1,1) NOT NULL,
[client_name] [varchar](200) NOT NULL,
[client_contact_person] [varchar](100) NULL,
[client_contact_person_designation] [varchar](100) NULL,
[client_local_address] [varchar](200) NULL,
[client_permanent_address] [varchar](200)z NULL,
[client_street_name] [varchar](50) NULL,
[phone_number] [varchar](20) NULL,
[mobile_number] [varchar](20) NULL,
[client_fax] [varchar](20) NULL,
[client_email] [varchar](100) NULL,
[client_website] [varchar](100) NULL,
[client_created_date] [date] NULL,
[client_is_customer_or_vendor] [varchar](1) NULL,
[client_remarks] [varchar](100) NULL,
CONSTRAINT [PK_client] PRIMARY KEY CLUSTERED
(
[client_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Search fields are client name, client_is_customer_or_vendor and client_created_date? Please suggest.