Hi, I have an odd issue with the MonthCalendar control. I need to capture certain mouseeventargs, which I can only do in the MouseDown event. I need to pass these arguments to the DateChanged event to make the logic in that routine work correctly. Simple enough, except that the DateChanged e...more >>

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 entries are rel...more >>

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. The only fix that resolves the issue is "resetting IIS". We ...more >>

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. The class has the abilitiy to fill a spec...more >>

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 would be truncated. The statement has been terminated.' ...more >>

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 data from the user (every time they hit ...more >>

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 how to store XML data in the database. Could anybody give me a hint? Thanks for h...more >>

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... thanks, sm ...more >>

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

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 called "SomeClass". That's a codebehind and when I start the app and want t...more >>

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 give me timeout error and not above mentione...more >>

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 CType(MyBase.GetChildRows(Me.Table.ChildRelation...more >>

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 data to the database. The commit transaction failes and the catch block try...more >>

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

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. Please be good enough to point me to some resources on resolving this ...more >>

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: Dim myConn1 As New OleDbConnection(AppSe...more >>

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); //this.t...more >>

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: A first chance exception of type 'System.Data.OleDb.OleDbException' occu...more >>

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 some process, Is this wrong ? O...more >>

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