Can VB.NET directly execute sql command like VB 6??

[alan]

Can VB.NET directly executing the sql command for insert, update and
delete but not using data adapter.insertcomand, adapter.deletecomand,
adapter.updatecomand?

Just like in VB6 , I can directly using sql to do that kind of action.

Alan

[Fergus Cooney]

Hi Alan,

And, oops, sorry - I've been looking at Bob's name instead of yours!

Regards,
Fergus

[Fergus Cooney]

Hi Alan,

That was an erroneous correction. Double oops! Sorry to give you a false
ray of hope there. With any luck there will be some bright sunny guys in the
morning.

On the other hand they may suggest
news://msnews.microsoft.com/microsof...amework.adonet
as an alternative source of wisdom.

Regards,
Fergus

[Jody Fisher]

Alan

Generally we now work with our datasets in disconnected mode thus the need
for the dataadapter

You can execute lines of sql script against an SQL server by using the
sqlcommand object

dim con as new sqlConnection("Server=servername; database=dbname
username=username password=pwd")
dim cmd as new sqlCommand("insert into tbltable (f1,f2) values
('hi','goodbye')",con)
con.open

cmd.ExecuteNonQuery()

let me know if this hasn't answered your question

Regards

Jody

"alan" <sm*****@sinaman.com> wrote in message
news:b3**************************@posting.google.c om...

Can VB.NET directly executing the sql command for insert, update and
delete but not using data adapter.insertcomand, adapter.deletecomand,
adapter.updatecomand?

Just like in VB6 , I can directly using sql to do that kind of action.

Alan

[Cor]

Hi Alan,

In addition to Jody's answer.

I saw in a post line below this that you are using Oledb, it exist also as
Oledbcommand

Cor

dim cmd as new sqlCommand("insert into tbltable (f1,f2) values

[Herfried K. Wagner [MVP]]

* "Fergus Cooney" <fi*****@post.com> scripsit:

On the other hand they may suggest
news://msnews.microsoft.com/microsof...amework.adonet
as an alternative source of wisdom.

Policeman!

;-)

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[EricJ]

you could have a look at this
http://msdn.microsoft.com/library/de...ml/daab-rm.asp
code would be
SqlHelper.ExecuteNonQuery(gstrCnn, CommandType.Text, "insert into tbltest
....")
"alan" <sm*****@sinaman.com> wrote in message
news:b3**************************@posting.google.c om...

Can VB.NET directly executing the sql command for insert, update and
delete but not using data adapter.insertcomand, adapter.deletecomand,
adapter.updatecomand?

Just like in VB6 , I can directly using sql to do that kind of action.

Alan

[Cor]

Hi Herfried,

I have 5 times made a message like this and 5 times deleted it again.

It took al long time for me to find something that i could add to the answer
of Jody, because that was a short and complete answer in my eyes. Happenly I
found it in the thread beneath it..

:-)

Please mark your OT messages with OT?

:-)))))))))))))))))))))))))))))))))))))))))))))

Cor

[Jay B. Harlow [MVP - Outlook]]

Alan,
In addition to the other's comments. David Sceppa's book "Microsoft
ADO.NET - Core Reference" provides a wealth of knowledge on everything
ADO.NET. It is an easy read to learn about ADO.NET, plus a good desk
reference for double checking things later.

The above book goes into how the data Connection objects are related to the
data Adapter objects, data Command objects, and data Reader objects.

It then goes into the related (yet independent) DataSet family of objects
(DataSet, DataTable, DataRelationship, DataColumn and DataView).

It covers some of the more powerful & useful features of ADO.NET that many
developers can overlook.

Hope this helps
Jay

"alan" <sm*****@sinaman.com> wrote in message
news:b3**************************@posting.google.c om...

Can VB.NET directly executing the sql command for insert, update and
delete but not using data adapter.insertcomand, adapter.deletecomand,
adapter.updatecomand?

Just like in VB6 , I can directly using sql to do that kind of action.

Alan

[Mike Caputo]

Cor, just a quick language tip... "Happenly" is not a word in English... I
assume you're translating "erfreulicherweise", but it doesn't translate
directly... the best translation is "Fortunately" or "Luckily" (like
glucklicherweise). That's all, just wanted to let you know.

Mike

--
Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.

"Cor" <no*@non.com> wrote in message
news:uO**************@TK2MSFTNGP10.phx.gbl...

Hi Herfried,

I have 5 times made a message like this and 5 times deleted it again.

It took al long time for me to find something that i could add to the answer of Jody, because that was a short and complete answer in my eyes. Happenly I found it in the thread beneath it..

:-)

Please mark your OT messages with OT?

:-)))))))))))))))))))))))))))))))))))))))))))))

Cor

[Cor]

Hi Mike,

Thank you, I am very happy that you told it. I used it without thinking. My
native language is Dutch; therefore those German words mean less for me than
the English equivalents. In Dutch the first sentence would be.

Dank je, ik ben erg blij dat je het vertelde.

Cor

Cor, just a quick language tip... "Happenly" is not a word in English... I
assume you're translating "erfreulicherweise", but it doesn't translate
directly... the best translation is "Fortunately" or "Luckily" (like
glucklicherweise). That's all, just wanted to let you know.

[Herfried K. Wagner [MVP]]

* "Cor" <no*@non.com> scripsit:

Thank you, I am very happy that you told it. I used it without thinking. My
native language is Dutch; therefore those German words mean less for me than
the English equivalents. In Dutch the first sentence would be.

Dank je, ik ben erg blij dat je het vertelde.

In German:

Danke dir, ich bin sehr froh (or "erfreut") [darüber], dass du es (or
"das") gesagt hast.

Very similar too.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Improve your quoting style:
<http://learn.to/quote>
<http://www.plig.net/nnq/nquote.html>

[Fergus Cooney]

Night porter in a busy conference centre?