Imports System.Data.OleDb

Public Class Form3

    Dim cmd As New OleDbCommand
    Dim rdr As OleDbDataReader
    Dim strmsg As String
    Dim db As New mydb1
    Dim da As New OleDbDataAdapter
    Dim dset As New DataSet

    Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        strmsg = "select Class from Week"

        cmd = db.dbcommand(strmsg)

        rdr = cmd.ExecuteReader
        'While rdr.Read

        'End While

    Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles  ComboBox1.SelectedIndexChanged
        cmd.CommandText = "select * from Week where Nme = '"& ComboBox1.Text.ToString &"' "
        rdr = cmd.ExecuteReader
        txtClass.Text = rdr.Item("Class")


    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        cmd = db.dbcommand("insert into Week(Nme,Score,Class) values(Default,'"& Val(txtScore.Text) &"',Default ) where Nme = '"& ComboBox1.Text.ToString &"'")


following are the screenshots of error and my table

Recommended Answers

All 6 Replies

You have a few problems to clear up before we can answer your question.

  1. You need to use the Code tool to insert code or you lose all formatting (I fixed it up for you this time)
  2. You did not attach any screenshots
  3. Your question is confusing

Please provide more detail.

By the way, you don't need to use ToString on something that is already a string. Just use


how i attach the screen shots

In the editor's toolbar, click "Files". You should get some "Choose" buttons. If you select a file, it will be automatically uploaded and attached.

i try to attach my screenshots,but i cant,please help with this

here i am attaching the screen shots,please have a look on this

If you are not going to provide full information then you are not going to get help. For example, what is

 Dim db As New mydb1

I presume mydb1 is a user written class but there is no way of knowing what this is because you haven't provided the code. We don't know what your database looks like or even what type of database it is because, again, you seem more interested in playing twenty questions than in getting an answer.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.