| How to prevent delete operation in DataAdapter ? Or, how to get child rows from deleted row? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have parent child 2 datatables with database trigger set on "delete cascade". When I delete row from parent table, trigger deletes all related child rows. Here is a problem: After I deleted parent record and I'm calling DataAdapter.Update() on child table I'm getting an error: "Concurrency violation: the DeleteCommand affected 0 records." Because it already deleted by trigger. So, I tried many m... |
|
| SQL Desktop Engine and ADO.NET question (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I recently installed MSDE and the .NET QuickStart tutorials. I'm trying to write an app that uses the Northwinds database installed on my local host. As I understand it, I should be able to drag the database from the Server Explorer to my form. Is this incorrect? I've also tried dragging the SqldataAdapter object from the tool box to my form and opening a connection that way, but the wizard... |
|
| Looking for a good book (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I was browsing both the Amazon and Barnes & Noble websites looking for some good books but there appears to be *so* many and it's hard to tell which are going to be good or not. I'm looking for one or two *good* books on the subjects of ASP.NET and ADO.NET together. E.g., using ASP.NET on the front end to communicate with a back end database via ADO.NET. I'm hoping to find a mid level type of book... |
|
| Strong types (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi friends, Could you please tell me or assist me to get a suitable link describing the difference between strong typed objects [datasets] and ordinay objects ? [datasets] Thanks in Advance Emmanuel Mathew Outgoing mail is certified Virus Free. Checked by AVG anti virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 Release Date: 27/06/2004 |
|
| Multiple statement execution via ADO.NET (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi: Is it possible to execute a complete script with different commands in one execution under ADO.NET? If so, with which component and how? Do I have to separate statements with 'GO'? TIA, Martin. |
|
| SqlConnection performance issues (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Where can I go to read about performance issues when dealing the sql connections in ADO.NET? Specifically, I am looking for some place that discusses the pros and cons of using a single connection vs. using multiple connections. We are wanting to write a wrapper class that handles all the specific SQL functionality and we'd like to read more (good, specific) information on sql connections in ADO.N... |
|
| Transaction Question (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Can someone explain to me how the transaction object works behind the scenes? I am currently using it in my updates and it works great. I was curious how the rollback works and the update (added, modified and deleted rows) actually are changed at the time of call to the dataadapter or when I commit the changes? Thanks |
|
| OleDb connection to SQL connection (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have an OleDb connection string to an SQL server provided by the Data Line Properties dialog. What do I need to do to convert this OleDb connection to an SQL connection. Can I just remove the Provider property? Sam Matzen |
|
| Storing objects in SQL Server table (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello. I need to store custom objects in a SQL Server 2000 table. Which is the easiest way to do it? Do I need to write methods to store each attribute separately from C# app to the table and the opposite as well? Regards, Diego F. |
|
| Overflowing a DataView's RowFilter (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Greetings, I'm trying to let my users dynamically filter records from a table that relate to other tables. RELATIONSHIPS: [CustomersTable].[CustomerID] [OrdersTable].[CustomerID] [SalesRepsTable].[SalesRepID] [OrdersTable].[SalesRepID] There is a Many to Many relationship between CustomersTable and SalesRepsTable. On my Windows form, I basically dump all the SQL Server column names as text boxes a... |
|
| Syntax for convert in ado.net (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a dataadapter that I pass a sqlcommand to, which has paramters. I have the following sqlcommand on my page: SELECT * FROM tbl Changes WHERE (CAST(@column1 AS nvarchar(20)) LIKE @Criteria1) and have the following code to call this sqlcommand in my webpage: cmdSelectNone.Parameters("@Column1").Value "Change Status" cmdSelectNone.Parameters("@Criteria1").Value "%" & txtSearchCriteria1.Text & "... |
|
| SqlServerCe VarBinary Question (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I need to fill a VarBinary Field in a table with 19000 bytes (depends) The Documentation says that the field can only be 8000 bytes long, and if I change it to anything over that I get an exception. There must be a way I can do this. Help Appreciated, Best Regards, BM |
|
| excel question (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| i have oledb connection with this string "Provider Microsoft.Jet.OLEDB.4.0;Data Source C:\Downloads\sase2.xls;Extended Properties "Excel 8.0;HDR Yes;IMEX 1"" and work fine with normal *.xls file but when file is saved as web page i get error initializing connection. What i need to do to read that excel document? thx |
|
| Does anyone know if there is a replacer of ADOX in ADO.Net? Thanks, (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| . |
|
| Visual Studio 2005 Beta 1 is out there! ADO.NET 2.0 included :) (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I hope you won't mind if I spam this newsgroup with a little announcement: Visual Studio 2005 Beta 1 is available! The Express editions are available for public download, and the full version is available for MSDN subscribers. Get more info and download from: http://lab.msdn.microsoft.com/vs2005/get/default.aspx This beta contains the 2.0 version of the .NET Framework, including all the new ADO.NE... |
|
| Calling Clear() on empty dataset produces strange behavior. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have the following situation which I use often, but now produces strange behavior: I have a class derived from a typed dataset. In this class I defined a method Read for reading data from a web service. As the Read() function can be called often, I first clear the dataset with Clear() Then I merge the dataset returned from the web service with the cleared dataset. Now the first row of the merged... |
|
| empty DataTable fields throw exception (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm having some trouble with a typed dataset that contains fields that should technically be considered null. I've loaded my typed dataset from SQL server. One particular table contains only one row. It has two fields: Agency and CaseType. In the SQL Server table, the Agency field has a value, but the CaseType field is null. In my typed dataset, I can read the Agency value, but any attempt I have ... |
|
| ADO.NET connection Pool question (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| i have read a article : "Als o remember that each .NET assembly gets a unique PID. This means that each new assembly you run gets its own pool ªregardless of the similarity of function or the fact that their ConnectionString values are identical." URL: http://www.winnetmag.com/SQLServer/Articles/ArticleID/38356/pg/3/3.html as above , my web application with many Assemblies will maintain many diffe... |
|
| ADO.Net Connection Question (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, What is the best way to test to see if a MS SQL DB is running? Does it throw a specific error when trying to connect to it that I can catch? I am trying to design my application if the db server is offline to save the db info locally. Any ideas? Thanks |
|
| Oracle function returning a value (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I need to pick up the retyurn value from an Oracle function. Is it modeled as an output parameter ? |
|
| Problems after installing Sharepoint Services (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Recently, we installed Sharepoint Services on our test server (Server 2003) to try it out. I made a new web for my regular aspx pages. My problem is that now whenever I try to access my old pages, it prompts for a username and password for that server. I want it to allow anonymous web requests from this server. (Anonymous is checked off under web properties already). If I click cancel on the U... |
|
| Exceptions in IConfigurationSectionHandler.Create() (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I'm writing my own custom config section handler. Since I'm parsing my custom part of web.config in Create(), I'd like to throw some meaningful errors if a user has made a mistake. However, no matter what kind of exception I throw, the ASP.NET application will always show some generic error message, such as: "Exception in configuration section handler" Is this by design? Thanks. Oleg. |
|
| Problem with DataGrid focus (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I am using the windows.forms datagrid and binding 2 datagrids to 2 different DataTables from a single typed dataset. The DataTables have a parent child 1 to many relationship. When saving the data to an XML file (using dataset.WriteXML()), it gets written incorrectly sometimes. Basically, my XML file should look like: ParentTable ParentCol1 stuff /ParentCol1 ParentCol2 stuff /ParentCol2 Ch... |
|
| Cannot connect to sql server over the network. (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| This is really weird. Basically I have the website(asp.net 1.1, written in vb) and sql server 2000 running on my machine. I have to copy the database over to another server for testing. So i change the connection string to point to that database, and it doesn't work. I've tried it on 3 different machines now. Changing the connection string correctly each time. And nothing. But it always works when... |
|
| lock records for update: how? options? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I know ADO.Net recommand using disconnected update (optimistic concurrency) for good reasons, but it's just not an option for us. 99% of our client would rather seeing "record locked" kind of message up front when they load records, than being told "updating failed" after they spend all the time entering the data. So here I am spending a lot of time trying to find a good way to do the "read wi... |
|
