I have some data in my Linq.DataContext.I had succes in converting it to an XSD - Schema, using the following code:
Dim changeset As System.Data.Linq.ChangeSet = c.GetChangeSet()
Dim objDic As New Dictionary(Of System.Type, List(Of Object))
If Not changeset Is Nothing AndAlso Not changeset.Inserts Is Nothing AndAlso Not
[code].....
How to bind a textbox in design view to a LINQ to SQL datacontext class?
View 3 RepliesI have an object that may have been inflated via a plain old DataContext, or may just have been new-ed up with just its .ID property set. There's no way to know for sure. I'm looking to rehydrate the entire object from whatever is in the database. If the object was new-ed up, I can call .Attach() on the table object and refresh from the Data Context with no trouble. But, if the object was already inflated from the DataContext I get the error: "Cannot attach an entity that already exists.". There's no timestamp field or anything like that - just an integer primary key being used to control the rehydration. I'd like to know if there's a way to conditionally attach. Here's the code - it works the way I want it to, but this seems a hackish way to go about it:
' myDC is a shared instance of a vanilla DataContext...
' myObj is an instance of a linqed-up `SomeLinqObject`
Dim tbl = myDC.GetTable(Of SomeLinqObject)()
[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 RepliesI'm going through an XML file of articles and the journalist(s) that wrote them. As we are adding the articles into _Data our datacontext we may come across a journalist that needs adding so we do this: [code] However subsequently we may come across this same journalist again and nothing is returned when we do this: [code] So it uses the code above again to insert the same journalist again.Once all of our inserts are done we do a submitchanges. At this point it has a head fit:INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ articles_ journalists_journalists'. The conflict occurred in database 'blah', table 'journalists', column 'id'. The statement has been terminated.From looking through the sql generated in sql profiler you can see that it is trying to add some journalists more than once, this will fail as the name must be distinct. The subsequent records that are trying to be inserted with these journalists are failing as the journalist wasn't updated.Surely if I have a collection of journalists, add some to it and then look in my collection I should see all of them and not just the original ones.
View 3 RepliesI have a php web service that I can call from a php client. I need to call this web service from a vb.net application. When I try to add a reference to this web service I get this error:The root element of a W3C XML Schema should be <schema>here is the top of my wsdl file:
<?xml version="1.0"?>
<!-- partie 1 : Definitions -->
<definitions name="raidService"
[code].....
I have a context menu on my DataTemplete for a list box, and that menu will contain links to Favourite and Retweet the tweet (the menu item) But I don't know how to get the information about the Tweet in code. I am trying the following Line:
[Code]...
I am setting my viewmodel as datacontext in my xaml but I override it to my view to make few functions work however to achieve the visibility on some grids and I have a property in my VM can I override my datacontext back to my VM? If so how? I have a stackpanel that has datacontext overriden as my grid and within that stackpanel I need to change the datacontext for a button.
View 1 RepliesI would like to know if its possible to discard changes of only one record of only one table in datacontext. I use databind to bind my controls on a form. I modify one record at a time. after the modification, the user have to hit save button to validate. But he can hit cancel. I would like that the cancel button discard all the changes that the user has done. Is it possible?
View 3 RepliesI asked a question earlier where I was told a simple way to "bind data to objects" is to just run a SqlConnection(connectionString). The response also included a comment saying I could get fancy with L2S and Entity Frameworks, so I looked deeper into those. It seems all you have to do with the DataContext object is point to the database. Why would SqlConnection be a benefit? What is the difference (or pros/cons) of using either one of these? Is one more "standard"? Is one more modern?
View 1 RepliesUPDATE: See the bottom of this question for what I did to solve the problem.I'm trying to understand how the ItemsSource and DataContext properties work in a Silverlight Toolkit DataGrid. I'm currently working with dummy data and trying to get the data in the DataGrid to update when the value of a combo box changes.
View 2 RepliesI'm trying to find a way to have the DataContext available from within Entities.
I want to do something like this:
partial public class MyEntity
public DataContext as MyDataContext
private sub OnLoaded()
[Code]....
This should be pretty easy, but it throws VS2008 for a serious loop.I'm trying out WPF with MVVM, and am a total newbie at it although I've been developing for about 15 years, and have a comp. sci. degree. At the current client, I am required to use VB.Net. I have renamed my own variables and removed some distractions in the code below, so please forgive me if it's not 100% syntactically perfect! You probably don't really need the code to understand the question, but I'm including it in cas.
I have a very simple MainView.xaml file:
<Window x:Class="MyApp.Views.MainView"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
[code].....
I am preparing to deploy a web service that uses SqlConnection primarily as its means to get to the database, and I am adding some new methods that use a DataContext instead of thatand the default constructor and DBML file would use a connection string refering to my development machine (I believe...)
View 1 RepliesI am new to WPF and the MVVM design pattern this month, and more than a little out of practice in general. To learn, I've been playing around with textboxes, rectangles, and ways to display them in a window. I began with Ashley Davis' excellent "Simple Drag Selection in WPF" tutorial, which walks through creating a view model for a collection of rectangles, binding a listbox to said collection, and styling the listbox with a canvas, creating a data template for the rectangles, as well as basic "rubber band" selection logic.
I have since built on this tutorial to improve the drag selection so that it behaves much more like selection does in windows explorer, and to allow resizing the rectangles from the corners or edges.All was well until I changed the MainWindow.xaml in an effort to include a column on the side for various buttons and controls, thus moving the "editor surface" grid from inside a 1x1 grid on the main window to a column of a 1x2 grid, moving the data template to the grid's resources (since it will be the only element in the window that needs it). As soon as I did this, subroutines that I wrote which interact with the listbox started misbehaving--rubber band selection no longer works. There's no visual indication that listbox items are being selected (they were highlighted previously), and interrogating listBox.SelectedItems.Count after a drag-selection mouseUp event returns a zero.
After some experimentation, reading many questions on this site and sections of my WPF Unleashed book, and going over the msdn databinding overview, as of this morning I still cannot find my mistake(s). I believe it is a data binding mistake or incorrect data context.Some details about the view models involved:
DataFieldViewModel
...implements INotifyPropertyChanged and exposes properties for its (in this case a rectangle and a textbox) X,Y position, width, height, visibility, and selection status (a way to track it across several rubber band selection operations)
PageViewModel
...implements INotifyPropertyChanged, and has among other things an ObservableCollection of type DataFieldViewModel, called DataFields, and exposes it as a ReadOnly Property.Here's a look at MainWindow.xaml.vb and one of the broken subs:
Namespace EditorUI
'
' The main window of the editor.
[code]....
a datacontext defined in a module(domain services ado.net ria)a page having add/delete methods whenever any method is executed, it is found that all the previous actions (NEW RECORD ADDITION and DELETION OF RECORDS) are carried out before the new action is carried out normally
this behaviour is not prominent but "when using break points and inspecting the values of the variables and table object to be added to context, it is clear that all the previous actions take place again. even when the datacotext. savechanges is called, even after that still all actions carried out on the datacontext repeat themseleves, when any new action is to be carried out
<ItemsControl DockPanel.Dock="Top" ItemsSource="{Binding Path={x:Static vmc:clsPersonViewModel.ChildrenPath}, Mode=OneWay}">
<ItemsControl.ItemTemplate>
[Code].....
In the code above, if there are no children (the ChildrenPath property returns NULL), nothing is rendered in the view. In the code below, when ChildrenDataSetPath is NULL the XamDataGrid still gets rendered. How do I achieve the same for a single object (as opposed to a collection) as the datacontext?
<DataTemplate DataType="{x:Type vmb:clsPersonViewModel}">
<igDP:XamDataGrid DataSource="{Binding Path={x:Static vmb:clsPersonViewModel.ChildrenDataSetPath}}">
[Code].....
the schema is created using VS, but when I try creating the schema using XSD.exe, the validation works, am I missing something here, like namespace or anything?
SCHEMA:
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="EmployeeXML" targetNamespace="http://tempuri.org/EmployeeXML.xsd"
elementFormDefault="qualified" xmlns="http://tempuri.org/EmployeeXML.xsd"
xmlns:mstns="http://tempuri.org/EmployeeXML.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:simpleType name="NameType">
[Code]...
I have an imported sql database using pa as the schema instead of the default dboThe problem is when I go into vs 2008 and create a gridview control, it won't recognize the from table object. I get "invalid object name" unless I go directly into the code and put the database name and schema name in front of it.
View 5 RepliesI have written a small XML validator, that takes in an XML file and an XML schema and validates the XML files against that schema. It works well, except for an XML file, with this content:
[Code]...
I would like to take data, from a dataset, and parse it out in XML. but, i would want the XML to be based on a particular XSD schema. The dataset is being filled from a database (wich i have no problems doing).
View 1 RepliesAre there any commands that make life easy with respect to this? I want to take the column schema of one datatable (.net datatable) and copy it to another new datatable.
View 2 RepliesI want to move a table schema from one database to another using vb.net or c#. How can I do that?
View 1 RepliesI am using microsoft access 2003 and visualbasic.net. I am trying desperately to add a database using the wizard, and it lets me go through with it, testing the connection is good, but when I try to finish it gives me an error: "<customers>Could not retrieve schema information for table or view customers." What am I doing wrong? I've added databases in the past without this problem using the same Access.
View 12 RepliesHow do I create a .xsd Schema file from a given .xml file programatically?
Is there a .NET class representing XSD.exe ?
i have to create a class that creates an xml file using a schema.i created a "Component class in vb.net and setted his properties with the tag xmlelement("nameofthexmlnode").i did the creation of the xml.Now i have to use the xml schema but i didn't found an easy to use/understand example.i know that i have to serialize the object but i can't still create an xml using a valid schema.
View 2 RepliesTrying to dispaly a sql server database schema on a webpage, vs 2008 see the code below
[Code]...
I have an .XSD that is made from a class so that I can pass to a webservice. It got it over to the webservice as an XMLSchema object and now I need to make it into a class so that I can make objects out of it on the webservice side. I know that XSD.exe is the answer but I'll be darned if I can puzzle out exactly how to implement this thing. I need it to do this conversion at run time so I need to put the code for it into my project and all the references I've seen to using XSD.exe talk about calling it from the command line.
My .XSD is below.
<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="[URL]">
<xs:element name="Field">
[Code] .....
In my project this is living in an XMLSchema object. How do I turn it into a class?
I import a XML to a Dataset and works fine, import XML with Schema and fine to, but for any estrange reason the primary key that is in the XSD don't appears in the Dataset.
The XML and XSD are generated from a access 2003 table, right button and export.[code]...
I'm a little stuck here and maybe some of you can point me in the right direction ... maybe even get me a solution. Well, I do query a table but before everything I need to get the SQL Query to create the Table (like you get, when you select to option "Create to" in SQL Server Management Studio). For example like this:
[Code]...