c# - adding javascript function from codebehind

Question

DBDataSet.tblAdsDataTable dtAds = client.getAdsDate(ref errCode, AdsType, AdsSlot, Country);
        string ss = "";
        string aa = "";
        if (dtAds.Rows.Count > 0)
        {
            foreach (DBDataSet.tblAdsRow dr in dtAds)
            {
                DateTime date = dr.AdsDate;
                string AdsDate = date.ToString("dd/MM/yyyy");

                ss += '"' + AdsDate + '"' +",";  
                aa = ss.TrimEnd(','); // equal to "01/01/2018","02/01/2018"

                string jquery = "var naArray = ["+ aa +"];";;
                ClientScript.RegisterStartupScript(typeof(Page), "a key","<script>" + jquery + "</script>");
            }
        }

Hi, from the code above, i would want to add javascript in code behind like <script> var naArray = ["01/01/2018","02/01/2018"];</script>. However, when i execute, it become <script> var naArray = ["01/01/2018"]; <script> which "02/01/2018" is missing in the array. Appreciate if anyone can help on this. Thanks.

I dont see any code that is making up the 02/01/2018 date in your sample above? You have only used AdsDate — Prateek Shrivastava
– Prateek Shrivastava, Commented Jun 12, 2018 at 4:13
aa = ss.TrimEnd(','); // equal to "01/01/2018","02/01/2018" Can you explain this code? — Lonely Planeteer
– Lonely Planeteer, Commented Jun 12, 2018 at 4:19
The date is retrieve from datatable & i want to add each date into array in the javascript — android_beginner
– android_beginner, Commented Jun 12, 2018 at 4:19
@LonelyPlaneteer, aa = ss.TrimEnd(','); if not adding this, it will become "01/01/2018","02/01/2018", mean adding a "," behind — android_beginner
– android_beginner, Commented Jun 12, 2018 at 4:20

Karan · Accepted Answer · 2018-06-12 04:43:10Z

1

You are setting value to jquery variable is inside the foreach loop. It should be outside of the loop. Try updating your code as below.

DBDataSet.tblAdsDataTable dtAds = client.getAdsDate(ref errCode, AdsType, AdsSlot, Country);
string ss = "";
string aa = "";
if (dtAds.Rows.Count > 0)
{
    foreach (DBDataSet.tblAdsRow dr in dtAds)
    {
        DateTime date = dr.AdsDate;
        string AdsDate = date.ToString("dd/MM/yyyy");

        ss += '"' + AdsDate + '"' +",";                  
    }
    aa = ss.TrimEnd(','); // equal to "01/01/2018","02/01/2018"
    string jquery = "var naArray = ["+ aa +"];";;
    ClientScript.RegisterStartupScript(typeof(Page), "a key","<script>" + jquery + "</script>");
}

edited Jun 12, 2018 at 4:43

answered Jun 12, 2018 at 4:27

Karan

12.7k3 gold badges31 silver badges45 bronze badges

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

Comments

Lonely Planeteer · Accepted Answer · 2018-06-12 04:39:05Z

1

        string aa = "";

        foreach (DBDataSet.tblAdsRow dr in dtAds)
        {
            DateTime date = dr.AdsDate;
            string AdsDate = date.ToString("dd/MM/yyyy");

            aa += '"' + AdsDate + '"' + ","; // equal to "01/01/2018","02/01/2018"
        }

        aa = aa.TrimEnd(',');

Attach javascript outside your loop. Your value is changing in each iteration.

edited Jun 12, 2018 at 4:39

answered Jun 12, 2018 at 4:33

Lonely Planeteer

3991 gold badge8 silver badges24 bronze badges

Collectives™ on Stack Overflow

c# - adding javascript function from codebehind

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related