C# dataSet 类型转换

从数据库读出数据时出现了类型不匹配现象,代码如下

string type = null, detail = null, remark = null;

 int num = 0;
double price = 0.0;

//查询商品信息的SQL语句
string infosql = string.Format("select typeName,goodPrice,goodCount,goodDetail,

goodRemark from goodsInfo where goodsId={0}", Convert.ToInt32(txtId.Text));
DataSet dataSet = new DataSet(); //产生一个数据对象集

try
{
       SqlDataAdapter dataAdapter = new SqlDataAdapter(infosql, DBHelper.con);
       dataAdapter.Fill(dataSet, "goodsInfo");        //数据适配器填充数据单元

       foreach (DataRow row in dataSet.Tables["goodsInfo"].Rows)
       {
          Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}", row["typeName"], row["goodPrice"], row["goodDetail"], row["goodRemark"], row["goodCount"]);
            type = (string)row["typeName"];
            detail = (string)row["goodDetail"];
            remark = (string)row["goodRemark"];
            num = (int)row["goodCount"];
            price = (double)row["goodPrice"];
   }

我的数据库中goodsInfo有5个属性 goodsId  int  自动增长 ，typeName  varchar ,goodCount int, goodprice  money  , goodDetail varchar ,goodRemark varchar .

错误地方是黑体，错误信息：

指定的转化无效

学我这样，很标准的写法哦：⊙﹏⊙

price = Convert.ToDouble(row["goodPrice"].ToString());

隐式不行就这样转换嘛。

price =double.pase(row["goodPrice"].ToString());