Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score DataTable Column Index for Given ColumnName
dchman - 24 Feb 2007 4:17 PM - 7 messages
I have a datatable that is created dynamically (in an asp.net 2003 application), so various columns may or may not be present.  Consequently, although the column names may be constant, the column indexes are not.  I would like to retrieve the column index for a given column name, but haven't ...
Score SQLDatasource not using SelectCommand from _Selecting Event.
John Kotuby - 24 Feb 2007 3:11 PM - 2 messages
Hello again... I am cross-posting to the ADO newgroup because nobody in the ASPNET group had a comment. Note, since my first post I have tried using MS Update to install VS2005 SP1 but the automatic download and install failed. ...
Score ASP.NET Repeater Control - Hide a <div> ???
sfx_pete - 24 Feb 2007 11:23 AM - 3 messages
Hi All, In my repeater control I have a <div> that is set to run at the server with the intention that I can hide it based on certain criteria. I'm able to do this OK but I'm not sure I have the most efficent ...
Score Re: New features in ADO.NET
Andy - 23 Feb 2007 9:43 PM - 1 message
Ya, I realized that right after I hit send.  Oh well. ...
Score Local cubes connection...
GB - 23 Feb 2007 9:38 PM - 1 message
Hello, I have created 3 local cubes which resided in the same .cub file. How can I make ADOMD connection to all 3 cubes at the same time in my client application (C#)? The problem is that Initial Catalog (database name) in connection string in ...
Score System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Nick nkw - 23 Feb 2007 7:55 PM - 4 messages
I already following the steps in: [link] But I still get the error. I found it works when using VS.Net internal web server. It use Domain\MachineName$ to connect SQL Server after ...
Score C# and Datagridview
Chris - 23 Feb 2007 6:33 PM - 1 message
I have a datagrid view with two combobox's. These are populated by lookup tables. I need one column to change what is loaded into the other. How do I do this on code? I don't thnk this method will work: ...
Score Yet another "Concurrency violation: the UpdateCommand affected 0 records" exception
Santi - 23 Feb 2007 5:26 PM - 3 messages
Hi friends, In an application with a single user - single computer, with InsertCommand and UpdateCommand created by hand, and a FoxPro database accessed with OleDB, when following this steps I get the exception: 1. Insert a row in the dataset OK ...
Score System.Data.Common.DbCommand v/s Oracle.OracleAccess.Client.OracleCommand
Kuldeep - 23 Feb 2007 12:43 PM - 2 messages
Hi All, Platform: Visual Studio 2005 Programming Language: C#.NET Technology: ASP.NET [though it doesnot matter!] I am here trying to integrate System.Data.Common.DbCommand with Oracle.OracleAccess.Client.OracleCommand for an ExecuteReader method.. While doing this, I get this error message: ...
Score Does MARS use multiple connections behind the scenes?
Simon Harvey - 23 Feb 2007 11:14 AM - 2 messages
Hi all, Quick question. I would like to use MARS to avoid lots of additional connections being opened in a certain area of code that I have (a deep load style scenario) As I understand it, it allows you to have several open data readers on ...
Score New features in ADO.NET
Tony - 23 Feb 2007 10:57 AM - 2 messages
I want to know how many differences is between ADO.NET in Visual Studio 2003 and ADO.NET in Visual Studio 2005. I work with asp.net aplications. Will my applications work in VS2005? I want to know, does VS 2005 (ado.net 2.0) have only NEW features or have ...
Score qst
sunita - 23 Feb 2007 4:35 AM - 2 messages
i want to get difference between two dates interms of days From [link] Posted via DevelopmentNow.com Groups [link] ...
Score Computed Columns
Aamir Mahmood - 23 Feb 2007 12:25 AM - 10 messages
Hi All I have DataTable object.  Is there a way that I can know which fields (columns) in the table are computed. Apparantly the DataTable.Columns returns all columns both computed and other. Any help would be appreciated. Thanks. ...
Score SqlConnection ConnectionTimeout Before and After Pool Is Created
scott.ballard - 22 Feb 2007 10:51 PM - 1 message
Greetings, Does the ConnectionTimeout property in the SqlConnection class refer the total time to create the connection pool, if necessary, and return a connection, OR just the total time to return a connection from an established pool?  I notice that in the connection string for a ...
Score (Newbie) Problems configuring tables relationships in a DataSet.xsd
marivi - 22 Feb 2007 8:33 PM - 1 message
Hi! I'm having some problems when configuring table relations in my DataSet.xsd file. I'm trying to do that through the Design Editor, openning DataSet.xsd. What I want is to have the same configuration as in the SQLServer DB ...
Score XML Serialization with of a sub-class of DataTable.
sylvain.ross - 22 Feb 2007 8:26 PM - 1 message
Hello everybody, I have a very weird problem regarding the serialization of a class that I wrote (named DummyClass in my exemple). My class inherits from DataTable. Then I just try a dummy XMLSerialization and then Deserialize it into a new object. ...
Score Help calling an Oracle procedure from vb.net
dlevine54 - 22 Feb 2007 8:18 PM - 8 messages
I am calling an oracle procedure in a package. It is defined as   function get_request_status(request_id     IN OUT number,                       appl_shortname IN varchar2 default NULL, ...
Score OracleClient Connection Pooling
DSISupport - 22 Feb 2007 7:32 PM - 2 messages
Hi, I have this ASP.NET application developed with VS.NET 2003 VB.NET and deplyed on Windows 2K server IIS 5. This application uses the following: - Oracle 10G databse - MS Data Access Block from MS Enterprise Library June 2005 (with the other ...
Score Filtering relational dataset tables by parent record
dentyne - 22 Feb 2007 7:12 PM - 1 message
Good morning, [Cross post in Csharp group before I knew adonet group existed] I have a typed dataset with 10 relational, hierarchical tables.  I want to be able to "filter" all the dataset tables based on one parent record.  For instance, let's say I have a dataset that with 10 tables ...
Score BindingSource design advice
Flomo Togba Kwele - 22 Feb 2007 5:55 PM - 3 messages
I have a grid bound to a bindingsource. The user clicks on a row and hits a button on the form to delete the row. The tableadapter executes its update method but comes back with a Foreign Key violation. I trap the error and tell the user it's not ...
Score SQL Server logon name
nkw - 22 Feb 2007 5:05 PM - 2 messages
I have an ASP.net app and I have the following connection string: <add name="ConnectionString" connectionString="Data Source=DBS-004;Initial Catalog=DB1;Integrated Security=True" providerName="System.Data.SqlClient" /> I use Windows authentication and the Page.User.Identity.Name is my Windows ...
Score How do I run a DTS package in VS 2005
Gordon - 22 Feb 2007 4:40 PM - 3 messages
Hi; I am trying to convert a program written in VS 2003 which runs a DTS package. VS 2005 won't let me compile the program it doesn't recognize the DTS object. Is there a way to run the package under 2005 ? ...
Score General (newbie) design question about fields naming and aliases
M. Simioni - 22 Feb 2007 4:39 PM - 5 messages
Hi, I'm using the Dataset Designer Tool to create datasets for my VB.NET 2005 application. In my SQL Server tables I have odd field names, like "PWD_EXP" or "SYS_NAME". I have to show these fields to the user in a datagrid, so I have to ...
Score Access Components in LoginView
Steve Harp - 22 Feb 2007 3:54 PM - 2 messages
Hi All, This should be easy.  I have a LoginView control on my default page. Within the LoggedInTemplate, I have a DropDownList control.  From my code-behind cs file (in the DropDownList_SelectedIndexChanged method), how can I access the DropDownList to see what selection was made?  A ...
Score What is the purpose of AcceptChanges?
Jerry H. - 22 Feb 2007 2:53 PM - 10 messages
I know that sounds like a lame and newbie kind of question, because I understand what the effect is - but I'd really like to know what Microsoft's thinking behind this method is about. For example, I can pull ten rows from a datasource into a dataset, ...
Score Imports-statement for System.Transactions namespace
Dirk Schelfaut - 22 Feb 2007 2:35 PM - 3 messages
Hi I want to use the TransactionScope-class, available in the Namespace System.Transactions in my Windows Forms-app. The problem is that my version of Visual Studio 2005 can't find that namespace. So when I type Imports System.Transactions at the very beginning of my class ...
Score MultiUser Environment Winforms
AnikSol - 22 Feb 2007 2:12 PM - 4 messages
Development Environment: VB 2005 Prof, SQL Server 2005 In a typical Multi User environment, what is the best way to handle updates of disconnected datasets of other users. Eg: User A opens application Winform 1, dataset1 is loaded on his machine ...
Score Concurrency notification question
Earl - 21 Feb 2007 8:51 PM - 12 messages
I'm posting this question in both the SqlServer and ADO.Net newsgroups in the event there might be a programmatic answer on either the frontend or the backend. Imagine a small network running the same app attached to SqlExpress. A ...
Score ADO.NET Connectionstring+pooling
njdude - 21 Feb 2007 6:46 PM - 2 messages
When i run this sp_who I see the connection showing up and in the next second it is gone. The connectionstring i have is Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;pooling=true;Min Pool Size=2;Max Pool Size=50;Connection ...
Score Dataset and scalability issue
Nick nkw - 21 Feb 2007 3:50 PM - 4 messages
I am creating a winforms application. Drag and drop and VS 2005 automatically created Dataset based on the MDB schema. I found it seems that all the changes are cached in the memory. Will the default way has any scalability issue if the database tables are huge? What's the ...
Score What is the action of ForeinKeyConstraint.AcceptRule = Cascade - Ado.net 2.0
Rolf Welskes - 21 Feb 2007 3:06 PM - 4 messages
Hello, I have understand all about ForeignKeyConstraint . But: When I set ForeignKeyConstraint.AcceptRule = AcceptRejectRule.None or ForeignKeyConstraint.AcceptRule = AcceptRejectRule.Cascade I see no difference in behavor. What is the difference (not what you can read in the help), but what realy is the action wich takes place when I set to Cascade. ...
Score Authentication with WorkGroup
ruca - 21 Feb 2007 12:59 PM - 2 messages
Hi, How can I use authentication with Work Groups and not Domains. What is the configuration (in Web.config and IIS) to work with this? Basically I have a webapplication that use WindowsIdentity to login in my clients. Recently one of this clients change server and will be working with ...
Score Connection to Oracle Database from DotNet
Prasad - 21 Feb 2007 5:16 AM - 3 messages
Hi,    I have to connect to Oracle database which is on different machine from the application server.To connect to oracle db from DotNet , do I need to install oracle client?.Also please provide me the connection format I have to ...
Score To William (Bill) Vaughn
fiaolle - 20 Feb 2007 7:34 PM - 2 messages
What title will your new book have and when will it come or if it's already here? Thanks Fia ...
Score Please Heeelp I don't know what's wrong
fiaolle - 20 Feb 2007 5:24 PM - 6 messages
Hi I'm new to ADO in Visual Basic.Net and have problems with updating the DataSet. I'm using the code below, but after I have used the DataAdapter's Update metod nothing happens to the Dataset OR the database (the record is ...
Score Memo field trouble
musosdev - 20 Feb 2007 3:11 PM - 8 messages
Hi I'm using an AccessDataSource to perform a select query on an MDB file. However, my Memo fields are getting truncated? (to about 250 characters). Why is this happening and how do I fix it?! Thanks, Dan ...
Score Is DataSet.GetXml leaking memory?
Sunil Menon - 20 Feb 2007 1:23 PM - 3 messages
Dear All, I was just browsing through my code checking where my application is allocating memory and found that my code frequently calls Dataset.GetXml to get xml string output to store data in database. Further investigation through .Net reflector revealed that the call ...
Score localized exception messages
leibnizster - 20 Feb 2007 12:41 PM - 6 messages
hello, how do I set ADO.NET exceptions to be thrown in a particular language? I downloaded the dutch language pack, set current culture etc. Everything works OK for regular System exceptions (ex. Divide by zero => it shows "Poging door nul te delen."). But the exception related to ...
Score Copying a Record from one DataTable to Another.
Wayne Gibson - 20 Feb 2007 10:53 AM - 5 messages
Hi, Firstly thanks for taking a look this thread. I'm looking to update/insert records from one database into another. The databases will look something like this: Database1.MDB     Table1         fields (Won't know what these are at runtime) ...
Score DbProviderFactory, System.Data.Common, huh?
Jeff Jarrell - 20 Feb 2007 3:43 AM - 2 messages
I finally stumbled across the DbProviderFactory in System.Data.Common.  I had a similar factory in my framework but I thought it would be better to use the framework code, so of I went to change the code. As I was doing this it is apparent that when using the DbProvider (both the ...
Score Why is this code so SLOW?!?!?!?!
Marcus - 19 Feb 2007 11:54 PM - 4 messages
I have a a VB.Net app using an Oledb data connection to an Access 2000 database. There are three tables that I am using in a SELECT query: - ReadProps (2025 records, 5 fields) - Devices (511 records, 27 fields) - ReadPropEnums (3060 records, 6 fields) ...
Score Get SQL Printed Message Text w/ADO.NET
Dan - 19 Feb 2007 3:46 PM - 2 messages
Is there a way to get the printed messages from a SQL Script with ADO.NET? ...
Score Change default windows login in Integrated Security
Nemo - 19 Feb 2007 1:22 PM - 3 messages
Hi everybody! I've a connection to a database using integrated security in order to connect my app. with this db. but I want to use not the default Windows Login, I want use another login (an Active Directory validated ...
Score Inserting a row - not working
JamesB - 19 Feb 2007 12:25 PM - 3 messages
Not sure if you'll be able to help as I'm using an inherited database connection that one of our devs wrote... but in any case... I'm trying to add a new row to a table, using the following code (the below ...
Score TableAdapters and transactions
TheMaxx - 19 Feb 2007 9:36 AM - 6 messages
How to work with tableAdapters and transactions? I see no Connection or Transaction property in TableAdapters. This guy is doing something with reflection: [link] Isn't there a better way, something like best practise? ...
Score Typed DataSet with Oracle
mail747097 - 19 Feb 2007 7:38 AM - 3 messages
I'm developing an application that accesses an Oracle database. If I add a typed DataSet to my application and drag/drop a table in Oracle from Solution Explorer all integer column in the table becomes System.Decimal columns in the DataSet. I'm using Visual Studio 2005 ...
Score Determine if Oracle client installed?
David Thielen - 19 Feb 2007 5:13 AM - 3 messages
Hi; The class OracleClient is always installed - it's part of .NET. However, if Oracle's client software is not installed on a a system, then OracleClient can not do anything. How can I determine of Oracle's client software is installed and working so ...
Score HowTo: Set Server Permissions using SMO
Scott - 19 Feb 2007 2:53 AM - 1 message
All, Does anyone know how to set SQL Server permissions on SQL Server 2005 using SMO? For example how would one assign a new user to a server instance? Code snippet would be welcome. Thanks in advance, Scott ...
Score Joining two datatables with no primary key
Karch - 18 Feb 2007 9:08 PM - 7 messages
I have two datatables that share two columns which could be thought of as the primary key. There are additional columns NOT shared between the two tables. I need to merge the two tables together where Table1.ColumnA = Table2.ColumnA and Table1.ColumnB = Table2.ColumnB. What is the best way to ...
Score Currencymanager and finding underlying record i DB
Finn Stampe Mikkelsen - 18 Feb 2007 8:53 PM - 7 messages
Hi I'm a newbie to VB.NET. I have an app, with a dataset called dsKunder1 containing several tables. One being Reservedel.... I have a datagrid DgSpare, a dataview DvSpare, which i use to control the dataview in my datagrid. I will be needing to use the rowfilter of the ...
Score Nothing inserted (oledb access 2000 - VB.NET 2005)
Leo Leys - 18 Feb 2007 7:38 PM - 3 messages
Hi, I try to insert a record into an existing access table using VB.NET 2005. When I use a tableadapter.insert method, the result is obviously 1 record affected, but no actual record is added to the table. I tried different ways (oledbcommand executenonquery..), the result remains ...
Score What is happening when I press ESC while editing a data-bound DataGridView?
nvx - 18 Feb 2007 3:46 PM - 4 messages
Hi, could anyone please explain to me what exactly is happening when I press ESC while editing a data-bound DataGridView? The problem is I have a data-bound DataGridView and overriden ProcessCmdKey function and when I press ESC, it produces DB column ...
Score Connection Property for Query-based TableAdapter?
Mark Olbert - 18 Feb 2007 4:49 AM - 9 messages
I've just discovered something really annoying: if you drag and drop a stored procedure onto DataSet design surface in VS2005 you get what >>looks<< like a TableAdapter...only it isn't. Specifically, it doesn't expose a Connection property. ...
Score Login page username and password error messages code
chandrach_usa - 18 Feb 2007 4:34 AM - 2 messages
Hi I am some  new to .Net(C#) .I am trying to create a login page with error message validations.That validations are when I click the submit button with out  enter user name and password , first  error message ...
Score problem using stored procedures in dotnet
chandrach_usa - 18 Feb 2007 3:31 AM - 2 messages
hi Are there any pre written stored procedure which can be used for log in page under dot net  and also with validations. I m a newbie to dotnet, any help wil be appreciated. thanks in advance thanks chandra ...
Next »