string sqlstr1 = @"SELECT TIME1,value FROM (SELECT TIME1, V炭 value FROM T_SJ order by time1 desc) where rownum>0 and rownum
string sqlstr2 = @"SELECT TIME1,value FROM (SELECT TIME1, 物料 value FROM CL_J order by time1 desc) where rownum>0 and rownum<8 ORDER BY TIME1";
if (conn1.State == ConnectionState.Closed)
{
conn1.Open();
}
if (conn2.State == ConnectionState.Closed)
{
conn2.Open();
}
chart1.ChartAreas[0].AxisX.Interval = 1; //设置X轴坐标的间隔为1
chart1.ChartAreas[0].AxisX.IntervalOffset = 1.1; //设置X轴坐标偏移为1
OracleDataAdapter sw1 = new OracleDataAdapter(sqlstr1, conn1);
OracleDataAdapter sw2 = new OracleDataAdapter(sqlstr2, conn2);
DataSet dtlw1 = new DataSet();
DataSet dtlw2 = new DataSet();
sw1.Fill(dtlw1); ————报错ORA-00911: invalid character
sw2.Fill(dtlw2); ————报错ORA-00911: invalid character
DataTable dt1 = dtlw1.Tables[0];//将数据放入表中
DataTable dt2 = dtlw2.Tables[0];//将数据放入表中