|
I am using the XMLDocument class to extract a specific node's data and then replace it with different data. This is done successfully but when I save the file the second line is modified to contain "[]" after the dtd declaration.
The first two lines of the XML file looks like this before I run my code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
After running my code the first two lines look like this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd[]">
The following is a bare-bones section of my code:
Dim xd As New Xml.XmlDocument
xd.XmlResolver = Nothing
'Load the xml file
xd.Load(filepath)
'Find the Element Node (INSTANCE)
Dim NodeList As Xml.XmlNodeList
Dim Node As Xml.XmlNode
NodeList = xd.DocumentElement.GetElementsByTagName("INSTANCE")
For Each Node In NodeList
If Not Node Is Nothing Then
'Find the Attribute of this element ("TRANSFORMATION_NAME")
TransformationName = Node.Attributes.GetNamedItem("TRANSFORMATION_NAME").Value
'Set the new Attribute of the element("TRANSFORMATION_NAME")
NewTransformationName = "NEW_NAME"
' Write the new TransformationName
Node.Attributes.GetNamedItem("TRANSFORMATION_NAME").Value = NewTransformationName
' Reset node to nothing
Node = Nothing
End if
Next Node
xd.Save(filepath)
For some reason when this saves to XML it modifies the DOCTYPE line to add a [] at the end of the .dtd expression, and I don't know why. If anyone could help I would greatly appreciate it.
|
|
|
|
|
I am interested in someone providing a sample that has a panel on a user control that contains a collection of controls available at design time. To put it simply I would like the following.
1. a user control
2. a panel control
3. a collection of, let's say, label controls that are accessible at design time that are contained on the panel
I understand the method to add a collection, or any control, to the properties window is <designerserializationvisibility(designerserializat ionvisibility.content)="">. What I don't understand is 1. How to create the collection of controls and where to place the <designerserializationvisibility(designerserializat ionvisibility.content)="">. 2. How to place the controls on the Panel at design time.
BTW, I haven't found this simple example on any of the forums. I think Microsoft should provide a decent example of this.
A little extra information to clarify the need. I need a user control containing a panel with a collection of controls where the user control has the collection exposed in it's property window when it is dropped on a form. This will be much like the grid control, which has a columns property in it's property window. When the user clicks on the ellipse '...' an editor pops up where you can add and remove columns and set their properties.
|
|
|
|
|
Anonymous wrote:
I was trying to use two DataReaders. I guess I need to use two DataSets?
The number of DataSets is not the problem. You can only have one active DataReader object on a connection and any one time. You can have multiple DataSets filled by a DataReader, though.
Anonymous wrote:
"mySqlConnection.Open()"
at the top of my Sub() and close at the bottom. Is this ok?
Not really. You should .Open() your connection immediately before your fill the DataSet , or do whatever you need to do with the database, then .Close() the connection as soon as your done with it. DON'T leave it open and idle for ANY reason. This needlessly consumes resources on the SQL server, not to mention hogs a very expensive licensed connection on the server too.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thanks for all your help!
|
|
|
|
|
It sounds funny, but is there any way to hide
checkbox from checkbox control?
|
|
|
|
|
I meant by program. off course I can just put another
control on top of it to hide.
|
|
|
|
|
CheckBox.Hide() should work.
|
|
|
|
|
Sorry this is in vb.
And I just want to hide checkbox only but not label
|
|
|
|
|
|
So make the checkbox and the label two separate objects.
|
|
|
|
|
The thing is I want to display chinese, japanese, English on this control
only the control can do this is checkbox otherwise i have to install
Microsoft Form 2.0 ObjectLibrary. Since Microsoft won't allow you to distribute this library with your application, I don't want to do.
It only works if you have office installed on your computer.
|
|
|
|
|
hello
im a new VB.NET user
i know there are a lot of thread bout this but
i really need a small example on how to update, delete and add
data to database
i have only 1 textbox...with 3 button(delete, add n update)
with a database name TRY
i dont need much..just a small fragment of code...
i read similiar thread before..but it is very confusing to me
please help me
thank you in advance
Gary
|
|
|
|
|
Hi,
I'm trying to bind the text property of a combobox to a property of one of my objects that is accessed using an index but I can't quite find the right way to make it work. I tried this:
<br />
MyComboBox1.DataBindings.Add(New Binding("Text", Settings.Item(0), ""))<br />
MyComboBox2.DataBindings.Add(New Binding("Text", Settings.Item(1), ""))<br />
MyComboBox3.DataBindings.Add(New Binding("Text", Settings.Item(2), ""))<br />
Which will correctly read the value from the object, but for some reason it doesn't get written back? Any ideas?
Thanks
WJ
|
|
|
|
|
Just a guess, but maybe the item you're binding TO is not allowed to be indexed. Here's a convoluted hack we have to use to get around the NULL problem with binding combos (but that's another story).
1) create an offscreen textbox (note that it can't be an on-screen textbox with the Visible property set to false (Yes, that's another story too).
2) have your object keep that textbox popuplated
3) then bind your combo to the text property of the offscreen textbox.
In your example, you'll need three offscreen textboxes.
Good Luck
john
|
|
|
|
|
Hi!When one writes more lines than the richtext visible area a scroll automatictly shows up, but it doesn't keep up with the text that is being written.I would like it to always be at the bottom, showing the latest writes.Isn't there any property or value that can be changed?I can't seem to find it.All i saw in the web was some strange confusing code with handlers and stuff... :P
Thanks in advance.
|
|
|
|
|
This question has been answered many times in the forums. I would suggest you try searching the comments before posting a new question. I answered this one back on Sept.3rd.
In order for the .ScrollToCaret function to work, the RTB must have the input focus:
RTB1.SelectionStart = RTB1.TextLength
RTB1.Focus()
RTB1.ScrollToCaret()
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi!
I can't seem to make it work.My code is like this:
RichTextBox1.SelectionColor = System.Drawing.Color.Red
RichTextBox1.SelectedText = texto
RichTextBox1.SelectionStart = RichTextBox1.TextLength
RichTextBox1.Focus()
RichTextBox1.ScrollToCaret()
Please say that my code has some stupid error, or that i need to set some property to some value.
PS:I'm sorry i haven't searched this forum for the answer, but in my PC this site is very, very, very slow (once i wanted to punch my monitor) and i don't know why it's always transferring data, it never says done...
|
|
|
|
|
Hi! It works fine after all.I had an error in my code.Sorry.
Thank you very much for all your help.
|
|
|
|
|
" SELECT PassID FROM Users WHERE (Today_Date) = #Date# " <---- gives me a Syntax error
how can i search the date field for the current date? I also have a query in Access that asks for the passid . if i can't run the search from my vb code, then how can i call the query from code and pass in the passid into the query?
|
|
|
|
|
You should never, Never, NEVER use string concantenation when building SQL queries. You should be using a parameterized query to do this. The parameter object will handle the validation and proper conversion of the date for you.
Check out the docs on the OleDbParameter class here[^] for more information.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm not using the .Net framework
I'm only trying to look for a record with the todays
date only to verify it exists.
|
|
|
|
|
This is the Visual Basic Forum, not Access. If you were writing code for this, this wouldn't be a problem, but you run the risk of getting flamed for asking questions in the wrong forums.
Since Access can store dates and time in various formats in the same column, for the best results you have to search between todays date and tomorrows:
SELECT PassID FROM Users WHERE ( (Today_Date>=#12/15/2004#) AND (Today_Date<#12/16/2004#) );
This query will work regardless if the date is also stored with the time, like "12/15/2004 10:14:23 AM". If your dates are also stored with the time, then your query never would have worked, even if you got the syntax correct.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am writing this Vb
<br />
strSQLUpdate = "SELECT PassID From Users WHERE (PassID)= " & SearchSQlPassID & " AND (Today_Date)=Date()" <--- works Sweet :)<br />
<br />
'open Connection<br />
strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RMSC LOGIN\MYDataBase.mdb;Persist Security Info=False"<br />
Set Cnxn = New ADODB.Connection<br />
Cnxn.Open strCnxn<br />
Set cmdChange = New ADODB.Command ' Create command object<br />
Set cmdChange.ActiveConnection = Cnxn<br />
cmdChange.CommandText = strSQLUpdate<br />
Set rsUser = cmdChange.Execute ' execute the SQL command<br />
Now i want to test the value of the results
<br />
If rsUser.Fields("PassID").Value = 0 Then <-- error here Error 3021 either BOF or EOF is true or the record has been deleted<br />
if the passid doesn't meet the criteria above i want it to display a message
<br />
MsgBox ("You first need to log In before you log out!!")<br />
Cnxn.Close ' Close everything<br />
Set Cnxn = Nothing<br />
Unload Me<br />
how can I test the result without throwing this error?
|
|
|
|
|
Stupid Me !!!!!!!!
why didn't I try
<br />
if rsUser.BOF then <br />
MsgBox ("You first need to log In before you log out!!")<br />
Cnxn.Close ' Close everything<br />
Set Cnxn = Nothing<br />
Unload Me<br />
else <br />
the rest of my code to log the user out
Thanks for the help!! Some times it is neededc to have a different set of eyes looking at the code
|
|
|
|
|
Hi,
I want to write a program in vb by which the user can zip or unzip the selected files without opening winzip.
How i can do that in vb. if any of you have any idea or source code please tell me.
Thanks
Syed Saba
|
|
|
|