| Time-out Error ! (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Friends I am having ASP.NET application and in this application sometimes I get Time out error, what this time out error is and how to put check for this error Any help in this would be appreciated. Regards Makarand |
|
| displaying the xml files in a dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a dataset with five individual tables within it. I would like to iterate through the dataset and display and/or print the raw xml documents. Where can i get info on how this is done? Thanks in advance, Al |
|
| Dataset not keeping changes/updates (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi I need some help badly. I have a Dataset that I populate via an XML string (I also have a xsd for the dataset). The Dataset actually has 3 tables. My web form simply populates the Dataset and then upadates all the fields from the form on postback. I then write the contents to an XML string and send it off. My problem is that none of the updates are reflected in the XML. What am I doing wrong. I... |
|
| strange: DataSet and WriteXml() (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi NG! This is going to drive me crazy: By working and experimenting with a XML DataBase I fire up the whole thing quite often. Therefore I coded a Routine public void CreateTestData(string path) //path is the full filename to re generate my Test Data when ever I need it. There is a XML File ("path") containing the (inline )Schema. Within "CreateTestData()" I declare a DataSet DataSet tmpDS new Da... |
|
| Oracle Provider to return Cursor (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a Stored Proc that has an output parameter as a ref cursor. How do I populate a DataSet or a DataTable via the Oracle .NET Provider? Or if you can point me in the right direction. Thanks Shariff |
|
| relational data "in-sync" in disconnected model (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How do you go about keeping relational data "in sync" in the disconnected model? In the connected model this was a bit easier to code you just joined your tables in SQL and "requeried" the grid controls every time you needed them to stay syncronised. (Less scaleable and more confusing for users who wanted to cancel child data too, but easier to code!) Example scenario... Simplified tables in back ... |
|
| Closing connections (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| In closing an ADO.NET connection, is it adequate to just use: SqlConnection.Close or should all of this be used: DataSet.Dispose DataAdapter.Dispose SqlConnection.Close SqlConnection.Dispose |
|
| DataSet from DataGrid? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it possible to get DataSet from DataGrid? If so, How? I am trying this: DataSet ds ; ds (DataSet)dgListSummary.DataSource; it fails!(gives ds as null) Thank u. |
|
| Howto:? use select rows from a datatable based on an array of GUIDs (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I can't seem to figure out how to select rows from a DataTable based on an array of GUIDs which is efficient. The DataTable can at times contain 10,000 entries and the array may have 250 GUIDs, any suggestions TIA, Peter |
|
| DataRelation (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Friends, I am using Microsoft's "Data Access Application Block" for accessing data from database. I am trying to create a menu control, which has sub menus as well. So i was thinking that DataRelation would be a good option. It seems, DataRelation needs 2 DataTables in a DataSet. The DAAB returns a DataSet with only one DataTable (i think so! i do not know how to get 2 DataTables in a DataSet u... |
|
| DataSet TableMapping Problem (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi All, I have a DataSet that contains 3 related tables. My stored proc. returns rowsets from these 3 tables. The problem is the SqlDataAdapter is having problems mapping between the SourceTable and DataTable. If I only have one table in my DataSet the default name 'Table' is used... mySqlDataAdapter.TableMappings.Add("Table","myTable"); But if I have 3 tables in my DataSet how do I create a mappi... |
|
| Severe Error occurred on the current command (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Error: SqlException: A severe error occurred on the current command. The results, if any, should be discarded. I'm using 2 SQL 2000 Servers. Server A and Server B. I have a Stored Procedure on Server A that executes a Stored Procedure on Server B through a linked server. This use to work. The only thing that has changed recently on Server's A and B is that i installed SP3 for SQL 2k. What's odd is... |
|
| Access Autonumber Fails ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi everyone, Below is the standard way to get an autonumber field that is the primary key for a table. This was working fine until the table was modified (a field was added to the table). The schemas were updated etc.. but then this code began to return a 0 and not the next autonumber. I have gone through and rebuilt the adapters, datasets and schemas but to no avail. Does anyone know why this cod... |
|
| Getting field values from the DataGrid (7 replies) |
| microsoft.public.dotnet.framework.adonet |
| I can't seem to find a way to read the value of a specific column in the current row of a DataGrid. I've done this before with ComponentOne's .Net grid and the code looks like this: strRecordID DBGrid.Columns["RecordID"].Value.ToString(); This would get me the value of the RecordID column in the current row. Can anybody show me how to do this with the standard WinDataGrid? Any help is greatly appr... |
|
| Sending NULL Date Values in SQL String (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Im trying to send a NULL value for a date data type in a SQL update string in vb.net. When i try to send NULL it tells me that it cant convert a string to data type Smalldatetime. Can someone please help? |
|
| Wildcard for Integer Field (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Using vs.net pro, vb.net, ado.net, sql native... In Component Designer, right click on a properly configured DataAdapter, Preview Data. There are 2 fields in the parameters box: PIN as string Count as integer You can enter a value of % as a wild card for PIN, but if you do the same for Count, you get an error message that says your entry is not properly configured. What can you use as a wildcard f... |
|
| Has .NET abandoned client-side data binding? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Pre .NET, I used to use RDS to stream ADO RecordSets to the client where I would bind them to tables. This gave me a very fast solution for displaying large lists asynchronously on the client. I could then perform multiple sorts on the client without hitting the server again. I've tried the server side bindings (datagrid etc) and the speed is appalling compared to what I'm used to with RDS. Al... |
|
| How to determine if a datareader field is required? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have an ASP.net page that retrieves an OLEDB datareader from an Access table. I can use the GetSchemaTable method to return schema data such as column size and provider type. However, the AllowDBNull property always returns True; even with the Primary Key. Is it possible to determine if a field is required in the datareader's parent table? |
|
| Incredible Delays with OracleClient and ASP.Net Projects (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I experience long delays when I create the first connection with an ASP.Net web site OR web Service that uses the OracleClient. It waits about 30 40 seconds the first time you call OracleConnection.Open. I do not see this delay at all when running OracleClient in a regular winform project, only in ASP.Net projects. It happends durring the first connection to oracle, and this makes me suspect the o... |
|
| How to?: access a dataview using an index (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Problem: Take a dataview of names and scores, sorted by score, and then populate an array with the name and score. The easy approach would seem to be to access the index of the dataview and increment this to walk through the view, assinging to the array during the process. My Problem: how to access the dataview index in C#? code snippet: int playerCounter; int teamCounter; int teamRemainder; int r... |
|
| Oracle Database Connection Help (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| HI Day 1 of .NET, and having difficulties getting a connection to Oracle from test program. Below is my problem. The datasource in the DSN was tested with oracled ODB Test and it works, I can also connect via SQLPLUS. DB Version: Personal Oracle8i Release 8.1.7.0.0 ..NET SDK Installed from MS Download of Jan 31, 2003. C# Code snippet of last try: string strConn "Provider MSDAORA;DSN oracle ds;UID ... |
|
| Book/Resource recommendations (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Greetings, I'm looking for some solid recommendations on books and other resources of information that cover in detail good programming practices for accessing data in SQL Server from .Net web forms. The reading I've done to date tends to leave off the all important details of error handling/trapping. Specifically, I would like to see a well developed data access class for retrieving/updating/dele... |
|
| Concurrency handling and DELETEs (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I know that the Update method supports a DBConcurrencyException that is thrown if zero rows are updated. Therefore, by appending a lot of the following crud to the UPDATE's WHERE clause: "AND PotentiallyUpdatedField @OriginalValueOfThatField" ... one can trap for other users performing updates to the same record. As far as I can tell, the same principle either doesn't apply to DELETEs or, typicall... |
|
| RejectChanges() empties the table? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am using an XmlDataDocument which is synchronized with a DataSet. I pass the XmlDataDocument to each form and synchronizing with a DataSet in that form. There are several tables defined in the XML document. There is already data in the tables. I have a few forms that allow the data to be modified. I have a Save button and a Cancel button. In the Cancel Click() method, I call ds.Tables["tablename... |
|
| DataView.RowFilter for nulls (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm attempting to filter a dataview to include only rows where a column is null. I tried several approaches: Col null and (following a solution from this list) Col Is Null. But that didn't work either. I've attached a simple VB module that demonstrates the problem. Thanks for your help, Dave |
|
