数据表的访问单元格值

谁能告诉我如何获取第四列第一个单元格的示例值？

a b c d
1 2 3 5
g n m l

例如，如果值 d 是可数据化的，那么如何访问它？

谢谢。

334808 次浏览

小开

最佳答案

If you need a weak reference to the cell value:

object field = d.Rows[0][3]

object field = d.Rows[0].ItemArray[3]

Should do it

If you need a strongly typed reference (string in your case) you can use the DataRowExtensions.Field extension method:

string field = d.Rows[0].Field<string>(3);

(make sure System.Data is in listed in the namespaces in this case)

Indexes are 0 based so we first access the first row (0) and then the 4th column in this row (3)

小开

foreach(DataRow row in dt.Rows)
{
string value = row[3].ToString();
}

小开

string abc= dt.Rows[0]["column name"].ToString();

小开

You can also try (first cell in 4th column):

dt.Rows[0][3]

小开

data d is in row 0 and column 3 for value d :

DataTable table;
String d = (String)table.Rows[0][3];

小开

public V[] getV(DataTable dtCloned)
{


V[] objV = new V[dtCloned.Rows.Count];
MyClasses mc = new MyClasses();
int i = 0;
int intError = 0;
foreach (DataRow dr in dtCloned.Rows)
{
try
{
V vs = new V();
vs.R = int.Parse(mc.ReplaceChar(dr["r"].ToString()).Trim());
vs.S = Int64.Parse(mc.ReplaceChar(dr["s"].ToString()).Trim());
objV[i] = vs;
i++;
}
catch (Exception ex)
{
//
DataRow row = dtError.NewRow();
row["r"] = dr["r"].ToString();
row["s"] = dr["s"].ToString();
dtError.Rows.Add(row);
intError++;
}
}
return vs;
}

小开

Assuming that the values in "SomeColumnName" are unique / distinct and that the value you are looking for in "NameOfColumnWhereIsTheValueYouLookingFor" is "Double".

double SomeDoubleValue = (double)SomeDataTable.Select("SomeColumnName = ValueWhichDetermineTheRowLocation").First()["NameOfColumnWhereIsTheValueYouLookingFor"]