dcsimg

Search:

Type: Posts; User: VBJames

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    251

    VS 2017 Re: Progress Bar while a Excel report builds

    On the .Cells(iRowCnt, 1).value = openreader.Item("Job Number") i get error advising "System.IndexOutOfRangeException: 'Job Number'

    Also my progress bar doesnt show.



    Private Sub...
  2. Replies
    5
    Views
    251

    VS 2017 Progress Bar while a Excel report builds

    Hello,

    Basically i have a Excel report thats grabs data from a SQL DB.

    While the report is being built i would like to use a progress bar with a percentage on the build of the report.


    ...
  3. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    Thank you, everyone for all your suggestions & input.

    I think this is going to be beyond my programming ability but willing to learn & hate being beaten.

    I honestly thought this was not going...
  4. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    The image in post #10 is


    169881


    Each number represents a engineer.
  5. Replies
    5
    Views
    262

    VS 2017 Re: Code Help - DataList

    Thanks Tommytwotrain,

    Your code you supplied does exactly what i want it to look like and perform.

    All i am wanting to do is create a new datalist for each engineer with their name on it and...
  6. Replies
    5
    Views
    262

    VS 2017 Re: Code Help - DataList

    Shaggy Hicker,

    Thank you for the feed back i have taken onboard on what you have said and changed it to use only the datareader.

    In regards to changing the SQL statement i dont think it would...
  7. Replies
    5
    Views
    262

    VS 2017 Code Help - DataList

    Hi,

    I am trying to create a new DataList for each engineer in Items(i) the code at the moment produces 1 DataList & with the incorrect Engineer name.

    I think i need to add another for\next...
  8. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    Hi Tommytwotrains

    I am testing on what you advised my current code:




    Imports System.Data.SqlClient
    Imports System.Data.SqlClient.SqlConnection
    Imports System.Configuration
  9. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    Hi Tommytwotrain,

    I have edited your code to include the SQL Query for the jobs and the list of Engineers 1-9 but it only writes one table.



    Imports System.Data.SqlClient
    Imports...
  10. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    Hi Tommytwotrain.

    Thanks for getting back to basically, its a job board for 9 enginners all pulled from a SQL DB backend there is also a support desk app for logging and customer & supplier...
  11. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    Sorry, here is the attachment 169825
  12. Replies
    2
    Views
    225

    VS 2017 Re: ToolStrip Menu Item From SQL

    Thanks jmcilhinney, that was what i was looking for.
  13. Replies
    2
    Views
    225

    VS 2017 ToolStrip Menu Item From SQL

    Hi,

    I am wanting to populate a menu tool strip/item from a SQL table.

    Basically the table has 2 columns Link_Name & Link_Address

    The menu has already been created in designmode and i would...
  14. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 Re: CustomControls

    Hi Boops Boops,

    I have drawn up some code already using a datagridveiw it does work to a point but it just doesnt look right.



    Dim strings(My.Settings.ListBoxStrings.Count - 1) As...
  15. Thread: CustomControls

    by VBJames
    Replies
    17
    Views
    744

    VS 2017 CustomControls

    Hi,

    Has anyone, built there own custom contols before.

    I might be asking beyond the VB.Net abilaty but i am looking at creating a Engineer Job board for my Support Desk program.

    Before this...
  16. Replies
    0
    Views
    210

    VS 2017 Opinion on the bast deisgn layout.

    Hi,

    I am wanting a design layout like this basically it be on 2 tv screens.

    The layout be like the below but 9 engineers:

    169487

    Like...
  17. VS 2017 Re: Moving from a datasource listbox to another listbox

    Ok, i will look at changing my SQL statement.

    My plan is to have one list box populated from SQL query and the user selects the engineers from the list box which is passed to another list box and...
  18. VS 2017 Moving from a datasource listbox to another listbox

    Hi,

    Basically i would like to move items from one listbox to another the idea being the selected enginners will be displayed on a Job Board.

    My first list box is populated from a data source i...
  19. VS 2017 Re: Binding a textbox to a code built datagrid

    Sorted it.......

    Removed ds.Tables("['Job_Info$']") & changed DataGridView1.DataSource = ds to DataGridView1.DataSource = ds.Tables("['Job_Info$']")

    Thanks for everyone's input and assistance.
  20. VS 2017 Re: Binding a textbox to a code built datagrid

    jmcilhinney has this not been done already in the code as my datagridview datasource = ds and i am referencing ds in my bindings.



    Private Sub Form11_Load(sender As Object, e As EventArgs)...
  21. VS 2017 Re: Binding a textbox to a code built datagrid

    apologies sorry for the bad description, what about changing the textbox once a new record is selected as my query is pulling 4 records in and would like the textbox's to show the values on the...
  22. VS 2017 Binding a textbox to a code built datagrid

    Hi,

    I am trying to bind a textbox databindings (text) to the select field of my datagridview i have done this in code rather than the GUI because of my SQL select statment.

    As my PracticeDB is...
  23. VS 2017 Re: Conversion from sring "Update Error" to type 'integer is not valid

    Worked it out before i re-checked the forum and as per si_the_geek response you are quite correct......

    Thanks for letting me know of the temporary issue i will keep my eyes open on this.
    ...
  24. VS 2017 Re: Conversion from sring "Update Error" to type 'integer is not valid

    Hi Si_the_geek,

    Thanks for your help so far, i thought that so moved
    SQLcmd = New SqlCommand(QueryOpen, Sqlcon)

    Just before the
    SQLCMD.ExecuteNonQuery but the debug is still coming back...
  25. VS 2017 Re: Conversion from sring "Update Error" to type 'integer is not valid

    Hmm ok, now the problem is the insert command works to a point:

    But the issue is



    where SupplierID = '" & result & "'"


    In debug i can see it giving the correct ID but on the.
  26. VS 2017 Re: Conversion from sring "Update Error" to type 'integer is not valid

    Grrr what a dumb **** i am i....... now i have spotted it. :blush: :blush: :mad: :mad: and the blooming error told me what to look for......
  27. VS 2017 Conversion from sring "Update Error" to type 'integer is not valid

    Hello,

    First i am loving this forum, it has been very helpful and learnt a fair bit going through past posts.

    But i am here again :( after several hours of trying to work this outi thought i...
  28. Replies
    1
    Views
    219

    VS 2017 Forcing an application to close

    Hi,

    Whats the best methord to force a form not a application to close my plan is the following.



    Dim msgresult as dialogresult
    Catch ex As Exception
    msgresult =...
  29. VS 2017 Conversion failed when converting the varchar value

    Hi,

    I am getting a error on my Notes section of my GUI for DB i know its the notes area as if i leave the nortes section blank it adds the new record correctly.

    Error:169069

    The orginal...
  30. Replies
    2
    Views
    298

    VS 2017 Re: SQL Insert Into

    Again didnt see this got to learn from your mistakes thanks Shaggy Hiker
  31. Replies
    2
    Views
    298

    VS 2017 SQL Insert Into

    Hi,

    I have tested the command in SQL Managment studio and i can add a company easily with the insert into command.

    But my code picks up this error:

    169041

    Here is my code:
  32. Replies
    3
    Views
    230

    Re: Finding Duplicate In SQL DB

    Worked it out :bigyello: :bigyello: :bigyello:

    Dim Sqlcon As SqlConnection = New SqlConnection("Data Source=JAMESPC\SUPPORTDB;Initial Catalog=Support_DB;Persist Security Info=True;User...
  33. Replies
    3
    Views
    230

    Finding Duplicate In SQL DB

    Hi,

    Does anyone know whats the best way for finding if a record exists in a SQL DB.

    Here is my current code


    Private Sub btnaddeng_Click(sender As Object, e As EventArgs) Handles...
  34. VS 2017 Re: Incorrect syntax on SQL Update and text trim

    Thanks GaryMazzone must of got the wallpaper effect worked a treat.
  35. VS 2017 Incorrect syntax on SQL Update and text trim

    Hi,

    My application i am creating is a SupportDesk ticketing system.

    I am at the point of removing a engineer from my SQL DB.

    We dont want to delete the engineer so its deactivated by adding...
  36. Replies
    1
    Views
    197

    VS 2017 Combo Box Populate From SQL2017

    Hi,

    I have a Combobox + textboxes that that is populated from a databinding mode on form_load it works correctly.

    But if i select a different company i wanted the textboxes to show the SQL data...
Results 1 to 36 of 38



Featured


Click Here to Expand Forum to Full Width