I have following query,
[Code]....
how to do it in linq queries ??? also is it possible to combine firstName and lastname in select query in Linq ? just like we do in SQL Queries like : select me_first_name + ' ' + me_last_name as 'Full Name' from me_employee how can i achieve this task in linq?
I have a program and I get time data from a sqldb and display it in a column in a listbox. What are the proper steps for adding the time as I iterate through the data in the column? I figure I will need to do some conversions on the time to be able to add it and display it as a total.
View 9 Replieshow to sum upan specific columns in gridview using linq? I can't find anything in Google regarding this topic.
I tried this but not exactly what I want to be the output.
Dim total = Aggregate rowItems In Gridview1.Rows _
Into Sum(Cdbl(rowItems("AMOUNT")))
I have a situation where I have a hierarchy. I'm trying to use LINQ to get all of the items throughout the hierarchy as opposed to For Each loops. I spent some time looking for examples, but most where C# using lambdas, and I'm not quite sure I understand it. I'd like to try to get all of the Items for a specific system, the levels of items could be n-levels deep.
Code:
System
SubSystem1
Item1
Item99
Item100
Item2
Item121
Item3
SubSystem2
Itemx
Itemy
Itemz
I am using the following line of LINQ to drill down into an element. Is it possible to expands this code to drill further down so that I can add content to the <population> element in "Test2". I want to be able to do somthing like element.SetValue(1000000). However I need to expand the code below so that I can pass the entire query results into the variable called "element"'
Dim eles = From c In doc.Descendants("File") _
Where c.Attribute("Name").Value = "Test2" _
Select c
[code]....
I have a page with a form on it and needs a range of dates. Thus I've placed a number of textboxes on the page into which users can type dates. When the user clicks the save button I want to trigger a LINQ update to the SQL Server...all the rows already exist, so I'm just updating existing data.
For example, lets say my table looks like this:
Column Names: Description dateValue
Column Values:
Birthdate 1/1/1990
Anniversary 1/10/1992
Death 1/1/1993
I want to do something like this:
hupdate.Description("Birthdate").dateValue = TextBox1.Text
hupdate.Description("Anniversary").dateValue = TextBox2.Text
hupdate.Description("Death").dateValue = TextBox3.Text
hconfig.SubmitChanges()
Is there a way to do this with LINQ?
Is there a way to alter a specific row to a column?
Like i want to alter a row but not the whole thing only one column?
deducting from customers purchases. The fields look like this:
tblStocks:
Name Type Qty
Pencil 2 15
[code].....
I just looking how to use LINQ for grouping a list.
Class Item
Public col1 As String
Public col2 As String
Public col3 As String
Public description As String
[Code]...
Dim query=Form f in BBSDb.Forms order by f.FormID Descending Select f where I want the f.FormID to be able to replace with a variable..What I mean is.. it doesn't have to f.FormID .. I may want to set f.FormName to be in descending for example using the code dynamically.. Is there anyway to achive?
View 2 Replieshere's the scenario. There's 2 types of employees; Worker and Manager. The worker will have to access the page 'worker.aspx' and the Manager will have to access the page 'manager.aspx'. In my login database (Access 2007) I have the first name, last name, username, password and job title of both workers and managers. Ex:
[Code]...
I'm working with a database application and i want to check if there is a null value in a specific column but it works only when its not null but if its null it throws an exception automatically. I tried to change the null value property of this column but I'm not able it shows a message that its not a valid property. I tried to change the source code in the code editor but it changes back automatically. Is there a way that I can work around this?
View 5 RepliesIv've always done a loop like below to go through each row of my DataGridView..For Each row As DataGridViewRow In DataGridView1.Rows....Is there a way to specif a specific row and column that i want to get data from? I tried this below but didnt work
MessageBox.Show(dataGridView1.Rows[1].Cells[0].value)
and
MessageBox.Show(dataGridView1[0, 1].Value)
I have a DataGridView binded to a DataSet that I created using the Visual Studio Data Source Configuration Wizard. Everything works good except for one problem.I have two columns, Modified_By and Date_Modified that should be inserted or updated as the user and the current date, respectively. So every row in the DataGridView should have the same value for these two columns.So far, I have thought of two ways to get this working, but neither one seems very clean. The first idea is to make a custom Fill method that takes as parameters the user and the current date and then add them as extra columns in the select method. For example
View 1 Replieslet's say the datagridview have 3 column
|--------------------------------
| id | name | age |
-----------------------------------
| 1 | john | 20 |
------------------------------------
i want to get "id" only from every row i tried this code,but it wont work
For cn As Integer = 0 To DataGridView1.RowCount - 1
DataGridView1.Rows(cn).Cells(0).Value)
Next
I have a Xtragrid where when I double click the row I need to be able to pass the value of one of the columns to a stored procedure. There's got to be an easy way to do this but I haven't been able to find it.
View 9 RepliesHow can I add all the items of a specific column of a listview. For example I had a listview of a class like:
name............... surname............... age
------------------------------------------------
asdsa..............asdasdasd................21
sadsad..............asdasdasd...............23
sadsad...............adasdasd...............24
I just want to add all the numbers of age column so I can find the total sum of ages of the students. I want, when I clicked my button It makes my textbox's text = 68 for this example.
lets say i have a datagridview with 4 column "a,b,c,d"now i only want insert entire column "b and c" into sql database, is this possible to do it?
View 2 Repliescan i ask how do i insert my records from my textbox to specific column name of my table
IsConnected("Insert into products values(" & _
Me.TextBox1.Text & ",'" & _
Me.TextBox3.Text & "','" & _
[code].....
I have the following piece of VBA code that I need to convert to VB.NET for use with a ListView control (the original VBA control was a ListBox):
For i = 0 To lstProperties.ListCount - 1
If lstProperties.Column(18, i) = "" Or IsNull(lstProperties.Column(18, i)) Then
GoTo OpenFrm
[Code].....
Let's say I want to search only in the 3rd or 8th column of the listview. How do I do that?
View 4 Replieslooking like this:
ID | Value
1 | 6
2 | 5
[code].....
Which syntax is to be used in order to retrieve that IconCriteria(2) applies to cell C5.[code..]
View 2 RepliesI have a Dynamic DataTable Created at runtime. The Setup is like so
Id | Name | Age
-----------------
3 | Mike | 21
6 | John | 43
8 | Sara | 34
What I am trying to do is come up with a linq statement I could use to find and update specific rows.
Such as a statement to change AGE to '33' WHERE ID = '3'
My code So far is:
-[VB.NET]-
Dim MyRow As DataRow = From column In MyTable.Rows Where column("Id") = 3
MyRow(0)("Age") = 33
But this is not updating my DataTable entry.
I dont know how to access the value from a Subtable "Produkt"
I have a datagridview wich uses the Datasource from the LINQ result from the picture.
The columns from Maintable are displayed correctly. But for the Subtable "Produkt" i cant reach the Name Column value. if i Use "Produkt" in the DataPropertyName the Result is: {ContainerDB.tbl_Produkt} with Produkt.Name nothing is displayed.
Same thing I am trying to do in the linq order by. It's not working.I have column that is defined in the data base as string (Varchar) and I need to cast/convert it to integer before I need to sort it.What should be my linq statement?
View 1 RepliesGiving it a go at LINQ to SQL.
Tools: VB2008 Express to SQL Compact Northwind DB
I am doing the following walkthrough: [URL]. I did the walkthrough step by step although I get the following message ...... The column name is not valid. [ Node name (if any) = t0,Column name = CustomerID ] ....... on the first line of the following code.
' Execute the query.
For Each custObj In custQuery
msg &= String.Format(custObj.CustomerID & vbCrLf)
Next
I have enabled all that the walkthrough indicates but to no avail.
Dim MyQuery = From c In xdoc.Descendants() _
Where c.Attribute(OriginY) IsNot Nothing _
Order By Val(c.Attribute(OriginY).Value), Val(c.Attribute(OriginX).Value) _
Select c.Attribute(UniStr)
Right above you can see my First! linq attempt! And here comes my first question.
How can i select more than one column in a linq query in vb.net?
For example... Select c.Attribute(UniStr) AND c.Attribute(OriginY)
I use this command to retrieve information from an Access database:
Try
Dim result = From row In Me.ChitaDataSet1.chita.AsEnumerable() _
Where row.Field(Of String)("askID") = x _
Select row[code]....
how to Update a cell in specified row-coloumn coordinates?
I have a datatable contain fId field. I want to update all values for this field to "1" without using loop. [Code]
View 1 Replies