What are 'unions' in C plus used for? I have some old C++ files that I'm trying to update,and not sure how I can convert these to VB:
struct txyz {
union {
struct {
float_t Time;
float_t X;
float_t Y;
[Code]...
I am trying to union to queries to create an XML file. The query itself works as T-SQL, but my implementation as LINQ-TO-XML fails with "Could not translate expression..." error.Am I asking the wrong question? Is this approach flat wrong? I am new to LINQ. How do I create a single XML from 2 queries?
[code]...
I know how to call the Union extension method, e.g.
Dim r = productFirstChars.Union(customerFirstChars)
However I do I do this with the Linq syntax, e.g.
from productFirstChars select ?
When the user has typed in some information I would like to output possible matches in a descending order, so if someone types in a full first name and a full surname, it should be listed above a result where just the surname matches.I've done something similar in SQL before which worked perfectly, but this time I'd like to do it in LINQ.
Firstname, Surname, City, Country as string variables.
Dim DataEnum As IEnumerable(Of frmTelephone.clsPerson) = alPerson.OfType(Of frmTelephone.clsPerson)()
[code].....
i have a Problem with UNION for LINQ to SQL I have my LINQ query
Dim dc As New ContainerDB.DataClassesDataContext()
Dim test = (From container In dc.GetTable(Of tbl_container)() Where container.pkContainerID = iPkContainerID).Union( _
From containerHist In dc.GetTable(Of tbl_containerHIST)() Where containerHist.pkContainerID = iPkContainerID)
[Code]...
Is it possible to create sql union like filter in dataview
View 3 RepliesI need to return the same results from linq as I get using SQL
SELECT DISTINCT Area, Region
FROM dbo.Regions
Union
SELECT null,'All'
Order by 1,2
I use this for showing an "All" selecting in a combo box
My current linq points to a view that does the union for me but I want to know how to do it right in linq. I can't figure out how to union a row for the null,'All' values.
Public Shared Function GetRegions(ByVal Area As String) As IEnumerable
Dim DB As New SiteDBDataContext
Return From values In DB.uv_Areas _
[Code].....
I've got a query which returns all invoices and credit notes for a given client, in a loyalty structure query where I need the total value of the points the client achieved through invoices, minus those that was forfeited by credit notes. Now I start my query like this (There are more unions in the query, this is just the first part)
[Code]...
I want a combined Ranges. How do I combine two ranges into one?
Dim range1 as Excel.Range = osheetTemperatureData.Range("A7:"A10")
Dim range2 as Excel.Range = osheetTemperatureData.Range("C7:"C10")
Dim range3 as Excel.Range = range1 + range2 '????
I have the below C code I want to convert to VB. How do I convert the macro and union over?
c--------------
#define bf_N16
#define S(x,i)(bf_S[i][x.w.byte##i])
[Code]....
I tried to experiment with the ability of .NET to support unions using the code below,but it causes a System. ExecutionengineException in .NET 2.0 and FatalExecutionEngineError in .NET 4.0 with the message:
The runtime has encountered a fatal error. The address of the error was at 0x738b3138, on thread 0x1080. The error code is 0xc0000005. This error may be a bug in the CLR or in the unsafe or non-verifiable portions of user code. Common sources of this bug
include user marshaling errors for COM-interop or PInvoke, which may corrupt the stack.I agree that this code should not work, but I didn't expect this kind of exception. Is this a .NET bug?
Class POLine
Public price As Decimal
Public VendorItem As String[code].....
I'm trying to create a list of all my objects from several lists of objects using Union.
Return Chart.AnnotativeNodes.Union( _
Chart.DecisionNodes.Union( _
Chart.EndNodes.Union( _
Chart.StartNodes.Union(Chart.WorkCenterNodes))))
The above line gets an error because I can't union List(of AnnotativeNode) with List(of DecisionNode). Each list defined like List(of EndNode) or List(of StartNode), but each class inherits from the base type Node.Is there a possible way to union these to get a result of IEnumerable(of Node)?
I have been given a project to do were i have to create a credit union application in VB2008, what i need to create this application etc like how many labels textboxs etc obviously i need to create it but all am asking is if you could tell me were to start as i am lost and never really created anything in vb 2008.
Here is the spec:
The client is prompted for their name and a personal reference number. If the application is successful then this number becomes the loan agreement reference number. If the applicant has a credit rating of 14 or more points the application is rejected. If the credit rating is less than 14 points then the client is prompted for the loan period (must be equal to 12, 24 or 36 months) and the amount required.
The cost of the loan is 6% if required over 12 months and 8% if over 24 months and 12% over 36 months. This is added to the loan. The applicant's net monthly income and total monthly outgoings are taken into account. If the monthly repayment is more than 25% of disposable income (net income outgoings), then the application is rejected. If the repayment is less than or equal to 25% then the loan is granted and a form is produced and printed with the relevant information, including the loan and repayment amounts.
I don't have the same problem when using an untyped dataset.
OK. I have a typed dataset MyDS with a typed datatable MyTable (TableID, Title, Message).
The table gets filled with results from two tables, using a UNION ALL
Select
TableAID,
TableATitle,
[Code]....
Is this how typed datasets handles UNION? I didn't want to create two typed datatables and create separate SQL for each and create a relation.
I have been given a project to do were i have to create a credit union application in Visual studio2008 am just wondering if you could tell me what i need to create this application like how many labels textboxs etc obviously i need to create it but all am asking is if you could tell me were to start as i am lost and never really created anything in vs 2008. here is the spec
The applicant's age is considered, thus
CODE:
The client is prompted for their name and a personal reference number. If the application is successful then this number becomes the loan agreement reference number.
If the applicant has a credit rating of 14 or more points the application is rejected.
If the credit rating is less than 14 points then the client is prompted for the loan period (must be equal to 12, 24 or 36 months) and the amount required.
The cost of the loan is 6% if required over 12 months and 8% if over 24 months and 12% over 36 months. This is added to the loan.
The applicant's net monthly income and total monthly outgoings are taken into account.
If the monthly repayment is more than 25% of disposable income (net income outgoings), then the application is rejected.
If the repayment is less than or equal to 25% then the loan is granted and a form is produced and printed with the relevant information, including the loan and repayment amounts.
HTML
Private Sub DadosN�oReconciliadosToolStripMenuItem_Click(sender As System.Object, e As System.EventArgs) Handles DadosN�oReconciliadosToolStripMenuItem.Click
[code].....
I have two tables say "Table1" and "Table2". I made a UNION query and saved it as "AllTimesFailure". It is worth mentioning, I am using Access DB. When I am trying to fetch the records from AllTimesFailure through oledbDataReader, it says "The Microsoft Jet database engine cannot find the input table or query 'AllTimesFailure'. Make sure it exists and that its name is spelled correctly.". I double checked query name and found correct but the problem still exists. when I run the same query as I pass through my command object, it works fine in Access query analyzer and fetches records normally.
[Code]...
I'm new to VB.NET. I'm trying very hard to not go screaming back to VB6...... I have a Query stored in an Access2000 database called 'build_VNMON'. (Does that make it a Stored Procedure ?) It uses multiple tables and multiple Union Statements to arrive at the desired results. It may not need to be as convoluted as it is, but I inherited it, and it works. What I really need is to output one column of the build_VNMON result to a text file, so I'm trying to use an OleDbDataReader.
[Code]...
I'm using VB .NET and I know that Union normally works ByRef but in VB, Strings are generally processed as if they were primitive datatypes.Consequently, here's the problem:
Sub Main()
Dim firstFile, secondFile As String(), resultingFile As New StringBuilder
firstFile = My.Computer.FileSystem.ReadAllText(My.Computer.FileSystem.SpecialDirectories.Desktop & "1.txt").Split(vbNewLine)
secondFile = My.Computer.FileSystem.ReadAllText(My.Computer.FileSystem.SpecialDirectories.Desktop & "2.txt").Split(vbNewLine)
[Code]...