Hi , i have a requriment where i need to perform connection pooling through c#.net code .My database is Sybase. Can any one forward me link or suggest me on how to start to write code for this. Regards Mani....more >>

Hello, I have the following problem: I have a table and in this I have rows say: Name, PreName, street. as fields. Now a have a row for example: Smith, John, new street 5 . Now I make a change to this row to: Smith, Harry, ..... Now I can get this row for example with table.Select....more >>

Hi I have a problem with the syntax of the SQL commands I use with the Oracle 10g Express database (from an asp.net 2.0 application using system.data.oracleclient). The database wants the queries formulated as in this example: SELECT "Company"."Name" AS "Name" FROM "Company" "Company"...more >>

Fred Read (postmaster@foxhouse.demon.co.uk) wrote: : He posts this drivel every week or so to a number of groups that : I subscribe to and nothing seems to stop him. *ALL* of his posts : are off topic and unwelcome to the groups he posts to. : We have complained about him to his postmaster ...more >>

I have a Data Access Layer that clients use to interact with the database. The layer takes in a SqlConnection and optionally a SqlTransaction. Clients are responsible for the upkeep of the connection/transaction. The layer allows clients to limit the # of records (maxsize) returned. Suppos...more >>

From: rji@cheetah.inmos.co.uk (Richard Ingram) Newsgroups: uk.misc Date: Mon Aug 14 10:08:32 1995 Some cencorship loving bore wrote : > In article <GEVANS.95Aug14094119@mvagusta.uk.tele.nokia.fi> gevans@mvagusta.uk.tele.nokia.fi (Gareth Evans) writes: > > His sysadmin is also next to use...more >>

Hello, The problem with GetSchema is that the columns vary by provider. In fact, I can't even find a spec for the columns returned for Sql Server! I don't know why Microsoft didn't even see fit to provide such a spec, it really eliminates the usefulness of GetSchema. Does anyone know of suc...more >>

1. Where would I find the code where the delete action takes place? C# automatically placed this binding navigator on my form and I see no code for where it deletes a record. I want to add a messagebox to confirm before allowign the delete. Thank you! Sometimes I wish I stuck with V...more >>

Hello, I'm trying to update some records of a database table called "PETICIONS_TRESORERIA" with this structure: codi int data_peticio datetime name varchar (first two fields made the primary key) .. .. .. I'm using a data adapter with a UpdateCommand as follow...more >>

I am having trouble figuring out how I might do the following, if I can do it at all. I have two databases, each with their own separate authentication details. I have a select statement that gets the data from one table based on existence in another table in another database. This works f...more >>

Hello, Consider I have a String: Dim MyString As String = "Hello" or an Integer: Dim MyInteger As Integer = 100 or a class which its properties: Dim MyClass As New MyCustomClass MyClass.Property1 = "Hello" MyClass.Property2 = Unit.Pixel(100) MyClass.Property3 = 100 Or even a ...more >>

Hi all, Is there a simpler/faster way of performing the following query with AccessDataSource against an .MDB file? SELECT StoryID, StoryTitle FROM Stories WHERE ((SoryTitle LIKE '0%') OR (SoryTitle LIKE '1%') OR (SoryTitle LIKE '2%') OR(SoryTitle LIKE '3%') OR (SoryTitle LIKE '4%') OR ...more >>

Hello all, It's urgent... i want to add autocomplete textbox facility in my application like google. as you type it suggests option to the user..i want the same kind of facility...i know i can do only with ajax(xml and javascript) but i want to fetch possible values from database and want t...more >>

I call a function with a CustomerID and it returns a dataset of two tables (Customers, Orders). If the ID does not exist in Customers, it returns empty tables. I also set a relationship on CustomerID between the tables, as well as a constraint on CustomerID. In code, if the tables are empty...more >>

I am setting the command object text of an OracleCommand to "Select FNGETDBVER() FROM DUAL;" I am attempting to retrieve the result of this function. However, when I call ExecuteScalar on this I get an invalid character error: "ORA-00911: invalid character". Any ideas? I can execute th...more >>

I believe this question is simple enough -- why aren't data types in SqlParameters validated in ADO.NET? For example, why is an exception *not* thrown on this line: cmd.Parameters.Add(New SqlParameter("@Id", Data.SqlDbType.Int)).Value = "not an int" Ideally, this wouldn't even compile, ...more >>

Gents, Been using 2003 for 4 years, and have several large Windows Forms based project that I need to continue to develop with VS2005. I have imported one of these projects, fixed some newly detected errors, and it appears to work great in VS2005. The problem I am having is updating Dataad...more >>

Hi I´ve 2 tables (order and order details), In my application I´ve 2 Datatable with 2 dataadapter. The primary key of table orders it´s and Identity the table details has foreign key with the identity of orders. How can insert in table order and details. I more than one record on table orde...more >>

Hi everyone. I have a very simple problem, that I seem to not being able to solve! Assume I have two simple tables Car, and Store, looking like this: Car ------- car_id make Store ------- car_id numberofcars and I want to show, and update the data in the Store table. I can ea...more >>

Hello I need an event to be able to cancel a delete request to a DataRow object in some conditions. It seems DataRowDeleting should be able to do the job but setting e.Action is impossible (it is read-only) How can I do the above job? Thanks in advance Hamed ...more >>

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. I have tried using the SQLDatsource control as part of a user ...more >>

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 ...more >>

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 method. Heres what I have so far (simplified of course!). Does anybody know a be...more >>

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 messa...more >>

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 2. Call to Update, the row is inserted in the...more >>

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 User B opens application Winform 1, dataset1...more >>

i want to get difference between two dates interms of days From http://www.developmentnow.com/g/7_2005_3_15_0_0/dotnet-framework-adonet.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

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. Amir ...more >>

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, program IN varchar2 default NULL, phase OUT varchar2, ...more >>

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 blocks like exception, security...) - Use Cryst...more >>

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 small c...more >>

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 allowed, but visually (and in the bindingsou...more >>

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 Window...more >>

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 ? Thanks, Gordon...more >>

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 present them with another naming convention (like "Pa...more >>

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, modify the contents of a few rows and then...more >>

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 (above Public C...more >>

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), ...more >>

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 listbox is filled via a datareader with contact names using ...more >>

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 Lifetime=120;Initial Catalog=test...more >>

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 use as I am new to oracle. Thanks Prasad...more >>

What title will your new book have and when will it come or if it's already here? Thanks Fia ...more >>

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 not deleted). Before I used the ExecuteNonQuery, then the record was gon...more >>

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...more >>

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 creates a stringwriter ...more >>

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 ADO are sti...more >>

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) Database2.MDB Table1 fields (...more >>

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 base and t...more >>

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) When I run the following SELECT stateme...more >>

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 is simplified) DataTable tblImport = myConn.OpenTable("SELECT * FROM table); DataRow ...more >>