ADD RECORDS TO MS ACCESS 2003 USING VB.NET PART 2

[16clairey]

more power to you sir dan.. nice tutorials., keep it up.. :)

[akosiDAN123]

@16clairey thank you :)

[ewcentes89]

sir maraming salamat sa video na to. nakatulong po to ng malaki sa project ko. Kaya lng ho my error po. naka hilight po ung da.Update(dt) tpos Syntax Error in INSERT INTO statement. . Sana po matulungan nyo ako. . .Salamat po :-(

[akosiDAN123]

@ewcentes89 Hello, if you think the code is correct and you almost follow the code in the video one possible reason you get that error is your database properties. One error in your database is that you use a reserved word for column name in your database, using of space in database table column or you have incorrect select statement in your sqldataadapter. If your database is good and you still got the error kindly send me your program and your database.

[147147147147]

@ewcentes89 solved

check your all database name if any name was mach then change that name here is link ( support.microsoft. com/kb/892608 )

copy the link and remove the space after dot

[chirocadiz09]

sir dan pde ba kayo gumawa ng tutorial para namn sa EDIT records sa access? thanks! :)

[mistrysun1]

Hi there, i'm getting a problem >> Syntax error in INSERT INTO statement.

can anybody please help me??

Thanks in advance, and great video! :D

[akosiDAN123]

@mistrysun1 Happy Holidays,

Hello,

if you think the code have no error, I guess the error is due to your database properties

like having a space in column name, using reserved words in column name like "Position". If you still have error feel free to msg me.

[16clairey]

SALAMAT po sir DAN.., tnx for the tip.. it was a very big help.. thanks again..

[naruto040108]

duga amp. ndi nya pinakita ung pagdeclare nung isa .

[sarah32896]

ur tutorial helped alot in my system, thanks! ;)

[MrMicofloro]

sir dan....nkahighlight po yung da.update(dt) <-- sabi po OleDbException was unhandled tpos syntax error INSERT INTO statement...ganyan din po ang problem ko..

[mistrysun1]

@MrMicofloro I Have the same problem, have you came to fixing it by any chance?

[xxxjoelxxx18]

pano ba mag edit ng data sa database gamit ng vb2008 at pwd bng e edit lang ang isang Coulomb ng table?

[TmoT100]

salamat pre! more power subscribed.. can i make a request? can you make a tut for uploading images into a database using oledb? i tried openfiledialog but i dont know how to restrict the files to only images.

[akosiDAN123]

@TmoT100 Thanks tol, quick info for saving img to database you can choose 2 way to do it. You can save the location to database or convert the image to binary data then save to database. If you use the location it might be easier but one con is what if the record itself is rename or have been move without notice it would be a disaster. For saving image binray to db its easier to query but kinda more complicated to save and retrieve. Btw added your request to my TODO List now.

[TmoT100]

@akosiDAN123 will watch that vid when it comes out. for now maybe i'll do option 1 cuz i dont know how to do the 2nd option. thanks again

[alaizamariecruz]

kuya dan si nend ko na sa email mo nakakita kasi ako ng email mu e ung akosidan@live.com

[akosiDAN123]

@alaizamariecruz Hello, like what I told you a while your error is on your database, try to changes the password in your database to userPassword and level to yearLevel or what ever suits you. Hope iit helps :D

[alaizamariecruz]

kuya dan. ayaw po gumana ng code na --> da.update(dt)

ano pong gagawin ko? edi dba po yun yung kailangan para masave sa database. ayaw po. :(( help naman po.:(( pls. pls. pls.

[akosiDAN123]

@alaizamariecruz hello would you mine give some more info why da.update(dt) is not working, its not just da.update(dt) you need in order to save you also need the oledbcommandbuilder.

[alaizamariecruz]

@akosiDAN123 eto po yung maling code daw.

Dim cb As New OleDbCommandBuilder(da)

da.Update(dt)

con.Close()

tpos po nkahighlight po yung da.update(dt) <-- sabi po OleDbException was unhandled tpos syntax error INSERT INTO statement. yan po.

salamat. :((

[akosiDAN123]

@alaizamariecruz Hello possible reasons is gumamit ka ng reserved words sa access like password or you use special character in your table fields like space. If in case you got error you can send me your database and project and I will try to fix it If I can if you don't mind

[alaizamariecruz]

@akosiDAN123 totoo kc nean kuya dan, sa oct 5. na kasi ippresent tong project namen, group kame kagabi pa kame nammomroblema sa database nmen. pag hindi kc nmen magawan ng database ung project nmen babagsak kame sa subject nmen na soft eng. kuya dan ayaw namen bumgsak. kaya tulungan mu nman kame magawan ng database ung project nmen. ang project is Major examination system. tsaka kuya dan anung email add mo? sesend ko ung project nmen. salamat. po wala na talaga kame mhingian ng tulong :((

[deathpedal]

kuya dan post ka nmn po kung pano mabalik ung supply ng product sa inventory kapag nagdelete ka ng ordered product

[akosiDAN123]

@deathpedal If you don't want to totally delete the record in the database set a flag field in your table. For example set the flag to 0 if temporary you don't want to use and set the flag to 1 if you want to use it again. There you need to add some condition in your select query like this to view available

"Select * from tablen1 where flag=1" sa code dinidisplay ko mga record na available.

Tol sorry hindi muna ako gagawa after na muna ng final defense namin sa thesis.

[deathpedal]

IDOL!!!!!

[marbie51610]

hello sir Dan, first of all i would like to thank you, you really helped me a lot by this video now my problem is solved, but im going to ask some questions, im working on a program, i can now save textbox inputs from vb.net to access database. But my problem is, i dont know how to save the record inputted in datagridview, my datagridview is unbound, pls help me

[akosiDAN123]

@marbie51610 Hello, about your question you need to get the datagridview cell item value then use the cell value to save it to your database. string value is equal to datagridviewname(columnINDEX,r­owINDEX) something like that. Sorry also for the late response since I'm kinda busy yet because of our thesis atm. Thanks also for appreciating the video :D

[marbie51610]

@akosiDAN123

can you give me a simple code about your answer? Gl on your thesis im also working on my thesis, thank you. :)

[akosiDAN123]

@marbie51610 Sure, added it to my TODO list now but I might not do it yet at the moment because of some school stuff. Goodluck also to your thesis.

[thehaloman96]

thank you!