DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select * from tbClass;select * from tbBoard", conn);
da.Fill(ds);
}
ds.Relations.Add("RelationBetweenClassAndBoard", ds.Tables[0].Columns["ClassID"], ds.Tables[1].Columns["BoardClassID"]);
rpt_Class.DataSource = ds;
rpt_Class.DataBind();
转为oracle操作如何写
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select * from tbClass;select * from tbBoard", conn);
da.Fill(ds);
}
ds.Relations.Add("RelationBetweenClassAndBoard", ds.Tables[0].Columns["ClassID"], ds.Tables[1].Columns["BoardClassID"]);
rpt_Class.DataSource = ds;
rpt_Class.DataBind();
转为oracle操作如何写
ORA-00911: 无效字符
DataSet ds = new DataSet();
using (OracleConnection conn = new OracleConnection(sConnectionString))
{
OracleDataAdapter da = new OracleDataAdapter("select * from tbClass;select * from tbBoard", conn);
da.Fill(ds);
}
ds.Relations.Add("RelationBetweenClassAndBoard", ds.Tables[0].Columns["ClassID"], ds.Tables[1].Columns["BoardClassID"]);
rpt_Class.DataSource = ds;
rpt_Class.DataBind();