| Logical n-tier design-Suggestions? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a number of applications devloped in VB6 using a logical n tier design. Essentially, an ID is passed through a business component to a data access component which returns a recordset streamed as XML between tiers. The data columns are exposed to the presentation layer as a set of properties on the business object. If an ID of 0 is passed, an empty recordset with a new row added is retur... |
|
| IsolationLevel = Browse? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am testing an ADO.NET application accessing AS/400, using an OleDb drivers from IBM. The IBM documentation does not cover ADO.NET, but I assume that the existing OleDb drivers should work with the OleDb classes in ADO.NET. The problem I am having is to get BeginTransaction and Rollback to work. The IBM documentation says that for ADO, one should use IsolationLevel adXactBrowse for Transactions t... |
|
| Selecting master records by value in detail record (8 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, formerly, I'd write: "Select T1.* From T1 inner join T2 on T1.id T2.id t1 where T2.group 1" T1 is the master, T2 the detail table in a 1:n relationship. I have 2 DataAdapters, one for each table, and a typed dataset that describes both tables and their relation. I use a Parameter for the n table: "where group ?". Before filling the dataset, I set the Parameter Value: bla("group").Value 1. No p... |
|
| XML Nodes Disappear when Moved (Code Attached) (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello! I have this problem. I've attached code of where I move a child element in an XMLDataDocument from one parent to the other. Ths issue is the attributes against which I match my XPath locations in finding the source and destination nodes. They disappear when I re insert the node ... I have no idea what's going on here. The code used for moving nodes are as follows: MoveNode("//xyz:Parent[xyz... |
|
| MAB ExecuteXMLReader Error (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to use the ExecuteXMLReader method of the Microsoft Application Blocks using an example from the documentation and I am receiving the following error: System.InvalidOperationException: There was an error generating the XML document. System.InvalidOperationException: System.Xml.XmlTextReader cannot be serialized because it does not have a default public constructor The error occurs at t... |
|
| two stored procedures needed to bind to single datagird (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have specifi requirement of two stored procedures needed to bind to single datagird. Acutally i want to display leave details of the staffs from one stored procedure and total leave taken by staffs from another store procedure for the manager to approve the leave. How do go about this. Can any1 pls help me or sample coding for binding two different stored procedure to the same data grid. tha... |
|
| SqlDataAdapter Error (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have SqlDataAdapter and DataSet. I have troubles with updating values in database. I can get data from DB. I want to use stored procedure. It is OK. Then I change one field in DataSet. When I try to update SqlDataAdapter, it throws following error. Stack Trace: [SqlException: Line 1: Incorrect syntax near 'spf Test Update'.] System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, Data... |
|
| update (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| When I tried to update the data back to the datasource using dataadapter.update method, it did not work with bound textbox control, but it is okay with datagrid. Why ??? Thanks in advance. |
|
| Invalid command sent to ExecuteXmlReader. The command must return an Xml result. (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I can't get round this problem, and I have not found a solution anywhere in the web. Firstly is it because I'm using SQL 7.0 and I can't use the "FOR XML" T SQL command? But surely this can't be the problem otherwise ADO.net would not be able to return XML data from non SQL 2000 sources which would make it a backward step from ADO 2.5... Any help on this would be massively appreciated.... than... |
|
| Finding a SqlDataAdapter Reference by Name (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a series of SqlDataAdapter controls on a form. Prgramatically, I need to execute the Fill method given the "name" of the sqldataadapter not the object reference. Since a sqldataadapter is not a visual control, I can't walk through the controls list in order to obtain a pointer to the obejct. So, given the string name of a sqldataadapter, how do a find a reference to the object? Thanks, Tom |
|
| ADO Connection Pooling (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| We migrated a big Web application fom VB 6 to .NET The application was a COM component running under the Transaction Server and uses ADO to access data on a SQL server. Connection pooling did work well in COM . Migrating from ASP to ASP is to big a a task to undertake now. In .NET Connection Pooling of ASP does not work right away: After a few hundred requests, we have 100es of active connections ... |
|
| Question about updating Master-Detail typed dataset thru DataAdapter.Update (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Same scenario as the question about default view for the detail table, different question though: I have a Master Detail typed dataset. I have been able to successfully populate it from a single stored procedure that returns the two tables and then create a DataRelation between the two tables. The pseudocode looks something like: myDataAdapter.TableMappings.Add("Table", "masterTable") myDataAdapte... |
|
| Best practice to secure connection string (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm looking for some best practices for securing my connection string to a sql server from a web application. I'm using C#, ASP.Net 1.0, and SQL Server 2000 Running in a dev environment I simply put the connection info in my web.config file .. something like this: configuration appSettings ! SQL Server 1 add key "DSN" value "server 192.168.168.10;database APPDB;user id userid;password userpassword... |
|
| Only update dataset when needed (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I notice in a previous thread how to do an update back to the DB of a bound textbox. Now, if I fire: myBind.EndCurrentEdit() from within: private void cboEntities SelectedIndexChanged(object sender, System.EventArgs e) { this.BindingContext[dsEntities].Position cboEntities.SelectedIndex; } will an update be done, if no textboxes have been changed? Is their somesort of dirty bit for that row? Also,... |
|
| sqlclient access SQL server got no data error (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| hey guys, have a question here. using the sqlclient to access SQL database and get a error said the datareader doesn't have any data, any idea? thx a lot. Pat. |
|
| Flexible update (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| So, I truly have a handle on the dataadapter updating. I'm using the command builder right now because the select queries are simple. My question now is whether I have the ability to specify which rows I want updated. Even if multiple rows have had data updated by bound controls, can I say just update row 3 for example? David B. Bitton david@codenoevil.com Diversa ab illis virtute valemus. |
|
| Tricked up Databinding (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am doing some databinding of controls on my winform. I'm using a combobox to control the position of the dataset. Ok, no problem so far. Now, I have another combo box that I populate w/ a seperate query which returns the contents of a reference table. Then, I bind the reference combobox as so: // entities string sql "SELECT * FROM EntryPageEntities"; dsEntities db.SqlSelect(sql); cboEntities.Dat... |
|
| Disconnected recordset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| In ADO, I can create a disconnected Recordset by setting the ActiveConnection property for the recordset to Nothing after it is created. Once the ActiveConnection is set to Nothing, the *.ldb file (I am using Access) is cleared and I can even rename the .Mdb file. If I am correct, this shows me that the recordset is disconnected. I am now converting my app. to ADO.Net and cannot find how I can cre... |
|
| Question about detailtable's default view in Master-Detail (7 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a Master Detail typed dataset. I have been able to successfully populate it from a single stored procedure that returns the two tables and then create a DataRelation between the two tables. The pseudocode looks something like: myDataAdapter.TableMappings.Add("Table", "masterTable") myDataAdapter.TableMappings.Add("Table1", "detailTable") ' won't fill unless I set this, get a constraint viol... |
|
| Typed dataset shared to multiple projects (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm creating a N Tier database application. I have those projects: DataAccess, BusinessRules, ClientWinForms and DatabaseSchemas. If you know what N Tier is, you probably know what are the 3 first projects. DatabaseSchemas contain a couple of typed DataSet schemas that are used to pass data between projects, and each other project is referenced to that project. But here is the problem. Column prop... |
|
| DataTable method LoadDataRow(...) (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, When using the LoadDataRow method I must supply a array of System.Objects corrosponding to each column. The problem is,how should I init an System.Object when the column is an autonumber. Documentation notes System.Object.Empty, but can't figure out how to use it ? something like: object[] objs new object[1] obj[0] new System.Object.Empty myDataTable.LoadDataRow (obj, ...); does not work. Can ... |
|
| HELP CONNECTING - Using SQL Server with .net framework and ASP (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have tried all three of these and still get "The page can not be displayed" This database was set up by the installation of .NET framework. I think I have the datasource correct as it is the name I see when looking at the sql server. Is there just a guest user ID I can use? Do I look at users? I am running Windows 2000 Professional (NOT SERVER). % set conn server.createobject("ADODB.Connection")... |
|
| Bug in VS.Net? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have defined a "global" varial in Global.vb and make the variable public. When I run my app. from without VS.Net for testing purposes and end the app. by clicking on the Close (X Button) in Internet Explorer, it ends the app. and takes me back to VS.Net IDE. At this stage, the global variable is not cleared and if I run the app. again, all codes that relies on this global variable will not be ex... |
|
| Join 2 tables using DataView? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Can I join 2 tables and bind to DataGrid (Windows) as a flat table? I can create parent/children pairs, but what I'd like to get is a joined flat table without parent/children navigations in my DataGrid. That's fairly easy for Access/SQL, but all tables are already in memory DataTable, so I wish DataView (or any other ADO.Net components) to do the task, without reading again from disks and having ... |
|
| Help, SQLAdadaptor Error ARITHABORT (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi with the SQLAdabtor Wizard I have create an update/insert/sqlect/delete datement. But if I will update the Dataset and store this in the database i become an error: Updated failed because the following SET options have incorrect settings :"ARITHABORT" Where I could set this setting! Thanks! Dot Net Guruhias Dot Net Guruhias |
|
