100165626.htm
来自「C#高级编程(第三版),顶死你们。。 。up」· HTM 代码 · 共 201 行 · 第 1/3 页
HTM
201 行
<p class="2" style="MARGIN-TOP: 8.15pt; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US"> protected void retrieveButton_Click(object sender, System.EventArgs e)</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> {</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> retrieveButton.Enabled = false ;</span></p>
<p class="2" style="MARGIN-TOP: 0cm; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US"> ds = CreateDataSet();</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">接着，绑定两个文本控件：</span></p>
<p class="2" style="MARGIN-TOP: 8.15pt; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US"> textName.DataBindings.Add("Text" , ds , </span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> "Products.ProductName");</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> textQuan.DataBindings.Add("Text" , ds , </span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> "Products.QuantityPerUnit");</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> trackBar.Minimum = 0 ;</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> trackBar.Maximum = this.BindingContext[ds,"Products"].Count --1;</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> textName.Enabled = true;</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> textQuan.Enabled = true;</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> trackBar.Enabled = true;</span></p>
<p class="2" style="MARGIN-TOP: 0cm; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">这里有一个记录滚动机制，该机制响应</span><span lang="EN-US">TrackBar</span><span style="FONT-FAMILY: 宋体">小图标的移动：</span></p>
<p class="2" style="MARGIN-TOP: 8.15pt; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US"> protected void trackBar_Scroll(object sender , System.EventArgs e)</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> {</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> this.BindingContext[ds,"Products"].Position = trackBar.Value;</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> }</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> private DataSet CreateDataSet()</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> {</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> string source = "server=(local)\\NetSDK;" + </span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> "uid=QSUser;pwd=QSPassword;" + </span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> "database=northwind";</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> string customers = "SELECT * FROM Products";</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> SqlConnection con = new SqlConnection(source);</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> SqlDataAdapter da = new SqlDataAdapter(customers , con);</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> DataSet ds = new DataSet();</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> da.Fill(ds , "Products");</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> return ds;</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> }</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> static void Main() </span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> {</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> Application.Run(new ScrollingDataBinding());</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> }</span></p>
<p class="2" style="MARGIN-TOP: 0cm; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US">}</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">在开始检索数据时，跟踪栏的最大位置就设置为记录的个数。接着在上面的滚动方法中，把</span><span lang="EN-US">Products</span><span style="FONT-FAMILY: 宋体">数据表中</span><span lang="EN-US">BindingContext</span><span style="FONT-FAMILY: 宋体">的位置设置为滚动条的位置，这样就可以有效地改变</span><span lang="EN-US">DataTable</span><span style="FONT-FAMILY: 宋体">中的当前记录，绑定到当前行上的所有控件</span><span lang="EN-US">(</span><span style="FONT-FAMILY: 宋体">在本例中是两个文本框</span><span lang="EN-US">)</span><span style="FONT-FAMILY: 宋体">就会被更新。</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">本节介绍了如何绑定到各种数据源上，例如数组、数据表、数据视图和各种其他数据容器，如何排序和过滤数据。</span><span lang="EN-US">22.3</span><span style="FONT-FAMILY: 宋体">节将讨论如何扩展</span><span lang="EN-US">Visual Studio</span><span style="FONT-FAMILY: 宋体">，以允许进行数据访问，得到与应用程序的更好集成。</span></p></div>
<!-- page -->
<div class="page" style="text-align: center">
<a href="100165625.htm">上一页</a> <a href="index.html">首页</a> <a href="100165627.htm">下一页</a>
</div>
<div style="margin: 0px auto; width: 700px; border: solid 1px #0b5f98;">
<div style="float: left; width: 16px; background-color: #0b5f98; color: White; padding: 1px;">
图书导读
</div>
<div style="float: right; width: 670px; text-align: left; line-height: 16pt; padding-left: 2px">
<!--导读-->
<h1 id="divCurrentNode2" style="color: #b83507; width: 100%; text-align: left; font-size: 12px; padding-left: 2px">当前章节:<a href='100165626.htm'><font color='red'>22.2.2 数据绑定对象</font></a></h1>
<div id="divRealteNod2" style="padding-left: 2px">
<div style='float:left;width:49%'>·<a href='100165623.htm'>22.1.3 DataGrid类的层次结构</a></div><div style='float:right;width:49%'>·<a href='100165624.htm'>22.2 数据绑定</a></div><div style='float:left;width:49%'>·<a href='100165625.htm'>22.2.1 简单的绑定</a></div><div style='float:right;width:49%'>·<a href='100165627.htm'>22.3 Visual Studio .NET和数据访问</a></div><div style='float:left;width:49%'>·<a href='100165628.htm'>22.3.1 创建一个连接</a></div><div style='float:right;width:49%'>·<a href='100165629.htm'>22.3.2 选择数据</a></div></div>
</div>
</div>
</div>
<!-- 评论 -->
<!-- 今日推荐 -->
</div>
<!-- 页脚 -->
<div id="foot">
<img src="../../book/readbook.aspx@node=5626&bookid=16&bookname=22.2.2++_25ca_25fd_25be_25dd_25b0_25f3_25b6_25a8_25b6_25d4_25cf_25f3" alt="" width="0" height="0" />
<style>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?