My update method is not working, I am getting An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Don't know why. Please help! using System; using System.Data.OleDb; using System.Data; using System.Da...more >>

hi i am using OleDbSchemaGuid to display the schema information of a database when i use OleDbSchemaGuid.Procecdures method it returns a data table containing all procedures as well as functions.. but i am not able to separately get the list of procedures and the list of functions....i need...more >>

We are reguarly getting deadlock errors on a page when it calls SqlDataReader.Read(). If DataReaders are read only, forward only 'firehoses', why would this be causing deadlocks? What can be done to resolve the problem? ************************************************** Erro...more >>

I know I need to use the parse method of the DateTime but am unsure where or exactly how to do it. I am trying to update a SQL database with an unspecified amount of data and am passing in several columns whose datatype is of type DateTime. Below is my code. using System; using System.Data....more >>

Database1 contains a table of people with addresses (sql Server) Table: People MasterID MasterName MasterAddress1 etc. DataBase2 Contains a table of people and the property they own. (msAccess -> imported from the sqlServer but detached) Table Property PropertyID MasterID Prop...more >>

Im just converting an app to .net (using VB) and I decided to use ado.net also, rather than sticking with plain ado. I have got my queries running fine with datareaders, but I'm having a little trouble inserting records. I dont really want to use an SQL command as single quotes in strings o...more >>

Hi all, What wrong with the below snippit of code? I believe I've called the this function correctly and besides all the errors (immediately below) are pointed to this snippit of code. Thanks in advance, Steve. } expected Invalid token '(' in class, struct, or interface member declaratio...more >>

Hi All! i am using the oledb connection to connect Oracle database. I use the code for connectiong to datawindow as Public sqlca As Sybase.DataWindow.AdoTransaction Public con as oledb.oledbconnection 'con as oracle connection con.open() sqlca = New Sybase.DataWindow.AdoTransaction(co...more >>

I'm designing my data access needs and have a couple of questions. First of all, I can't get a straight answer what a "business object" is. I typically create classes to represent my database tables, are those "business objects"? Is it more typical to pass the business objecs to the DAL metho...more >>

in ADO.net 2.0 beta 2 I know how to do the parent-child type. 1. drag a DataGrid control in a window form, get a datasource from table cust. 2. drag table cust onto the DataGrid. 3. in the data window, right-click the dataset, select configure.. adding table o. 4. drag t...more >>

This Point has always make me confuse Sure that DataSet is in the RAM but where in the RAM the Server or the Client Shall be Very Kind of you if any one can take a lill of there time to let know this Topic clear to me.. Thanks Dudes ;) ...more >>

Having spent a lot of time Googling over the last 2 days, this seems like a common problem, but I havent run into any answers: My VB.Net front end loads data from an Access database successfully, and navigation works fine. However, I cannot add a record. Code is as follows: In my Add N...more >>

Hi, How can I make my application work with SQL Server, Oracle, MySql, etc? _dino_...more >>

Does anyone knows how to assign the value of a textbox to = productDataSource.SelectParameters when a button is clicked? I'm using = VS 2005 and all the code I've found on the web are samples of dropdown = lists with code in the aspx page. Heres the subroutine where I'm stuck. Prote...more >>

I'm getting an "Unknown connection option: user" error when trying to The connection string block in the dataConfiguration.config file looks like: <instances> <instance name="Instance1" type="Sql Server" connectionString="Connect_String1" /> </instances> <connect...more >>

(sorry for the dual post here and the webservice NG. I meant to send to both at the same time) I have a method which sends email to & from a specific account. All was working fine until the server was upgraded to an AD/DNS server. Now the email never goes through. I can run the same code f...more >>

I have a DataTable that is being maintained in a Model class. I also have a View class which creates a DataView from the DataTable that the Model passes it. The view class then has methods to filter the contents of the DataView so that the user can narrow down the list to the items they are ...more >>

Is there anyway to determine the index of a DataRow within a DataRowCollection? I am using the Find() method of the DataRowCollection on my table to get me the record I am looking for, but it is returning a DataRow object and not the index of the object. Is there another way to find this? A...more >>

Hi, We are having a major debugging problem here and would like to take advices from anyone. In our app, we need to update our dataset using DbDataAdapter against Oracle database. Once we have issues, like invalid data or something like that, the update will fail but only with limited re...more >>

I built the Microsoft (June 2005) Enterprise Library as strong named assemblies. In a Web application called ConfigTest, I use the Data Access Application Block. When the application starts and the code that uses the enterprise library is executed, I get the following error page: Server Erro...more >>

Hi, I've sent a similar post earlier - but after no more luck and a lot more frustration, I am reposting the issue with some additional information. It's regarding several web applications on the same server, connecting to a SQL Server on another server. I keep getting the following exc...more >>

I am a Delphi programmer who is excited about converting to .Net (however still novice in .Net), and I need your help to understand some data manupulation concepts. I am using I have a typed DataGrid bound to an access database, which has a table with 2 datetime fields: Date1 and Date2. I ...more >>

Hi I 've got 2 databases on 2 different SQL servers. I need to copy the result of a stored procedure on SQL1 into a table in a database of SQL2. What would be the most efficient way of doing this. I'm slightly concerned about performance, since the query result can easily be 500000 records. ...more >>

Hello all, I wonder how to merge multiple datarows within one single dataset? I have a dataset which contains one table, in this table, for example, there are 10 records, where rec#1 - 5 have the same content in column(0) and rec#6-10 have the same content in column(0), now I want to concat...more >>

can a menu on a base form be inherited and shown on another form? How can i do this? ...more >>

I have been reading about the new data features in VB 2005, and while the DataSet Designer promises to reduce development time, it also looks very much like the VB6 DataEnvironment which, for me at least, was a source of much grief which went away when I replaced it with straight ADO code, as we...more >>

This is really stumping me. I have a dataset where I compute certain columns because I need to reorganize the data to a certain format, but I need to take the new columns and put them into a new dataset. I have a custom control where a user performs some actions and it combines certain columns...more >>

Hi! How do I reorder the column in a dataset after it is loaded with data? Don't know if this is a easy one and I just missed it, but mabye you know? ;) Erik ...more >>

Here is a newbie question, but this one is driving me crazy. In a VB.NET Windows form application, I am inserting and updating records in a DataSet, which show up in a bound DataGrid just fine. I am also issuing a DataAdapter.Update command, and the updates are saved to the database but the ...more >>

Hello everyone, I have a data adapter and would really like to be able to change the value of a column on update. I am using New System.Data.SqlClient.SqlParameter("@DateModified", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, B...more >>

1. Is there a 2nd way to declare a strongly typed DataSet (e.g. CustomerDataSet) in WSDL instead of using the WSDL <import namespace="CustomerDSnamespace" location="url to CustomerDS.xsd"/>? Apparently, if I include CustomerDataSet schema definition in WSDL types, it will not be recognized ...more >>

I am running a tiny SQL Server 2000 database on a Small Business server premium edition. I am connecting (using SQL Server security logins) to it from 2 XP professional workstations each running the same simple VB.NET program. (I am not running the server as a domain controller, just using a ...more >>

We stop a separate server with a SQL Server instance for backups at night the restart after backups are completed. The ADO connection on our web server (Win Svr 2k w/IIS) cannot reconnect to the database server unless the web machine is rebooted. We have tried to restart IIS but it did not w...more >>

Hi, Is there a way to read witch WebControl (like TextBox's) and howmany webcontrols are in a WebForm? ...more >>

Hello, I have an asp datagrid where i'd like to display four colums, each one showing datas coming from a different dataset. Each dataset has a common PK, so i'd like to make a join on this PK, and fill a result dataset to bind it to my asp datagrid. I can't find any samples showing this kind o...more >>

Hi all I am using System.enterpriseservices in a class library. I am calling a stored procedure within this class procedure. This procedure is taking a long time to execute and after some time I get the follwoing error "Distributed transaction completed. Either enlist this session in a new ...more >>

I am running a VB.NET app on my desktop with Access 2003 as the DB. The table I am working with has a PK made up of 2 columns. I am currently the only user. I built my own UpdateCommand for the data adapter. The command uses values for the PK columns in the WHERE clause ad then uses "Set" for...more >>

Hi, I have a data adapter and trying to connect it to multiple tables. I am not sure if it is possible and if so, I can't find what I am doing wrong. I am using HTML controls because the original page was created with another software, but I changed all the controls to "Run as Server Control"...more >>

Hola mundo tengo la siguinnte conexion a una base de datos Acces 97, funciona bien en windows 98 y 2000 pero al instalar la aplicacion en WindwsXP SP2 sale el sgiuiente erorr Run-time error '430': Class does not suppot Automation. Estoy usando mdac2.7 Public db As New ADODB.Connection P...more >>

Here's a variation on the old chestnut, but I can't get a handle on it. I have a database that has a many to many relation. Table A has two columns AID and AName, table B has two columns BID and BName and table AB has three columns ABID, AID and BID for relating tables A and B. (I am using A...more >>

I create a script file (.sql) with DTS. How can I read it into Asp.net and execute it? ...more >>

I am using ADOX to create an Access table and populate it with one row of data. The ADOX code sets two columns as primary keys (I can view the table in Access and see that they are set). When I try to create the UpdateCommand I get an error that it fails because the Select does not include a p...more >>

I would like to know if anyone knows how to execute a stored procedure from ASP.NET 2.0. I'm using the NorthWind database and I'm trying to execute the "CustOrderHist" stored procedure. The error I get is "Incorrect syntax near 'CustOrderHist'. " Public Function GetCustomerOrderHi...more >>

Hi, I'm currently working writing a Windows service in C# which needs, among other things, to interface with Microsoft Great Plains 8.0, specifically to add General Ledger entries. In order to add a new General Ledger entry to a Great Plains database, it's necessary to supply a journal entr...more >>

What is the difference between an OleDBConnection and an ADODB.Connection? I am working in a VB Express 2005 application and I want to have a global connection object throughout but when creating a table in an Acess DB using ADOX the OleDBConnection won't work and I have to create an ADODB.C...more >>

How do I code a Find method for a dataset that has a multiple column primary key. I tried the following but it won't accept the syntax of the Find. The prinmary key is a combination of the name and uclass columns. =========== code =========== Public Function FindUnitRow(ByVal name As Strin...more >>

Are stored procedures are precompiled in SQL Server. John. ...more >>

Windows Forms Application Sql Server backend Controls are bound to a DataSet I want to restrict the amount of numbers to the right of the decimal a user can enter into a control that is bound to a sql server numeric, .net system.decimal. If the numeric's scale is 2 then the user can only...more >>

Do I use ExecuteNonQuery only when I insert, delete, and update the database? Thanks Ross ...more >>

I was wrong. When the CommandBuilder is hooked to the DataAdapter, the UPDATE statements generated DO morph from row-to-row. This way only the changed columns are SET. This is a good feature, but given the other limitations of the CB, I still can't recommend its use. When you use hand-writt...more >>

I have a really wired thing going on here and I can't seem to figure out what is wrong. I have a managed C++ application that is using ADO.NET on an Access database. Here is the steps that I am taking that are causing a problem: 1. I open a OleDBConnection to the database 2. I create an ...more >>

Say I have master table of inventory parts (PartID, PartNr, PartName, ....) I also have a detail table for bill of materials (BOMID, ParentPartID, BOMPartID, ...) The two tables are in a one to many relatiobship linked by PartID<>ParentPartID. BOMPartID in the detail table also references...more >>

I have read posts and tried many things and I am not getting how to do this. I have a datagrid bound to a dataset (the source). When a row is selected on the datagrid, I need to duplicate that row into another dataset (the destination). The destination dataset will be bound to a a repeater ...more >>

Created a vb.net windows service which connect to a database by using OleDb. Using a connectionstring pointing to a local sqlserver database everything works fine, but when connecting to a database on another server the connection.open method executes without errors but the connection stays clos...more >>

I need to return values from multiple tables in a dataset at the same time. Is there a way to create inner join query to a dataset that has several tables? BR Johanna Turku ...more >>

Check out the article titled : Dear Mr Gates, A suggestion to make the CLR Ubiquitous at http://dreams2text.blogspot.com/ ...more >>

Can we detach /attach database in program? ...more >>

Hello: Im trying to build a generic library with tools that can be connected to any database. I want to list the tables on the database. Now I'm using the code: DataTable resultTables = cs.GetSchema("Tables"). But it returns different tables for the different databases For example, in...more >>

Hi, I can't use DataTable! I try to write ( in form load): Dim myDataTable As DataTable = New DataTable("ParentTable") I then get "Type expected" for the DataTable (in Task List) I have included "Imports System.Data" (Tried Imports System.DataTable, and other Imports) I have Visual Bas...more >>

The console application below demonstrates the problem. Is there a fix? using System; using System.Data; namespace ConAppOverflow { class Class1 { [STAThread] static void Main(string[] args) { // Create a dataset. DataSet ds = new DataSet("ds"); DataTable dt; Da...more >>

I have a windows form with 5 fields. They are bound as follows: drvDetail = (DataRowView) cm.Current; vueDetail = drvDetail.DataView; this.BindingContext[vueDetail].Position = cm.Position; txtSON.DataBindings.Add("Text", vueDetail, "service-order-number"); txtTaskID.DataBindings.Add("Tex...more >>

I have a connection to an iSeries table that I pull a customer number, name, and status into a dataset. I have two data grids on the form one has the dataset from the iSeries as its source and the other has the dataset from the Access database table as it's source. The Access table only has th...more >>

In ado.net I know I can execute a command and create a table using the appropriate SQL syntax (ie. CREATE Table. . .) This does not give much control or structure over how the table is created. From previous days of DAO I know there is a tabledefs collection, containing tables, which on turn...more >>

Is it possible with vb.net & ado.net to execute a local dts package stored on a sql 2k server? Can anyone point me to an article / howto that shows an example of this? Thanks in Advance. ...more >>

Hi, I have a strongly typed DataSet with 10+ tables, filled with data from a XMLDocument, and SQLServer database matching the dataset schema. How do I insert that data into the database with minimum coding effort using ADO.NET and the .NET framework? Thanks (jbx01) ...more >>

I have read how one can define tables, indices, relations etc. in .Net code in a way that allows you to run a off-line XML based ADO.NET, which is excactly what I need. I have also read about Typed Dataset and how this definition is stored in an XSD file. I was wondering if these two tec...more >>

Dear, I'm using Microsoft .NET Provider for Oralce, but it's time consuming on large scale record by using OracleDataAdapter. Code Snippet: - DataSet dataset = new DataSet(); OracleConnection conn = new OracleConnection(); OracleCommand myCommand = new OracleCommand(); OracleDataAdapter a...more >>

Hi, I'm in the design phase of a little database program in C#. But I don't know what database to use. The DB should be free, easy to set up, and easy to program up against in C#. I'm using VisualStudio.NET 2003, wich I have a Certified Partner licence for. I have never used ADO before, and I...more >>

In y C# project i'm trying microsoft solution to rotate rows as colums http://support.microsoft.com/kb/175574/EN-US SELECT YEAR, Q1= ISNULL((SELECT AMOUNT FROM QTRSALES WHERE QUARTER = 1 AND YEAR = Q.YEAR),0), Q2= ISNULL((SELECT AMOUNT FROM QTRSALES WHERE QUARTER = 2 AND YEAR ...more >>

Hi. I have a DataSet with two tables, and I setup a view (using defaultView) on one of the tables within the DataSet. All with strong typing. Here the 3 lines: ppDS.HPerson.DefaultView.RowFilter = "fullname like 'test%'"; int row_count = ppDS.HPerson.DefaultView.Count; foreach (ParamP...more >>