| Merging does not work as documented (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have been reading Core Reference ADO.NET by David Sceppa, a book by MSPress, and had found what I thought was the solution to a problem I have. I am referring to figure 11 8 where two DataTables share the same primary key (say an identity) but have different columns. According to the book, merging these two would result in a change in the number of columns of the receiving DataTable (now the... |
|
| Adding columns to database table (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello all, I'm writing a program that reads an Xml file and updates/patches a database with the information in the Xml file, e.g. add rows and columns to database tables, and add constraints to tables. I decided on using DataSet and OleDbDataAdapter, and there is no problem adding new database rows to existing database tables. Adding new columns to an existing database table is not working, could ... |
|
| Wrong Index after a datagrid is sorted - Help! (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a dataadapter that fills a dataset in an asp.net web application. A DataGrid then pulls data from a dataview whose source is the dataset. All of this works great. When I click on 'edit' in the datagrid it returns the proper record (proper primary key value of the record I'm editing). However, if I sort the datagrid (via the built in sorting headers) then click on 'edit' it returns the origi... |
|
| How to filter columns of a dataset using a dataview (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a dataset with 10 column fields in it. I want to bind this data to a datagrid but I only want to show 3 columns not all 10 columns. How can I create a dataview that filters only the 3 columns that I want to display. Thanks for any help! Shannon |
|
| DataSet.Merge doesn't track changes (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have discovered that when I used the Merge method, it will merge the new DataSet into the old DataSet and I can verify it by looking at it in a DataGrid. However, the changes to the DataSet do not appear to be tracked in the changed DataSet. That is, the RowState for modified/added rows is not being set. I can verify that by looking at the HasChanges property or by calling GetChanges and dumping... |
|
| Asynchronous loading of data (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a requirement to load data into a grid in a few seconds. Using the Recordset open method in ADO 2.x, I could do this and raise an event when the recordset had finished loading so the user would get the impression the data loaded quickly regardless how big the recordset was. My question is in ADO.NET how can I achieve the same effect? Rgds. |
|
| ASP.NET: Error "Login failed for user 'sa'." (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Dear all, When running the program, I recieved the following error "Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'." In web.config file, the connection setting is below: " appSettings add key "PubsString" value "workstation id 'sha tongl xp1';uid sa;pwd '';server localhost;initial catalog 'Pubs'" /add /appSettings " Any help will be highly appreciated. Tony |
|
| Expressions and their limitations (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I am using VB.net in a non Web applications I have been reading up on expressions and they seem quite helpful. However, in one book I've read it talks about what appears to be a severe limitation. The book may have been written before VS 2003 so maybe the issue has been fixed. I don't know. What I am told is that "Using expressions in combination with DatRelations gives you the ability to create a... |
|
| Tool for scripting out the database (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I am looking for a tool that will connect to the database and script the entire thing out (i.e. tables structured, stored procs, views, etc... including the data in the tables) to a file. I would then run this script elsewhere to restore the database. I'd prefer something that command line based (but not necessarily so) so that I can schedule it. Thanks |
|
| how to use mysql database or other db(not sql server or oracle) (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| In asp.net, it uses ado.net to connect to mysql or other type database. But I don't know how. Are there some articles that illustrate example? Thanks. |
|
| IDataParameter.ParameterName (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, Excerpt from the docs: "The ParameterName is specified in the form @paramname". What's the so called "form" supposed to be? It's a string starting with '@', what else? radi |
|
| Oracle date problem (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| We are having problems while retrieving dates from the oracle provider. If we make a query with SQLPLUS we obtain the exact date. Using the oracle client provider included in ado.net we obtain dates with 1 or 1 differences. For example, in the table the date is 11/Jan/2004 , and it returns 10/Jan/2004 The problem is with the time recorded in the field. What can the problem be??? Thanks. |
|
| inserting Null into date field insteadof "Jan 1 1900" (9 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| inserting Null into date field insteadof "Jan 1 1900" hi i am providing a html form to insert dates into sql table using asp.net and vb.net. when user is not entered by default it is taking as Jan 1 1900. I want to insert null if user left date fields. Thank u san |
|
| ExecuteScalar alternative (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| ExecuteScalar is great it returns the first field of the first row. Is there a command that returns just the return value from the stored proc? I can't seem to find it. Thanks |
|
| newbie needs help with DataSet (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a dataset which has one datatable which has one datacolumn, is there a way to convert it to a String[]? TIA |
|
| Last In Concurrency (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Using VS 2003, VB.NET, MSDE... I am working on a telephony program trying to figure out how to handle concurrency exceptions (which would be rare). Since the telephone is the interface, there is no way to present the information to the caller letting them select what they want to do when a concurrency exception happens. So, I would like to use the "Last In Wins" method of handling a concurrency is... |
|
| Oracle connection string with IP address (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| With SQL Server, I can create a connection string to a remote server using an IP address such as: "Data Source 190.190.200.100,1433;..." where 1433 is the port (1433 is the default) This works just fine. Is it possible to use the "Microsoft Managed Provider for Oracle" and connect via an IP address using something like the string below to connect to a remote Oracle 8i or 9i database server: "Data ... |
|
| Dataset Designer: This may be a dumb question (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I've noticed that when I'm working in the Dataset designer, if I drag a table and drop it on another table I get a "nested hierarchy". How is this different than using the datarelation you get when dragging the key from one table to another? When would one be preferred over the other? TIA Brian W |
|
| Import XML Files Into Access 2002 (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| In MS Access 2002, there's a functionality that will allow me to import an XML file into the database. Is there a way to do this programatically using VB.Net? Thanks for any ideas. Cesar |
|
| DataSet With Application_OnStart (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I've read many times about the benefits of using the DataSet object. I know that you can place it in the cache in just about any place. I was wondering, though, if it were a good idea to add the DataSet to the cache in the Application OnStart event (assuming that it can be done) to make it available to all pages that need it? Thanks, Roshawn |
|
| Working with Connection object (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, In my web application, I need to connect to an SQL Server database. My pages (UI) will use one or more business objects as well as datareaders (I cannot make everything a business object...) With ASP 3, I created a VB class named DataAccess which maintained an ADO Connection object and facilitates the creation of recordsets. One instance was created at the beginning of the page and a reference... |
|
| DataTable.Expression Question (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, How to calculate a value based on a Datatable.Field and a Variable. Somehing like : ..Columns.Add("NewValue", GetType(Double), "DataTableField * txtValue.text") TxtValue.text comes from a TextBox. Is it possible ? Thanks Stan |
|
| Dataset to table (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi I have a dataset which is filled with data. How can I write this dataset into a local access table and also creating the table if it does not exist and overwriting it if it already exists? A simple code example would be great. Thanks Regards |
|
| Handling empty relation to child object (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| In a Typed Dataset, is there a way on the xs:keyref tag that I can specify how to handle null child objects? For example, if I have an Invoice table, where a ClientID key is used to create a reference to a Clients Table by it's ID Column. On the Clients table I have a Name element. In the calling code I do : x myInvoice.Reference x myInvoice.Amount x myInvoice.Rate x myInvoice.Client.Name this wil... |
|
| connection (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a question about connection. I want to trap when the internet connection is down. For example, I fill in a Invoice row and lock it up. Now somehow, the client has a internect connection failure so that it loose connection to SQL server. How can I trap this in my application? I try to use withenvents for connection. There are only two events:StateChange and InfoMessage. However both are ... |
|
