Sending data to access query from Visual .net form

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
    - Using IDataAdapter to fill a strongly-typed dataset We're using abstract interfaces for the data access in our classes. We're using strongly-typed datasets when using data adapters. We can use a SqlDataAdapter to fill a strongly-typed dataset using the Fill method, but we can't get the same result if we've cast the object to an IDataAdapter's fill method. Is it possible to fill a stronly-typed dataset using the interface? Thanks. --ROBERT Tag: Sending data to access query from Visual .net form Tag: 106706
  - 2
    - Cannot open a password protected access database I am unable to open a password protected Access Database programtically. I have office 2003 installed on my machine. I am using the OleDb namespace in C#. I can open the database in access. I can open the database programatically if I remove the password. Here are the last 3 connection strings I've tried, with the Execption text that was generated for them. Tag: Sending data to access query from Visual .net form Tag: 106702
  - 3
    - DataGrid paint exception when size too small I have a .NET windows forms application with one form displaying data. I have a tree view on the left side and the datagrid on the right side. Tree view allows the user to select verious items and based on that selection the datagrid is bound to the appropriate datasource and table from the database. This works well. The problem comes when I resize my form and the grid portion is not visible or just barely visible. Now when I perform the same operations by selecting various items in the tree I get an exception System.ArgumentException with Message : '0' is not a valid value for 'value'. 'value' should be between 'minimum' and 'maximum'. Source : System.Windows.Forms. This happens when I call SetDataBinding method. When I again resize the form so that the grid is more visible this problem goes away. I have also seen a bizzare display with red cross over the entire grid area when I resize the grid again. Is this a known issue in the datagrid ? Can somebody help me ? Thanks Tag: Sending data to access query from Visual .net form Tag: 106701
  - 4
    - Default Value in Typed Dataset Hello in a strongly typed dataset, we can set defaults for each field. How can we set default for a datetime type field ? If I set it either to: now; Now; Now(), now() or DateTime.Now - it doesn't work. So how do I set it ? Thanks Tag: Sending data to access query from Visual .net form Tag: 106700
  - 5
    - Parameter ?_1 has no default value I'm using the HierCube .net OLAP component from rainbowsoft (http://www.rbwsoft.com/) in a vb winform application (vs2003). The data source is an MS Access 2000 table; the data adapter is of the oledb type; and the sql string has two parameters ala =? At runtime the app provides values for the params like so: oledaPivotData.SelectCommand.Parameters("Conversion").Value = cboConversion.SelectedValue oledaPivotData.SelectCommand.Parameters("Year").Value = cboYear.SelectedValue The cube works fine. However the cube control won't let me access the Dimension Mapping facility, it complains that "Parameter ?_1 has no default value". I'm not sure how to solve this. I've written to the control developers, but they can be slow to respond...and this issue seems to be more generic than specific to this control. I've not been able to find a discussion here that deals with my situation, most other cases are using SPs. Tag: Sending data to access query from Visual .net form Tag: 106698
  - 6
    - Oracle Pipeline function I have a VB.Net application that currently access an Oracle 9i database. We use ref cursors called from stored procedures to pass back recordsets.. I was wondering if it is possible to pass back the data through an Oracle Pipeline function instead? Thanks Tag: Sending data to access query from Visual .net form Tag: 106693
  - 7
    - Question about DataSet.WriteXML method. I have a DataSet in which one row contains a column with a string that has CR or LF characters in it. I am converting this DataSet to XML by calling DataSet.WriteXml(). I would have expected CR and/or LF characters to be translated to numeric character entry values. Instead, they are written out as absolute. How can I ensure that all special characters are translated properly when calling WriteXml? -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: Sending data to access query from Visual .net form Tag: 106692
  - 8
    - When to use MSDE/Sql Server (when using VB.NET) Hi, I'm just wondering when I better should use an Sql Server or when a MSDE. Whet are the advantages of one to another en the limits etc. And this espacially when using them as databases for VB.NET-applications. Any information would be great! Thanks a lot in advance, Pieter Tag: Sending data to access query from Visual .net form Tag: 106687
  - 9
    - Problem with Delete Query and DateTime parameter I want to delete some rows from database table by way: DELETE FROM DOSTEPNE_MIEJSCA WHERE ID_STANOWISKA = 66 AND GODZINA BETWEEN '2001-01-01 08:00:00' AND '2001-01-01 18:00:00' connection.Open(); string zapytanko = "DELETE FROM DOSTEPNE_MIEJSCA WHERE ID_STANOWISKA = 66 AND GODZINA BETWEEN '2001-01-01 08:00:00' AND '2001-01-01 18:00:00'"; OleDbCommand command = new OleDbCommand(zapytanko, connection); command.ExecuteNonQuery(); connection.Close(); where column GODZINA has DateTime data type... Why I get this Except?: "OleDBException was unhandled - Unsuitable type of data in expression of criterion" When I ry this query through the QueryBuilder - ExecuteQuery - I get properly ressult ... Thanks for help... Tag: Sending data to access query from Visual .net form Tag: 106685
  - 10
    - Error... Dear developer, I have experience this error message: System.NullReferenceException: Object reference not set to an instance of an object. at GreenBid_mobile.LoginProc.ValidateLogin(String EmailAdd, String Password) in c:\inetpub\wwwroot\greenbid_mobile\loginproc.asmx.cs:line 108 Here is the code: public string ValidateLogin(string EmailAdd, string Password) { int result; sqlCommand1.Parameters["@usr_Email"].Value=EmailAdd; sqlCommand1.Parameters["@usr_PW"].Value=Password; try { sqlCommand1.Connection.Open(); result=(int)(sqlCommand1.Parameters["@usr_session"].Value); } catch(Exception ex) { return (ex.ToString()); } sqlCommand1.Connection.Close(); if(result==1) return "Login Successfully"; else return "Login Failed"; the error is fall on "result=(int)(sqlCommand1.Parameters["@usr_session"].Value)", my database connectivity no problem.. but the problem keep on occur. Thanks advance whoever tell me the problem.. thanks cheers, Wong CS Tag: Sending data to access query from Visual .net form Tag: 106676
  - 11
    - about GetDate(T-SQL) SELECT GETDATE() July 29 1995 2:50 PM (1 row(s) affected) ---------------------- how can changed this format: 1995-29-05 14:50, Just in storeprocess ? Tag: Sending data to access query from Visual .net form Tag: 106668
  - 12
    - MSSQL - ON DELETE SET NULL Hello NG, Does SQL Server support "ON DELETE SET NULL"? I have a couple of CREATE TABLE / ALTER TABLE commands that are all in one string, separated by ";\r\n", and send them to SQL Server (without transaction context). The SQL itself is created dynamically, but here is a sample (for simplicity, I scrapped irrelevant stuff). I always get an SqlException with as many SqlErrors in it as there are ON DELETE SET NULL occurances. The same thing works with Access, though (with Jet-SQL syntax of course). Or (being a consumer product) is Jet just "fault tolerant" and ignores that? CREATE TABLE TFoo ( ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, Bar UNIQUEIDENTIFIER); CREATE TABLE TList ( ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY ); CREATE TABLE TBar ( ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, Foo UNIQUEIDENTIFIER, List UNIQUEIDENTIFIER, FOREIGN KEY (Foo) REFERENCES TFoo(ID) ON DELETE SET NULL, FOREIGN KEY (List) REFERENCES TList(ID) ON DELETE SET NULL); ALTER TABLE TFoo ADD FOREIGN KEY (Bar) REFERENCES TBar(ID) ON DELETE SET NULL; Many thanks, Phil Tag: Sending data to access query from Visual .net form Tag: 106667
  - 13
    - Which one is better one SQL or DataSet Transactions I am developing a project, in that i use SQL Transactions to begin a transaction like if i want to save the details of the user along with the Address first i will save the details of the user and then the address. in my database i have these type of files: Person, user, Address, userAddress : person will have the details like personID, firstName, LastName, SSN . . . and user will userid, PersonID, . . . . and in the same way Address will have a unique AddressID and this adddress id will be corelated in UserAddress. for this type of transactions i use SQL transactions. but when i was going thorough a Micorsoft Enterprise Example : Duwamish i came accross DataSet Transactions. in that, if there are any transactions he first performs all the transactions in the DataSet and then update the database. SQLDataAdapter.Fill(Destination, Source) from the above scenario which one is most reliable. . . Thankyou, Raghuram. Tag: Sending data to access query from Visual .net form Tag: 106666
  - 14
    - Which one is better one SQL or DataSet Transactions I am developing a project, in that i use SQL Transactions to begin a transaction like if i want to save the details of the user along with the Address first i will save the details of the user and then the address. in my database i have these type of files: Person, user, Address, userAddress : person will have the details like personID, firstName, LastName, SSN . . . and user will userid, PersonID, . . . . and in the same way Address will have a unique AddressID and this adddress id will be corelated in UserAddress. for this type of transactions i use SQL transactions. but when i was going thorough a Micorsoft Enterprise Example : Duwamish i came accross DataSet Transactions. in that, if there are any transactions he first performs all the transactions in the DataSet and then update the database. SQLDataAdapter.Fill(Destination, Source) from the above scenario which one is most reliable. . . Thankyou, Raghuram. Tag: Sending data to access query from Visual .net form Tag: 106665
  - 15
    - about the storeprocess ALTER PROCEDURE Login @LName nvarchar(50), @Pwd nvarchar(500) AS declare @myID int SET NOCOUNT ON if exists ( select @myID = ID from kylin_user where lname=@lname and pwd=@pwd ) begin insert into kylin_log(UID,TLogin)values(@myID,Getdate()) end RETURN but it mind that @myID=ID wrong ! what't the errors ? Tag: Sending data to access query from Visual .net form Tag: 106664
  - 16
    - SQL View How to use SQL View via ado.net in asp.net? Any reference at website? Please advise. Tag: Sending data to access query from Visual .net form Tag: 106663
  - 17
    - dispose() how to dispose connection pooling when aspx is discontinued? In VB, the syntax is unload but how about aspx ? Tag: Sending data to access query from Visual .net form Tag: 106662
  - 18
    - How to read from DataReader and Update using DataAdapter I am looking for example of reading one table using datareader and updating another with the values using a dataadapter. Tag: Sending data to access query from Visual .net form Tag: 106658
  - 19
    - CLOB - IN OUT PARAMETER PROBLEM (Type your message here) PROCEDURE dal_get_clob_data ( i_dal_string IN VARCHAR2, io_dal_clob IN OUT CLOB ); An exception threw when I tried to use IN OUT CLOB inspite of the usual work around I did. When it is IN CLOB or OUT CLOB it worked fine but not in case of INOUT CLOB. Is there anyway to do with this? I am using MDAC 2.7 -------------------------------- From: Naren Srini ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>V9J2gtoMqU6p5kL9A86XGA==</Id> Tag: Sending data to access query from Visual .net form Tag: 106642
  - 20
    - SqlDecimal MaxValue Has anyone noticed that the doc for this says: The value of this constant is 79,228,162,514,162,514,264,337,593,543,950,335 but that it is actually 99,999,999,999,999,999,999,999,999,999,999,999,999? Just thinking that Microsoft has a (minor) documentation error that should be fixed. Tag: Sending data to access query from Visual .net form Tag: 106640
  - 21
    - Master-Detail records I wrote an application in .NET 2003, everything worked fine for several weeks. This application has several text boxes and a detail grid. I put navigation buttons on the form to move to the next record, which will also change the data in the grid. I didn't make any changes to the application, but all of a sudden, the detail grid quit updating with changes to the position of the master. If I just did it wrong in the first place and it should have never worked, then that's the way it is, but I would like to know what I did wrong, and maybe some ideas of why it would all of a sudden decide to stop working. Thank you Kalvin Here is my code: '***** CODE STARTS HERE Public Function GetAllLabs() As DataSet Dim DS As DataSet DS = SqlHelper.ExecuteDataset(ConnectionString _ , CommandType.StoredProcedure _ , GET_ALL_LABS) DS.Tables(0).TableName = LabsTable DS.Tables(LabsTable).PrimaryKey = New DataColumn() {DS.Tables(LabsTable).Columns("LabID")} GetChild(DS) DS.Relations.Add("LabsToPVS" _ , DS.Tables(LabsTable).Columns("LabID") _ , DS.Tables(CHILD).Columns("LabID")) Return DS End Function Public Sub GetChild(ByRef DS As DataSet) SqlHelper.FillDataset(ConnectionString _ , CommandType.StoredProcedure _ , GET_CHILDREN _ , DS _ , New String() {CHILD}) DS.Tables(CHILD).PrimaryKey = New DataColumn() {DS.Tables(CHILD).Columns("ChildID")} DS.Tables(CHILD).Columns("ChildID").AutoIncrement = True DS.Tables(CHILD).Columns("ChildID").AutoIncrementSeed = -1 DS.Tables(CHILD).Columns("ChildID").AutoIncrementStep = -1 Return End Sub Private Sub BindFields() uiLabID.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "LabID") uiLabName.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "LabName") uiStreet.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Street") uiCity.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "City") uiState.DataBindings.Add("SelectedValue", Data.Tables(LabsTable).DefaultView, "State") uiZip.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Zip") uiProvince.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Province") uiCountry.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Country") Dim PhoneNumberBinding As New Binding("Text", Data.Tables(LabsTable).DefaultView, "PhoneNumber") AddHandler PhoneNumberBinding.Format, AddressOf FormatPhone uiPhoneNumber.DataBindings.Add(PhoneNumberBinding) Dim FaxNumberBinding As New Binding("Text", Data.Tables(LabsTable).DefaultView, "FaxNumber") AddHandler FaxNumberBinding.Format, AddressOf FormatPhone uiFaxNumber.DataBindings.Add(FaxNumberBinding) AddHandler Me.BindingContext(Data.Tables(LabsTable).DefaultView).PositionChanged, _ AddressOf UpdateStatusForPosition End Sub 'Handles the Format event for the Phone and Fax numbers Protected Sub FormatPhone(ByVal sender As Object, ByVal e As ConvertEventArgs) If e.Value Is System.DBNull.Value Then Return End If If CStr(e.Value).Length = 10 Then e.Value = "(" & Strings.Left(e.Value, 3) & ")" & _ Mid(e.Value, 4, 3) & "-" & _ Strings.Right(e.Value, 4) End If End Sub Private Sub frmLab_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try Data.Tables(LabsTable).DefaultView.Sort = "LabName ASC" BindFields() ChildData.DataSource = Data.Tables(LabsTable) ChildData.DataMember = "LabsToPVS" With ChildData .Cols("PVSID").Visible = False .Cols("LabID").Visible = False .Cols("DateEntered").Caption = "Date" .Cols("StreckOperator").Caption = "Streck Operator" .Cols("PipetOperator").Caption = "Pipet Operator" .Cols("LotNumber").Caption = "Lot Number" .Cols("KitNumber").Caption = "Kit Number" End With FirstRecord() Catch exc As Exception MessageBox.Show(exc.Message.ToString, "Error Opening Form", MessageBoxButtons.OK, MessageBoxIcon.Error) Me.Close() End Try End Sub Private Sub FirstRecord() Me.BindingContext(Data.Tables(LabsTable).DefaultView).Position = 0 End Sub Private Sub UpdateStatusForPosition(ByVal sender As Object, ByVal e As System.EventArgs) ShowCurrentRecord() End Sub '***** END CODE Tag: Sending data to access query from Visual .net form Tag: 106637
  - 22
    - Combining multiple datatables on a unique ID Hi, Using VB .NET I want to combine app 100 different ADO.NET datatables, each with app 50,000 records which have been populated from SQL. They share a common ID, and I would like to group by this ID and sum up the other 4 columns to give me one master table. I understand how to populate the datatables but don't know what the best/fastest way to query across different datatables is. Any advice on querying one datatable with another on a common ID is much appreciated. Tag: Sending data to access query from Visual .net form Tag: 106630
  - 23
    - Deploy applcation VBNET and Sql Hello friends i have a question. Is about the deployment an application net over a pc. I installed the netframework 1.1 and i copied the applicattion . The problem es when the application tried to connect Sql. Dont do it Thanks -- Message posted via http://www.dotnetmonster.com Tag: Sending data to access query from Visual .net form Tag: 106617
  - 24
    - Data Adapter Problem? The following is an issue using ado.net in an asp.net page using SQL Server.... I have a Statement that when executed from my asp.net dataadapter takes about 24,000 reads according to SQL Profiler. I think the read count is accurate as it grids a long time. The same statement when executed from Query analyzer takes only 116 reads and it executes quickly. Why the Difference? Same table, same server. The statement as it executes is as follows: exec sp_executesql N'SELECT Amount, InvoiceNum, Job FROM Unpaid_Bal WHERE (InvoiceNum = @InvoiceNum) AND (Job = @JobNum)', N'@InvoiceNum varchar(50),@JobNum varchar(11)', @InvoiceNum = '100488RS', @JobNum = 'ABCE-036245' thanks, G Tag: Sending data to access query from Visual .net form Tag: 106613
  - 25
    - FTP a text file guys, i need some help on this one. i need to set up a program that will create a text file (done that). then ftp that file to an IP address, say IPAddress=204.23.144.21 IPLogin=ftpmylogin IPPassword=mypwd this program can be in VB.NET or ASP.NET - doesnt really matter. whichever is the easiest. im a little lost as to where to turn on this one. thanks again rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Sending data to access query from Visual .net form Tag: 106611
- Next
  - 1
    - bound comboboxes I have three comboboxes on the form. When the record is displayed, all the three combo boxes are blank. If I select a value in the first combo box, and click save, the first value in the other combo box is displayed automatically. However, if I go to the next record and come back, those 2 combo boxes are correctly shown as blank. Is this a known issue? Any workarounds ? Thanks Tag: Sending data to access query from Visual .net form Tag: 106610
  - 2
    - Trying to use Nile Oracle DAAB in VB I am trying to use the Oracle DAAB found in the Nile application at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp. I am trying in VB 2003 to call an Oracle 9i stored procedure with parameters but I cannot seem to get past the compiler. Oracle procedure: CREATE OR REPLACE PROCEDURE insertNonQWP (repText IN VARCHAR2,repID IN NUMBER) IS BEGIN UPDATE TESTNONQ SET TXTFIELD = repText WHERE TID = repID; COMMIT; END; What am I doing wrong in my parameter assignment? One of the examples in C# looks like: OracleParameter[] ps = {new OracleParameter("CUSTOMERID",customerId), new OracleParameter("SESSIONID",sessionId), new OracleParameter("NETAMOUNT",netAmount), new OracleParameter("TAXAMOUNT",(Decimal.Multiply(netAmount, (Decimal)0.05))), new OracleParameter("TOTALAMOUNT",(Decimal.Multiply(netAmount, (Decimal)1.05))) }; OracleHelper.ExecuteNonQuery(m_connectionString, CommandType.StoredProcedure, "SP_PURCHASECARTFORSESSION", ps); How do I do it in VB? I tried: Dim ps() As OracleParameter = {New OracleParameter("REPTEXT", "Junk"), New OracleParameter("REPID", 2)} Dim rowAffected As Integer rowAffected = OracleHelper.ExecuteNonQuery(connectString, CommandType.StoredProcedure, "insertTestNonQ", ps) and I get an ?Overload resolution failed because no accessible ?ExecuteNonQuery? can be called with these arguments.? ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Sending data to access query from Visual .net form Tag: 106609
  - 3
    - Wierd Occurrance I have an intermittant problem that occurs a couple of times a week in a handful of places in the code (the same places at different times). The error is 'Object reference not set to an instance of an object'. After much research (it's not my code), I've found that it is occuring when a datareader is being used after being returned from a another method that queries an Oracle database. Here is the method: Public Function GetDataReader(ByVal strSelect As String) As OleDbDataReader Dim rc As Integer Const FUNCTION_NAME As String = CLASS_NAME + ":SelectSQL" Try objConn = New OleDbConnection(strConnectionString) objCmd = New OleDbCommand(strSelect, objConn) objCmd.Connection.Open() GetDataReader = objCmd.ExecuteReader(CommandBehavior.CloseConnection) Catch ex As OleDbException If oLogFile Is Nothing Then oLogFile = New clsLogFile() rc = oLogFile.LogErrorMessage(FUNCTION_NAME, ex.ErrorCode, ex.Message + " SQL Statement: |" + strSelect + "|") GetDataReader = Nothing Finally objConn = Nothing objCmd = Nothing End Try End Function As I mentioned above, the error is occurring the first time the returned datareader is used in the calling code. The first thing the calling code does is check to see if the returned datareader is closed. When this statement executes the datareader object does not exist. Here is an example of the calling code: oDatabase = New ICPT.clsDatabase(oSession.ApplicationConnectionString, oSession.DatabaseType) strSQL = "SELECT * FROM TransactionCodes" rdrTranCode = oDatabase.GetDataReader(strSQL) 'verify the datareader is open and contains a record If rdrTranCode.IsClosed = False Then '' bomb on this line 'do something End If I've checked the application log files and there is no indication that the GetDataReader() method is trapping and logging an error. Any of you guys see a problem with this code? It looks as if a database connection and subsequent query are being done successfully (nothing in error logs), but when the datareader is returned the reference to the datareader is lost. I can tell you that most of the things this application does involve at least a few calls to GetDataReader(), and sometimes there are quite a few calls to perform a certain function. I've checked the Oracle log and trace files and there is no indication of anything flaky. Any ideas? Thanks, Todd Tag: Sending data to access query from Visual .net form Tag: 106607
  - 4
    - How to select distinct values 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 Tag: Sending data to access query from Visual .net form Tag: 106604
  - 5
    - 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: Sending data to access query from Visual .net form Tag: 106603
  - 6
    - 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: Sending data to access query from Visual .net form Tag: 106601
  - 7
    - 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: Sending data to access query from Visual .net form Tag: 106595
  - 8
    - 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: Sending data to access query from Visual .net form Tag: 106593
  - 9
    - 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: Sending data to access query from Visual .net form Tag: 106592
  - 10
    - 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: Sending data to access query from Visual .net form Tag: 106591
  - 11
    - 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: Sending data to access query from Visual .net form Tag: 106590
  - 12
    - 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: Sending data to access query from Visual .net form Tag: 106586
  - 13
    - 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: Sending data to access query from Visual .net form Tag: 106585
  - 14
    - 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: Sending data to access query from Visual .net form Tag: 106583
  - 15
    - 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: Sending data to access query from Visual .net form Tag: 106578
  - 16
    - 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: Sending data to access query from Visual .net form Tag: 106570
  - 17
    - 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: Sending data to access query from Visual .net form Tag: 106567
  - 18
    - 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: Sending data to access query from Visual .net form Tag: 106565
  - 19
    - 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: Sending data to access query from Visual .net form Tag: 106563
  - 20
    - 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: Sending data to access query from Visual .net form Tag: 106560
  - 21
    - 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: Sending data to access query from Visual .net form Tag: 106559
  - 22
    - 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: Sending data to access query from Visual .net form Tag: 106557
  - 23
    - 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: Sending data to access query from Visual .net form Tag: 106554
  - 24
    - 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: Sending data to access query from Visual .net form Tag: 106549
  - 25
    - 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: Sending data to access query from Visual .net form Tag: 106547

Hi There,
I have made a query called "Schedule",in access using few tables. Has
fields like Order #, Required Date, Quantity ordered etc.. Depending
upon the Required date field I provide on the input of the query. The
query filters and displays results based on that. I want to use a form
using Visual .net. The form would have a calender on it, when the users
clicks on a particular date. I want that date to be sent as an input to
the Required date field for my "Schedule" and display the result on the
form. I have been trying to use Ado.net, but not sure how to send this
date information to the query in access. I will really appreciate if
somebody can tell me how I can do this.
thanks a million.
-K

Top

Use the Microsoft Access to ADO.NET object mapper and code generator by Robbe

Robbe
Thu Mar 10 18:45:04 CST 2005

http://www.eggheadcafe.com/articles/microsoftaccess_source_code_generator.asp

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx

<srusc@hotmail.com> wrote in message
news:1110479657.280292.9380@f14g2000cwb.googlegroups.com...
> Hi There,
> I have made a query called "Schedule",in access using few tables. Has
> fields like Order #, Required Date, Quantity ordered etc.. Depending
> upon the Required date field I provide on the input of the query. The
> query filters and displays results based on that. I want to use a form
> using Visual .net. The form would have a calender on it, when the users
> clicks on a particular date. I want that date to be sent as an input to
> the Required date field for my "Schedule" and display the result on the
> form. I have been trying to use Ado.net, but not sure how to send this
> date information to the query in access. I will really appreciate if
> somebody can tell me how I can do this.
> thanks a million.
> -K
>

Top