I have a bindingsource filled by a strongly-typed table via a tableadapter. I have connected the binding source to the AddingNew event where I want to supply some values for the new row. The problem is that this event is triggered when the TableAdapter fills the binding source. I'm not ...more >>

Hi; I have a Decimal type in SqlServer and I write a new Decimal (1.23) setting a parameter of type DbDecimal to it and all it writes is a 1. The decimal is gone. What am I missing? -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.w...more >>

Numeric is a type in Sql Server - but not in SqlDbType. -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm ...more >>

This is for Sql Server. "SELECT table_name FROM information_schema.tables WHERE (table_type = 'BASE TABLE') ORDER BY table_name"; gives me all user tables plus the system dtproperties. 1) How can I get just user tables (ie no dtproperties also)? 2) How can I get just system tables? 3) H...more >>

Hello! Is there an advantage of using parameter objects instead of using concatenated command strings? Example 1) use of parameter object: OracleCommand cmd = new OracleCommand("SELECT PROJECT FROM USERS.LOGIN WHERE UPPER(SESSIONID)=:SESSIONID", _con); cmd .Parameters.Add(new OraclePa...more >>

Hi, I am wondering, is there any limitation for the length of a query string? Thanks, Lubomir...more >>

In english it would we something like: The supplied assemblyname or the codebase is invalid. HRESULT: 0x80131047 The error is displayed right after the application is starting and wants to load the first Class Library. To redroduce the error I need to Start a WebApplication (everything run...more >>

I need to register the IBM drivers for connecting to DB2, as I get this message indicating the drivers are not registered. I can connect to the database just fine using any number of ways outside of my program, so I know that the drivers are there and can be connected to, but I am not sure wh...more >>

Hi there, I'm currently trying to come up with a solution for incorporating transactions into ADO.NET typed datasets. I was all set to simply use implicit transactions using TransactionScope as discussed on this page... http://msdn2.microsoft.com/en-us/library/ms172152.aspx#Mtps_DropDownF...more >>

Hello all. Here is my architecutre: I have a sql server data table feeding a dataset/datatable displayed in a datagrid. Today I had a very strange error, something like: 'Sql Exception - Date Overflow'. Which is strange in of its own. After i restarted my application, I noticed that all th...more >>

Hi, I'm getting the following error when connecting to Oracle database through ..NET ===================================================================================================== System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. Descri...more >>

I have a project that creates a SqlDataAdapter and uses its Fill method to fill a DataTable with data from a user-provided query. From there I can obviously access details about the rows and columns returned by the query. However, I need to be able to determine the size of the varchar fields t...more >>

Hi, I have a .NET DLL with a COM callable wrapper. The main entry point establishes a connection to an Access 2000 database. The connection is used as the active connection to different SQL commands. The last line of the entry point of the DLL calls m_Connection.Close. The IDE does n...more >>

I am having a strange issue with cascading deletes in that it simply isn't cascading. Heres what I'm using: VB .NET 2005 sp1 SQL Express 2005 For simplicity, I will give 2 of the many table adapters in the app and their relations: Sites ----- (PK) Name ContractType ContractExperati...more >>

do i need to install the oracle client to connect to an oracle database ? i'm doing fairly basic queries to an oracle (9.2) database and will be rolling the app out to multiple windows desktops. will i need to install the oracle client on each windows desktop ? is there any advantage in connec...more >>

Hi all, I want to handle concurrency issue when 2 user try to update same record. What i want is if user1 and user2 are accessing same record and user2 has updated same record then when user1 tries to update that record he should able to update it. Which is not happening currently. Can a...more >>

Hi Gurus, I need advice from you. We are going through an arguement. I am working on a [ORDERS] project, and another person is working on [REPORTING]. What he want me to pass is a OrderID, then he will do a query, create a DataTable to create a report. But the question is should I pass a...more >>

I am working in C# creating a Windows Forms application. I have a dataset from an Oracle database that I want to change to a typed dataset. Can this be done once a dataset that is not typed has been returned from the database? -- Robert Hill ...more >>

Hi, I have a problem with the GetChanges() method when I use an expression column. The expression is using data from a child relation. When I call Getchanges I got an evaluation expression that the column from my child relation doens't exist. How can I work arround this issue? Thanks Bar...more >>

Hi, I have created a CLR stored procedure and want to call it using Data Access Application block provided by Microsoft. But in this application block when method tried to derive SP's paramter using SqlCommandBuilder.DeriveParameters, it throws InvalidOperationException and give error message...more >>

Hi all, I need to read and write to a DateTime column. The column is binded to a TextBox. The problem is that I don't know how to display only the "hour part" of the DateTime in the TextBox, now if I write 12.30, when the TextBox loses the focus I see 10/04/2007 12.00.00. I'm using the c...more >>

I'm trying out the tableadapter in vb.net V2 framework. I have added a tableadapter which successfully returns all records in a dataset table. If I preview data by right clicking the dafault Fill,GetData() methods shown under the TableAdapter this lists all my records in myTable. I now want ...more >>

I'd like the administrator for my web site to be able to select between a 'Production' back-end or a 'Backup' backend. There are 2 values in the Web.Config file, but I know that the point that it connects using the web.config information is already too late. My current connection is setup ...more >>

I'm connecting to a access database which is in the \bin\debug folder in my project directory. So if I set myproject/settings/myDatabaseConnectionString to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb" and configure a dataset to use this connection string and ...more >>

I'd like to develop a client-server application where the users (.Net 2003 application) can modify data in the database (sql server 2005), and all other users will see those changes in near real time. This kind of architecture will require that the client applications periodically (every se...more >>

I have a "UDL" file on my desktop that I used to test my OLEDB connection to my database. When I invoke this and supply my User ID and Password, it connects to the database just fine. Now when I go over to VS2005 and supply the same connection in my UDL, I get a error when I attempt to ope...more >>

Oracle 9i Windows 2000 SP4 Visual Studio 2005 NET Framework 2.0 Configuration (version 2.0.50727.42) We are getting: "Unable to get error message (6107) System.Runtime.InteropServices.ExternalException {System.Data.OracleClient.OracleException}" - after processing around 10000 +- 500...more >>

Currencymanger is a boon, but making it work in out of the box situation could be challenging. Is there any sample or article, which describes, how to synchronize two dataviews bound to the same data table? This is the scenario: dvDataView1 is bound to Dataset.DataTable. dvDataView2 is...more >>