您好,登錄后才能下訂單哦!
本篇內(nèi)容介紹了“C#調(diào)用Oracle數(shù)據(jù)庫的步驟”的有關(guān)知識,在實際案例的操作過程中,不少人都會遇到這樣的困境,接下來就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧!希望大家仔細(xì)閱讀,能夠?qū)W有所成!
C#調(diào)用Oracle數(shù)據(jù)庫第1步 數(shù)據(jù)表
student( studentid varchar2 studentname varchar2 )
數(shù)據(jù):
studentid studentname
001 001
002 002
002 003
C#調(diào)用Oracle數(shù)據(jù)庫第2步 建包
CREATE OR REPLACE PACKAGE PKG_SELECT_STUDENT AS TYPE T_CURSOR IS REF CURSOR; PROCEDURE Getusername ( us_id IN Varchar2, cur_name OUT T_CURSOR );
C#調(diào)用Oracle數(shù)據(jù)庫第3步 建包體
CREATE OR REPLACE PACKAGE BODY PKG_SELECT_STUDENT AS PROCEDURE Getusername ( us_id IN varchar2, cur_name OUT T_CURSOR ) IS BEGIN OPEN cur_name FOR SELECT * FROM student WHERE studentid=us_id; END Getusername; END PKG_select_student;
C#調(diào)用Oracle數(shù)據(jù)庫第4步 我的webform.cs文件
在文本框輸入ID,點擊按鈕查詢,有多條數(shù)據(jù)填充顯示在gatagrid里面
private void Button3_Click(object sender, System.EventArgs e) { string usid=this.TextBox1.Text.Trim(); Selectop st=new Selectop(); this.DataGrid1.DataSource=st.GetSelectAll(usid); this.DataGrid1.DataBind(); } public DataSet GetSelectAll(string usid) { OracleConnection con = DBoracle.CreateConnection(); OracleCommand command = new OracleCommand(); DataSet ds = new DataSet(); try { command.Connection=con; command.CommandText="PKG_select_student.Getusername"; command.CommandType=CommandType.StoredProcedure; command.Parameters.Add("us_id",OracleType.VarChar,10).Value=usid; command.Parameters.Add("cur_name",OracleType.Cursor); command.Parameters["cur_name"].Direction = ParameterDirection.Output; OracleDataAdapter adapter = new OracleDataAdapter(command); con.Open(); //command.ExecuteNonQuery(); //adapter.SelectCommand=command; adapter.Fill(ds); } catch(System.Exception ex) { throw ex; } finally { con.Close(); command.Dispose(); //adapter.Dispose(); } return ds; }
“C#調(diào)用Oracle數(shù)據(jù)庫的步驟”的內(nèi)容就介紹到這里了,感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識可以關(guān)注億速云網(wǎng)站,小編將為大家輸出更多高質(zhì)量的實用文章!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。