Data Access Application block and COM+

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
    - claim your Live Internet training session today. Do you want to attend a LIVE Internet classroom with us? www.velocitystudy.com is offering 100 IT students a free introductory training session. Please visit www.velocitystudy.com to register for you introductory session. Tag: Data Access Application block and COM+ Tag: 88826
  - 2
    - Problems with reading data from excel sheet: Some values are null Hi, I've got an excel sheet in which i define some kind of matrix. This looks this way A B C D E F G ID 12345 FROM/TO 1 2 3 4 5 6 1 0 3 3,5 0 2,3/4 0 2 7,9/3,6 0 1,2 0 1 1 3 0 0 0 4 0 2 4 1 0 1,2/4 0 1 2 5 2 2,4 1 0 0 6 6 1/5 0 0 0 0 0 I'm trying to read that sheet into a dataset via ado.net in a c# windows application as descripted in the MSDN Article http://msdn.microsoft.com/library/en-us/dnadonet/html/odatanet2.asp?frame=true . But when I'm displaying my dataset in a datagrid some values are null: ID 12345 (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) FROM/TO 1 2 3 4 5 6 1 0 3 3,5 0 2,3/4 (null) 2 7,9/3,6 0 1,2 0 1 1 (null) (null) (null) (null) 4 0 2 (null) (null) 0 1,2/4 0 1 (null) (null) (null) (null) 1 0 0 6 (null) (null) (null) 0 (null) 0 0 All cells in the excel sheet are defined as text. I don't see any pattern behind this behaivor. Does anyone here knows something about this issue? Thanks in Advance Markus Tag: Data Access Application block and COM+ Tag: 88825
  - 3
    - MDAC Dependency I understand that ADO.Net has some dependency on MDAC 2.6 or later (from MSDN documentation). Please correct me for the following: "If I am going to use either System.Data.SqlClient OR System.Data.OracleClient namespaces for data access, as they directly communicate with database (without the support of respective OLE-DB drivers), MDAC dependency can be avoided" -- Rao TRN Tag: Data Access Application block and COM+ Tag: 88820
  - 4
    - Updating datasets with parent child relationships - 320301 I have used KB article: 320301 (http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;320301&product=vcSnet) as as reference to update datsets with nested relationships. So far it works great for the case of a simple parent-child relationship between two tables in a dataset. I have a couple of questions: -Is this a temporary work-around until a permanent solution is provided? -Is there any negative impact on using this code example to handle relationships of higher depth than parent-child relationship? For example, lets say you have a table named "UnemploymentClaim" that has a child named "worker" that has a child table named "address" that has a child table named "zipCodes". (I know I am reaching here, but hopefully you get the point). The question here is will the same methodology that is used in KB article 320301 work for the relationships that I described? I would really appreciate any input on this matter because I am looking into using this on a larger scale... Thanks, Bill Tag: Data Access Application block and COM+ Tag: 88817
  - 5
    - ado.net not retrieving updated records I have an asp.net application which allows users to search, create and update records in a SQLServer2000 DB. Search results are displayed in a datagrid The problem is after a record is updated or created and the datagrid refreshed by the user, the newly updated record doesn't display in the search results. The datagrid itself is definately refreshing as the record that has been updated disappears completely If I close and open the browser and do a new search the record appears Any db connections I open I have closed in a finally block and the dataset I use to populate the datagrid is NOT held in session Any ideas? Tag: Data Access Application block and COM+ Tag: 88815
  - 6
    - Why does my Dataview NOT work!!! Me.SqlDataAdapter1.Fill(Me.vdsVehicle) Dim dt As New DataTable dt = Me.vdsVehicle.Tables(0) Dim dv As New DataView(dt) dv.RowFilter = "VehicleYear = '1985'" both the Dataset and the Dataview still have three records. It is not filtered down to ONE record like it should be. Why?? Tag: Data Access Application block and COM+ Tag: 88803
  - 7
    - RowFilter on Time values I have a table in a SqlServer database which contains a couple of DateTime fields, 'StartTime' and 'EndTime'. These fields are only used to store time, not date. Since I don't specify any date information, all the records have '1/1/1900' for their date. Once I've loaded all the records into a DataView, I would like to be able to filter the records by StartTime and EndTime. The time value I want to filter on is stored in a TimeSpan variable. Apparently, you can't compare DateTime values directly to TimeSpan values in a RowFilter, so I wind up doing something like this: DateTime date = new DateTime(time.Ticks); DataView1.RowFilter = "(date > StartTime) AND (date < EndTime)"; Unfortunately, the .NET DateTime class starts at '1/1/0001'. So my filter looks something like this: "('1/1/0001 6:00AM' > '1/1/1900 6:00AM') AND ('1/1/0001 8:00PM' > '1/1/1900 8:00PM)" Which never returns any results, of course. What I want to do is JUST compare two time values. Is there an easy way to do this? TIA, Gabe Tag: Data Access Application block and COM+ Tag: 88802
  - 8
    - Typed DataSet in code... Can a typed DataSet be made in code so that code that comes after the type code will pick up on the dataset's table structure for intellisense? Tag: Data Access Application block and COM+ Tag: 88801
  - 9
    - Typed DataSet creates extra tags in the XML output. Two DataSets loaded with the same XML data and schema write two different XML data files. Bellow youâ??ll find a simple test code and the output. Declare, instantiate and load the DataSets: Dim dsOrig As New DataSet("Request") Dim dsDup As New DataSet("Request") Dim filePath As String filePath = " PVIrequest.xml" dsOrig.ReadXml(filePath) dsOrig.WriteXmlSchema("Test.xsd") dsDup.ReadXmlSchema("Test.xsd") dsDup.ReadXml(filePath) Edit the first DataSet and Write XML: Dim swXML As New System.IO.StringWriter With dsOrig Dim rwEdit As DataRow rwEdit = .Tables("eCommerce").Rows(0) rwEdit.BeginEdit() rwEdit("action") = "Test" rwEdit.EndEdit() .WriteXml(swXML) TextBox1.Text = swXML.ToString â??See bellow <eCommerce version="1.1" action="Test"><Requestor><ID>value</ID><Password>*******</Password></Requestor><Shipment action="GenerateLabel" version="1.0"> Complex Type data </Shipment></eCommerce> Edit the second DataSet and Write XML: Dim swXML As New System.IO.StringWriter With dsDup Dim rwEdit As DataRow rwEdit = .Tables("eCommerce").Rows(0) rwEdit.BeginEdit() rwEdit("action") = "Test" rwEdit.EndEdit() .WriteXml(swXML) TextBox1.Text = swXML.ToString â??See bellow <Request><eCommerce version="1.1" action="Test"><Requestor><ID>PENTA_0608</ID><Password>57ID57C7UH</Password></Requestor><Shipment action="GenerateLabel" version="1.0"> Complex Type data </eCommerce></Request> I need to get rid of the extra tags (the DataSet name). I thank Cowboy for his Xml Transform suggestion, but I would like to know what am I missing with my approach? As I mentioned in my previous cry for help, my way around it was to create doc as an XmlDataDocument(dsDup) and call doc.SelectSingleNode("/Request") function. I hope that this message has clarified my problem. Thank you. Tag: Data Access Application block and COM+ Tag: 88790
  - 10
    - OracleClient stored procedure parameter - can it handle 8 bit VarChars? I'm trying to execute a pair of Oracle stored procedures that encrypt/decrypt a character string using Oracle's obfuscation package. Each stored procedure has an input and an output parameter. One procedure encrypts a string, the other decrypts a string. The problem is that when I encrypt a value the procedure executes without incident, but the return string is losing it's high-order bits. What I get back is a value that looks encrypted, but when I feed the string to the decryption procedure I don't get my original value back. When we compare the string returned by my .Net function to the string returned when executing the sp under SQL*Plus we see that several characters are 80h "smaller" in the .Net functional return than they are when the sp is executed under SQL*Plus. The database is Oracle 9i, running with an eight bit character set, but I don't see any property in the .Net OracleClient that allows me to specify that I expect 8 bit characters back from Oracle. Can anyone shed any light on this for me? How can I get .Net to understand that Oracle is returning 8 bit characters? Thanks much, Brad Tag: Data Access Application block and COM+ Tag: 88786
  - 11
    - RowDeleting, RowChangeing, ColumnChanging exception handling As I figured out, the recomended way to cancel editing of a column, or deletion of a row is to create an event handler for ColumnChanging or RowDeleting events, and to throw your own exception. Well, I did just that, and the problem is that I do not know where to catch this exception. As I understand, it should be done somewhere in the DataGrid which is bound to the DataTable which raised an event, but I don't know where. Can anybody help me? Tag: Data Access Application block and COM+ Tag: 88783
  - 12
    - parent column in child row Hello, I have a dataset with 2 tables and a relation (parent - child). I linked that ds to a datagrid. Shows everything fine (very little coding for such functionality!). But.. in the child row I want to show a column of the parent. Example: orderColumn shows customerId and I want the customerName which is located in the parent. How do I do that? Thanks in advance Frank Tag: Data Access Application block and COM+ Tag: 88778
  - 13
    - DataTable.New() and Rows.Add() not working right I'm using a SqlReader to read results from a query and insert them into a DataTable. The DataTable is from a DataSet which contains an Xml that was read in using ReadXml(). My problem is, only 1 row gets written correctly. The others don't have any attributes and are not in the proper hierarchy in the Xml yet they're all created from the same loop. while (sqlReader.Read() ) { DataRow dr = dtProducts.NewRow(); dr.ItemArray[dr.Table.Columns.IndexOf("Col1")] = sqlReader.GetString(indexPT); ... ... // set more rows dtProducts.Rows.Add(dr); } ds.WriteXml(@"X:\temp\Test.xml"); Tag: Data Access Application block and COM+ Tag: 88777
  - 14
    - SQL Stored Procedure not updating. Hoping someone can provide some insight into what I'm doing wrong here. I have a Win.Form with a bunch of text controls, bound to a Dataset (DsCustomerInfo1), and a ComboBox bound to the ClientID Field of that Dataset (DsCustomerInfo1.cw_clientinfo.ClientID) so that I can select a client ID, and get all the text boxes filled with data for the selected client. That all works beautifully. I edit the address field for instance, and hit my Update Client Button. Private Sub btnUpdateClient_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateClient.Click Me.connExpress.Open() 'Open the connection Try Debug.Assert(Me.DsCustomerInfo1.HasChanges, "No Changes Present") Me.daCustomerInfo.Update(Me.DsCustomerInfo1, "CW_customerinfo") Catch ex As Exception MsgBox(ex.ToString, MsgBoxStyle.Critical, "SQL Error") End Try Me.connExpress.Close() 'Close the connection End Sub The Assert says that there are no changed Rows. I have a breakpoint on the daCustomerInfo.Update line, and I have a watch on CType(CType(DsCustomerInfo1.cw_customerinfo.rowCollection.Item(0),System.Dat a.DataRow),SupportTool.dsCustomerInfo.CW_customerinfoRow) Which is the row I'm changing. The Address field shows my new edited address, but the Rowstate property is Unchanged. I can select a new client from the Combobox, and come back to this one, and my new edited address is still displayed, but it hasn't been reflected back to the SQL Database. If I log out of the application and come back in, I'm back to my original address as stored in the SQL DB. Tag: Data Access Application block and COM+ Tag: 88773
  - 15
    - [store procedure] + sqldatareader problem my simple store procedure like thiese:- CREATE PROCEDURE dbo.companyinfo_shipper_search @searchcode varchar(10) as select name from companyheader where code = @searchcode GO ------------------------------------------------------------------- my vb.net code cmdSearch.CommandType = "dbo.companyinfo_shipper_search" prmCompany_Code = cmdSearch.Parameters.Add("@searchcode", strCode) prmCompany_Code.Direction = ParameterDirection.Input prmCompany_Code.SqlDbType = SqlDbType.VarChar Try Dim drCompanyReader As SqlClient.SqlDataReader = cmdSearch.ExecuteReader(CommandBehavior.SequentialAccess) Do While drCompanyReader.Read Console.Write(drCompanyReader.GetString(0)) Loop ......etc I use sql analyzer to check and it really return the correct records. However, as I use sqldatareader, it returns error" Invalid attempt to read when no data is present". What's wrong with my code ??? Please help. Tag: Data Access Application block and COM+ Tag: 88771
  - 16
    - Child Table In ado.net cannot have table as child of more than one parent. Is there a way around this? Tag: Data Access Application block and COM+ Tag: 88749
  - 17
    - How to maintain state of the listbox while it is bound to Datasource? Hi I have bound my listbox to a dataset. But when I select multiple choices from the listbox, when I again come back to that list box the selected items are lost I have 2 tabs. One has bounded listbox, so when I select multiple items and then go to the other tab and then came back to the first one the selected items are lost Pl help Tag: Data Access Application block and COM+ Tag: 88738
  - 18
    - Connecting to Excel via ADO.net: ISAM driver error Hi, I've got following problem: I'm trying to open a excel sheet via a ado.net oledb connection. but as soon as the function Open is called I'm getting an exception with following text: "Could not find installable ISAM driver". Looking in the msdn I found several issues to that problem. I checked the registry as described and re-registered the dll but that was effectless. Here's my code: string sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=J:\\MyDir\\MyExcelFile.xls" + /*+ ofdExcelSheet.FileName + */ ";Extended Properties=\"Excel 8.0;HDR=Yes\""; System.Diagnostics.Trace.WriteLine( sConnString ); System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection( sConnString ); cn.Open(); I'm using VS.NET 2003 and Office 2003 Does anyone have any expierences with that issue Thanks in Advance Markus Tag: Data Access Application block and COM+ Tag: 88737
  - 19
    - DataTable.Select returns no rows on a date filter H I am using the DataTable Select to filter my data on a date column within the data table, as follows dr_DataRow = m_dt_ScheduleDataTable.Select("StartDate=#" & Format(dte_DiaryDate, "MM/dd/yyyy") & "#" This would appear to intermittently return rows, and I can't see why it does sometimes and doesn't on other occasions. The data table I have has 136 rows and the date I am initially testing with matches 22 of these rows. On occasions all 22 are reurned, other times just some of these and at other times no rows I also allow the user to filter on an integer column dr_DataRow = m_dt_ScheduleDataTable.Select("InterpreterID=" & CType(int_Interpreter, String) And this never seems to exhibit any problems so I think it must be a date issue. I am passing the string in in US format as you can see, although I am in UK and everything is in UK format, bit if I pass a date string in UK format it never returns rows and throws an error if I pass in a date which does not comply with US format e.g 16/05/2004, therefore leading me to believe that the Data table holds dates in US format regardless of all my system settings Has anyone seen anthing like this Thank Siobha Tag: Data Access Application block and COM+ Tag: 88734
  - 20
    - How to create COM+ object which use .NET EnterpriceServices on remote machine? How to create COM+ object which use .NET EnterpriceServices on remote machine? I use on remote machine: object comObject; comObject = Activator.CreateInstance(Type.GetTypeFromCLSID(classGiud,remoteMachineName)) ; classGuid - GUID of class which inherits from serviced component. After execution this expression, It shows error like this: "Could not find server.dll assembly." Before I have been installed COM+ proxy. Can I deploy COM+ client as registered type library from server.dll? Thank You, Vasily! Tag: Data Access Application block and COM+ Tag: 88733
  - 21
    - "MDAC required" but it's installed... Hi, I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server: The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\FullInstallVer = "2.71.9040.2" The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc. Does anybody know about thisp roblem? And some solution? Could it be because of some restictions (although I do have full Admin rights on the pc). I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe). Thanks a lot in advance, any help, hints etc will be really appreciated! Pieter Tag: Data Access Application block and COM+ Tag: 88729
  - 22
    - Getting OCI-22060 error while using Microsoft.Net's Oracle Provider Hi, I am trying to get data back from Oracle database using Microsoft .Net's Oracle Provider and I keep on getting a OCI-22060 error stating that argument [2] has unitialized value. SQL plus returns me the data I need without any problems, and for the same query I get this error on the web. This error only happens when I use a materialized view. If I don't use the MV and get data from all the tables everything is fine. However, since there was no automatic redirection of the queries to the MVs were taking place, I decided to write code to use the MVs directly, and that's when I got this error. Any help would be appreciated. Thanks, and best regards, - Amit. --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Data Access Application block and COM+ Tag: 88723
  - 23
    - DBnull and checkBox when adding new record Yo, Got a checkbox which I databind at runtime to a numeric column. It works fine but when I add a new record I get the error: -------------------------------- An unhandled exception of type 'System.InvalidCastException' occurred in mscorlib.dll Additional information: Object cannot be cast from DBNull to other types. -------------------------------- I'm databinding just after adding a new record, so the order of events is: 1. Add new record code: private void AddRecord() { // daBuilding is my DataAdapter, dsBuilding is my DataSet. daBuilding.FillSchema(dsBuilding, System.Data.SchemaType.Source, "BUILDING"); this.BindingContext[dsBuilding, "BUILDING"].AddNew(); this.DataBindControls(); } 2. Databinding code: private void DataBindControls() { // Check the global flag to see if we have already databound controls. if (this.dataBound) return; . . // this is the line that craps out: chkHeritage.DataBindings.Add("Checked", this.dsBuilding, "BUILDING.HERITAGE_LISTED_YN"); chkHeritage.DataBindings["Checked"].Format += new ConvertEventHandler(NullToBoolean); . . // Set global flag so we don't have to databind again. this.dataBound = true; } My understanding is that you have to databind AFTER having retrieved a dataset to bind to, hence the FillSchema() call at the begining. But how does this work when you add a new record and have checkBoxes which don't know what to do with a null? Any advice on this greatly appreciated. Cheers, PeterZ Tag: Data Access Application block and COM+ Tag: 88721
  - 24
    - data access for WinForms I am looking for architectural solution for data access from WinForms. For WebForms I am using MS Data Access Application Block with few modifications. DataReader methods help a lot and this was a big boost for my project. For WinForms requirements are quiet different. For a example databinding is must. If you have few windows opened all of them must be in synch. So Dataset objects comes to mind first but it requires so much coding, with any change to database I have to change Adapters, then regenerate dataset. VS has a lot of support for working with datasets but still a lot of hassle. I would prefer to create data access code separately from UI so in order to use VS tools for working with Dataset I use Components instead of classes. I just don't feel that it is considered rapid development. I just wanted to know if everybody works like this or there is some smarter solutions out there(please don't offer me to by $1000 application)? Tag: Data Access Application block and COM+ Tag: 88719
  - 25
    - expression for a instantiation a DataColumnobject Hallo, i not unterstand the expression {oColPk}, see Row 18. What do have the braces with the instantiation a DataColumnobject? >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 1 Private Sub Test() 2 Dim oDsCustomer As DataSet 3 Dim oTblOrders As DataTable 4 Dim oColPk As DataColumn 5 6 'Eine Tabelle mit 3 Spalten im Arbeitsspeicher anlegen 7 oDsCustomer = New DataSet("CustomerOrders") 8 9 oTblOrders = New DataTable 10 oTblOrders = oDsCustomer.Tables.Add("Orders") 11 12 oColPk = New DataColumn 13 14 oColPk = oTblOrders.Columns.Add("OrderID", Type.GetType("System.Int32")) 15 oTblOrders.Columns.Add("OrderQuantity", Type.GetType("System.Int32")) 16 oTblOrders.Columns.Add("CompanyName", Type.GetType("System.String")) 17 18 oTblOrders.PrimaryKey = New DataColumn() {oColPk} '<--- What is that? 19 end Sub <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Greetings Wolfram Hubert Tag: Data Access Application block and COM+ Tag: 88716
- Next
  - 1
    - DBConcurrencyException (without Concurrency Problems ?) I am experimenting with ADO.NET I use MySQL 3.23 with MyODBC 3.51 At the moment I simply try an insert a select and an update. I use the usual DataSet approach. The select works and retrieves the data from the database. When I try an update I always get a System.Data.DBConcurrencyException I have looked thru some Microsoft documentation and as far as I understood it a DBConcurrencyException is only thrown when the DataSet is out of sync with the database. I am pretty sure that I don't change the database between the filling of the DataSet and testing the Update statement. I have already looked at the DataRow which I try to update immediately before dataAdapter.Update(dataSetChanged); it seems hold the same data as as the database. Does anybody know what could cause this behavior, or give my some hints what to investigate? Many thanks, Hans Tag: Data Access Application block and COM+ Tag: 88713
  - 2
    - Delete Record Question I have a SQLDataAdapter created with the wizard and having all of the commands including the DeleteCommand - I used the defaults. To delete a record, this works just fine: myDA.SelectCommand.Parameters("@mykey").Value = mykey myDS.Clear() myDA.Fill(myDS) If myDS.mytable.Rows.Count > 0 Then myDS.mytable.Rows.Item(0).Delete() myDA.Update(myDS) End If However, it seems that I should be able to do this in a more straightforward manner using the DeleteCommand. How should this be done with a minimum of code? thanks, T Tag: Data Access Application block and COM+ Tag: 88710
  - 3
    - Oracle Connection Pooling Hello, I am trying to figure out connection pooling. I found this article which discussed the various options available on the connection string, unfortunately it was for the "oracle" provider and not the "Microsoft Oracle provider". Where can I find the options which are avialable for the Microsoft Version? How do I control the number of Connection which are in the pool? I placed this in my connection string "Min Pool Size=30" and it did not bark at me, but then again, I am not sure that it really opened 30 connections? How can I see how man connections are open for my application? I think I am opening connections and not closing them because after a while my application begins to have problems making a connection. Someone indicated that I should create "performance counters" to monitor how many connections are open at any one time. I have never set up performance counters. Does someon how a sample? Thanks in advance for your assistance!!!!! Tag: Data Access Application block and COM+ Tag: 88709
  - 4
    - DeleteCommand.executenonquery with ADO.NET - How do I know if a record was deleted? After entering the sql statement da.deletecommand.commandtext = "Delete from Users where username = @username" I set the parameter to the username I wish to delete. This successfully deletes the user. However, even if I enter an non-existant user, I cannot discern whether a user was deleted or not. Is there a way to do this? (I would rather not use a dataset, since I am trying to increase performance). thanks in advance Rodger Dusatko Tag: Data Access Application block and COM+ Tag: 88699
  - 5
    - data access layer function call Hi. I have the following requirement and I don't know which way I should approach it In a 3 tier application, the business layer calls a function in the data access layer; the data access layer function opens an Oracle connection, execute an "ExecuteScalar" instruction, closes the connection and returns the result to the business layer I would like to know which is the best way for handling both database errors and invalid data Right now, I wrapped connection.open and command.executescalar in a try/catch block with connection.close in the finally statment. Should I not do that? Should I move the try/catch block in my business layer wrapped around the data access layer function call? Btw, what is the difference between connection.close and connection.dispose - some MS examples have connection.close while others have both Where should I do my data validation? For example, should I throw an exception if the executescalar returns a null, that I should catch in the business layer, or should I have an IIf(retVal.IsDBNull, -1, retVal) statement? Is the data access layer supposed to return clean data Thank TM Tag: Data Access Application block and COM+ Tag: 88695
  - 6
    - Dataset VS DataReader - Performance Hi All We have had a HOT discussion on the subject ... to resolve this I need a authentic answer (preferably with some supportings) to my question follows... What and How much difference (in terms of end-user user response time in seconds) it will make to an end-user of a web site if we use Typed DataSet as a dataobject OR custom defined dataobject.. 1) with @ 100 - 200 concurrent users in given circumstances... 2) web page needs to process about 500 Rows (@ 50 columns) (MAX 1000 rows in few circumstances. 3) once the processing is done dataset/datareader will be cleaned-up. 4) if we dont use dataset we will be using some custom defined dataobject, populated programmatically using by looping thru datareader 5) Inclination towards using typed - dataset is owing to ease of development, and other out-of-the box functionality provided by microsoft Any lights on this will be appriciated. Tag: Data Access Application block and COM+ Tag: 88690
  - 7
    - Combobox issue. Hi All, I am working in VB.NET. I have a data bound control (combobox) which I want to fill with a certain field of my table from database ( SQL as backend). The issue is, I want these values to fill the combo at the index specified by me, ie, not the usual 0,1,2.... by default. Also, not dataset, but I am using dataReader. Can anyone send me the sample code for the same? Thanks for your help. Tag: Data Access Application block and COM+ Tag: 88686
  - 8
    - Deleted Records and DataAdapter.Fill Dear All, Question Why DataAdapter.Fill does not refresh the deleted records in the dataset? If this is by design then how can I refresh the data and get rid of removed records without actually refilling the dataset with clear and fill operations? Detailed I have a DataAdapter refering to a table in database. The data is being shown in a DataGrid. As the data is updated, in the table (from other connection), it is reflected in the grid by a call to the Fill method of the DataAdapter. All is well , but if some row is deleted then the call to Fill method does not delete the record from its underlying DataSet. I have come to know that calling clear method is an option but it seems so dirty - clearing all the data and then getting it again. Can someone plz guide Why it is done this way and what is the resolution. Thank You Tag: Data Access Application block and COM+ Tag: 88685
  - 9
    - Unusual binding problem with comboboxes and currency manager Unusual binding problem with comboboxes and currency manager I have an authors form that includes columns whose UI are comboboxes. On the form level I have Dim cm As CurrencyManager In the formload event handler I bind as follows: cm = CType(BindingContext(DsAuthorsTwo1, "Authors"), CurrencyManager) Here's what happened. The form would open to the first Author. The values for the columns represented by textboxes or in one case a checkbox were correct. The values for the columns represented by comboboxes were wrong. They were always the 0th selected index. If I moved the cm.position forward then back to 0, then the values would be correct. So I contrived the obvious at the bottom on the form_load event procedure: MsgBox(cboContentRights.SelectedIndex.ToString) -> 0 cm.Position += 1 cm.Position -= 1 MsgBox(cboContentRights.SelectedIndex.ToString) -> 3 (correct) There's got to be a more elegant way. polynomial5d Tag: Data Access Application block and COM+ Tag: 88681
  - 10
    - TypedDataSet doesnot pass correctly in Web service This is a multi-part message in MIME format. ------=_NextPart_000_0122_01C446FD.9D8D7460 Content-Type: text/plain; charset="windows-1255" Content-Transfer-Encoding: quoted-printable Hi, I wrote (not using an automatic tool) a costum DataSet, called = MyDataSet, that holds only costum DataTables, called MyDataTable that = holds only MyDataRows.=20 MyDataSet derives from DataSet, MyDataTable derives from DataTable, and = MyDataRow from DataRow. The Tables collection of MyDataSet holds only = tables of type MyDataTable. Then, I wrote a web method that returns = MyDataSet. When I consume the method, I can see in the debuger that in the server = side, the objects are created correctlly. But when the answer returns to = the client side, the answer is indeed of type MyDataSet, but the tables = in the Tables collection are just DataTables (and not MyDataTable, as = was in the server side). I think that I have a problem with the XmlSerialization of MyDataTables. How can I fix this bug? Thanks, David ------=_NextPart_000_0122_01C446FD.9D8D7460 Content-Type: text/html; charset="windows-1255" 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=3Dwindows-1255"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY dir=3Dltr bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I wrote (not using an automatic tool) a = costum=20 <EM>DataSet</EM>, called <EM>MyDataSet</EM>, that holds only costum=20 <EM>DataTables</EM>, called <EM>MyDataTable </EM>that holds only=20 <EM>MyDataRows</EM>. </FONT></DIV> <DIV><FONT face=3DArial size=3D2><EM>MyDataSet </EM>derives from = <EM>DataSet</EM>,=20 <EM>MyDataTable </EM>derives from <EM>DataTable</EM>, and <EM>MyDataRow=20 </EM>from <EM>DataRow</EM>. The <EM>Tables </EM>collection of = <EM>MyDataSet=20 </EM>holds only tables of type <EM>MyDataTable</EM>. Then, </FONT><FONT=20 face=3DArial size=3D2>I wrote a web method that returns=20 <EM>MyDataSet</EM>.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>When I consume the method, I can see in = the debuger=20 that in the server side, the objects are created correctlly. But when = the answer=20 returns to the client side, the answer is indeed of type = <EM>MyDataSet</EM>, but=20 the tables in the <EM>Tables </EM>collection are just <EM>DataTables = </EM>(and=20 not <EM>MyDataTable</EM>, as was in the server side).</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I think that I have a problem with the=20 XmlSerialization of <EM>MyDataTables</EM>.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>How can I fix this bug?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Thanks, = David</FONT></DIV></BODY></HTML> ------=_NextPart_000_0122_01C446FD.9D8D7460-- Tag: Data Access Application block and COM+ Tag: 88679
  - 11
    - DataColumn hi folks can i get information regarding precision and scale from datacolumn, without using adapter regards, and thanks in advance seril Tag: Data Access Application block and COM+ Tag: 88678
  - 12
    - Problems using HasRows Hi. I am using VS.NET 2003. I have a function that runs a procedure and returns a SqlDataReader: Public Overloads Function RunProcedure(ByVal StoredProcName As String, _ ByVal Parameters As IDataParameter()) As SqlDataReader Dim cn As SqlConnection Dim cmd As SqlCommand Dim returnReader As SqlDataReader Try cn = New SqlConnection cn.ConnectionString = strConnectionString cn.Open() cmd = BuildQueryCommand(StoredProcName, Parameters) cmd.Connection = cn cmd.CommandType = CommandType.StoredProcedure returnReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) Return returnReader End Function When I try to use HasRows on the caller routine, I receive the error: "Invalid attempt to HasRows when reader is closed". If I remove the CommandBehaviour.CloseConnection option from the DataReader this error goes away. Can't I use HasRows and CommandBehaviour.CloseConnection? Thanks, Robert Scheer Tag: Data Access Application block and COM+ Tag: 88670
  - 13
    - INSERT INTO fails for SqlDbType.Text I want to inser a Text string as a BLOB When I try to insert a series of records I get the following problem -- System.Data.SqlClient.SqlException: String or binary data would be truncated My table has three nvarchar 50 columns, (MessageId, PutDate, MsgType and a Text column (RawMessage), which I want to use as large storage container for XML messages So I read the XML Messages and want to insert each into the Database The code of the INSERT Part looks like this private static void InsertIntoDB(byte[] msgId, DateTime putDate, string message tr string commandText = "INSERT INTO message (MessageId, PutDate, MsgType, RawMessage) " "VALUES ('"+BitConverter.ToString( msgId )+"','"+putDate.ToString("u")+"','Type',@RawMessage)" command.Connection = con command.CommandText = commandText command.Parameters.Clear() SqlParameter msg = new SqlParameter("@RawMessage",SqlDbType.Text,message.Length) msg.Value = message command.Parameters.Add( msg ) command.ExecuteNonQuery() catch(Exception e Console.WriteLine(e.ToString()) Console.WriteLine("Neither record is written to the database!") Any Help? Tag: Data Access Application block and COM+ Tag: 88668
  - 14
    - very novice Find Button I have a DataForm bound to a dataSet "dsPhoneBook". I want to have a button "btnFind"on my form open a input box where I can enter a name and the record be set to the name I entered into the input box. I can not figure out how to do this. Need Help! Thanks Kent Tag: Data Access Application block and COM+ Tag: 88665
  - 15
    - Merging Data with strong typed DataSet Hi there, I have a strong typed data set which is manually filled by me and then saved on local drive with "objDataSet.write(...)". When I generate two new DataSet with one that has the XMLSchema in it, and the other has the saved DataSet in it (objDataSet.ReadXML) and i do a "Merge" I get an error that the DataTypes of the columns arent matching. When I look at the Schema of the DataSet where I only loaded the data via ReadXML, I see that every column has the datatype "string". How to get arround this problem? Many thanks, i am hanging at this since about two weeks now. Greetz BenLeino CodeExtract: objDataSet = New Data.DataSet objDataSchema = New Data.DataSet objDataSet.ReadXml("C:\PPTR Workdirectory\pptr_tmp196\tmp1A5.xml") objDataSchema.ReadXmlSchema("C:\...\dsSchemaPPTPresentation.xsd") objDataSet.Merge(objDataSchema) Tag: Data Access Application block and COM+ Tag: 88664
  - 16
    - Cannot connect to SQL Server I am not connecting to my sql server running local.programming in VB.net Database programming with statement Dim OConn As New SqlConnection("Data Source=localhost\\KIRZAD-APPLE;Initial Catalog=Northwind; UID=sa;PWD=") My server name is KIRZAD-APPLE OConn.Open() 'Throwing exception,probably not getting the server. Please help me.Bye. Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Data Access Application block and COM+ Tag: 88660
  - 17
    - MDAC 2.8 on Win 2003, How do you repair or re-install MDAC 2.8 on Windows 2003 Server? Tag: Data Access Application block and COM+ Tag: 88656
  - 18
    - Is there a .NET version of ADOX. ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database. Tag: Data Access Application block and COM+ Tag: 88650
  - 19
    - Checking for NULL data Does null check have to explicitly be performed on every nullable value from a DataReader return. ie. for: DataReader dr = sqlCommand.ExecuteReader() while( dr.Read() { int intTestValue = dr.GetInt32( dr.GetOrdinal("TestValue")); } This will cause an exception if value is null, so do I have to do a special check for null on every return?? Or is there a more efficient way of doing this? Thanks Tag: Data Access Application block and COM+ Tag: 88644
  - 20
    - Help: OleDbException: Operation must use an updateable query I do an UPDATE query in my ASP.NET page. On my development machine it works PERFECTLY. When I upload the site (inlcuding my Access MDB) to my production website and try to do the same update qry I get this error. Any ideas? System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MyPage.EditHtml.cmdSave_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\EarlyAlert2\EditHtml.aspx.vb:line 151 Tag: Data Access Application block and COM+ Tag: 88640
  - 21
    - Do I Have to Open a Connection 3 Times? I'm just starting to learn asp.net. What I have is a registration form for a message board system. Basically, the user enters in their info and it's validated. So I have a custom validator check to make sure the username is unique, I have another custom validator that makes sure the email address is unique and then I save the info to the database. That means I open the connection to the sqlserver 3 times. Seems inefficient to me. Is there a better way? Sub Button1_Click(sender As Object, e As EventArgs) if me.isvalid then Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection Dim uname as string Dim password as string Dim em as string Dim ip as string Dim rightnow as date ip = Request.UserHostAddress() rightnow = now uname = username.text password = password1.text em = email.text dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_register" Dim dbParam_username As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_username.ParameterName = "@username" dbParam_username.Value = uname dbParam_username.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_username) Dim dbParam_password As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_password.ParameterName = "@password" dbParam_password.Value = password dbParam_password.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_password) Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_email.ParameterName = "@email" dbParam_email.Value = em dbParam_email.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_email) Dim dbParam_ip As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_ip.ParameterName = "@ip" dbParam_ip.Value = ip dbParam_ip.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_ip) Dim dbParam_last_ip As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_last_ip.ParameterName = "@last_ip" dbParam_last_ip.Value = ip dbParam_last_ip.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_last_ip) Dim dbParam_created As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_created.ParameterName = "@created" dbParam_created.Value = rightnow dbParam_created.DbType = System.Data.DbType.DateTime dbCommand.Parameters.Add(dbParam_created) Dim dbParam_last As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_last.ParameterName = "@last" dbParam_last.Value = rightnow dbParam_last.DbType = System.Data.DbType.DateTime dbCommand.Parameters.Add(dbParam_last) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try 'Server.Transfer("index.aspx") end if End Sub Sub CustomValidator_Username( s As Object, e As ServerValidateEventArgs ) Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_username" Dim dbParam_username As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_username.ParameterName = "@username" dbParam_username.Value = trim(e.value) dbParam_username.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_username) dbConnection.Open Dim cnt as integer cnt = dbCommand.ExecuteScalar If cnt = 0 Then e.IsValid = True Else e.IsValid = False End If End Sub Sub CustomValidator_Email( s As Object, e As ServerValidateEventArgs ) Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_email" Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_email.ParameterName = "@email" dbParam_email.Value = trim(email.text) dbParam_email.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_email) dbConnection.Open Dim cnt as integer cnt = dbCommand.ExecuteScalar If cnt = 0 Then e.IsValid = True Else e.IsValid = False End If End Sub -- . http://sf-f.org, weblog and search engine for fans and writers of speculative fiction. . Tag: Data Access Application block and COM+ Tag: 88638
  - 22
    - No Smart Device Choice How come My VB.Net environment does not contain the Smart Device Application Template to open the Smart Device Application Wizard. Any Ideas? Thanks Paul Tag: Data Access Application block and COM+ Tag: 88637
  - 23
    - Updating field with single/double quotes I have a memo field in my Access database that is called HtmlText. I have a text box in my ASP.NET application that I fill with HTML. The HTML has both single and double quotes throughout the HTML. I tried to run an UPDATE query to update the db but it fails. I think it's because of the quotes. How can I get the UPDATE command to update fields that contain both single and double quotes? Ideas? Examples? Thanks. Tag: Data Access Application block and COM+ Tag: 88627
  - 24
    - ADO Update Problem Greetings all, I am using an Access Database to store question information for a questionare application. I am using VB.net as the front end, and ADO.net to retrieve the information from the database. My data is bring displayed in a DataGrid bound to a dataset. All of my calls to the database are to parameter queries. The problem that I am having is with the update command. When I call the update method for my data adapter, and pass a dataset containing only the changed records, only one record shows the change. I know that parameter queries work because data is being returned and update, just not in the quantities that I want. From what I have read, the update method in ADO.NET should be able to process a batch change, but the only specific information I have been able to find concerns SQL Server and not MS Access. The only information I have been able to find regarding the update method and MS Access were for single records. Does ADO.net send each update request separately, waiting for conformations between requests, or does it send all of the changes at once? I know, if you write the queries properly, SQL server can process the data in a lump sum, but I do not believe Access has that ability. I have been working on this for several days. Any help you can provide would be greatly appreciated Thanks in advance, Edison Tag: Data Access Application block and COM+ Tag: 88626
  - 25
    - Books reviewed I've been on a mission this past year to move from VB6 to .Net. I'm fortunate(!?) not to have the big catalog of some long-time VB developers, although I have some CE apps that have to be entirely rewritten in CF. A lot of what I develop has to be written for the PPc, so I knew I would be looking for information in .Net, ADO.Net, CF -- and SQL Server. So in the spirit that others might benefit from my journey, here are my observations. Having been a tech writer many years ago (and a page designer before that), I give these reviews with the caveat that I know how difficult it is to write technical literature and also how difficult it is to pull together all the aspects of a book. Thus I'm not going to give much about any specific errors or bugs, but a general feel for the book and how it helped me. I will also give the caveat that I've never read ANY book that didn't give up some useful bits of information -- no matter how bad that book might be otherwise. Final caveat is that I'm not there yet -- I'm still learning much as I develop and I'll still have many questions here. But I don't see my opinions changing on the books I'm reviewing here. The following list is in no particular author order: Introducing Microsoft.Net 2nd Ed (note: the 3rd Ed is out now), David S. Platt As its title implies, its a great book to get you started in the .Net way of thinking. There are some examples, but that is not really the focus of the book. Touches briefly on all areas of .Net. I wish I had read this book first. VB.Net, Matthew McDonald Strange, I've never seen any reviews of this book, and I got it for $10 at the half-price bookstore, but its chock-full of information and examples. The book is aimed at developers moving from VB to .Net, so it was right up my alley. If you can find it, buy it. Visual Basic.Net, Matt Tagliaferri Another out-of-the-mainstream book (spell that c-h-e-a-p) with some good stuff in it. If you are interested in GDI, this might get you kickstarted. Also gave me some intro to the datareader and datasets. Visual Basic.Net Database Programming, Evangelos Petroutsos, Asli Bilgin I've seen this book slammed in a few reviews, but I feel that's totally undeserved. This is a very good book for those just starting with ADO.Net. Its deep enough, it gives you a lot of great examples, and is fairly well illustrated. I do have some minor heartburn as follows. Some of the examples that required the Command Builder to be used did not show those in the code example. Literally, those examples would not run (I'm thinking this was one of the places that William Ryan straightened me out). Next, a few of the illustrations were actually screen shots of the code that were too small to read (altho in fairness, you have a CD to pull the code up in front of you -- I'm not much on using the CDs unless I do not understand the written word). Finally, the layout of the book is kinda goofy as regards the DataReader (you have to look in a couple of different areas where the material should have been pulled together). I have about a dozen pages tabbed for future reference, so that may give you some idea that despite my misgivings about a few errors, I still find the book very useful. Microsoft ADO.Net, David Sceppa In the lingo of the 20-something crowd, this book is "the bomb". I'd read reviews of how good this book is, and its reputation is well-deserved. I have not finished the book yet, but after several chapters (and some peeks ahead into the "Questions that should be asked more frequently"), I can see already that I'll feel more secure in my knowledge of ADO.Net once I'm finished. I'm thinking that this is probably the only book I've ever paid full-price for. If you were to be stuck with the task of creating a robust application with just any 3 books, this would be 1 of the 3. More about this anon. .Net Compact Framework, Craig Morris, et. al. One of the first books I bought and should've been one of the last. Examples all in C#, and since I had no .Net experience at the time, I didn't spend much time with it. Fairly lightweight tome, but I'm hanging on to it and intend to get back to it Microsoft .Net Compact Framework Kick Start, Erik Rubin, Ronnie Yates This book helped me out tremendously, not only with the CF, but on how to work with the datagrid and datatables. I do not claim to being there completely, but using some pieces of this book in conjunction with answers from the afore-mentioned William Ryan in the forums, I can at least visualize most of the concepts I need to pull things together. Microsoft .Net Compact Framework, Andy Wigley, Stephen Wheelwright I have not finished this book. Examples all in C#, and highly technical (these guys might be wound a little too tight, and might want to check out www.moosehead.com). I'm counting on this to fill in the holes in my technical knowledge once I have the nuts and bolts down. C# Text Manipulation Handbook, Francois Liger, et. al. I found this book also at the half-price book store and oh I love it as a reference! This little gem has helped me tremendously with casts, parsing, math manipulations, numbers to strings, strings to date, you name it. Even if you write only in VB.Net, the examples are easy to read/convert. This book will save you hours and hours of frustration with casting issues. Buy it. Professional SQL Server 2000 Database Design, Louis Davidson How did books about SQL Server land on the .Net list? Frankly, you will miss more than half the journey if you try to learn.Net in a vacuum without some knowledge of SQL Server. This book is so language-agnostic, it is an excellent resource. Written in a very user-friendly conversational tone, I have been enjoying it tremendously -- while learning much along the way. Troubleshooting SQL, Forrest Houlette I found this book totally by accident. It deals exclusively with troubleshooting SQL statements. Heck, while I realized the depth of SQL, I never envisioned that someone could write such a "troubleshooting" book that was language-independent. Using this book in conjunction with "The Practical SQL Handbook", "SQL Queries for Mere Mortals" and "Database Design for Mere Mortals" will make you much more confident in your SQL abilities. SQL Server Black Book, Patrick Dalton, Paul Whitehead I really appreciate the "black book" series of books. They helped me tremendously with VB and got me started with understanding C++. But for some reasons, this particular black book has not been as helpful. Its just as big, has just as many examples in it, but for some reason, I feel disconnected and the descriptive material feels lightweight. This book will remain a reference for me, but I'm somewhat scratching my head about some topics in the book. ADO.Net Step-by-Step, Rebecca Riordin Of all the tech books I've bought over the last 4 years, this is the only one I've ever returned and I did that last night. Because I consider books I buy to be such a repository of reference material, I struggled with even returning it, but something about the book just did not fit my way of thinking (which cannot be considered a knock on the author at all!). I've read some reviews about the book that it has errors and buggy code, but I did not get past the 2nd chapter nor even crack the CD, so I'll not lay that out as an issue either. I think that maybe part of the problem was that I had some knowledge already and clunking around with a "step-by-step" manual was like having someone eager to drive a racecar but their instructor wants to show them how to use the shifter. This book probably has a target audience that I didn't fit in. Visual Basic.Net, Richard Bowman One of my bargain purchases that was a dog. If the author's name is not on the cover of the book, that should be some sort of warning right there. Actually, there is some good material in the book, but its so covered up with screens on every page, you have to spend a lot of time digging for what you need. An excellent example of how NOT to design pages for tech books. Save your money. If you were only allowed 3 books to learn how to write both desktop and Compact Framework database apps, my choices would be: Microsoft ADO.Net, David Sceppa Professional SQL Server 2000 Database Design, Louis Davidson Microsoft .Net Compact Framework Kick Start, Erik Rubin, Ronnie Yates Tag: Data Access Application block and COM+ Tag: 88621

Hi, all
I want to know if I can use Data Access Application block ini COM+. How can I do this? Is as simple as derived the class from EnterpriseServices and asigne it attributes
Thanks a lot!

Top

Re: Data Access Application block and COM+ by Sanjeeva

Sanjeeva
Wed Jun 02 04:09:20 CDT 2004

Derive the COM + component from ServicedComponent and Create a data Access
component which will be using the Data Access App Block. This Data Access
component is instantiated from the COM+ component..

--
Regards,
Sanjeeva
Proteans Software Solutions

"otto" <anonymous@discussions.microsoft.com> wrote in message
news:D3345F03-9A66-43FC-9DCF-15809DABFCD5@microsoft.com...
> Hi, all:
> I want to know if I can use Data Access Application block ini COM+. How
can I do this? Is as simple as derived the class from EnterpriseServices and
asigne it attributes?
> Thanks a lot!

Top

Re: Data Access Application block and COM+ by anonymous

anonymous
Wed Jun 02 05:46:03 CDT 2004

Hi, Sanjeeva
so I donÂ´t have to change nothing in Data Access Application Block code, isnÂ´t it? I have to create my custom class, derive it from EnterpriseComponent, make calls to DAAB and thatÂ´s all. Is this correct
Thanks a lot !!

Top

Re: Data Access Application block and COM+ by Sanjeeva

Sanjeeva
Fri Jun 04 04:23:38 CDT 2004

yeah.. that should typically work..

--
Regards,
Sanjeeva
Proteans Software Solutions

"otto" <anonymous@discussions.microsoft.com> wrote in message
news:2CF3AE0D-AA10-4537-AA3E-A700F9AB753B@microsoft.com...
> Hi, Sanjeeva:
> so I don´t have to change nothing in Data Access Application Block code,
isn´t it? I have to create my custom class, derive it from
EnterpriseComponent, make calls to DAAB and that´s all. Is this correct?
> Thanks a lot !!

Top