Database problems in VB.NET 2003

  • Thread starter Thread starter thorgal
  • Start date Start date
T

thorgal

Hello,

I have following problem and don't know how to solve it.

I have 1 database and multiple connections. Now i want to lock the table
where there is an insert, update or delete statement.

Is there a way to lock a table for Reading/Writing and is is still possible
to have 5 connections on the same database and the same table, just as long
as don't change anything?

Tx

I'm working with SQL SERVER 2005 (free version) and VB.NET 2003
 
Kerry Moorman schreef:
thorgal,

Why do you want to lock the table instead of using optimistic concurrency?

Unless you have a really, really unique requirement, optimistic concurrency
is the way to go.

Kerry Moorman
Click to expand...

Dear,

Because i don't no what "Optimistic Concurrency" is and what it is and
what it those, can you please explain it to me

Tx
 
Ok, i have looked at it but i still don't know how to add it in my code, off
course i now what it is but how do I implement it in my code???

Public Shared Function InsertAlgemeen(ByVal oa As clsAlgemeen) As Integer
Dim sSQL As String

sSQL = "spInsertTblAlgemeen"

Dim opar1 As New SqlParameter("@Naam", oa.Naam)

Dim opar2 As New SqlParameter("@AantalCellen", oa.AantalCellen)

Dim opar3 As New SqlParameter("@AantalCentrales", oa.AantalCentrales)

Dim opar4 As New SqlParameter("@PrinterAanwezig", oa.PrinterAanwezig)

Dim opar5 As New SqlParameter("@ResetPLC", oa.ResetPLC)

Dim opar6 As New SqlParameter("@OpstartVertraging", oa.OpstartVertraging)

Dim opar7 As New SqlParameter("@Begindag", oa.Begindag)

Dim opar8 As New SqlParameter("@Einddag", oa.Einddag)

Dim id As Integer

Dim odt As New DataTable

odt = clsDatabase.GetDT(sSQL, opar1, opar2, opar3, opar4, opar5, opar6,
opar7, opar8)

For Each DR As DataRow In odt.Rows

id = IIf(Convert.IsDBNull(DR("ID")), "", DR("ID"))

Next

Return id

End Function
 
Back
Top