Schema problem with Strongly Typed dataset

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Proposed method implementation in a new generic data access component I've mentioned in other posts that I am creating a generic ADO.NET project. Version 1 is already done actually (see my signature, and read synopsis in docs) I am making alot of additions in version 2. One being the addition of a bunch of classes that form a "Gen" provider... (GenConnection, GenDataAdapter, etc...). In the constructor of each data object I'm adding an additional parameter specifying the "DbContext". For example the standard IDbCommand constructor... public IDbCommand() //creates a standard Command, must set properties separately In my GenCommand as proposed... /// <summary> /// This constructor will use the connection of the /// DbContext if it has a ConnectionString assigned. /// </summary> /// <param name="ctx"></param> public GenCommand(DbContext ctx) { _ctx = ctx; _cmd = _ctx.DbTemplate.Command(); if (_ctx.ConnectionString.Length > 0) { _cmd.Connection = _ctx.Connection; } } Do you think it is a bad idea to imply the Connection from the context? I require the context to be able to dynamically load the appropriate underlying provider (Sql, OleDb, ODbc, etc...). But should I also use it to imply the connection. If the user desired they could overide it and specifiy a different connection. However, for those lazy people, the context gives enough info to specify the connection. It behaves different than all the other providers, which is why I'm wondering if it is a bad idea? Any advice? Which would you prefer as a user? -- Michael Lang, MCSD See my .NET open source projects http://sourceforge.net/projects/dbobjecter (code generator) http://sourceforge.net/projects/genadonet ("generic" ADO.NET) Tag: Schema problem with Strongly Typed dataset Tag: 62830
  - 2
    - how can I get the path for the error ORA-01458 it is told on the microsoft web site that to resolve this=20 problem i must contact "the microsoft support service"=20 and they will send me the patch. THERE IS TONS OF MICROSOFT SUPPORT SERVICE... which one=20 must i contact and how much it will cost... I leave in qu=E9bec - canada (i speak french) thanks Tag: Schema problem with Strongly Typed dataset Tag: 62827
  - 3
    - Why is this login failing? I am using VS in conjunction with SQL Server 2000. I am trying to create a new SQLConnection but am getting an error message of "Login failed. Not associated with a trusted SQL Server Connection" I drag a SQLConnection to my components tray. In the Connection String property I say New connection. I give the server name (which is the name of my computer) and put the radio on specific name and password. I enter a user name of sa and a password of xxx. I click on the field "Select the database on the server" and get the above mentioned error, followed by "Login failed, Catalog info can not be retrieved". In the past I have solved this problem by going into SQL Server and in the Server, Properties, Security tab changing the authenication to SQL Server and Windows. My notes indicate that in the past when I've had this problem it was because the authentication was not set to mixed. However this does not seem to fix the problem in this case. Does anyone have any idea what's going on? Tag: Schema problem with Strongly Typed dataset Tag: 62826
  - 4
    - Record Locking? How would I go about locking records using ADO.Net? It seems that everything in ADO.Net is based upon opening a connection, retrieving data, and closing the connection. To keep the records locked, is it as simple as leaving the database connection open? ~Thanks Tag: Schema problem with Strongly Typed dataset Tag: 62817
  - 5
    - What is the best way to delete multiple rows Grid, DataAdapter, Access Source What is the best way to delete multiple rows bound to a datagrid without getting a concurrency exception. TIA Tag: Schema problem with Strongly Typed dataset Tag: 62816
  - 6
    - Connection String with Access Workgroup Info (mdw) I've searched through several forums without finding a definitive answer to this question: What is the proper syntax for a connection string that is connecting to an Access 97 db with workgroup security applied? I tried the following. I don't get an error, but it also displays NO results: Public Shared ReadOnly OleDbConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DBQ=c:\CORmandOTweb\NewSecure CORMandatoryOTList.mdb SystemDB=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UID=usern ame;PWD=anything" Also tried: Dim cnn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=" & System.Web.HttpContext.Current.Server.MapPath("/CORmandOTweb/NewSecure CORMandtoryOTList.mdb") & "; Jet OLEDB:System Database=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UserID=us ername;Password=anything") All help will be greatly appreciated! Lynnette Tag: Schema problem with Strongly Typed dataset Tag: 62802
  - 7
    - Concurrecy Error, anyone see what I'm doing wrong here ? This code takes the Person index drom the datagrid dgPeople and uses it to delete all the records from the dgEvents grid and underlying records. It works but i do get that concurrency message Case "Delete" Try 'open connection con.Open() 'Setup the Delete Command for events for this person DeleteCmd.CommandText = "DELETE * FROM [Events] WHERE PersonIndex = ?" DeleteCmd.Connection = con DeleteCmd.CommandType = CommandType.Text DeleteCmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_PersonIndex", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PersonIndex", System.Data.DataRowVersion.Original, Nothing)) Dim r As DataRow PersonIndex = CType(dgPeople.Item(dgPeople.CurrentRowIndex, 0), Int32) For Each r In tableEvents.Rows If PersonIndex = CType(r.Item(0), Int32) Then r.Delete() End If Next daEvents.DeleteCommand = DeleteCmd daEvents.Update(tableEvents) Catch ex As OleDbException MessageBox.Show(ex.Message) Finally con.Close() End Try Tag: Schema problem with Strongly Typed dataset Tag: 62788
  - 8
    - Installation of VB.NET Program Let's say now that I have my program finished. How do I go about writing a setup program that would install the required directories, and place my files where they need to be? For starters, I have my exe file, and two jpg files that I want to bundle in an install program that will just create a folder on the desktop, and then create those files automatically. How could I do that? Also, what's the difference between Build Solution, Rebuild Solution, Build ProjectName, Rebuild ProjectName? Thanks Jordan Tag: Schema problem with Strongly Typed dataset Tag: 62787
  - 9
    - ADO.NET xxxConnection best practice hello In my project i have classes whoes read,update , insert database for exemple in one method , i do 20 request which is best the practice ? a) open and close ADO.NET connection for each requests (using pooling connection but slower cause of .open() method ?) or b) open one connection for method , excute requests , close connection ( the pooling connection is use for the project and calls methods but not in each methods ) rq: my question is NOT for Execute multi request on one command , and NOT for using stored procedure thanks Tag: Schema problem with Strongly Typed dataset Tag: 62783
  - 10
    - many repeatable operations Hi I have in my project (C#) many operation such as add, update, remove record from table. How to automate this. I don't wan to use grid. Are some code generators or something else to get this. The best for me is dialog with fields to fill in and verification of filled fields. Thanks Konrad Tag: Schema problem with Strongly Typed dataset Tag: 62771
  - 11
    - Extending Typed "DataTables" I am facing the following problem in my applications and would like suggestions from you guys. My database schema has changed many times over the years and keeps chaging frequently according to specific client needs. My business layer (webservices) returns datasets to the thick client. The problem is that as the database changes so often, more than 800 datasets will have to be changed everytime. The solution suggested was as follows: a) Create 1 DataTable for each TABLE in the database. b) Create own DataSet for each visible screen or processing function by addind DataTables to this DataSet. c) Add Ref Contraints manually to this custom DataSet. This way, if the database changes, only one single DataTable class (schema) in the application will have to be changed. Now my problem is that i want to use Typed Datasets and Typed DataTables. What would be the best solution for this scenario. As mentioned on MSDN, DataTables can be instantiated independent of DataSets. In this case, the schema for the DataTable and the constraints are added manually in the code. But I could not find anything about extending Typed DataTables and using them independent of the DataSet. There is a powertoy by Shawn Wildermuth that helps you extend Typed DataSets, but i couldn't extrapolate his ideas to fit my requirements. Any ideas what the best thing for me would be ? Thanks, Nishith Tag: Schema problem with Strongly Typed dataset Tag: 62769
  - 12
    - System.Type.GetType("System.Data.SqlTypes.SqlString") problem Hi, I'm trying to create a DataColumn with the following code: DataColumn dc = new DataColumn("CustomerID", System.Type.GetType("System.Data.SqlTypes.SqlString")); but the GetType method does not return a valid type. If I use "System.String" it works. If I create an instance of System.Data.SqlTypes.SqlString and the use the instance's GetType method inherited from System.Object I can get the type but I would like to get the type directly from Type.GetType. Can anyone see what I'm doing wrong? Is there another way to get what I need with a single method call? Thanks...Ron Tag: Schema problem with Strongly Typed dataset Tag: 62764
  - 13
    - Transaction IsolationLevel Hi, I found the following statement regarding IsolationLevels in MSDN: "If changed during a transaction, the expected behavior of the server is to apply the new locking level to all statements remaining." (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html /frlrfsystemdataisolationlevelclasstopic.asp) My question is: if I already have a SqlTransaction running, and want to change the isolation level in the middle, how do I change it? I found that the SqlTransaction.IsolationLevel property is ReadOnly. Thanks for any help. Tag: Schema problem with Strongly Typed dataset Tag: 62760
  - 14
    - Updating BLOBS to database I need to store the logo of my enterprise in a image field. I find the way to retreave this field, but a cant´t find the way to store my logo's file in a table. I'am using ado.net Thanks Tag: Schema problem with Strongly Typed dataset Tag: 62749
  - 15
    - DataTable Events? I am getting started with DataTables and the DataGrid control. I want to find out when the user adds a row to a DataGrid, but I can't find a 'new row' or 'row added' method in either the DataGrid control or the DataTable class. I have bound a DataGrid to a stand-alone, in-memory DataTable. The user can edit the DataGrid cells and add new rows. When the user adds a new row, the calls all show "(null)", since they don't yet have values. I'd like to know when the user adds a new row, so I can plug in some default values, or do something to supress the "(null)" display in the cells. Is there an easy way to do that? Is an event fired when a user adds a new row? Thanks. -- Dave Veeneman davidv@nospam.com (actual domain is my last name) Tag: Schema problem with Strongly Typed dataset Tag: 62748
  - 16
    - Autoincrement Key values in Relationships ADO.NET and Autoincrement fields. Recently, while attempting to use .NET to build an interface for a new system, I came upon the issue of using Autoincrement fields as Key values. In and of themselves, they are not terribly troublesome, but when used as part of a Key defining a Parent-Child relationship, things get a little sticky. Per the MicrosoftPress book, ADO.NET by David Sceppa, handling Autoincrement values in Parent-Child relationships is no bother at all. In chapter 11 - Advanced Updating Scenarios : Section 'Working with Autoincrement Values and Relational Data', Sceppa states, (after fetching the new Autoincrement value for the Parent record from the database)"...how do you apply the new Autoincrement values to the pending new line items? Actually, you don't. You let ADO.NET do the work for you through the DataRelation.". That statement is only half right. ADO.NET will in fact update the values through the DataRelation, but in the process, it changes the RowState of the (child) records from 'Added' to 'Modified'. Since this property is read- only, this effectively prevents the child records from being INSERTed into the database (because the DataAdapter now believes these records are NOT NEW, but simply existing records that have been modified. Using this methodology, your detail data will never get stored to the Database. Ever. In his book, Sceppa also discourages the use of Autoincrement values in favor of the GUID. Since that value can be generated by either the client or server, it is much easier to handle since you do not need any special code to retrieve the values from the Database after the row has been added. Except for the fact that GUID values CAN BE DUPLICATED, and the fact that they are four times larger than an (SQL)Int, this would probably be a good suggestion. Even if the uniqueness could be guaranteed, who wants to use a 16-byte random 'string' as a key value for lookups and cross referencing between tables!?!? After fighting with this particular issue for several days (and nights), and repeated attempts to find something resembling an answer on Microsoft's many websites, I found something that actually works, and is not terribly difficult to achieve. I would like to say that the idea, if not the code, came from Microsoft. It didn't. Let's use the standard ORDERS and ORDERDETAILS tables to illustrate.... ORDERS : PrimaryKey = (ORDER_ID) --------------------------------- ORDER_ID : Autoincrement (-1, -1) CUSTOMER_ID : Int .... ORDERDETAILS : PrimaryKey = (ORDER_ID + LINEITEM_ID) ---------------------------------------------------- ORDER_ID : Int LINEITEM_ID : Int .... DataRelation -------------------------------- Parent : ORDERS("ORDER_ID") Child : ORDERDETAILS("ORDER_ID") Let's say that a single new order has been added to the DataSet and has been assigned an ORDER_ID of -1. the new records would look something like this... ORDERS.Rows(0)("ORDER_ID") = -1 ORDERS.Rows(0)("CUSTOMER_ID") = 7026 .... ORDERS.Rows(0).RowState = Added ORDERDETAILS.Rows(0)("ORDER_ID") = -1 ORDERDETAILS.Rows(0)("LINEITEM_ID") = 27 .... ORDERDETAILS.Rows(0).RowState = Added In order for the Database assigned Autoincrement value to propagate to the child table in the relationship, you need to use the Parent tables Select method, and NOT GetChanges since GetChanges will not cascade the values to the ORDERDETAILS DataTable. The call would look something like this.... nEffectedRows = sdaORDERS.Update(ds.ORDERS.Select ("ORDER_ID < 0")) ----->Insert statement is as follows.... "INSERT INTO dbo.ORDERS(CUSTOMER_ID) "_ "VALUES (@CUSTOMER_ID) ; "_ "SELECT ORDER_ID, CUSTOMER_ID FROM dbo.ORDERS "_ "WHERE (@ORDER_ID = @@IDENTITY)" This will add the new ORDER record to the Database and return the new database assigned ORDER_ID, which in turn is stored in the appropriate ORDERS datarow. If the DataRelation is set up correctly and in effect, the ORDER_ID values in the Child record(s) will also be updated with the correct ORDER ID. This makes our records look like this... ORDERS.Rows(0)("ORDER_ID") = 99 ORDERS.Rows(0)("CUSTOMER_ID") = 7026 ORDERS.Rows(0).RowState = Unchanged ORDERDETAILS.Rows(0)("ORDER_ID") = 99 ORDERDETAILS.Rows(0)("LINEITEM_ID") = 27 ORDERDETAILS.Rows(0).RowState = Modified ... This brings us to the problem with using this method. At this point, we have called the Update method for the ORDERS DataAdapter, but NOT for the ORDERDETAILS DataAdapter. If you look at the RowState for the ORDERDETAILS row you will see that it has been changed from 'Added' to 'Modified'. If you now try to send this row to the DataAdapters Update method, it will attempt to UPDATE it rather than INSERT it. Obviously this fails since the row does not exist in the Database. What makes this really fun to deal with is the fact that the RowState property is READONLY. Microsoft does not offer any solution to this. Sceppa is obviously unaware of this problem since he goes on to say, "Once the new rows in the order details DataTable contain the appropriate values for the OrderID column, you can successfully submit the pending new rows to your database". No biggie. It's not the first time Microsoft has left out a detail or two. Solution. It took me about 5 days to find a combination of tactics that actually worked. The sequence of events are the same as what is described above, but with a couple of extra steps tossed in. The solution itself isn't terribly difficult to code, infact it's rather simplistic. What made it difficult was trying to do it 'their way'. The brief run-down is as follows.... <data has already been added - we are about to update the database with our changes > //------------------------------------------------------ //------------------------------------------------------ Dim xx, yy As Int16 Dim tOrdersAry() As DataRow Dim tDetailsAry() As DataRow ' Get our array of (POINTERS to) the ADDED ROWS... tOrdersAry = _ ds.ORDERS.Select("", "ORDER_ID", Added) tDetailsAry = _ ds.ORDERDETAILS.Select("", "ORDER_ID", Added) ' Now, update the ORDERS Table with the NEW records... xx = sdaORDERS.Update(tOrdersAry) Dim tempTable As DataTable tempTable = <dsClassDef>.ORDERS.Clone ' The ORDER_ID field is an Autoincrement column. ' TURN IT OFF!!!!! tempTable.Columns("ORDER_ID").AutoIncrement = False ' Copy over all the data from the real (Details) DataTable ' (which includes the new, correct ORDER_ID value)... Dim tmpRow, tmpRow2 As DataRow For Each tmpRow In tDetailsAry tmpRow2 = tempTable.NewRow tmpRow2("ORDER_ID") = tmpRow("ORDER_ID") tmpRow2("CUSTOMER_ID") = tmpRow("CUSTOMER_ID") tempTable.Rows.Add(tmpRow2) Next ' Update the Database with the 'Added' records... yy = sdaOREDRDETAILS.Update(tempTable) //------------------------------------------------------ //------------------------------------------------------ One detail left to do at this point is call the AcceptChanges method for the -real- rows in the ORDERDETAILS DataTable. Since this is dependant upon your particular handling of the transaction, I do not include that code in this example, though I would suggest handling the INSERTS in a separate transaction and calling the AcceptChanges method for each added (detail) row rather than for the entire table after all updates, inserts, and deletes. In closing, I would just like to add that under normal circumstances I would not have bothered to comment on this problem. I have in this case because Microsoft has documented this situation to a fair degree of detail, but has done so incorrectly, ineffectively, and when consulting more than one source, in a conflicting manner. I paid good money to buy a MicrosoftPress book since they, by all rights, should be the absolute experts on the subject. I then added to my confusion by consulting the Microsoft website to clarify, only to find more wrong answers (though stated in a very matter-of-fact manner). I freely admit that I have never, and I mean never, really liked Microsoft. Mostly because of their business practices, but also because of the quantity of bugs and known problems within their software (which will be fixed in the next release for only $xxx.xx!!). When the company I work for decided to use .NET for a system re-write, I began investigating it, and to my own surprise, I was very pleased with what I found. For the first time in twelve years, I had something NICE to say about Microsoft. However, as with everything else from MS, once you get down to the details, the documentation ALWAYS works better than the actual software. Tag: Schema problem with Strongly Typed dataset Tag: 62743
  - 17
    - Problem with IConvertible and text column I'm trying to execute a stored procedure, which receives some parameters, to insert a row in a table. One of those parameters is defined with text data type, just as the column in the table. When I call that sp from my C# app, I get an exception of "Object must implement IConvertible". Although I call stored procedures daily, this is the first time I see this exception, and is the first time I use a text parameter in a sp. This is the C# code ... SqlParameter []parametros = new SqlParameter[4]; parametros[0] = new SqlParameter("@Id",SqlDbType.Int); parametros[1] = new SqlParameter("@Contenido",SqlDbType.Text); parametros[2] = new SqlParameter("@PalabrasClave",SqlDbType.VarChar,2048); parametros[3] = new SqlParameter("@Nombre",SqlDbType.VarChar,255); parametros[0].Value = objCanal.Id; parametros[1].Value = objCanal.Contenido; parametros[2].Value = objCanal.Palabras; parametros[3].Value = objCanal.Nombre; if (SqlHelper.ExecuteNonQuery(ConnectionString,"InsertarCanalEstatico",parametros) == 0) throw new Exception("Fila no insertada"); ... and this is the sp ALTER PROCEDURE dbo.InsertarCanalEstatico ( @Id int, @Contenido text, @PalabrasClave varchar(2048), @NombreCanal varchar(255) ) AS declare @cant int select @cant = count(*) from contenido where Id = @Id if @cant = 1 update Contenido set Contenido = @Contenido, PalabrasClave = @PalabrasClave, NombreCanal = @NombreCanal where Id = @Id else insert into Contenido (Id,Contenido,PalabrasClave,NombreCanal) values (@Id,@Contenido,@PalabrasClave,@NombreCanal) Tag: Schema problem with Strongly Typed dataset Tag: 62739
  - 18
    - Problems connecting to Oracle using Oracle Provider for .Net Framwork Hello, Trying to use .Net oracle provider, but am getting the following error. I am using Oracle 9i client to Oracle 9i. Any ideas? Could not create an environment: OCIEnvCreate returned - 1. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Could not create an environment: OCIEnvCreate returned -1. Source Error: Line 27: Dim myConnection As OracleConnection = New OracleConnection(strConn) Line 28: Line 29: myConnection.Open() Line 30: Line 31: myConnection.close() Source File: c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb Line: 29 Stack Trace: [Exception: Could not create an environment: OCIEnvCreate returned -1.] System.Data.OracleClient.DBObjectPool.GetObject (Boolean& isInTransaction) System.Data.OracleClient.OracleConnectionPoolManager.GetPo oledConnection(String encryptedConnectionString, OracleConnectionString options, Boolean& isInTransaction) System.Data.OracleClient.OracleConnection.OpenInternal (OracleConnectionString parsedConnectionString, Object transact) System.Data.OracleClient.OracleConnection.Open() HL7Delete.HL7Delete.getConfirmation() in c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb:29 HL7Delete.HL7Delete.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb:23 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() Tag: Schema problem with Strongly Typed dataset Tag: 62735
  - 19
    - SQL Query for Datagrid Paging I under stand how to pull the results for all but the first page in the grid using one query or stored proc. If I could specify TOP 0 in the sub query, you would think that would work. Do I need to create another stored proc to pull the results for the first page of the datagrid? SELECT TOP 3 id, name FROM mytable WHERE id NOT IN (SELECT TOP 0 id FROM myTable ORDER BY name) ORDER BY name TIA, Steve Tag: Schema problem with Strongly Typed dataset Tag: 62734
  - 20
    - timberline hello does someone knows how to access timberline accounting softwares database using .net? Tag: Schema problem with Strongly Typed dataset Tag: 62724
  - 21
    - @@ROWCOUNT I am trying to return the Row Count from a stored proc Here is the sp CREATE PROC AS SELECT * FROM accounts RETURN @@ROWCOUNT GO Here is where I am pulling the return value, but I am getting nothing??? All the return parameters are set correctly. lblMessage.Text = cmdDepositoriesRetrieve.Parameters("@returnvalue").Value TIA, Steve Wofford www.IntraRELY.com Tag: Schema problem with Strongly Typed dataset Tag: 62719
  - 22
    - Flexible Data Provider Architecture Hello, I need advice on how to design flexible data handling for an app that meets the following general installation options: 1. data on local machine, single user, probably using Access or FoxPro 2. data on network, multi-user, client server, SQL Server or Oracle 3. data on web service using SQL Server and IIS The option chosen must be transparent to the client. Currently my design is based on separating the client app from the data provider. The client instantiates a class from a separate dll that handles communication between the client and the data - currently SQL Server. I figured that I would later expand data handling to other data sources through subclassing. While I haven't since ruled this out, I'm guessing that the web service version will throw a wrench into this approach. The question is how to provide elegant and transparent switching between data handling code for a flexible and growing list of data providers. I'm tempted to implement an intermediate "generic" wrapper class containing all the methods needed by the client. The wrapper class would then farm out the actual work to provider-specific classes based on the provider in use. Unfortunately, I have yet to work with web services, so anything I come up with at this point would be a guess. Any advice would be appreciated. Randy Tag: Schema problem with Strongly Typed dataset Tag: 62715
  - 23
    - Sending Certain Fonts to Printer I am trying to send a 'Control' Font to a receipt printer. This is suppose to execute an auto-cut and open the cash drawer. Does anyone have an idea how I force a particular font to the printer? thanks Tag: Schema problem with Strongly Typed dataset Tag: 62698
  - 24
    - "Executereader requires an open and available connection" error I have an asp.net page that stopped running properly giving the error below. The app uses a SQL Server 2000 on another server. Enterprise Manager and Query analyzer on the web server can connect to that sql server just fine and run queries. I rebooted the web server and made aspnet member of the admin group. I don't know why the error mentions open connections if I can open several query anaylzer windows using the same sql server credentials as the asp.net is using. I suspect it's an issue with ado.net or .net in general. Any ideas? error message: "Executereader requires an open and available connection Karim Tag: Schema problem with Strongly Typed dataset Tag: 62691
  - 25
    - SQL Server connection string works with IIS 5.1 but not IIS 6 in ASP.NET Hello, I have a very simple aspx file that runs on WinXP Pro IIS 5.1 and connects to a SQL Server 2k DB running on a Win2003 Server box. It works fine with the connection string below (X replace real values for security). "packet size=4096;user id=XXX;pwd=XXX;data source='XX.XXX.XXX.X';persist security info=False;initial catalog=XXX" When I place this aspx file on the Win2003 Server under a Virtual Directory I get the following error. "SQL Server does not exist or access denied" I have replaced the IP address for the data source value in the original connection string with every imaginable option (local, localhost, <servername\sqlservername>, etc.) to no avail. I have added ASPNET, NETWORK SERVICES, & SYSTEM as logins to the SQL Server and the database I am trying to access. I have modified my <processModel section of the machine.config file to use the SYSTEM user name. Does anyone have any idea what is going on? Thank you ahead of time for your suggestions. John Tag: Schema problem with Strongly Typed dataset Tag: 62690
- Next
  - 1
    - Equivalent to Command.Parameters.Refresh Hi, Does anyone know what is the equivalent of Refresh method in VB6 for ado.net command object. Thanks in advance, Ray Tag: Schema problem with Strongly Typed dataset Tag: 62683
  - 2
    - 'ResourcePool' is not supported on the current platform Aloha! Im getting the following message when I'm trying to use the data adapter: 'ResourcePool' is not supported on the current platform I'm running Windows 2000 professional, SQL Server 2000 and .Net 1.1. What is causing this? I've seen that other people have had the same problem in other forums. however I haven't seen any answer to what is causing it! Help! Regards, Max. Tag: Schema problem with Strongly Typed dataset Tag: 62681
  - 3
    - master-detail DataGrid's for many-to-many relationship My database contains a STUDENTS table, a COURSES table, and an ENROLLMENTS table. The ENROLLMENTS table represents the many-to-many relationship between students and courses. I would like to have a master-detail pair of DataGrid's. The master grid contains students, and the detail grid contains the courses in which the selected student is enrolled. Master-detail grids are easy when there is a parent-child relationship between two tables. However, in my case the parent child relationship is between the STUDENTS and ENROLLMENTS tables (and the COURSES and ENROLLMENTS). How can I get a pair of DataGrid's to act as master-detail for this many-to-many relationship? Thanks, Dennis Tag: Schema problem with Strongly Typed dataset Tag: 62680
  - 4
    - multiple types of connections Hey all, I have a dll written in Vb.Net which has all my application's database access. I used OdbcConnection in it for legacy compatibility. I want to use the same dll to access Sql Server 7.0 and higher with SqlClient library when the database allows its use. I am going to use OdbcConnection for Sql Server 6.5 access still. What is the best way of using in the same code for two or more data access libraries? here is a simple code... Would I have to write one function for each data access type? Dim conSala As OdbcConnection Dim adpSala As OdbcDataAdapter conSala = New OdbcConnection conSala.ConnectionString = "DSN=Multi;uid=sasa;pwd=sasa;" adpSala = New OdbcDataAdapter("SELECT CDPARAM FROM PARAMS ORDER BY CDPARAM", conSala) dstSala = New DataSet Try adpSala.Fill(dstSala, "Params") Catch ex As Exception Return False Finally conSala.Close() conSala = Nothing adpSala = Nothing End Try Return True Tag: Schema problem with Strongly Typed dataset Tag: 62678
  - 5
    - Sending authomatic conformation e-mail I have registration form. After user fills the form he clicks submit button. On this click I want to create function that will send automatic e-mail to that user. Thanks Tag: Schema problem with Strongly Typed dataset Tag: 62677
  - 6
    - Can I sum the result of a expression? What I am trying to do is TABLE.SUM( Column1 + Column2 ). But looks like I can not put more then one column into the sum. any work around? thanks Tag: Schema problem with Strongly Typed dataset Tag: 62676
  - 7
    - Stored procedures debugging Hi. When we use the stored procedure debugger from vs.net, can other users execute the stored procedure being debugged? Do I need to avoid access to the stored procedure during a debug session? Thanks, Antonio Maciel Tag: Schema problem with Strongly Typed dataset Tag: 62674
  - 8
    - Combobox selected index changes when dataset changes Here is what I am trying to do. I have a form with a combo box bound to the underlying dataset. The user right clicks and changes all the rows in the dataset to the present value in the combo box. The data in the dataset rows changes correctly The combo box then jumps to the next index? Any ideas on what is going on here? Thanks Tag: Schema problem with Strongly Typed dataset Tag: 62673
  - 9
    - How to Find Row Index by PrimaryKey of DataTable Dear All, Does Anyone know how to retrieve the row index if i already know the primarykey of a datatable?? Thanks All, Ivan Tag: Schema problem with Strongly Typed dataset Tag: 62670
  - 10
    - Windows Service I am not even getting to point where I need to close the connection, since I can't even connect and open to begin with...So That is not the issue. The issue is the actual connection itself...I know that I need to set my process's property to a certain setting so that the network server recognizes that in fact it is my machine that is making an attampt to connect, but I am not really sure how and where I need to set these settings at...If anyone have some expertise in this area please give me some insights... Tag: Schema problem with Strongly Typed dataset Tag: 62666
  - 11
    - SQL Server 2000 Timestamp and Dataset Hi all I experience Problem when using SQL Server Timestamp attribute. I have a DataAdapter defined to use Stored SQL Procedure for select, insert, update and delete. When i fill the DataSet i also populate it with the SQL2K Server Timestamp. How can i pass the Timestamp value back in the Dataset or how is the correct definition of the Dataset for the Timestamp value. When i perform a update with the DataAdapter.Update Method the Update will fail if i have a statement like this in the Stored Proc: Update Table set Name = @Name where ID_Table = @ID and Tstamp = @Tstamp If is use the statement : Update Table set Name = @Name where ID_Table = @ID with no Timestamp the Update is well working. I guess that the Timestamp value is not passed in the Format needed. The DataAdapter is generated with the wizard. I'm using a typed Dataset. Do you have some suggestion / help ? Best Regards Paolo Taverna Tag: Schema problem with Strongly Typed dataset Tag: 62659
  - 12
    - Accessing FoxPro Database using OleDB Hi, I am currently working on a project in which I need to interrogate a FoxPro database and present some results from the database in a web browser. I am using VS.NET 2003, Framework 1.1. I build a Select statement and then use the Select statement to query a table in the FoxPro database. The problem is, the query is taking a very long time to run from my .NET code. Running the same query from inside Visual Fox Pro is 20 times faster. Does anyone know what I can do from my .NET code to make the query much faster? The query string I use follows this pattern: SELECT * FROM myTable WHERE UPPER(myField) = myValue Thanks in advance Glenn Tag: Schema problem with Strongly Typed dataset Tag: 62658
  - 13
    - Method returns a dadaset but .aspx page doesn't catch it hi i have written a stored procedure in Oracle 8 which takes in 3 parameters and returns a dataset.Now this procedure is called in a method in a class. this class is referenced from my .aspx page as //REFERENCING MY CLASS in the .aspx page CInvBQR lInvBQR = new CInvBQR(); DataSet ldsTempDe; ldsTempDe = lInvBQR.GetSerialNoDetailsPretoPost (Convert.ToDouble(sNewMobileNumber),"MB_00_000","M"); //PROCEDURE DEFINED in CInvBQR public DataSet GetSerialNoDetailsPretoPost(double dblSerialNumber, string sStockCode,string sSerialNumberType) { OleDbCommand locmdCommandObject = new OleDbCommand(); CDataHandler lDataHandler = new CDataHandler(); DataSet dsSerialNumberDetails=new DataSet(); try { locmdCommandObject.CommandType = CommandType.StoredProcedure; locmdCommandObject.CommandText = "Inv.spGetSerialNoDetailsPreToPost"; loprmSerialNumber= locmdCommandObject.Parameters.Add "@pinumSerialNumber",OleDbType.Numeric); loprmSerialNumber.Value = dblSerialNumber; loprmSerialNumber.Direction = ParameterDirection.Input; OleDbParameter loprmStockCode= locmdCommandObject.Parameters.Add ("@pivchStockCode",OleDbType.VarChar,12); loprmStockCode.Value =sStockCode; loprmStockCode.Direction = ParameterDirection.Input; OleDbParameter loprmSerialNumberType = locmdCommandObject.Parameters.Add ("@pivchSerialNumberType",OleDbType.Char,1); loprmSerialNumberType.Value =sSerialNumberType; loprmSerialNumberType.Direction = ParameterDirection.Input; dsSerialNumberDetails=lDataHandler.GetData (locmdCommandObject); return dsSerialNumberDetails; } The issue is that although the procedure is returnning a dataset containing a row , when i catch it on the .apsx page and i try to access the row count or value of any column i get the following error error: cannot obtain value I would appreciate ur advice or guuidance in this matter thanx Saurabh Bhargava Tag: Schema problem with Strongly Typed dataset Tag: 62655
  - 14
    - Extracting the XML from Dataset Hi All, does anyone know how to extract the XML from an empty dataset (note the words empty dataset here). All I can seem to get is the root element, all child elements are not returned. Rgds, D Tag: Schema problem with Strongly Typed dataset Tag: 62650
  - 15
    - [ANN] Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available Hello: Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available for download. Release Changes: Alpha 1 ( 2003-08-1 ) ------- -------------- - New GDS implementation. - Reorganization of XML documentation files using a new XML file format. - Design time support for connection string ( For MS .NET only ) - Support for database schema retrieval. - Support for SELECT ... FOR UPDATE statements. --------------------------------------------------- You can download binarys ( for Windows and .NET Framework 1.0 ) at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1.exe?download You can download sources at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1-Src.zip?download You can download documentation at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1-Doc.zip?download -- Best regards Carlos Guzmán Álvarez Vigo-Spain Tag: Schema problem with Strongly Typed dataset Tag: 62649
  - 16
    - Streaming LIVE Video on My ASP.NET Website How do I add a live video stream to my website? Also, as a secondary option, can anyone suggest a good program that will update pictures from my camera every 30 seconds or so? But ideally, it would be a live stream! Thanks Jordan Tag: Schema problem with Strongly Typed dataset Tag: 62645
  - 17
    - SQL User Defined Functions Dera all, i have created a UDF in SQL server and would to call it using following SQL statement. Any ideas how can i do that? The issues is that i can call a UDF by specifiying the parameter etc.. but in this case, i don't need to pass any parameters...since i am using UDF in select statement.. i don't know how to call fill the dataset in this case... SELECT B.BRAND_ID, SEGMENT_ID, B.LINE_ID, DBO.GetDeliveryFeesF(B.BRAND_ID, SEGMENT_ID) AS DELIVERYFEES From Brand B ***************************** create FUNCTION GetDeliveryFeesF ( @BrandID int, @segID int ) RETURNS int AS BEGIN RETURN(select case when b.chassis='Y' and deliveryfee is not null then b.DeliveryFee Else (Select isNull(sb.delivery_fee, pl.delivery_fee) from brand b, Segment_Brand sb, productline pl where sb.brand_id = b.brand_id AND b.brand_id = @BrandID and sb.segment_id =@segID and pl.line_id = b.line_id) end As DeliveryFee from brand b where b.brand_id = @BrandID ) END *********************************************** Tag: Schema problem with Strongly Typed dataset Tag: 62633
  - 18
    - DataReader, mySQL and Text fields The following code has been working really well for me. Dim sSql as String = "Select ctDateTime,ctArea From tblContacts" Dim db As OleDbConnection = New OleDbConnection(sDBCS) Dim dc as OleDbCommand = New OleDbCommand(sSql,db) db.Open() Dim dr as OleDbDataReader = dc.ExecuteReader() dtgrid.DataSource = dr dtgrid.DataBind() dr.Close() db.Close() If I add one more field to the select (a "Text" data type) I get the error below. Any one with suggestions. Line 22 is the line that is failing. The ExecuteReader. TIA Larry Lowry ============================================================= No error information available: DB_E_NOTABLE(0x80040E37). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: No error information available: DB_E_NOTABLE(0x80040E37). Source Error: Line 20: Dim dc as OleDbCommand = New OleDbCommand (sSql,db) Line 21: db.Open() Line 22: Dim dr as OleDbDataReader = dc.ExecuteReader() Line 23: dtgrid.DataSource = dr Line 24: dtgrid.DataBind() Tag: Schema problem with Strongly Typed dataset Tag: 62630
  - 19
    - SqlDataAdapter.Update replacing first row with second after update Hi, I have a WinForms app with a strongly typed dataset that contains two tables, FamilyMembers and ClassesTaken. For both FamilyMembers and ClassesTaken, I have a default value of -100000 for the AutoIncrementSeed with a step of 1. I am trying to simply use these default values temporarily, wait for the user to hit "save", post the changes to the database, and return the identity values into the appropriate columns (FM_ID, CT_ID). I have a datarelation mapped from FamilyMembers to ClassesTaken on FM_ID to FM_ID with an UpdateRule set to cascade and an Accept/Reject rule of none. (A FamilyMember may have 0 or more classes taken.) The problem is that when I add more than one family member, and then assign the FIRST family member entered to a ClassesTaken record, the DataAdapter is for some reason overwriting the first record in FamilyMembers with the second record. I have set the SqlCommand.UpdatedRowSource for the update and insert statement to UpdateRowSource.OutputParameters. This behavior does not occur when the 2nd or subsequent rows are assigned a "ClassTaken". For example: (PRE-UPDATE) FamilyMembers (FM_ID, First, Last) -100000, Jim, Smith -99999, Mary, Smith ClassesTaken (CT_ID,FM_ID,Class) -100000,-100000, English (POST-UPDATE) FamilyMembers (FM_ID, First, Last) 2, Mary, Smith 2, Mary, Smith ClassesTaken (CT_ID,FM_ID,Class) 1,1,English What is strange is that the data is inserted correctly into SQL, but the dataset is showing duplicate records for the FamilyMembers. When I set the UpdateRule to "NONE", this behavior does not occur, but I also lose the FM_ID foreign key update on ClassesTaken. Is there any explanation for this? I'm at wits end with this one. Thanks, Dave Tag: Schema problem with Strongly Typed dataset Tag: 62624
  - 20
    - Connection question In the course of using VS.net I have generally setup my connections by dragging a SQLDataAdatper to the form and going from there. However, I am at a point where I would like to begin connecting to the database and creating DataAdapters and DataSets via code. On a form I go into the ConnectionString property of a SQLConnection object and copy the values there. I suppose that I can just copy these values to my connection string that I create in code, but I can not. I have code that looks like this: Dim myConnection As New SqlClient.SqlConnection myConnection = New SqlConnection Try 'myConnection = "workstation id=P426;packet size=4096;integrated security=SSPI;data source=P426;persist security info=False;initial catalog=Corp" Catch ex As Exception End Try With the code above I get a squiggly under the "Workstation id = P426...." line and it says, "Value of Type String can not be converted to System.data.sql.connection" What do I need to do to write a connection string that is palatable to my code? What is the easiest way of doing this? Tag: Schema problem with Strongly Typed dataset Tag: 62621
  - 21
    - very urgent...please From: "Nedu N" <nedu_n@hotmail.com> Subject: not able to read and bind the XML tag data from dataset Date: Tuesday, August 12, 2003 2:06 PM All, I am facing some problem in accessing the data (which is here XML tags itslelf as data) from dataset.... example: I have got data as <BTN> in one of the columns in my database table, and i am able to see this data when write the content of the dataset into a xml file with dataset.writexml(). But when i try to bind this dataset to a datagrid i am seeing only spaces in this specific column...i am okay with other columns... Any help will be greatly appreciated.. Thanks Nedu Tag: Schema problem with Strongly Typed dataset Tag: 62615
  - 22
    - OracleConnection Hi, I'd like to ask You to solve my problem connecting to Oracle9.x database as SYSDBA. How can I specify that 'AS SYSDBA' ? When I try to login with 'User ID=SYS as SYSDBA' I always get Unknown user/password. Maybe I've placed my problem wrong and should check Oracle permissions to do that ? Thank You Best regards Rafa³ Grzybowski Tag: Schema problem with Strongly Typed dataset Tag: 62612
  - 23
    - not able to read and bind the XML tag data from dataset All, I am facing some problem in accessing the data (which is here XML tags itslelf as data) from dataset.... example: I have got data as <BTN> in one of the columns in my database table, and i am able to see this data when write the content of the dataset into a xml file with dataset.writexml(). But when i try to bind this dataset to a datagrid i am seeing only spaces in this specific column...i am okay with other columns... Any help will be greatly appreciated.. Thanks Nedu Tag: Schema problem with Strongly Typed dataset Tag: 62610
  - 24
    - how to cast a Recordset from ADO a ADO.NET Data Struct Hi! can somebody tell me how to cast a Recordset from ADO to a ADO.NET Data Struct the ado recordset is in a dll that is called from an app that is being build in C#.NET Thanks in advance Tag: Schema problem with Strongly Typed dataset Tag: 62608
  - 25
    - One dataAdapter and two tables. Does it work? Hi all, I am using a dataapater, a dataset and an select sql command to retrieve data from two related tables using the following code: Dim da As New OleDb.OleDbDataAdapter("SELECT Materials.*, Material_Functions.fName FROM Material_Functions INNER JOIN Materials ON Material_Functions.ID = Materials.Function;", conn) Dim ds As New DataSet("DSMaterials") da.Fill(ds, "Materials") You cannot see it in the code but table 'Materials' and table 'Material_Functions' both have a field called 'fName'. For simple (one table) sql commands I had no problem binding textboxes to fields in the dataset using the following code: (Assume sql command is "Select * From Materials;") TextBox.DataBindings.Add("Text", ds, "Materials.fName") But this doesn't work any more. I checked the output window during run-time and all the fields are placed under one table (Materials) which is logical. I also noticed that the 'fname' field coming from the 'Material_Functions' table is named 'Material_Functions.fName', which is also logical. The question is when it comes to data binding what to I put in the third argument??? 'Materials.Material_Functions.fName' doesn't work. I know that I can use a second dataadapter to load the second table separately and set the relationship in the dataset manually, but I would prefer to do it in just one dataadapter (don't ask me why, because I don't know that either). So how do I work around it with just one dataAdapter? And if I should use 2 of them what is the advantage of that over the single DA? Thanks in advance Theo Tag: Schema problem with Strongly Typed dataset Tag: 62602

I have a strongly typed dataset whose schema looks as such:

<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="Dataset1"
targetNamespace="http://tempuri.org/Dataset1.xsd"
elementFormDefault="qualified"
attributeFormDefault="qualified"
xmlns="http://tempuri.org/Dataset1.xsd"
xmlns:mstns="http://tempuri.org/Dataset1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="Dataset1" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="cc">
<xs:complexType>
<xs:sequence>
<xs:element name="usr" minOccurs="0"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="distributionList"
nillable="true" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="nam" type="xs:string"
form="unqualified" />
<xs:attribute name="uid" type="xs:string"
form="unqualified" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>

I have a test function in a windows form in which I try to fill the
dataset up with xml. My function looks as such:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim ds As New Dataset1
Dim xreader As XmlReader
Try

Dim stream As New System.IO.StringReader("<cc>" & _
"<usr uid=""123"" nam=""Test User"">" & _
"<distributionList>testing</distributionList>" & _
"</usr>" & _
"</cc>")

xreader = New XmlTextReader(stream)

' I am crashing here
ds.ReadXml(xreader, XmlReadMode.InferSchema)

MsgBox(ds.GetXml)

Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub

My believe my problem lies in the schema. If I specify multiple or
zero distributionList nodes the xml is read into the dataset
correctly. If I specify just one distributionList node I get a
"Specified cast is not valid". Am I missing something in the schema?

Thanks,
Collin

Top