data set& data adapter

Question

what is data set&data adapter?explain with one example?

Baimey Rajesh · Answer

Datasets store a copy of data from the database tables DataAdapters are used to link Databases with DataSets. sample 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 Thanks Paru Please mark if it helps!!!