尽管数据显示在变量this.reflistval上，但数据不会显示在component.html上 [英] Data not display on component.html although it display on variable this.reflistval
本文介绍了尽管数据显示在变量this.reflistval上，但数据不会显示在component.html上的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我使用asp.net web API核心2.1处理项目角度7
数据显示在reference.component.ts上ngoninit事件变量
this.RefListVal
但不在Reference.component.html上显示
我的网络API函数
[HttpGet（{tableName}） ]
public List< object> GetColumnNames（[FromRoute] string tablename）
{
var columnNames = new List< object>（）;
using（var command = _context.Database.GetDbConnection（）。CreateCommand（））
{
command.CommandText = $SELECT row_number（）over（按代码asc排序） ）作为rownum，代码，ArabicCaption，COLUMN_Name，TableName FROM INFORMATION_SCHEMA.COLUMNS左边连接ReferenceFiles对INFORMATION_SCHEMA.COLUMNS.COLUMN_Name = ReferenceFiles.FieldName和INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = ReferenceFiles.TableName WHERE TableName = N'{tablename}'和TABLE_NAME = N '{}的表名';
_context.Database.OpenConnection（）;
using（var reader = command.ExecuteReader（））
{
if（reader.HasRows）
{
while（reader.Read（））
{
columnNames.Add（（Int64）reader [rownum]）;
columnNames.Add（（Int32）reader [code]）;
columnNames.Add（（string）reader [ArabicCaption]）;
columnNames.Add（（string）reader [COLUMN_Name]）;
columnNames.Add（（string）reader [TableName]）;
}
}
其他
{
columnNames.Add（未找到）;
}
}
}
return columnNames;
}
结果如下
[1,1 ，كودالموظف，EmployeeId，Employees，2,2，الفرع，BranchCode，Employees，3,3，الاسم，EmployeeName，Employees]
如何在reference.component.html上显示结果angular 7
我尝试了什么：
api服务
参考列表：参考[];
getReferenceDataForEmployee（tablename：string）：Observable< Reference []> {
返回this.http.get< Reference []>（'https：// localhost：44326 / api / Reference /'+ tablename）;
}
在reference.compoent.ts
RefListVal：any;
ngOnInit（）{
console.log（'welcome' ）;
this.apiservice.getReferenceDataForEmployee（'Employees'）
.subscribe（data => {
this.RefListVal = data; //数据显示在reflistval上但未在component.html上显示
console.log（this.RefListVal）;
}）;
在reference.component.html上
< tr * ngFor =让RefListVal参考>
<！ - < td> {{ref.rownum}}< / TD> - >
< td> {{ref.code}}< / td>
< td> {{ref.tableName}}< / td>
< td> {{ref.fieldName}}< / td>
< td> {{ref.arabicCaption}}< / td>
< td> {{ref.latineCaption}}< / td>
< / tr>
this.reflistval在检查浏览器上显示为
0：1
1：1
2：كودالموظف
3：EmployeeId
4：员工
5：2
6：2
7：الفرع
8：BranchCode
9：员工
10：3
11：3
12：الاسم
13：EmployeeName
14：员工
长度：15
__proto__：数组（0）
解决方案
SELECT row_number（）over（按代码asc排序）为rownum，代码，ArabicCaption，COLUMN_Name，TableName FROM INFORMATION_SCHEMA.COLUMNS左边连接ReferenceFiles on INFORMATION_SCHEMA.COLUMNS .COLUMN_Name = ReferenceFiles.FieldName和INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = ReferenceFiles.TableName WHERE TableName = N'{tablename}'和TABLE_NAME = N'{tablename}';
_context.Database.OpenConnection（）;
using（var reader = command.ExecuteReader（））
{
if（reader.HasRows）
{
while（reader.Read（））
{
columnNames.Add（（Int64）reader [rownum]）;
columnNames.Add（（Int32）reader [code]）;
columnNames.Add（（string）reader [ArabicCaption]）;
columnNames.Add（（string）reader [COLUMN_Name]）;
columnNames.Add（（string）reader [TableName]）;
}
}
其他
{
columnNames.Add（未找到）;
}
}
}
return columnNames;
}
结果如下
[1,1 ，كودالموظف，EmployeeId，Employees，2,2，الفرع，BranchCode，Employees，3,3，الاسم，EmployeeName，Employees]
如何在reference.component.html上显示结果angular 7
我尝试了什么：
api服务
参考列表：参考[];
getReferenceDataForEmployee（tablename：string）：Observable< Reference []> {
返回this.http.get< Reference []>（'https：// localhost：44326 / api / Reference /'+ tablename）;
}
在reference.compoent.ts
RefListVal：any;
ngOnInit（）{
console.log（'welcome' ）;
this.apiservice.getReferenceDataForEmployee（'Employees'）
.subscribe（data => {
this.RefListVal = data; //数据显示在reflistval上但未在component.html上显示
console.log（this.RefListVal）;
}）;
在reference.component.html上
< tr * ngFor =让RefListVal参考>
<！ - < td> {{ref.rownum}}< / TD> - >
< td> {{ref.code}}< / td>
< td> {{ref.tableName}}< / td>
< td> {{ref.fieldName}}< / td>
< td> {{ref.arabicCaption}}< / td>
< td> {{ref.latineCaption}}< / td>
< / tr>
this.reflistval在检查浏览器上显示为
0：1
1：1
2：كودالموظف
3：EmployeeId
4：员工
5：2
6：2
7：الفرع
8：BranchCode
9：员工
10：3
11：3
12：الاسم
13：EmployeeName
14：员工
长度：15
__proto__：数组（0）
I work on project angular 7 with asp.net web API core 2.1
data display on reference.component.ts ngoninit event variables
this.RefListVal
but not show on Reference.component.html
my web API function
[HttpGet("{tableName}")]
public List<object> GetColumnNames([FromRoute] string tablename)
{
var columnNames = new List<object>();
using (var command = _context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = $"SELECT row_number() over (order by code asc ) as rownum,code ,ArabicCaption, COLUMN_Name,TableName FROM INFORMATION_SCHEMA.COLUMNS left join ReferenceFiles on INFORMATION_SCHEMA.COLUMNS.COLUMN_Name=ReferenceFiles.FieldName and INFORMATION_SCHEMA.COLUMNS.TABLE_NAME=ReferenceFiles.TableName WHERE TableName = N'{tablename}' and TABLE_NAME= N'{tablename}'";
_context.Database.OpenConnection();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
columnNames.Add((Int64)reader["rownum"]);
columnNames.Add((Int32)reader["code"]);
columnNames.Add((string)reader["ArabicCaption"]);
columnNames.Add((string)reader["COLUMN_Name"]);
columnNames.Add((string)reader["TableName"]);
}
}
else
{
columnNames.Add("Not Found");
}
}
}
return columnNames;
}
the result as following
[1,1,"كود الموظف","EmployeeId","Employees",2,2,"الفرع","BranchCode","Employees",3,3,"الاسم","EmployeeName","Employees"]
How to display the result on reference.component.html angular 7
What I have tried:
on api service
referencelist:Reference[];
getReferenceDataForEmployee(tablename : string):Observable<Reference[]> {
return this.http.get<Reference[]>('https://localhost:44326/api/Reference/'+ tablename);
}
on reference.compoent.ts
RefListVal: any;
ngOnInit() {
console.log('welcome');
this.apiservice.getReferenceDataForEmployee('Employees')
.subscribe( data=>{
this.RefListVal = data; //data display here on reflistval but not show on component.html
console.log(this.RefListVal);
});
on reference.component.html
<tr *ngFor = "let ref of RefListVal ">
<!-- <td> {{ref.rownum}}</td> -->
<td> {{ref.code}} </td>
<td> {{ref.tableName}} </td>
<td> {{ref.fieldName}} </td>
<td> {{ref.arabicCaption }} </td>
<td> {{ref.latineCaption }} </td>
</tr>
this.reflistval display on inspect browser as
0: 1 1: 1 2: "كود الموظف" 3: "EmployeeId" 4: "Employees" 5: 2 6: 2 7: "الفرع" 8: "BranchCode" 9: "Employees" 10: 3 11: 3 12: "الاسم" 13: "EmployeeName" 14: "Employees" length: 15 __proto__: Array(0)
解决方案
"SELECT row_number() over (order by code asc ) as rownum,code ,ArabicCaption, COLUMN_Name,TableName FROM INFORMATION_SCHEMA.COLUMNS left join ReferenceFiles on INFORMATION_SCHEMA.COLUMNS.COLUMN_Name=ReferenceFiles.FieldName and INFORMATION_SCHEMA.COLUMNS.TABLE_NAME=ReferenceFiles.TableName WHERE TableName = N'{tablename}' and TABLE_NAME= N'{tablename}'"; _context.Database.OpenConnection(); using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { columnNames.Add((Int64)reader["rownum"]); columnNames.Add((Int32)reader["code"]); columnNames.Add((string)reader["ArabicCaption"]); columnNames.Add((string)reader["COLUMN_Name"]); columnNames.Add((string)reader["TableName"]); } } else { columnNames.Add("Not Found"); } } } return columnNames; }
the result as following
[1,1,"كود الموظف","EmployeeId","Employees",2,2,"الفرع","BranchCode","Employees",3,3,"الاسم","EmployeeName","Employees"]
How to display the result on reference.component.html angular 7
What I have tried:
on api service
referencelist:Reference[];
getReferenceDataForEmployee(tablename : string):Observable<Reference[]> { return this.http.get<Reference[]>('https://localhost:44326/api/Reference/'+ tablename); }
on reference.compoent.ts
RefListVal: any;
ngOnInit() { console.log('welcome'); this.apiservice.getReferenceDataForEmployee('Employees') .subscribe( data=>{ this.RefListVal = data; //data display here on reflistval but not show on component.html console.log(this.RefListVal); });
on reference.component.html
<tr *ngFor = "let ref of RefListVal "> <!-- <td> {{ref.rownum}}</td> --> <td> {{ref.code}} </td> <td> {{ref.tableName}} </td> <td> {{ref.fieldName}} </td> <td> {{ref.arabicCaption }} </td> <td> {{ref.latineCaption }} </td> </tr>
this.reflistval display on inspect browser as
0: 1 1: 1 2: "كود الموظف" 3: "EmployeeId" 4: "Employees" 5: 2 6: 2 7: "الفرع" 8: "BranchCode" 9: "Employees" 10: 3 11: 3 12: "الاسم" 13: "EmployeeName" 14: "Employees" length: 15 __proto__: Array(0)
这篇关于尽管数据显示在变量this.reflistval上，但数据不会显示在component.html上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
