|
Hmmm seems you have 2 distinct problems.
1. Unicode in a client dataset - I'm sure it can be done, but I have not had the requirement.
Noctris wrote: How can i get a decent formatted XML file from a datatable
2. Datatabe/set to xlm is simply xmlDataset.writexml(memorystream/variable) I think!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You will need to run a REGEX session on your string before you send it to your XMLWriter.
Search GOOGLE for xml unsafe characters and ASCII code to see what you should turn those funny characters into. Since you are making your own server / client application you can set your own REGEX standards for conversion of characters.
IE: REGEX finds a "&" in your input string. You replace "&" with a @045; and send that to your XMLWriter.
|
|
|
|
|
I've Searched for hours and still can't find the answer: How would you load an HTML Page from the resources file into a VS.NET WebBrowser Control using VB?
It's an essential part of my application and I'm quite new to VB. Can anybody Help?
|
|
|
|
|
You can do:
WebBrowser1.DocumentText = My.Resources.HTMLFile
Where HTMLFile is the name of the HTML page you added to the Resources.
Alternatively, you could write out the text of the HTML file and then navigate to it:
My.Computer.FileSystem.WriteAllText("c:\file.html", My.Resources.HTMLFile, False)
WebBrowser1.Navigate("c:\file.html")
I don't know of a way just to load the HTML file in the webbrowser control straight from the resources but that may be due to ignorance on my part.
|
|
|
|
|
Thank you for your response. However I'm still having a little trouble.
Apparently My HTML Page is not a member of My.Resources.
Everything else is appearing in the intellisense panel apart from my web page and style sheet.
Has Anybody got any idea why this might be?
|
|
|
|
|
I had problems with adding a resource once for an HTML file. I ended up booting it to the curb and writing my own HTML structure internal.
Below is a quick HTML entry you can stream towards your WebBrowser object and it will work just fine. It builds a basic web page with a table and has simple Java script support VIA a text box entry. I also disabled any right click to view source function with the entry in the body section oncontextmenu=return false;
Give it a try you may find this easier to deal with.
=========================================================================
Dim tik As String = """"
TextBox.Text = "Add some internal Java Script stuff here if you want for a pop up window or what not"
WebBrowser1.DocumentText = "<%@ Page Language=" & tik & "VB" & tik & "%>" & ControlChars.NewLine & "<html><head><meta http-equiv=" & tik & "content-type" & tik & " content=" & tik & "text/html" & tik & ">" & ControlChars.NewLine & "" & _
"<script language=" & tik & "JavaScript" & tik & ">" & ControlChars.NewLine & "" & _
"<!-- hide" & ControlChars.NewLine & "" & _
"" & TextBox.Text & "" & _
"// -->" & ControlChars.NewLine & "" & _
"</script>" & ControlChars.NewLine & "" & _
"</head>" & ControlChars.NewLine & "<body topmargin=" & tik & "0" & tik & " marginwidth=" & tik & "0" & tik & " marginheight=" & tik & "0" & tik & " bgcolor=" & tik & "#FFFFFF" & tik & " text=" & tik & "#000000" & tik & " link=" & tik & "#000000" & tik & " vlink=" & tik & "#000000" & tik & " alink=" & tik & "#000000" & tik & " oncontextmenu=" & tik & "return false;" & tik & ">" & _
"<font size=" & tik & "2" & tik & " face=" & tik & "Arial, Helvetica, sans-serif" & tik & " color=" & tik & "#000000" & tik & "><table border=" & tik & "0" & tik & " width=" & tik & "610" & tik & " cellpadding=" & tik & "0" & tik & " cellspacing=" & tik & "0" & tik & " bgcolor=" & tik & "#FFFFFF" & tik & ">" & _
"<tr><td><font size=" & tik & "2" & tik & ">•<a href=" & tik & " http://www.codeproject.com" & tik & " target=" & tik & "_blank" & tik & "><b> Code Project Rocks! </b></a><br>" & _
"Where would we be without the help of everyone at Code Project?!?!<br><br></td></tr>" & _
"</table></font></body></html>"
|
|
|
|
|
why not save the file as a .txt file and add it to your resources, then save it as an .html file when you need it? ( or keep it a .txt file the whole time? )
How many bytes of text have I typed in my lifetime??? Man, I wish I kept track...
|
|
|
|
|
Hi all
Noob question 
I'm using different web services depending on whether I want to connect to the development back end server or the production one. I'd like to choose which web service to use based on a setting in the web.config file. If I use a case statement (or if etc) to define my object the code complains that the object isn't declared.
e.g.
if Appsettings("Debug") = "True" then
dim myObj as new devServer.Service
else
dim myObj as new prodServer.Service
end if
myVar = myObj.somethingClever
name myobj is not declared
Can this be done in some other way?
Thanks
Dave
|
|
|
|
|
Your issue is that myObj exists within the scope of the if statements. Set myVar to be the right service within the code block, or define myObj outside it, so that it's visible outside of the scope of the if statement.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
Sure, I understand why the example doesn't work. For this trivial example it would be easy enough to define myVar within the code block. However, my question is whether there's another way of approaching this problem.
Dave
|
|
|
|
|
It depends. I would probably put the two web services inside a single property that returns the right one based on the version, so I only do the check in one place. Beyond that, I don't see any better way to do it.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
We took a different route. When the user logs on they choose the server they want to work against. Typically they may have production, and 2-3 analysis servers they want to connect to. Additionally they can connect to UAT and dev servers by choice.
So we pass in the server name from the UI. Caveat - all the servers must use the same credentials. We do have a different set of creds per application.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Interesting. But how are you actually using the server name in the code? The problem I can't get my head around is how to do this without explicitly using the server when I define my objects.
|
|
|
|
|
Different development paradigm - all my objects are late bound. So during development the form objects are placed and named using a standard convention. A class is created to supply the CRUD and any other processing for each table.
At runtime the class gets the table via the DAL and a utility binds the 1 row to the form elements or dumps the table into a datagridview.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
This is for a Windows Application, not a Web. Anyways I have a Datagrid and I'm setting it's datasource to a table in the database i'm using. If in that table there is a column thats numeric, if i change that numeric column in the datagrid and i enter a non-numeric value and lose focus, the datagrid will catch this on it's own and display a message automatically. But i need to catch this when i click the save button so i can catch all errors at once and display in a single meessage.
If there is any way to disable this or trick the datagrid could someone please let me in on it, because i've been searching for a while and had no luck finding anything.
|
|
|
|
|
Change the numeric field to text and validate on save!
You lose any numeric settings for the column but it won't error
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have a window service that will alert until a file is read
the ftp write the code below to a log file where sent signify the file has be read
can someone help me with a subroutine in vb .ne that will return boolean indicating whether the file has be read or not
#Software: Microsoft Internet Information Services 5.1
#Version: 1.0
#Date: 2008-06-10 09:04:08
#Fields: time c-ip cs-method cs-uri-stem sc-status
09:04:08 192.168.114.55 [1]USER anonymous 331
09:04:08 192.168.114.55 [1]PASS IEUser@ 230
09:04:16 192.168.114.55 [2]USER anonymous 331
09:04:16 192.168.114.55 [2]PASS IEUser@ 230
09:04:17 192.168.114.55 [3]USER anonymous 331
09:04:17 192.168.114.55 [3]PASS IEUser@ 230
09:04:17 192.168.114.55 [4]USER anonymous 331
09:04:17 192.168.114.55 [4]PASS IEUser@ 230
09:04:42 192.168.114.55 [3]created MS+Pricelist.xls 226
09:14:25 192.168.114.55 [5]USER anonymous 331
09:14:25 192.168.114.55 [5]PASS IEUser@ 230
09:14:25 192.168.114.55 [5]sent /MS+Pricelist.xls 226
09:14:30 192.168.114.55 [5]sent /MS+Pricelist.xls 226
09:19:47 192.168.114.55 [6]USER anonymous 331
09:19:47 192.168.114.55 [6]PASS IEUser@ 230
09:19:47 192.168.114.55 [7]USER anonymous 331
09:19:47 192.168.114.55 [7]PASS IEUser@ 230
09:19:47 192.168.114.55 [7]sent /MS+Pricelist.xls 226
09:19:47 192.168.114.55 [7]sent /MS+Pricelist.xls 226
09:19:47 192.168.114.55 [8]USER anonymous 331
09:19:47 192.168.114.55 [8]PASS IEUser@ 230
09:23:23 192.168.114.55 [9]USER anonymous 331
|
|
|
|
|
About the only thing that comes to mind is to check the System.IO.File.GetLastAccessTime, but quite what you want to do with it is up to you.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
am using ftp
just look at the file give me idea on how to get the sent if you know about log files
|
|
|
|
|
Ok, I misunderstood your question. All you need to do is read the log file, look for "sent" in the row and get the file name.
If you post your code I will be able to see where you are going wrong.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I am reading rss feed using webrequest class object and showing its title in my application.
Can we have something that gives whether that particular feed is changed/updated at particular datetime so that I can update my application's data/content.
Rite now I am comparing string value of previous one and the one which is fetched on particular instance of time. This will use my bandwidth even if that feed is not updated !!!
Thanks,
regards,
divyesh
|
|
|
|
|
You need to have a look at the rss feed. They mostly have a date stamp of some kind, but how are you going to know if it has updated without fetching it to check anyway?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: but how are you going to know if it has updated without fetching it to check anyway?
magic
Telepathic software - my favourite.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I had an error in a program I was working on. A dialog box came up saying
"do you want to view Disassembly?" I clicked OK just for the fun of it, and
now every time I run the program it opens a new tab in VB.NET titled
Disassembly.
My guess is I checked an option to view the disassembly every time.
However, I really don't want this to happen!
Does anybody know how to turn this off again?
monika
|
|
|
|
|
Hi,
In the Tools Menu, click on Options tab. In the Debugging properties on the left pane, you can see there is a check box on the right side, describing 'Enable address-level debugging'. Under that there is another check box with the description 'Show disassembly if source code is not available'. Uncheck the same if you have checked it and try again.
Meeram395
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
