| Redundant data question (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm writing a WinForm application that will have circle objects represented by graphics circles. The user will be able to drag the circles around and specify which circles should touch other circles, i.e. their relationships. Each circle object will have a name, description, and size. The set of circles can be persisted to a file in the form of an XML dataset. In the GUI the user will see basicall... |
|
| Simple quesion about Views in SQL-Server (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I wonder if it is possible to create a View over lets say 4 related tables in SQL Server 2000 and use stored procedures to Select, Insert, Update and Delete records in the View instead of doing so in each table. Is this possible? If yes please give me a simple example to guide me in the right direction :) Thanks for any help in advance Ali Eghtebas, Sweden |
|
| Get table names from SQL Server (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is there some SQLDMO like way to get a list of database names from a server, and a list of table names from a database via ado.net or some other .net class library? Thanks, John |
|
| Unique Constraint in Strongly Typed Dataset (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| When generating a strongly type dataset using the SQLDataAdapter, only primary key constraints defined in the SQL Server source table seem to result in unique constraints in the generated datatable. Source table unique constraints other than the primary key constraint don't appear to result in unique constraints in the datatable. So, how can you use the dataset designer to add non primary key uniq... |
|
| Timeout? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi! Is there a query timeout for the SqlClient? How do I set it? Erik |
|
| SqlTransaction Exception: ..has completed; it is no longer usable. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've got some code that establishes a transaction from a classes connection object and is used across several command objects that are used in a few class utility functions. I had this transaction object working perfectly before but somehow my unit tests are failing and I have no way to backtrack what happened. All I'm getting now is an exception ("This SqlTransaction has completed; it is no longe... |
|
| Do you really have to specify the sql data type for the parameter.. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| When declaring Parameters for my command object for my stored procedure. Do you really have to specify the sql data type for the parameter.. Arrg!? Also, do you have to specify it in the sproc as well? Dim p1 As SqlParameter cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 16, "Description") |
|
| running stored procedure (Oracle 8i) (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have problem with runnig stored procedure. Procedure has 2 parameters (input parametr as Varchar2, input/outpup parametr as Ref Cursor). How can I do it ? I'm using C#. Thank you .. Peter |
|
| Dialog box to get all the connection string info from user (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Folks, In ADO, there used to be a function call to have ADO/MDAC display the basic / standard dialog box to get the user to provide all the info about what ADO data source to connect to (things like server, provider, initial catalog etc.). The same dialog pops up when you double click on a .UDL file. Can I still get this standard dialog using .NET and ADO.NET ? If so: how. (still haven't found it.... |
|
| Testing for null fields (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Using VB.NET with a Dataset... If I try to assign the value of a null field to a string, I get a runtime error that says "Cast from type DBNull to type String is not valid". Yet if I try to test the field for Null, I get a compiler error that says Null is no longer supported, use System.DBNull And If I use System.DBNull, it says I can't use that in an expression. So... HUH? How do I test a databas... |
|
| Sort based on Parent (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm trying to sort a DataView based on a Parent table value. But I just get an error every time. Simple Customers Orders scenario. I have a DataView (dvOrders) attached to the Orders table. There is a relationship between Customers and Orders (CustomersOrders). When I try doing: dvOrders.Sort "Parent.City"; or dvOrders.Sort "Parent(CustomersOrders).City"; I get an error message saying something li... |
|
| Returning key field value for an insert statement (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Forum, I have made an application where I use the ADO recordset.addnew method to insert new record in some tables...my problem is that its very slow on large tables. My statement is as follows: Set rsAnalyseRequest New ADODB.Recordset rsAnalyseRequest.CursorLocation adUseServer strSQL "SELECT * FROM tbl AnalyseRequest" rsAnalyseRequest.Open strSQL, Conn, adOpenDynamic, adLockOptimistic rsAnalys... |
|
| using SqlCommandBuilder -Urgent Help (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Guys, When calling a stored proc from ado.net, i have two options for setting the parameters. 1. I can create a SqlCommand object and set the datatype and parameter direction with in the source code. But that will bea kind of hardwiring the stored proc parameter names and datatypes with in the source code. What if my parameter name changes. Then i have to change the code, compile it. Advantage ... |
|
| Exception while adding relation to Relations collection (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have been trying to add a relation to a dataset so that I can have a master/detail relationship between two datagrids. I used the xsd designer to define my tables and the data will be stored in an XML file rather than in a database. When the code executes this exception gets thrown "Parent Columns and Child Columns don't have type matching columns." I have checked the xsd over and over and over.... |
|
| SQL Server Security, as seen from VS.NET (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi. I am completely stumped... Could you please help me ? 1. I am trying to open a connection to SQLServer 2000, on the same computer, with a simple simple code: Private Sub Page Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conPubs As SqlConnection Dim strConnection As String strConnection "Server MYSERVER; uid Administrator; pwd alex; database pubs" con... |
|
| Adding Column to Typed Dataset (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it possible to programatically add a column to typed dataset. I am doing the following and get no error or column?!??! myTypedDS.table.Columns.Add("COLUMN", Type.GetType("System.String"), String.empty) |
|
| Data Adapters: Keep in DataLayer, or Create Dynamically (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm creating a .net application with a data layer which holds variables for DataAdapter and DataCommand objects. I have 50 plus DataAdapters currently in use. My question is, am I doing this right? Should I just be creating the DataAdapters and DataCommand objects dynamically, ( each time a database query is made )? Many of these DataAdapters fill typed datasets, so I don't know if DataReaders... |
|
| Select statements after an Update statement (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I really don't understand the usefullness of including a Select statement after an Update statement(such is done automatically if you allow VS .NET to configure your SQLDataAdapter). I do understand that if you are changing or adding rows that have field values assigned by the database(autoincrement, identity...) you will need to Select the rows again to get access to these values. Where do the ro... |
|
| RowUpdatedEventArgs.Status question (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I don't really see the difference between UpdateStatus.Continue and UpdateStatus.SkipCurrentRow ? I suppose there is one ! Many thanks for you answer. Jean Baptiste. |
|
| I need .haschanges to fire before changing .position (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I need .haschanges to fire before changing .position, can this be done? Situation is this. I ahve a form where CandidateExperience is bound to a ListBox with Value member ExperienceID (int autonumber). When you change index or value the bindingcontext (through code) change .position to the appropriate position. No updates are done on this form save for 2 conditions. The main binding Candidates .po... |
|
| DataSet.ReadXml() (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi everyone! I'm trying to populate a DataSet Object from an Xml Document. This XML is a valid instance of the following schema: ?xml version "1.0"? xs:schema xmlns:xs "http://www.w3.org/2001/XMLSchema" xs:element name "tabelle" xs:complexType xs:sequence xs:element ref "zeile" minOccurs "1" maxOccurs "unbounded"/ /xs:sequence /xs:complexType /xs:element xs:element name "zeile" xs:complexType xs:s... |
|
| Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have this error when trying to update my dataset. Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information I've created a table call FIB with a primary key xfield CREATE TABLE "informix".fib ( xfield Integer, yfield Integer, PRIMARY KEY (xfield) constraint "informix".fixpk ) I'm using ODBC accessing Informix database. I... |
|
| Transactions and Rollback (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm new to ADO.NET. I'm using VB .NET and SQL Server 2000. I'm using the SqlDataAdapter control with the Stored Procedures generated by its Wizard to Select, Insert, Delete and Update rows in the database tables. Regarding this approach, I wonder what is what is the best way to control the transactions (with Begin Transaction, Commit Transaction and Rollback Transaction) in my application? Can... |
|
| Concurrency violation with sp data source (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Using the Datapoints MSDN example as a basis I have attempted to change this to use a stored procedure as a data source with edits of the resulting datagrid then being used for update of a single table. The example works fine with a single table as the source and destination but fails with a concurrency violation if the data source is a stored procedure using many tables/joins and the target is a ... |
|
| Stored Procedure, ADO.NET (VB) Error handling and generating error messages. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm using VB .NET and SQL Server 2000. I'm using the SqlDataAdapter control with the Stored Procedures generated by its Wizard to Select, Insert, Delete and Update rows in the database tables. I have altered the procedures to be able to send back the @@Error as an output parameter to the client VB application and also to manage transactions. Now what I wonder is how can I in a smart way handle... |
|
