I am currently using VS.NET 2005 to read in a text file into a sql server database table. The code cycles through the file and using a .add with a dataset seems to add all the rows just fine. When the program finishes and I go do a query on the table it is empty. I am new to using VS so I ...more >>

Using the typed dataset designer, I dragged an existing stored procedure onto it which has several select statements in it For simplicity, something like: select * from table1 select * from table2 select * from table3 It seems the designer generates on datatable based on the first selec...more >>

Hello all, I am working on a csharp database application that should give its end users the ability to create new tables related to existing ones or even create the database structure completely on their own. I know how to do that by creating a DataSet object and adding tables and relations...more >>

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

I get an error when executing the Update method on a dataset. The dataset is a strongly typed one, with two tables in a parent/child relationship. The parent has an identity column for its PK, while the child's PK is a composite one. Its first column is the identity column of the parent and the...more >>

VS 2005 I want to make sure I have this concept down correctly. I have a strongly typed datatable and a binding source connected to it. On my windows form a grid is connected to the binding source. When the grid is unsorted the datatable(bindingsource.positon).mycol = DirectCast(bindin...more >>

Hi, Enviornment : Visual Studio .NET 2005 and SQL Server 2005 I created one stored procedure, let's say GetData()...Basically, what it does is that it just returns data from table. (Select [A],[B] from [Test] where id=@id..something like this...) I created a strongly typed data set with...more >>

Hi, I have an error when I try to install a program that say "MDAC not present", I went to the MS page and downloaded the MDAC_TYP but when I run it nothing happen, I have Vista business with all patch, please help :( Thanks Paolo ...more >>

Hi; I have a case where I have a select and I need to get the column names the select will return. If the select will return a row I can just run the select. But it is possible for there to be no rows and I still need the column names. In this case Execute will return a DbDataReader with 0 ...more >>

Hello there! Is it possible to define a stored procedure command by adding the return value parameter without specifying the data type? I don't really know, what the data type of the return value is, so I prefer to get the value as object. Is there a chance to do it? Regards, Norbert ...more >>

Hi, I would like to ask, how SQ Server Express manage the table access: I have two processes. What happen if one process is writing data into table,and another process is updating data from this table at the same time. Will be the second process allowed to access this table for reading ? ...more >>

Hi, I don't succeed into debugging into generated tableadapter code. Neither by stepping in (F11) nor by putting a breakpoint. Is this not possible or is there something special I must do in order to debug into tableadapter code. It is not that I want to change the generated code, I want to ...more >>

I have an ODBC data source that has EXTREMELY limited SQL functionality that I want to expose via a web service. For example, I need to SELECT DISTINCT and teh ODBC client does not support the DISTINCT keyword. So, in the web service I am forced to retrieve ALL records that match the WHERE...more >>

I have a dataset (with one table in it) that I want to serialize into string data to store out on a SQL server DB. Here are my questions: 1.) Does anybody have some code that can do this? I saw there was a serialize method that uses a streamwriter, but I need a code example. ie; something l...more >>

This is a question from a Newbie. Although it executes correctly there is no new record added to the table (which isn't what I want :). Could it be that the table has an "AutoNumber" field (RecordID)? I have tried (among other things): SQLString = "SELECT * FROM TypeNames" DBAdapter2 = New O...more >>

Hello, friends, In our c#.net app (2.0), I have an UPDATE statement like the follows for Oracle DB: UPDATE contract SET phone = :phone, fax = :fax, status = :status, ....(more fields here) WHERE contractNum = :contractNum I know I need to pass values for each parameters before execution...more >>

New feature in ADO.NET 2.0 is the ability to do batch updates using the DataAdapter UpdateBatchSize property. From what I understand, enhancements were added to the SQL Server and Oracle Data Providers to support this. We have the need to support this directly without going through the DataAda...more >>

Dear all, I have a simple question based on accessing to SQL express 2005 throught a ..net 1.1 librrary- Does this SQLClient class is capable of accessing SQl 2005 express ? Or do we need to use 2.0 thnaks for info regards serge...more >>

Hi I need to check if a record exists (or not) in a table for a particular id. Is there a quick way to do this (like ms access dlookup function or similar)? Thanks Regards ...more >>

How can I Do bulk update. For example I have editable grid ,user is edting the grid and storing into dataset. I have to update all the changes into DB. I need to update only the changed records or fileds....more >>

There is so much talk about being a Postal Employee here in the Vista group, I was wondering if anyone had information on how one can become a Postal Employee. That would make my Momma proud. ...more >>

Hi All, I've posted this before but unfortunately I have found a solution yet so I am hoping that someone can help. What I wish to do is take an excel file from an end user, copy and rename it as "backup of...". Then I want to take the original file, delete it and create a new blank copy of...more >>

Hello All: I want to Filter a DataView then output to XML, the problem is when I = place a Row Filter on the DataView the changes are not applied on the = XML output. Thanks=20 Stuart=20 DataView oDataView =3D new DataView(oDataSet.Tables[0]); oDataView.RowFilter =3D string.Format("Em...more >>

Can anyone point me in the right direction here? I'm attempting to compile a Windows project that consists of a single form at this time. It's a newly generated windows project with a few controls. Here is the compile error: The type 'System.Data.SqlClient.SqlConnection' exists in both 'c: ...more >>

I have a DataGridView that is bound to a BindingSource whose data source is a table in a DataSet. The dataset is filled from an OleDBDataAdapter which is connected to an Access database. When a new row is added to the database, I want the DataGridView to automatically update to show it. Is ...more >>