Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score launching oracle jobs from ado.net
jobs - 3 Feb 2007 10:19 PM - 1 message
perhaps the wrong group, but i think somebody here has tried this. Greetings. I have a vb.net oledb procedure that can schedules an oracle procedure to run and returns to me an oracle job number. It looks like this: ...
Score Problem Opening SQL Database
Ken Ellis - 3 Feb 2007 3:35 PM - 3 messages
I am new to SQL and I am having trouble connecting to a database using SQLServer Express. I have created the database ok and have used VS 2005 to create a drag and drop program (no manual code) to access it, but when I try to access it with the code ...
Score Why does dataset designer prevent expressions for New MyDataset.MyTable?
Richard Coltrane - 3 Feb 2007 2:49 AM - 1 message
Hi there, I have created a dataset with two tables in it.One of those tables has an expression that calcs a percentage based on two other columns. However when i ran my app the UI was displaying (null) for the expression column. After ...
Score Responsive UI as in the Mgmt Studio Queries
shripathikamath - 2 Feb 2007 11:47 PM - 1 message
I have a SQL query, which when executed in Mgmt Studio Query Window takes about 10-12 seconds to complete.  From the time I issue the query, I see an initial lag of about 1 seconds after which the grid ...
Score Can I retrieve a SqlDataReader from a SqlConnection object?
Valerie Hough - 2 Feb 2007 10:12 PM - 2 messages
Is it possible to retrieve an SqlDataReader object (if one exists) from the SqlConnection object or the SqlCommand object with which it is associated? Thanks in advance ...
Score Multiple tab-delimited files without knowing structure
Dave - 2 Feb 2007 8:49 PM - 14 messages
Ok, I have a very special case that I'm trying to work with here. I can think of ways to accomplish it, but none are quick, and none seem remotely like a best practice for this particular task. My goal is to have a DataTable with a set of various types of data, ...
Score OleDB Create Table Script
nkg - 2 Feb 2007 8:32 PM - 1 message
Normally the scripts generated by the scripter class are for SQL Server database. Is it possible to use the Scripter class of SMO to generate create table scripts for an OleDB datasource.? TIA ...
Score Dataview Sort
Charles A. Lackman - 2 Feb 2007 8:30 PM - 7 messages
Hello I have a DataView using the DataViewManager that was created from a Dataset with a Relationship. The Parent View is "Customers" The Child View is "Contacts" I am looking for a way to Sort the ContactsView and perform a Find on it. ...
Score CurrencyManager marks all rows as Modified during navigation
Digital Slug - 2 Feb 2007 6:53 PM - 5 messages
Hello, When I navigate a table in a dataset using CurrencyManager, each row that has been navigated/selected/scrolled-through is marked with a RowState of 'Modified'. Of course, all of the rows are updated even though no row data has changed ...
Score Typed datasets
Chakravarthy - 2 Feb 2007 6:12 PM - 2 messages
Are there any downsides to using a typed dataset if i am using a web service layer and passing the dataset back and forth ? Raj. ...
Score Splitting a Table into 2 Parts.
JohnSouth - 2 Feb 2007 5:45 PM - 3 messages
My ASP.Net site gets a Dataset from a SQL Stored procedure and then binds Table[0] to a Repeater control in order to display the results. The default is 10 per page. Here is the resulting page: [link] ...
Score Import of csv file into dataset problem
twq@hispeed.ch - 2 Feb 2007 5:42 PM - 3 messages
Hello I would like to import a csv file into a dataset, In one column i have a mix of string and numeric values, the problem is that somehow only the numeric values are imported and all string values are imported as null values, what i want is that all values are ...
Score ExecuteScalar requires an open and available Connection. The connection's current state is Open, Exe
hasmukh4u - 2 Feb 2007 2:30 PM - 1 message
I am getting this exception not frequently but once in a while and all database operation gets stopped after this exception. Please suggest either a prevention or cure. Exception(03-08-2006 11:58:27):GetSingleCommand: SELECT permission_config_tbl.permission_value FROM permission_config_tbl ...
Score Get all source tables indexes from SQL Server query
Herman Berger - 2 Feb 2007 1:31 PM - 3 messages
Hi and goodday, We have the following table on a SQL Server 2005: CREATE TABLE [dbo].[CourseItems](     [CourseItemID] [int] IDENTITY(1,1) NOT NULL,     [CourseItem] [varchar](100) NOT NULL,     [CourseID] [int] NULL, ...
Score problem with bindingsource and byte-column
Christopher - 2 Feb 2007 8:28 AM - 2 messages
hi, my problem is as follows: i have a bindingsource and i want to set a filter. my primary key is a GUID and is stored in the database as a byte-value. now i want to set the filter of the bindingsource to that byte-value, ...
Score I want to take List of Datatables with ADODB using VB.Net..
soma.gunasekaran - 2 Feb 2007 6:23 AM - 4 messages
I want to take List of Datatables and Columns with ADODB using VB.Net..... I wrote the code ...but  i getting this Error......        "COMException was Unhandled"     "Operation is not allowed when the object is closed." ...
Score Problem with Transaction Management
Cyril Gupta - 2 Feb 2007 2:11 AM - 2 messages
Hello, I am having a little problem here with concurrent connections to the database. My application has a permanent connection to the database that I am using to Retrieve information. All of my updations are done using transactions and for that I create a new connection to the database (as some of my update ...
Score How do I set the DateTimeMode property when filling a DataTable
Ken Wright - 1 Feb 2007 9:06 PM - 4 messages
[This is a repost of a message from a year ago. I was told that I will receive a response if I post under my MSDN e-mail address.] I am investigating how best to manage UTC timestamps in ADO.Net.  We ...
Score OracleConnection error
David Thielen - 1 Feb 2007 8:08 PM - 8 messages
Hi; I am trying to open an OracleConnection with the connection string: Data Source=Aristotle.jfcom.mil:1526/DEV;Persist Security Info=True;User ID=jam_user;Password=grapes And getting:   open failed: System.Data.OracleClient.OracleException: ORA-06401: NETCMN: invalid driver designator ...
Score Datagridview and combox
Chris - 1 Feb 2007 6:27 PM - 2 messages
HELP! I have a datagridview which I dragged to a C# form so bindings are all taken care of automatically. The grid shows all of my ros fine when I run it. Now I want to change a column to a combobox and bind it to a lookup table. ...
Score FillSchema, Constraints and Stored Procedures
Tom Juergens - 1 Feb 2007 11:21 AM - 6 messages
I'm filling DataTables from a SQL2005 database using either simple "select .... from ..." or stored procedures as the data source. Before I get the data itself I call FillSchema because there are a couple of things I want to do ...
Score Handle large datasets in browser/web like msexcel
jayanttrav - 1 Feb 2007 10:10 AM - 1 message
Hi All, I need to first load and then do heavy editing on a survey data in a grid kind of control in a browser. Here i need to beat 2 things 1. UI responsiveness 2. Bandwidth (before the page times out). I have tried ...
Score Handle large datasets in browser/web liek msexcel
jayanttrav - 1 Feb 2007 10:05 AM - 1 message
Hi All, I need to first load and then do heavy editing on a survey data in a grid kind of control in a browser. Here i need to beat 2 things 1. UI responsiveness 2. Bandwidth (before the page times out). I have tried ...
Score Inserting data into msaccess
kirankumar.Dotnet@gmail.com - 1 Feb 2007 1:33 AM - 1 message
Hi, In Msaccess i have table database name Maagruhu and table name MaaUsers.and fivelds.One is autogenrated column.Id=autogenerated colun and remaining 4 are texts. Now tell me How to insert data into MaaUsers table using asp.net and ...
Score Stored Proc results in DataGridView
BillyRogers - 31 Jan 2007 10:02 PM - 7 messages
I'm trying to get the results of a stored proc (with no input parameters) into a datagridview.  I'm able to get the results into a messagebox but i'm nor sure how to get them into a DataGridView ...
Score Do I need a DataRelation?
hawbsys - 31 Jan 2007 7:05 PM - 2 messages
Dear all. I'm wondering why it's so hard to bind a lookup value from a related table into a textbox on my form. Say I've got two tables, product and productcategory. I'm paging through product information using the bindingnavigator, one product ...
Score Getting double count of updated records
David - 31 Jan 2007 6:36 PM - 4 messages
I have an SQL statement that uses the Command method ExecuteNonQuery and it is returning twice the number of rows (24) actually updated.  When I run the same statement using SQL SELECT I get 12 rows.  Below is my ASP.NET SQL ...
Score Multiple table in dataset query
Microsoft - 31 Jan 2007 5:48 PM - 6 messages
Hi everyone, Before I begin I should point out that I am quite new to programming and VB.net and am using VS2003 with SQLExpress 2005. I have two data tables a staff table and an office table, the linking field ...
Score xmldatadocument.dataset. how to perform a clear on the dataset?
BobC - 31 Jan 2007 5:17 PM - 1 message
xmldatadocument.dataset. Anyone know how to perform a clear on the dataset?  .clear isn't supported.  currently my only alternative is to rebuild it each time, but this would be a process waste. ...
Score run commands before SqlDataSource select?
Sergei Shelukhin - 31 Jan 2007 3:10 PM - 3 messages
Hi. Is there any way to run sql commands on the same connection that SqlDataSource uses to select data before the select? Apaprt from trying to build a multi-command CommandText. Overriding the class would be ok but I can't find the way to do it ...
Score Writing data from a table to another
max - 31 Jan 2007 2:27 PM - 9 messages
Hello, I'm working on an Access db in VS2005. I have a table, called tblPatients, in which I have three columns: PatientID (primary key), PatientName and DoctorName. This table is filled with more than 4.000 records. I load this ...
Score How to update a dataset table row I have previously added ?
Bishman - 31 Jan 2007 10:41 AM - 2 messages
Hi, C# App. VS2005 I have a detail table ordered descending on a field called DetailRowID ie ArrayIndex        Detail RowID 0                       3 ...
Score VB.NET Master Detail DataGridView Control
Adnan Abbasi via DotNetMonster.com - 31 Jan 2007 9:19 AM - 2 messages
Hi, I m a newbie to VB.NET. So, i have problem in doing some tasks like Master/Detail working with DATAGRID VIEW object along with BindNavigator. How can i implement Master / Detail that work with the BindingNavigator? Your advice will be highly appreciated. ...
Score One DataTable class in two datasets - design-time support
Jiøí Neu¾il - 31 Jan 2007 9:11 AM - 6 messages
Hi, I created two datasets in dataset designer in VS 2005. Both of them contain the same datatable. I think, having two classes for one DB datatable is stupid and badly maintaining. So I need manually add DataTable class from ...
Score New row not shown in Access after INSERT
CZuhars - 31 Jan 2007 2:20 AM - 3 messages
Hi, My .NET application writes to an Access 2003 db through OleDb.  I'm using a stored query in Access to insert a new row. The app's C# code sample includes: myCommand.CommandType = CommandType.StoreQuery; myCommand.CommandText = "InsertName"; ...
Score DB connection problem in setup for Microsoft Course 2524
michael sorens - 31 Jan 2007 12:37 AM - 2 messages
I am working through the manual for course 2524 (Developing XML web services using ASP.NET). It is at least 4 years old so hopeless outdated (:-) but I think I can salvage it to still be useful. I actually tried this with just ...
Score DataAdapter with Transaction (.net 1.1)
prof_martin - 31 Jan 2007 12:19 AM - 4 messages
Hi All, I created the following code, it is working, simple update of DataTable, populating data to datatable/dataset is outside/before. Problem: when I tried to use the transaction it doesn't. It prompt error message "Execute requires the command to have a transaction ...
Score ADO .NET 1.1 issue with stored proc params missing but only if culture is Turkish.
gcxmuirhead - 30 Jan 2007 9:33 PM - 2 messages
I have an application that is localized into a number of cultures (Turkish is one) and a number of stored proc calls are failling when the site is run in Turkish but not in any other language, but not all ...
Score How to use DataGridView in VBExpress and SQL Server 2000
BillyRogers - 30 Jan 2007 8:54 PM - 3 messages
I'm using VBExpress and SQL Server 2000 which means that I can't use the wizards/database explorer to do this stuff.  It has to be done in code. I've figured out how to connect to the database and execute a query, but so ...
Score SQL Across Domain Boundary
Geo - 30 Jan 2007 5:36 PM - 1 message
I have a .Net Windows client app that needs to access a SQL server database across a domain boundary. The app uses windows security. The user logs into the app with windows domain credentials while the app uses impersonation. Creating a SQL server account (using SQL security rather than windows ...
Score Returning Cursors using Enterprise Library 2006
manika02 - 30 Jan 2007 4:14 PM - 1 message
Hi, I am using Enterprise Library Jan 2006 to talk to Oracle. I have created a very Simple package with a stored procedure that returns a cursor but I get an error: ORA-06550: wrong number or types of arguments in call to 'PR_GETEVENTS' ...
Score Custom ADO.NET Provider, question about DbCommand.ExecuteReader
Jed Ozone - 30 Jan 2007 2:54 PM - 8 messages
I'm converting over a ADO.NET provider I wrote in 1.1 .NET to 2.0.  I don't understand why the DbCommand.ExecuteReader methods (it's overloaded) is not virtual or abstract.  This method would most likely need to be modified by ...
Score How to find out records number affected?
Ivan Abramov - 30 Jan 2007 9:34 AM - 4 messages
Which was updated by the sql UPDATE instruction. Is there some objects returning the number or I have to do explicit SELECT nevertheless? Thanks in advance. ...
Score Implementing SELECT DISTINCT with DataTable.Select method
Andrea Caldarone - 30 Jan 2007 8:40 AM - 3 messages
Hi all, I've a standard DataTable, is there a way to get an array of value like that one I obtain in SQL Server suppying the SELECT DISTINCT [field] statement? Have I to loop trough the datatable to build the array or is there a simpler ...
Score Enterprise Library 2.0(or 3.0), if i call a oracle procedure with Cursor, thorw Exception.
A.C - 30 Jan 2007 6:42 AM - 1 message
call oracle procedure code:         public string GetProductDetails(int productID)         {             OracleDatabase db = (DatabaseFactory.CreateDatabase()) as OracleDatabase; ...
Score Setting Command Timeout globally in Asp.Net / windows applications...
tom.herz - 30 Jan 2007 2:10 AM - 3 messages
Hi, I've been tasked with the following: We need to add elements to app.config and web.config to be able to specify the CommandTimeout for SQL Commands.  Since there is no option in the connection string to set this property globally, this means ...
Score loadOption.upsert
Carly - 29 Jan 2007 11:19 PM - 2 messages
Hello, Can somebody explain to me in plain language what is the meaning of each value in the LoadOption enumeration? Or some clear articles about DataTable.Load and DataRowVersion. Thanks, Carly ...
Score Concurreny violation on delete in dataset
Flomo Togba Kwele - 29 Jan 2007 8:57 PM - 6 messages
I received the following error: Concurrency violation: the DeleteCommand affected 0 of the expected 1 records. on the Update method of the adapter below:       Me.ClientBindingSource.RemoveCurrent()       Me.Validate()       Me.ClientBindingSource.EndEdit() ...
Score Constraint error on fill of dataset
Flomo Togba Kwele - 29 Jan 2007 8:09 PM - 4 messages
I've defined a dataset containing 3 tables via the DataSource Configuration Wizard. In the UserControl.Load event, I place:       Try           clientAdapter.Fill(DsClient.Client)           personAdapter.Fill(DsClient.Person) ...
Score Joining oracle and SQL Server data
Joel Zinn - 29 Jan 2007 7:56 PM - 2 messages
I am working on a project where we need to join data from a SQL Server db with data from Oracle.  I have searched and have not found any good method to accomplish this. Here is what I have to work with: ...
Score Close not closing...
theinvisibleGhost - 29 Jan 2007 5:25 PM - 8 messages
I've written a small app which has 2 buttons. The 1st button goes away to a directory full of SQL Scripts, and then runs them against the database. The 2nd button has code to do some modifications to the database, ...
Score SQL Server dataset read from database A and write to database B
RWC - 29 Jan 2007 4:24 PM - 3 messages
Hello, What I want I fairly simple (I guess), but I can't work it out. In one application I export data from a SQL Server database to an XML file. I have used the DataSet.WriteXML method to do this. My XML file ...
Score DataGridView for several tabels in a DataSet
atally12 - 29 Jan 2007 3:19 PM - 2 messages
I have a DataSet with two tables in it, with a relation between them. I fill the tables with records programmatically with these commands: System.Data.DataRow newRow = myTable.NewRow(); //give values to each column in the row myTable.Rows.Add(newRow); ...
Score STRANGE PROBLEM
in da club - 29 Jan 2007 11:04 AM - 3 messages
Im getting that error (It is strange. I Run my programme step by step pressing f11. im looping SqlCommand in a while loop. The First step runs but when a enter 2nd step in my loop it returns error ? ) any idea ? ...
Score Problem with ODP.NET on Windows 2000
tal.brown - 29 Jan 2007 8:49 AM - 2 messages
Hi, I wrote a simple application that opens and closes connections to an Oracle DB using the standard ODP.NET API. The ODP version is 2.102.2.20 and the DB version is 9.2.0.7 This application works fine on Windows XP, but when running on Windows ...
Score BindingSource, DataSet and multiple tables not syncing
Flomo Togba Kwele - 28 Jan 2007 11:43 PM - 6 messages
I have defined a dataset using the DataSource Configuration Wizard.  I dropped 3 tables onto the design surface. It looks like this: Tbl1                      Tbl2                        Tbl3 ...
Score Binding/paging issue gridview
Marc Grutte - 28 Jan 2007 10:44 PM - 1 message
Hi I am trying to bind a custom datasource to a gridview whilst paging is enabled. What is missing in this code to make the paging + binding work? thanks M <%@ Page Language="VB" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ...
Score Tableadapter.update not working
Chris - 28 Jan 2007 4:01 PM - 9 messages
Can anyone tell me why this code added automatically by C# does not work? I can add a record on the form or modify a record, but hitting the save button does not save changes back to the database table. I can see the chnages to ...
Score Any way to disable "lazy write" in Jet through ADO.NET?
DennisWelu - 28 Jan 2007 4:55 AM - 7 messages
I don't think there is a way. There seems to be a black hole of info about this unless you are using the older ADO technology. If you know, please share...! Dennis ...
Next »