I want to append data into Sql Server from xml file in tree step 1. A user uploads an xml file in a Web Form 2. A Dataset object read the xml file with the ReadXml method. 3. The Dataset append its record into SqlServer one by one in a loop. But can we insert all data in the DataSet once...more >>

Hi, I'm porting a VB 6 app to .Net, and wanted to use an XMLDataDocument to store information that had previously been kept in XML Recordsets. Unfortunately, I'm not too familiar yet with .Net's XML Namespace and was wondering if someone could help with something....in the VB 6 appl...more >>

Hi all, I am using DataSet to store Sql Server Data in my ASP.Net application and use it in several .aspx forms by saving it in Cache. In one of the forms, I need to filter one of the tables in DataSet and display the result in an Editable grid. I do this by creating a DataView by filterin...more >>

I am trying to create a DataSet with DataRelations. The problem is I don't want all the rows in the related tables. A sql statement of what I'm looking for is: SELECT ParentTable.*,ChildTable.* FROM ParentTable INNER JOIN ChildTable ON ParentTable.inner_package_size = ChildTable.inner_packa...more >>

I've seen people have this issue before, but it has always been = intermittent for folks. Mine isn't (some students do work, but several = cause the exception every single time). What goes on is that I try to = pull up data on a student, but when DbDataAdaptor.Fill is called, I get = the excep...more >>

We are having problems where connections in a connection pool are being exausted. We are using the Microsoft Application Block SQL Helper class and are seeing the failure in the following method: public static int ExecuteNonQuery(string connectionString, CommandType commandType, string command...more >>

I am getting data from a SQL Server 7 table and binding it to a grid. I have a field that is supposed to represent a date, and two fields that are supposed to represent time. When I look at the grid the date value is just the date (because I guess I didn't enter a time, but just a date), but t...more >>

The DataTable has a column containing integers. Filtering it as "Where ColName=12" filters fine. Here is the problem. I want to filter the integer column using "Like". For a string column the following will work "Where StrColName Like '12%'". I need the same effect on the integer column. ...more >>

At work, we have built a Director object that fires off processes. Any number of jobs can be run at the same time through its own Director instance. Currently, there is a philosophical discussion about either passing in a Connection String or a Connection object to the individual processes. ...more >>

I am noticing that the methods in MS's data application block are all shared. Any implications for performance with this? Seems like if users are sharing methods, we could take some sort of hit if they are accessing the same methods. Thanks, Dan ...more >>

Hi! I'm developing an application using informix DBMS and .Net. I came across following problem, when I form a query with too many clauses in WHERE part and try to execute it with Fill command I get an exception "Connection is dead". Removing one of the clauses creates no problem at all. I have ...more >>

Hello, I am trying to merge into a dataset and It fails with the following exception. I would like to know what table is causing this problem. It looks like one of the data columns names is the source of the problem. I thought I could catch the merge failed exception but it is not raised. ...more >>

I have an Oracle SPROC which takes as one of its IN parameters a table array (e.g. type charArray is table of varchar2(255)...) How can I call that SPROC and pass it the table array from ADO.NET? Thanks. ...more >>

I'm having a hard time finding something explicit which indicates whether Max Pool Size is intended to mean 'maximum number of connections within a pool, where distinct connection strings means distinct pools' or 'maximum total number of connections which can be pooled, regardless of how many di...more >>

Hi, I have a protected Access Database (with different tables) and an user with different permisions for every table. How can I get the user's permisions for every table? Daniel ...more >>

I have noticed this problem coming up in newsgroups before I have a slightly different variation on it. I have a dataview (dv) that I am filtering: e.g. strFilter = "EndDateTime >= '" + txtEndDateFrom.Text + "')"; dv.RowFilter = strFilter Now, on my computer and one one of my servers this ...more >>

Hi I am new to sql server ce and am trying to get my head round how to develop using sql ce as opposed to sql server 2000. I want to develop for hand held devices using windows mobile. The vs.net 2003 ibuyspy compact framework sample runs fine on the handheld when compiled and run. My problem ...more >>

I am trying to figure out how to get the events for a table to NOT fire. Please take a look at the example code below. No matter how I do it the event still fire. What am I doing wrong? Please someone respond, this is killing an arch. design in a application I am working on. DataSet ds = ne...more >>

Hi, I used OleDb.OleDbDataAdapter to retrive and modify the access i used merge function to combin another dataset, then update Access DB but i can't update the database by using pDataAdapter.Update(ds_data) the result is always 0 Here is my code '''''''''''''''''''''''''''''''''''''''''''''...more >>

I am starting a .NET project and am wondering if anyone has experience with using ADO.NET to access a SQL Server 7/NT server. If so, were there any issues? ...more >>

I'm using VS.Net 2003 and C# to write an app that connects to an Oracle 9i database. I have a button on a form that takes username/password/service name information, creates a connection string and issues an open command. From time-to-time, I get an error "ora-12154 tns:could not resolve ser...more >>

I'm using a bound control, a textbox bound to a column in a dataview. Despite setting the AllowEdit property to False, changes in the text in the textbox are saved to the dataview and underlying dataset. When using the update command of the dataadapter these changes are saved to the database...more >>

Hi, What's the best way to reload a DataSet? I have a DataSet object with multiple tables in it, I would like to refresh a table(reloading the data from sql server) in this dataset when a user click a refresh button. Thanks for your help. david ...more >>

Hello All. I am using a strongly typed data set in a C# application. Some of the tables contain columns that are computed values by means of the Expression attribute in the data schema. I get the above exception on an update via the data adapter. I have seen some references to this problem as...more >>

I need to obtain an mean value of Width column in a Dataview. I can walk through the Dataview (see below). How do I extract the values from Width column in the Dataview so they can be added together? Would it be better to use a datatable? If so same question. Dim dt As DataTable = ds.T...more >>

I have a DataSet with 3 named DataTables. What is the fastest way to create a new workbook and spit each DataTable to a new worksheet? Thanks. ...more >>

Hello, I am new to this and i am experimenting with Datasets and ADO.NET. I am trying to go smooth so for now so I created all my Adapters and Datasets etc. visually. However when i simply delete one of them from the visual panel, under my form, and then i create another one with a different ...more >>

Here is the SQL statement that I'm trying to execute INSERT INTO Tbl_NameCharacter(Character, Code) VALUES('Rebel Generic', 'Rbl') My database has a table name 'Tbl_NameCharacter' it has 3 fields, the PK is an autonumber 'CharacterID' the second is a 'text' field named 'Character' and the ...more >>

sql server / ado.net / vb.net What is the better approach to populating a subset of table data to a datagrid or form of controls - a view or a stored procedure?...more >>

Hi all, Visual Studio Enterprise 2003 and DotNet Framework 1.1. I have a strongly typed dataset (generated by the Schema Designer). This dataset has a table called Category and one of the columns in this table is called "ParentCategoryId". There are no explicit relationship set between ...more >>

Hi all, Can anybody kindly tell me the connection string for password protected access 2002 database.. I am using the following one but getting error dim CN as new OLEDB.oledbConnection cn.connectionstring = "Provider = Microsoft.JET.OLEDB.4.0; Data Source = \\server\Costing\costing_2004_05...more >>

Hi, I connected to a protected Access Database using an user and password. How can I add a new user and how can I set his permissions for each table from Database. From Access this is very simple. Tools->Security->User and Group permisions... Thanks, Daniel ...more >>

Hi, I am a total loss. I have VS 2002, Microsoft Oracle data provider and Oracle 10g client installed. I am trying to open a connection but keep getting a system.exception error. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I have Oracle 10g installe...more >>

I have seen a few threads mentioning this problem, but none of them have offered a solution that works for me. I have an application that creates an OleDbConnection to a Microsoft Access 2003 database. When the application is done with the connection, I call the Close() method on the connectio...more >>

i recently encount a strange problem. first , i successfully insert a record to db, but when i try to update this record, i always get a DBConcurrencyException exception. but when i change "using System.Data.OracleClient" to "using Oracle.DataAccess.Client", everything is OK. To make t...more >>

After retrieving a table from SQL. I wanted to add a column to the table with a record id. After retrieving the data and then I add the column and set the following properties: dt.Columns.Add("NewColumn", GetType(Int32)) dt.Columns("NewColumn").AutoIncrement = True ...more >>

Hi all, I'm creating my first "real" Windows Forms application. I'm having some = difficulty binding a DataView to my custom control. I can do it just = fine if I bind directly to the DataTable, and it behaves as I want. = (Multiple controls on the screen, each one bound to a different row ...more >>

I'm trying to use fill a table using DataAdapter::Fill with a Oracle procedure or function result. When I call a SP (with a simple select query) from SQLServer I don't put return value on the Command's Parameters. There's any way to do the same with Oracle database, but without passing the ...more >>

Hi, I have the following method, which sends an array of integers to another method. The array is obtained as follows: 1. Select rows from a datatable where boolColumn has been checked in a datagrid. Dim dRows() As dataRow = myDataTable.Select("boolColumn = True", "", DataViewRo...more >>

I am a newbie to both .Net and Sql Server and I am trying to access the database by using the ADO.Net data reader. This is actually one of the execises in a book that I am reading. However, when I run this program, there is an error saying that "Login failed for user 'sa'. Reason: Not associat...more >>

I have an application that is using Microsoft's Data Access Application Block in a WinForms Client/Server configuration. Recently, we have been having problems where an application is timing out and throwing an error stating that the connection pool is exhausted, requiring a restart of the appli...more >>

Hi We have an access db running on a windows 2003 server. The server is connected to the internet via ADSL. I would like a windows mobile 2003 based vb.net app to sync data from the server, ideally via gprs, from time to time, the pda and the server have the same info. What is a good way to go...more >>

Hi there, Just curious if you can issue a bulk update command on records in a DataSet table, i.e. Update fields in a certain DataTable with criteria that picks the Rows, and Delete Rows from a DataTable with criteria? Currently, I'm looping around the Rows in the DataSet's DataTable and upd...more >>

I'm currently using .NET version 2003. I want to be able to retrieve records. How do I do so using the OleDbDataReader? I want to be able to retrieve records using a selected choice from the combo box. Only when the user has made the selection does the form display the relevant details to that...more >>

Hi, I have a SQL table with over 100,000 records. I have a stored procedure that return this record set to me(vb.net client), and i then display these records in a grid. The problem is that dataset waits for all the data, before the grid control can populate with this data. Is there away...more >>

How to create a DataView by a specified row or rows? That is to say, when a row( or rows) are specified, is it possible to create a DataView which just includes this row (rows)? If not possible, is it possible to create a DataView, which only includes the parent row, by a specified row a...more >>

We are connecting to an Oracle 8.1.7 database using System.Data.OracleClient. Executing SELECT statements is easy. Modifying data is a cinch. Calling Stored Procedures was no problem until I tried to call a stored procedure with parameters. Calling a stored procedure with parameters genera...more >>

I am trying to run an insert statement against a table, and I get an error: "Can not insert explicit value for identity column in table "table name" when Identity_Insert is set to off." Now, in the set up of the table, when I populate it, I set the Column in the columns collection to be an ide...more >>

How can I extract a DateTime value from a Dataset in Asp.Net page to a DateTime field in code behind ? Here is my c# code: 1. Dataset ds=new Dataset (read by MS/Data Application Block) and was successfully displayed on the Asp.Net Data grid control. 2. DateTime dt=Convert.ToDateTime(ds.Tab...more >>

Hi! I have DataGrid bound to DataTable. I create DataTable "on fly" when application start without database connection. I use datagrid only to create simple XML-file for other purposes. Question: DataTable contains "Time"-column, and I need to get time into it automatically of the moment...more >>