ADO.NET

I am working on an ASP.NET 2.0 banking-type application.  No, it's NOT a school question!  This is a real-world web application. :) The table "Transactions" contain all types of individual "transactions" - interest_payment, deposits, withdrawals & fees mostly.  Each of these ...

provider = DbProviderFactories.GetFactory(invariantName); This FAILS when I have multiple versions of a connector installed.  The message is something along the lines of "may not be installed" but thats not it.  Here is an excerpt from my machine config.  As you can see I have MANY versions of MySql.  I wouldn't do this but I have one commerical tool (codesmith, mysql provider) that requires a specific version and it is Not the current one.  And it would seem over-time, the end users would not be paying attention to uninstalling old versions. ...

Hello, I have tried two ways for executing a query and creating a dependency on it, one using plain Sql commands, the other using Enterprise Library wrapped commands. I keep getting: Warning: Fatal error 682 occurred at Oct 12 2007 11:01AM. Note the ...

Our web application runs on .NET Framework 1.1.Sometimes we get errors like "Cannot find table 0". After this error the whole website is non-functional. If some one accesses the website at that instance they get the same error. ...

Hi I do smoething like that: (I try do this directly from code) USE master 1)Create login user1 with password = '12345' - ok USE MyNewDatabase 2)Create user user1 for login user1;  - ok 3)sp_addrolemember 'db_owner','user1' - error "User or role 'user1' doesn`t exist" ...

Using SQL 2005 We have a proc that we are calling from an ASP.NET application using ADO.NET.  It is intermittently return the following error message: 'Error executing the command exec [proc_name] to DataSet. String or binary data ...

I want to validate my data at the typed dataset level and not at the datagridview / ui level. Data validation is a business rule and as such should be a different layer then the UI. Basically, I have a class made for each datatable in my typed dataset. ...

Hello! I need some input as I am not quite sure the best way to approach what I need to do..... I am collecting information from users in a Forms Application but also have data that I have read from my database and the two are related. As I read the ...

Hi, I have an XML document that I  want to store in the SQL Server/Exprss database. The database table has a column of type XML. I saw examples how to read XML column, but I haven't seen any ADO.NET way ...

hello, does anyone know where i can find documentation on what sort of SQL can be used on the filter & view methods for DataTables? i see plenty of use of standard statements in use, but im interested in knowing which helper-methods such as UPPER('foo'), etc... ...

I am encountering the following problem with a call to a stored procedure from C# code. The stored procedure looks like this: ALTER  PROCEDURE sproc @id1 int, @id2 int, @trans_date datetime, @flag1 bit output, @result int Output AS .. .. .. Set @flag1 = (SELECT flag From MyTable ...

Hi, I would like to know, when should I initalize this property? I'm developing an multi-language application. Should I take the language of the database? of the user computer? are they more info on that property? Should I let it to Default in visual studio? ...

Guys, am I getting crazy? The huge app working just perfectly with 1.1 stopped working with 2.0. When I started debugging I found that the method GetType() returns the type in low case. For example I'm having the class ...

hi all, I am using sqlbulkcopy to copy content of csv file into table.  I am getting above mentioned error. When i increase bulkcopytimeout this error is not occuring.  So what i am expecting is if bulkcopytimeout is not sufficient then it whould ...

Hello, this is driving me crazy... I generated a dataset relation in the Visual Studio 2005 Designer and called it TestRelation. The designer generated this portion of code:        Public Function GetBRows() As BRow()             Return ...

On Aug 21, 4:27 am, treg***@hotmail.com wrote: Microsoft remove KB928365 from Windows Update. I thing, Microsoft know about troubles with this update and try fix bugs. ...

Hi, I've read some articles about this issue but no answer found. Once in some weeks we get a timeout exception on a commit. The command timeout is 30 seconds, but this error occurs 11 seconds after we write the ...

I have an SqlDataSource that I want to use for a gridview control. I want to filter the SQL statement using the Userid GUID of the "current user". Any idea how to do this? Thanks ...

Hi, Is there a known issue in using Access through OleDB provider in C# (.NET Framework 2.0) where inserted records are not reflected in subsequent queries. Worst still, if the PK is a auto number an exception is thrown. ...

This is driving me insane!! I have a very simple Insert statement that is blowing out with a Syntax error.  First, here is my code - I have stripped out all of the dynamic column names and hard-coded the values just to try and identify the problem: ...

I'm getting a timeout error at the following line (Line 1). I tried typing Line 2, but getting a compilation error (saying not an instance). How can I set a commandTimeOut value in this situation? this.tbl_ge_media_logTableAdapter.Fill(this.dB_CAIRS_LOCALDataSet.tbl_ge_media_log); ...

Hi, I am getting this exception when I am trying to insert the second item to an access DB. The values are from another OleDB source. If there are links about this exception please let me know. The full exception: ...

I have a static function in a class, everytime I call this function, I am creating a SQLconnection, open it, use it, and null it, All my functions and application logic is like this, Every connection is creating self connection object and null it after the ...

Hello, I am writing ASP.NET application using SQL Server 2005 Express Edition. In web.config I have: <connectionStrings> <add name="MIM-Magazyn_Demo" connectionString="Server=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIM-Magazyn_Demo.mdf;Database=MIM-Magazyn_Demo;Trusted_Connection=Yes" providerName="System.Data.SqlClient"/> ...