Results 1 to 8 of 8

Thread: SQL SELECT Statement mismatch

Threaded View

  1. #1

    Thread Starter
    Addicted Member Alexandru_mbm's Avatar
    Join Date
    Jul 2007
    Location
    VBForums.com
    Posts
    157

    Angry SQL SELECT Statement mismatch

    What's wrong with this ?

    ERROR: Type mismatch in expression.

    Code:
            conectare_db()
    
            data_table = New DataTable
            data_adapter = New OleDb.OleDbDataAdapter("SELECT id, denumire, pret FROM servicii WHERE id IN (SELECT id_serviciu FROM contracte WHERE stare='activ' AND id_beneficiar='" & Me.txt_cod_beneficiar.Text.ToString & "');".ToString, conexiune)
            command_builder = New OleDb.OleDbCommandBuilder(data_adapter)
            data_adapter.Fill(data_table)
            Me.dgv_lista_servicii_contractate.DataSource = data_table
    
            Dim coloana_1 As DataGridViewColumn = dgv_lista_servicii_contractate.Columns(1)
            Me.dgv_lista_servicii_contractate.Columns(0).Width = 90
            coloana_1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill
            Me.dgv_lista_servicii_contractate.Columns(2).Width = 90
            Me.dgv_lista_servicii_contractate.Columns(0).HeaderText = "Cod"
            Me.dgv_lista_servicii_contractate.Columns(1).HeaderText = "Denumire / Descriere"
            Me.dgv_lista_servicii_contractate.Columns(2).HeaderText = "Pret"
    
            deconectare_db()
    I just can't see what's wrong!!!
    Last edited by Alexandru_mbm; Aug 19th, 2010 at 06:21 PM.
    I'm still learning VB.NET
    Sorry for my bad english
    Thanks for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width