|
I need to be able to read an XML file into a database table that has been exported from another system where the schema may be different to my database table.
Is there a way to dynamically parse a schema to map fields and add them to a database table?
|
|
|
|
|
There's no autoamtic way to do it. You'd have to write the code that takes the data from each column and puts it into the correct column in the dataset/datatable.
|
|
|
|
|
Hi,
I am new to VB (using VB 2008 Express) and am trying to write a program to access my ADSL router and download the traffic statistics. The normal way to access the router is to open IE or Firefox and enter a URL. This calls the router which initiates a new "Authentication" window prompting for a username and password.
I have successfully created s simple form and can manipulate the buttons and textboxes. I can also output some text to a file. I am completely stumped though when it comes to the webbrowser box. If I implement a webbrowser1.navigate("192.168.1.1) command the router initiates an IE "authentication" window. My program stops until an entry is made into this external window. I am also not experienced enough to know if this could also be triggered from HTML or java code. Is it possible to gain control of this window from inside the webbrowser commands ?
I would greatly appreciatte some clues as to how to solve this issue. I am not asking for code as I really want to solve this myself rather than just copy and paste. That teaches nothing.
Thanks in anticipation
Regards
John
|
|
|
|
|
Hi,
We have a Windows Service, written in VB.NET. This service is set to start Automatically on machine start. Authentication/log on parameters are included while setting the Service.
However, we now notice that the service does not start on reboot, returning a Service Failed to log on error. Starting the service manually works without problem.
Server: Win 2003, .NET 2.0
Any help towards a solution would be most appreciated.
Regards,
RB
|
|
|
|
|
Write any errors that may occur during startup of the service to the eventlog. Maybe a network connection isn't ready or something similar.
Tosch
|
|
|
|
|
Have you tried setting the service to retry it's startup if it fails? You can set it to retry after so many minutes after the 1st and 2nd failed attempts.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
You may have some other services or resources on the system that are not ready when the Windows service is started, for example SQL server usually will usually not be ready when your Windows service started.
You should trap the exception to debug what is causing the failure, ie using AppDomain.CurrentDomain.UnhandledException or Application.ThreadException (can't remember which one for services, don't have the code with me now).
|
|
|
|
|
Hello to All,
When i am leaving my application for some minutes.Then again access it then my softwares textboxs color is showing black.
Do u know what is the reason behind it?
Thanks
If you can think then I Can.
|
|
|
|
|
The color of a textbox is always black. Do you mean that the background is black ? It's something weird on your machine, no code does that automatically, and if you've not written code to style textboxes, they are not going to style themselves.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi All,
Can anyone help me.
I have tried various methods and it doesnt seem to work.
I'm trying to get string before the @ in an email address
strEmail = Eddiez@gmail.nl
//Something happens here
strBefore = Eddievdz
Messagebox.show("Hello" + strBefore)
Thank you all
|
|
|
|
|
try this:
dim strEmail as string, strBefore as string
dim pos as integer
strEmail = Eddiez@gmail.nl
pos = strEmail.IndexOf("@")
strBefore = strEmail.Substring(0,pos)
|
|
|
|
|
Hi,
Try This.
dim strEmail as string, strBefore as string
strEmail = Eddiez@gmail.nl
Dim s() as string = strEmail.Split("@"c)
strBefore = s(0)
|
|
|
|
|
Thanks guys, this helped alot.Thanks a million
|
|
|
|
|
Hello to All,
How can i convert Word File,HTML File to PDF File?
Thanks
If you can think then I Can.
|
|
|
|
|
By buying a PDF library, finding a free one that works, or by writing your own converter.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Please send me basic idea for writing pdf document.
If you can think then I Can.
|
|
|
|
|
I'm speechless. Please re-read my post. You need to buy a library, or find a library, or write a library. The end. There's no 'basic idea' I could put into a forum reply, except perhaps to type 'buy PDF library VB.NET' into google. Atalasoft has one.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
eg_Anubhava wrote: Please send me basic idea for writing pdf document.
Christian already answered this. You need to either buy some converter software, or find a free version on the web. Search google and you will find many possibilities. If you wish to do it yourself through programming then you need to get a copy of the latest PDF specifications from the Adobe website. Either way it requires some small effort on your part.
|
|
|
|
|
Richard MacCutchan wrote: Either way it requires some small effort on your part.
And it's clear how that's likely to turn out....
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: And it's clear how that's likely to turn out....
You have to
|
|
|
|
|
Hi,you can convert word file,html to PDF file by pdf converter.Last week,a friend recommend Advanced pdf converter 6.0 to me,I am quite satisfied with it.It is very good in preserving the formatting. It also allow us to convert a lot files at the same time.
http://www.advancedpdfconverter.com/products/pdfconverter.html[^]
|
|
|
|
|
Do You have any help of source related in vb.net or c# ? If you can think then I Can.
|
|
|
|
|
This application is develop by .net plateform. If you can think then I Can.
|
|
|
|
|
Hello All
I have my requirement as follows.
I have a MSAccess table with 4 columns(of text type)and another column of Oletype. I have programmed in VB.NET such that a query will returns a dataTable with all the columns from that table
What im trying is to put those contents on a word document with all the columns. For which I have tried to loop through the contents of dataTable and tried to attach all those values of all columns to a string and then I have added that string to a WordDocument Bookmark as shown below.
oDoc.Bookmarks(
"Questions").Range.Text = qest
But Im unable to get that image which was stored in database column in the above fashion. so can anybody suggest a solution for my problem
Thanks in advance
|
|
|
|
|
krishnapnv wrote: oDoc.Bookmarks("Questions").Range.Text = qest
First, is an image a String?? Obviously, not. So this one line of code is not going to do it. You have to add the image to the document seperately. How do you do that?? i have no idea. I don't normally do Office Interop and am not very familiar with the Word Object Model.
A quick Google for "vb.net insert image into word document" reveals this list of examples[^].
|
|
|
|