111,097
社区成员




CREATE TABLE `student` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
insert into student values('张三');
CREATE TABLE `stufav` (
`studentId` int(11) NOT NULL,
`favoriteId` int(11) NOT NULL,
PRIMARY KEY (`studentId`,`favoriteId`)
) DEFAULT CHARSET=utf8;
private static void TestDataTableLoadNull()
{
using (GBaseConnection conn = new GBaseConnection(connectionString))
{
try
{
conn.Open();
GBaseCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from student s left join stufav sf on sf.studentId=s.id";
// cmd.ExecuteQuery();
GBaseDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
}
}
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from User_Table as s, Table_Input as sf Where sf.id=s.id";
//cmd.CommandType= CommandType.TableDirect;
DbDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.Load(reader, LoadOption.OverwriteChanges, dt);
dt.Load(reader);