Dataadapter with dataset - sql sever
SqlDataAdapter provides the communication between the Dataset and the Data Source with the help of SqlConnection Object . The SqlConnection Object has no information about the data it retrieves . Similarly a Dataset has no knowledge of the Data Source where the data coming from. So the SqlDataAdapter manage the communication between these two Objects.
The SqlDataAdapter object allows us to populate Data Tables in a DataSet. We can use Fill method of the SqlDataAdapter for populating data in a Dataset. The following source code shows a simple program that uses SqlDataAdapter to retrieve data from Data Source with the help of SqlConnection object and populate the data in a Dataset.
Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As SqlConnection Dim adapter As SqlDataAdapter Dim ds As New DataSet Dim i As Integer connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" connection = New SqlConnection(connetionString) Try connection.Open() adapter = New SqlDataAdapter("Your SQL Statement Here", connection) adapter.Fill(ds) connection.Close() For i = 0 To ds.Tables(0).Rows.Count - 1 MsgBox(ds.Tables(0).Rows(i).Item(1)) Next Catch ex As Exception MsgBox(ex.ToString) End Try End Sub End Class
Related Topics
- Dataadapter with dataset - OLEDB Data Source
- Dataadapter SelectCommand - Sql Server
- Dataadapter SelectCommand - OLEDB Data Source
- Dataadapter InsertCommand - Sql Server
- Dataadapter InsertCommand - OLEDB Data Source
- Dataadapter UpdateCommand - Sql Server
- Dataadapter UpdateCommand - OLEDB Data Source
- Dataadapter DeleteCommand - Sql Server
- Dataadapter DeleteCommand - OLEDB Data Source
- Dataadapter with CommandBuilder - Sql Server
- Dataadapter with CommandBuilder - OLEDB
- Dataadapter with DataGridView - Sql Server
- Dataadapter with DataGridView - OLEDB
Related Topics