Hi I have a data adapter bound to a table. How can I loop through the table via and access each record's column values on the way? Thanks Regards ...more >>

Hi; I know SqlServer well but Oracle is new to me. I have a couple of questions as I get started: 1) Is there a sample somewhere of how to connect to OracleExpress on a remote computer and do a simple select. In other words the bare minimum to access the database. 2) Must the Oracle c...more >>

I have some legacy VB6 code that uses DAO (Microsoft DAO 3.6) to access an access 2000 database. In this app, Access is used soley for data storage - there is no UI component. I have converted the database to SQL Server 2005. Can I use DAO to access the new SQL Server database, or must I change ...more >>

Hi, I get above error when I use the find function on a bindingsource control. The datasource member of the bindingsource is another bindingsource control, where the datamember is a relational member of the datasource The field I'm searching on is absolut in the table behind, I can browse ...more >>

hi, I just downloaded Microsoft Enterprise Library June 2006 and try to integrate it into my asp.net application. As i am going to connect to mySQL database, I need to include the source code in my project so that I can debug better. But I all those examples I found are reference the compiled dl...more >>

Do you all like any books ... particularly VB 2005, VS 2005, WinForms, ADO.net? There are so many, I can't see the forest for the trees! ...more >>

Sorry if this is a basic question but I was wondering how to test the data being read back from a database. I am using a datareader currently and am not sure if that is the best route. In classic asp it went along the lines of setting up the recordset and testing the recordset information as it...more >>

I have to use either sql server or oracle databse in my application. The front end application in vb.net. ...more >>

Hi, I wrote a very simple program to test concurrency with sql server 2005. I used the VS 2005 dataset designer wizard to create my dataset and and tableadapter. When I ran the program, I used the debugger to stop the code before the tableadapter.update(row) method was called. I then ran the s...more >>

I was just curious if most people were using data-bound Web controls to display data rather than just display the info via code. I recall that old Visual Basic used to have bound controls but they weren't very good and no self-respecting programming made much use of this. I hear ..NET data-...more >>

I'm a programmer but not a database administrator and really don't want to be either. After a fair amount of reading and many problems related to SQL and related stuff, I finally figured out how to create a database in Visual Studio and enter some data into it. Now, I'm trying to make a Web si...more >>

I am writing an ASP.NET application that uses SalesForce data as the back end. SalesForce has a web service that exposes the data in their system. Unfortunately the ways that you can select data are very rudimentary. There is no way to do a join between tables in SalesForce and there is no wa...more >>

What is fastest way of accessing mysql by ado.net ...more >>

When we use the SQL to backup a database, we use: backup database Health to disk='c:\Backup.bak' with init This will generate a physical file in disk. Can we backup file to a Stream? ...more >>

If I create a database or attach a database file in the version of SQLServer that comes built-in to Visual Studio, the ConnectionString that VisualStudio automatically creates for connection to this database is a "file-based" connection ("AttachDbFileName=..."). Is there a way to attach a d...more >>

Hello, I have a Newbie question. I am using .NET 2.0 and C#. I have a data entry screen which has about 25 fields. Excepting one field, none of the others fields require inputs. My question What is the best method to insert the records to a SQL db - calling the SQL insert i.e. "insert into......more >>

Hi, How to determinate if an SqlServer instance existed in a Server? ...more >>

I have a table that is composed of an ID and two foreign keys. This table is used to relate two other tables. I'm using a dataview to display the data. The data can be edited, including changed, deleted and added. How should I set up the dataview columns so the user sees the choices from ...more >>

were can I get a music sharring service...more >>

My codes blowing up with the "Thread was being stopped" exception when I try to create a data connection. Here's the line of (MS VC++ .NET 2003) code blowing out: SourceConn = new IBM::Data::DB2::iSeries::iDB2Connection(S"DataSource=ANTIGUA1;DefaultCollect ion=EMBTEST;UserID=PCS;Password=PCS;")...more >>

Hi! I'm reading CSV-file using OleDB provider with SQL-select command and it's working fine. Anyway CSV-file contains "field" containing date values like 20060825, and I'd like to convert it into datetime format when reading it into DataTable like #8/25/2006#. How to do this? Propably I h...more >>

I'm using VB ADO.NET with Northwind database Employees table. I create a WinForm with a ComboBox (cboEmployee) to let user to select or enter full name and store it in strNames string array. I then try to get the matching Employee ID based on the employee name entered. However the ***SqlCo...more >>

Hi, I would like to build a monitor application that monitors the connection = pooling. I know that it is possible to use PerfMon for SQL Server, but I = would like to build my own to deal with other providers. Does anyone have any link to articles or any other information that I = could ...more >>

Sorry if this is a basic question but I was wondering how to test the dataset information as it is being read. ex, I have a table that contains file extentions such as .xls, .doc, ..ppt. What I want to do is test the dataset as they are being written and if the dataset is equal to .xls i want ...more >>

I'm new to ADO.NET 2.0 so I have some questions you may be able to help me with. 1. I decided to take advantage of Strong Typed datasets. Everything worked but I did not really like the way I had to deal with the TableAdapters. So, I went ahead and did NOT use the TableAdapters provided by ...more >>

I have a BO that must call 2 functions each function residing in 2 different DO. BO->DO1.Update1 BO->DO2.Update2 Let's say that each DO call point to the same SQL Server. Let's say that each BO is on my Appserver and the 2 DOs on the SQL Server. I want to make a transaction so I am assumi...more >>

hi, I am handling CSV files as database. each CSV got 40,000 - 60,000 lines. I have to do the joining, subquery and other complex tasks here. the problem is, my query execution time too high, 2-3 mins. how can I reduce the time ? I saw there is no way of declaring keys for CSV files in Schema.i...more >>

When I try to connect Oracle 10g db from windows 2003 server I get error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" On the Windows 2003 Server - .NET Framework 1.1 - Oracle 10g Client (I can connect with SqlPlus) I give privilege to Users,ASPNET g...more >>

Hi there, I am fairly new to webservices and C#and currently have a problem with updating data to a remote sql database from data entered into a local MS access database. The dataset I am using comprises of several tables. Once the webservice has the dataset some operations are performed s...more >>

I have a DataTable setup and want to be able to change the columns at runtime so I limit the number of rows returned. I know you can have have multiple queries within a DataTable but they return empty columns which I don't want (or is there a way to stop empty rows being returned?). I guess...more >>

Hello, I am receiving a System.NullReferenceException error when the ImportRow is executed. However, as you can see there are rows in the table and I can see the data in Rows(0) in the dsetTempPlaceInfoFromPt.Tables("Places").Item.ItemArray of QuickWatch. Thus it is not null. The dSetP...more >>

If I create a simple collection with say 20 columns and 5000 row and a DataTable with the same and serialize both, the DataTable file is at least 2 times the size as the simple collection. What is all the overhead with the DataTable? -Joe ...more >>

We are moving our software to the web using ASP.NET 2.0 and are researching ways to enable our software to connect to multiple databases, specifically Oracle, SQL Server, and ASA. We have used ODBC in a client-server environment in the past, but have now stumbled upon Provider Factories in .NE...more >>

Background - VB.NET v1.1 SP-1. Query Oracle database using Microsoft .NET provider for Oracle (System.Data.OracleClient). Exception is thrown using both get data methods: 1.) OracleCommand.ExecuteReader() 2.) OracleDataAdapter.Fill() Problem - A certain query which happens to contain a Gr...more >>

Hi all, in the process of migrating from 1.1 to 2.0 i´m experiencing massive performance losses within the database access to a oracle database (same effect on 9 and 10) the following code is built in 1.1 and 2.0 (except the stopwatch of course). The 1.1 application is finished in less th...more >>

I program using ADO.NET and plan to generate a crystal report. Can DataSet or DataTable be the "DataSource" for a crystal report (just like DataGridView) which simplify display of rows and columns? What make up the data source for crystal report? Replies are appreciated... -- Message po...more >>

I use asp.net to restore a SqlServer database. I use the code: Restore database MyBase from disk = 'c:\xxx.bak' with Replace But after execute, it display an error message: Restore fail, the user did not have the previllage to RESTORE DATABASE 'MyBase' How can I do? ...more >>

Hi, When I install Sql2005 Express in Win2000 pro, it failed with : This system did not have the correct version of MDAC installed. Which version is needed for Sql2005 Express when installed in Windows 2000 professional? ...more >>

Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by default if the connection string is always the same? If not, how does one go about evoking connection pooling ? ...more >>

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.Common; namespace trial_a { public partial class Form1 : Form { ...more >>

Way back in the old ASP days, it was possible to open a Database connection by providing only the name of the ODBC DSN that I'd created earlier. I didn't need to indicate which driver, whether the connection was to SqlServer or something else, etc. It looked like: Conn = Server.CreateObje...more >>

Hi, I am coding under .Net compact framework and using System.Data.SqlClient connect to MS SQL server through PDA USB cradle. I can execute stored procedures and sql select or updates statements. But I always get NullreferenceException when I try to use DeriveParameters function of SQLCommand...more >>

I have created a DataSet out of an SQL Server DB. In the server, there are several 1:1 relations, in the graphical representation of the DataSet in Visual Studio, it seems as if there were just 1:n relations. Why? Is it a bug in VS 2005 or is it impossible for an autogenerated DataSet to under...more >>

Dear All, I am using Oracle Client 8.1.7.0.0. My .Net (c#) console application makes a connection to Oracle database and has following code Console.WriteLine(DateTime.Now.ToString()); OracleConnection NDPConnection = new OracleConnection("User ID=<Username>;Data Source=O801;Password=<Pass...more >>

HI, this is my query, I am using C# , OleDB, ADO.NET and CSV files. SELECT [GATEWAY],[IPADD], SUM(MOBILE),SUM(NWD), TOTAL FROM [rawdata.csv] where CVDate([START]) >= '7/29/2006' AND CVDate([END]) <= '8/23/2006' AND [GATEWAY] IN (SELECT [GATEWAY] FROM [gateways.csv] WHERE [CLIENT]='MR. XXX') ...more >>

Hi, How can I avoid hardcoding the name of the DataKeyField property of a DataGrid ? Like: datagrid.DataSource = someSource; datagrid.DataKeyField = "employeeId"; The above works but it's not what I want, because whenever the name of the field changes, I'm screwed. Avoiding this is th...more >>

Hello, today I installed the Microsoft SQL Server 2005 Standard Edition but after insatallation I can not find the SQL Server Management Studio (Enterprice manager) Need I to install it separately? Regards, Alfred M. ...more >>

Hello, I have big problem on updating an Access Memo field with OleDb. While the InsertCommand works, then UpdateCommand raises an exception: Syntaxerror in UPDATE-Statement. I tryed various work arounds (the last 3 days) with and without the CommandBuilder with allways the same result. ...more >>

Hello All I'm using this query Select Distinct(prj.Name) as PrjName, prj.oid as PrjOid From SITE61.PRJMGTProjectRoot prj, SITE61.CORERELATIONDEST ic, SITE61.PRJMGTDatabase pd Where prj.oid=ic.oidTarget And ic.oid=pd.oid And pd.oid= :plant_oid and getting a data-reader like this: D...more >>

Hi all, within an SQL Server Analysis Services project we are using an assembly to retrieve dimension permissions based on data stored in a adminstration database. Currently we store the connection string used to access in the administration database within the assembly: Dim locCon As N...more >>

I've searched and tried a few of the things I seen but nothing really helped me. I am in visual studio 2003 and using visual c++. I created a table by typing in the data inside the IDE. Inside the load event for the form I added rows to the table ataRow *myRow; myRow = dataTable1-...more >>

I'm calling a stored proc from C# and the call includes a datetime. The exe can run on machine A or B but the database is on machine C. When I run on machine A I need SET DATEFORMAT dmy in the proc or I get an 'out-of-range datetime value' message. I need to comment this statement out when ...more >>

i am creating a Datatable in memory and would like to save the DataTable as a new table in the database when i am done. How can I do this? thanks m ...more >>