| XML to DataSet problems (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm having trouble getting the DataSet object to load XML similar to the following: info item1 details /item1 item2 details /item2 /info The error I get is: "The same table (details) cannot be the child table in two nested relations" Also when trying to load the schema for this XML I get the same error. I know the problem has something to do with the dataset object not knowing how the item1 ta... |
|
| DataView or ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm building a data table programically and adding it to a dataset. However, I need to do some grouping and counting. I know I can use a dataview for filtering or sorting, but does anyone know of a more powerful tool for querying tables in a dataset? |
|
| Reading image columns from SQL Server (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I use the following code to read an image column from a SQL server 2000 database and save to a file. The files are created correctly, but when the application (Excel, Word etc.) is used to open the files, they are some how damaged. I know the files are correct because using ADO 2.7 and a stream the files are written and read by their respective applciations correctly. What am I doing wrong? 'Test ... |
|
| accessing row by primary-key of GUID type in DataTable (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I want to use DataTable.Select(string) method to select a row by specifying the primary key column value. However, my primary key column is of type GUID in SQL server. I tried this: myTable.Select("ID '" guid.ToString() "'"); but got an InvalidCastException saying "Specified cast is not valid". From the doc "ms help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemdatadatacolumnclassexpres sionto... |
|
| ADO.NET: Connecting to MySQL Server (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hey, I have a MySQL server running at 192.168.0.1:3306 I know how to connect to access databases using .Net, but I don't know how to connect to MySQL. Can somebody show me the connectionstring and a small example of opening a connection in ASP.NET ? Thnx |
|
| OLEDB: Data not written right away using ExecuteNonQuery? (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have been battling a problem for some time with a project I've been working on and I think I've finally distilled it down the following theory and example. The project is very complex, using multiple threads and throwing lots of events. In general lots of INSERT and UPDATE statements will be excuted directly on a single database and then events will be generated that eventually result in another... |
|
| Controlling a Datagrid from Code behind? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it possible to get the Edit, Update, Cancel events to fire to a code behind based function? I would really like to keep my Core logic separate from my UI if possible. |
|
| Default values in typed datasets? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Since ADO.NET defaults to enforce non nullable fields, why doesn't the "table import" to a type dataset also enter the default values or aren't these available from the server when designing the dataset? It's a kinda pain to have to manually enter all the defaults for non nullable fields when there is a SQL Server default already. /Micke |
|
| How to retreive the ID of a new record inserted ? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi ! I'm using a dataset which i fill with the data entered by the users. After, i'm using a DataAdapter.Update to update the dataset. Problem, i need to retreive the ID of the new record. How can i do this ??? Thanks David |
|
| sql statements between tables in a dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| This is a question that i have too but is old. ich have to generate new tables from existing data in an Database. My data are stored in an access database. I want to read a few tables from this database into a dataset object and create in this dataset my new tables. This tables need not to write back to the database. They will only be shown with crystal reports. To create my new tables I want to e... |
|
| How to get NumericPrecision for a column? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Using a DataReader one can easily call GetSchemaTable() and extract VERY rich and complete schema information on all columns in the select statement associated with the command object that created the DataReader. Why is it that this same information does not seem to be available if one uses the (more powerful) DataSet/DataAdapter pair? It seems contradictory to me that this is so, so I must be... |
|
| How can I instal ODBC in .Net pre release (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| First I loaded the dll down from msdn. I installed the System.Data.Odbc.dll in the globl assembly cach and tryed to use these objects. But if I do this a File.IO.Filenotfoundexeption is returned. thank s for help Gottfried |
|
| Calling Scalar UDF (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've searched the help files (RC 3) and a few third party books, and I can't find any VB.NET sample code to call and retrieve the value from a SQL Server 2000 scalar UDF. If anyone knows the right syntax, I'd appreciate your posting it or posting a link to where I might find it. Thanks in advance, Mary |
|
| How to copy tables between databases using ADO.NET? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I want to be able to export some of my database (currently in Access 2000 but eventually in SQL Server and maybe Oracle) tables to an Excel spreadsheet or CSV files. I know how to read the tables in using data adapters and data sets. The thing I can't quite figure out is how to write the new tables out easily. I could iterate through each record and column and write my own insert statement. I have... |
|
| Image Column Data in SQL Server (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a table that contains word and excel files stored in the image column in a SQL 2000 database. The data was stored using VB6 and ADO 2.6. I can successfully read an write these files using VB6 ADO and streams, and in turn use them in their repective applications (Word, Excel, etc.). When I retrieve the data using VB.NET and the filestream object the resulting file is somehow not complete; Wo... |
|
| Image Column Data in SQL Server (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a table that contains word and excel files stored in the image column in a SQL 2000 database. The data was stored using VB6 and ADO 2.6. I can successfully read an write these files using VB6 ADO and streams, and in turn use them in their repective applications (Word, Excel, etc.). When I retrieve the data using VB.NET and the filestream object the resulting file is somehow not complete; Wo... |
|
| Question on GUI Front end concurrency (7 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a middle tier that serves datasets to the front end (gui). I'm wondering how I would go about implementing optimistic style concurrency checks: User 1 gets the data from the middle tier, edits it, but doesn't save yet. User 2 gets data from middle tier, edits it, saves it. User 1 saves data. In this situation, all I can see is a last in win in order to fix this I must use timestamp columns ... |
|
| How to convert a Recordset to a Dataset on the fly? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Any suggestions or code samples are greatly appreciated. Thanks, |
|
| Problem reading from a data set (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello. The problem is the following: We read from a database and put the results in a DataSet object. In another part, we open that DataSet and begin reading the values for a specific column. But when the value is null, we get an error. We have taken a look to the XML version of the DataSet and have found that when the value is null in a certain row, there is no element created for the column in t... |
|
| DataSet persist changes? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Does a dataset perisit it's changes as well as it's current state when you persist it to Cache or Session State? I am unable to get the changes using DataSet.GetChanges() from a DataSet that I have persisited to Cache from an ASP.Net web form. I only get the current state of the DataSet. Anyone successfully doing this that can post an example? Thanks Tim |
|
| Fastest way to retreive identity field from added rows (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, this might be a real easy one, but I don't realy now how to figure it out. I use automatic increment for the id on my tables. I would like a fast and efficient way to get the id back after adding new row(s). This in ado.net without lang lasting connections to the sql server. Greetz, Joris |
|
| DataGrid (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have got a problem with datagrid. When you enter a new record in the datagrid, it creates a new row in the underlying table but does not add to its rows collection till you navigate to a different row (That means the row state property of this row is detached. If you do a compute of sum of a particular column then this row won't be included in the calculation). My problem is I want to This newly... |
|
| hi (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I want to map a dataset to a existing Xml schema and change the one to one mapping of the data element name in the dataset to a different element name in XML..Is this possible????? directly or can anybody give some guidelines Thanks Shyam |
|
| Inserting records into a pair of Master/Detail tables using DataSets (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Situation is you have a Master/Detail relationship between two tables in your database. You create a DataSet that includes both tables. You add a new record to the Master table. You then add new records to the Detail table. Your database is SQL Server and the Primary Key for the Master table is an identity field. How does calling the .Update method of the DataAdapter (and passing my Master/Detail ... |
|
| ADO.NET Experts - HOW TO Resync the current row ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, In ADO 2.6 I use the Resync Command Property of the Recordset object to resync the current row (with a Stored Proc) with the Database. Where is this in ADO.NET ? How to resync a row with the DB under ADO NET ? robert |
|
