有可能你查询出来的值不存在,建议改为:myRows = myTable.Select()if myRows.Length = 0 then
Response.Write("数据不存在")
else
temp = CStr(myRows(0)("vurl"))
Response.Write(temp)
end if
Response.Write("数据不存在")
else
temp = CStr(myRows(0)("vurl"))
Response.Write(temp)
end if
我明白了,你把
SqlDataAdapter1.Fill(DataSet1)
改为:
SqlDataAdapter1.Fill(DataSet1,"vod")就好了
SqlDataAdapter1= new SqlDataAdapter(cmdStr, SqlConnection1);
SqlDataAdapter1.Fill(DataSet1,"vod");