Web form issue

Peter_1985 2,526

Hi,

I get "undefined" unexpectedly to the column/field below, while there is the proper row value returned from the table. What is the reason?

html += "<td >货币</td><td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #D93256;' colspan=2 >" + Currency.Currency_Code + "</td>";

Viorel 112.5K Reputation points

2023-01-20T09:02:42.5466667+00:00

Is this a C# or JavaScript code and did you check the value of Currency.Currency_Code? Maybe it is actually undefined. (In JavaScript, check if the name is correct: "Currency_Code").
Viorel 112.5K Reputation points

2023-01-30T07:17:28.3+00:00
Any other help to this?

Did you consider all of the previous aspects, such as:

“In JavaScript, check if the name is correct: "Currency_Code"”,

“The problem could be a case issue...”,

Your code in C#: Currency_code = dataRow.Field...,

Your code in JavaScript: html += ... + Currency.Currency_Code + .... This can be fixed.

4 answers

QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-01-20T09:15:57.9833333+00:00

Hi @Peter_1985

You can see how the value of your variable changes in VS debug. In general, undefined variables cannot be used. Or it is also possible that it is already defined in aspx.

Best Regards

Qi You

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Peter_1985 2,526 Reputation points

2023-01-20T12:10:00.2566667+00:00

Hi all,

The table does have the proper values. One field now is showing the correct value expectedly. But this field is not.

AgaveJoe 26,136 Reputation points

2023-01-20T22:00:53.4433333+00:00

The JavaScript "undefined" error means a variable has been defined but has not been assigned a value.

An undefined complier error in C# means the variable cannot be found.

Unfortunately, you have not provided enough code for the community to accurately diagnose this issue. Is there anyway you can provide all the relevant code?

Peter_1985 2,526 Reputation points

2023-01-20T23:23:30.2066667+00:00

See the following:

using (SqlCommand sqlCmd = new SqlCommand("SELECT ...", sqlConn)) { sqlConn.Open(); sqlCmd.CommandType = CommandType.Text; SqlDataAdapter sqlAd = new SqlDataAdapter(sqlCmd); DataTable sqlDt = new DataTable(); sqlAd.Fill(sqlDt); sqlConn.Close(); if (null != sqlDt) { CurrencyList = sqlDt .AsEnumerable() .Select(dataRow => new CurrencyData { ... Currency_code = dataRow.Field<string>("Currency_code"), ... }) .ToList(); } } $.each(response.d, function (index, Currency) { var img = (Currency.code != "") ? "<img class='imgCurrency' src='ImageHandler.ashx?ImID=" + Currency.serial_id + "' />" : ""; html += "<tr class='currencyrow' data-id='" + Currency.serial_id + "'>"; html += "<td >货币</td><td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #D93256;' colspan=2 >" + Currency.Currency_Code + "</td>"; html += "<td >" + (site_lang === "CHI" ? "名称 " : "") + "</td><td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #2D2D85;' >" + Currency.Currency_name + "</td>"; html += "<td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #2D2D85;'></td>"; html += "</tr>";

Peter_1985 2,526 Reputation points

2023-01-20T23:26:49.1433333+00:00

Please help.

AgaveJoe 26,136 Reputation points

2023-01-20T23:54:56.9433333+00:00

The problem could be a case issue, object structure is not what you think, or a bug elsewhere in the code that we cannot see. You did not provide the return type or the service so we can only guess what mistakes you are making.

Please learn how to use the browser's dev tools to review the Currency variable and/ or response.d.

console.log(response.d); $.each(response.d, function (index, Currency) { console.log(Currency); var img = (Currency.code != "") ? "<img class='imgCurrency' src='ImageHandler.ashx?ImID=" + Currency.serial_id + "' />" : ""; html += "<tr class='currencyrow' data-id='" + Currency.serial_id + "'>"; html += "<td >货币</td><td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #D93256;' colspan=2 >" + Currency.Currency_Code + "</td>"; html += "<td >" + (site_lang === "CHI" ? "名称 " : "") + "</td><td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #2D2D85;' >" + Currency.Currency_name + "</td>"; html += "<td style='font-weight: bold;Font-size:16px;Font-family:標楷體;color: #2D2D85;'></td>"; html += "</tr>";

I'm not sure what browser you are using but the following shows how to open the Console in the Chrome browser.

Console overview

Peter_1985 2,526 Reputation points

2023-01-21T13:35:47.47+00:00

I did use Chrome and got the issue. How to identify the reason of this problem?

AgaveJoe 26,136 Reputation points

2023-01-21T14:02:00.8866667+00:00

You know where the code fails and you know the error is "undefined". For the second time, an undefined error in JavaScript means the variable does not exist. I'm assuming the response object is from making an AJAX call to an ASPX [WebMethod]. Unfortunately, you did not provide the Web Method return type or the entire client code. For the third time, is there anyway you can provide all the relevant code so the community is not forced to guress?

I provided troubleshooting advice and code which writes the response.d and Currency, within the $.each loop, to the console. Did you follow the advice and log the response? What is the value of response.d? What are the values of Currency? Do you see a Currency_Code value?
Sign in to comment
QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-01-23T02:16:10.3166667+00:00
Hi @Peter_1985

First I studied your code ideas based on your previous cases. Your idea is to read out Currency_code data from the database and save it in a datarow. Then you use dataRow.Field ("<string>Currency_code") to save the "Currency_code" in the datarow as a variable of type string. Finally, it is saved for use in the Currency class.

using (SqlCommand sqlCmd = new SqlCommand("SELECT ...", sqlConn))

Currency_code = dataRow.Field<string>("Currency_code"),

The Field method on the DataRow class casts a DataTable cell to a specific type.

Best Regards

Qi You

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Peter_1985 2,526 Reputation points

2023-01-23T15:38:38.6133333+00:00

Hi QiYou,

Is this due to Data type problem? Where to adjust it?

Peter_1985 2,526 Reputation points

2023-01-23T15:41:15.26+00:00

Hi QiYou,

Please help.

QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-01-24T05:18:33.5766667+00:00

First of all, your question asks why this variable is not defined but returns the correct value. I found the source of this variable based on the code you posted later. This program is actually not problematic in terms of the information you give so far. If you make an error, please continue to add information.

Peter_1985 2,526 Reputation points

2023-01-24T15:32:28.6233333+00:00

What other details do you need?

QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-01-25T05:49:35.8333333+00:00

Hi @Peter_1985

Do you mean your field is not showing the expected value? I'm sorry, I didn't understand what you meant. Can you add a bug report?

Best Regards

Qi You
Sign in to comment
AgaveJoe 26,136 Reputation points

2023-01-24T16:06:28.92+00:00

The community has explained what JavaScript "undefined" means, provided troubleshooting steps, and sample code to troubleshoot. Unfortunately, you've provided no feedback whatsoever. We have no idea if you tried debugging your code. Can you at least try the troubleshooting steps and tell us the results?
Please sign in to rate this answer.
Peter_1985 2,526 Reputation points

2023-01-26T06:36:45.0866667+00:00

AgaveJoe,

Please learn how to use the browser's dev tools to review the Currency variable and/ or response.d.

On Chrome, when running that web page, how to view the value of the Currency variable?

AgaveJoe 26,136 Reputation points

2023-01-26T11:05:26.75+00:00

I provided the code and a link that illustrates how to open dev tool in Chrome!

Simply open dev tools and click on the Console View. Then access the page and read the screen.

Peter_1985 2,526 Reputation points

2023-01-28T08:23:17.11+00:00

What to choose further below to see the value of the variable/field?
Sign in to comment
MesseAcess 0 Reputation points

2023-01-28T09:01:17.8066667+00:00

Hi,

I also get "undefined" error on my Foe Calculator site unexpectedly to the column/field below, while there is the proper row value returned from the table. What is the reason?
Please sign in to rate this answer.
Peter_1985 2,526 Reputation points

2023-01-30T01:52:12.6+00:00

Any other help to this?

Peter_1985 2,526 Reputation points

2023-01-30T01:52:36.41+00:00

Any other help to this?

Peter_1985 2,526 Reputation points

2023-01-30T08:12:31.8366667+00:00

Hi,

I received Email message showing the new update on this. But I cannot see the new comment. Any help?

QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-01-30T09:59:52.35+00:00

Hi @Peter_1985

Your problem is that the correct value is returned Currency_Code console, but not in the final table? If so, please leave me a message and I will help you continue to make changes.

Best Regards

Qi You

Peter_1985 2,526 Reputation points

2023-03-24T13:46:22.3233333+00:00

Hi,

Sorry to my late reply.

Can you refer to the project below?

https://1drv.ms/u/s!Ai8CrEskdewXykrPvEzLNAv4XY7Z?e=OucQeS

Peter_1985 2,526 Reputation points

2023-03-28T05:00:09.3533333+00:00

Hi all,

Can you help?
Sign in to comment