从数据库读取数据到DataTable中 遇到null就不读吗?
public DataTable LoadUserInfo(string uid)
{
string sql = "SELECT * FROM USERS WHERE LOGINID='" + uid + "'";
OpDB op = new OpDB(connectionString);//初始化数据库连接
DataTable dt = op.ResponseUserInfo(sql);
dt.TableName = uid + "的资料";
op.Close();
return dt;
}
public DataTable ResponseUserInfo(string sql)
{
DataTable dt=new DataTable ();
OracleDataAdapter oda = new OracleDataAdapter(sql, conn);
oda.Fill(dt);
return dt;
}
public void WrtieXML(string uid)
{
DataTable dt = LoadUserInfo(uid);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml(path);
}
然后我查看xml文档,发现数据库中只要是ROWS中的某一column为null,xml中就没有这一字段。