Xml - Mix Values From Local Data With Values Returned From Database While Using LINQ To SQL?
Oct 27, 2010
I am creating an xml file with LINQ as follows...
Public Sub CreateXml()
Dim db As New MDataContext
Dim Customers = <gallery columns="3" rows="3">
[code]....
Could i mix local values with the ones returned from the LINQ query...Something like the following?
Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String)
Dim db As New MDataContext
Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">
[code]...
View 1 Replies
ADVERTISEMENT
Dec 15, 2010
I am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
View 2 Replies
Oct 24, 2011
I am using a where comparer in the below snippet from my function.. I need to order or sort the returned items by one of the columns... I tried using .OrderBy(function(f) f.regDate) but that dont work at all... The part of the function in question looks like this:
[Code]...
View 1 Replies
Aug 3, 2011
I've got the hang of using dates now, but I haven't learned how to test multiple results of a query. I can return a value from a query, but I'm unsure how to return many without putting them into a data grid view or an object on the form. (In Visual Basic)I have to check when a particular investment needs to be bought or sold, there will be more than one in almost every case. I've got the function to find out the interval between the months, checking if the asset is bought or sold in month x, but I'm unsure how to test it against multiple assets at once - nor do I know the best way to do so.
View 12 Replies
Jan 1, 2010
When i parse some html and get the fields i need using regex, the first 4 fields returned are fields i don't need, so essentially i need all fields returned after the 4th one.
vb.net '// First piece of data we want...
Dim stringID As New Regex("(?<=><optionvalue="").*?(?="">)", _
RegexOptions.IgnoreCase Or RegexOptions.Singleline)
Dim stringsMatched As MatchCollection = stringID.Matches(stringClean)
[CODE]...
Is there a way i can blank out the first 4 fields returned?
View 2 Replies
Jan 14, 2010
I'm attempting to use business objects as a datasource for an ASP.NET Microsoft rdlc Report and I am having problems displaying the values of subobjects in the report.
For example, if have the following two classes 'Customer' and 'Address'.
Customer
FirstName
LastName
[Code]....
View 2 Replies
Jun 6, 2011
Suppose der is one database name Customer which have columns like Cust_ID,Cust_Name,Cust_Mob,Cust_Address And on Form der are one list box which contains all Cust_Id from database and 4 textbox so when user click on the listbox having id as 1 it should display name, mob and address of cust_id 1 in 4 textbox respectively?
View 18 Replies
Jun 8, 2012
im a newbie in vb.net and i am using vb.net 2008 express edition,,i am creating a project which is importing csv data in my database,
View 5 Replies
Apr 5, 2011
Currently I have a problem with updating my database with values in my Data Grid View.
On my form I have a "Populate" button and "Submit Details" button.
The "Populate" button fills my Data Grid with numerous lines of data.
On the click event for "Submit Details" I want this data to be inserted into a table in my DataBase by looping through each record.
For Each dgi As DataGridView In DataGridView1.Rows
Dim productCode As String = DirectCast(dgi.FindControl("product"), Label).Text
Dim description As String = DirectCast(dgi.FindControl("description"), Label).Text
Dim quantity As String = DirectCast(dgi.FindControl("order_qty"), Label).Text
[cODE].....
View 7 Replies
Sep 30, 2010
I'm populating a custom dropdown list control on the fly that's tied to data grid using VB .NET 2008. The form will display all the manufactures when the edit button on the data grid is selected.
The dropdown I created works fine. However, when I try to populate the drop down with the respected manufacture values from the database, I only get a value of "System.Data.DataRowView" that being populated in the dropdown list as opposed to my values from the database.
Here's the basic code I use to first create and populate the drop down control:
<asp:DropDownList ID="Manufacturedd" Runat="server" DataSource='<%# m_ItrackerData.Tables("Misc_Manufacture") %>' SelectedIndex='<%# getSelectedManufacture(DataBinder.Eval(Container, "DataItem.Manufacture"))
%>'></asp:DropDownList>
[Code]....
View 1 Replies
Apr 20, 2010
I as part of the support VB code for a larger ASP project, I need to read back the existing data from an Access database, to see if user has changed a value.
I'm reading the existing data back into a DataView using the following function:
Public Shared Function GetPolicyStatus(ByVal intPolicyID As Integer) As DataView
Dim strConString As String
Dim conMyData As OleDbConnection
[Code]....
View 4 Replies
Jun 21, 2012
I have three client PCs and one local server (actually a pc- Using windows 7 Ultimate on it).
In the server pc I have XAMPP installed and I am running an application developed using PHP on it. There I have the following PHP variables[code]...
View 1 Replies
Jan 31, 2012
I have a list of parameters going from -20,00 to 20,00 by step 0,25.Sometimes I need the whole list but in some cases I only need the parameters by step 0.50
ex : in the values 1.00 ; 1.25; 1.50 ; 1.75 ; 2.00 ; 2.25; 2.50 ; 2.75 ; 3.00 i only need 1.00 ; 1.50 ; 2.00 ; 2.50 ; 3.00[code]...
View 3 Replies
Jan 5, 2012
I am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
View 1 Replies
Oct 20, 2011
m_ListOfsAllFields.OrderBy(Function(x) x.DisplayOrder)
here I have DisplayOrder = 0 for 2 fields, so orderby is messing up and not ordering properly. How can I use orderby to order this collection?
View 2 Replies
Mar 10, 2012
I have a List(Of Hardware) - the List is called HWModels
Class Hardware has the following Properties:
ModelName
Status
CPUStatus
MemoryStatus
DiskStatus
The List is populated by reading a CSV file, once it's populated, I want to return the distinct records based on the ModelName
I've attempted by doing it as follows:
(From a In HWModels Select a.ModelName).Distinct
But this isn't right because I end up with a list of only the ModelName's and nothing else.
How do I get the Distinct function to return all of the other class members within the list?
View 1 Replies
Oct 25, 2011
I am trying to use Linq to Xml to query attribute values that will be used to populate a combo box. My xml looks like this:
<Records>
<Record id="1">
<LogoPositioning>
<Brand id="26">
<Xpos>100</Xpos>
<Ypos>200</Ypos>
[Code] .....
My issue is with getting the attribute values. I tried this:
For
Each xattr
As
XAttribute
In
attr
cboBrandChoice.Items.Add(test.Value)
Next
However, I keep getting the following error:
{"Unable to cast object of type '<GetAttributes>d__8' to type 'System.Xml.Linq.XAttribute'."}
I'm new to using Linq so this error isn't making a whole lot of sense to me.
View 2 Replies
Mar 28, 2012
I'm pretty new in Linq and the first problem I've is to select the Distinct values from a ObservableCollection( Of T)
I've tried with[code]...
View 2 Replies
Apr 26, 2010
I have 2 tables Table1 with columns [BId,Name,Amount] Table2 with columns [CId,BId, ExpenseType,Expense]. BId Is the foreign key in Table2. The Amount field in Table1 is always higher than Expense in Table2. I need to update the values of Amount (increase or decrease) based on value of Expense and I want to do it in single query in LINQ. Eg If the Expense has to be updated with 200, I would decrease(negate) Amount value with 200. If Expense is reduce to 100 then the Amount is increased by a value of 100.
View 1 Replies
May 11, 2012
I'm using Entity Framework code first and pulling some data back from our database. In the table I'm accessing is 13 columns that store the number of a items a customer purchased per week for the last 13 weeks as a char field. I have no control over how this data is stored. I need to total the 13 weeks results together to get a combined total, so take week1 + week2 + week3.... = Total Items Purchased over 13 weeks.In SQL I'd just Cast the char to an Integer and add the values together. But I'm struggling finding a solution to do this in linq.
I tried
(From c in Table
Select New With {.Usage = (Convert.ToInt32(c.week1) +
[code]......
View 1 Replies
Jul 2, 2011
Supposing the referenced List below contains 2 elements:
Dim Countries = From c In List _
Select New With { .Country = c.Country, .CountryID = c.CountryID }
The code above returns
.Country=Spain .CountryID = 1
.Country=Spain .CountryID = 1
How can I get the distinct values? The Countries query should contain only
.Country=Spain .CountryID = 1
View 5 Replies
Sep 23, 2011
I have the following example datatable:[code]And now the user should be able to compare multiple periods. In this example the user chose two periods: 1.1.2010 - 31.12.2010 and 1.1.2011 - 31.12.2011. The result of the example should be:[code]
View 2 Replies
Apr 2, 2010
I have a table with the below structure.
ID VALUE
1 3.2
2 NULL
4 NULL
5 NULL
7 NULL
10 1.8
11 NULL
12 3.2
15 4.7
17 NULL
22 NULL
24 NULL
25 NULL
27 NULL
28 7
I would like to get the max count of consecutive null values in the table.
View 3 Replies
Nov 12, 2011
From r In ReceiptLines
Where
r.RECEIPT.RECEIPTDATE >= _reportStartDate
And r.RECEIPT.RECEIPTDATE <= _reportEndDate
[Code].....
I am fetching all departments and their sales, average, count from the ReceiptLine, Receipt, ReceiptDiscount tables. The problem i am facing is, if i remove where discount > 0, I am getting null exception. But if I include that, then I only get sales that has discount. How would I write query that bring all sales less discount (if it has one).
View 2 Replies
Feb 21, 2010
If I have a datatble column set as int16 but rows can contain null values for this column. How do i write the linq query. I keep getting an error null value exception. Dim query = From n In resultstable.AsEnumerable Where n.value is dbnull.value does n't work.
View 6 Replies
Oct 19, 2010
I have a datatable which has been dynamically generated from FoxPro tables using a UNION Select statement. e.g.SELECT * FROM x UNION SELECT * FROM y UNION SELECT * FROM Z ORDER By v_alue1This produces a datatable with about 100 rows, each containing many fields, one of which is c_olor. From this datatable, I would like to select the distinct colors and then output in a dropdown.I have a public class Color which just has one property which I can then use as the DataTextField and DataValueField for the dropdownlist
Public Class Color
Private _c_olor As String
Public Property c_olor() As String
[code].....
View 1 Replies
Mar 8, 2010
Given the following XML, I would like to return all eventtitles where the eventtype id = 23. My current query only looks at the first eventtype, so returns the wrong result.
<event>
<eventtitle>Garrison Keillor</eventtitle>
<eventtypes>[code].....
View 1 Replies
Oct 1, 2010
I'm having issues with returning a list of strings of the .Value of a Linq query:
Dim details = <Details>
<Vector size="5">
<Item>Syntactic Structures</Item>
<Item>Introduction</Item>
<Item>The Independence of Grammar</Item>
[Code]...
Is correct in that it returns the list of XElements I want (items 1 - 4, base 0), but I really just need a list of strings for the .Value of those XElements. Maybe I'm just dense here, but anything I've tried in the chapterTitles query isn't working (appending with .ToList.ToString, etc.). details.<Vector>.<Item>.Skip(1).Take(4).Value just returns the first XElement's value.
View 1 Replies
Sep 19, 2010
I accept both C# and VB.NET suggestion, even though I'm writing an app in VB.NET I have two lists of intergers
List1 {1,2,3,5}
List2 {2,4,6,7}
I want to have new List3 {4,6,7} which is composed of elements of List2 that are not in List1. I know I can write a nice For Each loop for this but I want it done in LINQ I've been looking for such methods at Enumerable Methods, but I can't find it.
View 2 Replies
Jul 3, 2011
I am having so trouble with the ToUpper() procedure with strings. I am using LINQ to find unique values in a list of objects. In that whole process I set the values to compare to all lowercase in order to get a proper list. My goal is to populate a dropdown list with the values. I'm attempting to set the first letter of of the string to uppercase and keep the rest lowercase however the toUpper() procedure is not working?
Private Function FixCase(ByVal strIn) As String
Dim strOutput As String
Dim intStringLength As Integer = strIn.Length - 1
strOutput = strIn.Substring(0, 1)
[code].....
View 5 Replies