Hi I have the block of code below which is supposed to determine the number of rows affected with an update statement (ASP.Net, Access, C#, ADO.Net, OleDB) to determine if the update was successful or if a concurrency error occurred. There is an enumeration defined called DBResult where 1 is...more >>

Hello, Can you recommend a tool for making XSLT schemas. Let's say I have one XSD scheme, and I want to make another XSD scheme from the scheme 1, containing generally the same elements, but groupped in another way, omitting some fields, adding some others, making attributes from what was elem...more >>

I have SQL parameter that looks like this: cmdUpdate.Parameters.Add ("@invoicedate", SqlDbType.NVarChar, 40).Value = dr["invoice date"].ToString(); IT is updating a field in a SQL2K database. The database field is of type char and not date. The data in dr["invoice date"] looks like th...more >>

Hi there, I just set up my VStudio 2003 and tried to run a test of reading a character from database by using SqlDataReader.GetChar, but it failed. I got the following error message: ----------------------------------------------------------------------------------------------- An unhandled ...more >>

I'm adding a row to a table. The table has some columns with expressions. When I add the row I get an error: Additional information: Cannot perform '-' operation on System.String and System.String. Now the catch is I ONLY get this error when I call my server via remoting. If I call the same s...more >>

Can't add more than one row to table I am attaching a sample application The schema is based upon Chapter 13 of ADO.NET Core reference. It uses a currency manager for it's binding context. Here is the problem. The first form that opens includes a listbox of authors. There is a button...more >>

I'm using this code in VS .NET 2003 [code] Me.SqlCmd_BlacklistUpdateStatus.CommandText = "dbo.[SpamUpdateReport_blacklist]" Me.SqlCmd_BlacklistUpdateStatus.CommandType = System.Data.CommandType.StoredProcedure Me.SqlCmd_BlacklistUpdateStatus.Connection = Me.cn2 Me.SqlCmd_BlacklistUpdate...more >>

Hi, I use OleDbCommand to insert a new row to Access database. We reuse = instance of OleDbCommand more than one times.=20 =20 example: - The value of the first record is QueryID =3D 1 and = BooleanOperator =3D "And"; Add to database correctly; - The value of the...more >>

Hi, SqlCommand cmd = new SqlCommand("my_storedprocedure",con); cmd.CommandType = CommandType.StoredProcedure; The error is : type or namespace name 'CommandType' could not be found(are you missing a using directive or an assembly reference) I have included the following namespaces u...more >>

I am using ForeignKeyConstraints so that when I change a parent row's key, the child rows are updated with the appropriate key. The problem that I am running into is that I would like to be able to add a row to a table with a value that would not fit a stated constraint. So, I could add a ...more >>

Hi! I am trying to improve the speed of the app. Can you tell me if i need to use AddWithKey or not? Thanks. if (base.OpenDB() != System.Data.ConnectionState.Open) { throw new Exception("Unable to open DB connection!"); } string sSQL = "SELECT * FROM PROCESSCONTROLVIEW WHERE GROUP_ID = '...more >>

I am having an OleDBDataAdapter and a dataset. I fill the dataset with a row and execute Adapter.update(dataset,"Table Name"); Adapter.fill(dataset,"Table Name"); For the database table, my primary key is an auto number. Currently, I am fetching the key using: dataset.Tables["Table Nam...more >>

Hello, I've created a Dataset in code on my form based on an OLEDB provider also created in code. I want to be able to use this dataset in a Crystal Report, but the dataset is not listed in the report designer? I'm not sure how to resolve this problem, any ideas are helpfull. Thank yo...more >>

I have developed my web module project at my test machine under a different web path ex. c:\inetput\wwwroot\myProject and tested it. After it work find there I coped it to my real web site under the d:\inetput\wwwroot\script\myProject. How can I continue the develop the project under the n...more >>

We have a production web site that's data intensive (save user input to DB and query for displaying) with the ASP.NET app part on one W2K server and SQL 2000 DB on another W2K server. I have set up performance logs to log # of pooled database connections on the web server every 60 seconds (.NET ...more >>

I have a large SP that has various print messages throughout. I want to view these print messages from .Net. As such I wire up an infoMessage event handler to the connection. If executed using executeNonQuery it will return all messages fine. Using executeScalar, I only ever get the first ...more >>

Hello, I have a made client application that adds records to a database on a domain. Every now and then the database will create duplicate records. I have closely checked the code and have not seen anyreason for this to be. I am using parameters and using ExecuteNonQuery to update the da...more >>

Hi, Just curious. If you use the pagingsystem delivered with ASP.NET datagrid control ... will the system access the database each time you ask the next page ... or will all data be loaded into a hidden XML-file which will be used when going to the next page. If XML is the answer the...more >>

Hi, I'm creating the arquitecture of a N tiers application, at the moment I decided to use classes to inherit from Dataset in order to represent the Data Entities. However I hit the concurrency problem and I'm not sure how to prevent it (timestamps, sp, etc.) Can anyone recomend me a good s...more >>

I need to move through some records to get the first and last value of a field. The od days there was movefirst, etc in ADO. I know .ExecuteScalar() can get me the first record. But if I use a DataReader how do I get the last record's information for a specific field in that record? I've lo...more >>

Hi, I have the following query I run using SQL: Select Distinct col1 as D1, col2 as D2, count(col3) as CountOf from MyTable group by col1, col2 order by col1 I need to be able to get the same result without using SQL, by querying an off-line DataSet. XPath might be able to do the job,...more >>

I have VS.NET 2003 and also have BizTalk 2004 installed on the machine. Usually it is possible to add a DataSet to a project and then drag a stored procedure to the design surface to create a strongly typed dataset. With BizTalk 2004 installed the schema designer comes up as that from BizTal...more >>

Hello, I'm looking for options in handling a certain data situation. Data is stored in Oracle. There is a database that contains tables with common information. For example, it contains a table called USER_COMMON. This table has a key field (USER_KEY) and some other fields containing data (...more >>

hi, i am using 2 datagrids tied together with datarelations in a dataset. That part works great. i need to suppress the new row on the datagrid but cannot use the readonly properties on the datagrid so i can allow the user to check off on bool columns. I know dataviews can prevent it wit...more >>

Hi all! I am trying to apply a filter to a table in a dataset using criteria from a parent table, but I have no luck so far. Having a dataset with tables for Customers and Orders, and a relation between them, I wish to find the highest order for customers in a specific region. Creating a...more >>

I have a database with tables as follows FILM * filmID FilmTitle FilmLength FILMKEYWORD *filmID *keywordID KEYWORD *keywordID *Keyword * denotes primary key Keywords are simply text descriptors for use by a search engine. Films can have multiple keyword associations. ------...more >>

Hello friends, I have some problem in my ASP.NET connection 'Connection file code <% dim connstr connstr=("Provider=Microsoft.Jet.OLEDB.4.0;data source="&server.mappath("database/it.mdb")&"") %> follwoing error message occur when i execute the page Compiler Error Message: BC30451: Name '...more >>

Hi I have a Stored Proc in SQL server, which creates a record key when a record is created. I want to return the value back to my code, once the record has been created. I am using SQLHelper (Data Application Blocks for SQLServer), and calling the ExecuteNonQuery method in the SQLHelper...more >>

Hi All Is there a way to Execute a query (possibly including two tables and joins) on a totally disconnected dataset. By 'Totally Disconnted' , I mean there is no DB and there is no DBConnection / DBCommand - all the data and structure is in memory. The query is to be used to databind a grid,...more >>

I execute an SQL stored procedure that returns 5 records ("SqlCmd_SpamUpdate_spfBlackUnprocessed"). I then open a data reader, loop through those five records while calling stored procedures that does updates. The second SP needs information from the 5 records being returned. The problem i...more >>

Hello, Is there a way to connect to outlook's address book with ADO.net and fill a dataset with it? Any suggestions will be greatly appreciated. Thanks, Chuck ...more >>

Hi, I'm learning about three-tier programing and i want to implement this in a simple windows forms Application (not web), i'm using an Access 2000 Data Base, the objective of my application is to stores data from cd's into the data base, so i have 4 related tables, ("CdCategories", "Cds","...more >>

I have a table in 9.2 and a field as INT. When I use an OracleDataReader to query the table the field is being returned as Decimal. Being not to familiar with Oracle does anyone have an idea why? CREATE TABLE DWSDLAYERS ( LAYERID NUMBER, LAYERNAME VARCHAR2 (128), LA...more >>

I've written an asp.net application using ACCESS as the database. It works well first. But after a while, I found the application cound not make response to user's request quickly. It seems dead. You couldn't the ASP.NET page. Why? And how to solve the problem. Someone please help me. Here ...more >>

I have the follow asignment: txtDescription.Text = dtrSlb("slbDesc2") If the field returned is Null i get a run time error. I can check for if (dtrSlb("slbDesc1").GetType.ToString() = "System.DBNull") then .... But there has to be a better way. Aslo what's the best way t oget the length...more >>

I have a stored procedure that is being called from ado.net and it is failing with an exception that is related to the option ARITHABORT - 'UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'. This stored procedure works perfectly fine from query analyzer and ...more >>

Hi Guys, I was recently reading an article: http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/dnservic= e/html/service10012002.asp [Excerpt] "One of the most common types of I/O operations that occur within a Web method is a call to a SQL database. Unfortunately, Microsoft...more >>

Is it possible in ADO to execute a (select) stored procedure, but just return the number of records, not the actual data. My client has some stored procedures which if executed with certain parameters can return thousands of rows. I would like to execute a check prior to returning these rows a...more >>

I vant to receive group name by automaticalyy generated function FindByID_GROUP in VS C#. I know, that mentioned function returns string type value. What is wrong with this line? Why this exception occures, altrought I know that argument id_gropu is properly, and I am sure that the value in ...more >>

Hi, in order to know the primary key of a table in my dataset, i've the folowing code sql "select * from table1" create a dataadapter with this sql DA fill the dataadapter in a dataset DS DS.Tables(0).PrimaryKey but the expression returns me an empty array, is there any problem? is ther...more >>

Can someone share with me code for the following task please? 1) User clicks a button(button1), to bring up a file location window for the user to select the SQL Server 2000 and Pub database on the network(not onhis/her current machine so the user needs to create the correct path). 2)That user...more >>

I'm fairly new to .NET, so bear with me if this question is naive. But do most developers use the VS data controls for connections, adapters, and datasets, or do you write all that code manually? And if you use the controls, how do you wrap your connection and adapter code so that you can easi...more >>

I'm having a problem with my test server where I get the following message when i run a simple test app created in VisualStudio.net: The Microsoft Jet database engine cannot open the file 'E:\WebSites\DamarStone\db\damarstone.mdb'. It is already opened exclusively by another user, or you need...more >>

I am getting Null Exception error when I try to fill a dataset. I am providing a value for my parameter so I'm not sure, what's going on. Please see below..... Thanks Dim cmd1 As OleDbCommand = New OleDbCommand cmd1.Parameters.Add("@adate", OleDbType.DBDate) cmd1.Conn...more >>

hi, it seems, that a lot of people have the problem (including me), that isn't possible, to update a dataSet object with a gridview (without a data objet). does anybody knows something about this problem??? thanks. ...more >>

Where can i find simple Three-Tier Application Examples? Thank you. ...more >>

I create 2 tables, ParentTable and ChildTable. The row in ChildTable is referenced to ParentTable. But after updated and saved to database, the row in ChildTable doesn't refer to the correct row in ParentTable. You can see the following example to get the problems. Is there any good way to updat...more >>

I am doing a transfer operation from one database to another. During that time, I want to lock some tables so no new data can be written. How can I do this ? -- incognito...updated almost daily http://kentpsychedelic.blogspot.com Texeme Textcasting Technology http://texeme.com ...more >>

I'm trying to use the Select() method on a DataTable but I'm getting a NullReferenceException. Here's the stack trace: at System.Data.Select.Evaluate(Int32 record) at System.Data.Select.FindFirstMatchingRecord() at System.Data.Select.GetBinaryFilteredRecords() at System.Data.Select.SelectRows...more >>

Hi Group I have one column which can be either Null or with some value. I have one filter criteria in From End with "All", 'RTF Yes' and 'RTF No'. Depending on the filter selected by user i have to select the pertaining rows as below If Filter "All" select all rows from table if Filter =...more >>

Hi I am looking for a way to optimize my data storing into an Access 2003 Table (the mdb file I am using is Access 2000 version) oleDbDataAdapter seem to write one row at time even if it receives multiple rows I tried this code below CalBackFunc() <- My call back func is called every sec...more >>

Hi, I got a problem by putting 3 SELECT statements in one DataAdatper. I try to build a 'Select' DataAdatper, which only has select command. I put following lines in select commandtext Select * from Orders; Select * from OrderProducts; Select * from Products; I use Data...more >>

I've run into an odd bit of behavior when dealing with SQL Server 2000 and ASP/ASP.NET that I wanted to discuss. The issue I encounter is that in a stored procedure, once a SELECT statement succeeds and returns a recordset, all resulting errors are ignored by ASP/ASP.NET in certain cases (s...more >>

Can someone tell me why I can't use the data adapter to SQL server 2000 on my server using vb.net 1.1? When I try from my workstation, I get a good test connection message, but then VB will tell me the following message "Unable to connect to database. It is only possible to connect to SQL Se...more >>

Hello, I have an OLEDB DataAdapter and cannot create a Dataset to use with the adapter because the SelectCommand contains a parameter. Is there a work around for this? Any Help is appreciated. Thank You...more >>

Hello everyone, I am trying to get back the primary key and was using @@identity without any problem. However, when I use scope_identity() I get the following error. "Cast from type 'DBNull' to type 'Integer' is not valid." Please help. Thanks ...more >>

I'm trying to run a query that joins tables from 2 databases on the same server. The query is like this: SELECT TitleID, u.Name as Assignee FROM tblTitle t LEFT JOIN titlepost..Portal_Users u ON t.TitleProcessor = u.email When I put it in a stored procedure and execute the sp using SqlCom...more >>

I have an XML file I've created in another application that contains information on files, forms, and job header. My plan is, in my new "consumer" app, to read in this data and work with it, ultimately producing labels for shipping, etc. My planned approach is to construct a Dataset with 3...more >>

Hello, I have successfully been using the following connection string to connect via a SQLConnection object in my ASP.Net application for many weeks: Data Source=MARS-TEST;Initial Catalog=CascadeWMCClient;UID=marsweb;PWD=marsweb Today, after our Network Support Technician added a hard drive ...more >>

How do I copy a table from one dataset to another ? code I am using and that is not working : dataset2.tables.add(dataset1.tables(tablename)) Please help me. prashant...more >>

Hi all, That is a really bad, bad question, but some of us have problem with a application with more than one DB. Anyone here dev. the same app. for more than one DB? Why the best solution in the ADO.NET for that, thinking in time and cost, of course. In my case, for example, I have a ap...more >>

Hi I have a combo which is bound to a datatable. I want to remove the record from the datatable, which the combo points to. Can anyone confirm the correct syntax.... I believe it will be something like datatable.Rows.Remove(.......??how do I find the row that is bound to the combo??); ...more >>

Is there any way of using the ADO data wizards in a non-visual component? If you create a "web service" project, you drag ADO components onto a designer and use wizards, but I can't work out how to do this with a standard class library. Cheers. ...more >>

Hello, Is it possible when configuring an OLEDB DataAdapter, using the Query Builder, to specify parameters? I've tried placing =@parametername in the criteria section of the Query Builder, but this seems to always gerenate errors and then the Datasets won't fill. The datasource is a ...more >>

I am finding problems in trying to copy a databse table from one SQL 2000 server to another using ADO.net. However the source table has an identity column and I need to preserve the values in the destination table. Obviously every time I run the below code the destination table does not have the...more >>

I worte a conversion program which moves all data from SqlSrv to Oracle, using the OracleClient and SqlClient classes of .Net. Now when a column has 2001 characters or more I get this error. I've read a lot of it, but I do not fully understand what is wrong, and more important, how it can be s...more >>

MyGeneration is 100% free, tired of hand coding business objects, stored procedures, spend your time wisely doing other thing and let us help you. See http://www.mygenerationsoftware.com 1) MyGeneration is a Template Based Code Generator Supporting Four Template Languages - JScript, VBScrip...more >>

What is the correct syntax for passing a select statement via the Reader. The following code doesn't return anything. Dim strSQL2 As String = "SELECT * from ATable WHERE ' " & ComboBox1.Text & " ' = ' " & TextBox1.Text & " '" Dim cmd As New OleDbCommand(strSQL2, Conn) ...more >>

I have a situation where I have read only access to an Access database. I need to query the database and insert the rows retrieved into my own database. However there is no gaurantee that the original query won't return rows that I've already inserted into my own database. So my question...more >>

Hello, I have a file .SQL Containing a Script to Create Tables and Stored Procedure... Example : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_ADVANCED_SEARCH]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_ADVANCED_SEARCH] GO .........more >>

I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I don't think I made any changes to either page other than changing the user control that creates the ...more >>

Greetings I want to display a listbox on the form which will include two columns from the data table" FirstName" & "LastName" What I've done now, is modify the DataAdapter to include two additional colums as: [FirstName] + " " +[LastName] As NameFN [LastName] + " " +[FirstName] AS Name...more >>

Hi, I am using OracleDataAdapter to fill my DataSet. I am using Select Distinct in my sql querry to get unique recored. I am getting duplicate rows in DataSet. My SqlPlus shows only one row of Data. When I execute the code to fill DataSet My DataSet.tables[0]. rows.count gives me c...more >>

Hi all, I would like to have a functionality that saves/updates a given DataTable into the DB while its structure is unknown. I think of 2 possible solutions: 1) to use SqlCommandBuilder - which is very expensive in the runtime (performance issues) 2) constructing my own commands - iterating...more >>

Hi Can anyone tell me how can I send email through stored procedure in sql server ? I want to send attachment with this email too. TIA ...more >>

Hello All the samples I found are based on datagrid for the child table. What if I don't want the child records to be displayed in a datagrid, but in their own data bound controls like "text box, combo & list boxes). And I want to provide a second level of navigation buttons to traverse tho...more >>

How would I get the length of a column from a SQLDataReader? I'm looking for something like Query Analyzer uses to display its data. So, I would need to know that a varchar(200) is 200 where a varchar(20) is only 20. Also I need to know how many characters a datetime would fill up. This kinda...more >>

Hi, I have an Oracle 8.1.7 server and I'm extracting a Varchar2(length 300) using an aspx page and the field is always Null, even if it's not in the DB. I tried the EXACT same code in a windows form and it works perfect. Is there a bug in asp.net/ado.net with Varchar2 bigger than 256 char ?...more >>

using Data access application block for oracle, I try to pass a null value to the OracleDateTime to the store procedure. but I got an exception saying "this value si null", what am I missing here? shouldn't I be able to pass null parameters? Kevin ...more >>

Hi, I created simple dataTable (one field numeric, one string). Then I prepared dataConnector and put DataGridView on the form. In datagrid I can edit now numeric field but string field after post is clear (NULL value). Can anyone help? Thanks ...more >>

Hi, I created simple DataTable (memory table) object with two fields -numeric Id -string Name then I configure dataConnection and put on the form DataGridView. I bind fields from table to columns and now I can edit numeric column but when I try edit string column then it is after post event...more >>

In a SQL Server 2000 Database I have a Table which is shared by many users. I have a VB.NET Procedure which contains many calls to Stored Procedures and ADO.Net Commands to clear and update this shared table. What I would like to do at the start of this lengthly procedure is to place an ...more >>

Hi, I have been trying to connect SQL Server2000 developer edition using the following string. SqlConnection conn = new SqlConnection("server=localhost;database=pubs;uid=sa;pwd="); I dont know where i am going wrong. SQL Server Service Manager shows the following: Server : Hemant...more >>

Hi, I'm trying to create an archiving script, using the folowing query for all database tables insert into table2 select * from table1 (table1, table2 are 2 tables having exactly the same definition) The rpoblem is that the rows are,'t deleted from the table TABLE2, so the next time the u...more >>

Is anyone else out here working with Timberline version 7.x,8.x or 9.x and ODBC and .NET? If so any advice to offer? I am working with a number of older VB 6 applications that interface (mostly just read) Timberline data stored in a Pervasive SQL database that I am porting to VB.NET. Experiment...more >>

Hi, I now have 2 xml files with same structure first.xml <dataset1> <table1> <col1>aaa</col1> <col2>bbb</col2> </table> ..... </dataset1> 2nd.xml <dataset1> <table1> <col1>ccc</col1> <col2>ddd</col2> </table> ..... </data...more >>

I can build an interface for a master-detail database in about 5 minutes with vb6 using the data environment 1.0 reference. Does .Net have anything similar or must I define a connection, datadapters and the relational schema by hand? ...more >>

Hi alls I have a problem with a stored procedure : I use a CHARINDEX to filter a query and if I execute the query from sqlServer the charindex works fine but if I execute the query from my ASPNET application the charindex always return 0 (to test it I quit it from the Where to put it as a colu...more >>

G'day all, Being a fairly inexperienced programmer, I've never worked with= MDI Forms before=2E What I'm trying to do is open a Jet OLE DB= connection on my MDI Parent form (which is used to log in and= out with user name and password), and access this same= connection from the MDI Child ...more >>

does anyone have sample code of data being inserted to a table, then the last insert id is retrived and inserted into another table. The Code is c# and the database is SQL SERVER, NO Access examples or vb... Thanks for this... i just cant find a simple example on this identity problem, people...more >>

(Type your message here) Hi, I am trying to insert multiple rows using 'for' loop. It inserts first row but while inserting second row it gives error like "The variable name @name already declared. Variable names must be unique within a query batch or stored procedure" Please help me...my em...more >>

(Type your message here) -------------------------------- From: renu Friends, when I am trying to create a login page and connecting to the sqlserver database I am getting the following error ExecuteReader requires an open and available Connection. The connection's current state is ...more >>

DataSet is supposed to be an in-memory database=2E So is it= possible to fire a query on it=2E I want to fire a "Select" query= (with alises in it) and also a "Transform" (Crosstab) query=2E In= the current scenario I am putting things in an Access table but= for performance reasons want to ...more >>

I have a windows service that will insert records into an Access= database=2E Or at least that's the idea=2E The insert isn't= happening, but the code runs without raising any errors=2E When I= run the generated sql statement from a query window in Access,= the record inserts just fine=2E...more >>

I've used the Microsoft .Net Data Provider for Oracle and also the Oracle ..Net Data Provider . I'm issuing a simple select statement which would return a list of dates formatted as such 'MM/DD/YYYY'. The table is storing the dates in a field of date data type in the format of M/D/YYYY. There is...more >>

Hi, I got an error message - Operation is not allowed in this context. It said the error comes from the line objRS.Close() Anyone have any ideas why? Thanks a lot. Here is part of the code: Dim strConnectionString As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\test.mdb" objCo...more >>

Hi, I have the following VB.Net code snippet: While datareader3.Read .......... strsql = "select * from InspectionViolations where propTableID=" & datareader3.Item(4) & " AND inspIDCleared IS NULL" ConnViolPresent.Open() CmdViolPresent = New SqlCommand(strsql, ConnViolPresent) ...more >>

I need to retrieve automunber ID from source access table after inserting new row... I tried to do this by this way: gRUPATableAdapter.Update(dataSetGrafik.GRUPA); oleDbConnectionForID.Open(); OleDbConnection oleDbConnectionForID = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Da...more >>

I've been trying to track down a memory leak in a project and have been running around in circles for the past week or so. I've been using this as an opportunity to evaluate Compuware's devPartner, but unfortunately it seems to be doing more to confuse me than to help me. My problem can be ill...more >>

Hello I've few questions regarding ADO & C#: 1) Is it possible to view tata from multiple tables in the Datagrid control ? Most of the examples I see are only for 1 table. 2) In Comboboxes, can we display multiple fields ? For example in a Form of customers, we have a combo box to sel...more >>

Hallo people, is it possible to map the columns return by a sql select command to a DataAdapter to different tables in ADO.NET? I tried the tablemappings collection but got the following error message: "The DataTableMapping.SourceTable is required to be unique, 'Table' already exists in the c...more >>