Late and early binding

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
    - Binding I have creating VB .NET form with ADO .NET which have 2 textbo and have set DataBindings to the text properties of the TextBoxes i bind the the box with txtsysno.DataBindings.Add(new binding("Text", dataset1, "trxsystem.sysno") txtbranch.DataBindings.Add(new binding("Text", dataset1, "trxsystem.branch") when the form run, i place a method when a button clic txtsysno.text = "Z001 when i trace it, the txtsysno.text = "Z001" and i set the branch value throught the dataset wit dataset1.tables(0).Rows(0)("Branch") = e.SelectedRow(1) after i run the above code, the txtsysno was set to "", i don't know what makes this happen an BUT according to tests I've run, it says that the DataBindings exist, but the IsBinding is set to False, and is ReadOnly (the bindings exist, they just aren't active AND I can't/don't know how to make them active) Any body can help me??? thanks before Tag: Late and early binding Tag: 88512
  - 2
    - SQL server 2000 , how to save Danish data HI all I am working on Denmark Project, where I need to save Danish data to SQL server 2000 Database. When I am trying to save Danish Data, it is having some special Characters, it is getting converted to english characters. eg:character 'Ã¸' is getting saved as 'o How can we avoid this Thanks in advance. Eary help appreciated Thanks EJ Tag: Late and early binding Tag: 88508
  - 3
    - Monitor Transaction log Is there a way to monitor transaction log in SQL server and Oracle server using .NET? I'd like to write in VB.NET to mimic the SQL server replication (transactional publication) to use against SQL and Oracle to monitor some of the tables. Please advice. Thanks Tag: Late and early binding Tag: 88505
  - 4
    - returning values FROM window form Hi all, Quickie - I hope. I already know how to use a forms New() Sub to receive parameters from a calling class - but I don;t know how to return values... Anyone know the recommended method for doing this? Thanks, Graham Tag: Late and early binding Tag: 88496
  - 5
    - this stored procedure in sql query analyzer works correctly. but! i have a stored procedure : CREATE PROCEDURE [AddBuyer] ( @ID [int], @Name [varchar](50), @Address [varchar](50), @Phone [int] ) AS ... this procedure in sql query analyzer works correctly. but: i had created a app and test these lines of code: SqlConnection sqlCon = new SqlConnection(Connection.String); SqlCommand insertCommand = SqlHelper.CreateCommand(sqlCon,"AddBuyer", "@ID","@Name","@Address","@Phone"); SqlCommand updateCommand = SqlHelper.CreateCommand(sqlCon,"ChangeBuyerInfo", "@ID","@Name","@Address","@Phone"); SqlCommand deleteCommand = SqlHelper.CreateCommand(sqlCon,"DeleteBuyer", "@ID"); SqlHelper.UpdateDataset(insertCommand,deleteCommand,updateCommand,dsBus,tabl eName); sqlCon.Close(); this code raises an error and error message is: procedure 'AddBuyer' expects parameter '@ID', which was not supplied. Tag: Late and early binding Tag: 88495
  - 6
    - Retrieving timestamp output parameter from SqlCommand I've got a SqlCommand that executes a SQL Server 2000 stored procedure which, among other things, returns a timestamp output parameter. For the life of me, I can't figure out how to assign the value of this timestamp value to a byte array. I figure it's gotta be simple so what am I missing here? -- Cheers, David Clegg dclegg_at_ebetonline_dot_com Vote 1 http://cc.borland.com/codecentral/ccweb.exe/listing?id=21489 :-) Now supports Google Groups searching with Dyna-extend(tm) technology! Quality Central. The best way to bug Borland about bugs. http://qc.borland.com "Oh, well, of course, everything looks bad if you remember it." - Homer Simpson Tag: Late and early binding Tag: 88486
  - 7
    - Intermittent IndexOutOfRangeException - SqlDataReader Hi All I've been searching on the internet more than a week for a solution to this problem. All that I got was some desperate guys like me without an answer. My ASP.Net system works fine 99% of the time. However, eventually the system starts to fail with an IndexOutOfRangeException in any query that I run using the datareader object. The only way to stop this behavior is restarting the IIS Service. I know itÂ´s not a scalabillity problem... just few users are operating the system on that moment. It could be a pooling problem? I'll aprecciate any clue Alisso [IndexOutOfRangeException: field_name System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) +5 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +7 System.Data.SqlClient.SqlDataReader.get_Item(String name) +1 Tag: Late and early binding Tag: 88484
  - 8
    - Problem when creating database with SQL batch via ExecuteNonQuery() Hi All, I'm trying to create my database using a batch of SQL commands via ExecuteNonQuery(). The SQL batch should create the database and then all the tables to go into it. The start of the script is as follows: IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'TEST') DROP DATABASE [TEST] print 'Creating database TEST.' CREATE DATABASE [TEST] ON PRIMARY ( Name=TEST_Data, filename = 'C:\dbtest\scripts\\TEST.mdf', size=3, maxsize=5, filegrowth=10% ) LOG ON ( name=TEST_log, filename='C:\dbtest\scripts\TEST.ldf', size=3, maxsize=20, filegrowth=1 ) exec sp_dboption N'TEST', N'auto create statistics', N'true' exec sp_dboption N'TEST', N'auto update statistics', N'true' use [TEST] set nocount on print 'Creating branch table.' CREATE TABLE [dbo].[branch] ( [code] [char] (10) COLLATE Latin1_General_CI_AS NOT NULL , [name] [varchar] (12) COLLATE Latin1_General_CI_AS NULL , [addr1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr2] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr3] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr4] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr5] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [postcode] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , [telnum] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , [usemodemno] [char] (10) COLLATE Latin1_General_CI_AS NULL , [modemnum] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , [commreq] [char] (10) COLLATE Latin1_General_CI_AS NULL , [active] [char] (10) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] .... and so it goes on. (I'm picking up the 'print' statements via InfoMessage and a SqlInfoMessageEventHandler) The problem I get is that it's not creating the database or rather it seems not to be waiting for the database to be created. I've tried adding a WAITFOR DELAY but the execution just seems to ignore the statement and continues. I really don't want to split out the CREATE DATABASE into a separate script. I've tried placing the CREATE DATABASE into an EXEC ('..') but it still has the problem when it comes to the USE [TEST] ... I keep getting 'Cannot locate entry in sysdatabases for 'TEST' ...' I'm using a trusted connection to MSDE. Any help would be appreciated. Thanks in advance. Scott Tag: Late and early binding Tag: 88480
  - 9
    - 150+ columns SQL table??? Hi All; The DataAdapter Wizard does not like more than 99 columns so I have 2 DataAdapters with 2 DataSets. The first fills the first half of the row and the second fills the second half. Is this the best way of filling a DataSet with 150+ columns from a SQL MSDE Database? Thanks. Tag: Late and early binding Tag: 88479
  - 10
    - Two parent tables related to the same Child table Hello all, I have a problem that I'm not sure can be solved with a typical relationship in a DataSet. I have 3 tables in a dataset. 2 parents and a child. I have set up relationships between the parent tables and the child tables. The way I have set up the relationships is like this. ParentTables have an identity column, lets say ParentTable1ID or ParentTable2ID, and a 'SourcetypeID' column. The 'SourceTypeID' column is an integer (either 1 or 2). I.E. In Parenttable1 all rows have 1 in the column SourceTypeID and in Parenttable2 all rows have 2 in the column SourceTypeID. In the child table there is a column of ParentUniqueID and SourceTypeID. ParentUniqueID column maps to the parentID based on the SourceTypeID column. This way I can have rows in the childtable are associated with a row in either Parenttable1 or ParentTable2 based on the SourceTypeID column. So I have set up a relationship with both the ParentUniqueID and SourceTypeID columns (a multicolumn relationship). To put it another way if there is a row in the child table with ParentUniqueID set to 3 and SourceTypeID set to 1, the relationship dictates, the child row is associated to ParentTable1 with the ParentTableID of 3. Here is the problem. Becuase rows in the child table can have a parent in either parent table, I can not enable the constraint when creating the two relationships. This is because every row in a child table will be related to a single row in EITHER ParentTable1 or ParentTable2. Having said that, from what I understand, if you don't have a FK constraint on the child table you can not get cascading changes between the parent and child tables. So when I am updating the parents identity column it is not updating the childs 'ParentUniqueID' column to reflect the change. Is it possible to cacade changes in a dataset with relationships set up in this manner? If not, what is a good technique for updating children rows data when a parent tables row updates? Thanks for all responses in advance! Tom Tag: Late and early binding Tag: 88478
  - 11
    - Need DataGrid Help I want to "hot track" the cursor as it moves over the datagrid (highlight each row as the cursor moves), and I want to be able to select a row for editing when clicking on it. Is this possible? Tag: Late and early binding Tag: 88477
  - 12
    - IDbTransaction spanning several methods I am building a multi-tier app (similar to the design of MS PetShop). My original intention was to use MS DTC and declarative/automatic transactions, but having run into a million problems and having read some performance stats, I am at least investigating an alternative path: The BLL (Business Logic Layer) that is the transaction boundary, but would contain no transaction code other than [AutoComplete] attributes, etc, now has some knowledge of transactions. Each DAL (Data Access Layer) method has a ref IDbTransaction parameter, which they test for null and initialize if they are. This results in DAL code similar to: public void MyMethod(...., ref IDbTransaction trans) { OracleConnection conn = null; if ( trans == null ) { conn = new OracleConnection(CONN_STRING); trans = conn.BeginTransaction(); } else { conn = (OracleConnection)trans.Connection; } : OracleCommand cmd = ... cmd.Connection = conn; cmd.Transaction = (OracleTransaction)trans; : } and BLL code similar to: IDbTransaction trans = null; try { DALFactory.Create().MyMethod(..., trans); DALFactory.Create().MyOtherMethod(..., trans); } catch ( Exception e ) { IDbConnection conn = trans.Connection; trans.Rollback(); conn.Close(); throw e; } IDbConnection conn = trans.Connection; trans.Commit(); conn.Close(); Not very elegant.... I can swallow the transaction stuff in the BLL code, but I would really prefer it if I could end each DAL method with a conn.Close() as I would if I was using EnterpriseServices. Is there a more elegant solution? What happens if I call conn.Close() with a running transaction? I suppose I could try it, but I am still interested in input and suggestions on what to do. Cheers, Ola Tag: Late and early binding Tag: 88473
  - 13
    - Icon in Column Header On a WinForm application is there a way to add an icon into the column header of a datagrid? I am wanting to display a 'key' icon for the key columns of tables. Tag: Late and early binding Tag: 88472
  - 14
    - XML & Datset problem I am having big problem manipulating XML in a dataset. I am reading in a schema based on the following XML document. The minute I try to e.g. create a new row I get 'Object reference not set to an instance of an object' error <?xml version="1.0" encoding="utf-8"?> <DocumentElement xmlns="http://tempuri.org/dseditted2.xsd"> <TableInfo> <FieldName>column value</FieldName> <ControlType>column value</ControlType> <IsNull>column value</IsNull> <MaxLength>column value</MaxLength> </TableInfo> </DocumentElement> editteddataset = New DataSet() editteddataset.ReadXmlSchema("C:\Inetpub\wwwroot\xmlxconfig\dseditted2.xsd") Dim dsItem As DataRow Dim dsTable As DataTable dsTable = editteddataset.Tables("TABLEINFO") dsItem = editteddataset.Tables("TABLEINFO").NewRow Dim getcontroltype As DropDownList getcontroltype = CType(e.Item.FindControl("controltype"), DropDownList) THIS IS THE LINE OF CODE WHICH GENERATES THE ERROR dsItem("CONTROLTYPE") = getcontroltype.DataTextField What am I not understanding about XML, As I am fine when it is pulled from a database. Tag: Late and early binding Tag: 88467
  - 15
    - Oracle client not found ...- vb.net SQL*Plus works fine from te command line. Running code inside the vb.net app gives the long message at the bottom. Here is the code in question: ado_ora_con = CreateObject("ADODB.Connection") ado_ora_con.Provider = "MSDAORA" ado_ora_con.ConnectionString = "Data Source=umdw.umsystem.edu;User ID=email_directory;Password=************" ado_ora_con.Open() If ado_ora_con.State <> 1 Then MsgBox("Authentication to Oracle Failed") Exit Function End If Thanks, HankC error message=============================================================== Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [COMException (0x80004005): Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.] Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +789 Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack) +23 vanity.oracle.is_student(String site, String id) in c:\inetpub\wwwroot\inetpub\wwwroot\projects\vanity\oracle.vb:154 vanity.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\inetpub\wwwroot\projects\vanity\vanity.aspx.vb:135 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: Late and early binding Tag: 88461
  - 16
    - How make non-web app work on Local area network I have a non-web (winforms) VS dot net application that I have written using SQL Server 2000 as the back-end. This was done on a local area network with a dedicated file server. SQL Server 2000 resides on the file server and a full blown version of VS.net is on a client machine of the server. My solution resides on the local C drive. At this point in time I suppose I am doing what you would call a client/server type application in a two tier architecture. Is this Correct? So far so good. My applicaiton runs and works fine. However, I would like the application to be accessable to other machines on the network. The other machines all run Windows XP and have the dot net framework. My question has to do with the best way to do this. I suppose from the original machine I could create an .msi file, copy it to each of the other machines on the network and run it but this seems tidious. Another thought that comes to me is that instead of creating the solution on the local drive of the design machine, maybe I should create it on a shared drive of the server. Perhaps then I could compile to release mode and the other client machines could simply access the .exe that release mode creates. Is this possible and the way you do things in dot net or do I have it wrong? My guess is that at this point I would effectively have a 3-tier solution its just that the middle tier and the data tier would be considered as residing on the same machine - i.e., the file server. Any clarification would be appreciated. Tag: Late and early binding Tag: 88458
  - 17
    - ASP.NET w/ SQL Server Sessions & Cluster Failover Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State database and our application database. When the SQL Server cluster is failed-over, any "pointers" to the live connections stored in the connection pool are made invalid. When the application tries to reference these "damaged" connections, it throws an exception, and the pooling mechanism drops the bad connections from the pool. In our application, we are using a looping try/catch block to clear out the bad connections from the pool following a failover, and the users typically are not affected by the failover as a result of any exceptions in our application code. However, we don't have access to the source code for managing the ASPState connections. It appears as though there is no mechanism for the ASPState database to clear out the bad connections from the pool following a failover, and thus the exceptions are affecting users. Is SQL Server Session State Management even supposed to work with a SQL Cluster? Mike Olund OpenRoad Communications Tag: Late and early binding Tag: 88456
  - 18
    - datgrid helps those who help themselves ok - I'm not looking for a specific answer to a specific problem all I need is a push in the right direction where can I find full descriptions/usage for ALL the DATAGRID operators (ie GetVal, GetText, ...... (Visual C++ 6. thanks Tag: Late and early binding Tag: 88451
  - 19
    - DataGrid not customizing columns! Hi, I have the following code, that "should" display only one column on the datagrid from the datatable created here, but that is the theory anyway!,any comment on this would be appreicated...Thanks in advance DataTable dtCompany = new DataTable("Company") // Declare DataColumn and DataRow variables DataColumn dcolCompanyCode DataColumn dcolCompany DataColumn dcolCompanyID DataRow drowCompany // Create new DataColumn, set DataType, ColumnName and add to DataTable. dcolCompanyID = new DataColumn() dcolCompanyID.DataType = System.Type.GetType("System.Int32") dcolCompanyID.ColumnName = "CompanyID" dtCompany.Columns.Add(dcolCompanyID) // Create new DataColumn, set DataType, ColumnName and add to DataTable. dcolCompanyCode = new DataColumn() dcolCompanyCode.DataType = System.Type.GetType("System.String") dcolCompanyCode.ColumnName = "CompanyCode" dtCompany.Columns.Add(dcolCompanyCode) // Create second column dcolCompany = new DataColumn() dcolCompany.DataType = Type.GetType("System.String") dcolCompany.ColumnName = "CompanyName" dtCompany.Columns.Add(dcolCompany) // Create new DataRow objects and add to DataTable. for(int i = 0; i < dsetCompanyDetails.Tables["Table"].Rows.Count; i++ drowCompany = dtCompany.NewRow() drowCompany["CompanyCode"] = dsetCompanyDetails.Tables["Table"].Rows[i]["CompanyCode"] drowCompany["CompanyName"] = dsetCompanyDetails.Tables["Table"].Rows[i]["CompanyName"] dtCompany.Rows.Add(drowCompany) this.dgrdCompanyDetails.DataSource = dtCompany //this.dgrdCompanyDetails.DataSource=dsetCompanyDetails DataGridTableStyle ts1 = new DataGridTableStyle() ts1.MappingName = dtCompany.GetType().Name //ts1.MappingName = "dtCompany" DataGridTextBoxColumn dcolCustomerCode = new DataGridTextBoxColumn();// DataGridBoolColumn() dcolCustomerCode.HeaderText = "Company Code" dcolCustomerCode.MappingName = "CompanyCode" dcolCustomerCode.Width = 150 ts1.GridColumnStyles.Add(dcolCustomerCode) this.dgrdCompanyDetails..TableStyles.Add(ts1) Tag: Late and early binding Tag: 88444
  - 20
    - System.DllNotFoundException at OracleClient.UnsafeNativeMethods.OraMTSJoinTxn (also posted in microsoft.public.dotnet.framework.interop) I am running Windows XP Professional, Visual Studio .NET 2003, Oracle 9.2.0.1 and am trying to get automatic transactions with System.EnterpriseServices/MSDTC to work. I have set up the registry to point to, as far as I am aware, the right DLLs under HKLM\softare\microsoft\msdtc\mtxoci. I have also created the key XADLL and added a <orahome>\heteroxa9.dll. The business layer component (C# using System.Data.OracleClient) that is marked as transactional is called by an asp.net web application. The transactional class is registered with regsvcs and is visible in Component Services. The first time a method on the calling thread within the transactional component touches the database, the below exception is generated. Giving "Everyone" full access to the <orahome>\bin directory didn't help, so I do not think it is a security related problem. I have also tried to set the asp application to be in-process/out of process just to make sure that there is no problem with working directories etc (the dll in question resides and is registered in the bin directory of the web app) Any ideas? System.Exception: ? ---> System.DllNotFoundException: ? at System.Data.OracleClient.UnsafeNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) at System.Data.OracleClient.TracedNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) at System.Data.OracleClient.OciEnlistContext.Join(ITransaction transaction) at System.Data.OracleClient.OracleInternalConnection.Enlist(String userName, String password, String serverName, ITransaction transaction, Guid transactionGuid) at System.Data.OracleClient.OracleInternalConnection.ActivateForDistributedTran saction() at System.Data.OracleClient.OracleInternalConnection.Activate() at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(Str ing encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionStrin g parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() -- rest of stracktrace snipped Tag: Late and early binding Tag: 88442
  - 21
    - Oracle Parameter goes missing I have stored proc that takes 5 parameters and works fine when called from within one class, in another class i ge "ORA-06550: line 1, column 7 PLS-00306: wrong number or types of arguments in call to 'GETPEOPLE ORA-06550: line 1, column 7 PL/SQL: Statement ignored when looking with QuickWatch at the Command object its Parameters collection has all the parameters set up correctly BU StatementText for the Command object is: StatementText "begin PDCProcedures.GetPeople(p_LinkPersonID=>:p_LinkPersonID, p_PersonID=>:p_PersonID, p_Result=>:p_Result, p_ErrorMessage=>:p_ErrorMessage); end;" Strin ie it only has 4 parameters rather than 5, the middle one is missing Microsoft Oracle DataProvider, VB.NET 2002, Win2K, Oracle Server V8.174, Oracle Client 9.2.0.1. any ideas gu Tag: Late and early binding Tag: 88441
  - 22
    - HELP:Need add/update code example This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C443CB.F7F90250 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just making the transition from VB6 to .net. I've been thru the ado.net = course but still am reaching. I have a project that MUST be done quickly = and MUST be in vb.net. It's a simple routine that downloads some = fixed-length data files then updates a database. Specifically, I'm = having trouble with the code that checks for an existing record (based = on an account ID). If the record doesn't exist, then it needs to add a = new record and populate the rest of the columns. If the record does = exist then just populate the rest of the columns. Please help me to stop beating me head upon the wall with a few code = samples, please? Thanks in advance. (an email copy to rick1ryan@yahoo.com would be great also) ------=_NextPart_000_0008_01C443CB.F7F90250 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Just making the transition from VB6 to = .net. I've=20 been thru the ado.net course but still am reaching. I have a project = that MUST=20 be done quickly and MUST be in vb.net. It's a simple routine that = downloads some=20 fixed-length data files then updates a database. Specifically, I'm = having=20 trouble with the code that checks for an existing record (based on an = account=20 ID). If the record doesn't exist, then it needs to add a new record and = populate=20 the rest of the columns. If the record does exist then just populate the = rest of=20 the columns.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Please help me to stop beating me head = upon the=20 wall with a few code samples, please?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>(an email copy to <A=20 href=3D"mailto:rick1ryan@yahoo.com">rick1ryan@yahoo.com</A> would be = great=20 also)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0008_01C443CB.F7F90250-- Tag: Late and early binding Tag: 88431
  - 23
    - Creating a login function in ASP.NET using XML (visual basic) Hi. I'm trying to create a login page in asp.net using information from an XML document. (in visual basic) I've tried Rowfilter to find a cell with the 'username' and then match this with the 'Password' cell on the same row.... -> allow page to redirect if these match: If 'username' match 'password' then "redirect to next page" else "Error message" Does anyone know how to create this login function? Thank you for all help. M Tag: Late and early binding Tag: 88423
  - 24
    - Instar a record in Access Hi! When I execute a INSERT statement this error is display: "Operation must use an updateable query" The Server is a Windows 2003 The users of ASP.NET and IU_...... is in Administrators groups! The database is Access 2003. Can you help me please? This is the code: <% @Page Language = VB debug=true%> <% @Import Namespace="System.Data"%> <% @Import Namespace="System.Data.OLEDB"%> <Script Runat=Server> Sub Page_Load(sender As Object, e As EventArgs) dim cnn as oledbconnection dim cmd as oledbcommand dim tabla as string cnn = new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("datos.mdb") & ";") cmd = new oledbcommand("insert into table (field) values ('test')") cmd.connection=cnn cmd.connection.open() cmd.executenonquery() end sub </Script> Tag: Late and early binding Tag: 88421
  - 25
    - Simple question I would like to find for example If ID=1 exists in my table. In asp I used to do that with connection object: counter=connection.execute("SELECT COUNT(*) FROM table where ID=1").Fields.item(0).Value It was all in one line. What about here in asp.net. How can I get the counter? Create Stored procedure with output parameter and command object or create dataReader and read the first value? All of this is a lot of work? Thank you, Simon Tag: Late and early binding Tag: 88419
- Next
  - 1
    - Using Data Grid and ODBC dBASE Driver Hi, I'm using connection string: MyConnectionString="Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=my_dbf_folder_path" The problem is: How can I use it in DataGrid or other ways to edit\add data? I have following code: connODBC = New OdbcConnection(MyConnectionString) connODBC.Open() commODBC = New OdbcCommand("Select * from NAMES.DBF", connODBC) daODBC = New OdbcDataAdapter(commODBC) cbODBC = New OdbcCommandBuilder(daODBC) dsODBC = New DataSet("X") 'daODBC.Fill(dsODBC, "XX") dg.SetDataBinding(dsODBC, "XX") It correctly displays table Names.DBF in my DataGrid (dg). What should I add to this code to make available edit/add? Thanks, Tomek Tag: Late and early binding Tag: 88417
  - 2
    - Optimising Connections & DataAdapters Hi, I just read the following in an old NG thread: "when you use the adapter with a closed connection it will open it, do your requested database access, and close it immediately. If you use the adapter with an open connection the connection will continue to be open after the adapter is done." My DataLayer makes extensive use of DataAdapters to fill DataSets, and currently each DataLayer function creates its own, new, SqlConnection, and I do not explicitly open/close the SqlConnection, as the DataAdapter takes care of that. As a result of reading the above quote, I think I can improve performance by better use of SqlConnections. Specifically, I'm now thinking about manually opening an SqlConnection at the beginning of a DataLayer function before filling the DataSet, so that I have the option of passing the still-open connection to another function where it could be used to fill another DataSet, before passing this still-open connection back to the original function to be manually closed. Would this be (much?) more efficient than each separate function creating a new SqlConnection? Would such an approach create any new problems? Thanks, JON PS Also: can anyone compare the performance of re-opening an existing-but-closed SqlConnection with the cost of creating and opening a brand new one? Tag: Late and early binding Tag: 88416
  - 3
    - using(SqlConnection = ... ) ? I've noticed that if I use a statement lik using(StreamWriter sw = new StreamWriter(@"c:\filetowriteto.txt") {... then the file gets released at the end of the using statement block However if I use this on a database connection using(SqlConnection cndb = new SqlConnection(@"....") {... then unless I explicitly call Close, it doesn't close it. Certainly not with SQ server connections anyway, they're still visible in Enterprise manager unti you call close What is it with IDisposable - what does it actually DO? Is there any goo description of what resources it frees and what it doesn't Can you derive from it to define exactly what resources you want to free Tag: Late and early binding Tag: 88415
  - 4
    - Oracle data access: .NET System.Data.OracleClient or Oracle ODP.NET? Hi, all anyone knows which are the diferences in performance and funcionality terms between .NET system.data.OracleClient provider and Oracle ODP.NET Thanks in advance! Tag: Late and early binding Tag: 88414
  - 5
    - Dealling With Constraint Errors First create a typed-dataset with an integer ID primary-key field and a string Name field. Then create a form with a datagrid and a reference to the dataset on it. set the grids datasource to dataset1.table1. If you then enter 1 and Me on the first line, all is OK. If you enter 1 and Me2on the second line, you get the following error: "Error when committing the row to the original datastore" - "Column ID is constrianed to be unique, Value 1 is already present. Do you want to correct the value? Yes/No. I would like to put my own message up for the user or do something else, but I cant seem to find a way to hook into this internally-handled ADO.NET error. Any answers would be greatfully received. Tag: Late and early binding Tag: 88404
  - 6
    - Mixing ADO.NET transactions and Stored Procedure Transactions Hi there, I'm writing an application that calls a number of updates to a SQL Server database, wrapped in an ADO.NET transaction. One of the stored procedures implements T-SQL transactions - what i was wondering is if the T-SQL encounters an error and ROLLBACK TRANSACTION is called, will the fact that this error has occurred pass back to the ADO.NET transaction so that the other updates are rolled back too? or will it be suppressed? Do i need to call a RAISERROR in my T-SQL error trapping routine to make this work? My current ADO.NET code looks like this: using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlTransaction theTran = conn.BeginTransaction(); try { SqlDataAdapter da = new SqlDataAdapter(); // do first tran from command calling stored proc sqlCommand1.Connection = conn; sqlCommand1.Transaction = theTran; da.UpdateCommand = sqlCommand1; da.Update(theTable); // do second tran from command calling stored proc - if this // stored proc has transactions and fail will this raise an // error and rollback all the transactions? sqlCommand2.Connection = conn; sqlCommand2.Transaction = theTran; da.UpdateCommand = sqlCommand2; da.Update(theTable); theTran.Commit(); } catch { theTran.Rollback(); } conn.Close(); } the error trapping bit of the SQL proc looks like this: BEGIN TRANSACTION INSERT INTO StockLevels (fielda, fieldb) VALUES (@fielda, @fieldb); IF @@ERROR <> 0 BEGIN ROLLBACK TRANSACTION -- if this gets called will ADO.NET know about it and rollback? RETURN -1 END INSERT INTO StockTransaction (field1, field2) VALUES (@field1, @field2); IF @@ERROR <> 0 BEGIN ROLLBACK TRANSACTION return -1 END COMMIT TRANSACTION RETURN 1 Hope this makes sense!!! Many thanks James Tag: Late and early binding Tag: 88402
  - 7
    - HELP: Concurrency violation exception and IDENTITY columns Hello, I'm getting "Concurrency violation: DeleteCommand affected 0 records" exception when trying to update or delete newly created record. I use SQL Server 2000 database and tables with Auto-incrementing (IDENTITY) Primary Keys. I've read number of Google posts: http://groups.google.com.au/groups?hl=en&lr=&ie=UTF-8&threadm=O45fN8R3CHA.1828%40TK2MSFTNGP09.phx.gbl&rnum=2&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26q%3Ddelete%2Baffected%2B0%2Brecords and MSDN articles: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconRetrievingIdentityOrAutonumberValues.asp about similar problems. Most of them, suggest to use something like "SET @Identity=SCOPE_IDENTITY()" after the INSERT statement to retrieve newly created PK back to the DataSet. I've tried it many times, but doesn't seem to work for me. Here is my code (sorry for the word-wrap): m_SQL = "select teamid, projectid, playerid, jobroleid, createddate, createdby from teams" m_daTeam = New SqlDataAdapter(m_SQL, m_con) ' Dim cmdTeamInsert As New SqlCommand cmdTeamInsert.CommandText = "InsertTeam" cmdTeamInsert.CommandType = CommandType.StoredProcedure cmdTeamInsert.Connection = m_con cmdTeamInsert.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ProjectID", System.Data.SqlDbType.Int, 4, "ProjectID")) cmdTeamInsert.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PlayerID", System.Data.SqlDbType.Int, 4, "PlayerID")) cmdTeamInsert.Parameters.Add(New System.Data.SqlClient.SqlParameter("@JobRoleID", System.Data.SqlDbType.Int, 4, "JobRoleID")) cmdTeamInsert.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreatedDate", System.Data.SqlDbType.DateTime, 4, "CreatedDate")) cmdTeamInsert.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreatedBy", System.Data.SqlDbType.NVarChar, 50, "CreatedBy")) Dim insertPrm As New SqlParameter insertPrm = cmdTeamInsert.Parameters.Add("@TeamID", SqlDbType.Int, 0, "TeamID") insertPrm.Direction = ParameterDirection.Output m_daTeam.InsertCommand = cmdTeamInsert ' Dim cmdTeamDelete As New SqlCommand cmdTeamDelete.Connection = m_con cmdTeamDelete.CommandText = "DELETE FROM Teams WHERE (TeamID = @Original_TeamID) AND (CreatedBy = @Original_CreatedBy OR @Original_CreatedBy IS NULL AND CreatedBy IS NULL) AND (CreatedDate =@Original_CreatedDate OR @Original_CreatedDate IS NULL AND CreatedDate IS NULL) AND (JobRoleID = @Original_JobRoleID) AND (PlayerID = @Original_PlayerID) AND (ProjectID = @Original_ProjectID)" cmdTeamDelete.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TeamID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "TeamID", System.Data.DataRowVersion.Original, Nothing)) cmdTeamDelete.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CreatedBy", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CreatedBy", System.Data.DataRowVersion.Original, Nothing)) cmdTeamDelete.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CreatedDate", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CreatedDate", System.Data.DataRowVersion.Original, Nothing)) cmdTeamDelete.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_JobRoleID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "JobRoleID", System.Data.DataRowVersion.Original, Nothing)) cmdTeamDelete.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PlayerID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PlayerID", System.Data.DataRowVersion.Original, Nothing)) cmdTeamDelete.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ProjectID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ProjectID", System.Data.DataRowVersion.Original, Nothing)) m_daTeam.DeleteCommand = cmdTeamDelete ' m_daTeam.TableMappings.Add("Table", "Team") m_daTeam.Fill(m_DataSet) Here is the code to add a new record. it's pretty basic: myRow = m_DataSet.Tables("Team").NewRow myRow.Item("ProjectID") = intProjectID myRow.Item("PlayerID") = intPlayerID myRow.Item("JobRoleID") = intJobRoleID myRow.Item("CreatedBy") = strUsername myRow.Item("CreatedDate") = Now m_DataSet.Tables("Team").Rows.Add(myRow) and to save the changes i use standard Update method of my data adapter: m_daTeam.update(m_DataSet.Tables("Team")) and here is my InsertTeam stored procedure: CREATE PROCEDURE InsertTeam @ProjectID int, @PlayerID int, @JobRoleID int, @CreatedDate datetime, @CreatedBy nchar(50), @TeamID int OUT AS INSERT INTO Teams(ProjectID, PlayerID, JobRoleID, CreatedDate, CreatedBy) VALUES (@ProjectID, @PlayerID, @JobRoleID, @CreatedDate, @CreatedBy) SET @TeamID = SCOPE_IDENTITY() The "Add New" process goes well, the new record is created in the database. Here is the trace from SQL Profiler: declare @P1 int set @P1=32225 exec InsertTeam @ProjectID = 7, @PlayerID = 3, @JobRoleID = 2, @CreatedDate = 'May 27 2004 12:00:00:000AM', @CreatedBy = N'test', @TeamID = @P1 output select @P1 But when i check my DataSet, the TeamID for newly created record is still System.DbNull. So, obviously, when I delete or change this record and then try to save changes, DataAdapter.Update method throws "Concurrency violation" exception. I've been trying to fix this problem for almost 2 days now. I don't see what i'm doing wrong. Please, help! Thanks and regards, Dmitri Tag: Late and early binding Tag: 88388
  - 8
    - Conversion problem SqlDBType.Decimal -> T-SqlType Decimal (12,6) This is a multi-part message in MIME format. ------=_NextPart_000_0034_01C443C4.8FAD8060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I want to call a stored procedure containing a decimal parameter: SqlCommand dbCommand =3D new SqlCommand("myStoredProcedure", = myConnection); dbCommand.CommandType =3D CommandType.StoredProcedure; SqlParameter parmTOHighShort =3D = dbCommand.Parameters.Add("@dTOHighShort", SqlDbType.Decimal, 9); parmTOHighShort.Direction =3D ParameterDirection.Input; parmTOHighShort.Value =3D dataObject.TOHighShort; try { dbCommand.ExecuteNonQuery(); } catch (Exception e) { int i =3D 0; } in the stored procedure this parameter is specified as follows: CREATE PROCEDURE dbo.[myStoredProcedure]( @dTOHighShort AS DECIMAL = (12,9) ) =20 AS .... this does not work because the SqlDBType.Decimal do not specify any = precision, but the T-Sql data type does! Do any one know how to solve this problem ? Regards, P@rick ------=_NextPart_000_0034_01C443C4.8FAD8060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial><FONT size=3D2><FONT face=3DArial=20 size=3D2></FONT></FONT></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I want to call a stored procedure = containing a=20 decimal parameter:</FONT></DIV> <DIV><FONT face=3DArial><FONT size=3D2><FONT face=3DArial=20 size=3D2></FONT></FONT></FONT> </DIV><FONT size=3D2> <DIV><FONT face=3DArial>SqlCommand dbCommand =3D </FONT></FONT><FONT=20 face=3DArial><FONT color=3D#0000ff size=3D2>new</FONT><FONT size=3D2>=20 SqlCommand(</FONT><FONT color=3D#ff0000=20 size=3D2>"myStoredProcedure"</FONT></FONT><FONT size=3D2><FONT = face=3DArial>,=20 myConnection);</FONT></DIV> <DIV><FONT face=3DArial>dbCommand.CommandType =3D=20 CommandType.StoredProcedure;</FONT></DIV></FONT> <DIV><FONT face=3DArial size=3D2>SqlParameter parmTOHighShort =3D=20 dbCommand.Parameters.Add("@dTOHighShort", SqlDbType.Decimal, = 9);</FONT></DIV> <DIV><FONT face=3DArial size=3D2>parmTOHighShort.Direction =3D=20 ParameterDirection.Input;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>parmTOHighShort.Value =3D=20 dataObject.TOHighShort;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>try</FONT></DIV> <DIV><FONT face=3DArial size=3D2>{</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>dbCommand.ExecuteNonQuery();</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT face=3DArial size=3D2>catch (Exception e)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>{</FONT></DIV> <DIV><FONT face=3DArial size=3D2>int i =3D 0;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>in the stored procedure this parameter = is specified=20 as follows:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>CREATE PROCEDURE = dbo.[myStoredProcedure](=20 @dTOHighShort AS DECIMAL (12,9) )<BR>   <BR>AS</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>....</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>this does not work because the = SqlDBType.Decimal do=20 not specify any precision, but the T-Sql data type does!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Do any one know how to solve this = problem=20 ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>P@rick</FONT></DIV></BODY></HTML> ------=_NextPart_000_0034_01C443C4.8FAD8060-- Tag: Late and early binding Tag: 88386
  - 9
    - Dynamically determining C# data types from empty Database tables I have sucessfully used Reader.GetSchemaTable() to dynamically discover C# types from populated database tables. However, I need to determine the C# data type for the columns of empty tables in order to populate them. I have attempted to use GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] {null, null, table.getTableName(), null}); However, the type returned in the schemaTable is a number and cannot be cased to a C# Type. In additions, I haven't discovered a way to map the number to the C# Type. Is there a way to predetermine the C# type or map the type number into the correct C# type. Tag: Late and early binding Tag: 88383
  - 10
    - Avoid sort on SELECT command SQL "SELECT" (via Ado.net) gives results in sorted order by default. IOW, "ORDER BY" is turned on by default (seems to use the primary key). I'd like to retrieve rows in the order that I originally inserted them. Is there any way to turn off the default sort? VJ PS: I've hex-dumped the data file, and confirmed that the rows are not pre-sorted inside the database. Tag: Late and early binding Tag: 88382
  - 11
    - Insert New Column at a specific place Hi How to insert a new column in a Access table at a specific place using SQL If I use the following instruction a got my new column at the end of table ALTER TABLE Customer ADD COLUMN column2 LONGCHA The result column column column I'd like the result folling result: column column column Thanks Kleber Muffat Campinas-Brazi Tag: Late and early binding Tag: 88381
  - 12
    - checking for null parameter values HI There, How can I check to see if the parameter is returning null? I have tried many other legacy asp ways of doing things but nothing is working. Could smeone help me out with my code. Sean if myCommand.Parameters("@errmsg1").value ="" Then do something else do something else end if Tag: Late and early binding Tag: 88376
  - 13
    - Sorting datagrid-dataview-datatable datagrid is bound to dataview. the rows will sort when clicking on datagrid column headers.. however, selecting a row after sort reveals that the datatable still maintains original order. rows were not sorted. how do i ensure underlying datatable gets sorted with datagrid sort thank Tag: Late and early binding Tag: 88373
  - 14
    - How to get the value of autoincrement field from Database in dataset on client Hello, I have a dataset which I populate from a table containing a Identity (autoincrement) field. Now this dataset is received on client offline. While offline I add a record in the table and when user click save button, I send the updated dataset (GetChanges()) to the server where I use dataadapter.update(ds) after setting the selectcommand. This insert the new record in database and the autogenerated column gets a new value, but this value is not on the client side dataset. Now if I update the same record that I added in above description and send this updated dataset to server (when user click save button) since the id in dataset is not on server DB, so it throws a concurrency violation. How can I resolve this issue? After every update I do not want to get all the data back from server and populate the client screen again, there should be some way by which I can get the exact Id of autoincrement field on client side. Also note that user can insert multiple records before sending the dataset to the server. ------------------------------------------------------ Code to save on the server ------------------------------------------------------ Try objTrans = Me.ActiveConnection.BeginTransaction() da = New SqlDataAdapter Dim cb As SqlCommandBuilder da.SelectCommand = New SqlCommand("SELECT EstimateId, DiscountOnProspectivePrice, DiscountOnBillingPrice FROM X", Me.ActiveConnection, objTrans) cb = New SqlCommandBuilder(da) da.Update(dsEstimate, "x") da.SelectCommand = New SqlCommand("SELECT EstimateId, VendorId FROM Y", Me.ActiveConnection, objTrans) cb = New SqlCommandBuilder(da) da.Update(dsEstimate, "y") '************************* CommodityId is Identity Field in Table Z ******************************************* '*********When Inserted I need the autoincremented value of CommodityId and use it on the client ************************ da.SelectCommand = New SqlCommand("SELECT CommodityId, EstimateId FROM Z", Me.ActiveConnection, objTrans) cb = New SqlCommandBuilder(da) '***************** Updating the second time gives error on below line ****************************************** da.Update(dsEstimate, "z") objTrans.Commit() ' ----------------------------------------------------------------- Catch exSql As SqlException objTrans.Rollback() ProcessException.HandleSQLException(exSql) Catch exGet As Exception objTrans.Rollback() ProcessException.HandleGeneralException(exGet) End Try Thanks, Ashish Tag: Late and early binding Tag: 88371
  - 15
    - Am I blind? UpdatedRowSource Hello all, I'm coding with a typed dataset and adapters. I cannot get the AutoIncrement to be updated to the dataset. Any help would be gratelly appreciated. Thanks / jorge Check this out: The TypedDataSet includes: table1 ---------------- 8< ----------------------- <xs:element name="PolicyID" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" msdata:AutoIncrementSeed="-1" type="xs:int" /> ---------------- 8< ----------------------- table2 ---------------- 8< ----------------------- <xs:element name="PolicyID" type="xs:int" /> ---------------- 8< ----------------------- relations and contraints: ---------------- 8< ----------------------- <xs:unique name="PricePolicyDataSetKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Policy" /> <xs:field xpath="mstns:PolicyID" /> </xs:unique> ---------------- 8< ----------------------- <xs:keyref name="PolicyHasPeriods" refer="PricePolicyDataSetKey1"> <xs:selector xpath=".//mstns:Period" /> <xs:field xpath="mstns:PolicyID" /> </xs:keyref> ---------------- 8< ----------------------- Code: SqlDataAdapter adapter = new SqlDataAdapter("SELECT PolicyID, --- 8< --- FROM pasPolicy", transaction.Connection); SqlCommandBuilder builder = new SqlCommandBuilder(adapter); builder.RefreshSchema(); adapter.SelectCommand.Transaction = transaction; adapter.InsertCommand = builder.GetInsertCommand(); adapter.InsertCommand.CommandText += "; SELECT SCOPE_IDENTITY() AS PolicyID"; adapter.InsertCommand.UpdatedRowSource = UpdateRowSource.Both; adapter.Update(policy.Policy); policy.Policy.AcceptChanges(); Tag: Late and early binding Tag: 88369
  - 16
    - unspecified error when using access i have and asp.net application that uses an access database i use dbcom for database application for ex Imports Syste Imports System.Dat Imports System.Data.OleD Imports System.Configuratio Namespace Intranet.Common.Data.Access.Co Public Class dbco Implements IDisposabl #Region "Private Fields 'connection to data sourc Private con As OleDbConnectio 'Error Message fiel Private _errorMessage As Strin #End Regio #Region "Public Properties Public ReadOnly Property ErrorMessage() As Strin Ge Return _errorMessag End Ge End Propert Public Shared ReadOnly Property ConnectionString() As Strin Ge 'Return System.Configuration.ConfigurationSettings.AppSettings("Database.DEFAULT_CONNECTION_STRING" Return System.Configuration.ConfigurationSettings.AppSettings ("ConnectionString" End Ge End Propert #End Regio #Region "Public Method Implementations ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 'This function takes a stored proc name and returns an integer 'by invoking ExecuteScalar() on the OleDbCommand type instance ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Public Function RunProcedure(ByVal procName As String) As Intege Dim result As Intege Dim cmd As OleDbComman Tr cmd = CreateCommand(procName, Nothing result = CType(cmd.ExecuteScalar(), Integer Catch e As Exceptio result = - _errorMessage = e.Messag Finall Me.Close( End Tr Return resul End Functio ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 'This function takes a stored proc name, sql parameters returns an integer 'by invoking ExecuteScalar() on the SqlCommand type instance ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Public Function RunProcedure(ByVal procName As String, ByVal prams As OleDbParameter()) As Intege Dim result As Intege Dim cmd As OleDbComman Tr cmd = CreateCommand(procName, prams result = cmd.ExecuteScalar( Catch e As Exceptio result = - _errorMessage = e.Messag Finall Me.Close( End Tr Return resul End Functio ......................................End Namespac i use these i Imports Syste Imports System.Dat Imports System.Data.OleD Imports System.Configuratio Imports Alliance.Intranet.Common.Data.Access.Co Namespace Intranet.Common.Business.Logic.Co Public Class CustomerBi Implements IDisposabl #Region "Private Fields 'connection to data sourc Private con As OleDbConnectio 'Error Message fiel Private _errorMessage As Strin #End Regio #Region "Public Properties Public ReadOnly Property ErrorMessage() As Strin Ge Return _errorMessag End Ge End Propert Public Shared ReadOnly Property ConnectionString() As Strin Ge 'Return System.Configuration.ConfigurationSettings.AppSettings("Database.DEFAULT_CONNECTION_STRING" Return System.Configuration.ConfigurationSettings.AppSettings ("ConnectionString" End Ge End Propert #End Regio #Region "Public Method Implementations '******************************************************************** ' CheckLogin Metho ' The CheckLogin method reads a user login and password and check ' to see if it is in the database '********************************************************************* Public Shared Function CheckLogIn(ByVal PlayerGameName As String, ByVal PlayerPassword As String) As OleDbDataReader ' Dim ObjReturnDR As OleDbDataReader Dim params(1) As OleDbParameter Dim db As New dbcom params(0) = db.MakeParameter("@PlayerName", PlayerGameName) params(1) = db.MakeParameter("@PlayerPassword", PlayerPassword) db.RunProcedure("sp_Player_CheckLogin", params, ObjReturnDR) If ObjReturnDR Is Nothing Then Throw New Exception(db.ErrorMessage) End If Return ObjReturnDR End Function i use similar code to insert into tables i can insert 6 records into a table and then i get unspecified error it is not always at the same spot in the code it can and will be in different functions any ideas this is not a big database and right now i am the only one using it(trying to test it) so there are not concurrent users Tag: Late and early binding Tag: 88367
  - 17
    - Need SqlDataAdapter never to time out while running selects Is there a way to make SqlDataAdapter not to time out while running the select to fill the ds? What is the current setting for timeout on SqlDataAdapter? Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Late and early binding Tag: 88358
  - 18
    - Iterating through a datarelation's rows This is what I get for trying to do things the ADO.NET way instead of using plain ol ADO.. Anyway, I have two related tables. I've finally hooked em up so that they're in synch, but now I need to be able to iterate through the child table's rows, and I can't figure out how. For instance, with a single table I can do thus (adding rows to a treeview): For i = 0 To DsEnt1.R_Relations.Count - 1 nd = tvClient.Nodes.Add(DsEnt1.R_Relations(i).Name_Last) Next But If there is a datarelation named "E_ClientR_Relations" in my E_Client table, how come I can't do: For i = 0 to DsEnt1.E_Client.E_ClientR_Relations.Count - 1 ... I can't seem to find the relation anywhere enumerated so I can loop through it. Brian Link, Minnesota Countertenor ---------------------------------- "I think animal testing is a terrible idea; they get all nervous and give the wrong answers." - regmech Tag: Late and early binding Tag: 88357
  - 19
    - Timeout / Obtaining a connection from the pool - Please Help! Dear Group I'm desperate for a solution to this problem. Let's assume I've the following code: Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Dim sqlConnection As New System.Data.SqlClient.SqlConnection sqlConnection.ConnectionString = "workstation id=THEINTREPIDFOX;packet size=4096;user id=sa;data source=""(local)"";p" & _ "ersist security info=False;initial catalog=TestDB" sqlConnection.Open() sqlConnection.Close() sqlConnection = Nothing End Sub When I click 100 times on the button the page finally times out with: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Of course I could increase the max pool size but this isn't the solution to this problem. I wonder what's wrong with my code? According to MSDN, if the connection is closed it's released back into the pool. Also tried to dispose but nothing helps. It looks like that it keeps connections and doesn't release them. I'm grateful for any hints, ideas, suggestions on this problem as I'm very desperate to solve this. Thanks very much for your time & efforts! Martin Tag: Late and early binding Tag: 88352
  - 20
    - What is a "strongly typed dataset"? I have seen this mentioned several times, but I have not yet found a comprehensive definition for the term. One reference that I saw indicated that intellisense would work better with such a beast, but with no explanation of how or why. -Ken Tag: Late and early binding Tag: 88349
  - 21
    - DataGrid doesn't display changes ??? Hi, using a DataGrid : I set the TableStylesCollection and GridColumnStyles at designtime .. map to a DataSource and everything .. but the Datagrid doesn't use those settings (not at design-time nor at runtime) ??? It always uses the default layout being : showing all the columns that are available in the DataSet it is bound to. What am I doing wrong ? If I set the TableStylesCollection and GridColumnStyles at runtime (setting the DataGrid styles in code) then it works when I run the program. Thanks Chris Tag: Late and early binding Tag: 88346
  - 22
    - Data Connections into dBase files Hi, Please help me with Data Connections into dBase files. I have catalog with lot of files like *.dbf and *.mdx . Every file contains one table (I can see it in MS Access). How can I make connections into this/that folder/files in VB.NET project? Tomek Tag: Late and early binding Tag: 88344
  - 23
    - problem creating a database details page Hi, I have two webforms, form1.aspx which creates a datagrid with hyperlinks to a form2,aspx which I want to display details for the selected database entry. So far, using Visual Studio to Build Properties of the datagrid, I've successfully set up a datagrid in form1.aspx that creates a list of hyperlinks of the form: form2.aspx?ID=1 form2.aspx?ID=2 etc So now I need to set up form2.aspx that receives the ID parameter, creates a new dataset of all the column values for that database row, and puts them into page full of labels that are bound to the value that is associated with that ID for each column C1, C2, C3 etc. I guess the format would be something like: lblC1.Text.DataBindings.Add("Text", DataSet21, C1) lblC2.Text.DataBindings.Add("Text", DataSet21, C2) etc? I've tried creating a dataset with the SQL "SELECT * FROM DB WHERE ID=@ID" but I get the runtime error: "Prepared statement '(@ID nvarchar(255))SELECT * FROM DB' expects parameter @ID, which was not supplied." Any help on this would be much appreciated. Thanks, Graham Tag: Late and early binding Tag: 88342
  - 24
    - Search a DataTable on a byte[] field I am using a DataTable (dt) based on a SQL Server table containing a column of type varbinary(50) named descriptor. The DataTable column for this field is base64Binary, which seems to map to System.byte[]. I then defined a DataView (dv) with dv.Sort="descriptor". I find that if I have a byte[] variable bArray, then dv.FindRows(bArray) always matches all the rows of dv and dv.Find(bArray) always returns 0 (unless dt.Rows.Count=0). I don't understand this behavior I can do a manual search by using for(int i=0; i<dt.Rows.Count; i++) if ((new SqlBinary(byte[] dt.Rows[i]["descriptor"]))==(new SqlBinary(bArray)) .. But I would like to use a DataView. Is there any way to do this John Kane Tag: Late and early binding Tag: 88338
  - 25
    - Best Practices Hi. I asked this question on another newsgroup, but with no luck.. I'm doing a .Net conversion project. Before, I was using VB6.0 and Oracle for a 3 tier architecture. An important part of the conversion is moving a large number of Oracle stored procedure to VB.NET; the reason is that they containt too much business logic. This is an example of how a stored procedure looked like: BEGIN define cursor 1 define cursor 2 define cursor 3 validate inputs open cursor 1(with input arguments) open cursor 2(with input arguments) if cursor 1 column(x) <> cursor 2 column(y) raise error open cursor 3(with input and cursor 2 column(y) arguments) if cursor 3 column(z) is null then insert into some_table if cursor 3 column(w) is null then set some output variables set some output variables END What is the best way to write this in a VB.NET function/procedure? Should I use datasets or should I use datareaders? Should I execute the select statements (the cursors) at the beginning of the function, or should I execute them in the "middle" of the function? Do I use the same datareader for all the select statements (eg call ExecuteReader on the same datareader with different command object - or maybe the same command object with a different command string)? Should I use stored procedures for selecting, inserting and deleting from the database instead of doing it from the function? How do I deal with nulls? Maybe I'm not asking all the right questions, so I would appreciate, if someone knows a complex example on the internet that is similar to what I'm asking, to share the link. Thanks. TibM Tag: Late and early binding Tag: 88336

Hi,

Does it make difference to do early or late binding in ADO.net?

MTIA,
Grawsha

Re: Late and early binding by Miha

Miha
Fri May 28 03:30:53 CDT 2004

Huh?
Are you refering to strong typed datasets?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"al" <grawsha2000@yahoo.com> wrote in message
news:66edfd3c.0405272344.af8f49e@posting.google.com...
> Hi,
>
> Does it make difference to do early or late binding in ADO.net?
>
>
> MTIA,
> Grawsha

Top

Re: Late and early binding by William

William
Fri May 28 06:02:03 CDT 2004

Grawhsa:

I'll go out on a limb here and say that it always makes a difference whether
you use Early binding vs late bindging and late binding usually loses the
battle. On the other hand in the context of ADO.NET, you may be talking
about DataBinding controls which is totally different than what is
traditionally referred to by late binding vs early binding. If this is what
you are talking about, AFAIK, then when you set the bindings isn't the
issue - but I think knowing what you are referring to by binding is an
important issue, b/c if you know enough to ask about early vs late binding ,
you probably know why late binding is less attractive.

HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/
"al" <grawsha2000@yahoo.com> wrote in message
news:66edfd3c.0405272344.af8f49e@posting.google.com...
> Hi,
>
> Does it make difference to do early or late binding in ADO.net?
>
>
> MTIA,
> Grawsha

Top

Re: Late and early binding by Patrice

Patrice
Fri May 28 08:36:23 CDT 2004

It's always different. Probably not very well explained but basically :
- Early binding is to know the type of an object at compile time. The
compiler have all the needed element at compile time to build the call into
the excutable code (resolution of calls at compile time)
- With late binding, the type of an object is known only at runtime. It will
need extra instructions to find out where is the method to be called (if it
exists) before calling it (resolution of calls at runtime)

"al" <grawsha2000@yahoo.com> a écrit dans le message de
news:66edfd3c.0405272344.af8f49e@posting.google.com...
> Hi,
>
> Does it make difference to do early or late binding in ADO.net?
>
>
> MTIA,
> Grawsha

Top