SqlCeResultSet.ResultSetView 屬性
用於將 SqlCeResultSet 資料繫結到控制項時。
命名空間： System.Data.SqlServerCe
組件： System.Data.SqlServerCe (在 System.Data.SqlServerCe.dll 中)
語法
'宣告
Public ReadOnly Property ResultSetView As ResultSetView
Get
'用途
Dim instance As SqlCeResultSet
Dim value As ResultSetView
value = instance.ResultSetView
public ResultSetView ResultSetView { get; }
public:
property ResultSetView^ ResultSetView {
ResultSetView^ get ();
}
member ResultSetView : ResultSetView
function get ResultSetView () : ResultSetView
屬性值
型別：System.Data.SqlServerCe.ResultSetView
ResultSetView 。
範例
下列範例會使用 ResultSetView 將兩個文字方塊控制項繫結到 SqlCeResultSet。
Private conn As SqlCeConnection = Nothing
Private cmd As SqlCeCommand = Nothing
Private rs As SqlCeResultSet = Nothing
Private view As ResultSetView = Nothing
Private textBox1 As TextBox = Nothing
Private textBox2 As TextBox = Nothing
' NOTE: textBox instances are initialized in Form's
' InitializeComponent() which has been omitted for the
' brevity of this code snippet
'
Private Sub onForm_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Me.conn = New SqlCeConnection("Data Source = MyDatabase.sdf")
Me.conn.Open()
Me.cmd = conn.CreateCommand()
Me.cmd.CommandText = "SELECT * FROM Orders WHERE [Order ID] < @orderID"
Me.cmd.Parameters.Add("@orderID", SqlDbType.Int)
End Sub 'onForm_Load
Private Sub buttonBind_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Try
' Fill the command parameter
'
Me.cmd.Parameters("@orderID").Value = Me.textBox1.Text
' Close the previously data bound result set
'
If Not Nothing Is rs Then
rs.Close()
End If
' Create a new result set instance
'
rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)
' ResultSetView implements all data binding interfaces
'
Me.view = rs.ResultSetView
' Bind to text boxes; initially these will display the first row
'
Me.textBox1.DataBindings.Add("text", view, "Order ID")
Me.textBox2.DataBindings.Add("text", view, "Ship Address")
' Note:
' While UI controls are data-bound, the associated
' SqlCeResultSet and SqlCeConnection instances must
' remain open;
'
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub 'buttonBind_Click
' These event handlers are registered on the Next and Previous
' buttons, which control which record is displayed in the data
' bound text boxes;
'
Private Sub btnNext_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Me.BindingContext(Me.view).Position += 1
End Sub 'btnNext_Click
Private Sub btnPrev_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Me.BindingContext(Me.view).Position -= 1
End Sub 'btnPrev_Click
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeResultSet rs = null;
ResultSetView view = null;
TextBox textBox1 = null;
TextBox textBox2 = null;
// NOTE: textBox instances are initialized in Form's
// InitializeComponent() which has been omitted for the
// brevity of this code snippet
//
private void onForm_Load(object sender, System.EventArgs e)
{
this.conn = new SqlCeConnection("Data Source = MyDatabase.sdf");
this.conn.Open();
this.cmd = conn.CreateCommand();
this.cmd.CommandText = "SELECT * FROM Orders WHERE [Order ID] < @orderID";
this.cmd.Parameters.Add("@orderID", SqlDbType.Int);
}
private void buttonBind_Click(object sender, System.EventArgs e)
{
try
{
// Fill the command parameter
//
this.cmd.Parameters["@orderID"].Value = this.textBox1.Text;
// Close the previously data bound result set
//
if (null != rs) rs.Close();
// Create a new result set instance
//
rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable |
ResultSetOptions.Scrollable);
// ResultSetView implements all data binding interfaces
//
this.view = rs.ResultSetView;
// Bind to text boxes; initially these will display the first row
//
this.textBox1.DataBindings.Add("text", view, "Order ID");
this.textBox2.DataBindings.Add("text", view, "Ship Address");
// Note:
// While UI controls are data-bound, the associated
// SqlCeResultSet and SqlCeConnection instances must
// remain open;
//
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// These event handlers are registered on the Next and Previous
// buttons, which control which record is displayed in the data
// bound text boxes;
//
private void btnNext_Click(object sender, System.EventArgs e)
{
this.BindingContext[this.view].Position += 1;
}
private void btnPrev_Click(object sender, System.EventArgs e)
{
this.BindingContext[this.view].Position -= 1;
}