关于SqlXml的运用。。

Question

            DataSet ds = new DataSet();
            string connectionString = "Data Source=WWW-B128C922BB5\\SQLEXPRESS;Initial Catalog=StudentDb;Integrated Security=True";
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = connectionString;
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from student";
                    using (SqlDataReader rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            SqlXml student = rdr.GetSqlXml(0);
                            if (!student.IsNull)
                            {
                                ds.ReadXml(student.CreateReader());
                            }
                        }
                    }
                }
                dataGridView1.DataSource = ds;
            }
        }errow:在  SqlXml student = rdr.GetSqlXml(0);处出现 无法将类型为“System.Data.SqlTypes.SqlInt32”的对象强制转换为类型“System.Data.SqlClient.SqlCachedBuffer”。请教。。

Answer 1

首先确定student表的第一列字段类型为xml判断空值在前if(!reader.IsDBNull(0))
    ds.ReadXml(reader.GetSqlXml(0).CreateReader());

Answer 2

谢谢个位回答因为SQL中表是XML格式
所以存在格式错误问题无法显示是因为