An article in SQL Server magazine mentioned in passing that we can open MDF files directly with ADO.NET 2.0. Is this true? Are there any examples/tutorials of this? Does this mean that ADO.NET 2.0 is kind of like a scaled-down in-memory version of SQL Server? -- Bryan, Emperor of String.E...more >>

Hi, I am using VS2005 (C#) and SQL Server 2000. How can I make sure that: 1. Client A queries info from database and displays it in a list view or other controls on a form. If Client B changes some of this info that is displayed by client A, clint A gets its info updated 2. If clint B...more >>

Ok I'm confused on this... in T-SQL Say I have TableA and it has no select permissions on it for the user... but the user has a stored procedure with execute permission on it and contents of it is SELECT * from TableA... well of course this executes! and returns the TableA contents... where do...more >>

Running a VB.Net console application that uses data from a VB.Net webservice. Both the data sent and received are accessed with strongly-typed datasets. With dsMapping ds = WS.WorkOrdersForReprint(StoreId) .EnforceConstraints = False .Merge(ds) End With The...more >>

Hi I am a new to VB.net, I am using access as my database I am trying to show some tables in Vb using Datagrids, I am able to add rows to the table and update those changes to the access file, but when i try to delete rows its not being updated to the database, Any help will be appreciate...more >>

Hi I need to implement cascading delete between related tables. I can do this in sql server (2005) or in the dataset in my application. But what is the best solution when perfermance is important ? Thanks Rolf ...more >>

Hi, I'm developing an ASP.NET web application with MySql 5. I have a little problem: if i create a stored procedure like this one: CREATE PROCEDURE `spProva` (out retval int, in idemployee int) BEGIN UPDATE employee e SET e.Room = 'Milan 41' WHERE e.IdEmployee = idemployee; SET retva...more >>

Hi, I am using the SQL data reader to access SQL2000. I am opening the connection and executing the reader then closing reader and connection. There is an example code: SqlDataReader sqlReader = null; tring storedprocName = "procName"; SqlConnection sqlConn = new SqlConnection(connString)...more >>

I have a C# application in which I am allowing users that are members of sysadmins on SQL Server to create publications. The first thing that happens is the application sets up a loal distributor on the SQL server if one doesn't exist and then tries to set up a merge publication. The command...more >>

Hi, I have a table in SQL Server 2000 and accessing it in ADO.Net , I want to know fields width and I gave following VB.Net commands but I am fail to know it, it returns -1 for all columns. Dim col as data.datacolumn For Each col in ds.tables(0).columns ' ds is a dataset Console.Wri...more >>

I am using asp.net to build a scalable application. I am using data caching and I want to know whether the following situation can arise If concurrent users check the cache and finds that data is not there then they all will try to get the data from the database which is not required . ...more >>

I would appreciate some help, or direction, in understanding two things about using the DataAdapter's update method. The first issue I have is the DataAdapter and Table need to be declared in the same procedure as the three commands. Usally, this is done at the begining of a Web Form to displa...more >>

Since upgrading my project to .Net 2.0 i've been getting the following error on occassion: "InvalidOperationException was unhandled" followed by "Internal .Net Framework Data Provider error 1." The error happens when I call SqlConnection.Close(), but not all the time. The error can h...more >>

Hi, How can I update my client imediatelly if database info has changed? Example 1. Clinet A (win forms app in C#) has displayed on its form data retrieved from database (SQL Server). Client B adds new info or edits existing info of data displayed on Client A. How can this change be immedia...more >>

I am writing an application that populates a database from text files. I have an insert command which works fine, however, it overwrites anything that was in the database before. Looking for a little help: (the database starts off empty) Here is my code: Dim x As Integer = rtf4.F...more >>

Hi, I'm using a dataset close to 11 MB as the datasource for my reports. I've 15 subreports in my report, of which two uses this dataset as the datasource and the rest uses the same dataset, but have Selection Formula applied to the report document to filter the data. I get a Out of Memor...more >>

It is clearly stated in MSDN that "The .NET Framework Data Provider for Oracle does not support batched SQL statements". Are batch updates going to be supported anytime soon? Is anybody successfully using ODP.Net to execute batched updates against Oracle? TIA ...more >>

So what I'm trying to do is Create the table tblToLoad which i have done, then use fill schema to create the proper columns based on strLoadTable (which is a table name that is passed in via command line ) Then later in my program insert a datarow into the table. However I receive an error o...more >>

From within a FormView control, by looking at a particular column in my FormView, I can determine the "service type" of any particular record. Another table in my database will tell me how many "categories" that "service type has" (it's dynamic...different service types have a different numbe...more >>

If it need to close DataReader after read? I am study the Data Access Application Block for .Net Framework2.0 form http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlibjan2006_dataaccessappblock.asp I found the the DataReaders in the examples are not close explici...more >>

Hi, My previous post may be too confusing. This is the idea of my doubt: To do one single SELECT-type query, or one single INSERT-type query, I have no problems. To do multiple queries in a row, which objects can I reuse? Do I need to instantiate a new connection (MySqlConnection) object,...more >>

I've looked around and haven't found a usuable solution to this issue. I hope that you can provide me with some assistance. I have a application that calls for the user to select a database/table to view data from. At that point a datagrid populates with the information. This works fine except w...more >>

Hi, Using dataadapters, I got the follwing question: Given a DataSet with two tables (lets call them HEAD and ROW). As you can imaging, there is a foreign key constraint indicating that every ROW entry must have a corresponding HEAD entry. So far so good. Now, I fill a dataset with thes...more >>

Hi Developers, I am a .Net developer of a Large Online Retailling Company. I would like to have your help on a Connection Pool issue. Recently we have developed a Web Application on ODP .Net to work with Oracle Database 10g. To gain the performance, connection pool enable is a must. Everyth...more >>

Hi, I'n using VS2003 I.m using two typed datasets. One of them has stopped supplying intellisense methods: e.g. dsLocation.Locations.Clear(); // ok, intellisense from Locations tbl provided dsDepartment.Departments // Doesn't provide intellisense from the Departments table. If I ma...more >>

If I create a DataView(i.e. dv) with a particular RowFilter and Sort, I realize that I can't use a For Each to delete those rows because each deletion changes the current view. So that this won't work: dim drv as DataRowView for each drv in dv drv.delete() next If however I coll...more >>

Has anyone in her got experience with O/R Mappers for dotnet? Some of the requiriments could be -Enterprise level -Caching strategi -Stability -oracle support I have been looking at the following: http://ibatis.apache.org http://msdn.microsoft.com/netframework/future/linq/ http://...more >>

Hi! I'm trying to check in the OnFormClosing event if the dataset has changes that are still not commited and if yes to display a dialog box showing a question if the user wants to save tha changes or not. I test it with dataset.HasChanges() but it returns true even only when i change the record...more >>

Hi All! How can i delete or insert a record without using the bindingNavigator control? I can move through the records with the binding source but i can't find out how to delete and insert records.... Any tips? Thanks! ...more >>

Not sure if this is a MSDE or Visual Studio issue, but here goes: I have MSDE and SQL Server GUI tools installed (GUI from Developer Edition) to support database app development with Visual Studio .NET 2003 (VS 2003). I have the sample databases installed (pubs, North, etc.) via an executable ...more >>

Can you use sql server commands like this dv.RowFilter = "datediff(d, OrderDate, getdate()) >= 2850 " in a row filter? or will i have to do it another way? thanks! ...more >>

Hello. I call myOleDbDataAdapter.Fill(myTypedDataset, "MyTableName"); after i set value of column not mentioned in DataAdapter. myTypedDataset.MyTable.Guid = Guid.NewGuid().ToString(); this column is not included into any key or relation. after i fill dataset again. myOleDbDataAda...more >>

Hello, I have an sql statement problem that I hope one of you could help me with. For a little backgorund info, I have two tables in my SQL Server 2000 database. One table has distinct part numbers and descriptions. The other table has many rows of the same part numbers and additional inf...more >>

Hi, I'm just learning how to create a 1 to M with ADO.NET. I've created this little test app. A user selects a company name from the list, then clicks a button containing the code below. The code is meant to return all the child rows of the related parent row that has been clicked and dis...more >>

Hi! I have a Typed Dataset dsPersonal1 and i try to update the database after i edit a row in a datagrid bound to the dataset. Afret I execute personalDataAdapter1.Update(dsPersonal1) the dataset is updated but not the actual database.Can anyone tell me what am I doing wrong? I'm usinf Visual...more >>

Hi Folks, I am using Access and OleDb in ADO.NET in my application. Basically, my app allows users to view the db and add new rows to it using DataGrid control. My unique field in the table is a AutoNumber field. When i try to add a new row through the datagrid and then invoke DataAdapte...more >>

I have a table TableB which holds references to table TableA. I have one process Process2, invoked by another process Process1, that deletes all records in both tables and then repopulates them, all in a single transaction. It then notifies Process1, which in turn reads the new data. My pro...more >>

Hi, Currently, I have one database for Intranet clients on the server behind the firewall. But I was asked to allow the extranet users to access the same data. From the security perspective what is the best way to make that data accessible. Should we have two databases one for Intranet a...more >>

Hi All, What is the good way to handle a string which contains characters like single quote (') or square bracket with LIKE ([]), while building a SQL statement. Right now iam searching these characters in the string and adding the escape chars for that. eg 1: (This will fail to search) ...more >>

Hi, I am new with ADO.net and MSDE. I work with SQL server, but our project requires an export to MSDE. Currently, my connection string is DbConn = new OleDbConnection("Provider=SQLOLEDB.1;Data Source="+strSqlServerName+"; Initial Catalog="+strSqlServerDbName+"; uid="+m_strDbUserName+";pwd=...more >>

I have a table that will not allow some values to be altered if the tuple being updated meets certain requirements. I have a stored procedure that individually updates each value in a tuple if the relevant parameter is not null (all parameters default to null exept the PK). In this way I...more >>

Hi, I need to join two tables in a 1 to 1 relationship. The tables are on two seperate databases. How can I do this? Thanks in advance for any ideas Ant...more >>

Hi, I'm using a text box's text changed event to autocomplete a datagrid as the user types in the search value ('A' returns many, 'Ax' returns fewer etc). The first few letters typed in take a while to populate the datagrid. Once it populates, there is no further problem, each new text ch...more >>

Hi, We are in the process of making product in windows forms that is localized presently for all european countries.We are supposed to support all eastern and western european date , time and number formats.However we are currently facing a problem that say a user in Italy uses our product ...more >>

Hello, I am having a wierd problem. I am using an OleDBCommand to insert a new row into a table on an Oracle 10g database. My Code looks like this bool result = ( command.ExecuteNonQuery( statement ) > 0 ); last night the Oracle Database was hung due to some issues with the file sizes...more >>

Hi, I've got a spurious problem that occurs when I'm running McAfee AntiVirus 8.0, but works fine when that is not running (& I'm disconnected from the network) My application is written in VB.Net, using .Net Framework 1.1 (with hotfix KB886903). My PC has lots of stuff installed on i...more >>

Are there any examples of how to correctly implement a class inheriting from DbCommandBuilder? I have not been able to find any examples showing best practices for doing this. I would like to implement a custom command builder class similar to SQLCommandBuilder. Thanks in advance, Ji...more >>

Hello, I am faced with a problem that may be simple to you. However I am stuck as to how to approach it. I have a table with employee information. This table needs to be dumped to an xml file in specific format. To be precise I need to create a SPML file. SPML is standard XML format for thin...more >>

I am a bit of a newb to .NET and C#, and I've been trying to make a data access class that will act as a buffer between my other classes and my SQL database. However, the data it's returning is wrong and I'm confused as to why. It's a very simple class, shown here: ************* namesp...more >>

I am getting a message when I issue a 'FILL' command. The message is: 'Failed to enable cinstraints'. I am not sure what this means, can someone explain what I have done wrong. -- Norm Bohana...more >>

Hi, I am new to .NET and I created a data adapter which generated the SelectCommnad, UpdateCommand, DeleteCommand and InsertCommand through the wizard. But what do I do with them? How do I use them, what are the methods to trigger an Insert, a Select, an Update or a Delete? Can someone explai...more >>

Hello, I have two different, but related questions. 1) In .net or ADO is there a way to make an insert by just passing new parameters to string. I am doing multiple inserts where the only difference is values being inserted. In unmanged code I could use sprintf to have my insert command ...more >>

I have the following scenario, and would appreciate some advice on the best approach to give the results I require: Simple example: ------------------------ 2 Datasets, the second cloned from the first: dsOriginal.Tables[0] has 2 rows (string, boolean) row 1: red, true row 2: blue, true ...more >>

Hi all... I have an XSD file that contains some tables and some relations. Let's focus on a table named "Role". This table has one primary key, named "RoleId", a foreign key named "ApplicationId" and 3 more normal fields, summing 5 fields in total. As a help for you, I show the correspondin...more >>

Hi such a question What SQL Server 2005 security principal replaces database roles? fox ...more >>

I use the new feature of TableAdapter. When I add a column in the designer, it appear in the last column. I can't find out how to adjust it's order. How can I do ? ...more >>