Multiple Active Result Sets - general question

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
    - Multiple Active Result Sets (MARS) Two questions relating to this: 1 - Do I require SQL Server 2005 or can this work with SQL Server 2000? 2 - My ASP.NET book says that I require MDAC 9.0. My registry setting says that I'm using 2.8 but I can't find where I can download an update from. Thanks if you can help with either of these questions. Griff Tag: Multiple Active Result Sets - general question Tag: 124429
  - 2
    - How to bend ADO.Net to my liking... Data: A line (row) containing multiple fields (columns) Requirement: 1: Allow new lines to be inserted at any point 2: Allow deletion of any line 3: Keep the lines in the correct order Examples: When given a table with three lines: Line 1 Line 2 Line 3 1: An insert after Line 2 makes Line 3 become Line 4 and the new Line will be Line 3 2: A delete of Line 2 will make Line 3 become Line 2 Outside of ADO.Net, the lines would simply be a link list to make insertion and deletion quick and easy. The objective is to use a DataSet so that it can simply be bound to a DataGridView for display. The best solution I have been able to come up with is to have an ordinal number field that is hidden that initially increments by some large amount, say 1000: Line 1 (1000) Line 2 (2000) Line 3 (3000) After inserting a line after Line 2 would result in this: Line 1 (1000) Line 2 (2000) Line 3 (2500) Line 4 (3000) I imagine that this is an age old problem in relational databases and there is a better solution. Does anyone know of a better way? Tag: Multiple Active Result Sets - general question Tag: 124418
  - 3
    - Use of DataRelation is locking rows in DataTables I am using a DataSet generated using VS2003 .xsd files direct from db tables. I then add some DataRelations to the DataSet programatically. I am running into the following problem: any time I call GetChildRows() using a particular DataRelation the parent column becomes ReadOnly. All subsequent attempts to edit the parent column are now throwing ReadOnlyException and the only way I have found to clear it is to remove the DataRelation from DataSet.Relations - (and later add it again when I next want to do a lookup). I guess I am somehow missing part of the picture - what should I be doing to avoid this problem and what is causing it? Tag: Multiple Active Result Sets - general question Tag: 124413
  - 4
    - performance of single database vs multiple databases Hi I am currently working on a portal for an online university. The portal allows students, teachers, and administrators to access information, and perform certain tasks based on roles. We are currently developping tools for managing quizzes, assignments, news. What I realize if we have many courses, and if each course has it's own database, there are tables which are being repeated. Here is an example of two courses databases each with the necessary tables to run a quiz. All tables except the Courses table use foreign keys to relate to the parent table. Course A url -> "http://myservername/courseA" dbo.Courses (Id, Name, Description, Language, Semester) dbo.Quizzes(Id, Name, Description, CourseId) dbo.Questions(Id, Name, Question, Choices, QuizId) Course B url -> "http://myservername/courseB" dbo.Courses (Id, Name, Description, Language, Semester) dbo.Quizzes(Id, Name, Description, CourseId) dbo.Questions(Id, Name, Question, Choices, QuizId) So as you can see, Course A and Course B have both the same three tables (Courses, Quizzes, Questions). Of course some tools will need to talk to both course databases to generate reports, calculates grades, etc. Now is it better to use a single huge database with only the three tables (Courses, Quizzes, Questions), or is it better to keep them seperate? If so then why? Is performance better with multiple databases, or with a single database? Also I'm programming in asp.net 2.0 and would like to use typed datasets, and from what I found typed dataset can only use a single connection string. Is there a way around that? Also what about caching? If would appreciate any feedback or advice. Francis Tag: Multiple Active Result Sets - general question Tag: 124412
  - 5
    - ExecuteNonQuery against a stored procedure does not insert ntext f Hi, I have an SP that inserts some data including an ntext field for large strings (4 M chars) When executed, ExecuteNonQuery returns -1, but the insertion occurs with all but the ntext field populated correctly, the ntext field is blank. The string is an xml fragment. Any ideas? Regards Tag: Multiple Active Result Sets - general question Tag: 124405
  - 6
    - VS2005, C#, DataBinding of SqlServer 2K TimeStamp datatype Newbie Warning! There, out with the full disclosure. I have a datatable with a variable "CreationDate" of type TimeStamp. I'm trying to learning Data Binding, when I drag the table onto my Windows Form (2.0) and try to compile, I get an error about incompatible type conversions. What I want to happen is to have the TimeStamp displayed as a Date on my form (read-only, not updateable). How do I need to configure the databinding so that a TimeStamp (byte[]) is converted properly? TIA Tag: Multiple Active Result Sets - general question Tag: 124404
  - 7
    - Information for writing an ADO.NET 2.0 Data Provider I am in the process of writing an ADO.NET 2.0 Data Provider but I'm finding the lack of documentation is making the process rather slow. Can anyone suggest any sources of information? Thanks, Mark Tag: Multiple Active Result Sets - general question Tag: 124403
  - 8
    - DBConcurrencyException in Update() hi. im at wits end! my update command isnt working properly. im able to edit and delete data successfully with the same command builder, but when i add a new row and update, i get an "affected zero records" message. Dim cb2 As New OleDb.OleDbCommandBuilder(da2) dv.AllowNew = False gnrow = ds.Tables("exp").NewRow() ds.Tables("exp").Rows.Add(gnrow) da2.Update(ds, "exp") max1 = ds.Tables("exp").Rows.Count 'assigning the new record to the open employee record ds.Tables("exp").Rows(max1 - 1).Item("emp") = wonly1 da2.Update(ds, "exp") ------------------> this is where the program seizes up. will someone please tell me what to do to fix it? -- it's all latin & geek to me! ;-) Message posted via http://www.dotnetmonster.com Tag: Multiple Active Result Sets - general question Tag: 124399
  - 9
    - Report question Dear all, I want to create a crystal report like the following format, but don't know how to do this Date Expenditure 01-Jan 1832 02-Jan 39933 .... 31-Jan 35355 Total:252353 (this is not repeated items!!) 01-Feb 95875935 .... 31-Feb 32957235 Total: 355553000880080 How to show the [total] within??? Tag: Multiple Active Result Sets - general question Tag: 124398
  - 10
    - Best and quikest method to filter a dataview What is the fastest method to filter a dataview? Tag: Multiple Active Result Sets - general question Tag: 124391
  - 11
    - What could be causing this while updating a DataTable? Hi there, I am getting this exception "Deleted row information cannot be accessed through the row" when trying to update a datatable with an adapter: mAdapter.Update(mTable); <== exception here After struggling with this for hours, I am now looking for a more generic answer, i.e., does anyone know the possible scenarios in which this exception might occur inside the Update method. What "mistake" on my side could be triggering it. The exception usually happens if I: 1) Delete all rows in the table: for (int i = 0; i < mTable.Rows.Count; i++) mTable.Rows[i].Delete(); 2) Add new rows to the table => mTable.Rows.Add(newRow); 3) Call the update method => adapter.Update(); Thanks in advance for any opinions, -Benton Tag: Multiple Active Result Sets - general question Tag: 124388
  - 12
    - SqlException in Visual Studio 2005 First of all, I apologize if I'm not posting this in the appropriate group. This is my first time using these Newsgroups, so I'm trying to find my way around. That said, this is my problem: I have a stored procedure I'm calling from Visual Studio 2005. The query works just fine in query analyzer, but returns a very generic error in VS. Here's my stored procedure: CREATE PROCEDURE [dbo].[prc_AssetChangeVendorDetailID] @OldVendorDetailID int, @NewVendorDetailID int AS SET NOCOUNT ON UPDATE [Asset] SET [VendorDetailID] = @NewVendorDetailID WHERE [VendorDetailID] = @OldVendorDetailID and the code that calls it is: //Update all asset records with the old vendor detail ID to new ID. cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.AddWithValue("@OldVendorDetailID", 1); cmd.Parameters.AddWithValue("@NewVendorDetailID", 2); cmd.CommandText = "[prc_AssetChangeVendorDetailID]"; cmd.ExecuteNonQuery() I get an exception with the message of "Line 1: Incorrect syntax near 'prc_AssetChangeVendorDetailID'." Normally, I wouldn't argue with the editor, but the fact that the procedure executes without a problem in query analyzer is what has me stumped. Is there something I'm doing wrong? Tag: Multiple Active Result Sets - general question Tag: 124385
  - 13
    - Problem saving changes to table I receive the following error when trying to update a table after editing. System.InvalidOperationException was unhandled Message="Update requires a valid UpdateCommand when passed DataRow collection with modified rows." Source="System.Data" Here is the code: Private Sub SaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TestBindingNavigator.Click Me.Validate() Me.TestBindingSource.EndEdit() Me.TestTableAdapter.Update(Me.DBDataSet.Test) End Sub Private Sub Form1tmp_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DBDataSet.iScanLogin' table. You can move, or remove it, as needed. Me.TestTableAdapter.Fill(Me.DBDataSet.Test) End Sub In other sections of the program I am able to save changes on other tables in the same manner without any errors. What am I doing wrong? Tag: Multiple Active Result Sets - general question Tag: 124377
  - 14
    - DataRowView and objects don't match? Hi there, I have this method to search a DataView: public int FindIndex(string columnName, object key) { index = -1; foreach (DataRowView drv in table.DefaultView) { if (drv[columnName].Equals(key)) { index = i; break; } i++; } return index; } So far this does not work: int i = FindIndex("IDFIELD", textBox1.Text); <= I get a -1 However, this does work ok: string search = textBox1.Text; int i = SearchIndex("IDFIELD", Convert.ToInt32(textBox1.Text)); In this case I get the correct index. Any ideas? Regards, -Benton Tag: Multiple Active Result Sets - general question Tag: 124375
  - 15
    - Where to start? * Plateform: .Net 2.0 * Question: Is ado.net the solution? If so, what should I be looking into? * Data: schedule containing: 1 to n properties collection of lines line containing: 1 to n properties * Data Source: An engine that needs to take the saving of the data to keep a version history. The design is complete for how the versioning will be kept; it is based on doing a difference of what is saved and what is in memory. * Problem How to display this data and allow the user to make changes to it. * My thoughts I have limited knowledge of ado.net, but I am guessing that it is pretty straight forward to display the collection of lines, or a DataSet table of lines, in a datagrid. What I don't understand is how best to couple the data in the engine with a dataset. Do I simply create a DataSet (one of those .xsd files) and create a table for the collection of lines, have the engine populate it and have the GUI send it back to the engine for saving? Or is there a more sophisticated way of creating my own DataSet? Are there other ado.net classes I should be learning about to make the engine a sort of provider for then GUI? Tag: Multiple Active Result Sets - general question Tag: 124374
  - 16
    - DataTableReader Problem Help: I am trying to use a datatable reader to loop through a datatable but I get the following error message when I try: System.InvalidOperationException was unhandled Message="DataTableReader is invalid for current DataTable 'CABG_Transfer_to_Raw'." Source="System.Data" This is the code to get the reader. I preview the CABG_Transfer_to_Raw table and the data is shows up. Any ideas Me.CABG_Transfer_to_RawTableAdapter.Fill(Me.HQIPatientLevelDataSet1.CABG_Transfer_to_Raw) Dim dtreader1 As DataTableReader dtreader1 = Me.HQIPatientLevelDataSet1.CABG_Transfer_to_Raw.CreateDataReader If dtreader1.HasRows = True Then Do While dtreader1.Read Dim Message As String = dtreader1("Diag_Code") Dim Caption As String = dtreader1("Site") Dim Buttons As MessageBoxButtons = MessageBoxButtons.YesNo 'Displays the MessageBox Dim msbxResultDim As DialogResult msbxResultDim = MessageBox.Show(Message, Caption, Buttons) Loop End If This is what I get: System.InvalidOperationException was unhandled Message="DataTableReader is invalid for current DataTable 'CABG_Transfer_to_Raw'." Source="System.Data" Tag: Multiple Active Result Sets - general question Tag: 124371
  - 17
    - Can we use custom function in the DataColumn.Expression I am using VS2005. I add a column to a DataTable in a DataSet. Can Iuse custom function in the DataColumn.Expression? Tag: Multiple Active Result Sets - general question Tag: 124369
  - 18
    - Large Text. I'm wanting to save and retreive text from a multiline textbox which I've been told can become extremely large and I'm not sure how this is to be done(c#). I'm guessing SqlServers Text type is ok and some kind of chunking of the lines in the textbox. Any pointers will be greatly appreciated. Thanks. Steve. Tag: Multiple Active Result Sets - general question Tag: 124365
  - 19
    - Multithreaded access with TableAdapters We have an app under development processing data from com port events. There can be multiple com ports all sending data back to this one method on one instance of a class â??ldâ??. This method gets a db object associated speciffically with THAT com port. The db objects wrap a datatable and a tableadapter. So if we have COM1, and COM3 in use we might have something like this ld -> retrieves -> dataAdapterObjCOM1 dataAdapterObjCOM3 If I am running with only one com port all works fine. With more than one I get many errors in the Designer class for the db stuff. All the db objects are separate instance of objects specifically associated with that com port. So no two threads should be trying to access the same db wrapper objects at the same time. The errors include: The connection was not closed. The connection's current state is connecting. When trying to insert with the adapater. Note: I am testing for this connection state right before the insert line and sometimes it will see it sometimes it wonâ??t. I know doc says its for future use but I am getting it now. Object reference not set to an instance of an object. on DataTable NewRow() I unplug the extra comport and everything works fine again. Any suggestions? Tag: Multiple Active Result Sets - general question Tag: 124358
  - 20
    - SQL CONTAINS clause parameter substitution problem Hi, I'm in the process of parameterising the SQL SELECT statements in my ASP.NET application so that I don't directly include user input in the SQL (to protect against SQL Injection attacks). I've run into a problem with a statement which has a CONTAINS clause, which seems to result from parameters within quotes not being substitued. The following examples illustrate the results when the user inputs a single search string ("bottle") and two search strings ("bottle" and "corkscrew"). With user input embedded in the SQL it all works as expected for both single and multiple search strings: SELECT * FROM CatalogueItems WHERE (CONTAINS (Description, '"bottle"')) This returns all records whose Description field contains the word "bottle" (as expected). Note the single and double quotes around the "bottle" search string. Without the single quotes I get an "Incorrect syntax near 'bottle'" error. The double quotes seem optional, but I included them as they are needed if multiple search strings are specified (see below). SELECT * FROM CatalogueItems WHERE (CONTAINS (Description, '"bottle" AND "corkscrew"')) This returns all records whose Description field contains the word "bottle" and the word "corkscrew" (as expected). Note the single and double quotes around the search strings. The double quotes are needed because multiple search strings are specified (without them I get an "Incorrect syntax near the keyword 'AND'" error). My problems began when I modified the (C#) code to use an SqlCommand Object with parameters instead of directly embedding the user input in the SQL... Searching using a single parameter works fine: SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@SearchWord1", SqlDbType.Char, 6)); sqlCommand.Parameters["@SearchWord1"].Value = "bottle"; sqlCommand.CommandText = "SELECT * from CatalogueItems WHERE (CONTAINS (Description, @SearchWord1)) This returns all records whose Description field contains the word "bottle" (as expected). Note the absence of single quotes around the "@SearchWord1" parameter. If the quotes are added, then I get no results. Searching with two parameters fails: SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@SearchWord1", SqlDbType.Char, 6)); sqlCommand.Parameters["@SearchWord1"].Value = "bottle"; sqlCommand.Parameters.Add(new SqlParameter("@SearchWord2", SqlDbType.Char, 9)); sqlCommand.Parameters["@SearchWord2"].Value = "corkscrew"; sqlCommand.CommandText = "SELECT * from CatalogueItems WHERE (CONTAINS (Description, '"@SearchWord1" AND '"@SearchWord2"')) This does not return any results. Omitting single and/or double quotes from around the parameters causes varying types of failure: CONTAINS (Description, @SearchWord1 and @SearchWord2) Gives "Incorrect syntax near the keyword 'AND'" error. CONTAINS (Description, '@SearchWord1 and @SearchWord2') Gives no hits. It looks like enclosing the parameters in quotes prevents their substitution, but leaving the quotes out causes SQL syntax errors. Can anyone tell me how to do this please? Tag: Multiple Active Result Sets - general question Tag: 124357
  - 21
    - Serialized ADO.NET 1.0 dataset compatible with ADO.NET 2.0 Is it possible to serialize an ADO.NET 1.0 dataset to xml and then to deserialize it back to an ADO.NET 2.0 dataset ? And visa versa ? Is this functionality supported for the Compact Framework also ? Best regards Kay-Christian Wessel Tag: Multiple Active Result Sets - general question Tag: 124353
  - 22
    - Fill strongly type dataset from stored procedure Dear all, I have a file-strongly type dataset, that have two independent table inside it. I want to fill the two table in the dataset by one stored procedure(have two select sql on it) how can i do e.g. create spname .. SELECT * FROM table1 SELECT * FROM table2 GO and Dataadapter.fill(dataset.table1) but how about table2 Tag: Multiple Active Result Sets - general question Tag: 124345
  - 23
    - how to get output parameters using enterprise library 2.0 hi, how do I get output parameters from sql 2005 query using the entlib 2,0? I noticed the dbcommandwrapper is not there anymore. thanks xisco Tag: Multiple Active Result Sets - general question Tag: 124344
  - 24
    - Using a design time connection from a class Hi, I've created an SQLConnection by dragging a DataAdapter onto the form. The connection was named sqlConnection1. When I try to reference this connection in code from another class, I cannot find it. Intellisense only finds the classe SQLConnection. This must be a scope issue. How can I reference the forms connection object from code? Do I need to create another connection in the class, or pass it to the class, or is there a way of directly referencing it? Many thanks for your advice in advance. Ant Tag: Multiple Active Result Sets - general question Tag: 124339
  - 25
    - Looking for an alternative Current project is in .NET 2003 using SQL Server 2000. I use strongly typed datasets in this app, created by dragging a table form Server Explorer to a design surface, walking thru the SQL Data adapter wizard and generating Datasets. The database in the Server Explorer is a db designed and maintained just for the purpose of generating strongly typed datasets. I also maintain a SQL Script in one of my projects (generated from the template database) to create new databases from within my app. My problem arises when I want to modify the tables in the database. I have to delete the Dataset, remove the Sql DataAdapter from the design surface, modify my table, re-drag it back to the design surface and walk thru the whole process of creating SDA's and Datasets again, and modifying the SQL script. Adding a column to a table ends up taking an hour or more. Is there an alternative, a tool, a utility, etc that can help automate this or replace it entirely? NOTE: We will soon be migrating the app to Net 2005 and SQL Server 2005. Will this problem go away in .NET 2005? Michael Tag: Multiple Active Result Sets - general question Tag: 124335
- Next
  - 1
    - DataTable.AcceptChanges error, "Destination Array was not long eno I am encountering a situation where I'm trying to AcceptChanges() on a DataTable and this is throwing a Destination array was not long enough. Check destIndex and length, and the array's lower bounds. error from within this call. Can someone shed some light on this? What could have been done to lead to this error being thrown on such an apparently simple call?? Regards, -- TB Tag: Multiple Active Result Sets - general question Tag: 124332
  - 2
    - Generating an SqlParameter from a value in a DataSet How can I generate a Parameter if I cannot retrieve the SqlDbType from an item in a row of a DataSet? Is it safe to just take the object I retrieve from the DataSet and take the following constructor for the Parameter: SqlParameter(string parameterName, object value)??? Regards Stephan Tag: Multiple Active Result Sets - general question Tag: 124328
  - 3
    - How do I set the DateTimeMode property when filling a DataTable [ I posted this in Microsoft.Public.Data.Ado, but I haven't had a response. I thought I would try here too. ] I am investigating how best to manage UTC timestamps in ADO.Net. We ran into a lot of issues with UTC DateTime serialization in .NET 1.1. With .NET 2.0, there are new properties to help identify when a DateTime (as part of a DataTable or as a regular object) is UTC or local. I have been able to handle all cases so far except one. In our database we store all timestamps in UTC. I want to retrieve the data into a DataTable whose column has the DateTimeMode property set to DataSetDateTime.Utc. I can't figure out how to do this. Any suggestions? I have tried setting the DateTimeMode after the DataTable has been populated, but that causes an exception. I haven't been able to find anything in SQL Server 2005 that would allow me to specify that a DateTime column is a "UTC" DateTime. The only way I've been able to do it is by adding the columns manually before calling adapter.Fill(). I hope there is a better way. Here is my test code. I know it is poor coding, but it is only a test. For simplicity, I just use a raw SQL statement. SqlConnection conn = new SqlConnection(@"server=(local);database=master;uid=sa;pwd=password;"); SqlCommand cmd = new SqlCommand("SELECT GetDate() AS local, GetUTCDate() AS utc", conn); cmd.CommandType = CommandType.Text; SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable("TryIt"); dt.Columns.Add("utc", typeof(DateTime)); dt.Columns["utc"].DateTimeMode = DataSetDateTime.Utc; dt.Columns.Add("local", typeof(DateTime)); dt.Columns["local"].DateTimeMode = DataSetDateTime.Local; try { adapter.Fill(dt); dt.Columns["utc"].DateTimeMode = DataSetDateTime.Utc; dt.Columns["local"].DateTimeMode = DataSetDateTime.Local; } catch (Exception) { throw; } DateTime local = (DateTime)dt.Rows[0]["local"]; DateTime utc = (DateTime)dt.Rows[0]["utc"]; Tag: Multiple Active Result Sets - general question Tag: 124327
  - 4
    - How can I find the BindingSource has some changed data Hi, In my WinForms application, I have a set of controls that are bound to a BindingSource control. When the user closes the form, I need to ask him if he wants to save data. The problem is I cannot find anyway to check if the value of any textboxes is changed! Obviously checking DataSet.HasChange is not adequate. The reason is that the user might be in middle of adding or editing a record so the record has not been reflected to underlying dataset yet, but user accidentally clicks on form close button. Any help would be appreciated, Alan Tag: Multiple Active Result Sets - general question Tag: 124326
  - 5
    - Bug in TableAdapter Code Generator? I've run into problems using TableAdapters under VS2005 where the underlying Fill() method fails due to a constraint violation. This occurs when there was no change to the data of the underlying table -- hence there shouldn't be a constraint problem, so far as I can see -- but where the width of an nvarchar field changes (this occurs with SqlServer2005). Apparently, the TableAdapter code is sensitive to width mismatches between the field in the table and the field as it is described in the TableAdapter. That's not necessarily a bug...but the fact that reconfiguring the TableAdapter (by running its Configure context menu command) doesn't solve the problem surely is. Running the configuration command on a table where an nvarchar field's width has changed does not update the width specification for the column in the TableAdapter. You have to go in and do that manually (or recreate the entire TableAdapter from scratch, which is what I was doing early on...but that's a royal pain). Needless to say, having to manually update for field width changes is a pain. - Mark Tag: Multiple Active Result Sets - general question Tag: 124325
  - 6
    - SQLAdapter Timeout doesn't work Hi everybody, i've a problem with loading a dataset: i need to load entire contents of various tables into dataset, however i don't know size of this table. If table size is too big simply i need a timeout exception and go on. The problem is that when the table is too big, the Fill method avanza without any timeout. Why? Mehod code is this: private DataSet LoadDataSet ( int Table, DBtype db, out string ErrorMsg) { DataSet ds = new DataSet(); SqlDataAdapter adapter = null; string cmd; string TableName; ErrorMsg = ""; try { // Table name TableName = GetTableName ( Table ); // Compose Select statement cmd = "SELECT * FROM " + TableName; // SqlDataAdapter (GetConnectionString compose the string and set connet timeout = 10) adapter = new SqlDataAdapter( cmd, GetConnectionString()); adapter.SelectCommand. // Ten seconds for the command adapter.SelectCommand.CommandTimeout = 10; // And ten seconds for the connection (i think i don't need because i set before) adapter.SelectCommand.Connection.Timeout = 10; // // Execute // adapter.Fill( ds ); return ds; } catch ( System.Exception ex ) { ErrorMsg = ex.ToString(); return null; } finally { if ( adapter != null ) adapter.Dispose(); } } Tag: Multiple Active Result Sets - general question Tag: 124313
  - 7
    - Web Service SQL Connection Model Hi All, I am near completion of a project consisting (broadly) of a web app, a web service and a SQL server - the usual sort of configuration. Both the SQL server and the web service are tasked with dealing with large amounts of data per user; and a large number of users. At the moment I am using a new SqlConnection object for each request to the web service. Each of these connections is disposed of properly ... using (SqlConnection cn = DataService.CreateNewConnection()) { ... } Should I, however, be opening 1 single connection at Application startup and leaving that open for all requests from all Sessions? What are the pros & cons of both of these approaches? Many thanks, Chris Tag: Multiple Active Result Sets - general question Tag: 124309
  - 8
    - Dataset creation problem......... Hi All, I have two access databases. First contains a table which contains userids. The second one contains the users records. I tried to create a dataset which will query in these two databases and get two datatables. I tried to add relation between these two datatables. But while setting the relationship it gives error because each & every records in the first table does not contain related records in the second table. e.g. Table 1 Table 2 --------------------------- -------------------------------------- Id UserId UserId UserName --------------------------- ------------------------------------- 1 1001 1001 User One 2 1001 1002 User Two 3 1002 1003 User Three 1004 User Four Can anyone help me in this issue............... Thanks, Biren. Tag: Multiple Active Result Sets - general question Tag: 124306
  - 9
    - Get Rich Take advantage of a great deal Tag: Multiple Active Result Sets - general question Tag: 124302
  - 10
    - Using XML to read data from SQL Server Does anyone have a good, complete example code that would show the necessary steps for using XML to read data from a SQL Server database? I'm trying to switch from DataReaders and I have very little knowledge in the XML area. I would be very grateful and I suspect it would help many others to see such a posting in this news group. Tag: Multiple Active Result Sets - general question Tag: 124292
  - 11
    - Unable to insert BLOB in Oracle Hello, I am unable to insert BLOB objects into Oracle 9i database from .NET. I get the following exception: "ORA-01460: unimplemented or unreasonable conversion requested". I have a table in the database that accepts a number and blob object. The blob object i am trying to insert is a compressed dataset. Every thing seems to work fine if i insert small amount of data (compressing around 500 records) but i get an exception if i try to store data that has more than 500 records compressed. Any ideas as to why this may happen? Thanks Bala Tag: Multiple Active Result Sets - general question Tag: 124288
  - 12
    - ADO.NET 2.0, WebMethods and datatable strange behavior Hi, I am using VS2005 and .NET 2.0 I have a WebMethod that accept a typed data table. I realized that whatever rows that client sends to the SOAP server through the datatable, the webmethod received an empty datatable!! After spending several hours, I found that the only kind of data table that I can pass it to a webmethod is detached datatable. If data table is attached and part of a dataset, then the webmethod receives an empty datatable! Is that true? Or I am missing something? Thank you, Alan Tag: Multiple Active Result Sets - general question Tag: 124282
  - 13
    - Saving contents of datatable to Access table without writing SQL Hello, In ADO.NET is there anyway to save the contents of an datatable directly to an Access table without having to loop through and generate a SQL insert query string? I figure there's probably a way to do it as one chunk. I'm using VB.NET 1.1. Thanks, Eric Tag: Multiple Active Result Sets - general question Tag: 124275
  - 14
    - DataSet Question Hi, I have a dataset that is filled with data from the db. The user has modified that data in one of the tables where some of fields should now be null. I have played around with delete the row and adding a new row but have problems with the update. Do you think I should just reset the row by looping through the row and setting all the values to null before I update changes to the row? Thanks Tag: Multiple Active Result Sets - general question Tag: 124274
  - 15
    - SqlDataSource and Optimistic Concurrency Problems Hi, I'm using a detailsview control with an SqlDataSource control. My Update query isn't working, and I've narrowed it down to the optimistic concurrency parameters - i.e. when I comment them out of the query, it works. What seems to be happening is that if a field is NULL when it is read in through the select statement, it's causing the update statment not to find a match. I've got ConvertEmptyStringToNull not set (so it should default to true), but I can't get the update to work all the time and it's driving me crazy. Here's my code: Stored Procedure for Select as follows (the Update's going in a Stored Procedure when I can get it to work...): SELECT Customers.CustID, Customers.CustDisplayName, Customers.CustFirstName, Customers.CustSurname, Customers.CustType, Customers.CustNotes, Customers.CustIsBillingSame, Customers.CustNumEmployees, Customers.CustIsProspect, Customers.CustOnHold, Customers.CustPersonID, Customers.CustUserFieldB1, Customers.CustUserFieldB2, Customers.CustUserFieldB3, Customers.CustUserFieldD1, Customers.CustUserFieldD2, Customers.CustUserFieldD3, Customers.CustUserFieldI1, Customers.CustUserFieldI2, Customers.CustUserFieldI3, Customers.CustCategory, Customers.CustInactive, CustomerContactDetails_1.CustContactStreet1, CustomerContactDetails_1.CustContactStreet2, CustomerContactDetails_1.CustContactStreet3, CustomerContactDetails_1.CustContactTown, CustomerContactDetails_1.CustContactCounty, CustomerContactDetails_1.CustContactPostCode, CustomerContactDetails_1.CustContactCountry, CustomerContactDetails_1.CustContactTelephone, CustomerContactDetails_1.CustContactMobile, CustomerContactDetails_1.CustContactEMail, CustomerContactDetails_1.CustContactFax, CustomerContactDetails.CustContactStreet1 AS CustBContactStreet1, CustomerContactDetails.CustContactStreet2 AS CustBContactStreet2, CustomerContactDetails.CustContactStreet3 AS CustBContactStreet3, CustomerContactDetails.CustContactTown AS CustBContactTown, CustomerContactDetails.CustContactCounty AS CustBContactCounty, CustomerContactDetails.CustContactPostCode AS CustBContactPostCode, CustomerContactDetails.CustContactCountry AS CustBContactCountry, CustomerContactDetails.CustContactTelephone AS CustBContactTelephone, CustomerContactDetails.CustContactMobile AS CustBContactMobile, CustomerContactDetails.CustContactEMail AS CustBContactEMail, CustomerContactDetails.CustContactFax AS CustBContactFax FROM Customers LEFT OUTER JOIN CustomerContactDetails AS CustomerContactDetails_1 ON Customers.CustAddressID = CustomerContactDetails_1.CustContactID LEFT OUTER JOIN CustomerContactDetails ON Customers.CustBillingID = CustomerContactDetails.CustContactID WHERE (Customers.CustID = @CustID) <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:FocusSystemsConnectionString %>" OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:FocusSystemsConnectionString.ProviderName %>" SelectCommand="SelectCustomersAndAddresses" SelectCommandType="StoredProcedure" UpdateCommand="UPDATE [Customers] SET [CustDisplayName] = @CustDisplayName, [CustFirstName] = @CustFirstName, [CustSurname] = @CustSurname, [CustType] = @CustType, [CustNotes] = @CustNotes, [CustIsBillingSame] = @CustIsBillingSame, [CustNumEmployees] = @CustNumEmployees, [CustIsProspect] = @CustIsProspect, [CustOnHold] = @CustOnHold, [CustPersonID] = @CustPersonID, [CustUserFieldB1] = @CustUserFieldB1, [CustUserFieldB2] = @CustUserFieldB2, [CustUserFieldB3] = @CustUserFieldB3, [CustUserFieldD1] = @CustUserFieldD1, [CustUserFieldD2] = @CustUserFieldD2, [CustUserFieldD3] = @CustUserFieldD3, [CustUserFieldI1] = @CustUserFieldI1, [CustUserFieldI2] = @CustUserFieldI2, [CustUserFieldI3] = @CustUserFieldI3, [CustCategory] = @CustCategory, [CustInactive] = @CustInactive WHERE [CustID] = @original_CustID AND [CustDisplayName] = @original_CustDisplayName AND [CustFirstName] = @original_CustFirstName AND [CustSurname] = @original_CustSurname AND [CustType] = @original_CustType AND [CustIsBillingSame] = @original_CustIsBillingSame AND [CustNumEmployees] = @original_CustNumEmployees AND [CustIsProspect] = @original_CustIsProspect AND [CustOnHold] = @original_CustOnHold AND [CustPersonID] = @original_CustPersonID AND [CustCategory] = @original_CustCategory AND [CustInactive] = @original_CustInactive" EnableViewState="true"> <UpdateParameters> <asp:Parameter Name="CustDisplayName" Type="String" /> <asp:Parameter Name="CustFirstName" Type="String" /> <asp:Parameter Name="CustSurname" Type="String" /> <asp:Parameter Name="CustType" Type="String" /> <asp:Parameter Name="CustNotes" Type="String" /> <asp:Parameter Name="CustIsBillingSame" Type="Boolean" /> <asp:Parameter Name="CustNumEmployees" Type="Int32" /> <asp:Parameter Name="CustIsProspect" Type="Boolean" /> <asp:Parameter Name="CustOnHold" Type="Boolean" /> <asp:Parameter Name="CustPersonID" /> <asp:Parameter Name="CustUserFieldB1" Type="String" /> <asp:Parameter Name="CustUserFieldB2" Type="String" /> <asp:Parameter Name="CustUserFieldB3" Type="String" /> <asp:Parameter Name="CustUserFieldD1" Type="String" /> <asp:Parameter Name="CustUserFieldD2" Type="String" /> <asp:Parameter Name="CustUserFieldD3" Type="String" /> <asp:Parameter Name="CustUserFieldI1" Type="String" /> <asp:Parameter Name="CustUserFieldI2" Type="String" /> <asp:Parameter Name="CustUserFieldI3" Type="String" /> <asp:Parameter Name="CustCategory" Type="String" /> <asp:Parameter Name="CustInactive" Type="Boolean" /> <asp:Parameter Name="original_CustID" /> <asp:Parameter Name="original_CustDisplayName" /> <asp:Parameter Name="original_CustFirstName" /> <asp:Parameter Name="original_CustSurname" /> <asp:Parameter Name="original_CustType" /> <asp:Parameter Name="original_CustNotes" /> <asp:Parameter Name="original_CustIsBillingSame" /> <asp:Parameter Name="original_CustNumEmployees" /> <asp:Parameter Name="original_CustIsProspect" /> <asp:Parameter Name="original_CustOnHold" /> <asp:Parameter Name="original_CustPersonID" /> <asp:Parameter Name="original_CustUserFieldB1" /> <asp:Parameter Name="original_CustUserFieldB2" /> <asp:Parameter Name="original_CustUserFieldB3" /> <asp:Parameter Name="original_CustUserFieldD1" /> <asp:Parameter Name="original_CustUserFieldD2" /> <asp:Parameter Name="original_CustUserFieldD3" /> <asp:Parameter Name="original_CustUserFieldI1" /> <asp:Parameter Name="original_CustUserFieldI2" /> <asp:Parameter Name="original_CustUserFieldI3" /> <asp:Parameter Name="original_CustCategory" /> <asp:Parameter Name="original_CustInactive" /> <asp:Parameter Name="CustContactStreet1" Type="String" /> <asp:Parameter Name="CustContactStreet2" Type="String" /> <asp:Parameter Name="CustContactStreet3" Type="String" /> <asp:Parameter Name="CustContactTown" Type="String" /> <asp:Parameter Name="CustContactCounty" Type="String" /> <asp:Parameter Name="CustContactPostCode" Type="String" /> <asp:Parameter Name="CustContactCountry" Type="String" /> <asp:Parameter Name="CustContactTelephone" Type="String" /> <asp:Parameter Name="CustContactMobile" Type="String" /> <asp:Parameter Name="CustContactEMail" Type="String" /> <asp:Parameter Name="CustContactFax" Type="String" /> <asp:Parameter Name="original_CustContactStreet1" Type="String" /> <asp:Parameter Name="original_CustContactStreet2" Type="String" /> <asp:Parameter Name="original_CustContactStreet3" Type="String" /> <asp:Parameter Name="original_CustContactTown" Type="String" /> <asp:Parameter Name="original_CustContactCounty" Type="String" /> <asp:Parameter Name="original_CustContactPostCode" Type="String" /> <asp:Parameter Name="original_CustContactCountry" Type="String" /> <asp:Parameter Name="original_CustContactTelephone" Type="String" /> <asp:Parameter Name="original_CustContactMobile" Type="String" /> <asp:Parameter Name="original_CustContactEMail" Type="String" /> <asp:Parameter Name="original_CustContactFax" Type="String" /> <asp:Parameter Name="CustBContactStreet1" Type="String" /> <asp:Parameter Name="CustBContactStreet2" Type="String" /> <asp:Parameter Name="CustBContactStreet3" Type="String" /> <asp:Parameter Name="CustBContactTown" Type="String" /> <asp:Parameter Name="CustBContactCounty" Type="String" /> <asp:Parameter Name="CustBContactPostCode" Type="String" /> <asp:Parameter Name="CustBContactCountry" Type="String" /> <asp:Parameter Name="CustBContactTelephone" Type="String" /> <asp:Parameter Name="CustBContactMobile" Type="String" /> <asp:Parameter Name="CustBContactEMail" Type="String" /> <asp:Parameter Name="CustBContactFax" Type="String" /> <asp:Parameter Name="original_CustBContactStreet1" Type="String" /> <asp:Parameter Name="original_CustBContactStreet2" Type="String" /> <asp:Parameter Name="original_CustBContactStreet3" Type="String" /> <asp:Parameter Name="original_CustBContactTown" Type="String" /> <asp:Parameter Name="original_CustBContactCounty" Type="String" /> <asp:Parameter Name="original_CustBContactPostCode" Type="String" /> <asp:Parameter Name="original_CustBContactCountry" Type="String" /> <asp:Parameter Name="original_CustBContactTelephone" Type="String" /> <asp:Parameter Name="original_CustBContactMobile" Type="String" /> <asp:Parameter Name="original_CustBContactEMail" Type="String" /> <asp:Parameter Name="original_CustBContactFax" Type="String" /> </UpdateParameters> <SelectParameters> <asp:ControlParameter ControlID="CustNameSelect" Name="CustID" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr><td> <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource2" Height="50px" Width="125px" DataKeyNames="CustID"> <Fields> <asp:BoundField DataField="CustID" HeaderText="CustID" ReadOnly="True" SortExpression="CustID" /> <asp:BoundField DataField="CustDisplayName" HeaderText="CustDisplayName" SortExpression="CustDisplayName" /> <asp:BoundField DataField="CustFirstName" HeaderText="CustFirstName" SortExpression="CustFirstName" /> <asp:BoundField DataField="CustSurname" HeaderText="CustSurname" SortExpression="CustSurname" /> <asp:BoundField DataField="CustType" HeaderText="CustType" SortExpression="CustType" /> <asp:BoundField DataField="CustNotes" HeaderText="CustNotes" SortExpression="CustNotes" /> <asp:CheckBoxField DataField="CustIsBillingSame" HeaderText="CustIsBillingSame" SortExpression="CustIsBillingSame" /> <asp:BoundField DataField="CustNumEmployees" HeaderText="CustNumEmployees" SortExpression="CustNumEmployees" /> <asp:CheckBoxField DataField="CustIsProspect" HeaderText="CustIsProspect" SortExpression="CustIsProspect" /> <asp:CheckBoxField DataField="CustOnHold" HeaderText="CustOnHold" SortExpression="CustOnHold" /> <asp:BoundField DataField="CustPersonID" HeaderText="CustPersonID" SortExpression="CustPersonID" /> <asp:BoundField DataField="CustUserFieldB1" HeaderText="CustUserFieldB1" SortExpression="CustUserFieldB1" /> <asp:BoundField DataField="CustUserFieldB2" HeaderText="CustUserFieldB2" SortExpression="CustUserFieldB2" /> <asp:BoundField DataField="CustUserFieldB3" HeaderText="CustUserFieldB3" SortExpression="CustUserFieldB3" /> <asp:BoundField DataField="CustUserFieldD1" HeaderText="CustUserFieldD1" SortExpression="CustUserFieldD1" /> <asp:BoundField DataField="CustUserFieldD2" HeaderText="CustUserFieldD2" SortExpression="CustUserFieldD2" /> <asp:BoundField DataField="CustUserFieldD3" HeaderText="CustUserFieldD3" SortExpression="CustUserFieldD3" /> <asp:BoundField DataField="CustUserFieldI1" HeaderText="CustUserFieldI1" SortExpression="CustUserFieldI1" /> <asp:BoundField DataField="CustUserFieldI2" HeaderText="CustUserFieldI2" SortExpression="CustUserFieldI2" /> <asp:BoundField DataField="CustUserFieldI3" HeaderText="CustUserFieldI3" SortExpression="CustUserFieldI3" /> <asp:BoundField DataField="CustCategory" HeaderText="CustCategory" SortExpression="CustCategory" /> <asp:CheckBoxField DataField="CustInactive" HeaderText="CustInactive" SortExpression="CustInactive" /> <asp:BoundField DataField="CustContactStreet1" HeaderText="CustContactStreet1" SortExpression="CustContactStreet1" /> <asp:BoundField DataField="CustContactStreet2" HeaderText="CustContactStreet2" SortExpression="CustContactStreet2" /> <asp:BoundField DataField="CustContactStreet3" HeaderText="CustContactStreet3" SortExpression="CustContactStreet3" /> <asp:BoundField DataField="CustContactTown" HeaderText="CustContactTown" SortExpression="CustContactTown" /> <asp:BoundField DataField="CustContactCounty" HeaderText="CustContactCounty" SortExpression="CustContactCounty" /> <asp:BoundField DataField="CustContactPostCode" HeaderText="CustContactPostCode" SortExpression="CustContactPostCode" /> <asp:BoundField DataField="CustContactCountry" HeaderText="CustContactCountry" SortExpression="CustContactCountry" /> <asp:BoundField DataField="CustContactTelephone" HeaderText="CustContactTelephone" SortExpression="CustContactTelephone" /> <asp:BoundField DataField="CustContactMobile" HeaderText="CustContactMobile" SortExpression="CustContactMobile" /> <asp:BoundField DataField="CustContactEMail" HeaderText="CustContactEMail" SortExpression="CustContactEMail" /> <asp:BoundField DataField="CustContactFax" HeaderText="CustContactFax" SortExpression="CustContactFax" /> <asp:BoundField DataField="CustBContactStreet1" HeaderText="CustBContactStreet1" SortExpression="CustBContactStreet1" /> <asp:BoundField DataField="CustBContactStreet2" HeaderText="CustBContactStreet2" SortExpression="CustBContactStreet2" /> <asp:BoundField DataField="CustBContactStreet3" HeaderText="CustBContactStreet3" SortExpression="CustBContactStreet3" /> <asp:BoundField DataField="CustBContactTown" HeaderText="CustBContactTown" SortExpression="CustBContactTown" /> <asp:BoundField DataField="CustBContactCounty" HeaderText="CustBContactCounty" SortExpression="CustBContactCounty" /> <asp:BoundField DataField="CustBContactPostCode" HeaderText="CustBContactPostCode" SortExpression="CustBContactPostCode" /> <asp:BoundField DataField="CustBContactCountry" HeaderText="CustBContactCountry" SortExpression="CustBContactCountry" /> <asp:BoundField DataField="CustBContactTelephone" HeaderText="CustBContactTelephone" SortExpression="CustBContactTelephone" /> <asp:BoundField DataField="CustBContactMobile" HeaderText="CustBContactMobile" SortExpression="CustBContactMobile" /> <asp:BoundField DataField="CustBContactEMail" HeaderText="CustBContactEMail" SortExpression="CustBContactEMail" /> <asp:BoundField DataField="CustBContactFax" HeaderText="CustBContactFax" SortExpression="CustBContactFax" /> <asp:CommandField ShowEditButton="True" /> </Fields> </asp:DetailsView> Tag: Multiple Active Result Sets - general question Tag: 124270
  - 16
    - DataColumn size Hi everybody! Do someone know the easiest way to obtain the datacolumn size in code (I mean the size that you define creating a text field in a table)? In VB6 you could get it by means of Recordset.Field. DefinedSize property. I have been searchin for something similar in ADO.NET but without luck. Thanks beforehand Tag: Multiple Active Result Sets - general question Tag: 124256
  - 17
    - AD.NET 2.0: BindingSource and Parent Child relationship Hi, I have two BindingSource(s) in my form, one for parent and one for child area. The unique situation in my form is that the child area chooses its parent by a ComboBox. The problem is when I use AndNew method in the child BindingSource, I cannot choose the parent record through the combobox and parentDataSource.Position. The parent BindingSource complains about [Not Null] columns and throws exception. This doesn't make any sense to me. I shouldn't have to use DataSet.EnforceConstraints because I do not have any NULL value at that specific parent record and position! I am sure that I am missing an important points, what is it? Any help would be appreciated, Alan Tag: Multiple Active Result Sets - general question Tag: 124248
  - 18
    - How to write generic code access in ADO.NET M. Chand is a .NET consultant, author and the admin and founder of C# Corner. He has been working with .NET technology since pre beta releases. http://www.dotnetwire.com/frame_redirect.asp?newsid=3171 using System; using System.Data; using System.Data.Common; using System.Data.OleDb; using System.Data.SqlClient; using Microsoft.Data.Odbc; namespace GenericDataAccessApp { public class GenericAdoNetComp { private IDbConnection idbConn = null; private IDbDataAdapter idbAdapter = null; private DbDataAdapter dbAdapter = null; private IDataReader iReader = null; public GenericAdoNetComp() { } // GetConnection returns IDbConnection public IDbConnection GetConnection(int connType, string connString) { switch (connType) { case 1: // OleDb Data Provider idbConn = new OleDbConnection(connString); break; case 2: // Sql Data Provider idbConn = new SqlConnection(connString); break; case 3: // ODBC Data Provider idbConn = new OdbcConnection(connString); break; // case 3: // Add your custom data provider default: break; } return idbConn; } // GetDataAdapter returns IDbDataAdapter public IDbDataAdapter GetDataAdapter(int connType, string connString, string sql) { switch (connType) { case 1: // OleDb Data Provider idbAdapter = new OleDbDataAdapter(sql, connString); break; case 2: // Sql Data Provider idbAdapter = new SqlDataAdapter(sql, connString); break; case 3: // ODBC Data Provider idbAdapter = new OdbcDataAdapter(sql, connString); break; // case 3: // Add your custom data provider default: break; } return idbAdapter; } } } public class Client { private void ConnectBtn_Click(object sender, System.EventArgs e) { GenericAdoNetComp genDP = new GenericAdoNetComp(); sql = "SELECT * FROM Employees"; if (radioButton1.Checked) { connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\Northwind.mdb"; conn = genDP.GetConnection(1, connString); adapter = genDP.GetDataAdapter(1, connString, sql); } else if (radioButton2.Checked) { connString = "Data Source=MCB;Initial Catalog=Northwind;user id=sa;password=;"; conn = genDP.GetConnection(2, connString); adapter = genDP.GetDataAdapter(2, connString, sql); } else if (radioButton3.Checked) { // Construct your connection string here conn = genDP.GetConnection(3, connString); adapter = genDP.GetDataAdapter(3, connString, sql); } try { conn.Open(); // Fill a DataSet DataSet ds = new DataSet(); adapter.Fill(ds); dataGrid1.DataSource = ds.Tables[0].DefaultView; } catch (Exception exp) { MessageBox.Show(exp.Message); } finally { conn.Close(); } } } Tag: Multiple Active Result Sets - general question Tag: 124247
  - 19
    - SQLconnection problem I'm pretty new to asp.net and I'm having trouble just trying to set up a basic SQLconnection within visual studio, I'm sure the problem must be something basic but I can't seem to find it. The problem is that the connection string ("Integrated Security=yes;Initial Catalog=Northwind;Data Source=(local)") is underlined within the code editor and provides the error text 'Too many arguements for 'Public Sub New()' when you hover over the text. a snippet of the code is below: Imports System.Data Imports System.Data.SqlClient ' ----- within the page_load function ------ Dim sqlConnection As SQLConnection sqlConnection = New SqlConnection("Integrated Security=yes;Initial Catalog=Northwind;Data Source=(local)") Tag: Multiple Active Result Sets - general question Tag: 124246
  - 20
    - Binary serializing of dataset in framework 2.0 I was eager to try the new binary serialization of dataset in version 2.0 of the framework. The new serialization seems to be very fast comparede to the "binary" serialization in framework 1.1. However I have a few problems consering columns of the type Date: Columns set to the value of Date.MinValue and Date.MaxValue get corruptede depending on the what time zone my computer is set to: 1. When time zone is set to Greenwich Mean Time (GMT) everything works just fine. 2. When time zone is set to something east of GMT for example GMT +1 (Denmark) coulms with the value Date.MinValue are corrupted during the serialization and deserialization. 3. When time zone is set to something west of GMT for example GMT -6 (Central Time US) coulms with the value Date.MaxValue are corrupted during the serialization and deserialization. I also expirience problems with null valus: Columns with null values will be set to Date.MinVaule after deserialization when time time zone is east of GMT. Is this a bug or am i doing something worg? I use the code below to demostrate this behaviour: 'Create a dataset for test purpose '-------------------------------------- Dim drNew As DataRow Me.DatasetOriginal = New DataSet Me.DatasetOriginal.Tables.Add("TEST") Me.DatasetOriginal.Tables("TEST").Columns.Add("Id", GetType(Integer)) Me.DatasetOriginal.Tables("TEST").Columns.Add("Name", GetType(String)) Me.DatasetOriginal.Tables("TEST").Columns.Add("Date", GetType(Date)) Me.DatasetOriginal.Tables("TEST").Columns.Add("Number", GetType(Integer)) Me.DatasetOriginal.Tables("TEST").Columns.Add("Bool", GetType(Boolean)) drNew = Me.DatasetOriginal.Tables("TEST").NewRow() drNew.Item("Id") = 1 drNew.Item("Name") = "My name" drNew.Item("Date") = Date.MaxValue drNew.Item("Number") = 13 drNew.Item("Bool") = True Me.DatasetOriginal.Tables("TEST").Rows.Add(drNew) drNew = Me.DatasetOriginal.Tables("TEST").NewRow() drNew.Item("Id") = 2 drNew.Item("Date") = Date.MinValue drNew.Item("Number") = 13 drNew.Item("Bool") = True Me.DatasetOriginal.Tables("TEST").Rows.Add(drNew) drNew = Me.DatasetOriginal.Tables("TEST").NewRow() drNew.Item("Id") = 3 drNew.Item("Name") = "My name" drNew.Item("Number") = 13 drNew.Item("Bool") = True Me.DatasetOriginal.Tables("TEST").Rows.Add(drNew) drNew = Me.DatasetOriginal.Tables("TEST").NewRow() drNew.Item("Id") = 4 drNew.Item("Name") = "My name" drNew.Item("Date") = Date.Now drNew.Item("Bool") = True Me.DatasetOriginal.Tables("TEST").Rows.Add(drNew) drNew = Me.DatasetOriginal.Tables("TEST").NewRow() drNew.Item("Id") = 5 drNew.Item("Name") = "My name" drNew.Item("Date") = Date.Now drNew.Item("Number") = 13 Me.DatasetOriginal.Tables("TEST").Rows.Add(drNew) 'Serialize dataset '------------------- Dim bin As New System.Runtime.Serialization.Formatters.Binary.BinaryFormatter Dim Writer2 As New System.IO.StreamWriter("C:\DatasetSerialized.dat") Try DatasetOriginal.WriteXml("C:\Serialized.xml", XmlWriteMode.WriteSchema) DatasetOriginal.RemotingFormat = SerializationFormat.Binary bin.Serialize(Writer2.BaseStream, DatasetOriginal) Writer2.Close() Writer2 = Nothing Catch ex As Exception MessageBox.Show(ex.Message) End Try 'DeSerializer dataset '----------------------- Dim bin As New System.Runtime.Serialization.Formatters.Binary.BinaryFormatter Dim Reader As New System.IO.StreamReader("C:\DatasetSerialized.dat") Try DatasetSerialized = New DataSet DatasetSerialized.RemotingFormat = SerializationFormat.Binary DatasetSerialized = bin.Deserialize(Reader.BaseStream) Reader.Close() Reader = Nothing DatasetSerialized.WriteXml("C:\DeSerialized.xml", XmlWriteMode.WriteSchema) Catch ex As Exception MessageBox.Show(ex.Message) End Try Tag: Multiple Active Result Sets - general question Tag: 124244
  - 21
    - DataColumn.Exression and string formatting Hi, I am truing to add a calculated column to my data table. The column must show something like: "Date: 2005-01-23" I underestand that we can use Convert to convert a DateTime value to string. How can I convert it in specific date format? Thank you, Alan Tag: Multiple Active Result Sets - general question Tag: 124229
  - 22
    - excel datasource and gridview sorting Hi! I am somewhat befuddled. I have a gridview that I have filled using oledb datareader with data from an excel sheet.(code at bottom) My problem is that it does not sort and I can't figure out why. If I import to access and create a datasource using the table in access I imported from all is well. But when I fill it with the reader sorting has no effect. the code below works for gridview1 which uses a access datasource but the first one is uneffected. I have set allowsorting = true on both. But only the second one is sorting both by the button and by clicking on the hyperlink in the header. Can anyone tell me what I need to get the excel to sort? Thanks for your interest! Len Protected Sub btnSort_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSort.Click Dim direction As SortDirection direction = SortDirection.Ascending ExcelOut.Sort("Attending", direction) AccessGridView1.Sort("Attending", direction) ========PageLoad===================================================== Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then Dim DBConnection = New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Me.MapPath("Upload/DailyInfo.xls") & ";" & _ "Extended Properties=""Excel 8.0;HDR=Yes""") DBConnection.Open() Dim strConnString As String = Me.MapPath("Upload/DailyInfo.xls") Dim SQLString As String = "SELECT Hospital,[Room],[Patient Name],DOB,Symptom,Notes,Attending,Consulting ,[Initial Date Seen],FU FROM [INPATIENT PATIENT SVCS$]" Dim DBCommand = New OleDbCommand(SQLString, DBConnection) Dim DBReader As OleDbDataReader = DBCommand.ExecuteReader() ExcelOut.DataSource = DBReader ExcelOut.DataBind() DBReader.Close() DBConnection.Close() End If End Sub Html:================================ <asp:GridView ID="ExcelOut" runat="server" Width="800px" CellPadding="4" ForeColor="#333333" GridLines="None" AllowSorting="True" AutoGenerateColumns="False"> <Columns> <asp:BoundField DataField="HOSPITAL" HeaderText="HOSPITAL" SortExpression="HOSPITAL" /> <asp:BoundField DataField="Room" HeaderText="Room" SortExpression="Room" /> <asp:BoundField DataField="Patient Name" HeaderText="Patient Name" SortExpression="Patient Name" /> <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" /> <asp:BoundField DataField="Symptom" HeaderText="Symptom" SortExpression="Symptom" /> <asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" /> <asp:BoundField DataField="Attending" HeaderText="Attending" SortExpression="Attending" /> <asp:BoundField DataField="Consulting" HeaderText="Consulting" SortExpression="Consulting" /> <asp:BoundField DataField="Initial Date Seen" HeaderText="Initial Date Seen" SortExpression="Initial Date Seen" /> <asp:BoundField DataField="FU" HeaderText="FU" SortExpression="FU" /> </Columns> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#FFFBD6" ForeColor="#333333" /> <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="White" /> </asp:GridView> a.. b.. c.. Report abuse -------------------------------------------------------------------------------- Tag: Multiple Active Result Sets - general question Tag: 124214
  - 23
    - 0(n ***Hot stuff - check this out !!! 0(n http://www.kaneva.com/checkout/stream.aspx?assetId=2017&free=0 Tag: Multiple Active Result Sets - general question Tag: 124206
  - 24
    - Accessing a field in untyped DS Hello, I have an copied data set. I'm trying to access a field. daOrder.Fill(dsOrderSheet); DataSet dsCopy = new DataSet(); dsCopy = dsOrderSheet.Copy(); // How do you do this part? output = dsCopy.Tables["orders"].Rows[0].ItemArray["orderDate"]; //or output = dsCopy.Tables[0].Rows[0].ItemArray[1]; //neither work. How is this done? Thanks kindly for any advice on this Ant Tag: Multiple Active Result Sets - general question Tag: 124205
  - 25
    - Adding a Datatable to a dataset Hi, I'm currently getting up to speed with ADO.NET & have a few questions on it. This question relates to why a data table is added to a data set such: DataTable dtEmp = ds.Tables.Add["employees"]; // From book i would have thought it would be more like: DataTable dtEmp = New DataTable("employees"); ds.Tables.Add(dtEmp); // The way I think it should be. Works ok So what is going on in the first line? (from the book) Is dtEmp being referenced to the "employees" table that is being added to the dataset? (As opposed to dtEmp actually being added?). It doesn't seem intuitutive to me... Thanks for any comments Ant Tag: Multiple Active Result Sets - general question Tag: 124203

Having worked through an example (I'm novice status), it seems that this is
less efficient than using hierarchical recordsets in normal ADO.

Can one still use hierarchical recordsets (using the SHAPE command) in
ADO.NET?

Top

RE: Multiple Active Result Sets - general question by NoSpamMgbworld

NoSpamMgbworld
Fri Feb 03 09:36:43 CST 2006

"Griff" wrote:

> Having worked through an example (I'm novice status), it seems that this is
> less efficient than using hierarchical recordsets in normal ADO.

MARS serves a different function than hierarchical recordsets.

> Can one still use hierarchical recordsets (using the SHAPE command) in
> ADO.NET?

Yes and no. You cannot use it in ADO.NET, but you can still use the ADO
library in .NET. The downside is you end up with the Interop overhead, so it
is not an ideal solution if you can solve your problem in .NET alone.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

Top

Re: Multiple Active Result Sets - general question by Sahil

Sahil
Sat Feb 04 12:00:39 CST 2006

First of all, MARS is a different concept than what you mention (just so
there is no confusion) :)

Secondly - ditto on whatever Gregory said.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

"Griff" <howling@the.moon> wrote in message
news:uwIFYyKKGHA.2712@TK2MSFTNGP10.phx.gbl...
> Having worked through an example (I'm novice status), it seems that this
> is less efficient than using hierarchical recordsets in normal ADO.
>
> Can one still use hierarchical recordsets (using the SHAPE command) in
> ADO.NET?
>

Top

Re: Multiple Active Result Sets - general question by Griff

Griff
Mon Feb 06 03:38:05 CST 2006

> Yes and no. You cannot use it in ADO.NET, but you can still use the ADO
> library in .NET. The downside is you end up with the Interop overhead, so
> it
> is not an ideal solution if you can solve your problem in .NET alone.

Hmmm

I've found hierarchical recordsets in Classic ADO to be such a powerful tool
that I'm really surprised that it's now possible to do this using ADO.NET.

Was I the only person using hierarchical recordsets?

Top