Filter 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
    - No cursor when compared with ADO After a dataset has been populated, it no longer reflects changes in database. It is the shortcoming I found in ADO.NET. In ADO, we have dynamic recordset, keyset recordset which can reflect the changes to database done by other users immediately. Why can't I find these useful stuff in ADO.NET? Tag: Filter Dataset Tag: 107961
  - 2
    - Memory leak in OleDbCommand.ExecuteNonQuery()? Maybe there's something I'm doing wrong here. I'm open to any suggestions. I'll see if I can explain this clearly... I have a C# application that runs 24x7 collecting data from some source and storing the data in a Microsoft Access database. The problem is, every time it stores the data using a call to OleDbCommand.ExecuteNonQuery(), the applications memory usage grows. After a few days, the application has consumed most of the systems' virtual memory and grows more and more sluggish and unresponsive. The only solution right now is to restart the application every couple of days. Since the app uses one database and stores the same database fields with only the data changing, I set up everything at the start of the program. After that, as data comes in, only the stored data parameter values change. The first thing I do is open the MS Access database using an OleDbConnection with a Microsoft.Jet.OLEDB.4.0 provider. I then create a OleDbCommand with a command string that basically consists of "INSERT INTO table (field1, field2...) VALUES (?,?...)". Next I use OleDbCommand.Parameters.Add to add OleDbParameter data parameters that correspond to each field to the OleDbCommand, with the proper datatype for each field. Lastly I set the OleDbConnection in the OleDbCommand. As the data is collected I go through each OleDbParameter and set its Value to either the data collected or DBNull.Value if the data is missing. Then I call OleDbCommand.ExecuteNonQuery to actually store the data. That occurs successfully, but the virtual memory alllocation goes up and up each time the data is stored. I monitor the memory usage with Sysinternals ProcExp, and if I comment out the call to actually store the data, the memory usage remains constant. So am I doing something wrong, or is there a memory leak in OleDbCommand.ExecuteNonQuery? Tag: Filter Dataset Tag: 107957
  - 3
    - SQLConnection connection pool issue I have a similar problem to several other people who have posted= here - I can only open up to <Max Pool Size> connections=2E After= that I get a timeout expired exception=2E Looking at the open / pooled connections in perfmon (in both SQL= Server stats, and the CLR runtime), there are never more than 5= / 6 connections open, but without fail, I cannot open more than= <Max Pool Size> connections, even when I change this value or= don't specify it=2E I have already tried several suggested solutions - disabling SQL= Server debugging in VS=2Enet, running in release mode, connecting= to several other databases on several other computers, but= nothing seems to have any effect=2E I have gone through the code= with a fine tooth-comb, and put "open connection" counters into= my database class (all the connections are opened and closed by= a single pair of shared functions - and yes, the connection= object is passed by ref=2E), and ensured that the connections are= actually reporting they are closed (via SqlConnection=2EState)= both inside and outside the function that closes them=2E I'm all out of ideas now=2E Any suggestions would be greatly= appreciated=2E -------------------------------- From: Rory Smith ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>gdTZqEcYx0eoUbAQReEUNQ=3D=3D</Id> Tag: Filter Dataset Tag: 107956
  - 4
    - XML Schema (XSD) and ADO.net DataSet - limitations mapping between them The following valid XSD schema can NOT be successfully read by the ReadXMLSchema method of the DataSet object - it errors out with a "NonEmptyString not defined" error. This schema is more complex than a plain vanilla schema, but doesn't strike me as obscenely complex. Are there general rules for what can an can not be mapped between any XSD schema & a .net DataSet? Thanks <?xml version="1.0" encoding="UTF-8" standalone="yes"?> -- edited with XMLSpy v2005 rel. 3 U (http://www.altova.com) by Wheels Inc (Wheels Inc) -->  <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="CollisionTemplateA1"> <xs:complexType> <xs:sequence> <xs:element ref="FullName"/> <xs:element ref="Hometown"/> <xs:element ref="Province"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="FullName"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" fixed="/LR/Deeper/IsDriverInsane"/> <xs:attribute name="conditional" fixed="yes"/> <xs:attribute name="source1" fixed="/LR/Deeper/Name"/> <xs:attribute name="source2" fixed="/LR/Name"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:element name="Hometown"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" type="xs:string" fixed="/LR/City"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:element name="Province"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" type="xs:string" fixed="/LR/State"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:simpleType name="NonEmptyString"> <xs:restriction base="xs:string"> <xs:minLength value="1"/> </xs:restriction> </xs:simpleType> </xs:schema> Tag: Filter Dataset Tag: 107953
  - 5
    - Extracting enum from table Hi, I'm reading the result of a query using MySqlDataReader. I'd like to extract information about the row datatypes that are returned. For example, myDataReader.GetFieldType(1).TosTring() will easily return values such as "System.UInt32" or "System.Byte". My problem is that i'd like to retrieve information about enum types. My datatype in the MySQL db is defined as: ENUM('red','blue','orange') but the above code will return "System.String". I'm interested in retrieving something that will give me all valid input types for an enum field in the database. I've also tried looking at the System.Data.DataTable object but didn't find any clues on how to solve this. Any help is greatly appreciated. -------------------------------- From: Morten Skov ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>ltesbJ0arEScu0cv8VUUKQ==</Id> Tag: Filter Dataset Tag: 107952
  - 6
    - Broken Web Links Within Microsoft Access I have built a database in Microsoft Access 2003 that has a number of links that go out to the web. Does anyone know of a way I could set up my database to check which links are active and which ones are inactive? Because the links are added and removed, I would need to run this once a day, so any automation would be nice. While researching this, I came across (is broken) and (ConectionState) am I on the right track. Thank you for any help Corey -- Message posted via http://www.dotnetmonster.com Tag: Filter Dataset Tag: 107951
  - 7
    - Dataset: expression columns recalculation Hi there I'm having a typed dataset, where a datatable has some columns which are expressions. After doing a Merge, i was expected that my expression columns were calculated, but they were not. Although, if i do this foreach(System.Data.DataColumn column in dataset.myDataTable.Columns) { if (column.Expression!=null && column.Expression.Length>0) column.Expression =column.Expression; } they are calculated... is this by design ? thanks! www.dotnetx.org Tag: Filter Dataset Tag: 107949
  - 8
    - C# and ADO.Net - Cheap Question! Hi, I'd like to INSERT a string into a database using C#. The way I've tried it is the following: sQuery = string.Format("INSERT INTO myTable (Header, Body) VALUES ('{0}','{1}')", sHeader, sBody); It works fine until I have an occurence of ' (an apostrophy) in either the string-variables sHeader or sBody. How can I circumvent this? Thanks in advance! -- /Matthias Tag: Filter Dataset Tag: 107932
  - 9
    - Problem with RowChanged event and bindingcontext Hello all, IÂ´m experiencing a problem ( maybe a bug ...), with the rowchanged event. When i change the position in a table after alter a field the datarowchanged event starts only if the navigation path of the databinding is not a relationship: Ej... ds.Tables["house"].RowChanged +=...; texto.DataBindings.Add("Text", "house.doors"); this.BindingContext(ds,"house").Position++; in this case the event starts correctly Ej... ds.Tables["requirements"]..RowChanged +=...; // requirements is the relations between "house" and "requirements" tables texto.DataBindings.Add("Text", "house.requirements.pay"); this.BindingContext(ds,"house").Position++; in this case the event doesnt starts, but the DataRow of the relation table is altered. Does anyone know something about this? is a bug? it is its normal way of working? Greetings and excuse my poor english Tag: Filter Dataset Tag: 107927
  - 10
    - sqlcommand parameters with null Is there an easier \ shorter way of doing this? If txtreason.Text = "" Then NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value = vbNull Else NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value = txtreason.Text End If thanks gv Tag: Filter Dataset Tag: 107926
  - 11
    - Strange slow down with imbricated DataReader (Oracle, c#) This is my first c# windows app. I create a data reader on an Oracle table. Returns 552 rows. I iterate thru them, goes like light speed. Next, for each row returned, I need to fetch from another table to get some other information. When I do that, my program takes 20s instead of 1s. I even downgraded my inner SQL to become "select 1 from dual", same performance hit! Is there a problem with Oracle under c# using two DataReader at the same time? Here's the code: con = new System.Data.OracleClient.OracleConnection(); con.ConnectionString = "user id=xx;data source=xx;password=xx"; public void Process(ProgressBar progBar) { OracleDataReader dr; OracleCommand cmd; dr = GetMainDR() while (dr.Read()) { // get some columns ... cmd = new OracleCommand("select 1 from dual", con); Decimal i = (Decimal) cmd.ExecuteScalar(); <----- slows down everything cmd.Dispose(); ... } } public OracleDataReader GetMainDR() { OracleDataReader dr; OracleCommand cmd; cmd = new OracleCommand("select * from TABLE_OF_552_ROWS", con); // change dr = cmd.ExecuteReader(); return dr; } Tag: Filter Dataset Tag: 107924
  - 12
    - first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Hi all, I thought I would help out on a Error that comes up for a lot of people when calling a stored procedure from your application using sqlcommand object and passing parameters. this error comes up in VB.NET "first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll" this took me awhile but figured it out. Make sure in the stored procedure you declare the variable like this for variables that might not have any data: Make it equal nothing or null @mainnotes TEXT = '', or @mainnotes TEXT = null This fixed my problem, and I'm sure there are more solutions but, I hope this helps. The error could also come up if SQL permissions are not correct. Gerry Tag: Filter Dataset Tag: 107923
  - 13
    - Architecture: One Producer, Many Consumers Hi all, This sounded like a really easy R&D challenge but .NET is leaving me with too many options and I don't have six months to experiment and find the best one. Hence I would like to lean on this board's expertise. Environment is C#/.NET/SQLServer2k/VisStudio .NET. I have several remote applications that are delivering data to a central server. This server process is archiving the data in an SQL 2000 db. Now I also have one to about a dozen fixed clients on a WAN, which need to be notified when a change takes place to the central database so they can update their UI to reflect the changes. What is everyone's suggestion for doing this? Any resources out there you can point me at? I've run the gamut from remoting, to serialising the DataSets (which scares me due to the amount of data that may start going over the channel), to considering whether the remote clients should be writing directly to the db (although bandwidth limitations tend to prohibit TCP-like connections), to wondering why there doesn't seem to be any way for a client to simply connect to an SQL database and be told when changes occur... and so on. Is there something I've missed? This seems like a straightforward client-server requirement. Any help gratefully appreciated, and thanks in advance. Neil B Tag: Filter Dataset Tag: 107919
  - 14
    - Trouble with creating DataRelations - Need Help I am building an App that takes an Excel file and populates 3 DataTable's in a Dataset. I then was to create a relationship between these 3 DataTables. After dong so I want to run some code to process / modify the data in the tables and then return the result back into an Excel file. I am a beginner at VB and i chose this as a starter project. I get the following exception when i try to create the DataRelation: An unhandled exception of type 'System.ArgumentNullException' occurred in system.data.dll Additional information: 'column' argument cannot be null. Am i coding this correctly? When i run the fill command, will the table automatically pick the column header and other schema info? Once this is done I would like to create some DataRelationships between the three tables. Will there be an error because the table schema was not detected? I am curious about the concepts themselves rather than my code. I have already tried to read up on all the info online, but nothing addresses my situation. Listed below is the code I have. All help would be appreciated Thank You Private Sub cbConvert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbConvert.Click 'Convert button click event Dim filename As String filename = tbInputFileBrowser.Text() Dim XLFileConn As New OleDbConnection XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & _ ";Extended Properties=""Excel 8.0;HDR=YES""" Try XLFileConn.Open() Dim XLFileCmd1 As New OleDbCommand XLFileCmd1.Connection = XLFileConn Dim XLFileDA As OleDbDataAdapter = New OleDbDataAdapter XLFileDA.SelectCommand = XLFileCmd1 Dim XLFileMainDS = New DataSet("MainDataSet") Dim TableMain As DataTable = XLFileMainDS.Tables.Add("TableWithMain") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify <> 'TC' OR '26'" XLFileDA.Fill(XLFileMainDS, "Sheet1") Dim TableTC As DataTable = XLFileMainDS.Tables.Add("TableWithModTC") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify = 'TC'" XLFileDA.Fill(XLFileMainDS, "Sheet1") Dim Table26 As DataTable = XLFileMainDS.Tables.Add("TableWithMod26") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify = '26'" XLFileDA.Fill(XLFileMainDS, "Sheet1") 'XLFileDA.FillSchema(XLFileMainDS, SchemaType.Source, "Sheet1$") Dim ParentCol As DataColumn Dim Child1Col As DataColumn Dim Child2Col As DataColumn ParentCol = XLFileMainDS.Tables("TableWithMain").Columns("Proc Code") Child1Col = XLFileMainDS.Tables("TableWithModTC").Columns("Proc Code") Child2Col = XLFileMainDS.Tables("TableWithMod26").Columns("Proc Code") Dim RelProcCode As DataRelation Dim RelProcCode1 As DataRelation RelProcCode = New DataRelation("ProcCodeTC", ParentCol, Child1Col) 'Get an Exception Here RelProcCode1 = New DataRelation("ProcCode26", ParentCol, Child2Col) 'Add the relation to the DataSet. XLFileMainDS.Relations.Add(RelProcCode) XLFileMainDS.Relations.Add(RelProcCode1) Finally XLFileConn.Close() End Try Tag: Filter Dataset Tag: 107916
  - 15
    - DataTable.Row[i].EndEdit() Hi, How can I know which row is currently being editing when I have some controls bound to a DataSet.DataTable in order to call the EndEdit method prior to update data to the database? Is there any CurrentRecord indexer? When I call Rows.Add metod, the row I am adding will be put at the end? Sorry for these stupid questions but I am newer on .net and ado. Thanks Antonio Tag: Filter Dataset Tag: 107915
  - 16
    - Decimals truncated in dataset I'm airly new to .net and I can't seem to figure out this problem, I hope you can help... I'm filling a dataset from an Access database with columns of type = Decimal. When I load a datagrid with the dataset, the numbers are truncated, i.e. in Access I see 0.87224505043, in my datagrid i see 0. Why is this happening? Tag: Filter Dataset Tag: 107914
  - 17
    - closing connection not by design Hi, i wanted to get this groups opinions on a design issue ive run into: a programmer has coded a common data access class which is supposed to be inherited by all data access layers at my firm. This class instantiates a connection in the constructor, relies heavily on OleDb objects by necessity, and does stuff like returns DataReaders and creates DataSets and Command objects. Before using this class i looked thru the methods and noticed that there is no exception handling, so whenever error occurs, open connections and OleDb DataReaders and command objects never get closed/disposed. Being a helpful fool, i suggested to this programmer that it would be good idea to ensure that these methods clean up unmanaged resources that they create per best practice. The response i got is that "you dont understand the design", this decision was intentional... all code that calls this classes methods must write their own code to cleanup these resources in event of an error. He did not want to "restrict users of the class from flexibility in how they handle errors". Given that: 1. No other programmers who use this class were aware of this necessity 2. the programmer who wrote this class himself never checks for errors from code that calls these methods 3. its not possible for others to cleanup resources created within those methods 4. you can still pass exceptions to the caller and still dispose resources you create. 5. there are numerous problems with applications in production which use this data access class. my impression is that instead of accepting that a (fairly common) mistake/oversight was made and quickly taking basic steps to correct it, this programmer has decided to defend the indefensible. What do you think? Premier JiangZemin Tag: Filter Dataset Tag: 107901
  - 18
    - Vb.net ADO connecting SQL Server and Paradox table to create a query. All, I want to run a query in my vb.net application that will join a table in Paradox and a SQL Server table? The paradox table will be dynamic, meaning based on user input I may point to different folders but same file to get data. Thanks, Roger Tag: Filter Dataset Tag: 107900
  - 19
    - How does ADO.NET handle transactions when the connection is broken Hi, We are thinking of using ADO.NET to implement transactions on our SqlConnections, but would like to know how ADO.NET and SqlServer handle the situation when the connection gets broken. We have a client application in one location and a SqlServer DB in another location. We have tested the commit and rollback actions on a good connection and everything works great! When the connection gets dropped after the BeginTransaction method gets called however SqlServer seems to take a while before realising the connection has been dropped and rolling back the transaction (5 minutes). This means that the records updated inside the transaction before the connection was dropped remain locked for 5 minutes before being rolled back. Is there any way we can configure or control the timeout period? Here is a basic code snippet: try { db.OpenConnectionAndBeginTransaction(); db.ExecuteSomeSQL(); db.CommitTransaction(); } catch(Exception) { db.RollbackTransaction(); throw; } Any help would be greatly appreciated. Thanks, Rob Tag: Filter Dataset Tag: 107889
  - 20
    - REGISTERED AND CRACKED CAD/CAM/CAE SOFTWARES 2005! Hello architectural, engineer and technical users! We can offer you new regi stered CAD/CAM/CAE softwares: Survey , GIS , Rock , Soil and Water, Industri al and Control Project, Mathematics , Statistics and Accounting, Engineering and Technical Standards and Databank Such as ISO , DIN , BSI ,ASME , ASTM a nd etc. This softwares we can obtain for you with CDs or DVDs. Sorry for not downloa d available. May be in future it will be possible if we will have more secur y server. Our principle of work is next: 1.You order from us some softwares. In 1-2 days we inform you the cost of y our order, including price of delivery. 2.Usually by delivery we use TNT, DHL, UPS mail services. But for security of delivery and for quaranties for you and for us we often use TNT mail serv ice. We have agreement with them and they have become the intermediary of ou r deals. They controls the payment from you and delivery from us. By any rea sons If you will not receive packages or will disagree with contents you wil l be full refund. 3.All transactions would under control by TNT. But if you will be agreed to do deal thru TNT, price of you order will increase to 30%. 4.For every next order from you we will give you good discounts. It is a general think – secury and guaranties of parties of deal in in ternet. My e-mail: cadsoftwares@europe.com Now we can offer you some positions of our list softwares: Registered softwares by cadsoftwares@europe.com ==================== CAE & FEA Softwares ==================== AEA.Technology.HyproTech.DISTIL.v5.0 AEA.Technology.HyproTech.HX-Net.v5.0.1 AEA.TECHNOLOGY.HYPROTECH.HYSYS.V3.1 ALGOR softwares ALTAIR softwares AMESim.v4.0 for WinNT/2000/XP Amtec.Tecplot.v10.0 ANSA_V11.2 ANSYS softwares Ansys.ParaMesh v2.2 ANSYS.WORKBENCH.SUITE.V8.0 Applied.Flow.Technology.softwares Artas.SAM.v5.0.192 aspen.content.development.server.v7 AspenTech.softwares Autoform V2.1 AUTOMATION_STUDIO_V5.0_PRO AVL.FIRE.V8.2 AVL.SWIFT.V3.1.1 AVL.Workspace.Suite.v3.1.1 AVS/Express V6.0 CADFIX V5.2 CADFIX_V5.2 FOR LINUX CADISON PIPES V4.12 Cadpipe.2002.3D.Design.v7.0.for.AutoCAD Cadpipe.2002.Building.Services.v7.0.for.AutoCAD Cadpipe.2002.Commercial.PIPE.v7.0.for.AutoCAD Cadpipe.2002.HVAC.v7.0.for.AutoCAD CADPIPE.2002.Industrial_v6.6.for.AutoCAD Cadpipe.2002.ISO.v7.0.for.AutoCAD Cadpipe.2002.Ortho.v7.0.for.AutoCAD Cadpipe.2002.PID.v7.0.for.AutoCAD CAE.PowerTools.FEvis.Publisher.v1.0.0.28 CAEFEM.v8.12 CD.adapco.Star-CD.v3.150A.FOR.LINUX CD.adapco.Star-CD.v3.150A.FOR.WIN2000 CFD softwares CFDESIGN.V6.0 CFDlab.v2.2 CFDRC.V2003 CFX.softwares Chemical & Process Simulation Softwares CHEMPOINT.PROFESSIONAL.V6.0.ANSI CHEMPOINT.PROFESSIONAL.V6.0.UNICODE ChemPoint.v4.0 CHEMSTAT.V4.1.ANSI CHEMSTAT.V4.1.UNICODE ChemStations.ChemCAD.v5.2.Pro Citect v5.40 CITECT.SCADA.V5.42 Coretechnologie.3D.Evolution.v1.0 DDS.FEMTools.v2.1 Deform.2D V8.0 Deform.3D V5.0 Dlubal.RFEM.v1.12 DYNASIM.DYMOLA.V5.0A EDS.FEMAP.V8.3 EDSL.Tas v8.5 EDSL.Tas.v8.5 ENGINE.ANALYZER.PRO.v3.3 Engineous.Software.iSIGHT.v8.0 EPCON_API_TECH_DATABASE_v3.0 EPCON_CHEMPRO_v6.31 EPCON_ENVIRON_v2.0 EPCON_SINET_v6.11 EPLAN_PROFESSIONAL_V5.5 ESI.PAM-STAMP.2G.V2003 for AIX Expertsoft.PiSystems.XTE.v6.2.1.17 FEACrack v1.1.020 Fedem.Simulation.Software.v3.1 FE-DESIGN_TOSCA_VM_V4.51 FemScope.ED-Elas2D_v2.20.1 FET.Lisa.v4.0.0 FIRE_v6.0 Flexsim 4.0 FLOMERICS_FLOTHERM_V4.1 FLOWPHASE.POWER.SUITE.V1.02 FLOWSCIENCE.FLOW.3D.V8.1 Fluent PakSi-TM v1.4.7 FLUENT Post 1.2.6 FLUENT V4.5.6 [2CD] Fluent.Airpak v2.0.6 Fluent.Fidap.v8.7.2.FOR.LiNUX FLUENT.FIDAP.v8.7.2.FOR.WINDOWS FLUENT.GAMBIT V2.1.6 FOR LINUX FLUENT.GAMBIT V2.1.6 FOR WINDOWS FLUENT.ICEPAK.V4.0 FOR WINDOWS Gaussian.03.vB.02 Gaussian.03.vB.02.Linux GaussView.v3.0 GiD.Professional.v7.2 HAESTAD.METHODS.WATERCAD.V4.5 HKS.ABAQUS.V6.3-1 DOCUMENTATION HKS.ABAQUS.V6.3-1 for WINDOWS HKS.ABAQUS.V6.4-1 DOCUMENTATION HKS.ABAQUS.V6.4-1 for Linux HKS.ABAQUS.V6.4-1 for WINDOWS HSYM_v2.048 HyperChem.Professional.v7.02 ICEM.CFD.V4.2.FOR.LINUX ICEM.CFD.V4.3.1 Ilight Fieldview v9.1 for Linux Ilight Fieldview v9.1 for SOLARiS Ilight Fieldview v9.1 for Windows INFOLYTICA.MAGNET.V6.11.2 Intec.Simpack v8.6.07 for SOLARIS Intec.Simpack v8.6.07 for Windows IV>Reaction.Design.CHEMKIN.Collection.v3.7.1.for.Linux LMS.Falancs.v2.1 Ls-Dyna V960 LUSAS_FEA_V13.55 MI.NASTRAN V2.0 MSC softwares NAG.FASTFLO.V3.0 NCode.NSoft.v5.3.1 NE.NASTRAN V8.16 NI-488.2.V2.01 NUMECA.FINE.TURBO.DESIGN.3D.V6.13 for LiNUX NUMECA.FINE.TURBO.DESIGN.3D.V6.13 for Windows OidView.Professional.v2.1.74 PAM-Crash.v2001 PDESolutions.FlexPDE.v2.20e Perrys.Chemical.Engineers.Handbook PHOENICS 3.4 PhysProps.v1.6.1 PipeDrop.v1.2.3 PIPEFLOW.3D.V1.037 Pipeworks.v3.0 Piping.Systems.FluidFlow.v2.31 Pointwise.Gridgen.v15.0.LiNUX Pointwise.Gridgen.v15.0.Windows ProCAST.V3.2.0 for WinNT PROFILI_V2.13B Psim V4.1 QFin v2.1 QuikGrid.v4.5.WinAll RAHADNAK.AERODYNAMICS.TAERG.SI.HALLA.V5.1 RAMINT_RAM_ADVANSE_V5.1 Reaction.Design.CHEMKIN.Collection.v3.7.1.for.Windows Rebis AutoPlant v1.5 Rebis AutoPlant v2.01 REBIS.AUTOPIPE.V6.2.FOR.WINDOWS RICARDO_SOFTWARE_VALDYN_V2.8.1 RICARDO_SOFTWARE_WAVE_V5.1 SAFE.TECHNOLOGY.FE-SAFE.V5.0 Simaris deSign v1.30.26 SimSci.DataCon.v3.13 SimSci.HexTran.v8.11 SimSci.InPlant.v3.03 SIMSCI.PIPEPHASE.V8.1 SIMSCI.PRO.II.V6.0 SimSci.Process.Engineering.Suite.2002 SimSci.Visual.Flow.v4.1 Simulog.TetMesh-GHS3D.v3.1 SINAPSPLUS.v4.5 SINDA.FLUINT.v4.4L SINDA-FLUINT.V4.4.BUILT-IN.COMPILER SINDA-FLUINT.V4.4.FOR.COMPAQ.FORTRAN SINDA-FLUINT.V4.4.FOR.WATCOM.FORTRAN SRAC.COSMOS.DESIGNSTAR V4.0 SRAC.COSMOS.EDGE V4.1 SRAC.COSMOS.EMS V2003 SRAC.Cosmos.FloWorks.v2003 SRAC.Cosmos.M.V2003 SRAC.Cosmos.Motion.v2003 SRAC.COSMOS.Suite.V2003 SRAC.Cosmos.Works.v2003 SRAC_COSMOS_FLOWORKS_V2004_FOR_NT SRAC_COSMOS_FLOWORKS_V2004_FOR_WINME SRAC_COSMOS_M_V2.85 SRAC_COSMOS_MOTION_V2004_FOR_NT SRAC_COSMOS_MOTION_V2004_FOR_WINME SRAC_COSMOSWORKS_V2004_FOR_NT STAR.ANALYST.V5.1.0.3226 SuperPro.Designer v4.53 Tecnomatix.eM-Plant.v6.0.9 TECPLOT.V9.0 With CFD Analyzer 2.0 THERMAL.ANALYSIS.SYSTEM.V6.1 THERMAL.DESKTOP.V4.4.5.WITH.FLOCAD.AND.RADCAD THERMO.CALC.V2003P.for LiNUX THERMO.CALC.V2003P.for SGI THERMO.CALC.V2003P.for SOLARIS THERMO.CALC.V2003P.for Windows Ullmanns.Encyclopedia.Of.Industrial.Chemistry.2002.6th.Edition UTS.ADVANCED.SPRING.DESIGN.V6.0 VANDERPLAATS.GENESIS v6.0 VisSim.ECD.for.TI.C2000.v5.0f WATERCOM.DRAINS.v2004 WATERCOM.PIPES.PLUS.PLUS.V2003.7 WatPro.v2.30 wavefun.spartan.02.v1.0.1 wavefun.spartan.02.v1.0.2b WaveFun.Spartan.04.v2.0 WINSIM.DESIGN.II.FOR.WINDOWS.V9.0.5 XYZ.Scientific.Truegrid.v2.1 Contact with us thru e-mail: cadsoftwares@europe.com ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Filter Dataset Tag: 107888
  - 21
    - Datatable.Select method - Difference Between %AE% and *AE* Hi, Keyvalue :AETHAE Keyvalue : AETH The problem is that I am using the Datatable .select method and Filter expression is %AE%.This Pattern is searchs only mid string not with starting point. Output: AETHAE IF i use the *AE* , then searches from the starting point Output: AETHAE and AETH Pls. clarify... Thanks Palani Tag: Filter Dataset Tag: 107885
  - 22
    - How to synchronize Dataset to database In our project we fetched data into dataset from the database. Now we are storing the data in a XML File from the dataset. The modified DataSet is kept in the XML File And dataset is closed. Later at the time of saving we are building the dataset from the XML file and then want to save the dataset into database. We are not able to save the dataset being populated from an xml file into database. Kindly suggest a remedy for our problem Thanks in advance Regards Arnab Tag: Filter Dataset Tag: 107884
  - 23
    - DataSet and Table join Is there a way to join DataTables, kind of like how you do join in SQL? Tag: Filter Dataset Tag: 107878
  - 24
    - Having problem with SQLConnection.ChangeDatabase() method. I have multiple databases in which I want to traverse. Each database is secured using Applicaiton Roles. I use the SQLConnection object to connect to the first database. I run the sp_setapprole procedure and I can access the tables with no problem. However, when I try to call the ChangeDatabase method on my connection object, I get an exception thrown stating that my application role user is not a valid user in the database. If I connect to the same database using Open, it works fine. I don't quite understand what is going on here. Can anyone help? -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: Filter Dataset Tag: 107873
  - 25
    - DataTable Select method I want to know what kind of queries can i execute on datatable select method. The one i am interested in is between query for eg:- this is my sample query Select max(resultan) from TblseasResult Where SeasId='15.3.13.3302005' And Countno between 4801 and 4806 where Countno is numerical field now this is what i want to do DataTable1.select("Countno between 4801 and 4806") so it should return all the rows as Datarow array Thanks -------------------------------- From: Mandar Patankar MCP ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>yuriN1lzc0ydMcoRYJ+RYw==</Id> Tag: Filter Dataset Tag: 107871
- Next
  - 1
    - Problems inserting data into Access database Hi, I'm trying to insert new rows into a table in an Access database. Here's my code: Dim cn As OleDbConnection Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cn = New OleDbConnection(ConfigurationSettings.AppSettings("cnstr")) Dim TStart, TEnd As Date Dim duration As TimeSpan TStart = Now() Dim table as DataTable = GetData() TEnd = Now() duration = TEnd.Subtract(TStart) Label1.Text = tbl.Rows.Count Label2.Text = "Operation took " & Round(duration.TotalSeconds, 0) & " seconds to execute." End Sub Private Function GetData() As DataTable Dim AWS As New EEC.BookStore.Books() Dim tbl As DataTable = MakeTable() Dim books As EEC.BookResponse Dim i As Integer For i = 1 To 10 'would be to the max number of pages available 'Call the web service and format data as desired; this works Call Me.AddToTable(books)'custom function that adds rows to the table Next cn.Open() Call Me.SubmitInsertViaAdapter() cn.Close() AWS = Nothing Return tbl End Function Private Function MakeTable() As DataTable Dim tbl As New DataTable("Books") Dim col As DataColumn With tbl col = .Columns.Add("ISBN", GetType(String)) col = .Columns.Add("Title", GetType(String)) col = .Columns.Add("Category", GetType(String)) col = .Columns.Add("Authors", GetType(String)) col = .Columns.Add("SImg", GetType(String)) col = .Columns.Add("MImg", GetType(String)) col = .Columns.Add("LImg", GetType(String)) col = .Columns.Add("Pub", GetType(String)) col = .Columns.Add("PubDate", GetType(String)) col = .Columns.Add("Binding", GetType(String)) col = .Columns.Add("NumItems", GetType(String)) col = .Columns.Add("NumPages", GetType(String)) col = .Columns.Add("EAN", GetType(String)) col = .Columns.Add("Keywords", GetType(String)) End With Return tbl End Function Private Function UpdateTable() As OleDbCommand Dim str As String str = "INSERT INTO Books (ISBN, Title, Category, Authors, SImg, MImg, LImg, Pub, PubDate, Binding, NumItems, NumPages, EAN, Keywords) VALUES ([?], [?], [?], [?], [?], [?], [?], [?], [?], [?], [?], [?], [?],[?])" Dim cmd As New OleDbCommand(str, cn) cmd.CommandType = CommandType.StoredProcedure Dim col As DataColumn For Each col In tbl.Columns Dim param As New OleDbParameter(col.ColumnName, OleDbType.VarChar, 255, col.ColumnName) cmd.Parameters.Add(param) Next Return cmd End Function Private Sub SubmitInsertViaAdapter() Dim daBooks As New OleDbDataAdapter() daBooks.ContinueUpdateOnError = True 'daBooks.SelectCommand = Nothing 'daBooks.UpdateCommand = Nothing 'daBooks.DeleteCommand = Nothing daBooks.InsertCommand = UpdateTable() Label3.Text = CStr(daBooks.Update(tbl)) End Sub When all is done, there are rows in the datatable but none of them were submitted to the database. What am I doing wrong? Please help, I have only a few hairs left on my head!! Thanks, Roshawn Tag: Filter Dataset Tag: 107866
  - 2
    - Can't find stored procedure On Sql Server 2000, my program can't seem to find the Stored Procedure: AddNewResumeTemplate. The error it shows is: Could not find stored procedure 'AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5'. The problem is that it is there. I even have Sql Profiler running which shows it trying to execute: exec AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5 Which is correct and when I copy and paste it into Sql Query Analyser, it works. My code is the same as I have been running for a long time, so I can't seem to see what is missing. Here is what it looks like: ********************************************************************************* Dim ConnectionString as String =System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_ftsolutions") Dim objConn as New SqlConnection (ConnectionString) Dim CommandText as String = "AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5" Dim objCmd as New SqlCommand(CommandText,objConn) objCmd.CommandType = 4 trace.warn("objConn.ConnectionString = " & objConn.ConnectionString) objConn.Open() objCmd.ExecuteNonQuery ************************************************************************************* The trace.warn shows that it is accessing the correct database on the server, so I don't know why it can't find it. Tom Tag: Filter Dataset Tag: 107862
  - 3
    - using ReadXML with disparate XML data I want to load data from two related but different XML files into a two different DataTables in a single DataSet, then create relations, and finally filter and select specific data. I can't figure out how to load the two different sets of data into one DataSet. For example, the following results in just one table, and no detail data: XmlDataDocument datadoc = new XmlDataDocument(); datadoc.DataSet.ReadXml(new StreamReader(@"C:\temp\header.xml"), XmlReadMode.Auto); datadoc.DataSet.ReadXml(new StreamReader(@"C:\temp\detail.xml"), XmlReadMode.Auto); Trying a few variations of this code didn't get me any further. Tag: Filter Dataset Tag: 107854
  - 4
    - A question about closing the SqlDataReader Hi all, I have code like: SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { // do something here } else { reader.Close(); // this is the line I'm not sure about Response.Redirect("to_some_other_page.aspx"); } reader.Close(); My question is: Is reader.Close() in the else part really needed? If reader.Read() returns nothing, then is the reader actually open or not? The code above does not crash, but maybe the Close() is redundant... Thanks. Tag: Filter Dataset Tag: 107853
  - 5
    - List SQL Servers instaled on the system and the ODBC drivers Hi! I am trying to find a way for listing the SQL servers installed on a machine, for example MS SQL, Oracle, My SQL, Transact SQL. And also the ODBC drivers that exists on a system, including ODBC drivers for sql servers previosly listed, and the ODBC drivers for flat files (for example foxPro dbf files, dBase files, Microsft Office Excel, other ISAMs) In a word, all the posible information existing on a machine for creating datasources . Very much need for this! Tag: Filter Dataset Tag: 107845
  - 6
    - Can I execute sql drop database cmd w/a SqlParameter Hi, I'm wondering if it is possible to execute a sql command to drop a database with a SqlParameter containing the name of the db to drop. I've tried the following and I get an error SqlCommand dropDbSqlCmd = _masterDbConn.CreateCommand (); dropDbSqlCmd.CommandType = CommandType.Text; dropDbSqlCmd.CommandText = "DROP DATABASE @dbToDrop"; SqlParameter dbNameParam = dropDbSqlCmd.Parameters.Add ( @dbToDrop, SqlDbType.NVarChar, 128 ); dbNameParam.Value = dbName; Error is System.Data.SqlClient.SqlException : Line 1: Incorrect syntax near '@dbToDrop'. Thanx jra Tag: Filter Dataset Tag: 107844
  - 7
    - Connecting to non SQL database When i try to connect to an old UniVerse database (using their ODBC drivers) visual studio (vc# standard) gives me an error saying something to the effect that this version can only connect to Access/SQL databases. What version of visual c# or visual studio do I need to connect to any ODBC complient database? Tag: Filter Dataset Tag: 107843
  - 8
    - DataReader problem I hope someone can help. I'm using a SqlDataReader to pull some data from a Sql 2000 database. Most of the columns are varchar's of varing lengths and one of the columns is defined as a char(2). Using the datareader I can get the values of the varchar columns, but the char column returns empty. Example: myObj.prop1 = Convert.ToString(dr["VARCHAR_COL_1"]); myObj.prop2 = Convert.ToString(dr["VARCHAR_COL_2"]); myObj.prop3 = Convert.ToString(dr["CHAR_COL_1"]); I know there's a value in the char column on the db, the first two properties get set, but the third does not. I haven't check to see if it's null or just an empty string, My property being assigned to is a string. David Tag: Filter Dataset Tag: 107828
  - 9
    - Altering Access Database Using ADO.NET Hi Since the last version of my released software I've had to make some modifications to the back end Access database such as adding an extra field to a table and adding new queries. Does anyone know the easiest way to modify a tables structure and add queries using purely VB.NET or is it necessary to use COM objects to do so? Thanks Lee Tag: Filter Dataset Tag: 107826
  - 10
    - DataAdapter Query Access Hi people, i have a question about this: I need to know how can i obtain the sql queries (Insert, Update, Delete) that are executed by DataAdapter.Update on a DataSet. I know that i can see that queries on SQLProfiler but i want to obtain that sentences on my code...It's possible??? I hope you can help me... Regards Johny Tag: Filter Dataset Tag: 107823
  - 11
    - how store the images in ORACLE database using asp.net (Type your message here) -------------------------------- From: viji g hi i need help .... how store the images in ORACLE database using asp.net pls give me resulet i m wating pls help me urgent ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>kyzm318fGEuYs1Q2e5VjAA==</Id> Tag: Filter Dataset Tag: 107814
  - 12
    - Replacing MSDE Hello, I have made a Windows Application in C#, with a database running under MSDE. The application is quite simple, and there is only 3 tables, and only one has maybe 200-250 records maximum (the 2 others have only 10-20 records). I wanted to use XML files for datasets, but i am not sure if it is possible to use SQL queries to sort my data (like SELECT * FROM myTable WHERE ..... ORDER BY ...). Is there an other way to use database file without installing anything, like the old DBF files for Foxpro ? Because i think MSDE is a little bit to heavy for my purpose. Thanks for your answers. Michael Tag: Filter Dataset Tag: 107811
  - 13
    - Excel file permissions problem I have an Excel file, which I use to store some data. When reading from file, everiting is ok. When i try to insert some row, an OleDbExcetpion is thrown. I'va tracked it to a permission problem. The sheats of my Excel file as protected with password. Any way I can supply this password to the connection string, or other way? thanks Tag: Filter Dataset Tag: 107809
  - 14
    - A simple insert problem Hi all, I know I am going to kick myself but I have run into a bit of a brick wall and I need some help before I loose the rest of my hair. All I want to do is insert a new row of data into a access database from a vb.net app I'm writing. I have read so many forums today and I think I must be missing something really basic. I have a database with a table in it called Flights. The columns in the database are: CellInfo type=string Flightdate type=dateTime FlightTime type=int Key type=int recordNum autonumber, primarykey WhyComment type=string I have created a OleDbDataAdapter1, and Dataset1 to this database. With my code all I am doing at this stage is trying to insert the word "Test" into the column "WhyComment" when I click a button. Heres my code: *************************************** Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Fill Dataset DataSet11.Clear() OleDbDataAdapter1.Fill(DataSet11) 'Assign variables Dim myNewRow As DataSet1.FlightsRow Dim myDataset1 As DataSet1 Dim FlightsTable As DataSet1.FlightsDataTable 'Insert the word test into the colum "WhyComment" in table "Flights 'in the database. 'WhyComment is a string table myNewRow = myDataset1.Flights.NewRow 'The above row is where it errors out with this error: 'An unhandled exception of type 'System.NullReferenceException' occurred 'in DatabaseInserts.exe ' 'Additional information: Object reference not set to an instance of an object myNewRow("WhyComment") = "Test" myDataset1.Tables("WhyComment").Rows.Add(myNewRow) 'update Database OleDbDataAdapter1.Update(DataSet11) MessageBox.Show("Database updated!") End Sub **************************************** Anyones help would be appreciated. Cheers Dave ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>FdFbRYaMk0mqARLDPpAkqQ==</Id> Tag: Filter Dataset Tag: 107807
  - 15
    - Using Enterprise Library caching in Data Layer Can anyone point me in the direction of, or provide, some best practice (and poss examples) for using the Enterprise Library caching block within a COM+ Data Access Layer (which also uses the DA block)? I would like to cache data for a set period of time. The data is returned from SQL as Xml and then transformed with Xslt, it is the transformed xml that is to be cached. A few different applications use this data and I believe caching will vastly improve the performance. Any help on this subject area woul dbe much appreciated. Thanks, -------------------------- Shaun Venus emailid: sunevnuahs domain: hotmail.com -------------------------- Tag: Filter Dataset Tag: 107804
  - 16
    - Simply adding a table What is the best way to add a new table to a database? If possible I don't want to use SQL, but ADO.Net directly. I'm a Ado-Newbie and tried the following: dataSet.Tables.Add("xyz"); adapter.Update(dataSet); but this does not work. I believe that Adapter.Update() only works for Tables that already exist in the Database. But what is the alternative if I don't like the SQL solution (CREATE TABLE ...)? I cannot create the tables directly. I have to make that at runtime. Thanks, Thomas Krause Tag: Filter Dataset Tag: 107794
  - 17
    - Handling paging in the UI without using datagrid/dataview Hi Please give me some inputs on the following : Iam planning to use a custom control to list a large number of records from sql database through ado.net. so in the following code, if i give a select * query, does the dataset holds the complete records in the memory? or is there anyway i can set options in the dataset? or the paging logic need to be done in UI side? Hari //Open Connection. SqlConnection conn = new SqlConnection("Server=server;uid=login;pwd=pwd;database=northwind"); //Set the DataAdapter's query. da = new SqlDataAdapter("select * from customers", conn); ds = new DataSet(); //Fill the DataSet. da.Fill(ds, "customers"); Tag: Filter Dataset Tag: 107792
  - 18
    - Excel and ADO.NET Hello: I am building an App that takes an Excel file and populates 3 DataTable's in a Dataset. I then was to create a relationship between these 3 DataTables. After doing so I want to run some code to process / modify the data in the tables and then return the result back into an Excel file. I am a beginner at VB and i chose this as a starter project. I get the following exception when i try to create the DataRelation: An unhandled exception of type 'System.ArgumentNullException' occurred in system.data.dll Additional information: 'column' argument cannot be null. Listed below is the code I have. All help would be appreciated Thank You Private Sub cbConvert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbConvert.Click 'Convert button click event Dim filename As String filename = tbInputFileBrowser.Text() Dim XLFileConn As New OleDbConnection XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & _ ";Extended Properties=""Excel 8.0;HDR=YES""" Try XLFileConn.Open() Dim XLFileCmd1 As New OleDbCommand XLFileCmd1.Connection = XLFileConn Dim XLFileDA As OleDbDataAdapter = New OleDbDataAdapter XLFileDA.SelectCommand = XLFileCmd1 Dim XLFileMainDS = New DataSet("MainDataSet") Dim TableMain As DataTable = XLFileMainDS.Tables.Add("TableWithMain") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify <> 'TC' OR '26'" XLFileDA.Fill(XLFileMainDS, "Sheet1") Dim TableTC As DataTable = XLFileMainDS.Tables.Add("TableWithModTC") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify = 'TC'" XLFileDA.Fill(XLFileMainDS, "Sheet1") Dim Table26 As DataTable = XLFileMainDS.Tables.Add("TableWithMod26") XLFileCmd1.CommandText = "SELECT * FROM [Sheet1$] WHERE Modify = '26'" XLFileDA.Fill(XLFileMainDS, "Sheet1") 'XLFileDA.FillSchema(XLFileMainDS, SchemaType.Source, "Sheet1$") Dim ParentCol As DataColumn Dim Child1Col As DataColumn Dim Child2Col As DataColumn ParentCol = XLFileMainDS.Tables("TableWithMain").Columns("Proc Code") Child1Col = XLFileMainDS.Tables("TableWithModTC").Columns("Proc Code") Child2Col = XLFileMainDS.Tables("TableWithMod26").Columns("Proc Code") Dim RelProcCode As DataRelation Dim RelProcCode1 As DataRelation RelProcCode = New DataRelation("ProcCodeTC", ParentCol, Child1Col) 'Get an Exception Here RelProcCode1 = New DataRelation("ProcCode26", ParentCol, Child2Col) 'Add the relation to the DataSet. XLFileMainDS.Relations.Add(RelProcCode) XLFileMainDS.Relations.Add(RelProcCode1) Finally XLFileConn.Close() End Try Tag: Filter Dataset Tag: 107788
  - 19
    - Datagrid Navigate question If a datatable, bound to a datagrid, has multiple child tables, is there any way to determine which relationship is being used to generate the child rows when the user navigates using one of the relationship links? Thanks. Tag: Filter Dataset Tag: 107780
  - 20
    - ADO.Net DataSet to ADO Recordset I have two applications, one on ASP.Net and the other on ASP (both have different explicit databases). It so happens that the ASP application now wants to use the dataset created in ASP.Net for further information processing. How do i make this happen? Tag: Filter Dataset Tag: 107778
  - 21
    - Messages in ADO.NET I would like to be able to execute a long-running stored procedure from a Windows Forms application. The procedure loops through about 7,000 items, calling various other procedures along the way, and progress is displayed in SQL Query Analyzer using the Print command. It appears that Print events are handled automatically within the application (I assume through the InfoMessage event) and displayed as Message windows, which quickly causes an error. Is there a way to suppress this automatic handling, or do I just have to create an even handler of my own which does nothing? Tag: Filter Dataset Tag: 107776
  - 22
    - return OleDbDataReader from static function Hi all I want to return OleDbDataReader from a static function, So I will have DB interface for my Entire project, Is it possible? How do I close the connection ?????? Thank you Sharon ///////////////////////////////////////////////////////////// //Example of use : ///////////////////////////////////////////////////////////// OleDbDataReader reader = myDbObj.Select("SELECT CustomerID, ContactName, FROM Customers") While (reader.Read()){ System.diagnostics.Trace.WriteLine(reader("CustomerID").ToString() + " : " + reader("ContactName").ToString() + "<br>") } ///////////////////////////////////////////////////////////// //select function : ///////////////////////////////////////////////////////////// Public static OleDbDataReader Select (string selectString) { 'Use a string variable to hold the ConnectionString property. String connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\\Program Files\\Microsoft Visual Studio\\VB98\\NWIND.MDB" OleDbConnection cn = New OleDbConnection(connectString) 'Open the connection. cn.Open() 'Use a variable to hold the SQL statement. String As String = OleDbCommand cmd = New OleDbCommand(selectString, cn) Return cmd.ExecuteReader() 'Close the reader and the related connection. // reader.Close() //?????????????????????????????????????????????????? cn.Close() } Tag: Filter Dataset Tag: 107774
  - 23
    - How to override (null)? Sorry, this can be trivial question, but somehow I cannot find the answer to it. When I bind a data grid to a table, then some cells show a text value "(null)". This is happening for fields that have a database null value. When I manually read the database I can intercept this and override the value with a blank string, and this is the behaviour that I really want. How can I do it when I automatically bind the grid to a source? Thanks Tag: Filter Dataset Tag: 107772
  - 24
    - ado.net create a table Hi , I want to copy a dbf file to the the access database.I thought of two solutions 1. Copy the dbf to the access db by the query SELECT * into dest_table from [source.dbf] in 'source folder' this does not work out, it gave me the error that u have no permission 2.create a table with the same structure of dbf file and then insert the rows using oledbcommandbuilder update commands i tried to create the table by the following query create table temp (test1 int,test2 varchar(40)) it gave a error message "you donot have the necessary permission to use the 'temp' object." I believe there is something to do with the permission or something other than that could some one tell me what is the solution.. Thanks in advance, Viki Tag: Filter Dataset Tag: 107766
  - 25
    - LABEL ON not part of sql server? in sql server, how do I specify the column heading of a column? That is a column heading other than the column name. in the little sql I know, in the SQL on the IBM AS400, the following is permitted: Example 1: Enter a label on the DEPTNO column of table DEPARTMENT. LABEL ON COLUMN DEPARTMENT.DEPTNO IS 'DEPARTMENT NUMBER' thanks, -Steve Tag: Filter Dataset Tag: 107754

Correct me if I'm wrong, but once I have my data returned from a stored
procedure, in a dataset and displayed in a DataGrid (ASP.Net)...I can filter
the data correct, without making a return trip to the server?

Anyone have an example of how this works?

Thanks

Top

Re: Filter Dataset by Cor

Cor
Fri Apr 01 10:57:56 CST 2005

Steve,

Use a table("x").defaultview.rowfilter = "mycolumn = 'Steve'" for that

I hope this helps,

Cor

Top

Re: Filter Dataset by Steve

Steve
Fri Apr 01 11:03:01 CST 2005

Thank you, I'll give that a shot. I'm assuming I can do 'like' expressions
also, not just 'equals'.

"Cor Ligthert" <notmyfirstname@planet.nl> wrote in message
news:uT3w%23vtNFHA.2356@TK2MSFTNGP14.phx.gbl...
> Steve,
>
> Use a table("x").defaultview.rowfilter = "mycolumn = 'Steve'" for that
>
> I hope this helps,
>
> Cor
>
>

Top

Filter Dataset by Elton

Elton
Fri Apr 01 11:07:18 CST 2005

You are right.

Suppose you get data using sp(Select * from Employee ...)
to fill a dataset. Then you use following code

DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "Department = 'HR'";
datagrid.DataSource = dv; // only data in HR
datagrid.DataBind();

HTH

Elton Wang
elton_wang@hotmail.com

>-----Original Message-----
>Correct me if I'm wrong, but once I have my data returned
from a stored
>procedure, in a dataset and displayed in a DataGrid
(ASP.Net)...I can filter
>the data correct, without making a return trip to the
server?
>
>Anyone have an example of how this works?
>
>Thanks
>
>
>.
>

Top

Re: Filter Dataset by Stephany

Stephany
Sat Apr 02 03:52:31 CST 2005

The documentation for the DataColumn.Expression property provides details of
the syntax you can use for the DataView.RowFilter property.

"Steve Schroeder" <sschroeder@merchant-gould.com> wrote in message
news:OE%23jrztNFHA.3760@TK2MSFTNGP12.phx.gbl...
> Thank you, I'll give that a shot. I'm assuming I can do 'like' expressions
> also, not just 'equals'.
>
> "Cor Ligthert" <notmyfirstname@planet.nl> wrote in message
> news:uT3w%23vtNFHA.2356@TK2MSFTNGP14.phx.gbl...
>> Steve,
>>
>> Use a table("x").defaultview.rowfilter = "mycolumn = 'Steve'" for that
>>
>> I hope this helps,
>>
>> Cor
>>
>>
>
>

Top