How to select distinct values

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
    - REGISTERED CAD/CAM/GIS softwares! hi all ! see my site and you understand all. www.michaeliusis.narod.ru Hi all ! I provide CRACKED engineering and technical software at this topics: 1. Civil and Structural 2. 2. Survey , GIS , Rock , Soil and Water 3. Architectural 4. CAD-CAM 5. FEA , CFD and CAE 6. Electrical , Electronic , Control and Power 7. Chemical 8. Industrial and Control Project 9. HVAC and Piping 10. Mathematics , Statistics and Accounting 11. Engineering and Technical Standards and Databank Such as ISO , DIN , BSI ,ASME , ASTM ,... 12. Graphics and Animation 13. Busines and Financial 14. And other technical topics. Making cracks for your desire , any program. All soft I offer have been completely cracked and tested carefully by expert in corresponding field. All programs are full copies of originals (not demo, evaluation, trial or educational version) including English or multilanguage tutorial and crack or license file that makes program work as registered software from the house. Here is just a part of our software list.For getting the additional information Contact e-mail: danielhtools@yahoo.com Actel Designer V5.2 Adina System v7.5 Adobe Video Collection Pro V2.0 Agilent ADS 2003C ALGOR V15 Altium Protel 2004 Ansoft Ensemble v8.0 Ansoft HFSS 9.1 ANSOFT.SIMPLORER.V6.0 ANSYS CFX V5.7 (c) SAS IP INC, ANSYS Workbench 8.1 ArcView 9.0 Autodesk Architectural Desktop 2005 Autodesk AutoCad 2005 Autodesk AutoCad 2005 LT AUtodesk Building Systems 2005, AutoDesk Composer 2005, Autodesk invision 8 AutoDesk Land Desktop 2005, Autodesk Mechanical Desktop 2004 AutoDesk OnSite Enterprise 2.5, Autodesk Pre-Plan AutoDesk Raster Design 2005, Autodesk Revit 6.0 AutoDesk Revit 6.1, AutoDesk Survey 2005, Autodesk VIZ 2005 (c) Autodesk, AUTODESK.Inventor Professional 9 AUTODESK.INVENTOR SERIES V8 AUTODESK.VIZ.4.2 AutoManager Meridian 2004 AutoManager TeamWork 2004 Axum v6.0 (MathSoft) BENTLEY Descrates v8.1.2 NT2KXP Bentley Explorer 2004, BENTLEY GEOPAK REBAR 2004 Edition BENTLEY HVAC V8.01.01.05 BENTLEY IRAS B v8.1.2 NT2KXP BENTLEY MicroStation GeoGraphics v8.01.02.03 BENTLEY MicroStation Triforma v8.1 BENTLEY MicroStation TriForma v8.1.1. BENTLEY MicroStation V8.5 BENTLEY PowerDraft Database Server v8.01.02.20 BENTLEY PowerDraft v8.01.02.20 BENTLEY Redline v8.01.02.18 BENTLEY TriForma v8.01.01.24 BENTLEY.INROADS V8.4 BENTLEY.MICROSTATION.V8.1 BobCAD-CAM Version 19.0 Cadence Allegro v13.6 Cadence PSD rev 15.0 CADKEY Workshop EX v21.5 SP2 CAESAR II ver 4.4 Calcmenu 2004 CAM350 Release 8.5 Catia CAA V5R12SP3 Catia Rade tools V5R12SP3 Century Software TinyTERM Plus v4.40, CFDlab.v2.2 CFX v5.6 ChemOffice Ultra 2004 v8.0 ChemOffice Ultra v8.03 (C) CamSoft Cimatron 13 CIMATRON IT v 13.1 Cinema 4D ver. 8.503 CNC Plus V5 CNC Professional V15 Coade CadWorx Pipe V2004 COADE CodeCalc 2004 Build 040607 COADE PVElite 2004 Build 040607 COADE TANK 2.50 Build 040510 Cocreate NET MODEL EXPLORER 2004 V12 COSMOS Works 2004 SE Cosmosworks 2004 CSI ETABS NonLinear v8.13 CSI Sap2000 Nonlinear v8.2.3 CST Microwave Studio 5 DASSAULT SYSTEMES CAA CATIA P3 V5R13 DASSAULT SYSTEMES CAA ENOVIA LCA V5R13 DASSAULT SYSTEMES CAA ENOVIA PORTAL V5R13 DASSAULT SYSTEMES CAA RADE V5R13 Dassault Systemes CATIA v5R13 DASSAULT SYSTEMES DELMIA VMAP D5R12 SP4 Dassault Systemes Enovia 3d com v5.0 R13 Dassault Systemes Enovia DMU Navigator v5.0 R13 DASSAULT SYSTEMES ENOVIA DMU V5R12 DASSAULT SYSTEMES ENOVIA USER COMPANION FOR DMU V5R12 Dassault Systemes Enovia VPM Navigator v5.0 R13 DASSAULT SYSTEMES SMARTEAM V4.0 SP5.5 DEFORM 3D v 4.03 Deform 3D v5.0 (c) Scientific Forming Technologies Corporation DELCAM ARTCAM PRO V5.509C Differential Calculus (CrashCourse) Division Visual Collaboration Services 6.4.8, EdgeCAM V8.0 EdgeCAM V8.75 EdgeCAM.v7.5 EDS Design Shop 2004 Email Spyder V1.9 Empire v4.00 LICENSE FIX (c) IMST Erdas Imagine 8.6 Erdas Imagine V. 8.7, ESRI ArcGIS 9 ESRI ArcGIS Desktop v8.3 ESTOS PROCALL 2.2.17 Expert Moldbase Extension 4.1 DatecodeM150(2004120), FASTSHIP V6.1 FEM DESIGN V4.2 FIDES.Drill.v2003.336 FIDES.Erddruck.v2004.041 FIDES.Flow.v2004.036 FIDES.Gleitkreis.v2004.041 FIDES.Grundbruch.v2004.041 FIDES.KEM.v2003 FIDES.KEM.v2004.041 FIDES.Pilepro.FEM.v2003 FIDES.PILEpro.v2004.043 FIDES.Setzung.25D.v2004.042 FIDES.Setzung.v2004.041 FIDES.SteelCON.v2003.308b FIDES.Walls.Bemessung.v2003.288 FIDES.Walls.FEM.v2003 FIDES.Walls.FEM.v2004.041 FIDES.Walls.v2004.033 FIDES.WinIGEL.v2004.043 FileMaker Developer 6 Flexisign 7.5 FLOWPHASE.POWER.SUITE.V1.02 FLOWSCIENCE.FLOW.3D.V8.2 FormZ 4.2 (c)Auto·Des·Sys,Inc. FORMZ RADIOZITY V4.0.3 GIBBSCAM 2004 V7.07 Goelan 5.5 GoSteel 4.1 GravoStyle 98 v4.1 Dynamic version HEAL V8.1 - ANSYS, Hydraulicdesign Form vs Shape Rhino Tutorial v2, HyperSteel v7.0 HYPERSTEEL V7.1 SP1 HYSYS V3.2 - HYPROTECH, Image Processing Ext Pack for MathCAD 2000/2001 3.0 (Mathsoft) Intergraph PDS v 7.2 INUS TECHNOLOGY RAPIDFORM V2004 JewelCAD v5.0 LabVIEW 7.0 Lasergene version 5.08 Liscad.v6.2 LOGIC DESIGN AND VERIFICATION V5.1 (c) CADENCE Ls-Dyna V 970 Maple 8 (Waterloo Maple) Maple 9.5 Mathcad v11.A Enterprise (Mathsoft) Mathematica 4.2 (Wolfram Research) MATHWORKS MATLAB V6.5 Mathworks Suite v13 With Matlab v6.5 (Mathworks) MAXNC 15 CL & RAMS CAM Software Maxon Cinema 4D Maxon Cinema 4d v 8.5 MECHSOFT.INVENTOR.SERIES_6.0 Medisoft Network Professional Version 9 Mentor Boardstation C4S Metrowerks CodeWarrior HC(S)08 V3.0 MicroSim 8.0 MICROWAVE STUDIO V5.0 - CST, MODELSIM.SE.V5.8A Modelsim5.8B SE MPSIII v4.0 (Ketron) MSC.Fatigue for MSC Patran 2004 MSC.FEA-MSC.AFEA 2004 (C) MSC.Software MSC.Patran 2004 Documentation (c) MSC.Software, MSC.SuperForm 2004 with MSC.SuperForge 2004 NCSS 2002 (NCSS) NCSS 2004 STATISTICAL ANALYSIS SYSTEM NE NASTRAN V8.3, Nemetschek Allplan Ft v17.0 Nemetschek Allplan v2004 Nemetschek PlanDesign V2004 Nemetschek Vectorworks 10 Spotlight incl Renderworks NUMECA.FINE.TURBO.DESIGN.3D.V6.0 ORCAD 9.23 CADENCE OriginLab Origin Pro 7.0 PCB DESIGN STUDIO V15.1(c) CADENCE PENTALOGIX CAM MASTER 8.4.50 PLanit Millennium 8.3 Plaxis 8.0 Pointwise.Gridgen.V15 POWERCAD.PRO.V5.0 Primavera Expedition 8.5 Pro/DESKTOP Express 8 Pro/E Wildfire Date Code 2002490 Pro/ENGINEER Wildfire 2.0 Datecode F000 (2004110), Pro/INTRALINK R3.3 Service Pack Datecode M021, Pro/INTRALINK Release 3.3 DateCode 2002471 (c) PTC ProgeSOFT IntelliCAD 4.8 Progressive Die Extension 2.1 DatecodeM140(2004030), PROSTEEL 3D V16.2 Protel 2004 SP2 Protel DXP 7.0 PTC Pro Engineer Wildfire v2003 QuarkXPress 6.0 Quartus II v4.0 for PCs (c) Altera QuickBooks pro 2004 Radimpex ArmCAD v2.3.3 Radimpex software Tower 5.0 Radimpex Tower 4.3.8 Ram Advanse v5 Ram Structural Steel V8.0 REBIS AUTOPIPE V6.2 Rebis AutoPIPE v6.20 SAS v8.2 Scientific Notebook 3.5 (MacKichan) SDD 2004 (c) Mentor Graphics, SDS/2 v6.325 SESCOI WorkNC V16-12 Sescoi.WorkNC v16.0 Multilanguage ShipContructor2005 (c) ARL Softplan 11 Solid Edge v15 (c) Unigraphics Solutions Solidworks office 2004 SOLIDWORKS V2004 SP3 SolidWorks2004 SP 2.1 SPECCTRA ShapeBased Automation Software V15.1 SPSS v12.0 Staad PRO 2003 Synopsys.Core.Synthesis.v2002.03 Synopsys.Core.Synthesis.v2003.03 TANNER L-EDIT PRO V10.0 with LVS V10.0 TANNER S-EDIT V8.1 Teamcenter Visualization 5.1 (c) EDS, Tebis 3.2 r2 TECPLOT.V9.0 With CFD Analyzer 2.0 Tekla Structures V10.0. TEKLA XSTEEL v9.0 TEKLA XSTEEL V9.1 TEKSOFT PROCAM II V2003 T-FLEX CAD 8.0 TkSolver v4 Interactive Roark's Formulas (UTS) TurboCAD Deluxe Version 10.1 TurboCAD Professional v10.1 Unigraphics 18.0 UNIGRAPHICS NX 1.0.3.2 UNIGRAPHICS NX V2.0 VectorWorks LANDMARK v 10 Virtual Gibbs 6.1 Visual Mill 5.0 VisualMill 5.0 WASP-NET V5.4.3 (C) MiG WG2004 (c) Mentor Graphics, Wilcom 8.0 Wizetrade v 7.0 Working Model 2D 2004 v6.0 (c) MSC Software Zuken 6.04 ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: How to select distinct values Tag: 106603
  - 2
    - Performance Problems with filtering in Dataview Hi all! I would really appreciate getting some help on the following problem: I use a cached dataview as a source for my datagrid. The user selects items from controls and based on the selections a filter is applied on the dataview and the datagrid re-databinded. Now the problem: when I test the application on the server it works extremely fast, the filtering processes within 2 to 3 seconds on a datatable with 4000 rows! When I try to access the same site on the server from a client-Computer in the business network the filtering takes about 40 to 60 seconds!!! Does anyone have a clue how to explain these extreme performance differences? THANKS in advance, Robert Gregory -- Message posted via http://www.dotnetmonster.com Tag: How to select distinct values Tag: 106601
  - 3
    - SPs, sqlCommand and Terminal Services Hi all, I just ran into something very, very strange.. I have this application which fires of a series of SQL Scripts using the sqlCommand Object. One of the statements executes the procedure "sp_addMergePublication" on the server. If I do this on a local machine, everything works fine. But if I run my application on a server using Terminal Services then the application will Halt on that statement saying that "A severe error has occured." and that any changes should be discharged. Note. This happens ONLY when I run the application remote and it is not an error bound to a specific machine. I can recreate the problem on any given server. Has anyone ever had this problem, or perhaps even knows why this happens? B Tag: How to select distinct values Tag: 106595
  - 4
    - DataSet Filter Hello all. I'm trying to filter a dataset using the below snippet, however, it's returning 2 rows and it should only return 1. Can anyone please hel?p DataView dv = new Customer().GetCustomerFiles(4).Tables[0].DefaultView; dv.RowFilter = "FileType = 'Company Info'"; int b = dv.Table.Rows.Count; string a = dv.Table.Rows[0]["Title"].ToString(); Thanks all, Jon Tag: How to select distinct values Tag: 106593
  - 5
    - SqlCommand fires too soon..... I have the following: ___________________________________ Dim cmdSaveUser As New SqlCommand cmdSaveUser.Connection = con 'con has been configured previously cmdSaveUser.CommandType = CommandType.StoredProcedure cmdSaveUser.CommandText = "spInsertUser" cmdSaveUser.Parameters.Add("@FirstName", "Joe") cmdSaveUser.Parameters.Add("@Navn", "Brown") cmdSaveUser.Connection.Open ..... ___________________________________ What happens is this: As soon as i .open the connection, it seems that the command is fired. I don't want this to happen, as I want to call executeScalar and get an object in return. Any ideas? Jeppe Jespersen Tag: How to select distinct values Tag: 106592
  - 6
    - Losing records in a transaction I'm currently using .NET 1.0 and MS .NET provider for Oracle to connect to my Oracle9i R2(9.2.0.5) database. I have a piece of code which in essence is as given below Try m_Conn = New OracleConnection(strDBConnString) m_Conn.Open() m_Trans = m_Conn.BeginTransaction() 'Here I have a series of inserts and updates on huge tables. I am using ExecuteNonQuery function of the OracleCommand object for all these operations. InsertTb1() InsertTb2() UpdateTb3() 'If all goes fine I commit the whole transaction m_Trans.Commit() Catch ex as Exception 'Here I catch all exceptions and rollback the whole transaction m_Trans.Rollback() Finally m_Conn.Close() End Try I have similar code doing different actions on the same tables, running through out the application. Off late I have been getting database locks and subsequent slowness in the application. My DBA tracks down the holding statements and kills the session. Now, if the script used in InsertTb1() happens to be the statement of the assocated session that was killed, I expect Oracle to throw an exception, which inturn should be caught in the catch block and the whole transaction shoud be rolled back. But, it looks like I do not get an exception, due to which the code proceeds to fire the subsequent statements (InsertTb2(), UpdateTb3()) and I end up with incomplete records in the database. I have had an instance before, where Oracle database was throwing a 'No Data found' exception, but the exception never bubbled to my code i.e. The .NET provider ignored the excepton. Could this be a similar case? -- Message posted via http://www.dotnetmonster.com Tag: How to select distinct values Tag: 106591
  - 7
    - changing the table a dataadapter accesses changing the table a dataadapter accesses If I want to change the table a dataadapter accesses, can I remove the former table from the dataset's xsd file by simply deleting it? Thank you in advance. dennist685 Tag: How to select distinct values Tag: 106590
  - 8
    - DataTable.Select question Hi! An application adds DataRows into DataTable in random period of time, and after adding new rows saves DataTable as XML-file. DataTable contains DateTime Field named as "SaveTime", and some other fields... About "SaveTime" field, schema looks like... <xs:element name="SaveTime" type="xs:dateTime" minOccurs="0" /> Q: Is it possible to retrieve easily only those rows where rows are for example at least 10 minutes old according "SaveTime"? I mean something like... Dim drArr As DataRow() = dt.Select("SaveTime >= 10min") ...so how to make filterExpression correctly if it is possible? -- Thanks in advance! Mika Tag: How to select distinct values Tag: 106586
  - 9
    - Inject timeout BUT it's success Hi, My program uses DAAB to inject data to SQLServer using ExecNonQuery() with stored procedure. In normal case, it works property. But in some situations such as database backup process, I got timeout error and my program will retry to inject until success. In this week, I've found that my program inject data in backup period and it returns duplicate row after backup done. I think it will inject success but it returns timeout error. Do you have any suggestion to check this, because my program has to notify another program to process this data after injecting success. Best regards, Thana N. Tag: How to select distinct values Tag: 106585
  - 10
    - DataRowCollection.InsertAt method Hi to you all, I wonder if anyone has been able to get the DataRowCollection.InsertAt method to work correctly? I added 2 rows in DataGrid using InsertAt function. After I edited one of the rows and moved to Up/Down, a new identical row appeared in the DataGrid. Is this a bug? Any workaround in this case? Thanks, Daniel Tag: How to select distinct values Tag: 106583
  - 11
    - DataTable.TableName returns "Table"?? Hi, I get a DataTable based on this simple query: SELECT * FROM Customers Later, I want to know just the table name because I do not want to play with the string within the SELECT statement. I expect DataTable.TableName to give me an exact name, i.e. "Customers", but it gives me "Table" regardless of what query from what table. Can someone gives me some clarifications on the TabeName property? Thanks in advance. Regards, Antonio Tag: How to select distinct values Tag: 106578
  - 12
    - DataSet and GC.SuppressFinalize We are having issues with DataSet and related objects. They are staying in the memory for too long. When we started investigating the problem, windows debugger (windbg) showed that they are in the finalization queue. This surprised us as we were not aware that they have finalizers defined. The .net framework code (mentioned in this email) is reverse engineered by Anarkino tool. Even though DataSet does not define a finalizer, it derives from MarshalByValueComponent (MBVC) which does implement finalizer. In addition, the DataSet does not define a Finalize method but the base class does. However the base class has only proteted Finalize method. This means only derived classes can call this method. The constructor of DataSet makes GC.SuppressFinalize(this) call. Thinking that we have to call Dispose method, we checked for Dispose method implementation on DataSet. Well, it is not there. But MBVC has it. To my surprise, it is making GC.SuppressFinalize(this) again in the MBVC's Dispose method. This means these objects will never be finalized (is this right?) That is 2 times we saw the GC.SuppressFinalize between DataSet and MBVC implementations. Can any one explain why the supress call is required when we are not using any typed datasets? Is there an elegant way to make them disappear faster (other than using ReRegisterForFinalize method)? This problem applies all classes the derive from MBVC. Thanks. Raghu/.. Tag: How to select distinct values Tag: 106570
  - 13
    - Dataset XML Select Hello, I use VB.net I have a XML file and I read it with a dataset : myDS.readxmlschema("test.xsd") myDS.readxml("test.xml") I have 3 tables in my dataset. Is it possible to select easily data like with SQL ? ex. Select name from Table1 Where region = (Select num From Table2) .... Thanks for your help Tag: How to select distinct values Tag: 106567
  - 14
    - Removing empty fields from a bound datagrid Howdy folks: Long time listener...first time poster. My issue is that I am binding DB data to a datagrid using the <%# Container.DataItem("FOO") %> methodology. So my question is this...if FOO is empty, how can I substitute it out and replace it with something like "Not Entered"? Yes, I know I can choose to do this programatically, but before I go down that road I wanted to know if it's possible with a hidden Eval command or something of the like. Danke, Jacko Tag: How to select distinct values Tag: 106565
  - 15
    - Efficient Database Paging Tests I have been trying to determine the fastest way to implement database paging for an Access database with an ASP.NET front-end. I have a difficult database because the user can change the sorting and the fields are not unique, which excludes the "Select TOP" approach. Also the database has about 60,000 records and is growing. The user has to always have current data which excludes caching. I've tried the following approaches: 1. Using an OleDBDataAdapter to fill a datatable and then displaying the paged records from the table. 2. Using an OleDBDataAdapter to partially fill a dataset with the paged records and then running a second command to retrieve to the total records. 3. Looping through an OleDBDataReader until I get to the paged records and a second command to retrieve to the total records. 4. Looping through an OleDBDataReader to get the paged records and then completing the loop to count the total records. All 4 methods return the current total records which I need to set up my paging menu. Approach #1 if by far the slowest (up to 4 times slower) in every scenario. Approach #2 is the fastest most of the time. The Microsoft documentation warns that this approach is inefficient, but I have not found this to be the case. The only case where this approach faults is when the query's WHERE clause is very complicated. However, when there is no WHERE statement or ORDER BY and the page is near the start of the records then this approach is about 4 times faster than the next fastest. Approach #3 is slightly slower than #2 and also faults when the WHERE statement is complex. Approach #4 is also only slightly slower than #2, and it is not slowed down by a complex WHERE statement. My conclusion is that either #2 or #4 is best. Any suggestions would be appreciated. Tag: How to select distinct values Tag: 106563
  - 16
    - OleDbDataAdapter Partial Fill I'm using a OleDbDataAdapter to partially fill a dataset: Overloads Public Function Fill(DataSet, Integer, Integer, String) As Integer Everything works, but the function only return the records filled. Is there any way to get the total record count, without another command? Tag: How to select distinct values Tag: 106560
  - 17
    - Batch Queries with OLEDB I'm trying to use a batch SQL statement with an OleDbDataReader and the NextResult method. I tried: "SELECT Pages FROM Documents ; SELECT Date FROM Orders;" However, I get the error: "Characters found after end of SQL statement. " If I try removing the semicolon I get "Syntax Error in Query Expression." My database is a Microsoft Access 2000 mdb file and the code is running in ASP.NET. What am I doing wrong? Tag: How to select distinct values Tag: 106559
  - 18
    - Format of the initialization string does not conform to specification... I am trying to load data from a flatfile into a dataset, but I get the following errror: "Couldn't connect: Format of the initialization string does not conform to specification starting at index 170." What am I doing wrong? --gloria -------------------------- schema.ini: [861D_NI_03082005001.txt] ColNameHeader=False Format=TabDelimited CharacterSet=ANSI -------------------------- string filename = "861D_NI_03082005001.txt"; string fullfilename = @"\\asean-test2\sdc\" + filename; string connectionStr = "Provider=MediaCatalogMergedDB OLE DB Provider;" + "Persist Security Info=False;Data Source=" + fullfilename + ";Mode=Read" + "Extended Properties=\"Text;HDR=NO;\""; string loaddtlStr = "select * from " + filename; try { OleDbConnection loaddtlCN = new OleDbConnection(connectionStr); loaddtlCN.Open(); porerrorClass.WriteLine(3,CurrentFunction,"Connection is open."); OleDbDataAdapter loaddtlDA = new OleDbDataAdapter(loaddtlStr,loaddtlCN); DataSet loaddtlDS = new DataSet("LoadedDtl"); loaddtlDA.Fill(loaddtlDS); int rowcnt = loaddtlDS.Tables[0].Rows.Count; porerrorClass.WriteLine(3,CurrentFunction,"Rows loaded: " + rowcnt); loaddtlCN.Close(); } catch (Exception ex) { porerrorClass.WriteLine(3,CurrentFunction,"Couldn't connect: " + ex.Message); } Tag: How to select distinct values Tag: 106557
  - 19
    - Big Problem on SQL Server link to Web Services Dear developers, i hav face a big problem on connect my web services to my DB. i m using MS SQL Server 2000 to build the web services.. but i cannot invoke the input into the database and "HTTP 500 - Internal server error" on the IE. I hav try the same thing on newly created ASP.NET Web Application, it works fine... but when come to the ASP.NET Web Service, i face the problem.. can everybody out here pls advice.. anything additional setting should make on the Web Service..? Thanks a lot.. cheers, Wong CS Tag: How to select distinct values Tag: 106554
  - 20
    - DataRowCollection InsertAt method Hi to you all, I wonder if anyone has been able to get the DataRowCollection.InsertAt method to work correctly? I added 2 rows in DataGrid using InsertAt function. After I edited one of the rows and moved to Up/Down/Left/Right, a new identical row appeared in the DataGrid. Is this a bug? Any workaround in this case? Thanks, Daniel Tag: How to select distinct values Tag: 106549
  - 21
    - AutoIncrementSeed une solution complète qui marche C'est un mini exemple avec un DataGrid, un bouton "Add" (pas nécessaire, juste pour le code) et un bouton "Update". Le but : Utiliser des valeurs négatives pour les nouvelles saisies dans les champs auto incrémentés. Lors de la mise à jour avec DAProduits.Update(...), on cherche la prochaine valeur du champ auto incrémenté pour mettre à jour à la fois l'enregistrement du Dataset (pour le DataGrid...) mais aussi celui situé en base de données réelle. Si cette table est liée avec une autre, utiliser les mises à jour en cascade (dans le DataSet): ForeignKeyConstraint.acceptRejectRule ForeignKeyConstraint.DeleteRule ForeignKeyConstraint.UpdateRule Cet exemple a été réalisé pour une base de données Access. Public Class Form1 Inherits System.Windows.Forms.Form #Region " Code généré par le Concepteur Windows Form " Private DAProduits As New OleDb.OleDbDataAdapter Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim cmdBuilder As New OleDb.OleDbCommandBuilder(DAProduits) With DAProduits .SelectCommand = New OleDb.OleDbCommand("SELECT num,libellé FROM Produits", OleDbConnection1) .FillSchema(Me.DsProduits1, SchemaType.Source) '.FillSchema(Me.DsProduits1, SchemaType.Mapped) 'Fonctionne aussi .InsertCommand = cmdBuilder.GetInsertCommand() '(1) With Me.DsProduits1.Tables("Produits").Columns("Num") If .AutoIncrement Then .AutoIncrementSeed = -1 'Ne marche pas s'il est placé après le DAProduits.Fill(...) .AutoIncrementStep = -1 End If End With .Fill(Me.DsProduits1, "Produits") End With Grid.DataSource = Me.DsProduits1.Tables("Produits") End Sub Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click 'Ajout depuis un bouton (pour le code) 'Pas nécessaire car ça fonctionne aussi de manière classique, sans bouton "Add" Dim row As DataRow With Me.DsProduits1.Tables(0) row = .NewRow row("Libellé") = "Nouveau produit" .Rows.Add(row) .AcceptChanges() End With End Sub Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click If DsProduits1.Tables("Produits").Columns("num").AutoIncrement Then Try AddHandler DAProduits.RowUpdated, New OleDb.OleDbRowUpdatedEventHandler(AddressOf OnRowUpdated) DAProduits.Update(DsProduits1, "Produits") Finally RemoveHandler DAProduits.RowUpdated, AddressOf OnRowUpdated End Try Else DAProduits.Update(DsProduits1, "Produits") End If End Sub Private Shared Sub OnRowUpdated(ByVal sender As Object, ByVal e As OleDb.OleDbRowUpdatedEventArgs) Dim idCMD As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT @@IDENTITY", e.Command.Connection) 'Si le nom du champ AutoIncrement est nécessaire, une solution est de créer manuellement la requête SQL en (1) 'du DAProduits.InsertCommand en plaçant le champ AutoIncrement comme premier champ 'la ligne ci-dessous devient alors : e.Row(0) = CInt(idCMD.ExecuteScalar()) If e.Status = UpdateStatus.Continue AndAlso e.StatementType = StatementType.Insert Then e.Row("num") = CInt(idCMD.ExecuteScalar()) e.Row.AcceptChanges() End If End Sub End Class Tag: How to select distinct values Tag: 106547
  - 22
    - Error - No Value Given For One OR More required Parameters I have the following lines of VB.Net code. Its works if the HDR property is set to "No" but changing it to "Yes" generates the error "No Value Given For One OR More required Parameters". What am I missing? Dim sInsert, sSelect, sConn, sFile As String sFile = txtFileName.Text.Trim sInsert = "INSERT INTO [PassResults] (Model, Result, Operator) " sSelect = "SELECT F1, F2, F3 from [Excel 8.0;DATABASE=C:\PassResults.xls;HDR=Yes;IMEX=1].[Results$];" sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestResults.mdb" Dim AccessConn As New System.Data.OleDb.OleDbConnection(sConn) Try AccessConn.Open() Dim AccessCommand As New System.Data.OleDb.OleDbCommand(sInsert & sSelect, AccessConn) AccessCommand.ExecuteNonQuery() AccessConn.Close() Catch ex As Exception MessageBox.Show(ex.Message) Finally AccessConn.Close() End Try Tag: How to select distinct values Tag: 106538
  - 23
    - Selecting a Row in a DataTable Hi I'm very new to this so forgive me if I've made very amateur mistakes. I am writing a web page for work so that items in a database can be queried and then amended if required. I've written a function which returns a DataSet. I call this function from a sub procedure and assign the returned DataSet to a new dataset object (dsTable) with page level scope (dim at top of page). I then bind this data to a DataGrid control. All of this works fine. I then want to enter the row number of an item in the DataGrid and assign a new value to a column of the selected row. I'm doing this very simply by adding a text box for the user to enter the row number then to click a button to apply the changes. The button event calls the Preview sub and passes the row number. The way I expected this to work was private sub Preview(intLine as Integer) dim tSelect as DataTable tSelect = dsTable.Tables("Orders") tSelect.Rows(strLine).Item("Cost")=txtCos.Text '****Error here *** dgOrders.DataSource=dsTable dgOrders.DataBind() end sub However at the line of code I've highlighted I get an error saying "Object reference not set to an instance of an object." What does this mean. Any help would be greatly appreciated as it's driving me mad :o). Thanks Tag: How to select distinct values Tag: 106531
  - 24
    - datagrid rendering multiple tables I am building an online testing application that uses a usercontrol to navigate through a list of questions. The questions are multiple choice. I have a stored procedure that returns two tables: questions & answers. I have defined a relationship in code using a DataRelation. I would like to use a datagrid to display the questions and answers in order to take advantage of paging offered with the datagrid. Where I am having difficulty is determining how to have the datagrid list the question from one table and then the answers from the child table. Any suggestions? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: How to select distinct values Tag: 106529
  - 25
    - Multi-Database Transactions I've been looking into adding transaction capabilities into my object model framework. I always understood that, with SQL Server, a transaction could only cover one database, regardless of whether the transaction was done in a stored procedure or ADO ('classic ADO' or ADO.Net). But when I started reading in detail it got vague. For example, people were talking about data _sources_ instead of databases. So I did some testing and I can do a transaction in either SQL or ADO that successfully commits or rolls back updates to two databases. I'm using a single SQL Server 2000 Standard Edition with multiple databases on it and .Net 1.1. Before I get carried away, can anybody tell me the facts or point me to some definitive information about this, please? Thanks. Tag: How to select distinct values Tag: 106526
- Next
  - 1
    - Filter DataView for Duplicates? I have a DataTable with duplicates in a column. I would like to display only this column in a DataView, but remove any duplicates that exist. How can I do that? Thanks. Tag: How to select distinct values Tag: 106519
  - 2
    - use of SqlDataAdapter with a table without Primary Key Hi, I thought it isn't possible to use a SqlDataAdapter and a Databound grid when there isn't a 'real' primary key on the table. Although, is there a way to use it, and define somewhere in the SqlDataAdapter my own primary key on the table? I can't add a primary key to the table, so I guess that's the only way to find a solution? Any help would be really appreciated! Thans a lot in advance, Pieter Tag: How to select distinct values Tag: 106507
  - 3
    - Timeout at runtime but no timeout at design time in VS2003 Hi all, I have a timeout problem when retrieving data from my DB in a C# program. Everything is OK at design time : I can generate a Dataset and populate it with its data. Important note : the View1 is based on a UserDefined function returning a table variable, it takes 54 seconds to retrieve the data in SQL Analyser and approximatly the same in the VS designer. At runtime, this usual code crashes : ----------------------------------------------- sqlConnection1.Open(); try { sqlDataAdapter1.Fill(dataSet11); // crashes here. dataGrid1.DataSource = dataSet11; dataGrid1.DataSource = "View1"; } catch (Exception erreur) { MessageBox.Show(erreur.Message); } sqlConnection1.Close(); ----------------------------------------------- 1. How can the designer work differently ? 2. Where could I tell my connection to wait a longer time ? Thanks in advance, Patrice. Tag: How to select distinct values Tag: 106500
  - 4
    - re:creating a combobox column In my first post I tried to explain that I want to make a combobox column in a datagrid. But without having to buy a reference from a company I'm stuck! Did it make it a bit clearer? thanks! Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: How to select distinct values Tag: 106498
  - 5
    - I would like to insert a new column in DataTable at a specified position I would like to insert a new column in DataTable at a specified position, is it possible and how ? Thanks Tag: How to select distinct values Tag: 106492
  - 6
    - Timeout on Connection Pool I'm getting the following error message in an ASP.NET application: Time Expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I've read several KB articles on this and examined the server through the performance monitor while this error was occurring. SqlClient: _global_ Current # connection pools: 6 SqlClient: _global_ Current # pooled & nonpooled connections: 14 SqlClient: _global_ Current # pooled connections: 14 We do have six different apps running each with its own connection string. The connection strings contain only the server, database uid and pwd keywords. So I think I understand the Current # connection pools. What I do not understand is how I'm running out of connections when there is only 14 being used/pooled when the default is 100? What am I missing here? Also, as a side note, does anyone know what the "SqlClient: Total # failed commands" represents? This number was in the thousands on the performance monitor but I cannot see anything in our log file. We do capture and log every failed execution for review and there was nothing reported. Thanks in advance. Steve Tag: How to select distinct values Tag: 106490
  - 7
    - How can I combine crystal reports into one? (Type your message here) -------------------------------- From: Wu Jerry Basically, I use dataset as the datasource of the report and the= report takes in some parameters, too=2E The primary purpose of my= report is to display the profile of the employee=2E In order to= display multiple records, I have created a number of these= reports and each with its own dataset and parameters=2E I would= like to know if I can combine these reports into one so that I= can make good use of some features of the crystal report= viewer=2E(e=2Eg=2E printing, export to pdf) p=2Es=2E Right now, when I am using the printing and export to pdf= function, I can only get one record done at a time instead of= the records I want=2E ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>bABLM3HYNE2FatekpPxAYg=3D=3D</Id> Tag: How to select distinct values Tag: 106482
  - 8
    - Problem installing MSDE 2000 Hi, I've tried to install MSDE 2000 but without success. At first i got an error message about missing SAPWD. After i got some guidance (thanks to Peter) I defined a new administrator account under the name "NetSDK" , and add it a password (my previous account did not contain a password). Then i run from the command line the following command : SETUP.EXE INSTANCENAME="NetSDK" SAPWD="myPassword" . At first it seemed like I'm on the right way since I passed the first step which at the beginning required the SAPWD, but then a small window of "configures Microsoft SQL Server Desktop Engine ... " opened and a time remaining clock start count toward 0. When it gets to 4 seconds remaining it stucks, reinstall everything and aborted the installation. I have no id what's the reason for that but i tried several times and i got the same unwanted result each time. If anyone knows the reason or has any idea for solving this matter I will be grateful. Thanks, Gal. Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: How to select distinct values Tag: 106473
  - 9
    - Ups... just realised this is probably posted in the wrong forum (even though I'm retrieving data from MS Access to fill my datagrid...) I'll try to move the post But feel free to answer anyways :D Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: How to select distinct values Tag: 106472
  - 10
    - "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." I am recieving the above error when attempt to access a remote sql server database 2000 (sp3a) from ADO.Net. The database is on a windows 2003 machine and the ado.net code (web services) are on another winsdows 2003 machine in the same domain. I have configure the DTC to allow transactions and followed the resolution in the following KB but I am still getting the error. http://support.microsoft.com/?kbid=834849 Anyone got any ideas? Cheers Ollie Riches http://www.phoneanalyser.net Disclaimer: Opinions expressed in this forum are my own, and not representative of my employer. I do not answer questions on behalf of my employer. I'm just a programmer helping programmers. Tag: How to select distinct values Tag: 106461
  - 11
    - OleDbType for SQL Server Text? I have a column in a SQL Server 2000 table that is of type Text. That is so I can put an unlimited-size string inside that column. I am using the OleDb connector to put data in there, my pseudo code looks ike this: "@myparamname" , OleDbType.LongVarChar , 819200 , ParameterDirection.Input But text seems to be truncated after about 1000 characters. What is the OleDb type I should use when I want to insert say a 40k piece of text? Thanks. Tag: How to select distinct values Tag: 106456
  - 12
    - concurrencymanager refresh slow on first record I have the following situation. I have a datagrid bound to an arraylist. Initially, the arraylist is empty. When the user adds an item, the item is added to the arraylist and then the datagrid is updated by getting the currencymanager and calling its refresh method. For reasons I won't go into here, at this point in time the datagrid is simply for display purposes. The problem is, there is a second or two delay from when the refresh method is called and it returns but only on the first record. After the first record is put into the arraylist, any subsequent additions to the arraylist and calls to the currencymanager refresh method are almost instantaneous. Anyone run into this issue and/or know how to work around it? Thanks! -- -------------------------------------------------- Christopher C. Bernholt I.T. Research & Development .NET Re-Engineering Team R & L Carriers, Inc. http://www.gorlc.com -------------------------------------------------- Tag: How to select distinct values Tag: 106450
  - 13
    - Speed problems when accessing large MS Access database I?m doing some work on a project which involves accessing a large= Access database (about 850Mb) The problem is when I?m doing an update/insert into the database= the oleDbCommand=2EexecuteNonQuery() method seems to return before= Access has committed the change ? This means that a display I= have on screen which reads back what has just been ?inserted?= doesn?t work correctly=2E At first the problem was only intermittent but as the database= has grown it seems to happen all the time=2E It does work okay if= I step through the program in Visual Studio (thus introducing an= artificial delay)=2E Does anyone know a way around this? Someway= for the code to block until the operation has been committed? I= can?t seem to find info about this online=2E If I make the thread= sleep for 500 MS after performing the insert it's okay as well?= Is there a connection string parameter or something I can use?= Our customer wants to stick with MS Access for now although they= want to upgrade to SQL Server later=2E Thanks=2E Patrick=2E -------------------------------- From: Patrick Fryer ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>sOaUoMftzE+yoWng0QzNyg=3D=3D</Id> Tag: How to select distinct values Tag: 106442
  - 14
    - Oracle Connectivity/Windows Service We have a windows service written in VB.NET. This service is used to trigger applications. The functionality of the service can be briefly explained as 1. The Service accesses the Oracle database. 2. Checks the status of certain table entries. 3. Depending on the table entries processes are triggered. 4. The Service is a perpeterating one with a periodicity of 2 minutes. Issue: 1. The service is installed and is started. It is functioning as expected. Now the Database is brought down (say for backup) and is brought up again. When the Database is brought down the service is not able to access the database which is expected. Now when the database is brought up the service still persists with the error. ERROR from the service: -------------------------------- ERROR MESSAGE : ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory -------------------------------- A manual restart of the service is required to make the service functional again. Software Details ------- Oracle Version : Oracle 9i Enterprise Edition, Release 9.2.0.4.0 .NET Framework: Microsoft .NET 2003, v1.1.4322 ------ The service works well on Windows 2003 server but this issue comes in Windows 2000 server SP4. Any inputs on this will be of help -------------------------------- From: Karthikeyan Raghuraman ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>o7P+hRe3/0WrQ0UqB79M1A==</Id> Tag: How to select distinct values Tag: 106441
  - 15
    - Add a record directly to a table (Type your message here) Hi All, I am new to VB Dot Net, coming straght from VB6=2E I have tried and= failed trying to add a record to a table directly from a Data= Entry Screen=2E From reading ref=2Ebooks, it seems that I have to= create a DataSet, populate it,then use that to update the table=2E= I am utterly confused=2E Any suggestions or advices to point me= in the right direction are most welcome and appreciated=2E= Thanks=2E -------------------------------- From: Lennie Kuah ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>hMQj/rC4yEGoijx/0C8WmA=3D=3D</Id> Tag: How to select distinct values Tag: 106439
  - 16
    - Problem in search function! Hi, i have a search function on my page. first i allow user to select from the dropdown a price.On btn_click i estalish Sql Connection..then ..creat command..and then creat dataview. dv.RowFilter = "Price=here i want to have the selected value" from the dropdown i have named DropDown as ddlComnapy...so my code looks like.. dv.RowFilter = "Price=ddlCompany.SelectedValue" but on running the program it says:System.Data.EvaluateException: Cannot find column ddlcompany.SelectedValue but if i hardcode a value ,then the code works perfectly fine. CAN SOME BODY PLEASE POINT OUT WHERE I AM GOING WRONG .NET ROCKS! Aal -------------------------------- From: Aal D ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>bpTi2sC0OE2D6LdXZs+/XA==</Id> Tag: How to select distinct values Tag: 106437
  - 17
    - crystal report (Type your message here) i am workin on crystal report i hav created a dataset i want columnname in report as that of one of field of dataset ie my dataset contains fields city,department,amount i want records to b dispalyed as delhi mumbai pune banglore admin 100 100 1000 10000 marketing 1000 1000 1000 10000 these citynameand departnment name is comming from database i am stuck here and will be very gr8ful if u can help me -------------------------------- From: pearl 123 ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>wzoF1UvGsUWz1gntDrJDGQ==</Id> Tag: How to select distinct values Tag: 106436
  - 18
    - Bucket Data Columns What are "bucket" DataColumns that I see in my DataTable.Columns DT.Columns.columnFromName I can see several entries in the quickwatch like follows... Name Value buckets[45] {key={System.Array} val = <undefined value>} I belive these bucket columns are preventing me from doing a DataTable.Select() call so I can sort the datatable. Tag: How to select distinct values Tag: 106431
  - 19
    - any info on how to use mysql with .NET ? Hi I'm trying to use MySql with .NET. Has anyone done this? where is a good place to look for how to do this? Thanks much Dee Tag: How to select distinct values Tag: 106426
  - 20
    - DatagridView and DateTime ... How to set DataGridView column property to display only time part of System.DateTime value type? For example - whem I have DateTimePicker, I can set format to custom HH:mm and everything is allright... Is any simple solution to do the same with DataGridView column property ?? Tag: How to select distinct values Tag: 106421
  - 21
    - DatagridView and DateTime ... How to set DataGridView column property to display only time part of System.DateTime value type? For example - whem I have DateTimePicker, I can set format to custom HH:mm and everything is allright... Is any simple solution to do the same with DataGridView column property ?? Tag: How to select distinct values Tag: 106420
  - 22
    - DatagridView and DateTime ... How to set DataGridView column property to display only time part of System.DateTime value type? For example - whem I have DateTimePicker, I can set format to custom HH:mm and everything is allright... Is any simple solution to do the same with DataGridView column property ?? Tag: How to select distinct values Tag: 106419
  - 23
    - Oracle Int/Decimal problem Using OracleDataAdapter we have a problem with integers. The following table can be used as an example: CREATE TABLE tCmpCommunic ( nCommunicKey INTEGER NOT NULL, nPartyKey INTEGER NULL, nContactMechanismType INTEGER NOT NULL, nGeoKey INTEGER NULL, sAddress NVARCHAR2(1000) NULL, sComment NVARCHAR2(100) NULL, nComViaGeoKey INTEGER NULL, bMainContact SMALLINT NULL ); For some reason, the integer-columns are returned as decimals when using the Fill-method on the dataadapter. Has anyone seen this before? Are there something we are missing? Thanks in advance Egil Winther ShipNet AS Tag: How to select distinct values Tag: 106418
  - 24
    - Insert Records from a DataSet to MS Access 2000 I have the following VB.Net code to read an Excel file and it works fine. How do I take these records and insert into an Access 2000 database table? gsDBName = "MyFile.xls" gsProvider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gsDBName & "; Extended Properties=Excel 4.0;" sConn = New System.Data.OleDb.OleDbConnection(gsProvider) goDA = New System.Data.OleDb.OleDbDataAdapter(sExcelQuery, sConn) goDS = New System.Data.DataSet Try goDA.Fill(goDS) Catch ex As Exception MsgBox(Err.Source & vbCr & Err.Description) End Try dgExcel.DataSource = goDS Tag: How to select distinct values Tag: 106413
  - 25
    - Jet 4.0, ISAM and Excel Hi, when I read an excel column containing numbers with Jet 4.0, and fill a = dataset, I obtain a "System.Double" datatype. I would prefer to have a = System.Integer value, to fill a sql database column... Some ideas ? Oriane Tag: How to select distinct values Tag: 106405

I have a DataSet filled from a previous query to the database. I need to
get the distinct values from a field in the DataSet. Is there a way to
acheive this without going through the DataTable or by hitting again the
database?

TIA

Top

Re: How to select distinct values by Patrice

Patrice
Wed Mar 09 10:04:57 CST 2005

How could it find without doing one or the other ? My personal preference
would be to select this server side (I would say generally this is because
you want a codification table you could select at the same time resulting in
filling two tables instead of a single table in yur dataset).

If you prefer the other way :
http://support.microsoft.com/default.aspx?scid=kb;en-us;326176

Patrice

--

"Sylvain Larin" <slarin@NOSPAM_gmail.com> a écrit dans le message de
news:O5MhqxLJFHA.3916@TK2MSFTNGP14.phx.gbl...
> I have a DataSet filled from a previous query to the database. I need to
> get the distinct values from a field in the DataSet. Is there a way to
> acheive this without going through the DataTable or by hitting again the
> database?
>
> TIA

Top

Re: How to select distinct values by Robert

Robert
Wed Mar 09 11:15:26 CST 2005

I used the described method by Microsoft...DataSetHelper Class.
Worked fine.

--
Message posted via http://www.dotnetmonster.com

Top