ds = SelectExcel()
myDataTable = ds.Tables(0)
count = myDataTable.Rows.Count
If count > 0 Then
For j = 0 To count - 1
Dim PRODUCT_TYPE As String
PRODUCT_TYPE = myDataTable.Rows(j)("规格/型号").ToString().Replace("'", "''")
product_How = myDataTable.Rows(j)("件数").ToString().Replace("'", "''")
product_Menber = myDataTable.Rows(j)("数量").ToString().Replace("'", "''")
price = myDataTable.Rows(j)("单价").ToString().Replace("'", "''")
If price = "" Then
price = 0
End If
dt = database.SelectStockValue(PRODUCT_TYPE)
If dt.Rows.Count > 0 Then //这里为0
lable.Text = dt.Rows(0)("num").ToString()
valueweight = dt.Rows(0)("gross_weight").ToString() / Convert.ToInt32(lable.Text)
valuesuttle = dt.Rows(0)("product_suttle").ToString() / Convert.ToInt32(lable.Text)
product_Cname = dt.Rows(0)("product_cname").ToString()
End If
myDataTable = ds.Tables(0)
count = myDataTable.Rows.Count
If count > 0 Then
For j = 0 To count - 1
Dim PRODUCT_TYPE As String
PRODUCT_TYPE = myDataTable.Rows(j)("规格/型号").ToString().Replace("'", "''")
product_How = myDataTable.Rows(j)("件数").ToString().Replace("'", "''")
product_Menber = myDataTable.Rows(j)("数量").ToString().Replace("'", "''")
price = myDataTable.Rows(j)("单价").ToString().Replace("'", "''")
If price = "" Then
price = 0
End If
dt = database.SelectStockValue(PRODUCT_TYPE)
If dt.Rows.Count > 0 Then //这里为0
lable.Text = dt.Rows(0)("num").ToString()
valueweight = dt.Rows(0)("gross_weight").ToString() / Convert.ToInt32(lable.Text)
valuesuttle = dt.Rows(0)("product_suttle").ToString() / Convert.ToInt32(lable.Text)
product_Cname = dt.Rows(0)("product_cname").ToString()
End If
或, DataTable dt = database.SelectStockValue(PRODUCT_TYPE).Tables[0];
foreach (DataRow row2 in dt2.Rows)
{
}
如果都不,可能是你的DT里面没有值,为NULL