1) I generated a Subselect query in MS-Access which works fine there: SELECT (SELECT Name FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerName, (SELECT Surname FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerSurname, * FROM PlannedGames This Subse...more >>

Ihave an application (.Net 1.1, wi2k3 SP1, SQL 2005) that works fine after severalminutes of browsing then I start to get the following error : Servor Error in '/myVirtualServer' Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. Thismay have occured b...more >>

Hi! Does anybody know the best way how to export a DataTable to a dBase 3 file? Regards Stephan...more >>

I have a small ASP.NET 2.0 application that needs to be able to kick off a long stored procedure (for importing and processing tables ) and then allow the user to continue with the session, perform other tasks, and log out without having to wait for the SP to complete. I read the following artic...more >>

Hi - Does anyone know if the xmltype oracle column data type is supported in system.data.oracleclient? ---------------- Sal ..NET 2003 Oracle 9i ...more >>

Hi I'm trying to run a queries on a schema, and I keep getting ORA-00911: invalid character error. If I copy/paste it in SQL/Plus it runs fine. This is what I'm doing in code: //Set session here to ZGK037_MDB string sqlSession = string.Format("ALTER SESSION SET CURRENT_SCHEMA={0}", oDB.D...more >>

Hi, I was wondering when to use TableAdapters (TA) and when to use DataAdapters (DA). If I've got a typed dataset containing multiple related tables, I would say use a DA to fill the dataset. Why should I use TA instead? I can imagine situations where may be just one table from the datas...more >>

Is there some way to cast a IDataParameter to a SQLParameter? It's not working and I'm not sure why. ...more >>

I am using OracleConnection to connect to Oracle 9i Database from a VB.NET project the connection string has the parameters "User ID", "password", and "Data Source". my project import System.Data.OracleClient I tried to add connection pooling parameters like "Connection Timeout", "Incr Pool ...more >>

We're building some very high performance database applications, and are trying to use all of the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the BeginExecuteCommand, but without the...more >>

I am connecting to a remote SQL Server database from Visual Studio .NET 2005. I have an sql script located on my machine containing the sql code I want to use to create several tables, and want to execute it. How can I do this from Visual Studio .NET 2005? I do not like designing the database ...more >>

I'm trying to run a query to return all of the customers who have not placed an order. This query runs fine in Query Analizer but when I try to run it as part of a table adapter it returns all rows (customers with orders AND customers without orders). It appears that the second select is not...more >>

Hello, I'm using databindings to display data from a datatable. When I first fill my datatable, it works perfectly, and displays the current data. If I remove the datatable, and recreate it with new data, it's not working anymore : the displayed data are from the first fill of the Datatabl...more >>

Visual studio 2003, MySQL database, MySQL odbc 3.51 driver Is it possible to create the file dataset.xsd programmatically? I'm trying to create my dataset1.xsd file for using with crystal reports. The database is mySQL and the data connection is sat in my server exporer bar. The tables and...more >>

Are there any tools around similar to MSSQLs DTSWizard for importing data into a DataTable? The DTSWizard has many nice features which I would hate to recreate if it's already been done. Thanks, Joe ...more >>

My MSDE database uses Application Roles. When I run my asp.net application I cannot open the database, I get a Logon Failed exception. I need to be able to open the DB to run the sp_setapprole stored procedure for my role access. Is there some other way that I can do this? So far the only ...more >>

I am using ado to connect to active directory in a web application. I create the command: objConnection = new adodb.connection objCommand = New adodb.Command objConnection.Provider = ADSDOObject objCommand.Properties("Page Size").Value = 1000 objCommand.Properties("Search...more >>

I am a developer with limited database and zero crystal report experience. I am very confused. We wanted the ability to switch database providers easily, so I selected to use ADO components with our application. The database we're developing with is MySQL. I downloaded their MySQL Connecto...more >>

FW: 1.1 What is the best method for trapping timeout exceptions? There does not seem to be specific exceptions thrown for connection or command timeout. Should I check the message for "Timeout", or is there some other propery in the exception that better identifies a connection or comman...more >>

Hello: I have a SQL question. If this is the improper board to post this question on, please let me know where you would suggest I post it. I have a SALES table with the following schema and structure. ID Status Date -- ------ ---- 1 Open 1-1-2000 2 ...more >>

Hi all, I want to do the foll. I want to get the process running in the name system, with name "abc", and in turn get their arguments, so that i do some processing later Foll. is my code: Process proc = new Process(); proc.StartInfo.FileName = "notepad.exe"; proc.StartInfo.Arguments = "...more >>

Hi, We are developing a small web interface to a local ERP software, which uses SQL Server 2000 as database. The database uses SQL_Latin1_CP1 collation, and the fields are varchar (not nvarchar), however, the main program inserts and reads non-English (Turkish) characters into these columns. Ho...more >>

I have this a Data Set. In that data set I have three table adapters, each has there own queries. For some unknown reason, after I added two new fields to the database and mofified the store procedure to retrieve the new fields, in addition too the other fields it already retrieves, and fina...more >>

hi, i'm using db2 v8.2 and .net 2005. i'm trying to execute db2 commands but i can't . forexample, i can't get list of aliases or i can't create a new database. how can i solve this problem? please help me. ...more >>

Hi, My case is, i am trying to kill a process (SQLPLUS process) in my Win. Service, when either the Service is stopped or when my app exe is killed from the Task Manager. The problem is, when i kill the SQL process, its not getting killed, and its running and running. I find this in both t...more >>

Hi, I used a commandbuilder for my DataAdapter. i have a dataadapter "Pather" and a dataadapter "Sons" in "Pather" table i have and identity field that i use in "Sons" table to join them. How can i know with identity number i have for my new "Pather" row ? How can set my "sons" rows wit...more >>

Hey everyone, I want an advice. I want to build a site as an internet application using database etc. Since I need to use database , I'm interested in something not expensive for my own needs. I thought about using sqlServer, but I know that it is very expensive. Though I thought to use Acc...more >>

We upgrade our database from 2000 to 2005. So I use the new connection string in our newly developed web app. "Provider=SQLNCLI;Server=server_ip;Database=db_name;UID=username;PWD=password;" I got this error: The 'SQLNCLI' provider is not registered on the local machine I want to know, if...more >>

Hello, I am a newbie in C#2.0, as I have read, the application automatically generates a configuration files to store the connectionstring in (.XML file). So after compiling, everyone can see this sensitive infomation (username, password). Pls tell me how to make it "hidden" from user and how...more >>

I'd like to use the command builder to create update queries but my database schema uses datetime columns for the last time modified instead of a timestamp. Unfortunately ConflictOption.CompareRowVersion seems to only work if a timestamp exists. The update command seems to be rewritten by the ...more >>

Hello, I have a complex query on sqlsrv2000 that runs better if I use an intermediate #temp table. I have tried using a dataAdapter, Command Object to da.SelectCommand.CommandText = "Select * Into #temp From tblx" da.SelectCommand.ExecuteNonQuery But I get an error. The goal is to t...more >>

I want to create a simple procedure in Oracle that returns a resultset (a select query). In all the examples I've seen, you have to pass in a "ref cursor" OUT param into the proc from C#. Is there a simpler way to do this? IWO can I not pass anything in, and just declare the cursor in the proc...more >>

How can I get email data by email address from Exchange Server into a vb.net web application? The exchange server is on the same network as the web server. I basically need to be able to display what emails were sent to/received from based upon an email address, with the date, subject and ...more >>

Hey all, I'm trying to pass a parameter into my Stored procedure to be accessed by my data adapter into a dataset db2.AddParameter("@intClientID", cmbClientList.SelectedValue.ToString()); DataSet rsDataset = db2.Fill("spListMappingDetails", CommandType.StoredP...more >>

Hi, I'm still strugling with the following situation. I've got two table which are related by a foreign key contraint. These table reside in a typed dataset. I working on a webbased app, so a disconnected environment. Now, when I add a row to the parent table and add rows to the childtable (th...more >>

Hi, I have a table that contains an interger primary key. I want to query the table for rows that have values equal to a list of ID's that I specify. The sql that I would use would be something like the following: SELECT FunctionalGroupId, ReportId FROM FunctionalGroupReportXRe...more >>

from what I read & tried, DataGridView was meant for Window Forms, not for ASP/Web pages... correct? While I can use it to display data, I can't seem to figure out how to edit the cells... I'm not looking to put edit buttons on each row... I'll go back to regular window forms before I creat...more >>

I am working on an application where the end user will select the type of datastorage to use (SQL, Oracle, Access, even Excel for some readonly data, and maybe more providers ) The application reads/writes data and even must be able to create tables in databases (or even create databases) as ...more >>

hi i know in the VS 2005 when we use data access and binding there is no locking for data as before cuz its disconected but i wonder is this the standard now ? i mean when i make a query i will always be sure that maybe some recoreds out side my query will be modified by another user an...more >>

In vb6, I used getrows to load data into a multi-dimensional array. Since ADO.NET doesn't have getrows, I've succesfully loaded the same data into a datatable. How do I reference the data in the data table as a multi-dimensional array for (row and column), or load the data into an array from...more >>

When I run the code below in Visual Web Developer 2005 Express, I'm getting an "Unable to find the requested .Net Framework Data Provider. It may not be installed." error. I've been researching a fix for the past two days without any luck. I've tried completely uninstalling both VWD and SQL Se...more >>

I have a database ASP program that works off a centralized server. Now the client wants me to put it on laptops using SQL Server 2005 Express. I can do this but do not know of any way to protect my AP code from being viewed and stolen. Is there any easy or not too time consuming way to do thi...more >>

i'm creating a WebUserControl that overrides the RenderContents method, on that i generate the HTML to the writer. here the problem is that on the html code of the page i've one more tag that i doesn't whant <span>! What can i do to remove this tag from the renderes results? Overrided Metho...more >>

I've gotten quite comfortable using a DataReader to grab a single value from a table as in the following: Public Shared Function IsUserAdmin(ByVal strNUID As String) As Long Dim dr As SqlDataReader Dim conMembers As SqlConnection = MembershipDB.GetMembershipConnection() ...more >>

Re SQL Server 2005 Express Edition When I attempt to back-up the master file, I get told it is being used by another application. So the file cannot be copied for back-up. This is even the case after a complete shut-down of the PC. What is the solution to this? ...more >>

Hello everybody, When I saw this new DataColumn.DataSetDateTime property for the first time I thought myself: wow, what a good idea! Perhaps ADO.Net seamlessly converts UTC to local and vice versa, so I will be able to store dates as UTC but display as local! All that just specifying DataSe...more >>

I have a talbe, there is a smallDateTime field in it. I want to update this filed with a today's date. I want to make s sql like "Update myTable set dateField = {0}" I can I replace the {0} in the sql? ...more >>

Dear How can I select multiple checkboxes and update it to database at a single click on update button.The GridView allows to edit only one row at a time so for each row I have to select edit and than select checkbox and then click on update. How can I select multiples checkboxes and update ...more >>

All, Is it possible to use the same (strongly typed) DataSet object with an Oracle table adapter (or data adapter) and a MS-SQL table adapter? It would be nice to use the same dataset object so the calling code can use only one dataset and not use one for each database type. Thanks in a...more >>

Hi, Im pretty new to ADO.net and I ran into the following problem: I try to add a row to a DataSet that has NotNull-Constraints on its columns. When doing: DataRow row = ds.Tables["docdescriptors"].NewRow(); DocTypeDB dt = new DocTypeDB(row); NpgsqlCommand command = new NpgsqlComma...more >>