Refreshing database cache

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
    - Array as input parameter Hi all, I need a SQL stored procedure that has an input parameter of type array of datetimes. How to define such a procedure? if possible Thanks, Tag: Refreshing database cache Tag: 80330
  - 2
    - need suggestion in Guid autogeneration in dataset Hi al I have PK with Guid type in typed dataset Is anybody have any suggestion how 2 implement autogeneration of P thnks Tag: Refreshing database cache Tag: 80326
  - 3
    - System.Data.OracleClient Couldn't understand why following line of code is failing <%@ Import namespace="System.Data.OracleClient" % I am getting following error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be foun Although I can see the System.Data.OracleClient in References and I have v1.1 framework installed. Tag: Refreshing database cache Tag: 80325
  - 4
    - Timeout Expired error. Hi there! I am using MSDE 2000 SP3, Sql.Net provider on Win2k server. When I try to execute very simple query of inserting/selecting a row into a table, I am getting following error, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." This behaviour is not consistent. I have checked my code for not leaving any connection open. Is there any limitation on number of connections on MSDE? Or is it a problem with Sql.Net provider? Please help me. Thanks in advance. Tag: Refreshing database cache Tag: 80324
  - 5
    - FoxPro connect problems REGDB_E_CLASSNOTREG I'm using vs.net, clr 1.1, c# web application. I get the following error connecting to foxpro using its oledb driver. I've tried several ways to connect. No error information available: REGDB_E_CLASSNOTREG(0x80040154). [OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).] [InvalidOperationException: The 'vfpoledb.1' provider is not registered on the local machine.] System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) System.Data.OleDb.OleDbConnection.Open() Elkhorn.eCatData.Page_Load(Object sender, EventArgs e) in j:\projects\aproject\aproject\webui\data.aspx.cs:45 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() I downloaded and installed the driver foxpro8 driver from: http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en I don't have any verison of foxprox on the machine. I registered vfpoledb.dll myself from the command line just to make sure. The connection tested ok with the "Test Connection" button when I used the designer. I think the connection string is fine, is as on connectionstrings.com. @"Provider=vfpoledb.1;Data Source=C:\progra~1\aproject\data\data1.dbc;Password=;Collating Sequence=machine"; Any ideas? ??? Tag: Refreshing database cache Tag: 80320
  - 6
    - Concurrency violation, I don't understand! [This followup was posted to microsoft.public.dotnet.framework.adonet and a copy was sent to the cited author.] Hello everybody. I have a problem with an exception when I try to modify a row in a mssql db. The exception that I found is Concurrency violation. I read some other posts but I didn't find a solution. In effect with my code I want to replace all the strings inside a "info" attribute with the word "Hello" (This is a test, I know that this is a stupid thing, but I wanna make that). My code update 212 row but give me a concurrency violation in 7 roes. All these 219 rows are selected at the same time e stored inside the same table. The rows that I can't update are like the following: "IST. DI CLIN. CHIR. GEN. E TERAPIA CHIR. PROF.BATTEZZATI" But if I use SQL to replace this string with another one shorter (Like "IST. DI CLIN. CHIR. GEN. E TERAPIA PROF.BATTEZZATI" or "IST DI CLIN CHIR GEN E TERAPIA CHIR PROF BATTEZZATI" ) and then I run my code, it works fine and this line is replaced by the "Hello" word. In the db the info attribute is a nvarchar(90), I don't understand where is the problem. Is there some limit in the dimension of string that can be inserted in a datarow or datatable object? Thanks to everybody Tag: Refreshing database cache Tag: 80318
  - 7
    - Stored procs to xsd example 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 Tag: Refreshing database cache Tag: 80317
  - 8
    - 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: Refreshing database cache Tag: 80314
  - 9
    - 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: Refreshing database cache Tag: 80311
  - 10
    - 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: Refreshing database cache Tag: 80307
  - 11
    - 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: Refreshing database cache Tag: 80300
  - 12
    - 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: Refreshing database cache Tag: 80299
  - 13
    - 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: Refreshing database cache Tag: 80298
  - 14
    - 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: Refreshing database cache Tag: 80295
  - 15
    - 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: Refreshing database cache Tag: 80294
  - 16
    - 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: Refreshing database cache Tag: 80292
  - 17
    - 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: Refreshing database cache Tag: 80290
  - 18
    - 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: Refreshing database cache Tag: 80289
  - 19
    - 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: Refreshing database cache Tag: 80282
  - 20
    - 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: Refreshing database cache Tag: 80281
  - 21
    - 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: Refreshing database cache Tag: 80277
  - 22
    - 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: Refreshing database cache Tag: 80274
  - 23
    - 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: Refreshing database cache Tag: 80265
  - 24
    - 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: Refreshing database cache Tag: 80264
  - 25
    - 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: Refreshing database cache Tag: 80262
- Next
  - 1
    - 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: Refreshing database cache Tag: 80261
  - 2
    - 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: Refreshing database cache Tag: 80257
  - 3
    - 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: Refreshing database cache Tag: 80254
  - 4
    - 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: Refreshing database cache Tag: 80249
  - 5
    - 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: Refreshing database cache Tag: 80244
  - 6
    - 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: Refreshing database cache Tag: 80241
  - 7
    - 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: Refreshing database cache Tag: 80240
  - 8
    - 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: Refreshing database cache Tag: 80239
  - 9
    - 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: Refreshing database cache Tag: 80234
  - 10
    - 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: Refreshing database cache Tag: 80228
  - 11
    - 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: Refreshing database cache Tag: 80215
  - 12
    - 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: Refreshing database cache Tag: 80207
  - 13
    - 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: Refreshing database cache Tag: 80198
  - 14
    - 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: Refreshing database cache Tag: 80197
  - 15
    - 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: Refreshing database cache Tag: 80196
  - 16
    - 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: Refreshing database cache Tag: 80195
  - 17
    - 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: Refreshing database cache Tag: 80193
  - 18
    - 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: Refreshing database cache Tag: 80187
  - 19
    - 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: Refreshing database cache Tag: 80183
  - 20
    - 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: Refreshing database cache Tag: 80178
  - 21
    - 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: Refreshing database cache Tag: 80177
  - 22
    - 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: Refreshing database cache Tag: 80176
  - 23
    - Executing PL/SQL Block How can i execute Oracle PL/SQL block using the Oracle Command Object? Tag: Refreshing database cache Tag: 80173
  - 24
    - 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: Refreshing database cache Tag: 80168
  - 25
    - 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: Refreshing database cache Tag: 80167

Dear all

I have written a windows service that connects to an Oracle 9 database on
start up. I use a DataTable to hold a set of near static data.

Recently there have been some overnight external batch updates to this table
and my DataTable needs to be refreshed. Since this change of circumstances I
have been restarting my service in the morning. I need to find a way to
fresh my data object without restarting the windows service. I would be
grateful for any pointers.

Regards,
Wazir

Re: Refreshing database cache by Miha

Miha
Thu Feb 19 08:20:41 CST 2004

Hi,

Hmm - clear datatable and redo the select?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"MW" <mwazir77_ns@hotmail.com> wrote in message
news:%23NMNpCv9DHA.2028@TK2MSFTNGP10.phx.gbl...
> Dear all
>
> I have written a windows service that connects to an Oracle 9 database on
> start up. I use a DataTable to hold a set of near static data.
>
> Recently there have been some overnight external batch updates to this
table
> and my DataTable needs to be refreshed. Since this change of circumstances
I
> have been restarting my service in the morning. I need to find a way to
> fresh my data object without restarting the windows service. I would be
> grateful for any pointers.
>
> Regards,
> Wazir
>
>

Re: Refreshing database cache by MW

MW
Thu Feb 19 09:51:54 CST 2004

The updates to the table happen external to my service and thus I dont know
when to redo the select.
Is there any set mechanism to expire the object say every 24 hours and
reload the contents?

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%23prtMOv9DHA.2756@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Hmm - clear datatable and redo the select?
>
> --

Re: Refreshing database cache by Miha

Miha
Thu Feb 19 10:59:13 CST 2004

Hi,

"MW" <mwazir77_ns@hotmail.com> wrote in message
news:%23jsRSBw9DHA.328@tk2msftngp13.phx.gbl...
> The updates to the table happen external to my service and thus I dont
know
> when to redo the select.
> Is there any set mechanism to expire the object say every 24 hours and
> reload the contents?

System.Timers.Timer?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com