Search:

Type: Posts; User: JayCR

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    19
    Views
    2,023

    VS 2022 Re: Verify SQL actually submitted

    Thanks all, and I think the problem seems to have specifically been my effort to combine both the ExecuteNoneQuery with a reader, and that was part of my biggest issue.
  2. Replies
    19
    Views
    2,023

    VS 2022 Re: Verify SQL actually submitted

    Hi all, thanks for the replies. I forgot to mention, but not sure if its relevant or changes anything but... I am using ADODB to do the connection to a SQL Server but I have no idea if this makes a...
  3. Replies
    19
    Views
    2,023

    VS 2022 [RESOLVED] Verify SQL actually submitted

    I have seen different methods of ways to validate the sql has been run, some I do not understand, but the simpler options include just doing a post select statement to see what is returned, which...
  4. Re: Invalid Attempt To Read when No Data is present

    Thanks for the ongoing pointers, I missed the small VB link, linking to your code, but have reviewed and implemented it.

    I now have this called as a sub whenever the command is executed and I have...
  5. Re: Invalid Attempt To Read when No Data is present

    Thanks, is that the binding a data reader in windows forms? if so I am just reading through it now.

    Although I don't necessarily want it to appear as a table in all forms, I am looking at that as...
  6. Re: Invalid Attempt To Read when No Data is present

    Thanks for the great advice. I won't lie, I have read bits and bobs, but I never got to fully understand the reading element of it. I have tried to make sense of it but in a sleep deprived state, I...
  7. [RESOLVED] Invalid Attempt To Read when No Data is present

    Hi All,

    So given my last database was in the VB6 days, very simple and very terrible, I am trying to get some interaction between vb.net and the DB, but here goes.

    So the App will generate a...
  8. Replies
    18
    Views
    1,706

    VS 2022 Re: Index outside the array - but not sure why

    I will post all the code related to the form load here:



    Imports System.Data.Odbc
    Imports System.Diagnostics.Eventing.Reader
    Imports System.IO
    Imports System.Text
    Imports...
  9. Replies
    18
    Views
    1,706

    VS 2022 Re: Index outside the array - but not sure why

    Hi all and thanks for your ongoing assistance. I found a problem, and with a few message boxes, I am hoping this might help to clear the issue up. It seems that the sr.readline is part of the issue....
  10. Replies
    18
    Views
    1,706

    VS 2022 Re: Index outside the array - but not sure why

    So I have just checked and changed it to -1, but the error remains.186766

    This is the second row of about 300 in the document, and it is valid, so I am really unsure. The complaint itself is with...
  11. Replies
    18
    Views
    1,706

    VS 2022 Index outside the array - but not sure why

    Hi all,

    I have a text file which contains a number of different strings, one example of which is:

    Filename,Ver,OS,OSVer,Checksum,File size,Date,Time...
  12. Thread: Remove XML Nodes

    by JayCR
    Replies
    2
    Views
    341

    VS 2022 Remove XML Nodes

    Hi All,

    What is the easiest option to remove XML Nodes? I want to convert an XML document to a comma separated document?

    I would basically delete the opening nodes, and replacing the closing...
  13. VS 2022 Re: XML - Read in one full record and decide what to do with it

    Thanks both,

    The deserialising is the bit I am struggling with at the moment, and then how to put it into an array. Is there an idiot proof explanation to the above you have both described?
  14. Replies
    6
    Views
    1,344

    VS 2022 Re: [RESOLVED] XML error

    OK so to add a bit of meat to the bones here... The XML file is complicated. there are 1658827 lines to the file, that's right 1.65 million that I am working with. Let me strip some of the data out...
  15. Replies
    6
    Views
    1,344

    VS 2022 Re: [RESOLVED] XML error

    Thanks for the guidance, I tried it but have had some issues.

    I have had to start using a new XML file (the one I will be using in production, which is an export from JIRA).

    The code, and...
  16. VS 2022 XML - Read in one full record and decide what to do with it

    Hi All,

    I am working through XML, basically we have exported an XML from "JIRA". In summary we have a load of records, which come in the format of the below - I have chopped out about 40 or 50...
  17. Replies
    6
    Views
    1,344

    VS 2022 Re: XML error

    After a bit of fumbling, googling and headaching, I found a solution.



    Public Shared Sub ReadXML(ByVal InputFilename As String)
    'Dim readXML As XmlReader = XmlReader.Create(New...
  18. Replies
    6
    Views
    1,344

    VS 2022 [RESOLVED] XML error

    Hi All,

    trying my hand at something new - reading XML files. After a bit of googling, I found the following example. The xml file for this example is just an XML with the content below....
  19. Replies
    10
    Views
    1,568

    VS 2022 Re: Data binding controls disabled

    The code I am using is not generating an error:



    MODSQL:
    Public ConString As String = "data source=" & My.Settings.SQLServerName & ";initial catalog=Rochair;Integrated Security=True"
    ...
  20. Replies
    10
    Views
    1,568

    VS 2022 Re: Data binding controls disabled

    Sorry, I was at work, so just wanted to try and provide some more information, but didnt have access to the software or database.

    [QUOTE}
    Need more info. Is it hanging? Can you modify the record?...
  21. Replies
    10
    Views
    1,568

    VS 2022 Re: Data binding controls disabled

    Hi both,

    There are over 200 records in the table. I have another error in the code, which when it puts into debug mode, you hover over the recordset and it retuns multiple records. The Binding...
  22. Replies
    10
    Views
    1,568

    VS 2022 Data binding controls disabled

    I have a setup data bindings to my existing server but although ity dataset picks up the first record, the navigation toolbar is disabled without any code to do so.

    Any ideas what I am missing?
  23. VS 2022 Re: Creating Text File which is immediately

    Such a simple solution. I always thought you had to create the folder and file first, which is how I have done it for years!

    Simple fix and fixed the issue! thanks!
  24. VS 2022 [RESOLVED] Creating Text File which is immediately

    Just trying to write a log file from my app. The code (if the file does not exist) creates a ".txt" file, as the application starts. Then after the file is created, it then writes to the file to...
  25. Replies
    2
    Views
    3,618

    VS 2022 Type sqlconnection is not defined

    I have decided to re-write some software for my friend, which means my first real delve into sql.

    I started a new project and told it to "connect to database", provided the relevant details, test...
  26. Replies
    1
    Views
    564

    Access DBA Code - missing forms and code

    Hi All,

    I recently had a friend ask me to take a look at a program that was written a long time ago. They need to make it compatible with Windows 10 as its currently only compatible with Windows...
  27. Replies
    3
    Views
    944

    VS 2019 Re: adjustable table - read in from DB

    Hi Paul,

    basically, I want to use my program as an interface between excel and a database. I am looking to basically put the content of that particular table, into my for in an adjustable format....
  28. Replies
    3
    Views
    944

    VS 2019 adjustable table - read in from DB

    Hi All,

    I am looking for something, but I don't know what, so I come to you for guidance.

    My next project contains a link to a MYSQL DB. I want to read in the values, and have them displayed...
  29. Replies
    3
    Views
    1,183

    VB . NET to JavaScript

    Hi Folks,

    I need to learn a little bit of Javascript - Long story short, I need to put a mini app together for work, and the zendesk applications can have apps written, but only in JS.

    I...
  30. Replies
    1
    Views
    599

    Streamreader and missing objects

    Hi Folks,

    In my app, I have an order form which pops up, on the order form loading, it reads in the contents of the file, splits it up and throws it into the listbox. it also adds the content to a...
  31. VS 2019 Re: Variables assigned but stiHi Folks,ll Object reference not set

    Thanks for the reply Passel, and I agree with you 100%, I am open to learning, so just trying to put things to use! I don't see any feedback on here as a putdown, I need to learn, and though my code...
  32. VS 2019 Re: Variables assigned but stiHi Folks,ll Object reference not set

    I tend to pre-declare it as a shared variable, then have each sub add new items to each part of the array as it goes through. so I create a comma seperated string and add that to the shared array,...
  33. VS 2019 Re: Variables assigned but stiHi Folks,ll Object reference not set

    Thanks for the reply. In terms of coding practice, I am self taught, and not by studying it, just doing little apps here and there, so Its a case of not knowing better,

    In terms of the "-" I have...
  34. VS 2019 Variables assigned but stiHi Folks,ll Object reference not set

    Hi Folks,

    I am struggling to understand why this isnt working, maybe its the beer I had last night, and the fact I still have yet to go to sleep.

    I am taking the content of a list box, with...
  35. VS 2019 Basic XML Application - resources and guidance?

    Hi folks,

    so I am moving on and trying my hand at writing new applications. I am no expert, I am not a developer, more of a "got bored and wrote a program that helps" kind of guy.

    I am...
  36. VS 2017 Re: Connecting to and Manipulating a DB without datagrid

    I haven't any idea about using the schema personally. ADO.NET may well be the best method of connecting and using the database connection. I will look at the options.
  37. VS 2017 Connecting to and Manipulating a DB without datagrid

    Morning All,

    this may be a question asked a thousand times, but I keep getting led in a circle.

    I have a DB setup (KF.mdf) which is a single DB file, and not an active SQL instance on a SQL...
  38. VS 2010 Re: Reading text file length reports differently

    Thanks for the reply.

    Would this prevent the memory being drained on opening this application? and does it clear down after itself as necessary?

    James
  39. VS 2010 Reading text file length reports differently

    Hi Guys,

    I have a piece of software I use, which for all intents and purposes is a "grep" tool with a GUI.

    As part of the process, I read in the working files length, to set the properties for...
  40. VS 2015 Re: String to Array seperated by Node in Windows Application

    After Further Playing, this in fact almost nails exactly what I require!

    Although it only seperates by any tag, as opposed to per <FS> tag, it still allows me more control than I had before!
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width