I have this LINQ query lq_customer_product which has something like this [code]I had a combo which contains the product_name get it from lq_ customer_product, means the combo has 5 item in it.when I select an item from the combo (let say i select prod1) the following should occur:[code]
View 3 RepliesI want to declare a variable to hold the query result from LINQ to SQL like to the following:
Dim query As IQueryable(Of Student)
If isNoUserName Then
query = From st In db.Students _
Order By st.AssignedId Ascending _
[code]....
Return query
Error : conversions from 'System.Linq.IQueryable(Of )' to 'System.Linq.IQueryable(Of Student)'.
How do I declare variable "query" to hold both data from "Student" and "User" tables?
Is it wrong? Please suggest me correct way.
Public Function ReadXML() As List(Of String)
Dim list As New List(Of String)
Dim xmlDoc As XDocument = XDocument.Load("C:\MappingFile.xml")
[code].....
assign hot key for textbox?
View 13 RepliesI have an application in VB.Net that displays the results of a math operation to a listbox. For example I have the 12345 + 12345 = 24690. What I'm trying to do is to have the first 2 numbers (12345 and 12345) copied to 2 different textboxes when listbox item is selected. Here's the code I have so far:
'Make sure that we have a selected item before continuing
If listBox1.SelectedIndex = -1 Then
Return
[Code]....
During runtime it only works with index 1 when it gets selected. I have 10 records being displayed (0 to 9). None of other indexes are being shown at the textboxes.
I am experiencing aproblem in my VB.NET App. The salary form is a databound form in my app to a linq data source. There are several text boxes to enter and calculate different salary fields. e.g. Basic Salary, Budgetary Allowance and Adjusted Basic Salary...
all the above three controls are bound to the datasource. now on the Leave events of the Basic Salary and Budgetary Allowance there is a function to calculate Adjusted basic salary.
The problem is i dont see the calculated amount in the adjusted basic salary but i see only the underlying data in the database instead of the programmatically calculated amount.
I am trying to assign a dataset to the TAG property of a textbox control in my application. The code seems to do the assignment without any error but I cant see the property TAG name or the assigned value using quickwatch etc. etc. The TAG property name does show in the design window.
Is this property useable in my version (academic 2002 version 7.0) or does the TAG and any assigned value it holds not show in quickwatch. I can only find 1 reference which seems to suggest the TAG property is not supported in early versions, but would prefer a definitive answer.
How to get the textbox value on code-behind after the textbox value assigned on a modal-box? [code]Rows(i).Cells(0) is the first column on the Gridview, it is "ID". This ID will be assigned to the Textbox1 while the Linkbutton clicked.The Javascript code is on the same page as the Gridview code:[code]When I clicked the Save Button on the modal-box, the value on the Textbox1 can't catch on the code-behind. It always return null value. How to do that?
View 2 Replieshow can i assign what a label carries to a textbox. for example, if a label contains something, i want o assign the value to a textbox.
[Code]...
i want to make Software! for Notedon any Copeid txt In testbox And textbox sent Txt in My TxtFile i already figured it , how to send text in txt file
but m ask here interesting Questin: Point 1. My Application Run but not show in desktop Point 2. when i press any Special key Like F1 or F2 whatever my textbox visible true near by mouse and i past my text and press enter then my application visible false
i have record of 30 employees....and what i am doing is when the form loads i want to assign the textbox the value from the database....can i do it thru an arrary
eg i want to do something like this
For i = 0 To 29
fname[i].text = name[i]
how to i assign the name (fname[0]) in design window......is there an alternate way of doing this ?
am explaining this stupidly, but I'm still very much a VB newbie. This is a question about uni work, but it's not an assignment/test, just a little optional extension task.I have three text boxes, the first one is where the person's name is entered and the next two are where you enter the (same) person's score for two tests they have completed.
View 4 RepliesI'm trying to assign a number from a row the user selects in a DataGridView to a textbox. On the dgvProducts_CellContentClick event I wish to take whats in column(6) to a textbox.
[Code]...
i want to know how to assign specific number of digits enter in a textbox..
View 1 RepliesAdmin assigns the authority and get a new form to the new assign in with vb.net & access. I am not sure about this,I need a way to do the new form assigned? How?Actually, this project is the admin will assign the authority to a manager, and the manager will get the password to log in. Then, the manager once log in and will get a form to set the rooms who is going to use and date, etc, this is multi-manager to handle the room setting jobs.But, I think, I got stuck, I am not sure how to do the new form, HOW DO YOU ASSIGN THIS NEW FORM FOR EACH NEW MANAGER?????? THIS IS VB.NET WITH ACCESS.
View 3 RepliesIf this is a stupid question, then let me know. I can't just figure it out.First of all, this is my question. How do I detect the changed value on those text boxes?I have an idea that I create a another string values that have the original values and compare them right before saving or form closing event. This sample just have 3 text boxes, but I have 50 + text boxes on my one form. I can do it that way, but that is not really smart idea.Can I use abcDB.SubmitChanges() to detect any data changes on text boxes?
Dim sqlQuery = (From obj in abcDB.HelloWorld
Select obj.Fname, obj.Lname, obj.PhoneNumber).FirstOrDefault()
me.textboxFname.text = sqlQuery.Fname
[code].....
I have a question regarding LINQ 2 SQL and data integration with textbox:I have one textbox and button on my form, one stored procedure and LINQ 2 SQL class file in my project,I want that when I hit button, my store procedure run the SQL query and show me the result in textbox.I am using VB 2008 and Visual Basic for programing.
View 2 RepliesI'm using visual basic 2008 express edition by linq to sql for my database operation such as edit records. I did not use any sql server but I'm just using the built-in sql server within the visual basic 2008 express. I tried to revised the codes, no error in syntax but there's an error at runtime and it pops-up a window message saying its error message. What I want is to edit the records which were retrieved from the database into the text-boxes and when you click the button5 whatever the new value on the text-boxes should replace the previous one.The Account field is the field in my Table1 in memrec.dbml which I set up for primary key is true and the rest of the fields are false in its primary key.[code]...
View 3 RepliesI'm using visual basic 2008 express edition by linq to sql for my database operation such as edit records. I did not use any sql server but I'm just using the built-in sql server within the visual basic 2008 express. I tried to revised the codes, no error in syntax but there's an error at runtime and it pops-up a window message saying its error message. What I want is to edit the records which were retrieved from the database into the text-boxes and when you click the button5 whatever the new value on the text-boxes should replace the previous one.The Account field is the field in my Table1 in memrec.dbml which I set up for primary key is true and the rest of the fields are false in its primary key.The code below still found an error when you run the program and it pops-up a window which says:
NotSupportedException was unhandled - Sql server does not handle comparison of NText, Text, Xml, or Image data types.It highlights a yellow background on the line:
db.SubmitChanges()
These are what I see on each field's property on Table1 in memrec.dbml property window:
Access - Public
Type - String(System.String)
Server Data Type - Text[code]........
I have a LINQ to SQL DataContext with all my tables and all my stored procedures in it. Let me first start off by saying that we are upgrading our project from an access project to a WPF project. So in the Access project you could set a forms datasource to a stored procedure and edit and add new information. So in my WPF project on the page load I call my stored procedure to return an ISingleResult and then call a function to set the binding on every single textbox on the form. One is there an easier way to do this and two what if I want to add a new record since the textbox's are binded to an ISingleResult?
View 2 Repliesgiven this function:
Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _
[Code]....
instead of what I expected:
Select count(*) from remitline where lastname = "smith"
What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1
if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 RepliesI have a listbox on my xaml form that I bound to a List(Of MyType) property. I populated this list like so:
Dim fields As List(Of CheckableFields) = New List(Of CheckableFields)
Using context As ITIPEntities = New ITIPEntities()
Try[code]....
Now I'm at the point where the user selects the fields they want included in a report and I need to iterate over the required fields. This is my linq query:
For Each checkedField In _requiredFields
If checkedField.IsChecked Then
If checkedField.FieldData IsNot Nothing AndAlso checkedField.FieldData.Trim IsNot String.Empty Then[code].....
Example-I have a person class
Public Class Person
Private _fname As String
Public Property Fname() As String
[Code]...
Forgive my ignorance on this.I have this LINQ Query:Dim ngBikersDataContext As New CarBikeWalkDataContext
bikersList = (From c In ngBikersDataContext.Reg_Bikers _
Order By c.L_Name _
Select New Bikers() With { _
.BikerID = c.BikerID, _
.F_Name = c.F_Name, _
[Code]...
with the error "Overload resolution failed because no accesible 'Select' accepts this number of arguments."
Over the "NEW" I get an error " ')'expected."
We are doing a query against an in-memory collection of LINQ data objects. The wrinkle is that we are ordering by a column in a related table whose records have not necessarily been loaded yet (deferred loading:)
Dim oPkgProducts = _
From b In oBillPkg.BillProducts _
Where b.Successful.GetValueOrDefault(Common.X_INDETERMINATE) = _
[code]....
The pattern I'm trying to avoid is checking if a string (normally a control's text value) is null/empty, and if it is, comparing it using Contains to a field in my data. Obviously the field isn't hard-coded into my extension, neither is the object type.What I've got works perfectly in Linq to Objects, but I get the generic run-time error "LINQ to Entities does not recognize the method 'System.String Invoke(GenericQueryHelper.Customer)' method, and this method cannot be translated into a store expression." when using an entity framework model.
Here's what I have:
<System.Runtime.CompilerServices.Extension()>
Public Function CompareAndFilter(Of T)(source As System.Linq.IQueryable(Of T), expressionField As System.Linq.Expressions.Expression(Of System.Func(Of T, String)), compareTo As String)
[code]....
I want my usage to look something like this:
Dim results = repository.Customers.CompareAndFilter(Function(c) c.FirstName, searchText)
I do need to get this running against a SQL database really, as it is filtering results, so I don't want to be doing that in memory.
How can I convert this code LINQ to SQL in C # LINQ to SQL in Vb.net
[Code]...
How do I add ROW_NUMBER to a LINQ query or Entity? How can I convert this solution to VB.NET?
[Code]...
I'm having trouble porting that last line. I have been unable to locate a VB.NET example. I'm actually not looking for any paging functionality like the example provides, just good old-fashioned Row_Number(Order By X) row index.
How can I convert an object of type System.Data.Linq.DataQuery to System.Linq.IQueryable?I'm working with Visual Basic/Silverlight, and the source code of my query is as follows:
Public Function Get_Cli_Pag() As IQueryable(Of V_Cliente_Pagare)
Dim Qry = From P In Me.Context.Pagares Join C In Me.Context.Codigos On C.Codigo
[code]....