I have created a datagridview on a vb.nt form with drug_id,brand_name,date_made,date_expired as columns and i want to get a vb.net procedure or vb.net code that will insert the data on the datagridview to my Access database when i click insert button on the form.My database contains int_id column which is autoincremental and my datagridview contains several rows.Thanks for anticipated help.
samuel terngu
0
Newbie Poster
Recommended Answers
Jump to PostHope this gets you started, it creates the insert query "q". You will need a connection and a command object.... You should read up on Datasets - Datatables - Datagridview - MS ACCESS. There are much easier ways of doing what you want. Please show what you have tried.
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.