Hall of Fame

1. Infinity0851,220
2. CodeCruiser43,598
3. abel41,336
4. ozo39,788
5. Shift-332,420
6. Volox32,362
7. Idle_Mind30,809
8. TheLearn...29,500
9. angelIII26,532
10. objects24,893
11. BlueDevilF...21,450
12. jkr20,900
13. evilrix20,200
14. jpaulino18,100
15. RobSamp...17,350
16. Dhaest17,186
17. emoreau16,895
18. mrjoltcola16,840
19. moorhous...14,850
20. robberbaron14,750
21. itsmeandn...14,695
22. Omego2K14,500
23. ragi001714,300
24. ToddBeau...13,632
25. sirbounty13,300

1. cookre746,814
2. Interactive...699,539
3. Idle_Mind652,501
4. ozo431,265
5. Raisor403,292
6. jaime_oliv...387,063
7. nayernag...340,059
8. AlexFM330,806
9. Arthur_...318,698
10. sirbounty314,101
11. sunnycoder276,181
12. emoreau253,836
13. mlmcc241,731
14. Kavar234,568
15. angelIII233,636
16. pratap_r233,485
17. TheLearn...212,534
18. graye208,601
19. twalgrave205,843
20. julianH195,399
21. JesterToo185,484
22. RobSamp...173,080
23. gecko_a...166,943
24. bhagyesht164,069
25. Dhaest142,204

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.2

vb.net database

Asked by peanut1010 in Miscellaneous Programming, VB Objects

What is the best connection to a database. I am using access.

I am brand new to .net and I want to create and application that connects to an access database. I have seen many examples via internet however I want to make sure I use the best possible way.

I notice that many of the examples do not use the data toolbox options most seem to be hard coded and not related to the data components. Is this good or bad. I don't even see them using the server feature either that allows you to make a connection right to the database and have access to it from vb design side. Now I know in vb 6 that data environment was horrible and really draged the system down. So I use to hard code using adodb. Example
dim rs as new adodb. recordset
dim db as new adodb.connection
I never used the components just what I listed above and to like to a text box instead of using the properties of the textbox, datafield, datasource. I would just hard code it. Seemed to be the best way.

I am currently using:

Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\database.mdb")
MyConnection.Open()
Dim MyCommand As New OleDbCommand("SELECT * FROM table1", MyConnection)
Dim MyReader As OleDbDataReader = MyCommand.ExecuteReader()
Dim i As Integer
While MyReader.Read
TextBox1.Text = MyReader("fieldNam")
End While
MyConnection.Close()
MyReader.Close()
MyCommand.Dispose()

what type is this considered. ADO.net???? Hard Coded instead of components??????

Please someone help...

View the Solution FREE for 30 Days

20091111-EE-VQP-92

vb.net database

Asked by peanut1010 in Miscellaneous Programming, VB Objects

About this solution