what is the best way for me to get data from a form (textbox) and pass it to an access database
i need it to create a new row get data from 4 textboxes and also the current time and then pass the variables into an sql query(prob) and into the database
i no howto set the variable and the datetime.now but whats the cleanest way of inserting the new row
cheers binks
HOWTO Get data from my form and pass it to an Access databes
Ayyappan
hi,
the cleanest way is to you use dataset and tableadapter
lessons 8,9 have a good example http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx
actualy access follow the same rule as sql server except during importing database you select microsoft access instead of sql server but you will deal with both the same in IDE
hope this helps