Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Programmatically modifying the controls in FormView's PagerTemplate
Nathan Sokalski - 13 Jan 2007 9:02 AM - 4 messages
I am trying to create a FormView controls in which I access and modify the the controls in the PagerTemplate programmatically. However, I continue to recieve the following error: Object reference not set to an instance of an object. I am attempting to access the controls in my PagerTemplate using the ...
Score Validating an XML file
Jack White - 13 Jan 2007 1:00 AM - 15 messages
Hi there, I've created a strongly-typed "DataSet" using VS. If I save the data via "DataSet.WriteXml()" and later prompt my users for the name of the file in order to read it back in again (using "DataSet.ReadXml()"), how do I ...
Score Does TableAdaper.Fill() call Connection.Close() internally?
Ð - 13 Jan 2007 12:10 AM - 3 messages
The Microsoft online help is full of TableAdapter examples like     customersTableAdapter1.Fill(northwindDataSet1.Customers); I would expect the next line to be something like     customersTableAdapter1.Connection.Close(); But I haven't seen that in the code samples, and VS doesn't generate it. ...
Score ReadRepeatable
jackson - 12 Jan 2007 10:51 PM - 3 messages
..Net v1.1 Can someone tell me if I have ReadRepeatable IsolationLevel right? Say I begin a transaction with ReadRepeatable. I select a row from table FRUIT. Another user tries to UPDATE the same row in table FRUIT... Are they blocked until I end the transaction? ...
Score =?UTF-8?B?VGVzdCBNZXNzYWdl?= from Indy
null@nowhere.com - 12 Jan 2007 9:59 PM - 1 message
This is a test message. ...
Score =?UTF-8?B?VGVzdCBNZXNzYWdl?= from Indy
null@nowhere.com - 12 Jan 2007 9:58 PM - 1 message
This is a test message. ...
Score Error using OracleDataReader - please help
Philip - 12 Jan 2007 5:53 PM - 2 messages
Hi, I retrieve a list of arguments for a stored procedure from ORACLE using OracleDataAdapter. These populate a listbox on a form. Then when the user selects the argument from the listbox, I want to allow the user to set a value for the selected argument. ...
Score know if a datatable is being schemafilles but not ever filles
Andrea Caldarone - 12 Jan 2007 2:41 PM - 4 messages
Hi all, in my program I initialize a lot of datatable (member of the same dataset) with the .FillSchema method of the adapter at the startup. After when a user trough the guy requests a such data, I populate the datatable with the .Fill ...
Score Help with OLEDB Parameters & ORACLE REF CURSOR (MS Data Provider)
Philip - 12 Jan 2007 2:04 PM - 2 messages
Hi, I am building an application that will retrieve a list of stored procedures for a schema, with their parameters. This is basically to enable us to test the stored procedures and performance. First I query the ORACLE database 'user_arguments' table to get a list of ...
Score ExecuteNonQuery is returning -1 though the record has been inserte
Hari - 12 Jan 2007 12:52 PM - 3 messages
Hi, I am new to ADO.NET. I am develpoing an application to manage employee data. I am using Microsoft Enterprised Library Dlls to connect to the database and execute the stored procedure. Currently I am having  problem in executing in Stored Procedure used to ...
Score Copying from one db into another
John - 12 Jan 2007 12:36 PM - 6 messages
Hi I am trying to copy data from one db into another. Thanks for everyone who suggested ways to do that. After some more research I have come up with the below simple looking way. My question in, is it supposed to work this way ...
Score dataset.WriteXML to Spreadsheet ML
Rick - 12 Jan 2007 12:14 PM - 1 message
I want to use the WriteXML method to feed an XSLT stylesheet and output Spreadsheet ML. Does someone know if there is an XSLT available to use as a prototype? Regards, Rick ...
Score Inserting from one db into another
John - 12 Jan 2007 3:36 AM - 12 messages
Hi I have open connection to two separate databases. I now need to insert records from a table in one db into a table in second db. How can I go about doing it? Thanks Regards ...
Score leave connections open for how long?
Andrew Robinson - 11 Jan 2007 11:01 PM - 10 messages
I recently got into a discussion with a coworker about just how long to leave a connection open. I have always opened as late as I can and closed at the earliest possible point in time. using (SqlConnection cn = new SqlConnection(DataConnection)) ...
Score DbType ? to go with Oracle Provider Ref Cursor
Doyle - 11 Jan 2007 10:04 PM - 4 messages
What DbType to I use so that when the provider is Oracle I will get back the ole Ref Cursor ? my Parameter Construction method is below: public DbParameter GetParameter(string argParameterName, ParameterDirection direction, DbType argDbType, int argSize, object argValue, bool ...
Score Concurrency violation
HGJ - 11 Jan 2007 10:03 PM - 6 messages
I change the value in the Datagridview and then update using Data adapter update method and I am getting Message="Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.” I am the only user in the SQL database. ...
Score Oracle Client?
dinoo - 11 Jan 2007 8:45 PM - 7 messages
I give a brief idea on what is the problem - One of our clients wants to upgrade from Oracle 9i client to Oracle 10g. We are part of team where we are supporting the .Net applications. We have a existing web server in QC lab where Oracle Client 9i has ben already ...
Score Help on displaying combobox items
max - 11 Jan 2007 6:00 PM - 10 messages
Hello, I have a VS2005 framework and ado.net. I have an access db with two tables: 1) Patients; 2) Doctors. The 'Patients table is already filled by a long list of records (coming from an old access db) in 3 columns: ID, Name, Doctorname (for that patient); ...
Score MSDatasetGenerator schemaLocation problems.
Sean Abernathy - 11 Jan 2007 5:52 PM - 1 message
I'm in the process of converting a number of Visual Studio 2003 projects to Visual Studio 2005 SP1.  We have .xsd files that use MSDatasetGenerator to generated typed DataSet's. Upon converting to 2005 DataSet generation of all ...
Score Listing Sql Server Instances
Cleyton - 11 Jan 2007 4:15 PM - 1 message
I have an application that lists Sql instances on the network. In my case, I just use MSDE instances listed. The code is: DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient"); if (factory.CanCreateDataSourceEnumerator) {                 DataRowCollection dr = ...
Score Restoring DataColumn.AutoIncrement value
Mario Vázquez - 11 Jan 2007 11:37 AM - 3 messages
Hi All, I'm deriving the AutoIncrement, AutoIncrementSeed and AutoIncrementStep properties of DataColumn objects by inspecting the underlying properties of the source tables in Sql-Server. When I create and empty row of that table, ado.net generates a new identity ...
Score Accessing the controls in the PagerTemplate when using FormView
Nathan Sokalski - 11 Jan 2007 6:19 AM - 1 message
I am using a FormView control, and want to access the controls I have created in the PagerTemplate. Right now, I am doing this using the following method: CType(Me.FormViewID.FindControl("PagerTemplateControlID"), LinkButton) However, this gives me the following error: ...
Score Bizarre slow query problem (again)
wizofaus - 11 Jan 2007 5:44 AM - 22 messages
I previously posted about a problem where it seemed that changing the case of the word "BY" in a SELECT query was causing it to run much much faster. Now I've hit the same thing again, where basically almost any change I ...
Score oledbconnection v sqlconnection
JRD - 11 Jan 2007 1:05 AM - 3 messages
Greetings, I wrote a wrapper for the ado.net using oledb to make connection to the database. At the time the purpose of this class was so that I could use it against any kind of database type. However, I was told recently that ...
Score Dataset from datasource returns no rows
kwele - 10 Jan 2007 11:59 PM - 4 messages
I set up a dataset from Add New Data Source ... on the Data Sources tab. I selected two tables with a parent/child relationship. The wizard created the .xsd file. I then dragged the parent datasource over to the forms designer, where it created a bindingsource, ...
Score DataList Not Displaying
scottf35 - 10 Jan 2007 9:02 PM - 1 message
Hi, I have recently installed asp.net v1.1.4322 on a Windows Server 2000 so I could place my new asp.net website on our server. The server is a production server and has several websites already on it (before the install of asp.net). ...
Score How do I alter the database create permissions?
ornit_sagy - 10 Jan 2007 8:01 PM - 2 messages
Hello again, To continue my previous question, I'm working in a very strict environment in a school's computer lab, and I have to ask the system manager (who doesn't know anything about .net and sqlexperss) for any change. I don't really know the environment (except that it uses Novel) and I don't have much experience with sqlexpress my self. What should I ask for in order to solve the "CREATE DATABASE permission denied in database 'master'" problem? ...
Score Detach sql files on closing?
mtczx232 - 10 Jan 2007 6:29 PM - 2 messages
Detach sql files on closing? a)I have App that connect directly to SQL files (*.mdf). I realize that this connection Attach the files to SQL server. How I can force Detach mdf on closing program? b)also I try add to project SQL DataBase but I got error that I not ...
Score vb.Net 2005 call to Teradata stored proc
marcmc - 10 Jan 2007 5:21 PM - 2 messages
Hey, The below function won't build for me at the two Statements below attempting to add parameters to a dynamic stored procedure call. I just cannot find the correct syntax using Teradata. My procedure takes 3 parameters: (IN v_pWho VARCHAR(20), IN v_i_run_job_id ...
Score how to socket problem error
Krishna - 10 Jan 2007 12:20 PM - 3 messages
Hi,    I develop one application using .net and mysql 5.0.The following error message diplayed . A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no ...
Score Change SQL Servers for Application
AMP - 10 Jan 2007 9:44 AM - 5 messages
I have a small Visual basic.net 2005 application that needs to get data from SQL servers How can I make the dataset that uses My.setting.connection, use differant servers ie My Setting.Connection="Data Source=SRV1;Initial Catalog=DB1;Integrated ...
Score Advanced Select into statement in Access
khushal999p - 10 Jan 2007 8:32 AM - 2 messages
How to do this in MS Access 2000 Select Companyname,Counter = IDENTITY(int, 1, 1) into Custmoers2 from customers ...
Score Detach sql files on closing?
mtczx232 - 10 Jan 2007 7:12 AM - 2 messages
Detach sql files on closing? a)I have App that connect directly to SQL files (*.mdf). I realize that this connection Attach the files to SQL server. How I can force Detach mdf on closing program? b)also I try add to project SQL DataBase but I got error that I not ...
Score Newbie Missing Something with Access DB Update Using VB .NET
pooba53 - 10 Jan 2007 2:50 AM - 9 messages
I have a VB .NET application that is communicating properly with an Access DB. I have a slew of textbox controls bound to a dataset and when the application launches, the fields are correctly populated. If someone changes a value in one of the text boxes, I need to have a ...
Score Re: Datagrid Column Width
AmblogoBu - 9 Jan 2007 10:44 PM - 1 message
Now I've found free experienceh  'free gay web cam' ([link]) and additional there9 'free live web cam site' ([link]) ...
Score Accessing deleted rows problem
Rastko Soskic - 9 Jan 2007 9:56 PM - 3 messages
Hi everyone! As stated in subject I have problem with accessing deleted rows within dataset, that is, deleted rows within table contained in dataset. Dataset is strongly typed (generated by designer). I need to say that I've done this by following tips in MSDN. ...
Score Detach sql files on closing?
mtczx232 - 9 Jan 2007 9:01 PM - 2 messages
a)I have App that connect directly to SQL files (*.mdf). I realize that this connection Attach the files to SQL server. How I can force Detach mdf on closing program? b)also I try add to project SQL DataBase but I got error that I not ...
Score Correct error handling in DAL
BigStef - 9 Jan 2007 8:23 PM - 1 message
Hi people,    I've been struggling over the past weeks to get rid of my old VB6 habits of using error handling everywhere and I think I'm catching up quite fast! I have a question though... I have read many Best Practices topics ...
Score Correct error handling in DAL
BigStef - 9 Jan 2007 7:44 PM - 2 messages
Hi people,    I've been struggling over the past weeks to get rid of my old VB6 habits of using error handling everywhere and I think I'm catching up quite fast! I have a question though... I have read many Best Practices topics ...
Score Oracle stored procedure vs. functions? is not a procedure or is undefined
jobs - 9 Jan 2007 7:23 PM - 2 messages
PLS-00221: PLS-00221: is not a procedure or is undefined FUNCTIONS VS. STORED PROCEDURES - ADO.NET TO ORACLE FUNCTION I have a very simple oracle function I'm trying to call from ado.net. The code works fine for a stored procedure but I get the error ...
Score Adding rows to a dataset where the primary key is type System.Guid
michael - 9 Jan 2007 5:06 PM - 8 messages
So, I'm working with VS 2005 (VB) and SQL Server(both 2000 and 2005). A table in the SQL Server db has a column, which is the primary key, of type uniqueidentifier. The RowGuid attribute is "yes" and the default value is ...
Score Newbie: Oracle MembershipProvider Implementation
Alfred Rakgole - 9 Jan 2007 2:47 PM - 1 message
Hi, I'm looking for an implementation/example of  custom MembershipProvider for Oracle(9i and 10G)  to use in logon controls. Also tables to be created in the schema. Regards Mashao tharo***@gmail.com ...
Score Visual Studio 2005
marcmc - 9 Jan 2007 1:50 PM - 3 messages
Where is the auto tab on VS 2005 during debug to show you things like the cn.state, dtr state etc? I cannot find it. Also, vb.net 2005 is saying that i have a Null Reference Exception on the ...
Score Problems call DataAdapter.Update and Concurrency
Steve Lloyd - 9 Jan 2007 11:07 AM - 11 messages
Hi all, I wonder if anyone can explain what is happening here? I have a dataadapter that I am using to correlate the changes in an SQL Table to a DataTable.  I create a new DataRow then call .Update and ...
Score Invalid postback or callback argument error
Nathan Sokalski - 9 Jan 2007 8:51 AM - 3 messages
I have a DataList in which the ItemTemplate contains two Button controls that use EventBubbling. When I click either of them I receive the following error: Server Error in '/' Application. -------------------------------------------------------------------------------- Invalid postback or callback argument.  Event validation is enabled using ...
Score Adapter.Update() problem with Access Database relationship
divisortheory - 9 Jan 2007 5:46 AM - 2 messages
I have two tables.  First table is like this: TABLE PrimaryTable ----Guid PrimaryID  (Primary Key) ----string PrimaryName ----int PrimaryValue Second table is like this: TABLE SecondaryTable ----Guid SecondaryID ----Guid PrimaryID There is a relationship defined between PrimaryTable.PrimaryID and ...
Score Can't Fix Run-Time Error
Jonathan Wood - 9 Jan 2007 5:32 AM - 2 messages
Greetings, Attached is part of a Web site I'm working on. (I've attached it to retain formatting.) When it runs I get the following error on the line that says ERROR HERE!: "There is already an open DataReader associated with this Command which must ...
Score Fresh installation
Stig_Kulvedrøsten - 8 Jan 2007 9:38 PM - 2 messages
I've just installed Windows Vista with Visual Studio.Net 2005 and SQL Server Express Advanced Edition. When installation of vs.net and sql server was finished I tried to run one of my sites right away. This is the error I got: ...
Score Any solution for error message "Could not attach file 'App_Data\Database.mdf' as database 'Database'
ornit_sagy - 8 Jan 2007 8:34 PM - 1 message
Hello, I'm trying to connect to Database.mdf from an asp.net file and I get the following error message:    Could not attach file 'App_Data\Database.mdf' as database 'Database'.    CREATE DATABASE permission denied in database 'master' ...
Score Any solution for error message "Could not attach file 'App_Data\Database.mdf' as database 'Database
ornit_sagy - 8 Jan 2007 8:04 PM - 2 messages
Hello, I'm trying to connect to Database.mdf from an asp.net file and I get the following error message:    Could not attach file 'App_Data\Database.mdf' as database 'Database'.    CREATE DATABASE permission denied in database 'master' ...
Score Connection timeout
DCraig - 8 Jan 2007 6:34 PM - 2 messages
I'm having a problem with one of my forms (using .Net 03 EE, SQL 2K Standard, XP client and Windows Server03).  After editing and deleting a few records, the form starts timing out, giving me the message; "Timeout expired.  The timeout period elapsed prior to obtaining a ...
Score Getting notification from SQL 2005
Andrea Caldarone - 8 Jan 2007 5:03 PM - 6 messages
Hi all, I'me using VB 2003 with framework 1.1, and SQL Server 2005 Express as data provider. Is there a way to get notification from SQL Server 2005? I try to explain better, let's consider a canonical client - server scenario: one ...
Score Memory Leak in DataSets
Gunnar Valur - 8 Jan 2007 4:15 PM - 9 messages
Hi, I am using VB 2005 and have been having problems with memory usage in services.  After some investigation I think I have found that DataSets leak memory! So I created a simple test 1) Create a new Windows Application ...
Score net fw 3.0
John - 8 Jan 2007 12:41 PM - 8 messages
Hi What is the significance of net framework 3.0 for vs 2005 users? Thanks Regards ...
Score SqlCacheDependency - Cache Invalidation wihout result set modification
mrashidsaleem - 8 Jan 2007 12:02 PM - 3 messages
Using the SQL 2005 "query notification" caching mechanism, I am caching three columns (UserId, UserName, Password) of a table called UserInfo in my web application cache. However, the cache gets invalidated (and needs to be re-loaded) when another column LastUpdateDateTime of the ...
Score AS 400
MaryA - 8 Jan 2007 11:43 AM - 4 messages
I am trying to connect to as400 using oledbconnection the connection is opened but when i try to retreive data i get an error message         cn = New OleDb.OleDbConnection(StrAS400)         cn.Open() ...
Score Typed Dataset and transactions in ADO.NET 2.0
STeW - 8 Jan 2007 11:04 AM - 4 messages
Hi all, I have a general question about typed datased and transaction. Do you anybody know the best way how to manage transaction typed dataset? Generaly, when I create dataset and INSERT/UPDATE/DELETE command in a table adapter, there are connections on commands which are not in transaction. ...
Score how can i get notification from mfc Activex controle
pallaw - 8 Jan 2007 9:53 AM - 1 message
Hi All, Can anyone tell me how can i get notification from MFC Activex controle. I am using Web Application as the client for this control.I want some notification from my control on my web server. Thanks pallaw ...
Score Intermittent TransactionScope communication failures
Hans Malherbe - 8 Jan 2007 8:40 AM - 1 message
Dagsê I am having trouble stabilizing the behaviour of TransactionScope. We get intermittent exceptions with the message "Communication with the underlying transaction manager has failed". This happens in both the development and the staging environments. Infrastructure: Development consists of a virtual machine with Windows XP SP2 (VMWare ...
Score Have a change between v 1.1 to 2.0 about Return identity with CommandBuilder
mtczx232 - 8 Jan 2007 8:26 AM - 1 message
I have mistake? I remember that in ado.net 1.1 when I Fill empty (with no schema) Datatable, and use with CommandBuilder to set the Insert and other command, it's add to InsertCommand @@identity to obtain the new ...
Score What's My Password?
Jonathan Wood - 8 Jan 2007 4:07 AM - 42 messages
Grrr... I've spent the last several hours trying to learn ADO.NET. Specifically, the database connection stuff. I finally managed to create a database and enter some data within the VS IDE. I have several ADO.NET books but not one could tell me how to set up my ...
Score Complex queries on Local data objects?
divisortheory - 8 Jan 2007 12:43 AM - 6 messages
I'm using typed datasets and in my application I, for the most part, keep local copies of everything in the database in DataTables.  So at any given time my local tables always have at least as much (usually ...
Score OT: Looking for a good, free and simple XHTML editor
Tomasz - 8 Jan 2007 12:21 AM - 2 messages
Hi Everybody! I am looking for some good, free and *simple* xml/xhtml editor I could recommend my students. Yes, I know about Visual Web Developer 2005 Express Edition, but I mean *simple*. I teach an introductory class and most of my ...
Score Correct way of using OleDbAdapter and DataSet to update Access database?
JoWilliam - 7 Jan 2007 9:01 PM - 7 messages
Hi, I've written a VB .Net program (written in Visual Studio .Net 2003) which scrapes data from a web site and stores it in an Access database.  The database has 1 table with 11 columns, one of which is the primary key (not ...
Score Geting Identity back from SS SP
GaryDean - 7 Jan 2007 7:13 PM - 5 messages
I'm trying to get Identity back from a stored procedure in SQL Server.  When I execute the SP in Management Studio @NewID is returned in the first row/first columm.  but when I run the code below, executescaler returns ...
Score next vs?
John - 7 Jan 2007 6:13 PM - 12 messages
Hi When is next vs due? Many Thanks Regards ...
Score What are OleDbParameter names with 'Original_' prefix?
JoWilliam - 7 Jan 2007 3:08 PM - 6 messages
Hi, I'm new to all this OleDb stuff.  I'm using VB in Visual Studio .Net 2003. The Data Adapter wizard for the OleDbDataAdapter control generates the following OleDbUpdateCommand object for the query "SELECT Reference, Status, DateCreated FROM Questions": ...
Score Musing about drag-drop parameter generation
Earl - 7 Jan 2007 11:57 AM - 3 messages
It's fascinating the amount of parameters that are now generated by the drag-drop SqlDataAdapters. Doesn't this trouble anyone the amount of data being sent back and forth for a simple insert/update/delete? And that this is apparently the recommended Microsoft approach? ...
Next »