objOleDbDataAdapter.Fill(objDataSet, tableName); with sybase

[codeadair]

HI,all. Today, when i want to get data from sybase table. i have puzzled with a strang thing. just like the title. when the program runs to the point, my program dipped into it. the program will not run to the next statement and also with no error threw out. what is wrong? how could i get data from sybase table as i getting from oracle. by the way,i could do insert,update,delete operating in my program.and one thing else,when i use oleDbDataReader to read data from sybase table, another problem happens,when i do "myReader.Close();".the same thing happens,the program will not go to next statement. Here is my part codes: public int LoadDataSetFromSYBASE(string sql, string tableName, ref DataSet objDataSet) { this.sybase_Connect(); int iCount = -1; OleDbDataAdapter objOleDbDataAdapter = new OleDbDataAdapter(sql, this.sybase_con); try { iCount = objOleDbDataAdapter.Fill(objDataSet, tableName); } catch(Exception e) { throw (new Exception("Error in LoadDataSetfromSYBASE method. " + e.Message)); } finally { this.sybase_Disconnect(); } return iCount; } public void LoadDataFromSYBASE(string sql,object obj) { using (OleDbConnection connection = new OleDbConnection(sybase_ConnectionString)) { OleDbCommand command = new OleDbCommand(sql, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); reader.Read(); obj=reader[0]; reader.Close(); } }

MSN:msnadair@hotmail.com Skype:skyadair