I would like to know if there is any simple/fast way to create a complex XML file, when I say complex, I mean more than 20 elements encapsulated. Although this is VB.net,unfortunately literals will not work in this case
View 2 RepliesI have an XML File that I am processing using LINQ. I want to basically serialize the XML data into custom objects but don't know how.
[Code]...
How can I finish the above LINQ query to populate the Children property of the Group object?
I have a collection as follows
Private _bankRates As Dictionary(Of RateSourceBank.Key, RateSourceBank)
Where RateSourceBank.Key is simply
Public Class Key
Public RateType As String
Public EffectiveDate As DateTime
[Code].....
I'm using Linq to Sql and have a stored proc that won't generate a class. The stored proc draws data from multiple tables into a flat file resultset. The amount of data returned must be as small as possible, the number of round trips to the Sql Server need to be limited, and the amount of server-side processing must be limited as this is for an ASP.NET MVC project. So, I'm trying to write a Linq to Sql Query however am struggling to both replicate and limit the data returned. Here's the stored proc that I'm trying to convert:
[Code]....
This question is very similar to a previous question of mine, Use LINQ to count the number of combinations existing in two lists, except with some further twists.
I have a list of CartItems that can receive a discount based on the items specified in the list of DiscountItems. I need to be able to pull out the items in the Cart that can receive a discount and apply the appropriate discount specfied in the DiscountItem. The discount is only applied for each combination that exists. Here's what the two lists might look like to before the discount is applied[code]...
I have to join two main tables, and I need to filter the results by elements in an ASP.NET web form. These filters are created on the fly so I have to use a lot of where extensions to filter the query. I want to execute the query with as optimized SQL as possible.
I am first doing a simple join between TW_Sites and TW_Investigators. Then there are two sub-tables that are involved. TW_InvestigatorToArea and TW_InvestigatorToDisease. While most of the where clauses are working fine, I have found a performance issue that won't be an issue right now, but will be an issue as the table gets bigger.
The arrays DiseaseCategories and DiseaseAreas would be the results of a CheckBoxList result.
Protected Sub LoadResults()
'Get Dictionary of Filters
Dim FilterDictionary As OrderedDictionary = Session.Item("InvestigatorFilterDictionary")
' Initialize LinqToSql
[code]....
I have a datatable with the following fields:
SampleID varchar(50)
PreWeight varchar(50)
Validated char(1)
[code].....
I have Country=>Ligue=>Team(Name, Score)I need to select all team Name-Scores from a country.
something like this, does not work )
query = from ligue in myCountry.Ligues, from team in ligue.Teams
select name = team.Name, score = team.Score distinct
[code]....
I'm trying to update an access .mdb file. The file contains one table with 115 fields. I have estabished a connection to the database. I'm able to select the datarow I want to update. I can see it when I debug the code. I change two fields in the datarow by using thier index.
[Code]...
i try to convert this kind of sql query into linq in visual basic, but i get stuck on how to make a percent.. I also don't know how to use linqpad for creating this linq
SELECT CASE RIGHT(PICName, 3)
WHEN '(P)' THEN 'Problem'
WHEN '(R)' THEN 'Request'
[Code].....
I want to create a treeview from a database in my project. I have been using linq to retrieve data. I have TeamLeaders, Marketers and Clients. When i expand the TeamLeaders node i want to see the Marketers under that node and when I click on the Marketer. I want the list of clients under that Marketer to be displayed on the right panel that has a gridview. TeanLeaders and Marketers are from one table and Clients in a different table.
View 2 RepliesI have got the list of Class Name as Follows: Type[] typelist = typeof(Sample.Students).Assembly.GetTypes();
Now i have complete list of all classes available in Sample NameSpace:
Now i want to get data through class I am using Devexpress Persistance class so basically i have to create XPQuert Object as follows: XPQuery<Employee> EmployeeQuery = new XPQuery<Employees>(XPODefault.Session);
But in my case Employee class will be listed in typelist variable..How can i create the object of XPQuery.. is it possible something like this: XPQuery<typeof(typelist[0].Name)> EMployeeQuery = new XPQuery<typeof(typelist.Name)> (XPODefault.Session);
I meant i want to create object dynamically.
I`m looking for a way to parse a parameter name like linq does.I want to filter before i download the date from the database.With LINQ the data is already red into a dataset. I only want to select data from the database witch i need. how i can send a property name to a function without using the property name as string and without to use to mutch code inside the function and without creating an instance of the object, etc.
Module
Module1
Dim user
As user =
[code]....
In my programming task I've gone down a dark alley and wished I hadn't, but there is no turning back now.
I'm building up a SQL statement where the table name, column name and id value are retrieved from query string parameters i.e. ("SELECT [{0}] FROM [{1}] WHERE [Id] = {2};", c, t, id)
But it isn't as bad as it looks, I'm protected: Only authenticated users (i.e. signed in users) can execute the Page_Load I'm checking that both the table and the column exists beforehand (using GetSchema etc.)I'm checking that the Id is an integer beforehand All my tables have Id columns The database connection is reasonably secure
[Code]...
I figure I should use 'Aggregate' but apparently I am getting it wrong First I get a list of my Entity objects Dim employers As List(Of myEntity) = (New XXXX()).getZZZ(userName, userType) Then I figured this would be a way to put all the names in a string Dim names as String = employers.Aggregate(Function(current, [next]) current.Name & " " & [next].Name)
[Code]....
I'm getting an intellisenxe error saying that the statement below is expecting a ')' and is positioning the correction ater the parenthesis following "Approved". I'm not familiar with this IF syntax and I can't seem to make the correction; trial and error isn't working ;o)) If (reader.Item("Approved"), True, False) = 0), (reader.Item("DoNotDisplay"), False, False) = 0)) Then
View 2 RepliesI recently downloaded VB2008 express. Iam trying to create a link to an SQL table, but the LINQ to SQL class is missing in my add new item menu. is there another way to grab data from a database without using the LINQ to SQL?
View 1 RepliesI am trying to create a LINQ query statement that retrieve intersecting data from 3 datatables (dt, dt1, dt2). My first attempt to do so with the following LINQ query statement was successful: [code] However in my design, I would need the LINQ query statement to be dynamically generated, because I want a user to be able to retrieve intersecting data entries from VARIABLE number of datatables. In this case, the first option is not as good as the "INTERSECT" query operator, with which I can just easily connect each SQL query statement with a "INTERSECT" operator. The problem is that my second attempt using the "intersect" operator fails, and after many trials and errors I still can't get it to work. [code]
View 5 RepliesThe problem is: I have a list of objects, with some containing the same PlanId property value. I want to only grab the first occurrence of those and ignore the next object with that PlanId. The root problem is a View in the database, but it's tied in everywhere and I don't know if changing it will break a ton of stuff nearing a deadline.
So, if I have a list of PlanObjects like such.
Plan1.PlanId = 1
Plan2.PlanId = 1
Plan3.PlanId = 2
Plan4.PlanId = 3
Plan5.PlanId = 4
Plan6.PlanId = 4
I want to take a sub-list from that with LINQ (italics mean an item is not included)
Plan1.PlanId = 1
Plan2.PlanId = 1
Plan3.PlanId = 2
Plan4.PlanId = 3
Plan5.PlanId = 4
Plan6.PlanId = 4
For my needs, it doesn't matter which one is taken first. The Id is used to update a datsbase record.
Basically i have a list(of TransRecord)
vb Public Class TransRecord
Public TableName As String
Public PKs As String
[CODE]...
And want to create a linq filter to select only unique records for TableName + PKs (group by) ... but want it to select only the record with the highest ID for this group by.
I am having a problem setting up my combo box to pull its menu from a SQL Server table and store to the main data table.Currently my drop down list displays correctly but saves 'System.Data.DataRowView' to the data table. My main data table is called 'Survey' with staffname as a column, then I have another menu table of staff member names which populates the drop down menu.I found that when I remove the DataSource and populate the Items collection instead the combo box saves the correct value as expected but when I use the datasource it saves the words ''System.Data.DataRowView',[code]
View 2 RepliesI have combox1 and i want to dispaly Foure Columns in combox1 and I make this
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.Text, "select FirstName,FatherName,GrandFatherName,FamilyName from dbo.PersonalData")
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "GetSpecialFieldOFPersonalData")
Do While dr.Read
Me.ComboBox1.Items.Add(dr(0) & " - " & dr(1) & " - " & dr(2) & " - " & dr(3))
Loop
How do I use complex numbers in Visual Studio 2008 and in Visual Basic, dont tell me I spent all this money on VS2008 Pro only to find out that it cant handle complex number arithmetic!
View 1 RepliesIn my spare time i give myself programming stuff to do. Today i want to write a function that goes through a string, if the string contains any numeric value the function must return false, if the string has any special characters it must also return false else return true. For example the following strings would return as follows:
String Return Value
Travis True
78* False
[code].....
I am currently working on a project, which purpose is to call a webservice through a VB script. VB is by far not my first language and I simply reach the point where I do not know how to go on from here.
I have a Webservice descriped in a WSDL document that defines a service that takes a complex type as parameter and returns such one as answer.
The complex type is basically just a string that is wrapped inside a class object. So what i did was to create a new class module and added a public variable to it. I created a new instance of this class, gave it for the purpose of testing a value and tried to call the webservice. Everything goes well untill i reach the call to the webservice, where the program throws an exception that says:
"Class does not support automation or does not support expected interface"
My first thought was that the initialization of the object might have gone wrong but i am quite able to set and get the values on it. So i have to assume that the object is okay. I know that the url to the WSDL document is correct, due to the fact that I can call the document via the browser and it will throw an exception of "wrong type" when i feed the soap method with a primitive.
With out luck I browsed several pages on the net to find a clue what this could. So now i wanted to give this forum a shot.
You should know that i am not able to alter the WSDL file. I have to go with the way it is. In addition am supposed to stick to VB 6.0.
I used a Form in VB to make the call to the webservice.
Here is the call procedure:
Private Sub Command1_Click()
On Error GoTo ErrorHandler
Dim tS
[Code]....
I have a custom modelbinder built to handle my accountRequest class.This class consists of some boolean values and a UserViewModel.The UserView Model is made up of strings such as Firstname, Last Name, Address.Originally I was just passing the UserViewModel as the action parameter but I now I need to package UserViewModel inside of accountRequest.however, now my modelbinder will not map the strings in the httpContext.Request to my UserViewModel inside of AccountRequest. All of the booleans map just fine.Is there an easy way to get his data to map to the UserViewModel properties other than hardcoding it? [code]
View 1 RepliesI'm trying to save some settings in a complex object. If I make a dll of the class I can then add it in the projects properties settings list as that type.When the program runs though it won't show up as anything other than nothing. I read you have to have a sub new empty constructor which I have but don't know why else this would fail.First question is how to you do this. Second is there anyway to use a class inside the project as the target of the settings type or do you have to bring a in an external dll to do this every time? [code]
View 4 RepliesI suppose this is more of an opinion question, but, when you start a big project, what do you think about before you even start Visual Studio? Do you setup structure and files before actually coding them, or do you code them one-by-one?
View 2 RepliesI have a product table which has around 90 columns in. Must of the columns are integers. When I search for an existing product and insert it into a row its fine but when I alter one of the columns and do an update using the command builder I get 'Expression Too Complex'. Does anyone know why this is happening and how to fix it?
View 4 RepliesIm making a herbal database program and I am having troubles setting up HierarchicalDataTemplates for my main data class.
[Code]...