Good morning, I have a Windows Form (vb.net) and I am dynamically creating multiple DateTimePicker controls. The number of controls depends on how many employees are currently registered in the database. So for each employee they get a start and end time control for their schedule. I have read multiple articles and solutions and I am simply stuck. I need 1 handler to fire anytime a timepicker value is changed. Once the value is changed, the textbox next to it will show the timespan in hours that will be added to the schedule...

Any help would be great

Dim DateTimePicker As New DateTimePicker
                DateTimePicker.Name = "Start" & counter
                DateTimePicker.Size = New Size(80, 25)
                DateTimePicker.Location = New Point(Combo2.Location.X + 135, Combo2.Location.Y)
                DateTimePicker.ShowUpDown = True
                DateTimePicker.Value = "1/1/2018 06:00 AM"
                DateTimePicker.Format = DateTimePickerFormat.Custom
                DateTimePicker.CustomFormat = "hh:mm tt"
                Me.Panel2.Controls.Add(DateTimePicker)

                Dim DateTimePick As New DateTimePicker
                DateTimePick.Name = "End" & counter
                DateTimePick.Size = New Size(80, 25)
                DateTimePick.Location = New Point(DateTimePicker.Location.X + 90, DateTimePicker.Location.Y)
                DateTimePick.ShowUpDown = True
                DateTimePick.Value = "1/1/2018 12:00 PM"
                

Select all Open in new window

…

Good morning everyone! I am creating a system for work and part of that system is viewing a weekly schedule. Essentially I have a Windows Form that I dynamically create text-boxes for each employee in our database. Then for each box, it generates 7 more boxes for each day of a full week. I do this so I can add new employees to the database and the schedule auto generates the information. Anyways, I have a dynamically generated combobox at the top that holds dates of the current month and those dates represent every Monday of the month. I want the schedule to extract dates between the selected combobox item and that value +7 days...I ran the debugger and on the line that attempts to pull the date from the combobox I get an "object reference not set to an instance of an object". Here is my current code

This block creates the combobox and sets its properties

 Dim combo As New ComboBox 'Create a new combobox for the form
        combo.Name = "ComboBox1" ' set the combobox name as "ComboBox1"
        combo.Size = New Size(152, 35) 'Set the ComboBox Size to the same as the textboxes below
        combo.Location = New Point(20, 19) ' Set the combobox ontop of the textboxes
        combo.FormattingEnabled = True 'enable formating so the date is a shortstring
        combo.FormatString = "MM/d/yyyy" ' set the desired format
        Me.Controls.Add(combo) ' add the control to the form
        Dim Date1 As Integer = DateTime.DaysInMonth(Now.Year, Now.Month) 'Set date1 as 

Select all Open in new window

…

I am teaching myself visual studio with visual basic. Please help a newbie.

I have a connected sql table setup as follows
TABLE [dbo].[Suffix](
      [SuffixID] [int] IDENTITY(1,1) NOT NULL,
      [Suffix] [nvarchar](3) NOT NULL,
      [myCount] [nvarchar](5) NULL,
 CONSTRAINT [PK_Suffix] PRIMARY KEY CLUSTERED

I created a visual basic windows form in visual studio.  the save button on the form as the following code behind it in the click event.
            cmd.CommandType = System.Data.CommandType.Text

            cmd.CommandType = "insert into Suffix values ('" & TextBox30.Text & "', '" & TextBox28.Text & "')"
cmd.Connection = con
            con.Open()
            cmd.ExecuteNonQuery()
            MsgBox("Succesfully added", MsgBoxStyle.Information, "add")
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try

I keep getting the following error Conversion from string "insert into suffix value ('txx'" to type 'integer' is not valid.

How do I fix this?

Hello,
Any suggestion on how I can use Adobe in my vb.net app  to generate PDF from system.bytes(memory Stream).

Thanks

I have a drop down list using vb.net.  I want to refresh the drop down list if not
completed or another drop down list is selected ie I want the drop down list to display
the initial settings not where I let off when last visited.  At this time if I hit the refresh
button, the values are reset.  How can I reset in code and the best place to do this in code.

Currently from what I see so far the app is using session close.

Hello Experts.

I have learned from past experience that it can be hazardous to make changes to a back-end data table when it is bound to an existing VB.NET project in Visual Studio.

I would like to believe that it is possible to pull this task off without crashing my project, and would like to seek any advise from the EE community on how to do this.

Specifically, I have a single MDB file which contains a dozen or so tables and queries/views, with all their relationships. Everything is created/designed using MS Access 2016.

I want to change the primary key on one of the tables within that MDB. That would also require removing some of the relationships, and establishing new ones as needed.

Right now, the primary key for the Roster table is sequentially assigned, but the first non-primary field is and always will be unique, so I would really like to change it.

So, I am looking for some step-by-step instructions from someone who has successfully done this within the context of a previously bound Visual Studio project.

As always, don't hesitate to ask if I've left any important details out.

Thanks,
Tony G.

In this example from this post

https://www.experts-exchange.com/questions/29119837/clearing-a-Header-Row-CheckBox-in-a-DataGrid.html

My DataGrid looked like this:


Notice my CheckBox column is the 1st column of the DataGrid

My button click event looked like this, this worked fine:

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

        ' reset header checkbox
        Dim dgHeader As DataGridItem = DGEmployees.Controls(0).Controls(0)
        Dim targetChkBox As CheckBox = dgHeader.Controls(0).Controls(1)
        targetChkBox.Checked = False
        CType(DGEmployees.Controls(0).Controls(0).FindControl("DataGridEmployees_SelectAll"), CheckBox).Checked = False

    End Sub

Select all Open in new window

In these 2 lines of code:

        Dim dgHeader As DataGridItem = DGEmployees.Controls(0).Controls(0)
        Dim targetChkBox As CheckBox = dgHeader.Controls(0).Controls(1)

What are these references?

.Controls(0).Controls(0)
.Controls(0).Controls(1)

Is that the first row and 1st column?

So if my datagrid looked like this (the checkboxcolumn is the 6th column of my datagrid),


How do I reference the 6th column of my datagrid?

I tried this but it didn't work,

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

        ' reset header checkbox
        Dim dgHeader As DataGridItem = DGEmployees.Controls(0).Controls(0)
        Dim targetChkBox As CheckBox = dgHeader.Controls(0).Controls(6)
        targetChkBox.Checked = False
        CType(DGEmployees.Controls(0).Controls(0).FindControl("DataGridEmployees_SelectAll"), CheckBox).Checked = False

    End Sub

Select all Open in new window

I get this error message:

Specified argument was out of the range of valid values.
Parameter name: index

Hello,

How to export image to PDF995. I am using vb.net 2017 desktop.

Thanks in advance.

we are going to migrate a vb6 project to vb.net or c#.net. I want to use a converter tool at least for the screen drawings. did anynoe try  Microsoft Visual Studio 2008 expressfor that purpose?

I have written an application that runs as a Windows Desktop application , running on a windows 10 laptop that occasionally crashes. The crash may happen after 24 hours, maybe 60 hours - maybe longer, sometimes not at all.
The Widows Event Viewer shows that the application crash was preceded by an Error from the ,Net Runtime- at around a minute before athe application is reported to have crashed.

Is this an application error or due to the KERNELBASE.dll? Or something else!

The details of the error are:

Log Name:      Application
Source:        Application Error
Date:          24/09/2018 01:20:16
Event ID:      1000
Task Category: (100)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      C-035
Description:
Faulting application name: MyApplication.exe, version: 2.0.7.10, time stamp: 0x5ba4b1a1
Faulting module name: KERNELBASE.dll, version: 10.0.17134.1, time stamp: 0x149ab0fd
Exception code: 0xe0434352
Fault offset: 0x0010d722
Faulting process ID: 0x1958
Faulting application start time: 0x01d451f2970b38f1
Faulting application path: C:\Program Files\Company1\MyApplication.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report ID: 212dc380-af79-47ed-9362-dc496bd13999
Faulting package full name:
Faulting package-relative application ID:
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Application Error" />
    <EventID …

<%

If (XYZ IsNot Nothing) Then 

 Response.write(XYZ)

End If

%>

Select all Open in new window

This gives me an error:

Server Error in '/' Application.
Object reference not set to an instance of an object.

How can I test if XYZ is actually defined?

ASP.NET Web form app with VB.NET back end code.

Is there a way in the RowDataBound event in VB.NET to change the Font used for just a single column in the GridView control?

I have a GridView bound to a data source and for the a single column only in the GridView I want to use the Wingdings3 font so I can put the triangle symbol in that column.
Example of label/legend on form:

Here is my code that I just started changing the first nested IF.  The line I added for the Font change is incorrect syntax.  What would the syntax be?
I don't need to do it at the cell level necessarily if there is a way to change the whole single column to that font too, that would work as long as the header for that column would not change or could be blank:

    Public Sub OnRowDataBound(sender As Object, e As GridViewRowEventArgs) Handles GridViewHierachical.RowDataBound

        If e.Row.RowType = DataControlRowType.DataRow Then
            If e.Row.Cells(1).Text = "Delayed" Then
                e.Row.Cells(1).ForeColor = Drawing.Color.Red
                e.Row.Cells(1).Text = "p"  ' <== Wingdings3 character used to produce a down pointing solid triangle
                ' Change the font for column one to wingdings3 ==>  GridViewHierachical.Columns(1).DefaultCellStyle.Font = New Drawing.Font(GridViewHierachical.DefaultCellStyle.Font)
            End If
            If e.Row.Cells(1).Text = "Potential Early" Then
                

Select all Open in new window

…

Hi,

I need to serialize vb.net code to json.

I need the json to look like this:

{
    "KalTid": [
        {
            "AnstNr": "1",
            "Datum": "2014-01-02",
            "RadId": "9b8412eb-77a4-4e0b-853e-fdd78edeac8a",
            "UseTid": true,
            "StartTid": "08:00",
            "SlutTid": "08:00",
            "Timmar": 8,
            "Dagar": 0,
            "TidKod": "SJK",
            "UseBrukare": true,
            "UseResEnhet1": false,
            "UseResEnhet2": false,
            "UseResEnhet3": false,
            "Brukare": "1",
            "ResEnhet1": "",
            "ResEnhet2": "",
            "ResEnhet3": "",
            "Registrerad": true,
            "CalcTyp": "",
            "Source": "PORTAL"
        }
    ]
}

Select all Open in new window

The vb.net classes I'm using are looking like this:

Imports Microsoft.VisualBasic
Imports Newtonsoft.Json

Public Class KalTid
    <JsonProperty("AnstNr")>
    Public Property AnstNr As Long

    <JsonProperty("Datum")>
    Public Property Datum As DateTimeOffset

    <JsonProperty("RadId")>
    Public Property RadId As Guid

    <JsonProperty("UseTid")>
    Public Property UseTid As Boolean

    <JsonProperty("StartTid")>
    Public Property StartTid As String

    <JsonProperty("SlutTid")>
    Public Property SlutTid As String

    <JsonProperty("Timmar")>
    Public Property Timmar As Long

    <JsonProperty("Dagar")>
    Public Property Dagar As Long

    <JsonProperty("TidKod")>
    Public 

Select all Open in new window

…