Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score SQL ProgramName
Backwards - 6 May 2006 7:48 PM - 5 messages
If i run a SP_who/SP_who2 on my SQL 2000 database to see whos running what programs, i'm finding a lot of these are only showing ".Net SqlClient Data Provider" as the program name rather than for example "My SQL app 1" ...
Score populate many xml file into single dataset
naruphon - 6 May 2006 5:39 PM - 2 messages
I wanted to read two differrent xml files and put into the same dataset but having different table names. I found most of example showing the 'fill' method in dataadapter but no xml file. I will finally create the relationship for joining two tables togeter. Can anyone here help me to ...
Score Error Message
Joe Delphi - 5 May 2006 11:17 PM - 3 messages
Hi,           I am writing an ASP.NET 1.1 application that connects to a Microsoft Access database using the OleDB data controls.    I keep getting this error message: ...
Score update without postback?
cnote828 - 5 May 2006 7:31 PM - 2 messages
I'm just learning ADO.NET.  Can you update a GridView without doing a postback using DOM/javascript? ...
Score Updating multiple records
Bala Nagarajan - 5 May 2006 5:45 PM - 14 messages
Hello,         I want to know an efficient of updating multiple records in a .NET datatable into a Oracle 9i databse without making multiple trips to the database. That is, i want to know if  Oarcle 9i can take the whole set of ...
Score OracleConnection passing different application name
jimmy@age - 5 May 2006 3:08 PM - 6 messages
I'm writing a web service that is executing a stored procedure on an Oracle data server. One of the things that this stored procedure does is to keep track of 'who' is using it by storing some information from the V$SESSION ...
Score Joins on many tables
Klaus Hebsgaard - 5 May 2006 2:42 PM - 4 messages
Hello I have one central table in my db, with a lot of related tables (many to many relations). I need to do some searches, on the central table and it related tables. Previously it has been done by pulling everything up in a dataset and ...
Score system.Transactions
Filip De Backer - 5 May 2006 7:34 AM - 3 messages
Hi everyone, When I want to use the TransactionScope object, I need to include the System.Transactions namespace. But "using System.Transactions;" gives an error: The type or namespace name 'Transactions' does not exist in the namespace 'System' (are you missing an assembly reference?) ...
Score stored procedure select statement with where clause
ss - 5 May 2006 4:07 AM - 5 messages
Hi, Can anybody give me a sample code / sql script showing correc syntax like SELECT * FROM TABLE WHERE FIELD = the value to the where clause , i should be able to pass from the front end it should return a result ...
Score INSERT STORED PROCEDURE
ss - 5 May 2006 4:03 AM - 2 messages
Hi, Can anybody give me a sample code / sql script to write a very good INSERT INTO TABLE STORED PROCEDURE 1. It should take values from the client application which i should be able to pass as parameters 2. it should take exception handling ...
Score Is there a ADO.NET equivalent for ADOX
Sam Malone - 5 May 2006 12:46 AM - 4 messages
I want to get a list of all the tables in a database then for each table, all the columns, their datatypes, then views, indexes, etc. etc. The database may be of any technology - maybe only able to be connected by ...
Score TableAdapter update fail with inconsistent paramter
ad - 4 May 2006 9:05 PM - 2 messages
I use Wizard to build TableAdpater My tableadapter is make by a select command: Select ID, Name form Test It update generate a update command: Update Test set ID=@ID, Name=@Name where ID=@Orginial_ID But when I use a gridview with the TableAdpater and set the DataMemberKeys ...
Score SqlParameter Class
C - 4 May 2006 5:59 PM - 7 messages
When I use below code I get "Parameter count does not match Parameter Value count". Anyone know why I get this? SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@NTUserName", SqlDbType.VarChar); sqlParameters[0].Value = ntUserName; sqlParameters[1] = new SqlParameter("@FlgActive", SqlDbType.Bit); ...
Score Change DataSource at RunTime
Mario-LRJ - 4 May 2006 5:07 PM - 2 messages
I Have some .mdb with the same table structure but different datas. So i want to change at runtime the datasource without change de Form design and the control binding... (if it's possible) is that possible?? I thought to change only the connectionString and Refresh the DataSet, ...
Score Row - BeginEdit and EndEdit -> Why?
Vayse - 4 May 2006 3:30 PM - 6 messages
Hi Why would I use the BeginEdit and EndEdit on a row? The row still updates without them. Is it to just make it easier to roll back via CancelEdit? Thanks Vayse ...
Score SqlBulkCopy and column mappings
Steve - 4 May 2006 2:24 PM - 1 message
Hey, I'm replacing an old C++ DLL in our application that used BCP with an SqlBulkCopy alternative. The problem I’m having is that the column mappings seem to compare the destination column with that of the actual table and fails when there is a ...
Score Timeout in Transaction: Get two times the same data from table ada
Manuel Wagner/progsign - 4 May 2006 1:40 PM - 7 messages
In my function I have to retrieve some data two times. The first time it runs without any problem but on second call I get an timeout error. I´m very confused about this behavior because following code runs on two of ...
Score software services
thuriam.net - 4 May 2006 10:52 AM - 1 message
application support and improvement, Datagrep's offers a compelling alternative to minimize software development costs, and improve the quality of your software solutions and compress software development time. We have been using state-of-the-art Quality Assurance methodologies and practices in all its projects, focusing to deliver ...
Score DBMS for remote database management
Edwin Knoppert - 4 May 2006 7:36 AM - 1 message
I'm looking for something to change the MDB's layout on a website (of ours) .. Would be nice to do that in the browser but some kind of ftp app would do fine as well. ?? ...
Score get DataColumn length
stanley - 4 May 2006 6:01 AM - 4 messages
hi, another ADO problem: how can i get the Column legth as declaredat the Sql data base? for example - char(6)filed, char(10), .., the DataColumn.DataType property bring me the Type System.String for those columns but i need the specific length, ...
Score get table name problem
stanley - 4 May 2006 5:50 AM - 2 messages
hi, i am trying to get the original table name as declared at the sql database but instead of the real name the DataTable.TableName always holds the word "Table". i am using VS 2 and Sql 2003 any ideas? ...
Score [Help] How to modify DataSource of CrystalReport at runtime?
Jati Indrayanto - 4 May 2006 4:57 AM - 1 message
Hello everyone, I am using .NET 2.0 (WinForms - C#) for building my project. I faced a problem while I tried to change datasource of CrystalReport. These are my program snippets       CrystalReport1 obj = new CrystalReport1(); ...
Score Updating datasource reports an error
Georges - 4 May 2006 4:43 AM - 2 messages
Hi! Could someone help? I'm having trouble with the following code. Everythig goes fine till the last line where I'm trying to update the datasource. The program stops executing and displays the message "No value given for one or more required ...
Score How to call an oracle function in C# 2.0?
jens Jensen - 3 May 2006 9:52 PM - 2 messages
Hello, Assum i have an oracle function called ofunction. Can someone tell me how i can call this function assuming it take the parameter in_param of type clob. Any help will be highly appreciated C# .ADO.NET 2.0 ...
Score Check to see DataColumn DataType is Boolean?
Jay Balapa - 3 May 2006 8:33 PM - 10 messages
Hello, Iam trying to do the following- if(myColumn.DataType==typeof(bool)) { } I get the error "Operator == cannot be applied to operands type and object and bool." Is there a workaround? Thanks. jay ...
Score ado.net and sql 2005
Russell Gainford - 3 May 2006 8:10 PM - 6 messages
We have been testing a migration of our application from 2000 to 2005.  All seemed well until last week. Our framework generates a set of business objects and maps them through a DAL to a specific table/column.  In Sql Server (we also support Oracle) our ...
Score problem writing blob to oracle
Achim Kuehn - 3 May 2006 8:07 PM - 2 messages
hi, i have a problem writing a blob to oracle using ado.net. maybe someone can help. here's my code: OleDbConnection con = new OleDbConnection("Provider=msdaora;Data Source=orcl;User Id=******;Password=******;"); try { con.Open(); string save_blob = "INSERT INTO blobtable " ...
Score Transactions with generated DataAdapters
Steffen.Schlachter - 3 May 2006 3:27 PM - 2 messages
Hello, I have generated a DataSet with Visual Studio 2005 by selecting Data -> Add New Data Source ... -> Database etc. from the menu and selected 2 objects (tables) in the Data Source Configuration Wizard. As a result I get an .XSD DataSet file that automatically generated a DataAdapter. ...
Score Table name's in Dataset
Navnit - 3 May 2006 3:19 PM - 4 messages
Hello Guys, I have a proc which returns variable number of tables. I want to do some validations on these tables and dont want to use the index (e.g Dataset.Tables(0)) to refer to the table, I want to use the tablenames ...
Score SMO Table Owner
Scott - 3 May 2006 2:45 PM - 1 message
Using SMO, how to I get a table's ower? I'm scripting out some tables to disk based on the table's name, but I'm getting a clash on the file name because the same table name exists with multiple owners. I want to encorporate the ...
Score dataset merge bug!
Esref DURNA - 3 May 2006 11:35 AM - 8 messages
my query returns 12000 rows I m filling the dataset with increment size 5000 this.MainTableDA.Fill(ds,start,5000,MainViewName); but when I merge two dataset with have 5000 rows it couse an error sometimes it returns shortly 5000 rows 5000 rows not equal to 10,000 rows. sometimes it have 7022 ...
Score Help! Something adds 1 hour to my datetimes! :-S
Pieter Coucke - 3 May 2006 8:28 AM - 4 messages
Hi, For some reason, somewhere in my application 1 hour is added to my dates, depending in which time zone the application is run... Because I don't have a clue where this happens, I posted this to the three ...
Score VS2005: Bug in Rowchanged event during cascade update?
Zach - 3 May 2006 8:18 AM - 1 message
New 'behaviour' in ADO.NET 2.0? In a DataSet, I create a ParentTable with a Primary Key (ParentID). I then create a ChildTable with a Primary Key (ChildID) an a ParentID column. I create a Relation from ChildTable.ParentID to ParentTable.ParentID ...
Score update tabledefinition using dataadapter and datacolumn
Binder - 3 May 2006 8:17 AM - 2 messages
Hi everybody! I'm trying use the datacolumn class to create new columns in a datatable object and submit the new created column to the database (Access 2000). Here's the code:     Sub Main()         Dim oconn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; ...
Score Stored Procedure in SQL Server 2000 ?
ss - 3 May 2006 6:39 AM - 2 messages
Hi, How do I get the all possible stored procedures for a given table in SQL Server  2000 for example like To Insert, To Insert with Parameters, To Update, To Delete, To Do Transaction ie for example to Transfer Some Amount from One Account to ...
Score binding navigator delete modification
fanor - 3 May 2006 3:29 AM - 2 messages
The delete button in a data binding navigator by default will delete de current row in the  binding source.  Can anyone tell me how can I cancel a delete after a click on the button delete?? I want to do this in order to delete the current row just in some cases, for ...
Score Connection string is class module
Peter Afonin - 3 May 2006 2:51 AM - 4 messages
Hello, I put the connection string to the Web.config file, then in Global.asax I'm assigning this string to the application variable: cn = New OracleConnection cn.ConnectionString = AppCrypto.decrypt(ConfigurationSettings.AppSettings("ConnectionString")) Then I use this to variable to connect to the server: ...
Score DataTable.Select - There is no Row at position X -- Exception
Leandro Koiti - 2 May 2006 10:29 PM - 1 message
Hello, I'm facing this problem for a long time from now... I have a datatable that after a set number of rows gets all rows deleted (and archived into a xml) but to not have a clash with id's I set the start ...
Score Creating Strongly Typed Data Set
Vi - 2 May 2006 10:08 PM - 4 messages
Hi, I created a strongly typed data set that contains two tables (Orders and OrdersDetails). The tables have a parent/child relationship. How can I populate both tables based on values returned by a stored procedure in such a way so that the OrderDetails table contains only data for ...
Score Can anyone suggest an easier or better way to skin this cat? Two Select Queries
Hexman - 2 May 2006 8:26 PM - 3 messages
Hi All, Here's my situation.  I have two tables.  Table1 is a 'transaction' table.  Table2 is a 'master' table.  What I want to do is two-fold. First I want to check if there is a match between ProdGrp (t1ProdGrp = ...
Score DataAdapter.Update not actually updating my database
multiformity - 2 May 2006 8:02 PM - 3 messages
So, this is driving me nuts. I have verified that the row that was added or modified in the datatable was indeed added or edited. The update methods return value IS 1, indicating that the row I was after was altered. And for the rest of the execution of the program, the ...
Score What happened to ADO.Net business objects
john conwell - 2 May 2006 5:59 PM - 5 messages
I remember reading in a book on Beta 2 ADO.Net that MS was comming out with their own version of O/R Mapping called Business Objects.  I've been searching around for info on this, but not comming up with anything.  ...
Score Expression Field not working in code.
Irvin McCoy - 2 May 2006 3:30 PM - 3 messages
I have a table with a simple expression column. I'm multiplying quantity * AveLaborRate to come up with total_labor. When I do the 'preview data' it works fine, but when I run my program, all I get is the default 0. All of the ...
Score Deploying Custom .NET Data Provider
Alan Jackson - 2 May 2006 1:32 PM - 2 messages
Hi I've written my own data provider and want to be able to deploy it so that it becomes available generally on the machine. Ideally to be able to add a data connection in visual studio's Server Explorer. ...
Score Problems with Int64 and number in Oracle
Marius Tennes Krogh - 2 May 2006 12:44 PM - 1 message
Hi I have a table in oracle like this: RecID:             NUMBER Description:     VARCHAR2(256) If I try to get a record which has a "big" int64 value it won't return any ...
Score [REPOST] SMO Table Scripts -- Defaults and Binding Rules
Scott - 1 May 2006 11:11 PM - 3 messages
I'm using SMO to script out some tables, but I can't figure out how to include the column default field values or how to bind the user defined rules to the columns. I'm using the options shown below: ...
Score Select Distince Row Filter for dataview
G Hustis - 1 May 2006 9:19 PM - 2 messages
Is there a way to filter the rows of a Data View using the "Select Distinct" SQL statement? If so how do i use it? Thanks. Gary ...
Score Re: Read cvs File Fails
shriop - 1 May 2006 7:08 PM - 3 messages
I'd disagree based on [link] and [link] Where are you getting that this is correct? It also looks like there's ...
Score data reader error...
Brian Henry - 1 May 2006 6:54 PM - 5 messages
I keep getting this error message...System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at ...
Score ADO.NET 2.0 autoincrement problem using SQL 2005 & Web Services
Werner Wopienka - 1 May 2006 4:20 PM - 4 messages
Hi NG! I've tried the sample walkthrough: Creating a Distrubited Application with my database which includes a autoincrement value. My problem is that i don't get the current autoincrement value from the SQL Server when the table is empty. I clicked the save button whiches sends the ...
Score Out of Memory Exception
James - 1 May 2006 4:03 PM - 6 messages
Should be an easy one for you veterans.  Have a DataSet that I'm looping through with a For Each loop.  There are 500+ records in this DataSet.  For each record, I'm creating a PDF by exporting an ActiveReport.  So the basic ...
Score Dataset or datasource control?
Jason James - 1 May 2006 1:24 PM - 1 message
Sorry about the cross posting.  Shouldn't have gone to aspnet. Hi all, Having moved from dotnet V1.1 to V2 I am having some difficulty understanding the new data access methods that seem to be preferred. In V1.1 the dataset did everything that I needed, and now it seems that ...
Score Q: Expressions in DataColumns
G .Net - 1 May 2006 1:19 PM - 3 messages
Hi I've run into a problem when using Expressions in a DataColumn of a DataTable which I'm updating back to the underlying databas. That is, I'm loading data into a DataTable in which I've set some of the DataColumns to ...
Score Multiple Data Source, Same Front End
larocca.mario - 1 May 2006 11:50 AM - 1 message
Hi every one!! i'm a newbe... studing about ado.net ... and i'm climbing the big wall of the .net architecture THE PROJECT: I need to build a library Catalog. The library has a lot of DataBases like "catalog1.mdb" "catalog2.mdb" .... and so on. But all of them have ...
Score hierachical related client side data duplication
Jon Vaughan - 1 May 2006 8:01 AM - 2 messages
I have a hierachical dataset brought back from a sql server stored procedure with a design as follows : StaffID <Staff Columns> AddressID <Address Columns> StaffID_FK PhoneID <Phone Columns> AddressID_FK Im using a disconnected architecture, so when I recieve the dataset , I ...
Score VB Database Book Recommendation?
Tony K - 1 May 2006 12:31 AM - 2 messages
I'm looking for an Advanced Database Programming book strictly dealing with VB 2005.  I'm looking for something specific such as: Customers > Orders > OrderDetails Being able to add an order with details for a new/existing customer. ...
Score SMO Table Scripts -- Defaults and Binding Rules
Scott - 30 Apr 2006 10:41 PM - 1 message
I'm using SMO to script out some tables, but I can't figure out how to include the column default field values or how to bind the user defined rules to the columns. I'm using the options shown below: ...
Score Adding a Web Reference changes DataTypes ???
cc - 30 Apr 2006 6:41 PM - 10 messages
Hi, I having created a simple WebService (in VS 2005) with just one WebMethod as follows : [WebMethod] public DataTable GetProducts() {   DataTable objDataTable = null;   // code for filling up the datatable   return objDataTable; } Then, Adding the WebService as a Web Reference to a Client Application is ...
Score Batch Update + Parent/Child + AutoIncrement/Identity = Yikes!
skavan - 30 Apr 2006 4:24 AM - 2 messages
Hi, I've seen about 2,345 messages on how to submit parent/child rows via ado.net. 1. Make Connection, Grab Tables/DataSet &  Build CommandAdapters 2. Build relations 3. Make Changes 4. Post parent row with event handler (ms Access). ...
Score Null in a Column when there is data
John Mark Howell - 30 Apr 2006 4:06 AM - 2 messages
I'm running .Net v1.1, C# against a SQL Server 2000 db. I've got a stored procedure that returns multiple columns.  All but the first column are numeric(18,6).  I have the standard SqlConnection/SqlCommand/SqlDataAdapter calls to retrieve the data and ...
Score Missing post data in Internet Explorer (bug?)
Ian - 30 Apr 2006 2:03 AM - 2 messages
I had a really weird bug recently. I had a drop-down user control that would not fire the onselectedchange event server-side. After nearly twenty hours of debugging, I finally setup a local proxy (WebScarab, which rocks by the way) and noticed that IE was deciding not to POST ...
Score Re: Read cvs File Fails
rob - 30 Apr 2006 12:12 AM - 1 message
Thanks for the reply. I do not do any special configuration but just what is shown in the original post. Then I read the fields in the following ways: while (reader.Read()) {    for (i = 0; i < reader.FieldCount; i++){ ...
Next »