Use Linq To XML To Update A Document?

Aug 31, 2009

In general I have a xml document that i need to update.The query looks like this:

Of course it gives me a "This attribute is readonly" error.[code]...

View 4 Replies


ADVERTISEMENT

.net - LINQ Update Method Doesn't Update The Db?

Nov 5, 2010

Public Sub UpdateStaff(ByVal sr As StaffRecord)
Dim oldSr As StaffRecord
Dim q = From staff In db.StaffRecords Where staff.Employee_Number = sr.Employee_Number Select staff
oldSr = q.First
oldSr.Address_Line1 = sr.Address_Line1

[Code]...

The helper function I have written seems to do everything I want apart from update the db. Stepping through the code, the oldSr is updated by the new sr parameter but no update on submit changes.

View 2 Replies

Add An Element To The XML Document With LINQ To XML?

Mar 15, 2010

I'm adding an element to existing XML doc with the following code:

Dim theXMLSource As String = Server.MapPath("~/Demo/") & "LabDemo.xml"
Dim nodeElement As XElement
Dim attrAndValue As XElement = _

[code]....

It makes error like this:

System.NullReferenceException: Object reference not set to an instance of an object.Object reference not set to an instance of an object.Error line: nodeElement.Add(New XElement(attrAndValue))

View 4 Replies

Loading A Xml Document From A File Built Use Linq.Xelement

Jan 11, 2012

I'm trying to load in a xml file that was build using another windows form, but when I try the xml document I get the following error: Name cannot begin with the '%' character, hexadecimal value 0x25. Line 10, position 13.[code]

View 3 Replies

VS 2008 Xml Document Would Be Taken From The Web And Stored Into An XDocument Object / Linq Query

Jul 27, 2010

I have the following xml document which would be taken from the web and stored into an XDocument object.

[Code]...

View 3 Replies

Update Text Fields In PDF Document

Mar 11, 2010

Does any one have any examples whereby the code can access a PDF Document (adobe) and update the text fields inside that PDF document all from VB?

View 1 Replies

Program Update The Changes Made To The Current Document

May 29, 2009

How would i make my program update the changes made to the current document. And if it hasnt been saved yet make it show my save as dialog?

View 1 Replies

XML Document Object - How To Update Database Table

Jul 22, 2010

I have an XmlDocument object in memory which I need to update a database table with. My SQL Express 2005 DB table is three columns: Name, Telephone, Location. Below is the structure of the XMLDocument. What is the recommended technique to accomplish this?

HTML
<MyDirectory>
<Prompt>Records 1 to 561 of 561</Prompt>
<DirectoryEntry>
<Name>John Doe</Name>
<Telephone>22334222</Telephone>
[Code] .....

View 3 Replies

Linq To XML Update Value?

Nov 17, 2010

I'm playing around with Linq and XML and came across a need to update an XML node. Below is my code to read the xml, my question is, can I edit the xml source that I have loaded in to memory (from file) and save it?[cod]e...

View 1 Replies

Update Xml Value Via Linq?

Dec 17, 2010

Im trying to update the "value" Attribute of some xml file that have this structure:

<app-settings>
<setting name="codeBasePath" value="E:data" />
<setting name="server" value="LOCALHOST" />

[Code].....

View 6 Replies

How To LINQ Datatable Update

Sep 21, 2010

discovered the compact mode of this instructions vs usual code. I found sample code for selecting, etc. from a datatable, transforming a column in a list or array - all operations are "Select"s - readonly.I need to make an simple update on a certain rows (using LINQ) from a DISCONNECTED datatable for which now I'm using this

for each dr as datarow in dtable.Rows
dr("MyField") = 77
next

[code].....

View 16 Replies

How To Update Data Using LINQ To SQL

Aug 1, 2011

I need to update a datatable using LINQToSql. Option Strict is ON. Datatable name is Customer with fields customerID, customerName, SalesID. I need to update rows with SalesID = -1.

View 1 Replies

How To Update XML Element With LINQ

Mar 15, 2010

I'm editing XML element with the following XML:
<?xml version="1.0" encoding="utf-8"?>
<!--Test XML with LINQ to XML-->
<LabSerivceInfo><LabService>
<ServiceType>Copy</ServiceType>
<Price>1</Price></LabService>
[Code] .....
How to update the ServiceType and Price where ServiceType = varServiceType?

View 2 Replies

Update List With Linq Instead Of For Each?

Mar 9, 2012

I am a bit new to linq, I am only using linq for filtering the data. [code]...

Con.Numbers is a dictionary, but now I converted it into a list, hence the above code wont work with list[code]....

View 2 Replies

Update XML Element With LINQ To XML?

Mar 15, 2010

I'm trying to update an element in the XML document below:

Here's the code:

Dim xmldoc As XDocument = XDocument.Load(theXMLSource1)
Dim ql As XElement = (From ls In xmldoc.Elements("LabService") _
Where CType(ls.Element("ServiceType"), String).Equals("Scan") _

[code]....

But, I got this error message:

Object reference not set to an instance of an object.Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Error line:ql.SetValue("23")

View 1 Replies

.net - Linq-to-SQL Database Update Fails?

Aug 18, 2010

Very simple update. It simply fails, no error, no change gets made to the database.Dim db As New BarClassesDataContext Dim foo = (From a In db.articles Where a.id = 14 Select a).Single Response.Write("<h3>" & foo.title & "</h3>") foo.title = "This is my new, updated title for article ID #14"
db.SubmitChanges()

Here is the relevent portion of my article class. Also, this is a web form so I have no console. Is there another way to view the T-SQL output?

<Table(Name:="dbo.article")> _
Partial Public Class article
Private _id As Integer
Private _issueid As Integer
Private _dateadded As Date

[Code]...

View 3 Replies

Asp.net - Update Linq To Sql With Variable Names?

Apr 15, 2012

im pretty much a beginner to using ASP.net and linq to sql but what im trying to do is update a column of a table based on a variable. at the momment i have

Dim db As New sqldcDataContext Dim update As tableName = (From i in db.tableNames _ Select i)

i think this selects everything, how could i have two variables, one to store what table to update and the other what column. is this possible?edit: sorry for being unclear im trying to make this as dynamic as possible so i dont have to type in the exact table/col names. something like this but in the linq to sql syntax.

mysql_query("SELECT * FROM ". $table ." WHERE `" . $column . "` = "" . $data ."");

View 2 Replies

LINQ To SQL Update Not Working Correctly

May 11, 2009

I use the following statement to position which row to update;
Dim salonToUpdate = (From r In db.Salons _
Where r.StoreID = storeID _
Select r).Single()
If fileDate = #1/1/1900# OrElse fileDate = Nothing Then
SalonToUpdate.LastDownLoadDate = TableDate
[Code] .....

I've double checked to make sure none of the dates are invalid or null, but when the bolded statement executes, the following sql runs through the trace:
exec sp_executesql N'UPDATE [dbo].[Salons]
SET [LastDownLoadDate] = @p0
WHERE 0 = 1',N'@p0 datetime',@p0='2008-01-04 00:00:00:000'
Of course it's going to fail if LINQ is passing in where 0=1 every time. Shouldn't it be using some unique row identifier, (in my case, the salon id), to update the specific row?

View 2 Replies

Linq Update A Signle Field?

Jun 19, 2009

I am using database compact and i loaded it on my form and i want to update a single field but I cannot, why:

what am doing is:
dim newrec as datatable=(studentdataset."TableName")
dim querie= from det in newrec.asnumerable() _

[code].....

View 5 Replies

Update A Column In A Database Using Linq?

Aug 22, 2009

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?

View 9 Replies

Web Services - .net Linq Update Data?

Jul 31, 2011

Im using linq and im able get get data ouf of it realy easy. but i seem to not be able to update the data. the program does not error on it and it looks likes it has updated but it does not save te changes.

Public Function UpdateAlarmsbyKey(ByVal objKey As Integer, ByVal IdNumber As String) As Boolean

[Code]...

View 1 Replies

.net - Update 2 Table Values In One Query In LINQ?

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

.net - Update Students Table Record Using LINQ To SQL?

Aug 22, 2011

I´m trying to update my Students table record using LINQ to SQL. The problem is when one of the Properties of the object changed and 'PropertyChanging' Event is fired using 'SendPropertyChanging()' method.

student_id is a PK
data types are matched

Here is the full ArgumentException:

GenericArguments[2], 'System.String', on
'System.Data.Linq.Mapping.PropertyAccessor+Accessor`3[T,V,V2]'
violates the constraint of type 'V2'.

[code]....

View 1 Replies

Performing Insert And Update On A DataTable Using LINQ

Jul 12, 2011

I am pretty new to using LINQ and have been trying it out querying my strongly typed DataTable.
I have managed to perform a 'Select' ok but was wondering if someone can point me in the right direction to do Insert and Updates. I'm not sure if LINQ is best doing an insert at all?

My Select code is as follows:

Dim results = From myRow In _dt.AsEnumerable() _
Where myRow.Language_key = Lang And _
myRow.Section_key = SectionKey And _

[Code]....

View 1 Replies

Update An Object's Foreign Key Value With LINQ To Entities

May 4, 2012

[code]How do I update the ProdServiceID in the database using LINQ to entities?

View 1 Replies

Update Columns In Datatable Using Linq Without Condition?

Jun 22, 2011

How to update columns in datatable using linq without conditions. I have an idea that I'm just gonna loop all the data in the datatable but don't know what comes in LINQ.

View 5 Replies

Update Specific Rows In LINQ To SQL Result Set

Apr 6, 2010

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?

View 1 Replies

Edit / Update Records From Database Using Textbox By Linq To Sql?

Oct 14, 2009

I'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 Replies

Edit/update Records From The Database Using Textbox By Linq To Sql?

Oct 14, 2009

I'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]........

View 3 Replies

Update,Delete And Add To A Datagridview With Underlying Tables Using LINQ?

Jan 19, 2010

I'm looking for a simple example in VB2008 code.I have the Northwind DB installed on one of our SQL servers.

I've worked with the Datagridview on serveral occasions but never used its update,delete or add functions. I've Googled around the web, but could not find a simple example.

Whats the best way to do this and implement it using LINQ?

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved