oledb返回連接多個結果集（oracle 遊標）代码,PLSQL代码库,德仔网

代码语言
代码分类
【PLSQL】 oledb返回連接多個結果集（oracle 遊標）
作者:Dezai.CN / 发布于2011/7/7/ 750
<div><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">-------oledb返回多個結果集----------</span><span style="color: rgb(0,128,128)">
--</span><span style="color: rgb(0,128,128)">創建包</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">or</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">replace</span><span style="color: rgb(0,0,0)"> package pkg_tb_test </span><span style="color: rgb(0,0,255)">is</span><span style="color: rgb(0,0,0)">
type type_cursor </span><span style="color: rgb(0,0,255)">is</span><span style="color: rgb(0,0,0)"> ref </span><span style="color: rgb(0,0,255)">cursor</span><span style="color: rgb(0,0,0)">; 
</span><span style="color: rgb(0,0,255)">procedure</span><span style="color: rgb(0,0,0)"> SP_TB_TEST_SELECT(my_cursor out type_cursor);
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)"> pkg_tb_test;
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">創建包體</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">or</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">replace</span><span style="color: rgb(0,0,0)"> package body pkg_tb_test </span><span style="color: rgb(0,0,255)">is</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">procedure</span><span style="color: rgb(0,0,0)"> SP_TB_TEST_SELECT(my_cursor out type_cursor)
</span><span style="color: rgb(0,0,255)">is</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">OPEN</span><span style="color: rgb(0,0,0)"> my_cursor </span><span style="color: rgb(0,0,255)">for</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> tb_test; </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">查詢tb_test表</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)"> SP_TB_TEST_SELECT;
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)"> pkg_tb_test;
</span>

<div class="cnblogs_code"><img style="display: none" id="code_img_closed_0cf2fe41-2dc9-43c1-b99b-7f84714c932a" class="code_img_closed" alt="" src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif" /><img id="code_img_opened_0cf2fe41-2dc9-43c1-b99b-7f84714c932a" class="code_img_opened" src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif" alt="" /><span class="cnblogs_code_collapse">Default5.aspx頁面</span>
<div style="display: block" id="cnblogs_code_open_0cf2fe41-2dc9-43c1-b99b-7f84714c932a" class="cnblogs_code_hide">
<div><!--<br/  />
<br/  />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br/  />
http://www.CodeHighlighter.com/<br/  />
<br/  />
--><span style="background-color: rgb(255,255,0); color: rgb(0,0,0)"><%<span style="background-color: rgb(245,245,245); color: rgb(0,0,0)">@ Page Language</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)">=</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">C#</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)"> AutoEventWireup</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)">=</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">true</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)"> CodeFile</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)">=</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">Default5.aspx.cs</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)"> Inherits</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)">=</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">Default5</span><span style="background-color: rgb(245,245,245); color: rgb(128,0,0)">"</span><span style="background-color: rgb(245,245,245); color: rgb(0,0,0)"> </span><span style="background-color: rgb(255,255,0); color: rgb(0,0,0)">%></span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)"><!</span><span style="color: rgb(255,0,255)">DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">html </span><span style="color: rgb(255,0,0)">xmlns</span><span style="color: rgb(0,0,255)">="http://www.w3.org/1999/xhtml"</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">head </span><span style="color: rgb(255,0,0)">runat</span><span style="color: rgb(0,0,255)">="server"</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">title</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">未命名頁面</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">title</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">head</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">body</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">form </span><span style="color: rgb(255,0,0)">id</span><span style="color: rgb(0,0,255)">="form1"</span><span style="color: rgb(255,0,0)"> runat</span><span style="color: rgb(0,0,255)">="server"</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">div</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">asp:GridView </span><span style="color: rgb(255,0,0)">ID</span><span style="color: rgb(0,0,255)">="GridView1"</span><span style="color: rgb(255,0,0)"> runat</span><span style="color: rgb(0,0,255)">="server"</span><span style="color: rgb(255,0,0)"> AutoGenerateColumns</span><span style="color: rgb(0,0,255)">="False"</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">Columns</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">asp:BoundField </span><span style="color: rgb(255,0,0)">DataField</span><span style="color: rgb(0,0,255)">="id"</span><span style="color: rgb(255,0,0)"> HeaderText</span><span style="color: rgb(0,0,255)">="編號"</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(0,0,255)">/></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">asp:BoundField </span><span style="color: rgb(255,0,0)">DataField</span><span style="color: rgb(0,0,255)">="name"</span><span style="color: rgb(255,0,0)"> HeaderText</span><span style="color: rgb(0,0,255)">="名字"</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(0,0,255)">/></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">asp:BoundField </span><span style="color: rgb(255,0,0)">DataField</span><span style="color: rgb(0,0,255)">="sex"</span><span style="color: rgb(255,0,0)"> HeaderText</span><span style="color: rgb(0,0,255)">="性別"</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(0,0,255)">/></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">asp:BoundField </span><span style="color: rgb(255,0,0)">DataField</span><span style="color: rgb(0,0,255)">="age"</span><span style="color: rgb(255,0,0)"> HeaderText</span><span style="color: rgb(0,0,255)">="年齡"</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(0,0,255)">/></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">Columns</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">asp:GridView</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">div</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">form</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">body</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">html</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span></div>
</div>
</div>

<div class="cnblogs_code"><img style="display: none" id="code_img_closed_2de14bc2-80a3-41b1-aeaa-48177fb7d58a" class="code_img_closed" alt="" src="http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif" /><img id="code_img_opened_2de14bc2-80a3-41b1-aeaa-48177fb7d58a" class="code_img_opened" src="http://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif" alt="" /><span class="cnblogs_code_collapse">Default5.aspx.cs和Model後臺代碼</span>
<div style="display: block" id="cnblogs_code_open_2de14bc2-80a3-41b1-aeaa-48177fb7d58a" class="cnblogs_code_hide">
<div><!--<br/  />
<br/  />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br/  />
http://www.CodeHighlighter.com/<br/  />
<br/  />
--><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Data;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Configuration;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Collections;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Web;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Web.Security;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Web.UI;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Web.UI.WebControls;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Web.UI.WebControls.WebParts;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Web.UI.HtmlControls;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Data.OleDb;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Collections.Generic;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> Model;
</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">partial</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">class</span><span style="color: rgb(0,0,0)"> Default5 : System.Web.UI.Page
{
</span><span style="color: rgb(0,0,255)">protected</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">void</span><span style="color: rgb(0,0,0)"> Page_Load(</span><span style="color: rgb(0,0,255)">object</span><span style="color: rgb(0,0,0)"> sender, EventArgs e)
{
</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,0)">!</span><span style="color: rgb(0,0,0)">IsPostBack)
{
</span><span style="color: rgb(0,0,255)">this</span><span style="color: rgb(0,0,0)">.GridView1.DataSource </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> GetAll();
</span><span style="color: rgb(0,0,255)">this</span><span style="color: rgb(0,0,0)">.GridView1.DataBind();
}


}
</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> List</span><span style="color: rgb(0,0,0)"><</span><span style="color: rgb(0,0,0)">tb2</span><span style="color: rgb(0,0,0)">></span><span style="color: rgb(0,0,0)"> GetAll()
{
</span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> queryString </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">{call pkg_tb_test.SP_TB_TEST_SELECT('my_cursor')}</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">; </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">oledb調用存儲過程返回多個結果集</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)">OleDbConnection conn </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OleDbConnection(ConfigurationManager.ConnectionStrings[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">CN</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">].ToString());</span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">數據庫連接字符串</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)">OleDbCommand cmd </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OleDbCommand(queryString, conn);
OleDbDataReader read </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">null</span><span style="color: rgb(0,0,0)">;
List</span><span style="color: rgb(0,0,0)"><</span><span style="color: rgb(0,0,0)">tb2</span><span style="color: rgb(0,0,0)">></span><span style="color: rgb(0,0,0)"> listTb </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> List</span><span style="color: rgb(0,0,0)"><</span><span style="color: rgb(0,0,0)">tb2</span><span style="color: rgb(0,0,0)">></span><span style="color: rgb(0,0,0)">();
</span><span style="color: rgb(0,0,255)">try</span><span style="color: rgb(0,0,0)">
{
conn.Open();
read </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> cmd.ExecuteReader();

</span><span style="color: rgb(0,0,255)">while</span><span style="color: rgb(0,0,0)"> (read.Read())
{
tb2 tb </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> tb2();
tb.Id </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> Convert.ToInt32(read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">id</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">]);
tb.Name </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">name</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">].ToString();
tb.Sex </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">sex</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">].ToString();
tb.Age </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> Convert.ToInt32(read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">age</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">]);
tb.Address </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">address</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">].ToString();
tb.Tel </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">tel</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">].ToString();
tb.Email </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> read[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">email</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">].ToString();

listTb.Add(tb);
} 
</span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> listTb;
}
</span><span style="color: rgb(0,0,255)">catch</span><span style="color: rgb(0,0,0)"> (Exception)
{
</span><span style="color: rgb(0,0,255)">throw</span><span style="color: rgb(0,0,0)">;
}

</span><span style="color: rgb(0,0,255)">finally</span><span style="color: rgb(0,0,0)">{
read.Close();
conn.Close();
}
}
}




Model層代碼
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Collections.Generic;
</span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> System.Text;

</span><span style="color: rgb(0,0,255)">namespace</span><span style="color: rgb(0,0,0)"> Model
{
[Serializable]
</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">class</span><span style="color: rgb(0,0,0)"> tb3
{

</span><span style="color: rgb(0,0,255)">private</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> tb_from;

</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> Tb_from
{
</span><span style="color: rgb(0,0,255)">get</span><span style="color: rgb(0,0,0)"> { </span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> tb_from; }
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> { tb_from </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> value; }
}
</span><span style="color: rgb(0,0,255)">private</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> tb_to;

</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> Tb_to
{
</span><span style="color: rgb(0,0,255)">get</span><span style="color: rgb(0,0,0)"> { </span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> tb_to; }
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> { tb_to </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> value; }
}
</span><span style="color: rgb(0,0,255)">private</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> tb_title;

</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> Tb_title
{
</span><span style="color: rgb(0,0,255)">get</span><span style="color: rgb(0,0,0)"> { </span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> tb_title; }
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> { tb_title </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> value; }
}
</span><span style="color: rgb(0,0,255)">private</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> tb_body;

</span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> Tb_body
{
</span><span style="color: rgb(0,0,255)">get</span><span style="color: rgb(0,0,0)"> { </span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> tb_body; }
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> { tb_body </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> value; }
}
}
}
</span></div>
</div>
</div>

<div class="cnblogs_code">
<div><!--<br/  />
<br/  />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br/  />
http://www.CodeHighlighter.com/<br/  />
<br/  />
--><span style="color: rgb(0,0,0)">
<div class="cnblogs_code">
<div><!--<br/  />
<br/  />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br/  />
http://www.CodeHighlighter.com/<br/  />
<br/  />
--><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">connectionStrings</span><span style="color: rgb(0,0,255)">></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"><</span><span style="color: rgb(128,0,0)">add </span><span style="color: rgb(255,0,0)">name</span><span style="color: rgb(0,0,255)">="CN"</span><span style="color: rgb(255,0,0)"> connectionString</span><span style="color: rgb(0,0,255)">="Provider=msdaora;Data Source=MDSTEST;User Id=MGSSFCS;password=MDS"</span><span style="color: rgb(0,0,255)">/></span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)"></</span><span style="color: rgb(128,0,0)">connectionStrings</span><span style="color: rgb(0,0,255)">></span></div>
</div>

</span></div>
</div>

</div>
试试其它关键字
　多個結果集　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)