| sqlserver.exe use 100% cpu (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I just found that after I run a ADO.NET application couple times my machine cpu usage increase to 100%. From TaskManager I see the sqlserver.exe process causes the cpu usage. Do I need to call some api to close the connection or the Garbage Collection will do something later? Thanks for any help, CT |
|
| Retrieve Columns from Stored Procedure in any DB.... (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am writing a tool that will (hopefully) be able to query any database and retrieve tables, views and stored proc's along with their columns, parameters etc. I have been successfull so far using the GetOleDbSchemaTable method on the OleDbConnection object as shown below... schemaTable cnn.GetOleDbSchemaTable (OleDbSchemaGuid.Procedure Columns, new Object[] {null, null, "sp Test", null}); However,... |
|
| Bizarre C# specific Oracle Provider problem (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi there, I'm using the latest version of the MS .Net Oracle provider to connect to Oracle 9. If I try to open a connection from a C# class I get a ORA 12154: TNS:could not resolve service name exception. However if I use VB .Net it works fine. Both are console apps and all they do it create and open an OracleConnection object. The C# program throws the Exception in the Open call. The stack trace ... |
|
| SQL Query against DataSet (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi there, I am retrieving similar data from different datasources (Access database and Active Directory). Result is two DataTables containing names. I need to produce a difference list. I need to know what names are in the first table and not in the second and vice versa. Unfortunately I cannot create a SQL query against a DataSet. What would be the best/fastest approach? Thanks, SLE |
|
| .NET SqlClient Provider and Execution Plans (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have an ASP.NET app that uses SQL Server 2000 as a database. Recently one of the stored procedures has become extremly slow resulting in SqlException: Timeout expired errors. When it does not timeout it takes up to 40 seconds to run. I fired up Query Analyzer and ran the same stored procedure with the exact same parameter values and found that the procedure would run in less then 2 seconds. I th... |
|
| What's the possible to access to Deleted DataRow ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Is there any possible / way to access to Deleted DataRow on my DataTable ? Thanks. |
|
| How to get the Field Size of Access Table? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am using Microsoft Access as my application's database. How do I get the Field Size of the field in Access Table from Visual Basic? Because I am going the set the TextBox.Maxlength property according the the Field Size of the field in Access Table. Thanks. ^ ^ |
|
| Dataset - Incremental Search (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi! Is there any possibility to prepare simple incremental search with System.Data.DataSet using sort column? Thx in advance Dexter |
|
| I need readonly data- how about not the whole dataset, just a DataRowCollection or DataTable? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I need to have a call into a database which runs a bit of SQL you know "Select * from users where Username like %rick%" that sort of thing. I am just going to go through the one set of rows that comes back I don't need all the attributes of a full DataSet which is, as microsoft puts it, an in memory snapshot of a database. Is there any reason NOT to just pass around a DataTable object or a DataRow... |
|
| DataRelations in typed datasets, runtime/compile time binding (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Typed datasets seems to have a good compile time binding with the table layout, i.e. all the table names and columns names are bound to a C# class in compile time. But I found no compile time binding equivalent for the data relations, however it could have been done. A practical example: MyTypedDS myDS; //Defines two tables parent and child, and has a relation between them. foreach (MyTypedDS.Pare... |
|
| Querying across tables in a dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi everyone, I have a strongly typed dataset with 5 tables. The relationships between all the tables are already in the dataset. I want to create a dataview to bind to a datagrid (in a WinForm app) where the data is spread across (joined) between 3 tables. How can I create a view with a subset of the data to be bound to the datagrid? Just to spell things out, let's say I have tables 1, 2 and 3. I ... |
|
| read data from dataset (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| i'm sure there must be a simple answer to this but i can't find it on the net. i have a dataset which contains data about 2 tables (tableA and tableB). i would like to loop through records of tableA (in the dataset) and read the values. i have done the following, but i know its wrong because it doesn't work... what am i doing wrong? thanks! for (long i 0; i oDataSetMessages.Tables["tableA"].Rows.C... |
|
| How can i update several rows in a table at once ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How can i update several rows in a table at once ? I use a OleDbConnection. Perhaps whith a loop ? Christophe |
|
| Pass transaction between classes (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I'm trying to pass a transaction between several classes. I pass the connection & the transaction through all the classes I need and all the updated are done. My problem is when I try to do a Commit. I get the following error: "This SqlTransaction has completed; it is no longer usable." what a I doing wrong? Thanks, Ofir |
|
| Is there any where I can see a grid comparing SQL Types to system Types? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I need a table showing how these map to each other. Also if I use sqltypes do I have to cast a string to a SqlString when I retrieve it from a Web Control? I'm looking for optimal speed in our web app, and I've read the sqltypes are faster than system types, but I'm concerned with boxing and unboxing during type conversions. Currenly we map strings to varchar's, datetime to sqldatetime etc. What i... |
|
| Need help for DefaultView problem (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm using a textBox bound with a datatable, to get the right information I use a filter on the datatable.defaultView. every thing is working, but when I save, there is no error but the information isn't saved. here is my code Private WithEvents DATestAs OleDb.OleDbDataAdapter create the dataadapter select * from testTable txtTest.DataBindings.Add("Text", datatableTest,"field") ..... dataSetTes... |
|
| Once is not enough (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a form that uses a sproc from a SQL server 7.0 database to populate a datagrid using the DataAdapter.fill method Although the sproc runs reliably using the Query Analyzer or Access 2002, it always returns an exception using ADO.net. The return is not large, 1000 rows by 57 columns. The 7.0 Query analyzer uses ODBC and Access 2002 uses ADO without the net. Using a try/catch block I can force... |
|
| Close connection in webApp explicitly? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi! If I have a class, and I have a connection property, which I use to access the database... How do you make sure, the connection is returned to the connection pool? Must I make the connection public and explicitly close it, when I am done with the class? Or is it enough to add Me.connection.close in Protected Overrides Sub Finalize()?? Fx: Public Class Forhandler Private strConnectionString As ... |
|
| Merge Error After ReadXml (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm having trouble with Merge creating duplicate records, violating primary key constraints. I have a DataSet w/ Primary keys set up for each table. I make some changes. Merge data from server w/ PreserveChanges True works fine. I make some more changes I write it and its schema out to Xml using DiffGram mode I restart and read the dataset and it's schema from Xml Merge data from server w/ Preserv... |
|
| Getting a list of table names from a database (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Is it possible to get a list of tables in a database in SQL Server? Is is also possible to get a list of fields in each table? Are there any examples of this please? |
|
| Should I close a connection in a dispose method? (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've built a class to broker the data in may application. In other words, when my business logic needs a list of widgets in the db, it calls mybrokerclass.getWidgetList, which might return a collection or arraylist of widgets. This way, the business logic doesn't care about where the data comes from. (BTW, this is a web application) So my problem is this.. during a postback, a series of operations... |
|
| Data Adapter and Command Names (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I created a DataAdapter by Dragging a table from my Server Explorer (Connection Table) and rename the Adapter from the properties window. Now the Commands (Insert, Update etc) still reads as sqlUpdateCommand1, sqlInsertCommand1 etc. Any way of changing these statements to match my Adapter name. Thanks, Rajesh Abraham Chacko |
|
| Connection pool for DataReaders? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| My VB.NET/ADO.NET/SQL Server application requires asynchronous population of some very large lists. The obvious answer was VB's new threading support. This works wonderfully, except that the secondary thread holds an open SqlDataReader for a while, causing any other query on the database to fail until it is done (only one DataReader is allowed to be open per connection). Consequently I threw toget... |
|
| Hide/Rename Column in Datagrid (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I want to use a XML document as the DataSource of a DataGrid. I am doing this simply by: DataSet dataset; string xmlfilelocation @"C:\source.xml"; dataset.ReadXml(xmlfilelocation); There are two things I want to achieve: 1) Hide the "id" column of the dataset. 2) Change the physical column name to something more meaningful to the users. I've searching arround the internet for answer, somebody sugg... |
|
| Help Frams Bouma (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've recently been using your LLBL code generator as an assist to stubbing out my classes and I noticed that you use Sqltypes as your property return types. If I leave these as is do I have to cast my values from string toSqlString and from DataTime to SqlDate and from int to SqlInt32 etc......Isn't that a lot of casting to be doing? I'm very curious about how to properly use these types. We are d... |
|
