insert into Dict_area(acode,area_name,area_code,PY_Code,zipcode,up_code,down_code,arealevel,aimg) values(@acode,@area_name,@area_code,@PY_Code,@zipcode,@up_code,@down_code,@arealevel,@aimg)
再增加参数
for(i=0;i<m_SqlDataReader.FieldCount;i++)
{
if (m_IdentityKey!=m_SqlDataReader.GetName(i))
{
m_SqlCommand.Parameters.Add("@"+m_SqlDataReader.GetName(i),m_SqlDataReader.GetValue(i));
}
}
换成也不行
for(i=0;i<m_SqlDataReader.FieldCount;i++)
{
if (m_IdentityKey!=m_SqlDataReader.GetName(i))
{
m_SqlCommand.Parameters.Add("@"+m_SqlDataReader.GetName(i),(System.Data.SqlDbType)m_DataTable.Rows[i][12],(int)m_DataTable.Rows[i][2]);
}
}
System.InvalidCastException: Specified cast is not valid.