Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How can we use dataadapter to fill a dataset ?
What are the steps involved to fill a dataset ?
✍: Guest
Sample code is provided in “WindowsDataSetSample” folder in CD.”LoadData” has all the implementation of connecting and loading to dataset. This dataset is finally bind to a ListBox. Below is the sample code.
Private Sub LoadData() Dim strConnectionString As String strConnectionString = AppSettings.Item(“ConnectionString”) Dim objConn As New SqlConnection(strConnectionString) objConn.Open() Dim objCommand As New SqlCommand(“Select FirstName from Employees”) objCommand.Connection = objConn Dim objDataAdapter As New SqlDataAdapter() objDataAdapter.SelectCommand = objCommand Dim objDataSet As New DataSet End Sub
In such type of questions interviewer is looking from practical angle, that have you worked with dataset and datadapters. Let me try to explain the above code first and then we move to what steps should be told during interview.
Dim objConn As New SqlConnection(strConnectionString) objConn.Open()
First step is to open the connection.Again note the connection string is loaded from config file.
Dim objCommand As New SqlCommand(“Select FirstName from Employees”) objCommand.Connection = objConn
Second step is to create a command object with appropriate SQL and set the connection object to this command.
Dim objDataAdapter As New SqlDataAdapter() objDataAdapter.SelectCommand = objCommand
Third steps is to create the Adapter object and pass the command object to the adapter object.
objDataAdapter.Fill(objDataSet)
Fourth step is to load the dataset using the “Fill” method of the dataadapter.
lstData.DataSource = objDataSet.Tables(0).DefaultView lstData.DisplayMember = “FirstName” lstData.ValueMember = “FirstName”
listbox as the UI. Binding of the UI is done by using DefaultView of the dataset. Just to revise every dataset has tables and every table has views. In this sample we have only loaded one table i.e. Employees table so we are referring that with an index of zero.
2007-10-24, 4906👍, 0💬
Popular Posts:
How To Remove the Top White Space of Your Web Page? - CSS Tutorials - Introduction To CSS Basics The...
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...
How To Escape Special Characters in SQL statements? - MySQL FAQs - Introduction to SQL Basics There ...
How To Control Horizontal Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By...
Give me the example of SRS and FRS SRS :- Software Requirement Specification BRS :- Basic Requiremen...