|
nyjcr wrote:
VB is supposed to be this easy to learn, "foolproof" language...Its not!
.Net has made so many thing with VB much easier than previous versions, with the exception of connecting to a plain ol Access database. I miss using vb6 only for data, but im really starting to get the hang of ADO.Net and am starting to like it.
|
|
|
|
|
I have searched now for 3 hours, it is time 2 ask some people if it is posible. My question: I have a project for school and I made an awsom cartoon illustration for the application, but the app needs some textboxes ass wel. But I don't want to let the illustration get behind the textbox so you can't see it anymore.
Is ther a way to set the alpha of an textbox to 50% or sow? So that both are visible? That would be very nice. I have tryed some things bud nothing seems to work. Opacity works only with the form, Transparency Key doesn't work for me because if I set it 2 white, you can't see the box anymore but you can see right trough my programm, sow that is not what I want.
Are ther some people who know if this is posible and how to do this?
Sory for my English.
|
|
|
|
|
Can I use multiple resource files in VB? It seems that the IDE will only let me work with one...
Thanks,
Tim
|
|
|
|
|
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
|
|
|
|