I making a program that is used to signup students willing to join a university computer club... i'm using an access database and i've already connected the database to the program and i'm adding, deleting and updating students .. but my first problem is that i haven't figured out away to search the database... so if there is anybody that can help me out here ...
Also my other problem is that i'm using this project to help me learn programming and vb.net better and i have a couple of books to help out so i connected the database using the wizard and i used some simple coding as well for the inserting and deleting....etc as one of my books showed . my other book showed another way that i liked better it used sql for the modification of the database but it didn't workout ...the problem is that i don't know where the error is .. but i feel that it's somewhere in the connecting or making tha adapter or dataset?? so what i need is that if some could help me out with the steps of doing so...
an example of the code i'm using for inserting to the DB:
Private Sub add()
Try
Dim newRow As DataRow = Dsqucc1.mainTable.NewRow
newRow("firstName") = txtFirstName.Text
newRow("lastName") = txtLastName.Text
newRow("studentNo") = txtStudentNo.Text
newRow("email") = txtEmail.Text
newRow("pass") = txtPassword.Text
newRow("experiences") = rtxtExperiencies.Text
newRow("cellPhone") = txtCellPhone.Text
newRow("pcHours") = cboPcHours.Text
newRow("netHours") = cboNetHours.Text
newRow("comments") = rtxtComments.Text
newRow("ranking") = cboRanking.Text
newRow("memberLevel") = cboMemberLevel.Text
Dsqucc1.mainTable.Rows.Add(newRow)
Catch
MessageBox.Show("error", "error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign)
End Try
End Sub and then to update the database i use :
dbQuccAdapter1.Update(Dsqucc1, "mainTable")
So whats the SQL way?
thanks alot.
Nov 18th, 2005, 10:12 AM
searching an access database?
Threaded Mode