Re: Class definitions: VBA vs. VB .NET

Tech-Archive recommends: Speed Up your PC by fixing your registry

Ed,

Although this is not really a subject of this newsgroup.

Have a look at the input file HTML element.
It is mostly hard to find but this is to upload a file to a server

http://msdn.microsoft.com/en-us/library/system.web.ui.htmlcontrols.htmlinputfile(VS.85).aspx

Going the FTP route as a newbie results mostly in nothing as you need to many persons to help you.

jmo

Cor

"Ed Sowell" <jag_man__REM0VE__653@xxxxxxxxxxxxx> wrote in message news:D158C138-F6D3-4B74-B4E2-CA02F03B13EB@xxxxxxxxxxxxxxxx
I much appreciate the discussion and am getting to know the problems, no matter what the direction. After the tech at my hosting service told me I couldn't read csv (not sure that is true, but it's what he said) with MySQL (which is what they provide) I decided to convert my cvs file to MySQL on my Windows machine. I then spent a couple days installing MySQL, reading the manual, and posting questions to the MySQL Newbies Forum. It seems that MySQL keeps all databases in what appears to be binary form, so it's not simply a matter of moving my Web app files and a data file from my machine to the hosting server after getting my Web app working locally. I'm advised I have to export the database from MySQL on my machine, ftp it to the Web host server, and then use MySQl_import on the host. I'm sure all of this can be done, but the complexity builds. One thing I don't understand at this point is how to do the import at the Web host server. The hosting service does not allow telnet access, so apparently I can run MySQL in a command window. How am I to do that? Guess that's a question for the Weh hosting tech...

Thanks again.

Ed

"Cor Ligthert[MVP]" <Notmyfirstname@xxxxxxxxx> wrote in message news:%23KBsrtauJHA.4592@xxxxxxxxxxxxxxxxxxxxxxx
Now we agree again (completely)

:-)

Cor


"Tom Shelton" <tom_shelton@xxxxxxxxxxx> wrote in message news:f168e410-ec96-46c8-8ef5-eaf6dff4c100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 9, 7:19 pm, "Cor Ligthert[MVP]" <Notmyfirstn...@xxxxxxxxx>
wrote:
Disagreed Tom,

I once started with Net like Ed and that was with using an XML file to do
things (which became very quick a dataset).
Horrible to get that well because that you have to check that it is always
completely right rewritten.


I guess I should say, that I would actually use a database solution
for this as well. I was only commenting on Scott's comments on file
locking.

I checked this thread because I have given Ed a solution how to use a CSV
file. But that has the same problems as an XML file or any serial file.


I mentioned the office xml, because I think for simple readonly data
as he's talking about is a much simpler solution. Especially when
using LINQ to XML. I would post code, but all of my stuff is in C#.
I have code to generate xml spreadsheets as well as read them. I also
have some code I've been working on to convert Microsoft Word XML
documents to WPF FlowDocuments.

Of course, xml has the same problems if you are having to lock the
file - what I was pointing out is that the OP is using the data in a
read only fashion. But, using the OLEDB reader could introduce
problems IF it performs file locking. Simply having two vistors hit
the site at the sametime can cause issues in that case. Using simple
file io, you can control that by opening the file in shared mode -
but, I personally like to work with XML over csv if you go in that
direction :)


I would use in Ed's place direct an SQL Server Express database like the
advice of Scott especially now that this is freeware.

I direct this to you, but it is more for the OP that I write it like this.

I agree that overall, the database is the best solution. But, that
really depends on his hosting provider as to what is available - and
what the OP is willing to learn, do etc. But, given the choice
between working with CSV and XML - I would take the XML.

--
Tom Shelton


.

Quantcast