If I have the following structure:[code]How can I select it in a conditional like this? [code]I know that myUsers.Contains(.ID = "1") is totally wrong, but I am curious how to do something like that?Is it possible? Is this a job for LINQ?
View 3 RepliesI have a table that has a "date" column and an "amount" column. I also have a form with two DateTimePickers ("dtp1" and "dtp2"), a button and a label. The label should show the total amount calculated from the rows whose "date" value is between the dates picked by the user with the DateTimePicker controls.
I keep getting an error with my SQL statement, and I don't know what to try. My code is as follows:
Private Sub getData(ByRef total As Double)
Dim connection As OleDbConnection
connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\proyectogestion.mdb")
[Code]....
I have bee trying to figure out, how to match generic types, without the type parameter in a IF-ELSE statement - heres what i mean:
<P>IF TypeOf(Obj) Is GenericTypeExample(Of ???Any???) Then</P>
<P>End if</P>
Im using visual studio 2005 and access 2007 as database. I have already connect the database which have two table with two gridview in a web form (asp.net). Now i want to compared the data in the two gridview, and those who are matching should be displayed in a pop up Text box. All this should be done by clicking on a single button.
The following is the codes which i have tried and it does not work. I dont know where the problem. The following codes are for those who does not matched, which will be display. please answer should be in vb.net not C#
These codes are found inside my button "compare"
I two files like this
Error File:
[2 14.20 34.8] X8.435 Y-1.070 211.030
Short +215.534
[Code]....
From error file also i dont know how to get P value. If i used Index of ("P"). There are some other word also which contain P. Then code is not only taking the value i want from NodeList file but whole line.
Using an OLEDB connection I want to do a select statement but for the table I am selecting from, a table member also has to be there too which seems to be messing up my results. Normally I would write to get the column "col1":
SELECT lib1.table.col1 FROM lib1.table
For the table I need the information from, the table has a "submember". From what I have gathered the syntax is something like this:
SELECT lib1.table(submember).col1 FROM lib1.table(submember)
The problem is that the results are giving me every column within the table, not just my "col1" data.
how do I overcome it? I have created a class and compiled into .dll This code
[Code]...
In Visual Studio 2008, if I do this:
[Code]....
Does anyone here know how to get the above to work WITHOUT warnings being generated?
In the following code i get a warning at line 59:Warning 1: Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.and.. At line 78 I get this Warning:
Warning 2 Property 'SelectedCustomer' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.
The program compiles and runs well, but i cant' undesrtand the reason for these warnings. Any Idea ?
1: Public Class Form1
2:
3: 'Form level members
4: Private objCustomers As New ArrayList
[code]....
Cannot appear to be able to get this function to not have the above error.Private Function GetIncidentActions(ByVal FromAgentID As Integer, ByVal ToAgentID As Integer, ByVal incidentAction As Integer, ByVal ActionDate As Date) As String
[Code]...
I have users check off lab facilities in a UI. I want to use linq to fetch corresponding records for all of the labs that they have checked off. Basically,
Dim myRecs = (From l As EpiData In myDataContext.EPIDatas Where l.facility= _
one of the checked labs
So basically, I need to write a linq query where the "strings" to match are determined at runtime. Is there any way to do this easily? I know that there is a library out there called dynamic LINQ, but (1) it's in C# and I'm writing in VB (2) I'm really just looking for a single, simple solution for this single case.
I've encountered a problem which challenges my understanding of access modifiers in VB.Net. I have a class declared Friend. If I declare its properties Public, the application works. If I declare them Friend, the application fails.
Before this, I believed that, in a class declared Friend, it would make no functional difference whether I declared the members Public or Friend. I thought class access declarations applied their restrictions to all nested entities, so nested properties declared Public were effectively restricted as if they had been declared Friend. Obviously, I was wrong. Can anyone explain how access modifiers really work, or point me to the relevant documentation?
Here is a more detailed description of the situation: I have a Friend class called StripTask with properties called StripDate, HistorianDate, and TaskText. I have a collection of StripTasks (called _StripTasks) which is used as the data source for a Syncfusion GridDataBoundGrid. The way the binding works, I need to pass the name of a StripTask property to each of the grid columns so each column knows what data to display. It ends up looking something like this:_DataBoundGrid.GridBoundColumns(1).MappingName = "StripDate". When the mapped properties are declared Public, it works. When the mapped properties are declared Friend, the grid is populated with the correct number of rows, but every cell is empty.
As a follow-up question, is it a good idea to avoid things, such as this Syncfusion binding method, which require me to pass property names as strings? It just feels as if I'm inviting trouble.
I realize that this is a very basic question, but it's been a long time since I've played with VB. Why can't I call the Synch() Sub/Function in my CMMS_SCAD_CLASS class from my Main module? I get the following compile-time error:
'Synch' is not a member of 'ConsoleApplication1.CMMS_SCADA_CLASS.'
Main class:
HTML
Module Main
Sub Main()
Dim meterClass As New CMMS_SCADA_CLASS()
[Code]....
i made a class which has speed,symbol (string "*") and location what is the acceptable way to actually display the class symbol property on the screen ?the class will be stored in a list<OF T> and will contains hundreds dynamically instances
View 6 RepliesWe have a coding standard that says all shared (static) fields and methods must be called with the class name. E.g. NameOfClass.whatever Is there a tool that we can use to check this is in fact the case? (Likewise for modules) I should have make it clearer we are using VB.NET.
[Code]...
I have a custom class called "Time" with the following function, for determining if one Time equals another Time.
Public Shared Shadows Function Equals(ByVal Time1 As Time, ByVal Time2 As Time) As Boolean
Dim x(2) As Integer
x(0) = CInt(Time1.Hour)
x(1) = CInt(Time1.Minute)
[code].....
Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.I know it shouldn't do any harm, just let the compiler skip evaluation, but is it a way of getting rid of this warning?
How should class member variables be used in combination with class methods?Let's say I have a class 'C' with a member variable 'someData'.I call C.getData(), which does not return a value but instead puts data in C.someData. The class that instantiated 'C' first calls C.getData and then uses the data by accessing the member variable C.someData.I call C.getData() in the class that instantiated 'C' which is a function that returns data.I myself prefer the second way. But it also depends on the situation and it's a small difference. Is it 'bad' to have class methods that depend on the classes internal state? What are the best conventions?
View 2 RepliesWhats the difference between these two initialization methods for obj? I've seen both of these, but know know if there is an appropriate time to use one vs the other. I found this post which covers C#, but not sure if the same applies to VB.Net.[code]
View 3 RepliesI have a routine that accepts a List of Objects, a property name and a value to search for and simply returns whether or not it found it.The code I have hangs up at the For loop in the findit routine.[code]
View 4 RepliesI want to replace the Public Declarations that I currently store in a Module with a Class.Currently in my Module I have a declaration like this:
Public SetPath As String = My.Computer.FileSystem.SpecialDirectories.MyDocuments
How do I get the same functionality from a Class?
Public Class Audits
Private _SetPath As String
Public Property SetPath() As String
[code]....
I know I can reference the SetPath in code by doing a Dim aud as New Audit so my question is this. Where is the correct place to put the
= My.Computer.FileSystem.SpecialDirectories.MyDocuments
And is this an good example of a member that should be shared? If so does both the Private and the Public need to be shared. I just started using Refactor Pro and it almost always is recommending that I make all members shared. Is there ever a good reason not to do so?
i have a question about how to write an if else statement. I was experimenting with vb 2008 and wrote a program that adds few numbers together and displays the result in textboxes. for example i input the following 4 number in 4 different textboxes
14 3 1 5
and the result i get is 15 8. I was trying to simulate adding times together(eg 14:03 + 1:05 = 15:05). Everything seems to be working fine but how can i place "0" if the output for the minutes is less that 10? eg instead of having 8 in the textbox i would like to have 08.
I have a bunch of classes that all contain a Shared ReadOnly Dictionary. If I want to access that Dictionary when the class is a generic type (such as when I have a wrapper function that takes T as an interface that all of these classes implement), what's the way to do it?
I want to do something like GetType(T).GetMember("Dict"), but that will return a MemberInfo type, and that cannot be cast to a Dictionary of my defined type(s). For calling functions this way, one can use a delegate + CreateDelegate + GetMethod. But there doesn't seem to be an equivalent Create*for GetMember stuff. Or am I missing something?
If I plug the GetMember call into the immediate window, and then use a subscript as if it is an array, then the debug output says I am getting a Dictionary back. But if I use that same approach in the actual function that I am trying to write, then I get an error about System.Reflection.MemberInfo cannot be converted to Dictionary(X, Y)
I need to avoid serializing an Event class member because when the event is handled by an object that is not marked as Serializable the serialization will fail.
I tried using the NonSerialized attribute on the Event class member but it fails to compile. This line of code:<NonSerialized()> Public Event PropertyValueChanged()
produces the following error: Attribute 'NonSerializedAttribute' cannot be applied to
'PropertyValueChanged' because the
attribute is not valid on this
declaration type.
Public Event PropertyValueChanged() ' compiles but needs the extra handling described below
Is there another way to avoid serializing Event members? This is not a problem if the event is not handled and I can work around it by cloning the objects (and ignoring the event) before serializing them. Just wondering if there is a better way.
I know that the MenuItem class contains an internal class named MenuItemData, which contains itself an internal member named onDrawItem. Given a MenuItem, I want to retrieve the object corresponding to the member onDrawItem. But all I manage to do is to get the FieldInfo, not the object itself.
Here is my code:
Dim obj As Object
Dim fi As FieldInfo
Dim item as System.Windows.Forms.MenuItem
Dim mType As System.Type
[Code] .....
When reaching the last line, I get an error saying something like that (it's traduced):
The field 'onDrawItem' défined in type 'System.Windows.Forms.MenuItem+MenuItemData' is not a field of the target object of type 'System.Windows.Forms.MenuItem. I don't know what object to pass to the GetValue function on the last line. My goal is to remove the base eventHandler of the menuItem, named DrawItem. See this post and the function RemoveClickEventin the accepted answer for a better understanding.
I am attempting to fix a vb.net (using Visual Studio 2005) and while I have extensive experience using VB6, my vb.net skills are pretty much as a beginner.I've added some code to this program which calls a stored procedure but it won't run becauseof an error when it compiles:
Error 1 'usp_select_media_to_removeNoGenres' is not a member of 'Lynd.Data.TestDatabase._StoredProceduresClass'
[code]....
I would like to understand the Pro & Cons in using the commonly used methods via Singleton class against Shared (Static) members of a class in VB.Net. It could be in terms Time, Space complexity or best practices. I have a BankAccount class with methods doing some business logic.
GetBalance()
GetLast5Credits()
GetMiniStatement()
[code].....
VB Reference parent member of a class through a child when using List Of(T)?
View 1 RepliesI need to write an sql statement that has an IF condition in it
This is my current statment:
"SELECT * From History Where DelNoteNum = " & delNote & " ORDER BY StockLoc"
What I need to do though is if the StockLoc > 4000 then group by ProductCode. I definatly only need to do this if the stock location is greater than 4000 though.
I am trying to display my data in datagridview. I created a class with different property and used its list as the datasource. it worked fine. but I got confused how to do that in case we have nested class.My Classes are as follows:
class Category
property UIN as integer
property Name as string
[code].....
How do i programmatically execute a SQL statement using datasets?
View 6 Replies