AllExperts > Experts 
Search      

VB.NET

Volunteer
Answers to thousands of questions
 Home · More Questions · Answer Library  · Encyclopedia ·
More VB.NET Answers
Question Library

Ask a question about VB.NET
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Syed Adeel Rizvi
Expertise
I can answers questions regarding web based and desktop based programming in VB.Net. Which can include XML, Custom Controls + Computer Hardware and Windows Turboshooting...etc. More Skills : 1 . PHP - > All Type Of CMS e.g. (Joomla,Drupul,PHPNuke...etc) 2 . ASP 3 . ASP.Net 4 . CMS 5 . MySql 6 . SQl Server 2000 & 2005 7 . Ms Access 8 . Web Designing 9 . Networking Turboshooting 10 . Windows Turboshooting 11 . Hardware Turboshooting All Type Of Work Related To IT I also Do Work as a Freelance as Application & Web Developer & Designer

Experience
i have 3 years work experience in software house and 4 years work experience for computer hardware and Networking..

Organizations
110 Solutions

Education/Credentials
Bsc (Honors)

 
   

You are here:  Experts > Computing/Technology > Basic > VB.NET > DataSet in VB.net

Topic: VB.NET



Expert: Syed Adeel Rizvi
Date: 3/22/2008
Subject: DataSet in VB.net

Question
What is DataSet in Vb.net, When i can use DataSet.please Give me some code that is Use dataset.I am using MS SQl Server.

Answer
Hello,

Dataset is just like a table structure Like

Table - 0
 |_ Rows & Column

Dim Ds as new Data.DataSet
Dim Conn as new Data.OledbConnection
Dim CMD as Data.OledbCommand

Sub LoadData()
Conn.ConnectionString = "Your ConnectionString"
Conn.Open

Cmd = Conn.CreateCommand

Cmd.CommandText = "Select * From Table_name"

Ds.Load (Cmd.ExcuteReader,Data.OverwriteChanges,"MyTable")

If ds.Table(0).Rows.Count > 0 Then
'ds.Table(0).Rows(0)<- This Row Index ("FirstName") '<- This Column Name

msgbox ds.Table(0).Rows(0)("FirstName")
End If
End Sub

Thank you

Add to this Answer    Ask a Question



  Rate this Answer
   Was this answer helpful?
Not at allDefinitely              
   12345  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.