


hi i have 2 relational tables in the dataset when i save sometimes it gives me this exception sometimes not !!!!!! although the parent record is not deleted or modified !!!!!! the exception is "you can't add or change arecord because a related record required in parent table " how ...
Please, I could use some help. The problem is simple, I have a dataset from which I bind a datatable column to a control:sql = String.Format("SELECT * FROM [ChanSection]");dsAdapter = new OleDbDataAdapter(sql, pdata.Conn);OleDbCommandBuilder cb = new ...
I'm doing the typical master-child form. Master's records are in textboxes, one checkbox. Child is in a grid. A relation joins the PK/FK.MasterTable: SRProfile2Child: SRProfile2DetailPK/FK: Profile2KeyRelation: SRProfile2SRProfileDetailI can do the following:Delete a childAdd a child to an ...
HiIn Windows datagrid, one of the column is a boolean column, in which, user don't want to see True/False. They want to see Yes/No. Similar, kind of requirement is when another column is bind with a checkbox. They don;t want checked or unchecked box in the column.How can I display just Yes or ...
I'm sure everyone here is overjoyed! Here's my problem. 1)I fire off a query and fill up a dataset, grab a datatable out of and bind it to a DataGridView object. I'm not using any of the visual tools doing it all by hand. One of the columns in my dataset is an integer field called "status". ...
Hi, I generate a strongly typed dataset: xsd.exe ConfigExport.xsd /dataset /language:cs. It does the correct generation (my Id column is numeric as defined in the xsd): public uint Id{ get{ return ((uint)(this[this.tableFunction.IdColumn])); } set{ this[this.tableFunction.IdColumn] = value; }} ...
The update statement generated in an xsd schema contains by default every field in the where clause, although the defined primary key should be enough.Is there a way (except manually) the have sthe schema generate better Sql Code ?Kind Regards, Harry...
xsd files create typed datasets in C# Express 2005. All I need do is add it to the project. But in VS 2003 adding it to the project does nothing. I've tried several other xsd files and none of them seems to create typed datasets in VS 2003 the same way they do in C# Express. Any suggestions ...
The Datagridview redraw is extremely slow on XP 64-bit. I am using only 14 records with local access - so it's not a large data problem.Any suggestions?Thnx...
Hi all,I am writting a small application that works with songs and playlists. I am reading the information from an xml file, that has this format:<Root> <Tracks> <Track> <ID>IDxxx</ID> <Album>xxx</Album> ... </Track> <Tracks> ...
Hi,I've an XMl which has many nodes in terms of different Names.I need to fetch the Selected node and display that into a dataGrid since XMLDocument and C# doesnot allow to a load a part of a xml document.Is there any way to achive it?Thanks...
Hi,I need to privide my users with a visual interface do map values from diferent xml messages, just the the biztalk Mapper. e.g: MessageA.FieldX goes to MessageB.FieldY , and so on ....something like the biztalk mapperAny thing like this?really appreciate ...
Hello,I have XML database like this:<root> <user1> <item1>blabla</item1> <item2>blabla</item2> </user1><root>I need to have this items listed in my listbox by every user (will be selected in some combo or so).What's the best way to do this using ...
I've got a datagridview bound to a dataset that reads in an XML file that looks like so:<root><item>False</item></root>What I need is for this item to show up in the dgv as a datagridviewcheckboxcell instead of simply a textboxcell. I'm getting the text ...
When searching a DS loaded from a .xml file I get the error that the table does not have a primary key. I checked the .xml file (with schema embedded) and the primary key is set. The errror comes in item #2 when you do a search on the DS Any help would be appreciated. Tks, graab The following ...
