DropDown in particular column of a datatable jquery

Hi all ,


Good to be back after years.

Technical Post :)

This post is about how to bring up DropDown in a particular column of "dataTable()".

Simple and understandable,

U can just create an array to be listed out in drop down "dropvalues" and the option to be selection is u have to get it and loop it with the "dropvalues" and append it with option of select.

"aoColumnDefs": [
{
"fnRender": function ( oObj, sVal) {
                    var dropval = oObj.aData[1];
                    if(dropval != ' ')
                    {
                      var select = $("<select></select>", {
                    "id": "drop"
                    });
                for(var loop=0;loop<dropvalues.length;loop++){
                        var values = dropvalues[loop];
                    var option = $("<option></option>", {
                        "text": values,
                            "value": values
                        });
                        if(dropval == values){
                            option.attr("selected", "selected")
                        }
                    select.append(option);
                    }
                    return select.prop("outerHTML");
                    }
}

 Use this code your aoColumnDefs of datatable.

Use this code if any queries comment below.

Comments

Post a Comment

Popular posts from this blog

Twitter acquisition

Hi All,  " Twitter has acquired the Android lockscreen app ". There might be a few updates in that app in near future.    They have mentioned like " Twitter may come out with a "Twitter For Android launcher" and may push contextual tweets and direct messages directly to the lockscreen of a user ".   This app will be very useful for those who tweets all the time and those who need to get updated with the current news.           For more info:  http://timesofindia.indiatimes.com/tech/tech-news/Twitter-acquires-Android-lockscreen-app/articleshow/33405320.cms
Read more

How to keep your search history 'private'

Very Good morning all,       I think most of us know to clear browse history,especially guys knows it very well... if u know what i mean.       But still some may not know about clearing it.For your kind Info all our browser will have the option of saving browser history that would record each and every page u go,if someone using your used browser they could see all the pages you've gone.      Our browser history information will have all our personal traits. Advertisements companies will use it for targeting you through your browser history and hackers may find your pass keys too.        " Cookies are nothing but temporary storage of your browser "      The main thing is that "COOKIES",it will store what ever u do like filling forms,browser actions etc., The best way of not to be tracked is disabling the "Accept cookies" option.     To disable browser history and cookies capture,go to...
Read more

Creating empty Rows in datatable jquery

Image
Hi all, This is about how we can create Empty rows in datable  irrespective of the rows returned from DB. I have done it in "fnDrawCallback". My logic is like i have to display 10 rows on Initial load. If DB returned 2 rows, i have to display the balance 8rows with empty values. Here it follows, Now steps to create datatable, After the whole table rendered. You can get the number of rows printed in table in " fnDrawCallback ". In this, am getting the total records and passing it to my function which create empty rows. As we are using (#tableid).datatable().fnData([]) , it will call the " fnDrawCallback" again and again si i have restricted it to run only one times using var itr=1; We can manually set " " values to be printed in table using  fnData([" "," "," "])   as you know how many columns you are printing in table, By using this simple way, we can creating rows with empty records...
Read more