proKrastinate Posted December 6, 2002 Posted December 6, 2002 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 I'll search the forums. the second i didn't 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? Quote
*Gurus* Derek Stone Posted December 6, 2002 *Gurus* Posted December 6, 2002 For Microsoft Access databases you can simply distribute the .mdb file, and make sure the user has a compatible version of MDAC installed. You'd then use the System.Data.OleDb namespace to interact with one. Things aren't quite the same with SQL Server though. You can't just distribute a file. The user needs to have SQL Server installed, at the very least have access to a server running it. Quote Posting Guidelines
proKrastinate Posted December 8, 2002 Author Posted December 8, 2002 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 can't 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? Quote
*Gurus* Derek Stone Posted December 9, 2002 *Gurus* Posted December 9, 2002 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. Quote Posting Guidelines
proKrastinate Posted December 10, 2002 Author Posted December 10, 2002 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.