| ADO .NET and Unicode (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a UTF 8 Oracle 9 database that when I query with ADO.NET and write to an .XML or populate a datagrid, I get a lot of ???? for the data that is Unicode. Is there any way in ADO .NET to get around this? Any examples? Thanks, M |
|
| is this a bug in autogenerated code (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to define a column in my dataset that looks up the description from the relationship. the error is correct stating the value is null as at that point in time (dataset definition) the dataset has not been populated! the fills come later as the dataset is populated This code comes from the autogenerated dataset.vb file and errors when the project is run and tries to create the dataset if... |
|
| ListBox / CheckedListBox & databind (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| hi i need to bind a datatable to a listbox. i'm using a windows form listbox and not web listbox. i have a dataset with a filled table called MSMQ with two columns called Description and MSMQId. i'm doing the following: ListBox1.DataSource ds.Tables("MSMQ") ListBox1.DisplayMember "Description" ListBox1.ValueMember "MSMQId" but this is doesn't working. i've already learned (from this newsgroup) tha... |
|
| OLEDB DateTime Problems (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am storing a record in a MSAccess Database using OleDB and Jet. My problem is that my app is only storing the date and not the time. Here is my code: DataSet dsGames new DataSet(); dbaGames.Fill(dsGames,"Games"); DataRow newRow dsGames.Tables["Games"].NewRow(); newRow["dDate"] "05/01/02 15:22"; dsGames.Tables["Games"].Rows.Add(newRow); dbaGames.Update(dsGames); After executing this code, I look ... |
|
| master detail inserts question (7 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hy, having master detail tables in sql database. master table Ident and detail ID fields are autoincrementing. on my form, master fields are bound to text and comboboxes. detail fields bound to a datagrid. I save the master table following way; make a new datarow for the master table, fill all the values, add the row to the datasource master table. update the table. So far so good. Now I need to g... |
|
| Heirarchal DataSet binding to Datagrid (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a typed dataset with two tables that I would like to bind to a datagrid. Most of the columns will be bound to the child table, but in the first column I need to bind columns from the parent table. How can I accomplish this? Can I make a DataView out of specific columns from the two tables? TIA~ Paul |
|
| Persist a Dataset w/ attributes instead of elements? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is there any way to get a dataset to persist itself using attributes instead of elements? For large datasets, the duplication of BigLongTagName ....... /BigLongTagName can end up a lot bigger than row ..... BigLongAttrName "..." .../ I hope this makes sense. I am returning a dataset from a web service and I would like the resulting xml to be as small as possible. |
|
| Dataset.merge deletion (c#) (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| (cross posted from dotnet.framework...) Has anyone been able to delete data from a dataset via a dataset.merge? I can update and append just fine, but I need to find a way to delete records via this method to allow a client/server (webapp/webservice) app to work... Thanks for any assistance, Rob |
|
| IDataReader - handling nulls (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| How do I handle nulls on an IDataReader: The following line of code throws an exception when it's value is null, I just want a zero back. int nItems (int)oIDataReader["Items"]; Tony |
|
| Deleting rows (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am still having trouble deleting rows from a dataset. When the user navigates to a specific rows, I want the users to click a delete button to delete the row. I am using code similiar to the following to navigate through the rows: Me.BindingContext(DsAuthors1, "authors").Position 1 (goes back 1 row). Can I use code similiar to this to find the row number to use in a delete? Please help. |
|
| Removing Relations (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| How do i remove a DataRelation from my Dataset i have not been able to find anything like dataset.Relations("relationname").Remove thanks nauzad kapadia |
|
| How to bind data to template columns (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Help! I have two issues concerning binding data from a dataset to template columns. First, I cannot figure out how to bind data in the dataset to the template columns in the datagrid. How is the link between the columns in the dataset and the columns in the datagrid made? Secondly, I'm using Oracle 8i as the datasource and a boolean datatype does not exist. I'm forced to using a 1 character string... |
|
| Fastest way to propulate a DataSet from an Xml Document object (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I need to populate a DataSet from an Xml Document object. The object contains 15000 nodes. Each node equivalents to a row and 4 columns per row. Here is what I tried and took more 2 minutes. public DataSet foo(string strXmlFile) { XmlDocument xmlDoc new XmlDocument(); xmlDoc.Load (strXmlFile); // do some work here... XmlTextReader r new XmlTextReader(xmlDoc.OuterXml, XmlNodeType.Document, null); /... |
|
| REPOST : No Original Data to Access (31 replies) |
| microsoft.public.dotnet.framework.adonet |
| I will repost an earlier bug that seems is not listed yet to the bugs on support.microsoft.com. I have attached a simple repro case of a *major* problem we encounter in our application To reproduce please follow the steps 1) Click on b1 dscr edit box and alter field (eg from "Parent" to "Parent1") 2) Click on b2 dscr edit box and alter the field (eg from "Detail" to "Detail2") 3) Click on tab page... |
|
| SQL Server 2000 (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have visual studio.net and I just install SQL server 2000, when I run program under asp.net to access database, I got error message said System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. how can I solve this problem. please help me.... I might to exchange to help you. smile. Alidad |
|
| indexes (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I was wondering how one can create indexes on a table in a dataset. I have a need to have multiple indexes on certain tables that are composed of more than one field. If this is possible will these indexes speed up searches just as they would in a conventional DB? Thanks Perry |
|
| To Bind, or not to Bind? (10 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi guys As I mentione din my other post, I'm involved in writing a winforms app using VB.NET. I'm deciding whether to use the built in support for data binding of controls in VB.NET, or to write my own methodology. What is the general experience with data binding in VB.NET? It was always a no no in the past because of pessimistic locking, etc, but how about now when we're binding to a disconnected... |
|
| Problem with update table (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have problem with update table. I write to simple code: ******************************************************** CEmployeeData ds new CEmployeeData(); DataTable table ds.Tables[ "Employee" ]; DataRow newRow table.NewRow(); newRow["SomeField"] "SomeText"; table.Rows.Add( newRow ); ds.AcceptChanges(); // Without this error: "Cannot insert explicit value for identity column in table 'Employee' when... |
|
| CurrencyManager Questions (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Q1. When i used the cm.addnew method to create a new datarow, Can i refer this datarow by a variable ? Q2. I had the different results when I used the cm.endcurrentedit method to a datarow. Result I If the datarow was a new row and created by cm.addnew method, when i applied the cm.endcurrentedit method, it checked the constraints, ie : PK did not allow null value. Result II if the datarow was not... |
|
| master detail, datagrid mappingname question (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hy In a master detail form I like to show the details in a datagrid. When I set the datagrid.dataSource to the dataset and the datagrid.dataMember to the table, a default datagrid table style is aperenty made and shows ok! Also showing the table key column and the referential column witch is not what I want. So I try to make my own table style; but what ever mapping name I use for my own datagridt... |
|
| Getting the autonumber value of a new record (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have an application using an Access database. I have a routine that inserts a new record to a table that has an autonumber field as it's primary key. The code for adding the new record is pretty simple: dtsPersons.Persons.Rows.Add(rowTempPerson) dtaPersons.Update(dtsPersons) dtsPersons is a typed dataset, the fields in the table are: PersonID PersonName Address EmailAddress In this code t... |
|
| Changing row data in handler for datatable.rowchanged event (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How can I change the data in a row in the handler for the rowchanged or rowchanging events? I have thought of a handful of ways it will not work, but I can't get my hands on something that will work for me. I want to change a particular row field based on other fields. when I change the data, it doesn't stick because you are apparently not able to change the data in a modified row. since the event... |
|
| NextRecordset (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Dose ADO.NET have the a version of the old ADO's NextRecordset for stored procedures that return several recordsets? Ta in advance, Michael McDowell |
|
| Databinding problem (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am binding some textbox controls to a dataset for quick viewing and editing of a database. If I call the currencymanager's addnew method, it adds a new row to the dataset. But when I want to update, I call the CM endcurrentedit and it clears out the last text entered!? I notice if I type something in any textbox, then call endcurrentedit, it clears the text, but if I enter the text again and cal... |
|
| Dataset not updated when Close button clicked (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| When using a data bound DataGrid on a Windows form I have discovered that the underlying dataset does not get updated until the user moves off of the row being changed. In most cases this is not a problem, however when the user goes directly to the dialog's built in Close button (red X), the dataset does not get updated. I am trapping the form's Closing event, where I am trying to give the user th... |
|
