asked
select query results showing on gridview in asp.net???
I'm new to asp .net. I've created one application in asp .net and using backend as sql server 2005. I've connected backend with
asp.net and select query result showing in gridview is my current task. consider "available" is one of the field in a table(char(1) datatype). my task is **If *available="1"*, gridview have to display *green image*. else *available=NULL* gridview have to display *red image* on that column databound. and green and red images have *clickable*. if i click that green image, its have to change as yellow image. if i click red image, its have to change as orange image.** How to do its on gridview...?? anybody say with code. thanking you
Hi sabari, I'd look at doing something similar to the method explained at [
http://deepak-sharma.net/2012/01/27/how-to-change-the-background-color-of-rows-in-a-gridview-based-on-the-value-of-a-column-in-asp-net-3-5/][1] but instead using the grdProduct_RowDataBound (step 5) to show the appropriate image. You could also read [
http://stackoverflow.com/questions/5679158/how-to-color-code-rows-conditionally-in-vb-and-sql][2] for a VB based solution (you don't say what language you are using in
asp.net). You could then use the onclick event to change the colour again. Hope that starts you on the right path. Regards, Dave. [1]:
http://deepak-sharma.net/2012/01/27/how-to-change-the-background-color-of-rows-in-a-gridview-based-on-the-value-of-a-column-in-asp-net-3-5/ [2]:
http://stackoverflow.com/questions/5679158/how-to-color-code-rows-conditionally-in-vb-and-sql
I don't have any good solutions but I conceive that you can apply some [C# UI gridview control][1]. [1]:
http://www.kettic.com/winforms_ui/gridview.shtml
8 People are following this question.
