Stored procs to xsd example

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
    - dataset.getchanges fails to return changes Hi All I'm experiencing the problem of dataset.getchanges returning unmodified rows only : myDs.ReadXml("c:\Parsley.xml", xmlReadMode.Auto) For Each t In myDs.Tables For Each r In t.Rows If r.Item("Deleted").ToString = "True" Then r.Delete() Exit For End If Next r Next t myTmpDs = myDs.GetChanges() myDs.Merge(myTmpDs) myDs.WriteXml("c:\Parsley.xml", xmlWriteMode.WriteSchema) The getchanges call returns the non deleted rows, the merge call adds these rows to the main dataset. I have read elsewhere that I need a primary key? There is one on the SQL table the xml is extracted from but nothing in the xml to indicate this. Ta v'ry much Parsley Tag: Stored procs to xsd example Tag: 80314
  - 2
    - Installation Failure of MDAC 2.1 on Windows Server 2003 Hi, all, I have an application that starts installing with MDAC 2.1. Once the MDAC 2.1 is installed, it reboots the server and then continues again with the installation process once reboot complete. But then again, MDAC 2.1 is installed for the second time, it goes on like this. If I choose Cancel, the installation process has to abort. I understand that the version of MDAC on windows 2003 is at least 2.8. But how can I also install MDAC 2.1 for some application compatibility? Thanks a lot, Jake Tag: Stored procs to xsd example Tag: 80311
  - 3
    - Oracle Connection Pool Performance We are troubleshooting performance problems with our application. There are 30-50 users using an web IE OLTP application against a 3-6GB database, queries often hitting several tables (40,000-1.2M rows but using indexes) foreign key constraints enabled). The architecture is ASP.NET - DOT NET 1.1 which means a connection pool using OLEDB. There are issues with DataReaders not being closed - meaning new connections opening often - sometimes we see 90-120 open connections. The clustered dual server is fairly new with a fast dual cpu, INTEL, WIN2000 server over 9 disks, mostly Raid 5. However there is 1.5GB RAM and little disk I/O activity. Perhaps the issue lies in the SQL, lack of caching and connection pool. However there are no queries with huge buffer gets and the oracle stats do not point to anything specific. Are there inefficiencies with dot net 1.0 with Oracle and many users? Any ideas on next steps - Metalink does not have much that is NT specific. Final info Database is 8.0.5 and no not an option to upgrade that yet, perhaps in 6 months but the issues are here and now :-) Tag: Stored procs to xsd example Tag: 80307
  - 4
    - Configure DataAdapter Changes the Name of a Column in Insert Command I have a SQLDataAdapter that I allow the Configuration Wizard to auto-configure the Select, Insert and Delete commands. During the configuration wizard the Select Statement that I cause to be created is simple: SELECT [ICD-9], Category, Description FROM [ICD-9] ORDER BY [ICD-9]. However, the Insert statement that is created is : INSERT INTO [ICD-9] ([ICD-9], Category, Description) VALUES (@Param1, @Category, @Description); Look at the VALUES. Instead of the first parameter being @ICD_9, it's changed to @Param1. Now believe it or not, the statement works OK but I have no idea where @Param1 comes from and I certainly don't set a value for @Param1. Why did the configuration wizard change the name of the first column to @Param1 instead of using the @ICD_9 the way that I expected. Is it that pesky hyphen in the column name that I never should have placed in a column name in the first place? Tag: Stored procs to xsd example Tag: 80300
  - 5
    - Calculated Columns vs Calculations in stored procs.... what is the best way ??? I have several crossTab type reports in a VB app. I am displaying these reports in a Datagrid. The Datagrid gets its data directly from a stored proc I have created on SQL Server 2000 (rp_crossTab) which returns data in a nice crossTab fashion. (The stored proc accepts parameters such as onRows, onCol, sumBy, etc.) My problem is I have several crossTab reports which actually depend on data found in other crossTabs. For example, I have this total paid amount crossTab: REPORTA Name/Month Jan Feb Mar Jon 20 40 40 Jack 100 50 200 Jill 25 75 75 And another report might be a month-to-month ratio of the total paid amount: (this report clearly depends on REPORTA) REPORTB Name Jan to Feb Feb to Mar Jon 2 1 Jack 0.5 4 Jill 3 1 I thought of two ways to create REPORTB: 1) Call another stored proc which then calls rp_CrossTab, and performs the necessary calculations using tempTables. 2) Creating a new table using new DataColumn objects in .NET and setting their necessary values in the "Expression" field (eg "Jan/Feb") and also making the columns dependent on REPORTA. I can think of various problems with both scenarios... Correct me if I am wrong but solution 1 would take a huge performance hit since it would be in fact re-calculating REPORT A in order to generate REPORT B. Solution 2 sucks because I would have to hard-code logic in my .NET app and I dont really wanna do that.... as well I dont think I can use custom functions in the column Expression field (eg. DataColumn.Expression = "MyWeightedAverage(COL1,COL2,COL3)") What is the best way to create this second (or any other dependent) report? Is there something I have missed? Is it generally better to have ALL logic in stored procs... even it is much slower? Thanks a lot, I really appreciate any comments anyone may have. Tag: Stored procs to xsd example Tag: 80299
  - 6
    - 19 Feb 2004, How to access VB.net applications thr' PDA's Hello, I recently started development in Vb.net. I am about to finish a product in VB.net Database Applicatio, Sql Server as Backend. I read little about wireless technology and PDAs. Is it true that one can access VB.net forms/applications running on Server, using PDAs ? If so please tell me where to start for this ? what is the infrastructure investment for such projects ? What are running cost in terms of hardware and software ? Where can I get more resources on this topics ? Thanks in Advance. Regards. [Sham Shrinivas Yemul] -- > > Visit following web site for Colored flame lamps > >http://in.geocities.com/osyemul/index.html *********************************************** Intellisoft Computer Consultants Pvt. Ltd. 340 A Sakhar peth, Solapur - 413005 Phone : 91-(0)217-262 4713 http:\\intellisoft.netfirms.com Email : yemul@fusemail.com *********************************************** Tag: Stored procs to xsd example Tag: 80298
  - 7
    - OleDbDataAdapter appears to use incorrect path to DB Hi I am using .NET framework 1.0. I am having problems with the following VB.NET code: ---- . . . . Dim da As New OleDbDataAdapter(selectQuery, connection) Dim ds As New DataSet() Try da.Fill(ds) Catch eDB As OleDbException showException("Database exception while filling dataset.", eDB) Return Nothing End Try . . . ----- The connection object i pass into the OleDbDataAdapter constructor has been initialised with the connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\projects\TestData \tracking.mdb;User ID=Admin;Password=;Mode=Share Deny None" I checked that the data adapter's SelectCommand's connection was set to the correct connection string using the debugger. On the line: da.Fill(ds), i get an exception with the message: "Could not find file 'x:\projects\MyAppName\bin\tracking.mdb'." Now, obviously this occurs because the database does not exist at this location. But what I can't understand is why the path it's using to look for the database is the executable path. Has anyone seen this issue? Any help/comments greatly appreciated! Thanks id Tag: Stored procs to xsd example Tag: 80295
  - 8
    - Deleting In Strongly typed Dataset Hi All! After a long time for trying understand how strongly typed dataser work, I've finaly success. Except on the delete command. When I do some deleting, it only delete record from the dataset but not from the database. I've try many thing but I turn arround. I paste you the code I use. Me.cnAlbums.Open() Dim Row As DsAlbums.PhotoRow = Me.DsAlbums.Photo.FindByPhotoId(CInt(Me.lblPhotoId.Text)) Me.DsAlbums.Photo.RemovePhotoRow(Row) Me.UpdateFlag = False Me.DaPhoto.Update(Me.DsAlbums, "Photo") ' There is where it's suppose to delete..? Me.UpdateFlag = True Me.cnAlbums.Close() Sorry for my english but I'm french and I didn't get any response on the french newsgroup Thank a lot, Francois Tag: Stored procs to xsd example Tag: 80294
  - 9
    - form controls for relational tables with one-to-one correspondence Hi, What form controls should I use to manage the data thats in relational tables. Each relTable may have no row OR one row corresponding to the row in master table. Probably this is more of a database design question than programming logic. Tag: Stored procs to xsd example Tag: 80292
  - 10
    - GetChanges from a DataTable into a DataSet??? Is there a good way to get the changes only from a single datatable. I am using a typed dataset that holds four tables. I would like to get the changes only from one of them. If I use the ds."mytable".GetChanges it returns an instance of the datatable. Is there a good way to get that table into an empty instance of the dataset?? The ds."mytable" is read only. The best way I have found is to get all the changes ds.GetChanges and then to clear the rows of the other tables. I was hoping there was a better way. Basically because of business rules I want all of these tables in the same dataset but this one particular table has its own update statement. Thanks for any help on the matter. AJL Tag: Stored procs to xsd example Tag: 80290
  - 11
    - please help... multiple key table and merge I have a table with 3 keys, it is possible that the user may want to change one of them. If the key is changed (let's say from 1 to 2) the actual update to the database works fine. The problem is that when the dataset gets back to the client and an attempt is made to merge with the original dataset, an error is thrown: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." Basically, the original data appears to assume the original key value is 2 when it is really 1. It seems to me that I should be able to do this. The row is in a modified state so the 2 value should not be considered the current key. Any suggestions would be greatly appreciated. Aaron Tag: Stored procs to xsd example Tag: 80289
  - 12
    - Difference between MissingSchemaAction and FillSchema? I just read that the setting the DataAdapter's MissingSchemaAction property to AddWithKey will set the primary key, MaxLength and AllowDbNull. I also read that FillSchema will set the primary key, MaxLength, AllowDbNull and AutoIncrement. Is it correct that AddWithKey will not set the AutoIncrement property of a column but FillSchema will? -- Bill Tag: Stored procs to xsd example Tag: 80282
  - 13
    - How To Encrypt a connection String Hi, I store my connection string into a .config file How can I encrypt this file or the connection string ? Stan Tag: Stored procs to xsd example Tag: 80281
  - 14
    - Oracle Provider - ora-1031 error I have an ASP.NET application written using VS.NET 2003 that uses Microsoft's Oracle provider. I'm getting an occasional error, ORA-1031 insufficient privileges. It normally happens when the users add a record but it has happened a couple times when they update a record. I know the users have proper rights set up because they add and update records all day long. The error pops up only once or twice a day. I'm assuming that insufficient privileges means that the user was able to log in successfully but then tried to do something that they didn't have permission to do. If they tried to log in with an incorrect user name or password, they would get a different error. Does this make sense? I ask because I store the user name in a session variable and I was wondering if that was somehow getting cleared before the they attempted to login. If that were happening I wouldn't think that it would be an insufficient privileges error. Does anyone have any ideas why this error would be popping up every once in a while? Some sort of timeout issue? Suggestions? Thanks Terry Tag: Stored procs to xsd example Tag: 80277
  - 15
    - Looking for documentation on the inner workings of dataset/datatable/datarow... Hi, I'm trying to make some customized versions of these tools. The typed datasets are a step in the right direction but I'd like to add some core functionality in the form of.. MyTable/Row/DatasetBase Inherits DataTable/DataRow/DataSet etc.... ...add some functionality... MyCustomDataObject Inherits MyBaseClass ...add custom properties and so on.... Anyway, where I'm having trouble is finding complete documentation on the involved classes.. When you look over the code for typed datasets you find various interesting and undocumented functions such as DataRowBuilders and other constructors and such that aren't documented.. Does anyone know where I can find out about these things? I'd be thrilled if there was a book I could hunt down, but even a web article would help.. I could probably fake it, and copy enough of the structure from a generated typed dataset to get things moving, but I'm not comfortable having the entire core of my work be based on things I don't even fully understand.... Any suggestions?? W.G. Rowland Tag: Stored procs to xsd example Tag: 80274
  - 16
    - asp.net app does not work on 1.1 framework on production box I am having an issue with an asp.net website not working in production on the 1.1 framework, yet it works in development on the 1.1 framework. Both production and development are pointing to the same database server. I get the error below: Error: {0}System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at CollectorPerformance.menu.isSpecialAccessUser()An error has occurred. Please contact the Help Desk. Thanks for any ideas! Tag: Stored procs to xsd example Tag: 80265
  - 17
    - DataTable Column question Hello! I add column into DataTable after table is filled into DataSet like ... ds.Tables("WorkQueue").Columns.Add("OpenQty", GetType(Integer), "OrderedQty-PreparedQty") This column will be the last one, but how can I place it just after 'OrderedQty' 'PreparedQty' columns, because then it's not the last column? Is this even possible? -- Thanks in advance! Mika Tag: Stored procs to xsd example Tag: 80264
  - 18
    - ADO.NET convert NULL to default value? I'm working on a J++ conversion, and with the older ADO and the Java WFC, we have methods like GetInt and GetString on Field classes that, by default, convert NULLs to a default value. J# -> .NET forces us into ADO.NET, and suddenly all these calls to Field classes explode with a ClassCastException if the value is NULL -- no conversion to a default value occurs. I've mentioned this to a couple of people on weird occasions, and both have mumbled something about being able to set something to change this behavior. Is there such an option in ADO.NET? -- Chris http://clabs.org Tag: Stored procs to xsd example Tag: 80262
  - 19
    - Problemos with SQL and ComboBox Hi there guys! I'm still having problems with my ComboBox. I got a table, in SQL, with two columns, ProductID, ProductDescription. I want to fill a ComboBox with the ProductDescription column, but when the user selects an item, I want to return the ProductID, so I guess I got to fill somewhere in the ComboBox the ProductID too. How could I do this? Examples are appreciated!!! ;-) Thanks guys! Tag: Stored procs to xsd example Tag: 80261
  - 20
    - right to files on mapped drives throught IIS and ASP.NET Hello, On a local website but i want to access data on a remote drive (a mapped drive). The data are Foxpro files on a directeory of a mapped drive. I have a problem with security ( no tabel can be opened error 52 in foxpro ) I search the web for a solution. Server 1 = Windows 2000 (Webserver) and server2 = database server (NT server) The two server belong to the same domain. i created a user on the databaseserver (domainserver) who has administrator rights . On the webserver I already used impersonate="true" in the config.web file I added this new user on the webserver and in the IIS : anonymus is set on with this new created user with his paswoord ON the DatabaseServer the database files themselves have full control for the user created. But still get no rights Does anyone know what i am doing wrong ? Christine How must Tag: Stored procs to xsd example Tag: 80257
  - 21
    - DataView of a multiple tables? a la SQL view I have 3 sql tables which are related to one another and I am trying to create a dataset that represents a subset of columns in those tables. In other words, the dataset will have 3 DataTables and however many necessary DataRelations that represent the connections among them. My question is that is there a way to create a DataView that represent a single view from all three tables, so that I can easily bind it to a datagrid for example? It seems that DataView's constructor only takes a single DataTable. This is puzzling and maybe I am incorrect to think that DataView is synonymous with SQL views. As you know in sql you can create a view that selects from multiple tables with whatever criteria you specify. Thanks for your help. Jiho Tag: Stored procs to xsd example Tag: 80254
  - 22
    - Exception thrown in RowChanged handler is not propagated I have a test bed of code that I am using to isolate this situation. There is a bit of code involved, so I'll try posting a narrative description first. 1) I have a strongly typed dataset called OrdersDS 2) I have inherited from this dataset to extend it - the new class is called OrdersDSExt 3) In the constructor of OrdersDSExt, I add an event handler to the ORDERS datatable for the RowChanged event 4) In the event handler, I check the value of the ORDERAMT column to be sure it is >=0. If it is < 0, I throw an exception. Here's the problem: the exception occurs BUT it is not propagated up the stack so the "naughty" code has no idea a problem has occurred. What am I missing here? Tag: Stored procs to xsd example Tag: 80249
  - 23
    - Question: SQL Server Views In SQL Enterprise Manager I have a View that joins several subqueries/views. Through ADO.NET... 1. How can I modify the WHERE clause in the subqueries/views? For example, I hardcoded "WHERE CustomerId = 1". I want this to be dynamic, based on user input. 2. Is it possible to fill a dataset or datareader with the results from the main view? How can I do this, if it is possible. Thanks! Tag: Stored procs to xsd example Tag: 80244
  - 24
    - Multiple error providers Hi All, I have an application which populates a datagrid with a dataset. Ive used an error provider along with these and the errors show ok so far using the SetColumnError. Now my problem is that, depending on the column, I want to display different types of Icons/Error severity (Eg.. One Icon as "warning" in Column"a" and another as "Error" in Column"b" etc). Is this possible at all ?? Can I use something like multiple error providers ? Or is there some other way to go about it? Thanks!!! Tag: Stored procs to xsd example Tag: 80241
  - 25
    - System.Data.OleDb.OleDbException: System resource exceeded ERROR I have a loop to create instances of my user control at run time, for example: for intPageCounter=0 to intNumberOfPages dim objUser as new MyUserCtrl objUser.getProducts() Panel1.Controls.Add(objUser) next The method "getProducts" connect to Acces 2003 DB every time and get DataReader containing required data. After a while this error message appeared: System.Data.OleDb.OleDbException: System resource exceeded. Please advice. Tag: Stored procs to xsd example Tag: 80240
- Next
  - 1
    - Conceptional Question Hello, I'm planning to develop a data base application. Therefore I'm interested in your opinion about some conceptual thoughts I had relating to the internal handling of the application data. * An application must hold temporary data the user is working with. Do you usually only use a dataset as the basis to hold the data, or does it make more sense to have special classes managing the data internally (so you don' t have the whole overhead of a (e.g. strong type) dataset), and then use the dataset only to transfer the data to and from the database. What are the pros and cons? * How do you handle the interaction of data that has to be shown in a dialog? Are entry fields supposed to be bound to datarows of a dataset and used directly as a "carrier" between the dialog and the database, or does it again make more sense to separate a dialog result (the actual data that has been entered or which is to be shown) completely from any database-related stuff? Let's say for example, you would like to provide a "New Projects" dialog to the user to enter the parameters of a new project the database should hold. Should it receive a datarow and give it back with the actual data to store in the database, or is it best to use a custom class that represents the data for a project and that handles the interaction with the user (through the dialog) first? In the latter case, only in the second step a new datarow would be created and be filled with the data of that class to transfer it to the database. * How would you handle DBNull-values in database tables that could be shown in a dialog? Are there some common techniques for dealing with null-values that have to be "converted" to - let's say - entries in a textbox or in an option box group? I'm quite interested in your opinions. Thanks, Klaus Tag: Stored procs to xsd example Tag: 80239
  - 2
    - Access 2003 Error Hello I used C# for ASP.NET and used ADO.NET to connect Access 2003 file. Every thing was ok, when I used "Select" instructions. But, when I want to "Write" the database, like "Delete and Insert", the error was happen. I checked the file and IIS, it's not readonly. Dose anyone want to help me The codes is here OleDbConnection Conn OleDbCommand Command string ConnectionStr ConnectionStr = "Data Source=C:\\Inetpub\\wwwroot\\\\Data\\Test.mdb;Provider=Microsoft.Jet.OLE" "DB.4.0" Conn = new System.Data.OleDb.OleDbConnection(ConnectionStr) string queryStr="delete from UserData where ID='exUser'" Command = new OleDbCommand() Command.Connection=Conn Command.CommandText=queryStr Conn.Open(); Command.ExecuteNonQuery() Conn.Close(); Tag: Stored procs to xsd example Tag: 80234
  - 3
    - max number of records in dataset? Hi Using Winforms, ado.net, MS Access connection, datagrid. Is there a max number of records that can be handled? I will have about 50,000 and user should be able to scroll thru all in the worst case. Thanks Graeme Tag: Stored procs to xsd example Tag: 80228
  - 4
    - creating tables using ADO.NET I understand that you can't create .mdb files using ADO.NET. That's not a problem for me. What I really want to be able to do is create all the tables in an empty database based on a text file that specifies the schema. I'm fine with the text file containing a bunch of SQL CREATE statements but I'm also fine using ADO.NET to create DataTables and DataColumns. The problem with using ADO.NET is that I can't figure out how to set certain Access field properties such as "Allow Zero Length" for text fields or "Format" for Date/Time fields. Can this be done without using ADOX? Thanks, Dave Tag: Stored procs to xsd example Tag: 80215
  - 5
    - When would I use multiple TableMappings When would I add multiple mappings to the DataAdapter TableMappings property? I cannot think of a situation where this would make sense. -- Bill Tag: Stored procs to xsd example Tag: 80207
  - 6
    - Error Handling One Step Ahead It's 3:00 A.M., do you know what your application is doing? Know about possible errors before your customers do! Start the debug process before the customer reports an error to you One Step Ahead is a pro-active development tool for all of your custom software applications. Based on the .Net Framework, One Step Ahead is a Web Service and a Client Component that handles errors and records information about your application at those critical moments. When an error occors, a simple reference to the Critical Error Handler Client Component will solve your problems. The Critical Error Handler contacts a webservice logging error information including the error object and any variables or additional information you may want to pass along. Imagine knowing about errors as soon as they occur. When a customer calls complaining about an error, you could already have a fix for the problem Beta Testing Beta testing will begin shortly. If you are interested in being a part of the One Step Ahead beta testing program please contact us at betaTesting@CriticalSoftwareSolutions.com This FREE/NO OBLIGATION opportunity will allow you to realize the needs this application can fill within your organization Tag: Stored procs to xsd example Tag: 80198
  - 7
    - Robby@Here.Now I used to use the datalink component to build strings, however this is only usefull in .NET for OleDB strings. The SQL and Orcale strings does not rrequire a provider, so I end up stripping them out. Is there a replacement for the datalink component or a workaround for bulding strings in .NET? Tag: Stored procs to xsd example Tag: 80197
  - 8
    - dataviewmanager parent filter based on child criteria Hi, I've have an "Order / OrderDetails" parent child dataset. I have 2 datagrids. DataGrid1 is all of the orders. When I click on an orderdetail line I want DataGrid2 to show all orders using this part. Yes I could reselect the data from the database but why when I already have all the orders I care about in a dataset. I can create a datasetmanager: dim dvm as datasetmangager dvm = new datasetmanager(mydataset) dvm.dataviewsettings("orderdetails).rowfilter = "partno = '" & CurrentPartno.trim & "'" datagrid1.datasource = dvm Ok, now all is well and good for the orderdetails they don't show up in datagrid2. However, I still get all the parent rows with empty child rows when the child doesn't fit the filter.. I tried the following: dvm.dataviewsettings("order").rowfilter = "count(Child.partno) > 0" dvm.dataviewsettings("order").rowfilter = "Child.partno = '" & CurrentPartno.trim & "'" Neither works. Tag: Stored procs to xsd example Tag: 80196
  - 9
    - connect to access database failed?? Hello, everyone I use Access2003 create a database such as db1.mdb. without set login password. My web application can access it well But after I set login password, when i test the connection in visual studio .net. I always get follow information Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user obviously, no other user open db1.mdb at this time Could anyone help? Thanks a lot haiwen Tag: Stored procs to xsd example Tag: 80195
  - 10
    - MetaData - Beta Version Hola Les envio una applicacion hecha en ASP.NET, que he implementado. http://www.msnusers.com/GuyDotNetXmlWebServices/Documents/MetaData%2FCodeName.Mordor.zi La que permite construir formularios web y grilla de datos sin necesidad de programarlos, sino simplemente configurandolos a traves de esta herramienta. Para que despues puedan ser usados posteriormente por las interfaces de usuario que las requieran Gracias a esta idea que he concebido, se ha podido reducir el tiempo del desarrollo de las aplicaciones web que he liderado y por ende se ha logrado reducir los costos Vale decir que les alcanzo adicionalmente los archivos de Base de Datos, la primera de ellas, la que soporta toda la informacion para la herramienta (MORDOR) y la segunda de ellas una aplicacion de ejemplo que hace uso de la herramienta para construir los formularios que mantienen sus datos (TORNEO) Del mismo modo, podran darse cuenta al ingresar a la aplicacion, que solo es necesario dos archivos ASPX para soportar todas las diferentes interfaces de usuario que se prensentan (UIFORM.ASPX y UIGRID.Aspx). Lo que permite concluir que de alguna forma los formularios y grillas se constuyen on-fly El alcance de es herramienta, es en principio orientada con seguridad hacia el mantenimiento de los diferentes TABLAS MAESTRAS del sistema y TABLAS AUXILIARES, que ocupan un tiempo de desarrollo importante dentro del proyecto pero que seria dismuido drasticamente por el uso de este producto para su implementacion Dejando de esta manera, los restantes mantenimientos e interfaces de usuario para una implementacion propia de cada una de ellas README 1. Se necesita W2K + IIS + SQL Server 200 2. Atachar los archivos de DB sobre su servidor SQL Server 3. Ejecutar el instalador y definir el nombre de la carpeta virtual donde se instalara el producto 4. Editar el archivo Web.Config, cambiando el valor del key "DBConnection", con la correspondiente cadena de conexion para acceder a su SQL Server 5. Luego ingresar al IE: http://localhost/MetaDataBeta/Proxy.asp A partir de esta pagina podra acceder a las diferentes interfaces de usuario que muestra la aplicacion. El boton "Application", es el lugar donde podran registrar los nuevos elementos que deseen crear para trabajar con ellos Finalemente, dentro de la carpeta INSTALLER, encontraran los instaladores del producto y dentro de la carpeta DATA, los archivos de base de datos (4). Recuerden que METADATA es el nombre de la DB que soporta a la aplicacion del mismo nombre y TORNEO es una DB de ejemplo Espero recibir sus comentarios, sugerencias y demas a traves de mi email: guydotnetxmlwebservices@yahoo.co Saludos Javier Lun -- Movil: (51-1) 9-731-7187 Tag: Stored procs to xsd example Tag: 80193
  - 11
    - Max length of SQL statement, is there one? Is there a max length for a select, insert or update statement? If so what would it be? Thanks, Bob Tag: Stored procs to xsd example Tag: 80187
  - 12
    - Limiting record numbers retrieved Scenario: 50000 Customers in table Customers, Each customer has 5 Contact records In related table Contacts, each contact has 5 Records In table ContactPhones related to table Contacts. The total number of records in this scenario is 50000 + 250000 + 1250000 = 1550000 records. We want to create a dataset with the objective of displaying 1 Customer record, and ONLY it's related Contacts, and ONLY the related ContactPhones of the currently selected Contact. That is a total of 11 records at any one time. The interface consists of textboxes for the fields bound to Customers, a Grid for the Contacts and a grid for the ContactPhones. When we change row in the Contacts Grid we want to retrieve the 5 ContactPhone records for that newly selected contact. We created a strongly typed dataset in which we place the correct relationships and tables but we realize that even though we filter the Customer for a given customer, all of the contacts and all of the contactphones get loaded in the dataset. This is ridiculously slow as it well should be. How do you limit the loaded records to what I described above, ie only those required for the current viewing and editing need? The number of customers is expected to increase dramatically over what we are currently testing and the default way is just plain unuseable. Any help appreciated. Bob Tag: Stored procs to xsd example Tag: 80183
  - 13
    - Fill a ComboBox Hi everybody! I got a combobox to fill. I want to display some information (Text), but when I select a item, I want to return a number. The info I want to fill in is something like this: TEXT VALUE Category1 10 Category2 15 Category3 35 How can I perform this task? Thanks! Tag: Stored procs to xsd example Tag: 80178
  - 14
    - Retrieve subset of columns Does anyone know how to retrieve a subset of columns from a dataset? I keep running into variations of this situation over and over and have never found a solution. I must have missed some basic feature in ADO. I have a dataset with columns A, B and C. I need to pass a recordset with ONLY columns A and B to another function outside my control. I end up maintaining two datasets and it's a royal pain. I've found tons and tons of information on getting subsets of the rows, combining rows, rows this, rows that. Nothing on columns. I end up either maintaining two separate datasets and trying to keep them in synch, or building a second dataset from scratch off of the first one by doing dataset.columns.add. Tag: Stored procs to xsd example Tag: 80177
  - 15
    - Excel Download With Excel COM How do you download from an Excel spreadsheet using Excel COM (NOT the ADO.NET, Excel Connectstring) Using the ADO.NET and Excel connectstring to retrieve data from a spreadsheet won't work in my case since the spreadsheet doesn't just consist of columns of data but many funky data in series of cells anywhere. Thanks for info. Tag: Stored procs to xsd example Tag: 80176
  - 16
    - Executing PL/SQL Block How can i execute Oracle PL/SQL block using the Oracle Command Object? Tag: Stored procs to xsd example Tag: 80173
  - 17
    - dataadapter fill performance problem Hi i have a strange problem: i use code like this: ODBCConnection cnn = new ODBCConnection("... cnn string ..."); ODBCDataAdapter da = new ODBCDataAdapter("select * from tbl left join tbl2 on tbl.refid = tbl2.id", cnn); DataTable dt = new DataTable; DateTime t = Now(); da.Fill(dt); TimeSpan ts = Now.Substruct(t); Trace....... Show the ts. ..... i use this code in 2 programs: (the remoting server is a console app.) position: Time 1. remoting server program on a marshaled object in static method. 8.7 seconds. 2. the same server, but in the main file. 5.4 seconds 3. the client, in the remoting object (the same method as 1, but i know here it is not the same remoting object). 4.2 seconds. 4. different console program( that not using any remoting, built to the test.) 0.5 second ! u see a huge changes between these methods. I operate the 2 programs (remoting and test) concurrently and the results was the same +-. so i assume it is the remoting that affect the Fill method. but why ?? what could be the reason ?? if any1 want i will send him the remoting configuration section in the config file so he might watch it... Tag: Stored procs to xsd example Tag: 80168
  - 18
    - Get table relations Hi, I read the c# professional book from wrox and searched the internet. I cant find any hint on how to get table realtion information out of my database. I know I can define relations in the dataset, but I want to read it out of my ACCESS oder MSSQL-SERVER database, where it is already defined. Can anyone help (Suggestions, links, samples) Thx Frank Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Stored procs to xsd example Tag: 80167
  - 19
    - Sorting a Strong Typed Dataset Hi, I am looking for a way to sort a strong typed dataset. It would seem the most straightforward way is to use a dataview. The only problem is when I use the dataview I seem to loose the strong typed properties from my original dataset Anyone that can point me to an example of how to sort my dataset and maintain the use of my typed properties would be greatly appreciated Thank, Freeo Also here is a little more detial from the orig post in the general vb section Right, I can use the .sort property change the order rows are accessed in the dataview. This works great but I loose the Strong Typed Names from the original dataset (unless I'm missing something) when I use the dataview '************************ 'Here is a quick sample (Unsorted) Dim drHeader As CUnit.HeaderRo Dim objUnits As New CUnit(ConnectionString) 'This is a Strong Typed Dataset (.xsd objUnits.Loa For Each drHeader In objUnits.Heade Writeline drHeader.LK_I Nex '************************ 'Now Here is the sorted example where I loose Strong Typed Properties from the Unit Datase Dim drHeader As DataRowVie Dim objUnits As New CUnit(ConnectionString) 'This is a Strong Typed Dataset (.xsd objUnits.Loa Dim dvHeader as New DataView(objUnits.Header dvHeader.Sort = "LK_id desc For Each drHeader In dvHeade Writeline drHeader("LK_ID") 'This works but I lost the ability to use the typed property name (LK_ID) Nex '************************ The second example is 90% of what I want to do. Just incase the 10% is not so clear this is how you access a non-typed datase Writeline drHeader("LK_ID" and this is how you access a typed dataset Writeline drHeader.LK_I I can't figure out how to sort a dataset while maintaining the typed property names. Usually I would not care, but I have allot of class' that need to be sorted a second way and don't want to rewrite all the UI translation code Thanks in advance Freeo Tag: Stored procs to xsd example Tag: 80163
  - 20
    - Can an ImageButton be added to a Calendar day Cell? I've been trying to add an ImageButton object to a Calendar table cell, but so far I am unable to handle the Command event from that button in my form's code behind. Below is an example of what I am trying to do. The ImageButton that is on the form handles its Command event just fine, but the ImageButton that is added to the cell does not handle the event. Am I doing something wrong, or is not possible to add server controls to a calendar cell? Thanks. Chuck Hartman -- <CalendarContainingButton.aspx> <%@ Page language="c#" Codebehind="CalendarContainingButton.aspx.cs" AutoEventWireup="false" Inherits="Samples.CalendarContainingButton" trace="True"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>CalendarContainingButton</title> <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" Content="C#"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </HEAD> <body> <form id="Form1" method="post" runat="server"> <asp:Calendar id="Calendar1" runat="server" Width="100%"></asp:Calendar> <asp:ImageButton id="ImageButton1" runat="server" ImageUrl="http://msdn.microsoft.com/msdn-online/shared/graphics/icons/rtg_pr int.gif" CommandName="PrintForm" CommandArgument="DateTime.Now()"></asp:ImageButton> </form> </body> </HTML> </CalendarContainingButton.aspx> <CalendarContainingButton.aspx.cs> using System; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; namespace Samples { /// <summary> /// Summary description for CalendarContainingButton. /// </summary> public class CalendarContainingButton : System.Web.UI.Page { protected System.Web.UI.WebControls.Calendar Calendar1; protected System.Web.UI.WebControls.ImageButton ImageButton1; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } private void InitializeComponent() { this.Calendar1.DayRender += new System.Web.UI.WebControls.DayRenderEventHandler(this.Calendar1_DayRender); this.ImageButton1.Command += new System.Web.UI.WebControls.CommandEventHandler(this.ImageButton1_Command); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void Calendar1_DayRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e) { if (e.Day.Date.Day == 15) { ImageButton _ib = new ImageButton(); _ib.ID = "ib15"; _ib.Command += new CommandEventHandler(ImageButton_Command); _ib.ImageAlign = ImageAlign.Left; _ib.ImageUrl = @"http://msdn.microsoft.com/msdn-online/shared/graphics/icons/rtg_print.gif" ; _ib.CommandName = "PrintDay"; _ib.CommandArgument = e.Day.Date.ToString(); e.Cell.Controls.AddAt(0, _ib); Trace.Write("Added ImageButton Control to Calendar Day Cell."); } } private void ImageButton_Command(object sender, System.Web.UI.WebControls.CommandEventArgs e) { Trace.Write("ImageButton inside Calendar Day Cell was pressed."); } private void ImageButton1_Command(object sender, System.Web.UI.WebControls.CommandEventArgs e) { Trace.Write("ImageButton on Form was pressed."); } } } </CalendarContainingButton.aspx.cs> Tag: Stored procs to xsd example Tag: 80159
  - 21
    - Dataset math Hi.I'm lost. Winforms, ADO.Net, VB.Net Have a datagrid which is populated with a subset of my table using SQL query. What I want is the total of one column ("Sales") which I need to write into a textbox. Have had no success so far. Thanks for any help. Graeme Tag: Stored procs to xsd example Tag: 80154
  - 22
    - Retrieving Access SQL syntax Is their a way to retrieve MS Access 2000 query syntax from a VB.NET app using ADO.NET? Want to check the syntax that is in the database for something before I run the syntax Thanks Bob Tag: Stored procs to xsd example Tag: 80146
  - 23
    - Speeding up Read only data access? i am trying to speed up my code. i have commented old parts out, but leave them there for information. I have tried a data adapter and that is slower. The process is taking 10seconds, i would like to atleast half it any ideas? : Private Function CreateTblFromDR(ByVal dr As OleDbDataReader, ByVal dt As DataTable) As DataTable ', ByVal overloadParam As String Dim drow As DataRow Dim Index As Integer 'Dim i, CkNo, InvDate, Deal, InvNo, InvAmt, ref, comment As Integer 'InvDate = 0 InvAmt = 1 Deal = 2 InvNo = 3 ref = 4 CkNo = 5 comment = 6 dt.Clear() Dim counter As Integer = dr.FieldCount - 1 Dim aobjFields(counter) As Object Do While dr.Read drow = dt.NewRow dr.GetValues(aobjFields) For Index = 0 To counter On Error Resume Next drow(Index) = CStr(aobjFields(Index)) Next dt.Rows.Add(drow) On Error GoTo 0 Loop Return dt End Function Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Stored procs to xsd example Tag: 80142
  - 24
    - How to add a value to a parameter Ok, How do I assign a value to a parameter? I would like to assign the text of a web control to a parameter for addition into a database. I currently create the parameter in the code-behind as: Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@strText", System.Data.SqlDbType.VarChar, 500, "strText")) I've tried: Me.SqlUpdateCommand1.Parameters("@strText").Value = Me.strField.Text ... but it keeps on coming back claiming that strField is not a member within the class. I've had to manually create strField as it's contained within a Repeater web data control, so do I also need to some how reference it in the code behind? Any thoughts appreciated, <M>ike Tag: Stored procs to xsd example Tag: 80136
  - 25
    - Oracle.NET Data Provider and database connections In Microsoft support site, there is a mention to a bug in Oracle.Net Provider on the following link: http://support.microsoft.com/?id=330126 . But unfortunately the bug fix is not available. This bug is exactly what happens with me, but in windows application, can any one redirect me to the fix of this bug. Thanks in advance Ziad Tag: Stored procs to xsd example Tag: 80129

I have 3 pre-built stored procs and want to load the results of them
into an xsd for processing.

I've defined the XSD with different table and column names and would
like to map these to each of the procs. I can change the names if
necessary, but would rather map it, if for no other reason than to learn
how to

Does anyone have an example of how to do all this, or a link to an
article for it?

Thanks
Tim Almond

Top