How to execute a command

flashanimator

Execuse my beginner's question but I've not found the answer anywhere. Tell me please how to execute an SQL string that doesn't return a recordset. What I try to use conn.Execute (string.Concat ("use ", treeView1.Nodes [i].Text), null, (int) ADODB.ExecuteOptionEnum.adExecuteNoRecords); the compilator doesn't accept any type of the second parameter. Tell me please how to make working with command.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

mibuyt21y ago
Hi, Just add on. You should look into the benefits of ADO.NET while coding .NET. Cheers.
miker21y ago
Back to English. ADO.Net is a .Net implemetnation of ADO. You can start learning it here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconoverviewofadonet.asp I'm sorry, I did not even look into the link I gave you. My message to you was: look around.
flashanimator21y ago
???????? ????? ??????, ??? ????? ADO.Net, ?. ?. ????? ??? ??????. ????? ???? ???????? tutorial ?? ????, ? ?? ??? ???????? ???????????? ???????? ????? ??????? ? ?????????? ?? ??????????? ??????????, ??? ?? ???? ?? ???????? ? ????? ?????????, ? ???????????? ??????.
miker21y ago
????, ? o????? ?a? ?o-?????? ??o??o ?o?o?? ??o ?a? o?o?? ?a? ??o???? ?????. ? o?????? o? o??a?????. ? ???? ??o ?? A ? ?o??, ??o ?o ??o ?a? ????? ? ??o???? - ?? ?????a ?????. ? ?? ???? ?? ??????? ?a .Net, ?o ????? ????????? ??o ??a??? ? ???o??. ?, ??o?? ?o?o, ? ?????o ?? ?????? ??o ?? ??o???? ?o?????? ????? o???? ?a ??o? ?o??o?. ?o??o????? ?o???a?? ?a ?????? ?a??a?. ?o? ?a? ?a??????? o???: http://www.dotnetcoders.com/web/Articles/ShowArticle.aspx?article=54
flashanimator21y ago
ADODB for me is usual, may be I can use it if I'll find a good tutorial how to read a query result using it (including updating) and how to execute a command.
miker21y ago
Is that older ADO? Why don't you use ADO.Net?