How to bind asp data table into string array in asp.net c#?

Question

I have a java script, i want to bind data table in variable available ?

<script>
   $(function () {
       *var available* = [

        ];
        $("#tags").autocomplete({
           source: availableTags
        });
   });
</script>

I have a data table which is as follows:-

ds = du.returnDataSet("proc", "SHOW_REFINE_SEARCH", Parameters, DbTypes, ParameterTypes, values, Lengths);
DataTable dt = new DataTable();
dt = ds.Tables[0];

the data table value comes in the form which are as follows:-

Zone_ID Zone_Name     Company_ID
1       Rajasthan          1
2       Madhya Pradesh     1
3       Maharashtra        1
4       Uttar Pradesh      1
5       Jammu and Kashmir  1
6       Gujarat            1

I want to bind zone_name in javascript string variable...

prog1011 · Accepted Answer · 2014-11-15 06:15:54Z

1

Use Linq to DataTable Use .AsEnumerable()

ds = du.returnDataSet("proc", "SHOW_REFINE_SEARCH", Parameters, DbTypes, ParameterTypes, values, Lengths);
DataTable dt = new DataTable();
dt = ds.Tables[0];
string[] zone_nameList = (from n in dt.AsEnumerable() select n.Filds<string>("zone_name")).ToArray();

answered Nov 15, 2014 at 6:15

prog1011

3,4856 gold badges34 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Praveen Singh Over a year ago

how to append zone_namelist in javascript variable

prog1011 Over a year ago

@PraveenSingh - You have to use WebMethod for this

Community · Accepted Answer · 2017-05-23 11:57:55Z

0

There are other options with jQuery which you can use instead of using array you can use a web method.

You can go through this link

http://blog.nitinsawant.com/2011/09/integrating-jquery-ui-autocomplete-in.html

There are many question asked to SO all ready like

You need to create a web method or generic http handler as use it as source for you auto complete.

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Nov 15, 2014 at 6:13

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

Collectives™ on Stack Overflow

How to bind asp data table into string array in asp.net c#?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related