requerying with Dataadapter and dataset

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
    - LoadDataRow Issues I have 2 datasets, each with a DataTable. Each table has the same primary key, and columns. I am trying to copy rows from one dataset to another, based on an event from my application. It all works fine when the row is not present in the destination DataTable. Now when the row is present in the destination file, the .NET documentation says use the LoadRowData method of the dataset to copy the row. When do this, I get a unique key violation problem (right at the EndLoadData point in the code below).. Here is my code below. Can anybody help?? Dim app As Application Dim xmlDestFile As String = app.StartupPath & "\" & "dest.xml" Dim xmlSourceFile As String = app.StartupPath & "\" & "source.xml" Dim dsDest As New DataSet Dim dsSource As New DataSet Dim rwDest As DataRow Dim rwSource As DataRow dsDest.ReadXml(xmlDestFile) dsSource.ReadXml(xmlDestFile) Try For Each rwSource In dsSource.Tables(0).Rows Dim copyRowPersent As Boolean For Each rwDest In dsDest.Tables(0).Rows If rwDest.Item("Name") = rwSource.Item("Name") Then copyRowPersent = True Exit For End If Next If copyRowPersent Then Dim newRow(rwSource.Table.Columns.Count - 1) As Object Dim column As DataColumn Dim intLoop As Int32 intLoop = 0 For Each column In rwSource.Table.Columns newRow(intLoop) = rwSource.Item(column) intLoop = intLoop + 1 Next dsDest.Tables(0).BeginLoadData() dsDest.Tables(0).LoadDataRow(newRow, False) dsDest.Tables(0).EndLoadData() ' I get a primary key voilation problem here..., I don't even go to accept changes else 'Import the new rows here using ImportRow ' This works fine... End If Next dsDest.AcceptChanges() dsDest.WriteXml(xmlDestFile, XmlWriteMode.WriteSchema) dsDest.Dispose() dsSource.Dispose() Catch myex As Exception MsgBox(myex.ToString, MsgBoxStyle.Information + MsgBoxStyle.OKOnly, "Test") End Try VJ Tag: requerying with Dataadapter and dataset Tag: 72271
  - 2
    - Finer grained info on what led to a constraint exception Is there any way to provide a finer grained source of information on what led to a constraint exception? This is really a blunt tool right now. Tag: requerying with Dataadapter and dataset Tag: 72268
  - 3
    - ExecuteNonQuery and events This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3B016.BBB07A60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I'm using the ExecuteNonQuery command to insert a row in a database. = How do I fire an event when the row has been added. I know how to do it = with an OleDbDataAdapter, but I want to use ExecuteNonQuery. Ideas? Ian ------=_NextPart_000_0008_01C3B016.BBB07A60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm using the ExecuteNonQuery command = to insert a=20 row in a database.  How do I fire an event when the row has been=20 added.  I know how to do it with an </FONT><FONT face=3DArial=20 size=3D2>OleDbDataAdapter, but I want to use ExecuteNonQuery.  = Ideas?</FONT> <P><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2>Ian</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P></DIV></BODY></HTML> ------=_NextPart_000_0008_01C3B016.BBB07A60-- Tag: requerying with Dataadapter and dataset Tag: 72266
  - 4
    - Thread communication - events Is it possible to use events as a communication mechanism between threads? Tag: requerying with Dataadapter and dataset Tag: 72265
  - 5
    - EASY ONE? looping and updating labels with each iteration This should be an easy one, but I'm not sure the best way to do it. I've got a form, and when I click a button it starts looping through an array. With each iteration of the array I want it to change the status of a label. I realise that it must complete the execution of the code-behind page before it can update the labels, so how do I do it? TIA, Bruce Tag: requerying with Dataadapter and dataset Tag: 72255
  - 6
    - Master - Detail problem... Hi I have a typed dataset with a Master table (tblPersons) and a Detail table (tblRemarks). I have a Winform which shows person data (master data) I would like to have a datagrid showing the detail data. So I try to bind the datagrid like this: DataSource: MyDataSet And try to set DataMember to: tblPersontblRemarks But I get an error: "Invalid Property Value:" "DataBinding could not find a row in the list that is suitable for all bindings" And then when I press OK I receive another error: "Datasources of type System.DBNull are not supported. Parameter name: Datasource" If I rightclick on a dataadapter and select Preview Data... it works fine. Best regards Jan Tag: requerying with Dataadapter and dataset Tag: 72251
  - 7
    - DataView.Find (SQL Server 2000) I need to be able to sort/search a datatable for 2 columns, both of type integer. Is this possible? Dim dv As New DataView(MyDataTable,...) Dim dr As DataRowView Dim iIndex As Integer Dim objSearch(1) As Object dv.Sort = ("Column1, Column2 ASC") objSearch(0) = 5 'Locate 5 in column 1 objSearch(1) = 6 'Locate 6 in column 2 iIndex = dv.Find(objSearch) Will this find rows in my view where Column1 = 5 AND Column2 = 6? Or will it find rows where Column1 = 5 or 6 AND rows where Column2 = 5 or 6? As an alternative, I could apply a filter upon the DataView when enstantiating it. However, wouldn't this be less efficient/concise than DataView.Find? -bgsd Tag: requerying with Dataadapter and dataset Tag: 72242
  - 8
    - Udl File How to use it Hi, I have a quick question about the udl file. How to use it in a project ? I ve created one, but I don't know where to put it and how to replace my current connection string with it ? Thks Stan Tag: requerying with Dataadapter and dataset Tag: 72238
  - 9
    - Oracle cursors not releasing with OracleClient Hi all, I'm having a problem with Oracle .net provider and Stored Procedures returning REF CURSOR vars. I'm using OracleClient v1.0.1012.0 with Framework 1.0 and when I fill a dataset with the stored procedure, the cursor is not released and I always end up with a ORA-01000 error (too much cursors opened). It's very frustrating and I've observed that if I change the OracleClient reference to the one from framework 1.1 it doesn't happen and the cursors are released when closing the connection. Unfortunately, I can't change the framework version I'm using so I'd like to know if there's something I could do to fix this behaviour with framework 1.0 Another strange thing I've noticed is that if I call the function (see code) in a pageload event of an aspnet application I don't get the ORA-01000 error but if I call it from the Console Application I can't. I'll put some code here to reproduce the behaviour, any help will be appreciated !! Thx in advance, ori using System; using System.Data.OracleClient; using System.Data; namespace ConsoleApplication2 { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { [STAThread] static void Main(string[] args) { Class1 c = new Class1(); for (int i=0; i<850; i++) { c.try(); } } public void prova() { try { OracleConnection conn = new OracleConnection(@"<connection string here>"); conn.Open(); OracleCommand comm = new OracleCommand(); comm.Connection = conn; comm.CommandType = System.Data.CommandType.StoredProcedure; comm.CommandText = "PKG.READ"; comm.Parameters.Add(new OracleParameter("P_CURSOR", OracleType.Cursor, 38, ParameterDirection.Output, true, 38, 0, "", System.Data.DataRowVersion.Current, null)); OracleDataAdapter adapter = new OracleDataAdapter(comm); DataSet dset = new DataSet(); adapter.Fill(dset); conn.Close(); } catch (System.Exception ex) { //ORA-01000 Error when default 300 cursors are opened } } public Class1() { } } } Stored procedure CREATE OR REPLACE PACKAGE PKG AS TYPE etrcur IS REF CURSOR; PROCEDURE READ ( p_CURSOR OUT etrcur ); END PKG; / CREATE OR REPLACE PACKAGE BODY PKG AS PROCEDURE READ ( p_CURSOR OUT etrcur ) IS BEGIN OPEN p_cursor FOR SELECT <ANY SELECT HERE>; END SGM_READ; END PKG; / Tag: requerying with Dataadapter and dataset Tag: 72226
  - 10
    - BindingContext Hello i have a form bounded to a DataSet and i have several combobox's in the form. when i use Bc.Position = Bc.Position + 1 it moves to the next record in the DataSet, and all the combobox's that are bound to other tables in the dataset are updated too. problem is when the bc.position = 0 (first record) is selected the textbox's are updated correctly the combobox's are displaying the first record of the bonded table and not the value that is in in that record. is there i am missing? Thnaks Tag: requerying with Dataadapter and dataset Tag: 72219
  - 11
    - Passing values error I'm using this piece of code on page one.aspx Context.Items("Parameter") = x Server.Transfer("two.aspx") And in opage two.aspx I put a value in a text box via button. To grab the data I use Dim x As Integer = CType(Context.Items("Parameter"), Integer) BUT when I click the button to insert that value in a text box I get 0 (zero) instead of a number from the previous page. Tag: requerying with Dataadapter and dataset Tag: 72218
  - 12
    - how to create a notification? my sql is: CREATE EVENT NOTIFICATION mytestqueue ON DATABASE FOR DDL_DATABASE_LEVEL_EVENTS TO DATABASE northwind but error message is: Incorrect syntax near 'northwind'. how to do? thanks!!! Tag: requerying with Dataadapter and dataset Tag: 72210
  - 13
    - MySQL & WebForm - Please Help Hello, I just started to learn ASP.NET, and I am using MySQL for database, I have a question I hope someone can answer for me though :) I want to create a simple form that can edit and create a row in a database, for example the fields Name and Lastname. How do I go about this, can I somehow link my TextBox's to a field in the MySql database? So when I press Create-Button it adds the row with the fields from TextBox's itself? Or must I make a Button_Click event and make the SQL myself there? If I must do it myself, in PHP I used to create forms so all TextBox's were part of an array, then I could easilly make a foreach and create the SQL statement on the fly. This way I could add another TextBox to the page (and in the database ofcause), and not have to go change my code for it to be saved. Im looking for the best solution to creating/updating on a webform... and for my example a webform with 2 TextBox's (Name and Lastname) and 2 Buttons (Update and Create) would be good example, so I can use that method on bigger forms. I hope someone can point me in the right direction. Thanks, Cederstrom Tag: requerying with Dataadapter and dataset Tag: 72192
  - 14
    - Doing something like nested SQL in DataTable.Select method I have a table with fields the following fields ID INTEGER (Primary key) FLAG BOOL TIMESPAN DATETIME IMPORTANCE INTEGER say I want to find the an ID with flag set to true, highest importance and shortest timespan. so one way to write the SQL is this: SELECT ID FROM MyTable WHERE TIMESPAN = (SELECT MIN(TIMESPAN ) FROM MyTable WHERE FLAG=TRUE AND IMPORTANCE = (SELECT MAX(IMPORTANCE ) FROM MyTable WHERE FLAG=TRUE)); so. my problem is. the data is in a dataTable and the DataTable.Select method doesn't take SQL statements. So can something teach me how to find what I need from the DataTable? thxs in advance .Net newB Tag: requerying with Dataadapter and dataset Tag: 72190
  - 15
    - Using the GetChildRows method C# I am new to .net. I am populating a dataset with a few tables using stored procedures successfully and then setting primary keys and relations between table columns. BUT when I go to use the GetChildRows method my relations arent returning any child rows. Is there a better way of assigning the source table's primary/foreign key relationships to the dataset? Help is much appreciated. Tag: requerying with Dataadapter and dataset Tag: 72189
  - 16
    - use crystal report in ASP.NET datagrid search result page I am new to crystal report. I have ASP.NET pages that show the search result. Since the search result is represented by datagrid, it will be nice to put a button on that page, and allows the user to export the result to crystal report. Here's what I have done so far, and I dont know what to do next. 1) Add CrystalReportViewer web control to the search result page. 2) In my ASP.NET application, I added a new item crystal report (.rpt) In my case, can the crystal report just get the result from datagrid. Please advise! Thanks! Tag: requerying with Dataadapter and dataset Tag: 72187
  - 17
    - Accessing Excel thru Jet gives data in scientific notation Hi, I m trying to access an excel spreadsheet to load a named cells in a dataset. For this, I m using Jet OLEDB provider with ADO.Net. String cnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + fileName + "; Extended Properties=\"Excel 8.0;HDR=No;IMEX=1;\""; String sql = "select * from MyNamedCells"; Initially I was having problem with null values for certain cells where datatype appeared different to the provider. e.g. If a top cells of a column contain text data (say A13331123) and in the middle there was some numeric data (4509015284) .. the numeric data was being retrieved as null. This was fixed using IMEX switch. Now - althought the numeric data is being loaded, but it is coming in scientific notation (the above value converts to: 4.50902e+009). How can I get my text back with the right accuracy? Thanks. Tag: requerying with Dataadapter and dataset Tag: 72186
  - 18
    - How to bind PictureBox.Image to database image or bin column? How to bind PictureBox.Image to database image or bin column? thanks Tag: requerying with Dataadapter and dataset Tag: 72182
  - 19
    - FoxPro, dBase III, and ADO.NET I have a newbie question about different database formats as they apply to ADO.NET. I need to get access to a .dbf file using ADO.NET. The files are in dBase III format. Does that mean I need to use the FoxPro Data Provider or that I only need to specify "Extended Properties=dBase III" in the connection string to connect to dBase III files? It's my understanding that FoxPro is just one of many programs that can read dBase III files (just like many text editors can read .txt files or html files). Is this the case? If so, why would someone be interested in using the FoxPro data provider? Thanks, Dave Tag: requerying with Dataadapter and dataset Tag: 72172
  - 20
    - Returning Multiple Resultsets with Jet Hi, I was wondering if you can return multiple Resultsets with Jet 4.0. I keep getting an error on the ; . Dim sSql As String = "SELECT Full_Name FROM States WHERE Country_ID = " & CountryID & " ORDER BY Full_Name;" _ & "SELECT * FROM Countries ORDER BY Name;" Does this work with Jet 4.0? Thanks Tag: requerying with Dataadapter and dataset Tag: 72170
  - 21
    - Setting a datacolumns value to NULL? How do I set the value of a specific datarow's column to be null? Ex. Private sub savedata(byval sOID as string, byval sComment as SqlString) Dim ods as dataset Dim odt as datatable Dim odr as datarow Dim odrarray() as datarow try ods = me.getdataset(xxx...) odt = ods.tables(0) odrarray = odt.select("myoid = '" + sOID + "'") for each odr in odrarray If sComment.isNull then ??????? How do I set this particular row/column to be null??? Else odr("mycomment") = sComment.value End if next finally -- Doug Swanson Senior Applications Developer Synchrono, Inc 651.228.1772 dswanson@synchrono.com Tag: requerying with Dataadapter and dataset Tag: 72164
  - 22
    - DataReader with a return parameter and an OUTPUT parameter. I have a stored procedure and I set up the command type to be StoredProcedure with the return value and the output parameter set to InputOutput. This StoredProcedure also returns a set of rows. From the best that I can tell if I use ExecuteReader() the first time it returns the OUTPUT parameter and it takes a second time to actually get the data. Is this the default behavior or is there some special setup to get this to return the data AND the OUTPUT parameter in one call to ExecuteReader()? Thank you for your suggestions. Kevin rkevinburtn@charter.net Tag: requerying with Dataadapter and dataset Tag: 72163
  - 23
    - Dataset cycle through Hi All, I have created a oledbdataadapter/OledbConnection and dataset. I would like to cycle through all records that the dataset has to implant into a treeview as nodes. How do i do this? This is a win app. Thanks, JJ Tag: requerying with Dataadapter and dataset Tag: 72162
  - 24
    - formatting a label control with a date Probably a simple question: I have a combobox where the user will select a member number. I have two labels that are bound to the member's name (FirstName, LastName). I then have another label that is bound to the member's date of birth. Everything works fine in that when a member is selected from the combobox the name changes and the birthdate changes; however the label for the birthdate is in mm/dd/yyyy format but it also displays the time of 12:00 am. I want to delete the time. Is there a way to do this? Thanks for the information. Brad PS This is an oledb data adapter connecting to an access database. The date field in the database is formatted as short and the date-time picker in VB is a custom format of MMMM dd, yyyy. Tag: requerying with Dataadapter and dataset Tag: 72157
  - 25
    - Inserting identity columns with CommandBuilder generated commands? Hi, I need to commit the changes to the database of a dataset containing many (MANY) datatables. A few of them have an auto-increment column, but I need to insert a specific value in the database (which is MS-SQL, by the way). My code is fine and I send a "SET IDENTITY_INSERT ON" to the database when needed. Since all the operations I need to perform are very basic and that I have many different tables, I am using the CommandBuilder object. The problem is that the Insert command does NOT include the auto-increment field. Is there a way to make the extra parameter is added to my InsertCommand? MSDN and the books I have were not of any help. Thank you very much! Carl PS: Here's the code... Public Sub CommitTable(ByVal table As DataTable, ByVal transaction As SqlTransaction, Optional ByVal allowIdentityInsert As Boolean = False) Dim da As New SqlDataAdapter("SELECT * FROM " + table.TableName, transaction.Connection) da.SelectCommand.Transaction = transaction Dim cmdBuilder As New SqlCommandBuilder(da) Dim cmd As SqlCommand cmdBuilder.QuotePrefix = "[" cmdBuilder.QuoteSuffix = "]" da.InsertCommand = cmdBuilder.GetInsertCommand da.UpdateCommand = cmdBuilder.GetUpdateCommand da.DeleteCommand = cmdBuilder.GetDeleteCommand cmd = New SqlCommand("DELETE FROM " + table.TableName, transaction.Connection, transaction) cmd.ExecuteNonQuery() If allowIdentityInsert Then cmd.CommandText = "SET IDENTITY_INSERT " + table.TableName + " ON" cmd.ExecuteNonQuery() End If da.Update(table) table.AcceptChanges() If allowIdentityInsert Then cmd.CommandText = "SET IDENTITY_INSERT " + table.TableName + " OFF" cmd.ExecuteNonQuery() End If End Sub Tag: requerying with Dataadapter and dataset Tag: 72149
- Next
  - 1
    - How get the names of the SQL Servers available Could someone tell me how get the names of the server running SQL Server in my LAN using VB.NET ???? Many thanks nq Tag: requerying with Dataadapter and dataset Tag: 72147
  - 2
    - [ANN] PgSqlClient 1.0 Beta 4 released. Hello: Beta 4 version of *PgSqlClient* an ADO.NET Data Provider for PostgreSQL 7.4+ released. *Beta 4 ( 20-11-2003 )* * Bug fixes. * Better fit to ADO.NET. * Improved handling of command parameters. * Restricted batch command execution to PgCommand.ExecuteReader calls. * Added correct handling of character sets. * Added support for Geometric types. * Added some improvements to the SSL/TLS library. PgSqlClient 1.0 Beta 4 source code is available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta4-Src.zip?download PgSqlClient 1.0 Beta 4 binaries for .NET 1.0 available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta4.exe?download -- Best regards Carlos Guzmán Álvarez Vigo-Spain Tag: requerying with Dataadapter and dataset Tag: 72146
  - 3
    - Custom Data Providers Can anyone tell me or point me to documentation on how to register a custom data provider? Thanks, Kent Tag: requerying with Dataadapter and dataset Tag: 72145
  - 4
    - Using Oracle Packages in Visual Studio.NET 2003 designer Hi Group, we've noticed that Visual Studio.NET 2003 does not seem to be capable of reading the parameter data for commands on oracle stored procedures that are collected in packages. We can create a command, change the command type to StoredProcedure and enter a stored procedure or function name and it works fine (same functionality as simply drag'n'dropping the stored procedure or function from the server explorer to the designer). That works smoothly. However, when we enter a function name from a package, the name cannot be resolved. It works fine during runtime, when we have manually added the parameters (so there is no spelling problem with the names) - but the designer simply doesn't find the stored procedure or function. Is this a known problem? Are there any workarounds? What we're considering is creating temporary stored procedures (not in a package) to automatically get the parameters, and then manually changing the name so that it referes to the original function stored in a package. This is still easier than manually entering the parameters - but still it's rather cumbersome and time consuming... regards, david -- Auch das geht vorüber. (Sufi-Weisheit) Holger (David) Wagner Tel: +49 (89) 890 50 962 Dewetstrasse 1 Mobil: +49 (177) 274 12 45 D-80807 München Fax: +49 (177) 992741245 Tag: requerying with Dataadapter and dataset Tag: 72141
  - 5
    - unclosed connections problem We have recently migrated a classic asp/sql server web site from windows server 2000 without the .net framework installed to windows server 2003. We seem to be finding that sql server is using up excessive amounts of RAM, much more than the old machine, even with the same amount of traffic. I suspect there may be a number of unclosed database connections in the legacy asp code and that windows 2003 is not shutting them down as quickly as with windows 2000. Does this sound plausible and if so is their any temporary work around to solve the problem. (It may take some time to correct all the code problems) Scott Tag: requerying with Dataadapter and dataset Tag: 72140
  - 6
    - OUT NUMBER Parameters with Microsoft OLE DB Provider for Oracle => Hi Group, we're experiencing a very weird problem with the Microsoft OLE DB Provider for Oracle. We're using the version shipped with Visual Studio.NEt 2003. When we have any OUT parameter of type NUMBER, we get OCI-22060 (Argument [2] ist eine ungültige oder nicht initialisierte Zahl). This also happens when calling a function, where RETURN_VALUE is declared as NUMBER. OUT parameters as VARCHAR2 work fine, whenever we switch to NUMBER, the problem occurs. We're simply drag'n'dropping the command (stored procedure) from the server explorer. Could it be we're doing anything wrong? Or is this a bug in the provider? If so, are there any workaround or fixes available? regards, david -- Auch das geht vorüber. (Sufi-Weisheit) Holger (David) Wagner Tel: +49 (89) 890 50 962 Dewetstrasse 1 Mobil: +49 (177) 274 12 45 D-80807 München Fax: +49 (177) 992741245 Tag: requerying with Dataadapter and dataset Tag: 72139
  - 7
    - Data Control Hi I am dying trying to write all that datadapter code for each and every table that I need. Is there a third party control that I can use until the next version of vs.net comes out? Thanks Regards Tag: requerying with Dataadapter and dataset Tag: 72132
  - 8
    - Using IN keyword in data adapter. Hello all - I've searched high and low to an answer to my question so I'm posting here as my last option I'm trying to use the IN keyword in my WHERE clause of the data adapter to gather all IDs, separating them with commas, but I get an error that states that it could not convert a varchar value (due to the potential comma being there I needed to) to an int (which is what the ID field is defined as). Does anybody know what I can do to get around this issue or is there something I'm doing wrong? Here's my query (@CustIDs can hold a value of 15, for example, or '15,16') SELECT DISTINCT Customer.CustomerID, Customer.CompanyName, Customer.City + ', ' + Customer.State AS CityState FROM Customer INNER JOIN ClientServicesTable INNER JOIN CompanyServicesTable ON ClientServicesTable.CompanyServiceID = CompanyServicesTable.CompanyServiceID ON Customer.CustomerID = ClientServicesTable.ClientID WHERE (CompanyServicesTable.ServiceType = 'S' OR CompanyServicesTable.ServiceType = 'B') AND (Customer.CustomerID = @ID OR Customer.CustomerID IN (@CustIDs)) ORDER BY Customer.CompanyNam Much thanks Mark Tag: requerying with Dataadapter and dataset Tag: 72125
  - 9
    - DataSets, DataAdapters and bad design Does anyone else think the whole design of ADO.NET is a piece of ****? The DataSet is basically a mini, in-memory database. Heavy, tough to move data in and out of the database (@@Identity issues?). I've been developing desktop, web and n-tier applications for over 10 years and have never had a need for anything like it. Or do I just not get it? What am I missing? It seems to me all you need is a DataReader, a Command object, and a well designed data access layer. What do you need a DataSet/DataAdapter for? Tag: requerying with Dataadapter and dataset Tag: 72115
  - 10
    - Could not find installable ISAM I have had the problem where my vb6.0 app works in design mode and compiles and runs on that comp but wont run on others giving me the error : "Could not find installable ISAM" After reading and trying everything the only thing that worked for me was to install Visiual studio 6.0 with service pack 5. then you can remove Visual stuido but the drivers will stay allowing the app to work i did this on a windows 98 box and it worked well hope it helps Tag: requerying with Dataadapter and dataset Tag: 72109
  - 11
    - Sorting a dataset Hi All, I've populated a dataset, but need to return the results, one by one, in numerical order. I can do this easily when attaching a datagrid to a dataview, but I can't seem to do it on just the dataset. Anyone have any ideas on how to do this? My code is as follows... dsDistributionLists.ReadXml(Server.MapPath ("../XMLRoutines/4020DistributionLists.xml")) Dim holdingTable As New DataTable() Dim distListID As New DataColumn() holdingTable.TableName = "holdingTable" distListID.ColumnName = "distListID" holdingTable.Columns.Add(distListID) dsDistributionLists.Tables.Add(holdingTable) Dim dt As DataTable For Each dt In dsDistributionLists.Tables If Val(Mid(dt.TableName, 2)) > 7 Then Dim newRow As DataRow = dsDistributionLists.Tables("holdingTable").NewRow newRow(0) = Val(Mid(dt.TableName, 2)) dsDistributionLists.Tables ("holdingTable").Rows.Add(newRow) End If Next *********************** SORTING THING IN HERE ************************ Dim dr As DataRow For Each dr In dsDistributionLists.Tables ("holdingTable").Rows Response.Write(dr.Item(0)) Next Tag: requerying with Dataadapter and dataset Tag: 72107
  - 12
    - How to bind RTF text and Image VB6's RichTextBox can bind the RTF text with DataField prop, but .Net RichTextBox's Rtf Prop can't select for bind, Only bind the Text prop, but the Text prop can't read/write RTF format text! how to bind the RTF text with a RichTextBox control? I want't write the RTF text read/write code without bind my Database is SQL 2000 my DevProgram is C# my Project is a Windows Application thanks BTW: How to bind the Picture control 's Image prop with database's BLOB(image) ccolumn ? thanks Tag: requerying with Dataadapter and dataset Tag: 72106
  - 13
    - Caching data on local machine I need to cache a dataset on the client machine and amnipulate the dataset until the user desires to post the changes back to the server. ANy help? Tag: requerying with Dataadapter and dataset Tag: 72089
  - 14
    - LoadXML 2nd try Problem with reading a RSS Dim reader As XmlTextReader = New XmlTextReader(http://weblogs.asp.net/hpreishuber/Rss.aspx") ds1.ReadXml(reader) Error A column named 'comments' already belongs to this DataTable. this is cause on field comments is with namespace any workaorund/solution?? -- Gruss Hannes www.asp-konferenz.de - das Event für den MS Webentwickler www.aspnet-professional.de - das Magazin www.devtrain.de ASP und .NET Community Site www.vbmoves.de VB bewegt sich doch www.ppedv.de Company Site Tag: requerying with Dataadapter and dataset Tag: 72088
  - 15
    - Web DataGrid I have a search which returns one row, 1 result in a web datagrid. One textbox is also on the page and now I need to fill that text box with the first value from that datagrid (that value is a number). Thanks Tag: requerying with Dataadapter and dataset Tag: 72087
  - 16
    - How to get archive-informations of database with SQLClient or ODBC I have used blow method to get archive-informations of database,but there is always error,i don't know,how can i do,with ODBC too.I use J [C# SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind") SqlDataAdapter schemaDA = new SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.TABLES " "WHERE TABLE_TYPE = 'BASE TABLE' " "ORDER BY TABLE_TYPE", nwindConn) DataTable schemaTable = new DataTable() schemaDA.Fill(schemaTable); Tag: requerying with Dataadapter and dataset Tag: 72086
  - 17
    - Can't see counters at the performance monitor Hi All, I am trying to view the: "Current # of pooled and non pooled connections" from the performance monitor. When I select the performance object ".NET CLR Data" and select a counter from the list of counters, I can't select an instance from the instances list (not even _Global_) because it is disabled. What can be the cause of that ? Thanks !! Raz Tag: requerying with Dataadapter and dataset Tag: 72085
  - 18
    - SqlDataAdapter and finalization Hello all, I had some code that forgot (or should I say I forgot) to call Dispose on a SqlDataAdapter, so I thought it will be okay since SqlDataAdapter inherits via Component so the inherited Dispose/Finalize pattern would be picked up. However, after poking around with a decompiler I notice that within the constructor of SqlDataAdapter the call to GC.SuppressFinalize() is made so because my code forgot to call Dispose, the cleanup code will never be called via the overriden Finalizer in Component. Does anyone haveany thoughts on the rationale behind the SqlDataAdpater choosing to call GC.SuppressFinalize() in its constructor. Colin Tag: requerying with Dataadapter and dataset Tag: 72084
  - 19
    - multiple inserts Hoping someone can help with an optimisation query... I'm looping through an array, doing thousands of inserts. At present for every iteration of the loop I'm creating a new command object, and opening and closing the connection object, something along the lines of.... For Each objAS400Data In arrAS400 objCommand = New OracleCommand(strPackageName, objConnection) objCommand.CommandType = CommandType.StoredProcedure objCommand.Parameters.Add(New OracleParameter("IN_PARAMETER_ID", OracleType.Int32)).Direction = ParameterDirection.Input objCommand.Parameters("IN_PARAMETER_ID").Value = objParameter.Value Try objConnection.Open() boolReturn = objCommand.ExecuteNonQuery If Not (objCommand.Parameters("out_errMsg").Value Is DBNull.Value) Then strError += CStr(objCommand.Parameters("out_errMsg").Value) boolReturn = False objConnection.close() objCommand = Nothing Exit For End Try objConnection.close() objCommand = Nothing Next Whilst this all works, I can't help but get the feeling that instantiating all these objects, and opening/closing the connection is slowing things down. Is there a better, more efficient way of doing this? regards, Bruce Tag: requerying with Dataadapter and dataset Tag: 72077
  - 20
    - newbie, converting from ado to ado.net --> datareader help needed. Hi, I am converted an existing vb6 web app to vb.net and have run into a bit of a problem with data access via ADO.NET. I am doing a full text search against a SQL Server 2000 DB, the SP that I call to do this returns multiple resultsets, therefore from the documentation I found that I would have to use the SqlDataReader in order to move from one resultset to another. However here lies the problem. After the SP is called in the vb6 version I used the recordsets "RecordCount" method to create a large enough array to do some additional processing (don't ask). But I can no longer do this with the datareader because you read one row at a time. So my problem is how do I find out how many records are in the current resultset when using a datareader? As you can imagine the search SP is not trivial and repeating the query twice just so I can find out the recordcounts is not acceptable. My first guess at a solution would be to use an ArrayList and then just call it's .Add method then I wouldn't need to worry about array size. Any other suggestions welcome. Regards, Peter Tag: requerying with Dataadapter and dataset Tag: 72076
  - 21
    - How to display/edit formatted text from a database? Hi All! What is the most recommended way of displaying formatted text from a database and allowing users to edit and save it back to the database? I guess, RichTextBox control will do the job, but I was not able to display multi-line table rows properly in the RichTextBox control [although they display just fine in Word(Pad)]: http://communities.microsoft.com/newsgroups/previewFrame.a sp? ICP=msdn&sLCID=us&sgroupURL=microsoft.public.dotnet.framew ork.windowsforms&sMessageID=%253C06fd01c3ad0c% 2524e4d8c490%2524a401280a@phx.gbl%253E i.e., instead of +---+ | A | +---+ |AAA| |AAA| |AAA| +---+ I am getting +---+ | A | +---+ |AAA|AAAAAA +---+ What gives? Hopefully, there is an alternative to Word automation, because I do not want my application to depend on Word. Phil Tag: requerying with Dataadapter and dataset Tag: 72075
  - 22
    - How to update a row using timestamp Hi All, I have a table with a timestamp column. I use SQLHelper static class from(Microsoft's DAAB) to get the data from the table and store it in my C# class. When the user modifies the class properties and then call the Update method of my class I update the database. Here I want to check the timestamp. Can anyone tell how to store the (sql server 2000) timestamp value in C# and then pass it to SQL Server. Thanks In Advance, Venki Tag: requerying with Dataadapter and dataset Tag: 72070
  - 23
    - ACCESS DB - How do I get .NET to talk OK...I give up It would seem like Microsoft decided that they really liked SQL server, and so made it impossible for .NET to talk to ACCESS. I am using the 1.0 framework. I was getting a "The Microsoft Jet database engine cannot open the file <filename>. It is already opened exclusively by another user, or you need permission to view its data." message. This led me to KB 316675. So...I modified the machine.conf file (which means that, although I MIGHT get it to work on my machine, it probably won't work when it is hosted on the ISP) and behold...Now I get the message "Cannot Lock File" when I try to open the file to perform a SQL select statement. Pardon my french, but WHAT THE HELL DO I NEED TO DO TO GET THIS STUPID THING WORKING? Can somebody provide a code sample???? Thanks Tag: requerying with Dataadapter and dataset Tag: 72069
  - 24
    - object model - dataset, dataadapter, datatable Hello All, Could you guys help me understand the ado.net object model ? This is what I think, correct me if I am wrong * DatAdapater acts as a bridge to bring in/send out data to database * Dataset is in-memory cache, disconnected from db, doesnt talk to db directly * DataTable could be a part of dataset. could multiple table from a common datasource be a part of same dataset ? * How to add multiple tables to same dataset, using same datasource ? * A separate dataadapter is needed, for each SELECT/Stored proc, which will bring in data to dataset Can a single dataadapter be used for multiple tables added to the same dataset having common source ? I am somehow confused & thinking that there has to be 1 dataadapater for each SELECT querying diff tables Regards Kalpesh Tag: requerying with Dataadapter and dataset Tag: 72067
  - 25
    - Handling exception inside SQL Server stored procedure & return custmised message Hi friends, I am observing a pretty strange behavior when i try executing stored procedure using C# code. This is explained below: I have a table in which I have some constraints defined like unique, foreign key, check, etc. I have created a stored procedure to insert a record in this table. In this procedure, i am doing explicit exception handling. Say if there is any constraint getting violated during insert operation then I am catching the @@Error value in my locally declared variable @ErrorCode and if it's not equal to zero, then I am returning a customised error message via a output parameter declared in the procedure body, plus I am returning the actual database error code to the calling program by direct return @ErrorCode statement. Now when I execute this procedure with some dummy test values using a SQL Query Analyzer, it gives me perfect result. Now when I try to execute the same procedure from C#- ADO.NET code, with fresh values (which is not violating any constraints), it gives me perfect result. But the moment I test it with any values which violates the database constraint, exception message is displayed directly on the screen. As such, as per the logic implemented in stored procedure, the constraint violation message shouldn't be thrown by the C# code directly on the screen. I am just surprised to see this strange behavior. I am sure you have a reason for this strange behavior, plus an alternative way to do the same. Thanks and Regards, Amit Tag: requerying with Dataadapter and dataset Tag: 72066

Hi all ,
I wonder if you can help I run this code once

Dim daEmpDet2 As OleDbDataAdapter defined globally

strSQL1 = "select * From PREmpDet where Empcode='" & EmpCode & "'"
Dim dsEmpDet2 = New OleDbDataAdapter(strSQL1, cn2)
daEmpDet2.Fill(dsEmpDet2, "EmpDet2")

I get the right record when run the code the first time .
when I rerun the code with a different EmpCode I Still get the first record
what am I doing WRONG.
Thanks

Top

Re: requerying with Dataadapter and dataset by Miha

Miha
Fri Nov 21 14:38:07 CST 2003

Hi,

You should clear the dataset before doing fill (fill just adds rows)

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

<CobraStrikes@al.com> wrote in message
news:bpln9t$avd$1@news7.svr.pol.co.uk...
>
> Hi all ,
> I wonder if you can help I run this code once
>
> Dim daEmpDet2 As OleDbDataAdapter defined globally
>
> strSQL1 = "select * From PREmpDet where Empcode='" & EmpCode & "'"
> Dim dsEmpDet2 = New OleDbDataAdapter(strSQL1, cn2)
> daEmpDet2.Fill(dsEmpDet2, "EmpDet2")
>
> I get the right record when run the code the first time .
> when I rerun the code with a different EmpCode I Still get the
first record
> what am I doing WRONG.
> Thanks
>
>

Top