Click here to Skip to main content
15,896,444 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
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

SQL
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.
Posted
Comments
[no name] 16-Jul-15 12:15pm    
Suggest what? Add your search fields to your WHERE clause.
Sergey Alexandrovich Kryukov 16-Jul-15 12:31pm    
Sorry, this is not a question. What have you tried so far?
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900