I need to query XSD to fetch the name and type from the schemea containing <XS: Element name "Test" type = "test12">. I need to use LINQ.
View 1 RepliesI've pieced together some information from other posts but I'm stuck. The first part works fine. Basically I query the database using LINQ and then I loop through the results generating a report.
[Code]...
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 have a problem on dealing 2 same element with 2 diff attribute value.
Ex. <phone type:"home"> 123-456-7 </phone>
<phone type:"work">0934-4567-99 </phone>
How can I get the phone number for home using the Xelement.value using linq ?
Why I am getting this error frmProduct' is a type in 'Test' and cannot be used as an expression.
Below is the code.
[Code]...
I'm writing a program in which I want to list the values of some of the properties on every control on every form in the application. I can do this for simple controls like Buttons and Labels, but am having a problem when it comes to a complex control like a ListBox. I know how to extract the data when I laboriously code each ListBox individually. The problem is how to do it when it's a generic object buried inside two loops
View 7 RepliesI am using linq to fill a gridview with the information from an xml from code behind. I would like to order my Grid according to one of my elements in the xml ("value element").
gvResourceEditor.DataSource = (From resElem In resourceElements.Elements("data") _
Select New With { _
.Key = resElem.Attribute("name").Value, _
.Value = HttpUtility.HtmlEncode(resElem.Element("value").Value), _
.Comment = If(resElem.Element("comment") IsNot Nothing, HttpUtility.HtmlEncode(resElem.Element("comment").Value), String.Empty) _
}).OrderBy(?????)
I have two separate web services, the first configured to extract data from a live database, the second from a test database.
When consuming these web services from an application the object returned is a MyMessageData class which is defined in the web service.
In the application I would like to instantiate a empty the MyMessageData (from the live web service) and then use a configuration setting to decide which web service to retrieve the actually data from.
This does not work for test because the application does not see the instantiated MyMessageData class from live as the same type as the MyMessageData that is returned from the test webservice. [code]....
I need to test a string of text that needs to contain a certain type of char values. The known is allowing of a-z,A-Z,0-9. But the variable (which will be coming from a database field) will be the allowed symbols. The allowed symbols will look something like:!@#$%^&*()
So using regex, how can I check a string of text to make sure it ONLY contains a-z,A-Z,0-9 AND the allowed symbols as shown above? Remember, the allowed symbols is dynamic at run time so I need to somehow be able to plug that in to the method at run time.
The following examples would be valid using the above symbol string:
Test1234%
Test1234
The following example would NOT be valid:Test1234%_
I need to be able to tell if a property is of type List(of T)but am currently unable to. if i do
TypeOf (UpdateTo.GetType.GetProperty(node.Name)) Is System.Collections.Generic.List(Of Object)
I get the following error
TypeOf (UpdateTo.GetType.GetProperty(node.Name)) Is
System.Collections.Generic.List(Of Object) Expression of type
'System.Reflection.PropertyInfo' can never be of type[code]......
I have been trying to assign value to an object array that is defined as follows.Dim englishTextAry As Object(,) = New Object(,) {}I am looping through a dataReader and trying to assign the values to this array with the following code.[code]But the ReDim is throwing an error on dataVal not being an Integer.What am I doing wrong here? Can anyone point me in the right direction?
View 2 RepliesI have a form that displays data. What I would like to have is a button that when pressed will display some test extran textboxes in a dimmed/transparent type of fashion. I can get that using another form, but would like to do it without the second form.
View 1 RepliesI am developing an application with an Access DB, and i'm having trouble retrieving data from the db, i want to count how many operations have been made through two dates that i'm passing from a datetimepicker, and i can't manage to do it, since i keep getting an error saying "Data type mismatch in criteria expression". In the db, i have that date field type as a date. Before, i had it as a text, but it wouldn't work if i selected one date of x month and the other date from a different month. So, my question is, how do i indicate the type of data in the sql query? [code]
View 3 Repliesi'm new here but i've been having a problem lately with a sql query inside the code i'm writing, and i don't know what else to do. I've been trying to retrieve data from a table, and i want to use a variable for the "where" field in the SQL query, but it keeps saying that the data are not the same type. [code] The point is, i need it to be an integer because the primary key is the same, but i can't figure out how to specify it. I hope i posted this on the aproppiate place, and if not, i apologize, but i didn't have much time to go through it.
View 7 RepliesI've come from a Assembler and C/C++ background, so I understand the concept behind reference types versus value types in vb.net. Also, I've read Jon Skeet's article regarding references and value types and I understand all of that. My question is: How can you tell if a given type is a reference type or a value type? Is it simply that all integral types (ints, floats, etc.) are value types and all classes are reference types? (If so, where do strings fall?)
[Code]...
I'm out of my depth populating a windows form from an XML linq query (see code further down in post). The listbox is populated as intended, when a value is selected (row) I would like to populate the remaining form controls. The linq query I believe has created a new datatype "Anonymous Types". The query is only local to the load form subroutine but I'm not sure how to make it global.
When I define the query simply as an object the code in the selectedValueChanged event can't execute due to late databinding. how I can initially load the listbox from linq xml query and then populate the other controls when the value changes? Am I right in thinking even though the listbox is multi-columns (property) you can ONLY ever reference a row and NOT a column? I'm new to LINQ and Anonymous Types and the more I read the more confused I seem to get. On a less important note the order by is not functioning as intended (no errors) but data is always retrieved in xml file order and not by the node <text>. Also looked at using <text>.first to order the results without success.
[Code]...
Can some please tell me how to filter integer type value for Visual basic using query. for example: [code]
View 6 RepliesIf you have custom type, and you wish to assign a List(of T) to that custom type[code]...
View 1 RepliesI have a method, that returns a group of accounts
Public Shared Function GetAllNotesByUser(ByVal UserID As Guid) As Account (??)
Using db As New MyEntity
Dim query= (From A In db.Account _
[Code].....
I would then like to pass this to another function to calculate the totals for all the accounts in the collection. Is it best practice to return an Ienumerable, a generic list, I'm just not sure what works best with LINQ and the entity framework.
I've got a problem in one of my SQL queries, the type GUID can't be used with the operator & (obviously from the title). Here's the few lines of code which I'm using:
Dim ClientsAssetID As Guid = New Guid(ClientsAssetIDTextBox.Text)
Dim Client1 As Guid = New Guid(Client1TextBox.Text)
Dim Client2 As Guid = New Guid(Client2TextBox.Text)
[code]....
ClientsAsset, Client1, Client2 and Client3 are all of type GUID, but are entered into the textboxes as strings, are converted to guid and then should all go smoothly into the query, but it's having a problem with linking everything together. The error I'm
getting is "Operator '&' is not defined for types 'String' and 'System.Guid'.How do I fix this? I've tried a few different things, such as using Ctype in the query, but they have also circled back to this error.
I have the following query
Dim get_rmf_2 = From rmf In t_rmf _
Where rmf!NIVP = nivp_rap
When i run it i get an error :
Operator '=' is not defined for type 'DBNull' and string "test".
I suspect this is because the column "NIVP" in the datatable contains null values, I've tried yhe same thing without null values and it works.So how can i make this work ? ; the column "NIVP" really has a row "test" , and a normal SQL query works fine.
I've got an XML file with the following sample structure:How can I get the value of the element <Reference> where the <Organisation Type="Seller"> and the attributes are AssignedBy="B" and Type="T1"
[code]...
Or change 'Select a' to 'Select a.value', but is not giving me the result
I am trying to write a LINQ equivalent of
SELECT C1, C2, C3
FROM T1
WHERE T1.C4='xyz' AND
EXISTS (SELECT 1 FROM T2
WHERE T1.C17 = T2.C24)
ORDER BY C3
I'm using EF CTP 5, so I have a DBContext variable named dbc, which includes DBSet objects T1s and T2s, based on POCOs T1 and T2.
In LINQ I write
DIM IND = From i In dbc.T1s
Where i.C4 = "xyz"
And (From t In dbc.T2s Where i.C17 = t.C24).Any
Select i.C1, i.C2, i.C3
Order By C3
Running the query I get the error message "Unable to create a constant value of type 'T2'. Only primitive types ('such as Int32, String, and Guid') are supported in this context." When I omit the inner expression (third line in the LINQ code), the query runs fine. I tried switching the orders of the inner comparison, to be t.C24 = i.C17, with no effect.
I am using VB .Net for this, so I don't have access to var or this would be a simple matter.Right now my query is as follows
[code]...
So I used this query in LinqPad to help me determine what the object would look like. I got back a IOrderQueryable(Of RSError) which then contained a IGrouping(Of String, RSError) for each grouped collection of objects returned by the query.However I ended up with the current object type of errors as IOrderedQueryable(Of IGrouping(Of String, RSError)) because of the cast error I am getting in VS.
[code]...
I'm not sure how to get rid of the VB$AnonymousType_1 Part of the returned object.Am I even on the right track here or am I missing something completely?
Why is this query not working
Private mapOverlays As New List(Of GMapOverlay)
Dim mapOverlay = mapOverlays.Where(Function(x) x.Id = overlay.Name).Distinct()
DirectCast(mapOverlay,GMapOverlay).IsVisibile = False
I am getting the error
Unable to cast object of type
'd__7a`1[GMap.NET.WindowsForms.GMapOverlay]' to type
'GMap.NET.WindowsForms.GMapOverlay'.
I try to show my table data type in datagridview vb.net.[code]I try login using username "system". When I run this code, I got error message "ORA-00900: invalid SQL statement".
View 2 RepliesI try to show my table data type in datagridview vb.net. Here is the sample code :
oradb = "Data Source=(DESCRIPTION=" _
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" & txtServer1.Text & ")(PORT=" & port1.Value & ")))" _
[code]....
when view in browser, i got this error: Unable to cast object of type 'ASP.webform1_aspx' to type 'System.Web.UI.WebControls.Button'.
how should i solve this problem?
Line 7: If Not Page.IsPostBack Then
Line 8: Dim rowIndex As Integer = 0
<b>Line 9: Dim btn As Button = DirectCast(sender, Button)</b>
[Code].....
I'm trying to add a new record to my database but i keep getting the message - "conversion from type DBnull to type string is not valid". I think its something to do with the Employee ID when VB attempts to save it to the database my code is below
Imports System.Data.OleDb
Public Class Add
Private Sub DisplayRow()
[Code]....
I now have SQL Parameters set up and I'm using them to save/delete/add my data. This all works well, except when it's trying to save a combobox to the datatable it appears with the error above.Majority of my comboboxes have datasources, and the valuemembers of these are the actual list items, not the ID's of the list items.I'm not sure why this error could be happening, I'm fairly sure I've connected everything to the binding source correctly; I've checked it a few times.Does anybody know what the cause of this could be? I've looked around a bit and I haven't found much
View 7 Replies