I'm making an app in VB.net (.NET 3.5), using Oracle 10g XE, trough ODBC, I need users log in, to verify if user exists, I can validate if the query has rows of not, I've found property, but when I used it, some error appeared. Is there any other way to make that?
View 2 RepliesI have the following code;
Dim rdr As SqlCeDataReader = cm_sel.ExecuteReader
If rdr.HasRows Then
While rdr.Read
[code]...
The error I get is:
SQL Server Compact does not support calls to HasRows property if the underlying cursor is not scrollable.
So how am I supposed to check if data exists before actually reading the DataReader?
EDIT:the whole code:
Dim con As New SqlCeConnection(ConfigurationManager.ConnectionStrings("MyConnectionString").ToString)
Dim cm_sel As New SqlCeCommand("SELECT fID FROM Files WHERE fCatID=" & catID, con)
Try
[code]...
Any links to good descriptions and/or tutorials (with VB.net 2008) on OdbcDataReader? I tried, but didn't find many. MSDN is not such a good help in this case.
View 1 RepliesOdbcDataReader in showing decimal fields Decimal separator disappear with DB2 dsn
View 3 RepliesI think it is possible to overload the operator() aka "function call" as OdbcDataReader uses it. using OdbcDataReader("myField") is the same as using OdbcDataReader.Item("myField"), I want to be able to do that for my own class, is this possible, how? I've been trying with overloaded operators but no success.
View 4 RepliesThe above code does not appear to be evaluating correctly, at all for that matter. The code block is being processed regardless of the HasRows state. Any idea whats going on? I'm assuming its a setting in the Web.config or VS Dev environment thats the behavior.If I change it to
If SQLDataReader.HasRows = True Then
everything evaluates correctly.
I'm having some very weird issues with interfaces right now.
I have a very simple setup. In one of my class, I have a Property implementing a Property from an Interface.
In my class it's like:
Private _oForm As IForm
Public Property Form As IForm Implements IContainer.Form
Set(value As IForm)
[Code]...
I have like dozens of interfaces like this working throughout my project and I can't believe this simple one can't work!
Is there a way for implementers of an interface where a ReadOnly property is defined to make it a complete Read/Write Property ?
Imagine I define an interface to provide a ReadOnly Property (i.e., just a getter for a given value) :
Interface SomeInterface
'the interface only say that implementers must provide a value for reading
ReadOnly Property PublicProperty As String
End Interface
This means implementers must commit to providing a value. But I would like a given implementer to also allow setting that value. In my head, this would mean providing the Property's setter as part of the implementation, doing something like this :
Public Property PublicProperty As String Implements SomeInterface.PublicProperty
Get
Return _myProperty
[code]....
I searched on the forum / Internet for the solution how a PropetryInfo object (of a Public property) can reveal if it has a Private Protected Setter ... it was all in vain .... all help I found was about how to "Set" value of a public property having a Private Setter.I would like to know if I have a PropertyInfo object of a public property, how would I know if its Setter is Non Public?
I tried, in a exception handling block, where I did a GetValue of the PropertyInfo object and then called SetValue by setting the same value back... but to my surprise it worked well and didn error out.
[Code]...
I'm having a few problems converting some code into VB.NET from C#. Most of the translating is done, but I am getting errors when I try to run my code, and I can't figure out what is causing them. Here is the Sub I translated.
Public Sub CreateWidget()
Dim blue As LCDColor
blue.Red = 0
blue.Green = 0
[code]....
The error I receive on this line ("vision.Widgets.CreateWidget(wg1)") reads "In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user."
start with I was given a program by a friend that was created in Excel 2003 with the help of Visual Basic Editor. He said he used Visual Basic 2003, which he is not 100% sure about. Anyways he used CurLine in the program and when I try to open it in Excel 2007 and then open the Visual Basic Editor and run the program I get the following error:Run-time error '-2147418113 (8000ffff)':Could not get the CurLine property. Unexpected call to method or property access.
View 2 RepliesI have a very simple class that holds a few public properties - ID, Text, Colour, etc. and a Boolean called 'SelectedItem'. Just like the Checked property on RadioButtons, only one item can have its SelectedItem property set to True within a particular group. Note: there will be several separate groups (lists), each allowed to have only one item with SelectedItem = True.
My first thought was that I would probably just have to handle everything outside of the class, setting SelectedItem to False for every other item in a particular list when another item was selected. But that seems rather inelegant to me. So I've been trying to think of how this might be done within the class. For example: could I perhaps have a private string property called say "GroupName" - set in the New sub when adding a new instance of the class - and then use a private shared method to set every item's SelectedItem property to False, provided the item has the same GroupName as the newly selected item? I would have a go at doing this but I have no idea how to enumerate every instance of a class from within that class, or whether that's even possible. Is it? Or is there another (better) way to achieve my goal? Here is a cut-down version of what I've got so far:
Public Class ResourceItem
Public ID As Integer
Public Text As String[code]....
As can be seen: instead of instantiating a new ResourceItem and passing that as an argument to the manager's Add procedure, I'm simply passing the details of the new item and the procedure is creating the item from those. I don't know whether this is a good or bad idea - please advise - but I've done it because I couldn't figure out how to make the SelectedItem property only writeable by the manager, so I wanted to avoid having directly accessible objects that could have their SelectedItem property set to True without it deselecting all the other items in the same group. Of course that still leaves the possibility of setting a variable to one of the manager's list items and setting it from there, so I would still like to know how I could prevent that, if possible.
UPDATE: I didn't use the code above in the end, deciding instead to go with Cyborgx37's solution - which seems to work perfectly well for me despite the warnings about best practice. I also realised I would need to use the same class in another scenario where multiple items could be selected, so it was easy to add a Boolean property to the manager to enable that.
Using the following code I get Identifier expected and Property access must assign property or use its value errors:
ViewState["SomeKeyValue"]
What is wrong with this code?
I have a dataview an i would like to show the count property in a text box.
i tryied the following
me.textbox1.DataBindings.add(new DataBindind("Text",DataView,"Count"))
But i have a exception.
I have a listbox binded to a list of objects. For each list item I wanted to have a rectangle whose fill color is determined by a few properties of the binded object. So I did the following:
Made sure INotifyPropertyChanged was implemented on my object.Created a class to expose the properties I am interested in as attached properties.Binded the properties of the object to the attached properties of the rectangle Created a style that uses triggers to set the rectangle fill based on attached properties.
This works, but only the first time the property of the object changes. After that, the attached properties do not seem to be receiving notification when the data object's property changes. I have double checked and my data object is raising the INotifyPropertyChanged event.
<Rectangle Style="{StaticResource RecordStateRectangleStyle}"
Width="10" Height="10" Stroke="Black"
local:RecordAttachment.RecordState="{Binding Path=RecordState}"
local:RecordAttachment.IsDeleted="{Binding Path=IsDeleted}" />
[code]....
I have a weird question and I honestly hope you understand what is happening here: I design my form (using VB.NET) and put on it a few textboxes, comboboxes and a listview. After the design, I want to adjust the TabIndexes for each control on the form. On the right-hand side of the interface is the property box.
I then select the 'TabIndex' property item and enter a number key (for instance 0) for that selected item. I then select the next textbox control and enter the next number (for instance 1) WITHOUT re-selecting the 'TabIndex' property item. As soon as I select the combobox or listview control, the currently selected property item jumps to 'Items' or 'Collections' and does NOT remain on the 'TabIndex' property item. Why is this happening? Everything worked fine and all of a sudden this starts happening. Should I reset the editor settings or how can I resolve this matter?
I have a listbox with several list items added. I want that as user click on an item, I should be able to show its property. This should change for different items. For example (hypothetical) : Listbox has numbers 1 - 10. Now when I select 1 I should be able to set property - Name, Lastname, Colour, Age.
When I select 2 I should be able to set - Age, Hair Colour (clr shows), Weight, Date. When I select 3 then - City (combo box drop down), Country, Age only. This way value changes for diff items. One way is to put them in property grid and show them. Though this looks nice but adding/removing items in that is not easy. You need to have a class that refer that to prop grid. Do I have to code for each classes for all values in listbox or is there an easier way to manage items in property grid. If you think prop grid is not the right tool for such an activity then can you suggest something else.
I receive a System.Data.SqlClient.SqlException in the following code: Specifically Incorrect syntax near ' In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. The exception detail in its entirety is shown below the code.
[Code]...
on a Windows Form, an object myObject is bound to myObjectDataBindingSource like this:myObjectDataBindingSource .DatSource = myObject on the form, i have a check box bound to the property: chkProp1 for example of the object: myObjectDataBindingSource In the code when the checkbox is clicked, I need to go in code and change another text property of the object txtProper2 for example like this:
Private Sub chkProp1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chkProp1.CheckedChanged
[code].....
I have the following property in a property grid in VB.Net 2010.
<Description("Rapid Entry Post Car Wash Settings CarWashOptionPushButtons"), _
Category("Post Car Wash")> _
Public Property CarWashOptionPushButtons() As String
[code]....
I need to make this property a list box that gets the values from a database table and populates the list box with the values from the table. I have tried numerous things to no avail.
when I'm creating a new property in Visual Basic .NET in Visual Studio 2010, the rest of the Property (template?) doesn't complete the basic framework of the property in the code editor. It is now treating a statement like:
Public Property Length() As Integer
Instead of completing the property as it used to (code follows), it simply goes to the next line:
Public Property Length() As Integer
Get[code].....
What happens now is that, if I type in the 'End Property' code, the name of the property will now be highlighted as an error since it doesn't have a 'Get' or 'Set' portion.However, when I THEN type the 'Get' on the line following the 'Public Property Length() As Integer', then the balance of the property is created in the code automatically.I don't know how this got changed, but would love to change it back.Does anyone know if there's a setting in VS2010 that addresses this, or if it's something with the basic templates that visual studio uses for creating the basic code components?The weird thing is that for everything else, from class declarations, structures, functions and subs, the IDE still creates the balance of the code structure correctly. The only area where it doesn't is for Property declarations.
This code snippet was converted from the c# snippet on this link A ChildWindow management service for MVVM applications There are two classes in this snippet first is my confirmessage class
[Code]...
Now this works fine in C# , however in vb,net the line where I add the event handler generates the following error on the message.callback property : Property access must assign to the property or use its value I am tearing out my hair on this I have never used the Action of T delegate before so could i be missing something simeple ? I can provide the c# code as well.
Property Grid - Open a dialog box to edit a property?
View 1 RepliesSo I'm just trying to understand why someone would want to use the shorthand property instantiation
Public Property CarModel As String <-- property
As opposed to
Public CarModel As String <-- variable
I want to type the characters from right to left (to behave as a right alignment). But I am not supposed to use the Right Alignment property or the RighttoLeft property of a text box.For example, I want to enter the characters of a string from right and each character should shift one space left so that the user can enter another character after that.
View 13 Repliesgot an ErrorProperty access must assign to the property or use its value.Here i attach the code which have an error.In this program i tried to add data into form . I also create button , textbox. i am using visual studio 2005 and sql 2005. i also have attach the imagece
Private Sub btnregister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnregister.Click
admin1.LoginDataSet.staff(Me.NAMETextBox.Text, Me.TELEPHONEMaskedTextBox.Text,
[code].....
Conceptually it seems like a derived class should be able to override a readonly property with a read write property. Why isn't this possible?
[code]...
I want to assign an object property by referencing the property dynamically, with a variable name
i.e.
dim propName as string
staticObjectName.propName = 'whatever
I believe that the correct way to give a property a default value is to use the Default Attribute on the Property.[code]In the property window, the value that's displayed in a grid's property bag when it's newly dropped onto a form is False, not True. It does recognise that the default value should be True because it shows the value as bolded and then de-bolds it when we manualy set it to true - but it doesn't respect the default as the initial value. Is there any way of getting the property bag to respect the default value?
View 4 RepliesWell in my vb project it has started giving me a really weird error underlining all my msgbox codes for some reason
this is the error Error 83 Property access must assign to the property or use its value. C:UsersAidanDocumentsVisual Studio 2008ProjectsXeX 360 ModzZ B0XXeX 360 ModzZ B0XForm1.vb 56 17 XeX 360 ModzZ B0X