I got the following error: Concurrency violation: the DeleteCommand affected 0 of the expected 1 records. I have two tables in a strongly typed dataset, parent and child. I have defined the delete rule of the relationship to cascade in both the dataset and in the database. I can delete a ...more >>

I'm having a problem with the binding navigator on a form in that it won't reflect the results of a deleted record. The binding source is a single table bound to a sql db as its data source. When I call the code to delete a record (always a single record), the code executes properly and the re...more >>

Hi I need to store the path to db in my app. I have used app setting for this. Unfortunately various clients have different db paths and I have set them up once on each client location. The problem is that when I send them updates and they uninstall the old version and reinstall the new versio...more >>

Hello i created my data access layer in a class library (a dll), i referenced this dll in my project. When i deploy my solution i can access to the app.exe.config file, but i don't find the config file of my dataclass.dll. so i can't change connectionsstrings of my application. how can i do. ...more >>

Hi everybody, a suggestion, please. I have an application A that modifies the records of an access database. I should write an application B (running on the same machine) that monitor these changes, without modifying application A. I think the only solution is polling the database and check eve...more >>

Hi All, I am using VB.NET 2005 on Microsoft Vista.=20 I have opened a project in VB.NET and when i try to run it, it will = cause a error on the adox. Here is my Source: =20 Public Function CreateAccessDatabase(ByVal DatabaseFullPath As String) = As Boolean Dim bAns As Boole...more >>

Hi, I am getting a datatable which I assigned the dataview as MyDataView = datatable.view; the datatable has about 7 - 10 fields. I only want to display 2 fields on my wingrid, like name and description. How do I user dataview to filter out the rest of the columns? Thanks, AJ ...more >>

With classic ADO you could attach a ReturnValue parameter to a command containing inline parameters. Ex: Cmd.CommandString = "PubsInsert('G. B. Shaw', 'I lost my Rifle')" Dim pRET As New ADODB.Parameter pRET.Type = adInteger pRET.Direction = adParamReturnValue Cmd.Paramet...more >>

I have a stored proceedure that has a varchar(max) output parameter. How do I specify my size value in the parameters collection? or is this something that cannot be done? Thanks, ...more >>

Hi I have a stored proc that has two select statements in it i.e. it returns 2 result sets. When I try to use the Visual Studio DataSet designer and point it to this stored proc, it only sees the first select of the sp and therefore only generates the one DataTable etc. Is there a wa...more >>

Can anyone help me with an issue. I have a .net app that tries to connect to my sql server here on my laptop on my company's network. When I have someone on the network try the app they get the following message in the errorlog: *Timeout expired. The timeout period elapsed prior to completion ...more >>

I have a SQL Server 2005 instance. On it are a bunch of databases and a linked server. ADO.NET easily accesses all the named databases on this server. However, I would like to access data through a linked server on the same instance of SQL Server. However, the GUI of the DataAdapters won't all...more >>

Whenever I run this code, I get a row added to my table in the primary field whose text is "System.Object". This code is intended to simply add a single row to a single table. Anybody see why this is happening and what I need to do to stop the extra row? Private Sub btnDeleteOrder_Cli...more >>

I've created SqlParameter with precision = 15, Scale =2 and name = @param1. I added it to command which text is: Begin SELECT * FROM TABLE WHERE VALUE < @param1 END if I put param .Value = for example 99.99d it works. If I put param .Value as 99.00d it breaks with out of range value. ...more >>

I have googled and see this is a common issue, but for some reason I can't figure this out. I have a typed dataset, and have created a Query called "GetDataById(@id)" I call it like this: VerificationForm.VerificationFormDataTable table = VerificationTableAdapter.GetDataById(id); (wh...more >>

VS2005 I have an application that is used by a variety of users. The application analyzes some data and writes the results into a database. Different users use different databases, and sometimes the same user will use a different database at different times. So, I want the user to be ab...more >>

So I'm experiencing an odd problem. I establish a connection and enlist in transaction and then save my dataset changes to the database. My dataset contains 20+ tables that get updated, and I have my code setup to handle inserts/modifies/deletes in the correct order. I'm experiencing a really...more >>

Hi; Is there a database independent way to fill just the 1st row of a DataTable? -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm ...more >>

Hi; This should be possible but I can't figure out how to do it other than reading each row and stuffing it into a table. I have an IDbConnection and the select - no other info. I need a DataTable of the data that will be returned from the select. How can I do this? -- thanks - dave ...more >>

I'm trying to use this simple code to update an Oracle table and it fails with this message: Oracle.DataAccess.Client.OracleException : ORA-00904: "MINDEX": invalid identifier The Select command works fine. OracleConnection con = new OracleConnection("Data Source=SP3DSMP2;User Id=sys;Pass...more >>

integrated Security= true or Integrated Security=SSPI Does the above mean the same thing in a connection string?...more >>

In upgrading an application to .Net 2.0 from 1.1 I had an opportunity to implement some asynchronous calls to the database. In the application there is a quick search facility that makes 6 calls to 3 different database. This I thought was the perfect scenario for Asynchronous calls. Anyway i ...more >>

I read an article that you can procompile ASP.NET to speed up initial response time for users since pages do not have to be compiled the first time they are requested. http://msdn2.microsoft.com/en-us/library/ms227972.aspx Is it possible to do this with desktop applications? Thanks for an...more >>

In my ASP.net application I am getting the following error... "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occured because all pooled connections were in use and max pool site was reached". This only happens when I am in debug...more >>

hellow frnds, i hv a form of vb.net with SQL2000 connection, how can i count the hierarchical data from database. eg. every customer hv a id and each customer hv two downline id left downline and right downline(either one of them will hv value or both hv value) ...more >>

Hello, I am trying to set up some nested transactions to speed up a group of unit tests. The unit tests call a common method to build up some test data, which takes about 30 seconds and then runs a specific test. Each C# unit tests has a using statement that creates a new new TransactionS...more >>