need a databaase, SQL : Access

[proKrastinate]

I am doing a project for myself to give to my boss just to refresh and increase my skills in vb and to learn .net.

my first question is how to incorporate a SQL database, but that doesnt have to be answered here Ill search the forums.

the second i didnt know how or what to search for in the forums for the answer. if i use either SQL, access, or anything else as a database, does the recipient of my program need either one of these programs for it to work or do they need some kind of user installation package that would allow them to make use of databases given to them in a particular format?

 

[Derek Stone]

For Microsoft Access databases you can simply distribute the .mdb file, and make sure the user has a compatible version of MDAC installed. Youd then use the System.Data.OleDb namespace to interact with one.

Things arent quite the same with SQL Server though. You cant just distribute a file. The user needs to have SQL Server installed, at the very least have access to a server running it.

 

[proKrastinate]

im trying to learn, looking up resources on the net and trying to download tutorials from kazaa and planet source code but i cannot seem to get the hang of connecting a datagrid to a database, and displaying the information in the database on the datagrid.

i want to use access 2000, so i have to use the oleDb.oleDbConnection(). but i cant seem to udnerstand anything farther than that.

i tried tools connecto to a db, and using the Jet 4.0 Ole to connect to the db, and it successfully connected. i than just tried to drag/drop the actual table listed onto the datagrid itself hoping this would work but under my form a OleDbConnection1 textbox looking thing appears along with a OleDbAdapter1. whats exactly happening?

 

[Derek Stone]

I just posted an example of connecting to SQL Server in a recent thread. Try searching for it. The code to connect to an Access database is almost identical to it. Simply replace all instances of "Sql" with "OleDb" and change the connection string.

 

[proKrastinate]

really, its almost identical. ive been skipping all these tutorials and such online etc because they were saying how to connect to sql server. thx