Tham khảo bài thuyết trình 'module 3: working with local data', kỹ thuật - công nghệ, kĩ thuật viễn thông phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Module 3: Working with Local Data Overview Using DataSets Using XML Using SQL Server CE Lesson: Using DataSets Model Creating a DataSet Filling the DataSet Persisting the DataSet as an XML File Binding to a DataSet Using a DataGrid Database DataSet Tables DataTable DataRowCollection DataColumnCollection ConstraintCollection DataRelationCollection Model XML .NET Data Provider Connection Transaction Command Parameters DataReader DataAdapter SelectCommand InsertCommand UpdateCommand DeleteCommand Dim myDS As New DataSet("Project") Dim myDT As DataTable = _ ("Task") ("Name", _ ("")) ("Start", _ ("")) ("Duration", _ ("")) Creating a DataSet DataTable DataSet Filling the DataSet Dim myDR As DataRow = _ ("Task").NewRow() myDR("Name") = "Design Code" myDR("Start") = "2/1/2003" myDR("Duration") = "2 days" | Module 3: Working with Local Data Overview Using DataSets Using XML Using SQL Server CE Lesson: Using DataSets Model Creating a DataSet Filling the DataSet Persisting the DataSet as an XML File Binding to a DataSet Using a DataGrid Database DataSet Tables DataTable DataRowCollection DataColumnCollection ConstraintCollection DataRelationCollection Model XML .NET Data Provider Connection Transaction Command Parameters DataReader DataAdapter SelectCommand InsertCommand UpdateCommand DeleteCommand Dim myDS As New DataSet("Project") Dim myDT As DataTable = _ ("Task") ("Name", _ ("")) ("Start", _ ("")) ("Duration", _ ("")) Creating a DataSet DataTable DataSet Filling the DataSet Dim myDR As DataRow = _ ("Task").NewRow() myDR("Name") = "Design Code" myDR("Start") = "2/1/2003" myDR("Duration") = "2 days" ("Task").(myDR) Name Start Duration Design UI 1/1/2003 I day Design Code 2/1/2003 2 days Practice: Using DataSets to Access Data Creating and filling a DataSet 1 Adding to a DataSet from a form 2 Persisting the DataSet as an XML File DataSet provides volatile storage Use the WriteXml method to save data Use the ReadXml method to populate data from the file ("win\") Dim myDataSet As New DataSet() ("win\") Practice: Persisting the DataSet as XML Save a DataSet as an XML file 1 Verify the XML file 2 Binding to a DataSet DataSource property Binds a control to the data source Provides link from mobile application to DataSet Dim dt As DataTable = _ ("Info") 'Bind to the list box = dt 'Set column to bind to = "Name" Using a DataGrid Provides a user interface for entire tables in a DataSet Rich formatting capabilities DataGrid is bound to a data source at run time (not .
