string oradb = "Data Source=(DESCRIPTION="
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.130)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));"
+ "User Id=zch;Password=zch123;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
string sql="select courseName,courseId,courseInfo,number from Table.Course";
//OracleCommand cmd = new OracleCommand(sql,conn);
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = new OracleCommand(sql,conn);
DataSet DataSet = new DataSet(); adapter.Fill(DataSet,"Course");
GridView1.DataSource = DataSet.Tables["Course"]; conn.Clone();
运行提示 缺失表达式!!!
哪个高手来指点下?
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.130)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));"
+ "User Id=zch;Password=zch123;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
string sql="select courseName,courseId,courseInfo,number from Table.Course";
//OracleCommand cmd = new OracleCommand(sql,conn);
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = new OracleCommand(sql,conn);
DataSet DataSet = new DataSet(); adapter.Fill(DataSet,"Course");
GridView1.DataSource = DataSet.Tables["Course"]; conn.Clone();
运行提示 缺失表达式!!!
哪个高手来指点下?
行 29: DataSet DataSet = new DataSet();
行 30:
行 31: adapter.Fill(DataSet,"Course");
行 32: GridView1.DataSource = DataSet.Tables["Course"];
行 33:
cmd.SelectCommand = new OracleCommand(sql,conn);
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
行 29: OracleCommand cmd = new OracleCommand();
行 30: cmd.SelectCommand = new OracleCommand(sql, conn);
行 31: OracleDataAdapter adapter = new OracleDataAdapter(cmd);
行 32: adapter.Fill(DataSet,"Course");
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand =cmd;
GridView1.DataSource = DataSet.Tables[0];
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand =cmd;
GridView1.DataSource = DataSet.Tables[0];
改为alan0128的上而被句。。出现。。找不到表0?
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand =cmd;
DataSet ds = new DataSet();
adapter.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
是否缺少 using 指令或程序集引用???
Table.Course这是你的表名???
只用这个说找不到表
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.130)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));"
+ "User Id=zch;Password=zch123;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
string sql="SELECT courseName, courseId, courseInfo, courseTeacher FROM Table.Course";
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
adapter.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
conn.Close();这样代码。。然后说缺失左括号
一步步跟踪一下,看看程序运行到哪里的时候出问题。