Hi, i have a Problem with DataGridView in c# and i hope you can help me :) I added a DataGridView to my Application and bind it to DataTable. The DataTable changing the content but the DataGridView doesnt display it... How can i change this ? Thanks ...
Hello guys, I get some informations in a Dataset, and i would like to cast it in a strongly type object. For example my dataset have : TableName : tab_data Rows : 1 Columns : Name, FirstName, Address So i created a class like : public class Customer { public String Name; public String FirstName; public String Address; } Is there...
I am going to start on with a new project. I need to deal with hundred gigs of data in a .NET application. It is very early stage now to give much detail about this project. Some overview is follows: Lots of writes and Lots of reads on same tables, very realtime Scaling is very important as the client insists expansion of database serv...
At work we use DataStage which uses dataset (.ds) files. I can view the contents of the file from without our UNIX environment by using: orchadmin dump -name <dataset name> This only dumps the contents of the file to the screen. What I would like to do is have that dump stored inside a text file which I could then open/read from withi...
I'm looking for a java library or some help to write my own interpolation function. That is I have two arrays of doubles which are potentially different sizes, but are ordered. I need to be able to make an estimate of intermediate values, and insert so that both arrays become the same size. In fact the total number of points appearing...
Hi, I am using Linq to dataset to query a datatable. If i want to perform a group by on "Column1" on data table, I use following query var groupQuery = from table in MyTable.AsEnumerable() group table by table["Column1"] into groupedTable select new { x = groupedTable.Key, y = groupedTable.Count() } Now I want to perform group...
I have now found a TON of crappy not clear, not relevant examples of ways I can start to tackle the problem. Can't believe i've spent any more than 10 minutes on this but it's been 3 hours so far. I am looking at an aspx page with next to no code behind. This page renders a crystal report out to a pdf. The crystal report is bound to an...
I need to create two tables. The first one I can get via database with a command. No sweat. The second one is built from the first one with nested SELECT statements, JOINs, and operators like SUM, AVG etc. So it needs more functionality than filtering and sorting. It is done in C# with .NET 2.0, so no advanced features available. Ess...
Hi i want to represent a many to many relation in my wpf appliaction.I want to fill a combobox in my listbox according to a relation.But my parent table does not contain a primary key.So i am not able to add a relation also.My tables are as follows Tests Table(no PK) ............ Id TestName Sample 1 Test1 Blood 1 ...
I am using a dataset to insert data being converted from an older database. The requirement is to maintain the current Order_ID numbers. I've tried using: SET IDENTITY_INSERT orders ON; This works when I'm in SqlServer Management Studio, I am able to successfully INSERT INTO orders (order_Id, ...) VALUES ( 1, ...); However, it doe...
I am in the process of converting an in-house web app to a winform app for disconnected reasons and I hit the following snag. In the Function SaveMe() on the webapp there is the following code on the Person.ascx.vb page --> //get dataset from session Dim dsPerson As Data.DataSet = CType(Session.Item("Person" & Me.Uni...
The problem simplified: I have a DataSet with some datatables... I have a Winforms DataGrid bound to one of the datatables. User sticks some rows into said datatable, via the DataGrid, let's say 3 rows; All three rows now have their RowState = DataRowState.Added. I now begin a sqlserver transaction. Then call dataAdapter1.Update(dat...
Hi, I have created a dataset and in the designer I have created the relations and foreign keys that exist in the database. Basically, I have a product that has a relationship to a table of prices. The keyfield they share is IdProduct in the Prices table. In the Fill/Get of the product I return the Price field. I also have a DataGrid t...
DataRow[] rows = myDataSet.Tables[0].Select("name = '" + _string + "'"); If _string contains UNICODE characters, do I need to prefix it with N like in TSQL? DataRow[] rows = myDataSet.Tables[0].Select("name = N'" + _string + "'"); Thanks! ...
I have a Generic list of Objects. Each object has 9 string properties. I want to turn that list into a dataset that i can pass to a datagridview......Whats the best way to go about doing this? ...
Hi, I have used Dataset Designer in built in Visual Studio 2008 for my asp.net application to interact with my Sql Server database. Now i want to port my application to postgresql database. Can i use Dataset Designer similarly with Postgres? Or otherwise i am looking for an alternative tool that works similarly like Dataset Design...
Hi, I am trying to learn the basics of Windows Mobile development against SQL CE and have come across a basic problem. I have two tables. One called Customers that stores customer info and has an identity column called ID as the primary key. The other table is called Orders which has a column called CustomerID (the FK constraint is p...
I have a collection of objects (List) that is bound to a datagridview. How when I add or remove an object from the collection, can it refresh the datagridview without rebinding the control? ...
I need to insert the dataset records(C#) into the MS Accessdatabase table. I need to do the bulk insertion of records. How can I do this in C# ...
Hi I'm trying to working with RSS feeds in C#. I added RSS feeds like this and this When I try to read into a DataSet like: ds.readxml(rsspath) I get some tables in a DataSet. Now how do I know which table contains exact data of all the products? I'm not getting products list if I write: gv.datasource = ds.tables[0] Any help o...