Click here to Skip to main content
15,888,984 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: The Problem in Update Command with Table Adapter VB.net Pin
Member 128130747-Aug-18 22:53
Member 128130747-Aug-18 22:53 
Questioni want to do a car park booking system in vb, i use picbox to let user click, my questions is, how to link picbox to sql 2014, i means i need to know what picbox user selected, and it will auto record to sql 2014 Pin
Member 139364602-Aug-18 21:19
Member 139364602-Aug-18 21:19 
AnswerRe: i want to do a car park booking system in vb, i use picbox to let user click, my questions is, how to link picbox to sql 2014, i means i need to know what picbox user selected, and it will auto record to sql 2014 Pin
Richard MacCutchan2-Aug-18 21:50
mveRichard MacCutchan2-Aug-18 21:50 
AnswerRe: i want to do a car park booking system in vb, i use picbox to let user click, my questions is, how to link picbox to sql 2014, i means i need to know what picbox user selected, and it will auto record to sql 2014 Pin
Eddy Vluggen2-Aug-18 22:24
professionalEddy Vluggen2-Aug-18 22:24 
Questionhow to display user data after login in vb Pin
Member 139364602-Aug-18 21:12
Member 139364602-Aug-18 21:12 
AnswerRe: how to display user data after login in vb Pin
Richard MacCutchan2-Aug-18 21:48
mveRichard MacCutchan2-Aug-18 21:48 
SuggestionSome advice ... Pin
CHill602-Aug-18 21:55
mveCHill602-Aug-18 21:55 
QuestionDataGriedView Maestro - Detalle Pin
Member 1219672031-Jul-18 15:07
Member 1219672031-Jul-18 15:07 
Hola a todos, necesito de su valiosa ayuda para vincular dos DataGridView pero estoy teniendo un problema debido que me muestra el siguiente mensaje justamente en esta parte de codigo y es el siguiente: (El argumento 'column' no puede ser nulo. Nombre del parametro: Column) y no me permite vincularlo, me gustaria que me pudieran ayudar a encontrar el error de antemano muchas gracias  

Parte del código donde muestra el mensaje de error

    With ds

                .Relations.Add("Indice", _
                               ds.Tables("pa_Listar_Empresa").Columns("db_codigo_empresa"), _
                               ds.Tables("pa_Listar_Unidad").Columns("db_codigo_empresa"))

            End With






Codigo Completo



Imports System.Data
Imports System.Data.SqlClient

Public Class Form_Maestro_Detalle_Procedure

    Dim adaptador As New SqlDataAdapter()
    Dim ds As New DataSet
    Dim cmd As New SqlCommand

    Private Sub Form_Maestro_Detalle_Procedure_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        CargarDatos()

    End Sub

    Private Sub Dv_Maestro_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles Dv_Maestro.CellContentClick

        Me.lblDetalle.Text = ""
        Me.lblDetalle.Text = "Unidades: " & Dv_Detalle.RowCount - 1

    End Sub

    Public Sub CargarDatos()

        Try

            conectarse()


            '''''''''''''''''''''''''''''''''''''''''''''''''''''   
            'DataGridView maestro   
            ' ''''''''''''''''''''''''''''''''''''''''''''''''''''   
            With cmd

                ' Asignar el sql para seleccionar los datos del objeto Maestro   
                cmd = New SqlCommand("pa_Listar_Empresa", conn)
                cmd.CommandType = CommandType.StoredProcedure

            End With

            'Enlazamos el procedimiento almacenado y rellenamos el dataset
            With adaptador

                .SelectCommand = cmd
                ' llenar el dataset   
                adaptador.Fill(ds, "pa_Listar_Empresa")

            End With

            ' Enlazar el DataGridView al dataset   
            With Dv_Maestro

                .DataMember = "pa_Listar_Empresa"
                .DataSource = ds
                .SelectionMode = DataGridViewSelectionMode.FullRowSelect
                '.DefaultCellStyle.BackColor = Color.AliceBlue

            End With


            ' ''''''''''''''''''''''''''''''''''''''''''''''''''''   
            'DataGridView detalles   
            ' ''''''''''''''''''''''''''''''''''''''''''''''''''''   
            With cmd

                ' cadena sql para cargar el objeto detalle de ingresos   
                cmd = New SqlCommand("pa_Listar_Unidad", conn)
                cmd.CommandType = CommandType.StoredProcedure

            End With


            With adaptador

                .SelectCommand = cmd
                ' llenar el dataset   
                adaptador.Fill(ds, "pa_Listar_Unidad")

            End With



            With ds

                .Relations.Add("Indice", _
                               ds.Tables("pa_Listar_Empresa").Columns("db_codigo_empresa"), _
                               ds.Tables("pa_Listar_Unidad").Columns("db_codigo_empresa"))

            End With

            With Dv_Detalle

                Dv_Detalle.DataSource = ds
                Dv_Detalle.DataMember = "pa_Listar_Empresa.Indice"
                .SelectionMode = DataGridViewSelectionMode.FullRowSelect
                '.DefaultCellStyle.BackColor = Color.AliceBlue

            End With


            lblMaestro.Text = "Empresas: " & ds.Tables("pa_Listar_Empresa").Rows.Count

            lblDetalle.Text = "Unidades: " & Dv_Detalle.RowCount - 1


            desconectarse()

        Catch ex As Exception

            MsgBox(ex.Message.ToString)

        End Try

    End Sub

Los procedimientos almacenados: ambas tablas están vinculados por db_codigo_empresa

ALTER PROCEDURE [dbo].[pa_Listar_Empresa]
AS

SELECT
a.db_codigo_empresa as Codigo,
a.db_razon_social as [Razon Social],
a.db_ruc  as Ruc,
a.db_rep_legal as [Representante Legal],
a.db_direccion as Direccion,
a.db_telefono as Telefono,
a.db_correo as Correo,
b.db_denominacion as Actividad,
a.db_estado_empresa as Estado,

FROM tb_Empresa a

INNER JOIN tb_Actividad_Empresa b ON a.db_actividad = b.db_codigo_actividad 

WHERE a.db_estado_empresa = 'A' 

ORDER BY  a.db_razon_social

ALTER PROCEDURE [dbo].[pa_Listar_Unidad]

AS

SELECT 

db_codigo as Id,
db_codigo_empresa as Codigo,
db_denominacion as Denominacion,
db_direccion as Direccion,
db_estado_unidad as Estado,

FROM tb_Unidad 

WHERE db_estado_unidad = 'A' 

AnswerRe: DataGriedView Maestro - Detalle Pin
dan!sh 31-Jul-18 20:22
professional dan!sh 31-Jul-18 20:22 
QuestionCan anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Member 331739318-Jul-18 6:40
Member 331739318-Jul-18 6:40 
AnswerRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Richard Deeming18-Jul-18 7:34
mveRichard Deeming18-Jul-18 7:34 
GeneralRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Member 331739318-Jul-18 8:06
Member 331739318-Jul-18 8:06 
GeneralRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Richard Deeming18-Jul-18 8:21
mveRichard Deeming18-Jul-18 8:21 
GeneralRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Randor 18-Jul-18 15:02
professional Randor 18-Jul-18 15:02 
GeneralRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Dave Kreskowiak18-Jul-18 10:37
mveDave Kreskowiak18-Jul-18 10:37 
GeneralRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Member 331739318-Jul-18 11:29
Member 331739318-Jul-18 11:29 
GeneralRe: Can anyone Direct me to how to change Windows 'Settings' programmatically? Pin
Mycroft Holmes18-Jul-18 14:16
professionalMycroft Holmes18-Jul-18 14:16 
QuestionUSING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Member 1390609010-Jul-18 22:55
Member 1390609010-Jul-18 22:55 
AnswerRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Jochen Arndt10-Jul-18 23:49
professionalJochen Arndt10-Jul-18 23:49 
GeneralRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Member 1390609011-Jul-18 0:15
Member 1390609011-Jul-18 0:15 
GeneralRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Jochen Arndt11-Jul-18 0:35
professionalJochen Arndt11-Jul-18 0:35 
GeneralRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Member 1390609011-Jul-18 4:07
Member 1390609011-Jul-18 4:07 
GeneralRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Jochen Arndt11-Jul-18 7:06
professionalJochen Arndt11-Jul-18 7:06 
AnswerRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Dave Kreskowiak11-Jul-18 3:18
mveDave Kreskowiak11-Jul-18 3:18 
GeneralRe: USING FSWATCHER TO MONITOR FILES COPIED TO ALL EXTERNAL DRIVES Pin
Member 1390609011-Jul-18 4:06
Member 1390609011-Jul-18 4:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.