Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOW TO READ SQL RECORDS EXCLUSIVLY....

Status
Not open for further replies.
vijithamar

vijithamar

Programmer
Feb 14, 2002
29
IN
HI

i am trying to read sql server records exclusive...
but it is not working (sql server 2005 and vb.net)

this is my code

dim cmd As New OleDb.OleDbCommand
cmd.Connection = Conn
cmd.CommandText = "select batch.Stock from Batch WITH (XLOCK) order by BatchId"
dim dataredr As OleDb.OleDbDataReader = cmd.ExecuteReader

i am getting the records but not exclusive.

please help me.


 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
211
Ken01
Ken01
sal21
  • Locked
  • Question
read xml file 1
Replies
9
Views
226
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
124
Swi
Swi
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
321
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
137
Niki_S
Niki_S

Part and Inventory Search

Sponsor

Back
Top