Realtime operations in database from VB code?

[Lars Netzel]

Hello!

Is there anyway in VB.NET (windows forms) to work in realtime on the
database? I mean entering stuff in a textbox directly, updates the
database...

Best Regards
/Lars

 

[Lars Netzel]

... I don't want to have to catch a KeyDown and then Update some DataAdapter
... that will be way to slow I asume!

/Lars

 

[Cor Ligthert]

Lars,

Is there anyway in VB.NET (windows forms) to work in realtime on the
database? I mean entering stuff in a textbox directly, updates the
database

You cannot do anything in VBNet without code why than would you assume this
will work.

(The code is made by the/a designer when you are not making it)

However you can use the executenonquery commands when you are meaning this.

http://msdn.microsoft.com/library/d...clientsqlcommandclassexecutenonquerytopic.asp

I hope this helps?

Cpr

 

[Lars Netzel]

Thanx for you answer!

I'm not trying to do ANYTHING without code, just don't think the the
KeyPress would be very good.

I'm pretty sure I in VB 6 in a beginners lesson saw an example of an object
that sort of looked like a database reader... that you could browse thru the
posts in an access database in real time with and if you changed any values
you didn't have to save or anything.

If there are no such thing.. I need to prove to my customer that this is not
possible to do in .NET and if you have anykind of link to a microsoftpage
that will explain that using an Adapter to update (or execute non query)
with is the ONLY and the best way... please post!

/Lars

 

[Cor Ligthert]

Lars,

In non Beta, (because I do not know what by instance the Express versions
are able to do in future) is as far as I know all done as you wrote.

dotNet is not a MS Access Application (what is bassicly not a devellopment
tool but an enduser application that uses the MS Access database).

I never saw a feature what can do what your customer wants in dotNet 2002 or
2003

However check this yourself to be sure it is not in there what the customer
wants and will be told to you in future.

Visual Basic 2005 Express:
http://lab.msdn.microsoft.com/express/vbasic/default.aspx


I hope this helps?

Cor