Data Sets only hold data and do not interact with a data source.
This is a new Silverlight Data Grid control that allows the user to bind data in a traditional . Currently there's no support for Data Set and Data Table in Silverlight, so these two classes have been built in the same component as well, trying to replicate the minimal set of functionality to make everything work. With this control and the new classes everything is generated dynamically at runtime (using Reflection to create the objects needed to populate the "rows").
Also, the columns can be defined using the Data Columns prior to binding, so when the data is actually loaded their properties (read only, resizable, sortable, ...) are set automatically too.
In Lesson 3, we discussed a fully connected mode of operation for interacting with a data source by using the Sql Command object.
In Lesson 4, we learned about how to read data quickly an let go of the connection with the Sql Data Reader.
I'll probably put the code elsewhere but for the moment my blog is where you can keep updated of what's going on with the project (or ask questions, etc...).
The project will still remain in Codeplex until the site is closed but will no longer be updated. Project Description New control extending the Silverlight Data Grid to enable an easier use of binding objects with Data Source instead of Items Source. Actually binding data to a Silverlight Data Grid is easy with the Items Source property as long as it's IEnumerable, but the problem is that it has to define the "rows" previously, that is, the "cells" (properties of each object) have to be known at design time. Data Bind(); // Create a column Data Column dc6 = new Data Column("col6", typeof(Image)); dc6. Thanks to user Ken Eucker on tip for getting Selected Item property. Relative Or Absolute); Image Source img Source = new Bitmap Image(uri); Image img = new Image(); img. dr["col6"] = img; Plans include to add more validation and bullet-proof the current code, extend types of datasources, translator between equivalent . Net Data Set so it can be deserialized into this "custom" Data Set to be used by the grid), ...That’s how the adapter can later generate the commands it needs.) The code then calls each data adapter’s This entry was posted in controls, database and tagged C#, C# programming, controls, database, Data Grid, Data Set, example, example program, OLE DB, Ole Db Command Builder, Windows Forms programming. I read the other threads but i didn`t understood and none of the codes worked. I have 1 form with a Data Grid View bounded to the table Produse and 3 texboxes and 1 Save button. In the save button i`ve putted the code : Using con As New Sql Connection("Data Source=.\SQLEXPRESS; Attach Db Filename=H:\Projects\Windows Application1\Windows Application1\Database1.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True") Try con.