Search:
Type: Posts; User: JayCR
Search:
Search took 0.05 seconds.
-
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.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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?
-
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...
-
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...
-
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...
-
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...
-
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....
-
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"
...
-
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?...
-
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...
-
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?
-
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!
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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.
-
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...
-
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
-
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...
-
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!
...
|
Click Here to Expand Forum to Full Width
|