Search Database, Display In ASP.NET GridView Using C#

Is it possible to change the code to do search for multiple records? The current code allows to search for 1 record and display that 1 record. If I want to search for another record, it will still be displayed, but replaces that first record instead of displaying it under the first record. Is there anyway to change it? Thanks.

The search isn't working for me. the rest is all fine. help please

This article most helpful to me. Thanks

Thanks for explanation

Dropdown list value come from first table and gridview is sencond table

How to make search function using dropdownlist and display in gridview.

How to search checked checkbox items in gridview

Great article

I'm sure you missed some codes on the Go button. I can't see any definition of "dr"

I didn't get about dr from where it come..?? It gives error on my code..

What if search not found?

Simply Gr8 thnaaaaaaqqqqqq soooo muchhhh for sharingggg this code :) thak you once again

What is dr.HasRows?

Hi, could you please help as i keep getting an error when i write dr on this codes..

How to search article with any word like your page search box show

Hey just put the rep_bind() method code inside the go button .you never face any error

Thank you the article, please explain this rep_bind(); it give error on my code.

Hi,nice article but i am having one doubt whether this text box can accept the input as both alphanumerical or only alpha sets.

How to integrate autocomplete in this

Thanks

Nice

My gridview has page 1, 2, 3..., so when I go to page 2 for example , it doesn't view the data according the specified criterion in the search textbox.

Can you explain in detail

Thanks Vithal, i have a doubt my gridview is paged when i click in page 2, it shows data not specified in parameter

Create data table dynamically as per column list coming from database

Hi Vithal, I have 4 gridviews and i want each gridview to show a different column. How will i accomplish that. Thanks for your help

Welcome

Thank you sir for the nice aricle

Thanks

Good one...

thanks

Good Work....

Its simple add two more conditions

nice work...but if i am using one more tools like two textbox and one dropdownlist? how to search gridview records.. help me??

yes Nyra Leo you can get it. just append query output with + operator

sai refer my other articles

can I get this searched column elements in a variable Like if i have search query like" select telephoneno from table1 where city=Mumbai " then i want to take all telephone nos (seperated with commas)in a variable .Any idea hw can i do this?

ho to achieve both like and in condition here in the above article u implemented for like lets say i have 2 names arokya,ajit if i want to get based on these 2 names how to acevive this.Thanks

Thanks

nice article

dr has no rows ,check whether the records are coming properly or not .

i have an error as Object reference not set to an instance of an object at the if(dr.has rows) for same above problem..how can i solve this problem..pleas tell me sir.

refer my latest article

INSTEAD OF GRID VIEW CAN I USE TABLE CONTROL IF YES THEN HOW ? MY CODE IS UNABLE TO DO THE SHORTING AS I USED TABLE CONTROL INSTEAD OF GRID VIEW?

Hey usman khan do the same operation but change only query select * from bikemaster where name = ``+ textbox1.text +`` and city =`` +dropdownlist1.selected value +``; hope it helps

Hey Nihalani Pankaj if you are not familiar with disconnected. ArcArchiecture ,refer my artical http://www.c-sharpcorner.com/UploadFile/8af593/ado-net-dis-connected-architecture/ hope it helps..

Welcome

ok sure thanks

usman khan sir give me some time to write article on this or refer C#corner asp.net article list defiantly you will find solution

Hey Guys! I need some help.. I am building an auto buy and sell website for my semester project in which I want to include a filter search i.e I want that the users select from two dropdownlists and then search...like the two dropdownlist will be City(in which city do you want to buy) and make(like Toyota, Honda etc)...so by selecting these and clicking on search button it should fetch the records from database and show these records in data list..thats all

make necessary changes as per your server location

Error come that no constructor defined how to solve this error i download the zip file but solve this error

its a dataReader ,download zip file for better understanding

Which Method is dr.read and please give me code of this method

What is dr is that an dataset or what ?

balaji badrinath its fetch the records like character given input

Nihalani Pankaj dr.hasrows checks whether it has rows and dr.Read means it reads rows from dataReader

What is that dr.hasrows and dr.read

what is that dr.hasrows and dr.read

string query = 'select * from emp where Name like...in this one what is like?

thanks sir

good work

showing a nullreference exception was handled by user code in the following line:::::::::::::::::;constr = ConfigurationManager.ConnectionStrings["emp"].ToString();

thanks,refer my article list

gud article it worked bt may i know how can i export it into excel or word pls help with this as soon as possible

gud article it worked.....

thanks saddique khan sir

It is good article

its my pleasure Abdullah Naeb sir

Thanks a lot

how we'll define the datareader dr?

Thanks

thanks Nguyen Minh Triet sir

Thanks, it's works for me

thanks ketan

nice work thanks.

thanks and welcome Mohamed Ali sir

Thanks to C# conner Community