I have code to write xml file but unfortunately the database had field name with sapce eg. "form no" but when the xml file saves it converts to
"form_x0020_no" Pls tell me if there is any solution so that xml could be written with "form_no". and at this stage of application development i cannot chnage the variable names.
I have two lines of text which have long space (more like 14-15 spaces) before the actual text. I have tried simple replace to split and merge but nothing is working. I have also tried trim and the worst thing is that ASCII gives code of 32. But nothing works. Here is the text :
your heartburn symptoms Certain foods, such as fat, chocolate, caffeine and alcohol can aggravate heartburn symptoms 1 Certain foods (BTW it's not like it looks it is. In my actual richtextbox, when I select the space it gets selected as one big piece of space like a tab and i have also tried replacing vbtab but no use)
[Code]...
i want to replace :/ and space in my date and time ex. "6/23/2011 11:48:00 am" in my lbldate.text. how can i replace this 3 character
View 8 RepliesHow would i get a certain text inside a textbox to equal that text space to space or null to space?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Textbox1.Text.StartsWith(Textbox2.Text + " ") And Not String.IsNullOrEmpty(Textbox2.Text) Then
Textbox1.Text = Textbox1.Text.Remove(0, Textbox2.TextLength)
Textbox3.AppendText("a")
End If
Btw: after i finish this step my project will be finished!
In VB.NET when I use the WriteXML of DataSet, can I customize it? That is to say; I want to make a structure like this:
[Code]...
What I am trying to do is to output a dataset into an xml document using Dataset.WriteXML(), but one of the things that I can't figure out how to do is to have what I believe are called inner nodes.What I mean by that is I have client data, but a client can belong to many companies, which I need to show in the xml as strings, so what I was thinking it should look like is...
<ClientData>
<Client>
<ClientName>[code].....
I have a dataset which I wish to export to XML. The writeXML function works fine, but if a value in my dataset is a NULL, it doesn't export that element at all, for that row. I would have expected it to export at least an open and closed element.
View 4 RepliesI have some code that creates a dataset from a backend server. I then use the WriteXML method to output it to an XML file. This works fine. But some folks have requested that I sort the output one way or the other (yes, it is easy for them to do so, but they are end users and want the computer to do all their work.) I know I can use .select to extract the data to an array, but I would then have to write that array out to a .XML file. It would be easier (I think) to just sort the data before I output it to XML. I had thought there might be something like dataset.table(0).sortColumn = 2 or something like that, but apparently not.There is only one table and the code will know which columns may be used for sorting.
View 3 RepliesWhen i output my dataset to an xml file, 87 nested tables with 218 class object (system.type.object) columms i get 247,691 instances of output like this."msdata:InstanceType="LotNet.LForm+Pointer, Learing Programs, Version=1.3.0.9, Culture=neutral, PublicKeyToken=null" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">" In this case the decluration is more then twice the size of the Pointer. Is there any way to supress this kind of output the data is only used for internal consumption by other moduals.
View 2 RepliesI am stack at work finishing my program.I have a piece of code to write an xml file.
Dim ds As New DataSet
Dim dt As DataTable = GetDtable()
ds.Tables.Add(dt)
[code]....
That work will write an XML file whatever I put in the datatable (or dataset). It is just a simple code and it works fine. The problem is it will replace the old file everytime the new file is created. I really don't want that to happen. I also want to include 2 variables (username, sessionID) also time of the file created in the file name. So file name will be Username_sessionID_time.xml rathen than a fixed name.
The code below works fine on Windows XP but raises "InvalidCharacter in path" exception on Windows 2003. It works on Windows 2003 when I remove the underscore from the foldername. I don't have a Windows 2003 machine at hand right now so I was wondering whether the underscore is a reserved character on Windows 2003.
foundFiles = Directory.GetFiles("c:junkwatch_product", "BA*.txt")
I have a question about using writeXml. When I use this method, it writes to the specified xml file like this:
<safety><Incident>
<Name>Jason</Name>
<AGE>23</AGE>
</Incident>
<Incident>
<Name>Frank</Name>
<AGE>25</AGE>
</Incident></safety>
But, I would like to add these nodes to a parent node, i.e.:
<safety><SomeNode><Incident>
<Name>Jason</Name>
<AGE>23</AGE>
</Incident>
<Incident>
<Name>Frank</Name>
<AGE>25</AGE>
</Incident></someNode></safety>
I am creating the xml by first creating a dataset (connects to an SQL db and runs a query, filling the dataset) and using ds.WriteXML(myPath)
I have a class written in VB.Net exposed to COM via the ComClass & ComVisible attributes. The class is then made available to VBA via a TLB. In VB6 you could easily mark a member hidden in the object browser but still available with a check mark. In VB.Net the only way I found to make a member hidden the VBA object browser is to prefixing the name with an underscore.
Is there a way to hide a member without underscoring it?
I've been running the same project on the same computer for months now in VS2010.
There have been no code changes to the class that contains the following [code]...
Recently, when I compile, I get an error that my class must implement event ValueChanged.
When I remove the underscore and bring the Implements piece to the same line, it compiles.
If I then undo checkout and revert it back to what the code was before, it compiles.
I have a series of variable values that use an underscore to represent the space between words (e.g., abc_def_hij or klm_nop). When trying to display them as label.content (e.g., MyLabel.Content = DataType) the label always suppresses the first underscore. The examples I gave would display as abcdef_hij or klmnop and I can't seem to find anything that defines this anomaly or how to alter its behavior.
View 4 RepliesI have an XML file that is being updated via ASP.NET. The user should be able to add new nodes to the XML file AT ANY LOCATION in the node tree.
The XML file is read into a DataSet using DataSet.ReadXml(filename).
A new row is added to the appropriate DataTable, using InsertAt(row, index).
I have confirmed using a DataGrid, and using a loop (For Each dRow in Table, Response.Write..) that the new Row was inserted into the table at the correct spot (in my example code, the 3rd position).
However, The WriteXml() method is writing the node to the END of the XML tree! I can't get it to see the tree with the node in the correct location.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sXML_Lesson As String = "test.xml"
[Code]......
I have developed a program that tracks expenses for business trips that uses just a local SQL CE database on the user's pc. I chose SQL CE because the install process was much quicker and easier than Express. I have distributed the solution and I am looking for a way to allow users to backup and restore the data. I though that the readXML and writeXML methods from the dataset sounded like a good method, but I can't get it to work. I have tried a couple methods which have ended in either foreign key errors or not being able to keep the same primary keys as when the data was exported using readXML.
The basic structure for the data is:SQL CE Database -> DataAdapter.Fill -> Dataset -> Displayed to user through binding sources and other means The problem is not exporting the dataset with .writeXML, but getting the data back into database. The one shot .updateAll from the main table adapter creates foreign key failures, so I have reverted to iterating through the dataset and sending one row at a time, but I still can't get it to work.
[code]...
I have a directory with a bunch of sub folders. I need to add a number and underscore to the main folder and all sub folders.
Example
Subfolder
Atmos_Energy
I need it to say
05_Atmos_Energy
There will be 500 subfolders, How would I have a form that can name all the subfolders at once?
I have several HotKeys setup in my program that functionally are working, my problem is with the dispaying of the text. The underscore does not appear when the program is running.I have several radio buttons that have the text property set to something like "&1 Fold" while in design mode the underscore is present, but when the program is running the underscore is not present. FYI the background is set to transparent.
View 4 RepliesI have a string that likes 1234_a34_b789 There are at least two "_" in the string. It cann't be the first or last letter. What is the regular expression pattern?
View 7 RepliesIs there any good reason not to name functions with underscores in them? I'm aware of using a leading underscore for private members etc. but why not have functions like do_this_work()?
View 7 RepliesWell my question is simple, I want to match a string with following attributesNo white spaceMust start with a letterMust not contain any other special characters other than nderscore
View 2 RepliesHow to correctly insert image data from XML file to database table using sql server CE and openxml,XML file is written by vb.net DataSet.WriteXml method?image data is stored in database table is :
0x89504E47.my XML file Content after written by WriteXml method is :
<?xml version="1.0" standalone="yes"?>
<Data>
<Table>
<image>iVBORw0KGgoAAAANSUhEUgAAAcIAAAGuCAYAAAADLg..</image>
</Table>
</Data>
but after inserting with openrowset and openxml using stored procedure to another database table its value changes to this :0x2F0039006A002F00340041004100510.and is not the first value and raises an error in vb.net for opening image from database.
txt1 = help and txt2 = me! txt3 = not here, when i enter the other box i want the okay to drop sign to come up, after drop txt1=me! and txt2 = help.if i drag to txt3 display the can't drop sign.Iv'e tried everything all i can do is replace one way.also,i want the can't drop and can drop simbols to show.so far
Public
Class Form1
Private
Sub tbMouseDown(ByVal
[code]....
I've made some good progress with my first attempt at a program, but have hit another road block. I'm taking standard output (as a string) froma console CMD window (results of dsquery piped to dsget) and have found small rectangles in the output. I tried using Regex to clean the little bastards but it seems they are related to the _ (underscore), which I need to keep (to return 2000/NT logins). Odd thing is - when I copy the caharcter and paste it into VS2K10 Express it acts like a carrige return?Going to try using /U or /A CMD switch next..
View 2 RepliesMy Regex works, except if the email address entered has an underscore character (_) in it.
Because of my lack of experience with regular expressions, I'm not sure where in my pattern I'm supposed to add the offending character to allow it:
Dim pattern As String = "^[-a-zAZ0-9][-.a-zA-Z0-9]*@[-.a-zA-Z0-0]+(.[-.a-zA-Z0-0+)*." & _
"(com|edu|info|gov|int|mil|net|org|biz|name|museum|coop|aero|pro|tv|[a-zA-Z]{2})$"
He said he fixed it by adding the _ after the numeric check.
I see the A-Z0-9, but I'm not sure which is the numeric check...
I am using a picture box. I want to be able to use the Space or Enter key to change the image in it. For that, I try to use the keydown function as follow:
Private Sub ChestWindow_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
Select Case e.KeyCode
Case Keys.NumPad1[code]....
is the function which changes the image. It works well when I press '1' on my numeric part of the keyboard as a test.The issue is that when I press Space or Enter, the form containing the picturebox closes. (I've already put the keyPreview property to True)
I have to generate an XML file from several database tables. I could use the WriteXml method of the DataSet to do it, but the database tables are really huge and I can't add all those tables in the DataSet at the same time or it may cause a problem because of the big amount of memory used. Then I decided to use the DataTable's WriteXml method and save table after table, but the the generated file only stores the information of the last DataTable.WriteXml's call. How can I preserve the previous XML data when adding all that information?
View 4 RepliesI was trying to access the following property using Reflection because I don't have the original source code (suppose this was decompiled through Reflector). It seems that something is special about it being "private virtual" or maybe because it has "_" in the beginning of the property. I can access all the other private properties no problem except this one. Just can't figure out what I am doing wrong:
private virtual String _MyProperty
{
get
[code]......
I was trying to access the following property using Reflection because I don't have the original source code (suppose this was decompiled through Reflector). It seems that something is special about it being "private virtual" or maybe because it has "_" in the beginning of the property. I can access all the other private properties no problem except this one.
private virtual String _MyProperty
{
get
{
[code]....