ADO

Submitted by: 
Language: 
Visitors have accessed this post 12220 times.

i just wrote this code for the beginners cause i found out that some users need an introduction to ADO and how to connect vb to access.. features (ADD, UPDATE, DELETE, SEARCH) para sa mga kapwa source at beginners :) sana makatolong mamats!


Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

marunong ka gumawa ng log in/ log out, na oracle 10g yung database??

never ko pa kasi na try mag program gamit oracle eh hehe
senxa na peu same ways of coding lang sila.. VB 6 ba? o .net? to oracle?

di kopa na try mag use ng oracle eh kasi wala me oracle.. peu ano ba yan? sa vb 6 bayan? .net?

ahm sa visual basic 6, medyo nalito ako kong panu e empliment eh, ahh same way of coding lang pala

yap same way of coding hehhe actually nag start din ako sa vb 6 sa advanced lesson ko peu vb.net tinutoro samin so 2 background ko hehehe

yap same way of coding lang kaso mas matiik .net hehehe peu kung com object pag uusapan sa vb6 :) parang pag switch lang ng ADO to ADO.net

just wanna ask..
i create a program that add, save, and delete data. i used visual basic 2008 express. first, is there have any difference between visual studio 2008?
second as i click the save button. the data that i input to my textbox is automatically save in my database. i use access as my database. but after i closed the program all the data that i save is already gone. here is the code that i used.

me.validata
me.student_infobindingsource.endedit
me.tableadapter(me.sampledataset)

can you help to find what wrong why all the data is automatically deleted as i closed my program.

and can you give me some code for verifying whether the data already exist like the userID.

here my my email. [email protected]

thanks.

i look forward for the response.
^_^

download this:

//www.sourcecodester.com/sites/default/files/download/cedrick_blas/Vb.net_to_Access_Database.zip

ahmp i never tried creating program using vb 8.0 my latest software is vb 6.0 and visual studio 2008 prof ed.

i thing the only difference bet. the two is that in manipulating database
in vb 6.0 com object is very powerful tool cause of its ADO library while in .net u dont need to add more referene cause ADO bcme ADO.net

u use a tableadapter and thats not good for me..
in vb 6.0/8.0 u can use ado in manipulating data
so two ways of coding yan either ull use Recordset or Connection in inserting data such as (compile nalag ako dito huh hehehe)

Dim rs as new adodb.recordset
Dim cn as new adodb.connection

Set rs = new Adodb.Recordset
rs.addnew
rs!fieldnameofdatatbase1 = text1.text
rs!fieldnameofdatabase2 = text2.text
rs.update

or the use of connetion

cn.execute "Insert Into table1(username,password) Values('" & text1.text & "', '"& text2.text& "') "

sana makatolong refer to my code and other odes hir..salamat poh sa inu :)

Cedrick Blas
www.nwuicons.ning.com
www.greenhurtz.multiply.com
[email protected] (FB,FS,YM)

Good Luck Guys!
<<

hello,

need ko ng vb code for searching dataset and display as highlighted ung results (buong row) sa datagrid view. ung database ay gawa sa ms access. bale may text box na dun mo input ung seach key then may button na "search." Visual Studio 2008 ung gamit ko.

kahit sample code lang, thanks

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3>
  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.