根据列名获取数据
本文关键字:获取 数据 | 更新日期: 2023-09-27 18:00:08
如何使用Datarow
根据列名检索数据?我正在尝试从我的第一个循环循环数据库数据
//Trying to get data
DataRow dr = dsResult.Tables[1].Rows[0];
//trying to get data successful
//what i trying to achieve is to retrieve data from database based on rows index and
column name
for(int i =0; i <datagridview.Rows.Count ; i++){
string a = dr['ColumnName'].['RowsIndex'].toString(); //Failed
}
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dr = dataTable.Rows[i]; //Where the RowIndex
string a = dr[0].ToString(); //Where the ColumnIndex or ColumnName
}
试试?
dr.Rows[RowsIndex]['ColumnName'].ToString()
您是否尝试删除'columnName'
规范之后的句点,并将rows[i]["columnName"]
而不是[columnName][rows]
?