How to execute a command

Question

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.

mibuyt · Answer

Hi Just add on. You should look into the benefits of ADO.NET while coding .NET. Cheers.

miker · Answer

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.

flashanimator · Answer

???????? ????? ?????? ??? ????? ADO.Net ?. ?. ????? ??? ??????. ????? ???? ???????? tutorial ?? ???? ? ?? ??? ???????? ???????????? ???????? ????? ??????? ? ?????????? ?? ??????????? ?????????? ??? ?? ???? ?? ???????? ? ????? ????????? ? ???????????? ??????.

miker · Answer

???? ? 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

flashanimator · Answer

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.

miker · Answer

Is that older ADO? Why don't you use ADO.Net?