Visual Basic

Public Sub SqlCommandPrepare()
    Dim id As Integer = 20
    Dim desc As String = "myFirstRegion"
    Dim rConn As SqlConnection = New SqlConnection("Persist Security Info=False;" & _
                 "Integrated Security=SSPI;database=northwind;server=mySQLServer")
    rConn.Open()
    Dim command As SqlCommand = New SqlCommand("", rConn)

    ' Create and prepare an SQL statement.
    command.CommandText = "insert into Region (RegionID, RegionDescription) values (@id, @desc)"
    command.Parameters.Add("@id", id)
    command.Parameters.Add("@desc", desc)
    command.Prepare() ' Calling Prepare after having set the Commandtext and parameters.
    command.ExecuteNonQuery()

    ' Change parameter values and call ExecuteNonQuery.
    command.Parameters(0).Value = 21
    command.Parameters(1).Value = "mySecondRegion"
    command.ExecuteNonQuery()
End Sub

moomoooomoo wrote:

1.) how to change the columns using datagridview into a
comboboxcolumn at runtime?

moomoooomoo wrote:

2.) how to populate the comboboxcolumn at runtime? from codes...

' Retrieve the data for the combobox
Dim DataForCombo As DataTable = SQLStuff.GetDate()

' Create a new ComboBox column
Dim col As New DataGridViewComboBoxColumn
With col
    .HeaderText = "Column Header in DGV"
    .DataPropertyName = "ID column name in the table the DGV is showing"
    .DataSource = DataForCombo
    .ValueMember = "ID column name in DataForCombo table"
    .DisplayMember = "Column name for the data shown to the user in the ComboBox"
End With
DataGridView1.Columns.Add(col)

Jens Johanneson wrote:

Is there a way to send a message from one dll to other dlls which is NOT compiled in the same exe file?

Jens Johanneson wrote:

Any suggestion how the third party system "loads" the dll's?

Jens Johanneson wrote:

Am I able to "connect" to its namespace/work processes to see which dll's it runs?

Jens Johanneson wrote:

Can I use the references in the XML file to get hold of loaded dlls?

Jens Johanneson wrote:

I'd rather not have a "poor coders" solution with temp files or status flags in the registry. I would like to see some kind of dll message switch - is there any?

Jens Johanneson wrote:

"...The only other way to do this would be to write a plug in that implements this functionality..." - is it possible to write an "umbrella plug in" which only purpose is to send messages between our dlls?

Jens Johanneson wrote:

where or for what should I start looking for to gain some skills in such coding techniques? Is there a convept name?