| ADO.NET Bug? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| hi all I posted this question here a while ago, but no one can answer it. don't know if all the MVP are too busy answering some other questions. anyway, I have this *bug* in my ado.net app, I have data fields from oracle database in a winform binded to all kind of controls, but I am not fill the dataset will all records (think we are not supposed to do that, at least not for a hundreds and hundrea... |
|
| Saving ANSI Character into SQL Server's varchar field (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to type some chinese character into a datagrid then update them into SQL server using SQLDataAdapter, however it always store??? in the database. As my data type in SQL'server is in Varchar format (i cannot change it into nvarchar format), what should i do ? Thx a lot |
|
| how to convert an ado recordset xml format to an ado.net dataset xml (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a visual basic client using soap tool kit 3 using consuming vb.net web service . I wanted to know that at the server side when i receive an ado recordset xml format string , how can i convert to ado.net dataset xml format to load it to a dataset ... i.e converting an ado recordset xml format to an ado.net dataset thanks |
|
| last record (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| how do i get the last record in a dataset in ado i would use rs.movelast, now how do i do that in ado.net? |
|
| Send mail (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Language Programming: ASP.NET with VB.NET My problem it's not how to send a e mail, but I would like to have (and hoe to do it) two things. The first is when I click in my SEND button, that opens a window (with fixed widht and height) where it's put the fields: Form: me@home.com To: me@work.com It's look strange that I don't want to have the body field, right? Well.... that is the second thing tha... |
|
| Error collection (Sybase) (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I'm currently working on a project that uses ASE 12 as its DBMS. In the office I've installed ASE 12.5 Developer Edition, and at home I've installed ASE 12.5.1 Developer Edition. Also, I'm using Oledb classes from .NET Framework 1.1. My problem is when Sybase returns any error, for example trying to delete a record that is referencied at others tables (FK). When I'm at work, my application ... |
|
| Using the dataSet.Merge method (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hiya I am passing a dataset to a middle tier object, which in turn updates the data source and retrieves an Identity value from the database, replacing the ID value in my dataset with the correct value. When the function returns to the UI layer, the dataset that I passed to the middle function has the updated ID, whereas the dataset on the UI layer still has the original value. I tried the merge t... |
|
| A well know bug with apparently no known solution :-( (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I sporadically get the following problem when running asp.net applications with the Data Application Block: Configuration Error An error occurred during the processing of a configuration file required to service this request. Access is denied: 'Microsoft.ApplicationBlocks.Data'. Source Error: Line 256: add assembly "System.EnterpriseServices, Version 1.0.5000.0, Culture neutral, PublicKeyT... |
|
| Returning two tables at once (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi chaps, I was wondering if it is possible to make execute one stored procedure and get more than one table back. I particular, what I'm looking to do is get a some info from a primary table, and then all the related info from a foreign table. I'd like to put these two tables into a dataset. I'm just wondering if I have to make two seperate calls to stored procedures to get my two tables, or whet... |
|
| SqlClient Severity Error Problem (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I posted an a problem in the newsgroup on 26 Feb 2004 here is the link http://groups.google.com/groups?hl en&lr &ie UTF 8&oe UTF 8&threadm urpv7dY%24DHA.2336%40TK2MSFTNGP11.phx.gbl&rnum 1&prev /groups%3Fq%3Ddotnet%2520sqlclient%2520severity%26hl%3Den%26lr%3D%26ie%3DUTF 8%26oe%3DUTF 8%26sa%3DN%26tab%3Dwg Microsoft has confirmed this is a bug and they have fixed it in Whidbey but they refuse to fix ... |
|
| Parameters and the IN operator? (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Is there a way to use an input parameter to populate an IN operator (ie. "IN (val1, val2, val3)") in a Where clause? I have a data adapter whose SelectCommand reads: "Select contact id, firstname, lastname from Contact where contact id in ( val1 , val2 , ...)" I need to fill the list of values for the IN operator from a list of values that I have retrieved in my code earleir. The goal here is to u... |
|
| How to persist a COMPUTED column in a data table? (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello... I have two columns in a datatable. column calcCol1 and Col1. When I loop through the records to copy data from the computed column to the original column it gives an error saying that there is no data. (although I know there is). I loop as follows dim dr as datarow for each row in dtable dr("Col1") dr("CalcCol1") next what I am doing wrong? thanks in advance. Newsgroups brought to you cou... |
|
| OFF TOPIC: Telecommunications and T1 (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi there buddies; I got a T1 at home. I want to accept inbound calls from any phone and use the T1 to record conversation in the PC. Do you know any resource about T1's, how to install'em, and so on. Thanks |
|
| REF CURSOR returns no rows (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| Dear All, I am having a really strange problem with reading cursors from an Oracle 9i database for a "particular" procedure. My DataReader does not contain any rows after I execute the command object. I have tried cmd.ExecuteReader and x DataAdaptor(cmd) x.Fill(myDataSet) I execute the SELECT statement in TOAD/ SQL PLUS and that works fine. The SELECT statement is a bit complex with lots of outer ... |
|
| how to convertan ado recordset xml format to an ado.net dataset xml (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a visual basic client using soap tool kit 3 using consuming vb.net web service . I wanted to know that at the server side when i receive an ado recordset xml format string , how can i convert to ado.net dataset xml format to load it to a dataset ... i.e converting an ado recordset xml format to an ado.net dataset thanks |
|
| commas in text fields to save as a numeric value (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a financial application. When I populate text boxes with financial numbers I don't group the digits via a comma. For example. I'll use 500000 instead of 500,000. Obviously the latter is easier to read by our accounting guys. The problem is when saving 500,000. It will save 500 because I save the Val(txtTextBox.Text) value. Val cuts off the number at the first non numeric character. Is there... |
|
| sql server alias for clients (9 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have some programs (written in vb6 & vb.net) that connect to sql server on a W2k machine. I should change the machine (moving to a new one) but for a few days the two machine will co exist so I cannot give to the new machine the name of the old one. I would like to have the programs accessing sql with a dummy alias (ideally set in the dns or in Active Directory) so that I would be able to move s... |
|
| Restoring DB made ADO.NET not connect? (8 replies) |
| microsoft.public.dotnet.framework.adonet |
| I Restored a MSDE database with a prior backup. Now my program won't connect to it. I use SQL Security. Any ideas? Thanks, Shane |
|
| Adding Data to Junction Table through Datasets (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Everyone, I am quite inexperienced in databses so I just wanna ask that how can we add data to junction table after adding data to the Parent Tables. I have Three Tables: Topics TopicsQuestions Questions topicId TopicId qid topicName Qid Questions Difficulty There is a many to many relationship between these tables. I know how to add data to the two primary tables but I don't know how the data ... |
|
| Keep generated DataSet internal (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I've got a C# strongly typed DataSet that is being auto generated from an XSD schema I've created. I see that I can change the access modifier for the generated DataSet class to "internal". However, it gets set back to :public" any time I alter my schema (causing the DataSet to be regenerated). Is there any setting that I can tweak so that the generated DataSet will always be internal by default? ... |
|
| Enumerate SQL server list? (7 replies) |
| microsoft.public.dotnet.framework.adonet |
| Anyone know how to enumerate the SQL Servers on a network using .Net? I can do this with VB6, but howso in .Net? |
|
| Column value? (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| How do you retrieve the value of a column in the current datarow object in a dataset? |
|
| OT- Deklarit & ORM Projects (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| A few months ago, a good friend of mine starting using LLBL gen to generate data access code. He's are very hard core ADO.NET developer so I was kind of surprised when he told me he really liked it. I decided to give the whole ORM thing a try and found that it was surprisingly good. However, LLBL gen didn't support SQL CE and I found that Deklarit did so I gave it a try. Deklarit is a lot more tha... |
|
| How to save a datarow into dataset? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I wanna save changes made to dataset liker adding a datarow by dr ds.tables(0).newrow and then setting thev value for each column of the table. But I couldn't save those to dataset and eventually to Original database (Like SQL,Excel etc.) Please help |
|
| Column Expressions (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have a dataset with 2 tables. The first table has 3 columns, the second 3 columns. Table Name Column Name Column Type T1 C1 String C2 String C3 String T2 C1 String C2 String C3 String the dataset has a relation, named R1, defined between the tables. The parent table is T1. The child Table is T2. The parent columns are C1 and C2. The child Columns are C1 and C2. Table T2 has a fourth column added... |
|
