DataRow.Select Weirdness!

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
    - DataAdapter.Update method woes We have been experimenting for quite a while now on the best approach to take for updating data. The approach we are currently investigating is using the DataAdapter class' Update method. However, we have run into an issue regarding this approach and we can't seem to find a suitable workaround. Allow me to setup a basic scenario to use as an example: In this application, we are submitting all database updates in batches. When the user submits data base updates, we want either all updates to occur or no updates to occur. Anytime an error occurs while updating, all changes are to be roll backed on the back end database (which is SQL Server), the row in error is to be resolved in some fashion, and all pending updates remain pending so once the error is resolved the user can re-submit. Of course one of the issues with this scenario is "rolling back" any modifications made to the DataSet during the Update call. If row 10 has a RowState of Added and the error occurs on row 20, then after the roll back of the back end db row 10 will still need to retain that RowVersion of Added. In other words, AcceptChanges only needs to be called when all database activity has been successfully executed, and not on a row-by-row basis. We found the solution to that problem. In the DataAdapter's RowUpdatedEvent, set e.Status = UpdateStatus.SkipCurrentRow. We have a table, tblAddressType, on SQL Server. We have four associated stored procedures for selection, insertions, updates, and deletions. The stored procedure for insertion has two output parameters: @intAddressTypeID which returns the ID of the newly added row (by returning @@IDENTITY) and @datInsertedDateTime which returns the date/time of the row insertion (by returning GetDate() ). The DataSet contains one table, tblAddressType. The DataAdapter maps the two output parameters of the insert stored procedure to the appropriate columns in the DataTable. When a row is added to the DataTable and the DataAdapter Update method is called, everything works as expected. The new ID and the Inserted Date Time are returned from the stored procedure and are populated in the appropriate columns by the column mappings. Great and dandy. What is the problem you ask? Lets say we have 5 inserts. Inserts 1 through 4 are successful. Insert 5 fails for some reason. Ok, the Catch block rolls back the transaction so inserts 1 through 4 are no longer in the backend. Since we did not call AcceptChanges on the DataSet, and we prevented a row-by-row AcceptChanges in the RowUpdated Event by setting e.Status = UpdateStatus.SkipCurrentRow, then inserts 1 through 4 are still pending insertions. Right? Wrong!!! The RowState of those rows are now Modified. When those stored procedure output parameters are mapped to the appropriate columns, apparently the RowState changes from Added to Modified. Not good since those rows do not exist in the back end due to the transaction being rolled back. Has anyone run into this and know a good workaround? Tag: DataRow.Select Weirdness! Tag: 63068
  - 2
    - Exclusive lock in SELECT Hi. When I execute a SELECT using the Fill method of SqlDataAdapter class, there is a exclusive lock on all the tables that apperas in the SELECT clause. I ain't using transactions. Therefore, while the SELECT is executing, I can't have interaction with the tables. Hope someone has an answer for this. Thanks very mucho. -- Ing. Rodrigo Meneses Arquitecto de Sistemas Corporación L' Tel: +58(212)267.4611 Fax: +58(212)267.5395 Tag: DataRow.Select Weirdness! Tag: 63067
  - 3
    - Strange problem: Dataset add/delete fail on record 2-3 bouundary - retry Hi, We are trying to discover the source of a very strange record Add and Delete problem. When we Add records to the table the first two records work just fine, but adding a the third record results ArgumentOutOfRangeException "Index" is thrown. It is also thrown when attempting to add a record beyond the third. But, if one catches the exception and retries the Add it succeeds, most of the time. Here is the code we use to trap and retry the add Sub AddArecord(....) ' Create a new row dr = dsOrder.Tables(TN_ORDER_DETAIL).NewRow() ... Values in the new record are set here ' Add the row Try dsOrder.Tables(TN_ORDER_DETAIL).Rows.Add(dr) Catch ex As System.ArgumentOutOfRangeException dsOrder.Tables(TN_ORDER_DETAIL).Rows.Add(dr) End Try End Sub Another strange thing is that when we delete records, we throw the ArgumentOutOfRangeException "Index" if the tables has 3 records and you delete one. But if the table has 4 records you do not generate the exception on a delete. Is there some sort of max record in table property the we set to 2, or ??? I am baffled and appreciate any help. BTW, we are using VB.net, ,Net Framwork 1.1, MDAC 1.7, and SQL Server 2000. Thanks, Jerry Tag: DataRow.Select Weirdness! Tag: 63065
  - 4
    - Strange problem: Dataset add/delete fail on record 2-3 bouundary Hi, We are trying to discover the source of a very strange record Add and Delete problem. When we Add records to the table the first two records work just fine, but on the third record a ArgumentOutOfRangeException "Index" is thrown. It is also thrown when attempting to add a record beyond the third. But, if one catches the exception and retries the Add it succeeds, most of the time. Here is the code we use to trap and retry the add ' Create a new row dr = dsOrder.Tables(TN_ORDER_DETAIL).NewRow() ... Values in the new record are set here ' Add the row TrydsOrder.Tables(TN_ORDER_DETAIL).Rows.Add(dr) Catch ex As System.ArgumentOutOfRangeException dsOrder.Tables(TN_ORDER_DETAIL).Rows.Add(dr) End Try Tag: DataRow.Select Weirdness! Tag: 63064
  - 5
    - excess parameters? Could anybody help me understand why VS.NET when a table is dragged onto the form creates 'double' parameters for data adapter's command objects, as for example shown below for "Original_First_Name" and "Original_First_Name1"? What would happen if I removed "Original_First_Name1"? And why this is created at first place? Thanks in advance, Strah Me.OleDbDeleteCommand1.Connection = Me.OleDbConnection1 Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_SSN", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SSN", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_First_Name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "First_Name", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_First_Name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "First_Name", System.Data.DataRowVersion.Original, Nothing)) Tag: DataRow.Select Weirdness! Tag: 63062
  - 6
    - OLE DB - Beginner problem in C++ 6.0 Hi, I have problem with basic access to DB via OLE DB. I have basic sample program in C++ (MSVC 6) with use ATL. I can open rowset, I can move next or prev rowset, I can delete. But I cannot update or insert rowset (I have set property: propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE ); Rowset is opened with: HRESULT CTestDbPSet::Open() { CDataSource db; CSession session; HRESULT hr; CDBPropSet dbinit(DBPROPSET_DBINIT); dbinit.AddProperty (DBPROP_INIT_DATASOURCE, "D:\\C\\TestDbP\\Test Db.mdb"); hr = db.OpenWithServiceComponents ("Microsoft.Jet.OLEDB.4.0", &dbinit); if (FAILED(hr)) return hr; hr = session.Open(db); if (FAILED(hr)) return hr; CDBPropSet propset(DBPROPSET_ROWSET); propset.AddProperty(DBPROP_IRowsetScroll, true);//Muze jit i pozadu po zaznamech propset.AddProperty(DBPROP_IRowsetChange, true); propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE ); hr = CCommand<CAccessor<CT_SMS_OPERATOR> >::Open (session, "SELECT * FROM MY_TABLE", &propset); if (FAILED(hr)) return hr; return MoveNext(); } Function with problem: void CTestDbPView::OnBtnUpdate() { UpdateData(TRUE); m_pSet->m_STATUS=99; HRESULT hr = m_pSet->SetData();//Update(); if (hr != S_OK) { AfxMessageBox(_T("Cannot Update."), MB_OK); return; } } Thank for help! Tag: DataRow.Select Weirdness! Tag: 63060
  - 7
    - Pros and Cons I am looking for some pros and cons between developing a custom DAL wrapper that would allow the developer to send the Stored Procedure name and some parameters and just writing a DAL that is application specific such as having a Products class and then using data adapters and such to return application specific data. Currently I am using the first solution but I find that sometimes there are things that would work better if I used the application specific DAL such as having an array of items that need to be added to the database as a single record for each item in the array but need to have the current records removed before the new ones are added. Stanley Tag: DataRow.Select Weirdness! Tag: 63056
  - 8
    - Custom DataAdapter Class Hi All, I'm tryin' to create a new DataAdapter class. This class inherits from System.Data.Common.DbDataAdapter and implements the following interfaces: IDbDataAdapter and ICloneable. Here is the class declaration and a simplified version of the constructor called by VS.NET: [Serializable()] public class PIDataAdapter : System.Data.Common.DbDataAdapter, IDbDataAdapter, ICloneable { public PIDataAdapter() { try { this.mobjSqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(); this.miAdapter = (IDbDataAdapter) this.mobjSqlDataAdapter; this.SelectCommand = (IDbCommand) new System.Data.SqlClient.SqlCommand(); } catch { } } ... } The code compiles ok and I can even add an instance of this class to a web form designer, but there are some things that are not Ok. Here are they: 1. The SelectCommand property of the class doesn't get initialized in the code-behind file of the page I add it to. Is the constructor the right place for doing this? or do I have to catch any event for doing the initialization? How to write the values of the initialization in the code- behind file of the page where I add the component? 2. When I right click the PIDataAdapter instance, the following options are NOT present in the context menu: Configure DataAdapter..., Generate Dateset..., Preview Data... What am I doing wrong? Could anyone please help me? I've spent a lot of time trying to figure out what is wrong but didn't get anywhere ... Thanks in advance, Best Regards, Jeverson Tag: DataRow.Select Weirdness! Tag: 63054
  - 9
    - DataView not writing changes to DataSet???? Greetings, I have a textbox control with has a binding to a DataView (which always has only one row). Changes to the row are persisted during the lifetime of the DataSet/DataTable which underlies the DataView. However when I use MyDataAdaptor.update() the change is ignored. When I programmatically inspect data in the row, I see the new value, but when I look ats it rowstate this is set to "unchanged". Further info: if I use editbegin() and editend() the rowstate is changed to modified. Update then catches the change and updates the database. The DataView is being used to filter to a single record to supply a form (sorting on an index value of another control). So the filter is being changed frequently before Update is called. However the changes persist when rows are revisited. I have another textbox control on the same form, using a different dataview - changes to it are caught and passed on to the update. I see no differences in the properties of the controls or the dataveiws. I don't think this matters but the data type of the column in the database is int, while the textbox is string. Any ideas? Tag: DataRow.Select Weirdness! Tag: 63052
  - 10
    - MSDE Most Misterious of Egipt Pyramid....... Dear friend, I'm using MSDE and VB.Net My problem is that when try to connect at database message box say me: "SQL server don't exist or denide access". Now: I have reistall Msdn but nothing is changed I have manually change login autentication mode from Windows NT to SQL (article 285097) but nothing is changed I have try many string connection mode. This is the last: Imports System.Data.SqlClient . . Try Dim conn As New SqlConnection("Server=Home/VSdotNET; Database=master; User Id=sa; Password=;") conn.Open() If (conn.State = ConnectionState.Open) Then MessageBox.Show("Connection opened successfully") End If conn.Close() Catch ex As SqlException MessageBox.Show(ex.Message) End Try My question is: How I can verify the correct installation and functionality of MSDE ( I have WinXP) How I can set Login and Password on MSDE so to be shure of their value? Tag: DataRow.Select Weirdness! Tag: 63048
  - 11
    - Using Strongly Typed Datasets Environment: VS.NET 2003; VB, Access 2003 database. The application allows users to specify the path/filename and the table name at runtime. I am trying to figure out how I can use a strongly typed dataset in this environment. If I add an OleDBDataAdapter to my project and then create a dataset from that the table name is embedded in the generated code. I believe that changing the file/path is accomplished by making the connection string use a variable that contains the user's path/filename but I am not sure how to handle the fact that the table name changes at runtime. Can anyone point me to some documentation or examples that will help me understand how to do this? -- ------------------------------------ Wayne Wengert wayne@wengert.org Tag: DataRow.Select Weirdness! Tag: 63039
  - 12
    - Passing Null Values via a SQLCommand.Parameter I use stored procedures in most of my programs and in many instances one or more of the parameters being passed can be null. I am looking for the most efficent way to test for a null value then pass it to the parameter object. Here is an example of what I do now, paying special attention to the Parameter functions: Sub AddRecord (byval FirstName as string, byval LastName as string) Dim cnn as new SQLClient.SQLConnection(strcnn) Dim cmd as new SQLClient.SQLCommand cnn.open : cmd.Connection = cnn : cmd.CommandType = adStoredProcedure cmd.CommandText = "spAddRecord" If Trim(FirstName) <> "" Then cmd.Parameters.Add("@FirstName",sqldbtype.varchar).Value = FirstName Else cmd.Parameters.Add("@FirstName",sqldbtype.varchar).Value = System.DBNull.Value End If If Trim(LastName) <> "" Then cmd.Parameters.Add("@LastName",sqldbtype.varchar).Value = LastName Else cmd.Parameters.Add("@LastName",sqldbtype.varchar).Value = System.DBNull.Value End IF cmd.ExecuteNonQuery cnn.close : cnn = Nothing : cmd=Nothing End Sub My questions are: 1. How can I test for Null values in other data type. 2. Is there a better way to do this? I haven't found any real soild documentation on this on the web or in my VB.Net and VS.Net books. Thanks, Tom Tag: DataRow.Select Weirdness! Tag: 63038
  - 13
    - Is this RowFilter + edit operation permissible? What happens if a change is made to the column value on which the RowFilter is based? Does the row "fall out" of the filtered view? Dim OldPartId as String = "42" Dim Dv As DataView = New DataView(MyTable) Dv.RowFilter = "PartID = " + OldPartID + " AND Qty > 0" Dim rv As DataRowView For Each rv In Dv rv.BeginEdit rv("Qty") = 0 rv.EndEdit '// this row now does not meet '// the filter criterion Qty > 0 '// is it still in the view? Next Tag: DataRow.Select Weirdness! Tag: 63036
  - 14
    - Datarow update Hello: I am trying to change a a value in my datarow column ["EmailSent"] from "no" to "yes"... I would like to do it inside my loop... Does anyone have any suggestions on how to do it. Thank you very much for your help... I have placed the code here: private void Page_Load(object sender, System.EventArgs e) { if(!Page.IsPostBack) { string path = Server.MapPath("requests.xml"); ds.ReadXml(path); foreach (DataRow Ord in ds.Tables["request"].Rows) { string id = Ord["id"].ToString(); string name = Ord["Name"].ToString(); string email = Ord["Email"].ToString(); string emailSent = Ord["EmailSent"].ToString(); string apptSetDate = Ord["dateTime"].ToString(); string date1 = Ord["Date"].ToString(); string time = Ord["Time"].ToString(); string ampm = Ord["AmOrPm"].ToString(); string procedure = Ord["jobCode"].ToString(); string date2 = System.DateTime.Today.AddDays (3).ToShortDateString(); int dog = compareDates(date1,date2); if(dog == 0 && emailSent == "no") { try { MailMessage Mailer = new MailMessage(); Mailer.From = "johnpyke@avonlakedental.com"; Mailer.To = email; Mailer.Bcc = "t_wasserman@lycos.com"; Mailer.Subject = "Avon Lake Dental Appointment Reminder"; string picPath = Request.QueryString.ToString(); string strBody = "Hello " + name + ". This is just a note to remind you of " + "your appointment at " + time + ampm + " on " + date1 + " for a " + procedure + ". This email reminder was set for you on " + apptSetDate + "."; Mailer.Body = strBody; Mailer.BodyFormat = System.Web.Mail.MailFormat.Text; SmtpMail.SmtpServer = "smtp- gh.AVONLAKEDENTAL.COM"; SmtpMail.Send(Mailer); //Change Value of EmailSent = "yes" } catch (Exception ex) { MailMessage Mailer = new MailMessage(); Mailer.From = "johnpyke@avonlakedental.com"; Mailer.To = "t_wasserman@lycos.com"; Mailer.Subject = "Avon Lake Dental Email Problem"; string strBody = "There was an error emailing out the Appointments. " + " Here is the message " + ex.Message; Mailer.Body = strBody; Mailer.BodyFormat = System.Web.Mail.MailFormat.Text; SmtpMail.SmtpServer = "smtp- gh.AVONLAKEDENTAL.COM"; SmtpMail.Send(Mailer); } ds.AcceptChanges(); } } } } Tag: DataRow.Select Weirdness! Tag: 63032
  - 15
    - Extending Typed DataTables I am facing the following problem in my applications and would like suggestions from you guys. My database schema has changed many times over the years and keeps chaging frequently according to specific client needs. My business layer (webservices) returns datasets to the thick client. The problem is that as the database changes so often, more than 800 datasets will have to be changed everytime. The solution suggested was as follows: a) Create 1 DataTable for each TABLE in the database. b) Create own DataSet for each visible screen or processing function by addind DataTables to this DataSet. c) Add Ref Contraints manually to this custom DataSet. This way, if the database changes, only one single DataTable class (schema) in the application will have to be changed. Now my problem is that i want to use Typed Datasets and Typed DataTables. What would be the best solution for this scenario. As mentioned on MSDN, DataTables can be instantiated independent of DataSets. In this case, the schema for the DataTable and the constraints are added manually in the code. But I could not find anything about extending Typed DataTables and using them independent of the DataSet. There is a powertoy by Shawn Wildermuth that helps you extend Typed DataSets, but i couldn't extrapolate his ideas to fit my requirements. Any ideas what the best thing for me would be ? Thanks, Nishith Tag: DataRow.Select Weirdness! Tag: 63013
  - 16
    - Translating XML to database hello , i am working on ASP.NET & C#. I want to insert/update/delete some datas to the database. the datas are based on the object. For example class Person { string name, address, pincode; }; i have related schema in the SQL Server database. can i store the above class object to the database with out using SQL query for insert/update/delete but using XML. because i need reusablity. if i do it using sql i need to change my query every time when ever modification of class. can anyone help me please. Thanks in advance. krish Tag: DataRow.Select Weirdness! Tag: 63012
  - 17
    - SQL Server not exist or denide access Dear friends my problem is this: I have installed MSDE and when try to connect to it by this code: Try Dim conn As New SqlConnection("server=VSDOTNET;uid=sa;database=master") conn.Open() If (conn.State = ConnectionState.Open) Then MessageBox.Show("Connection opened successfully") End If conn.Close() Catch ex As SqlException MessageBox.Show(ex.Message) End Try ....an msgbox show this message:"SQL Server not Exist or Denide Access". Why ?? Tag: DataRow.Select Weirdness! Tag: 62997
  - 18
    - Stores Procedures with Informix How I can handle to the stores procedures in informix 9.30? Thanks Tag: DataRow.Select Weirdness! Tag: 62995
  - 19
    - Cannot fill Dataset Hi, I am still a beginner concerning ADO.net. When I am trying to read data from a Access-file into a dataset I always fail... :-( I am using the following code. The DB-Connection (Me.Con) is established and open. The SQL-Code is correct and the specified table exists. Dim DA As New OleDbDataAdapter() DA.SelectCommand = New OleDbCommand _ ("SELECT MID, From, To, Subject FROM gmx", Me.Con) DA.TableMappings.Add("Table", "gmx") Dim Tbl As DataTable Dim NR As DataRow Dim DS As DataSet DS = New DataSet("gmx") DA.Fill(DS) .... The error "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll" occurs in at the DA.Fill(DS) Command. I can do what I want. I also tried just to fill a datatable, but I always get the same error. What am I doing wrong? Thanks, Sebastian Walters Tag: DataRow.Select Weirdness! Tag: 62990
  - 20
    - OleDbDataCommand problem I'm know the "old" implementation of ADO very well, and I am now trying to get used to ADO.NET. I've always preferred creating connection, commands and recordsets programmaticaly since every application I've built that needs data access allows for modifiable connection settings. This leads me to my question: When I create a OleDbConnection, OleDbCommand and OleDbDataReader to retrieve data from an Access database, everything works the way it should until I set the CommandText for the OleDbCommand object. It seems that if I try to order the results using the ORDER BY command an OleDbException is thrown with the following description: Unspecified error: E_FAIL(0x80004005) However, if I do not use and ORDER BY command, the exception is not thrown. Here's the code: public OleDbDataReader GetPopUps() { OleDbCommand cmd=new OleDbCommand(); OleDbDataReader dr; cmd.Connection=mcn; cmd.CommandType=CommandType.Text; cmd.CommandText="SELECT PUKey, Domain FROM PopUp ORDER BY Domain ASC"; dr = cmd.ExecuteReader(); cmd=null; return dr; } Any help would be greatly appreciated. Paul Tag: DataRow.Select Weirdness! Tag: 62989
  - 21
    - Can't find component or one of its dependencies?!? I have several COM+ objects (amongst others): BO.Dispatch, DAL.BaseDAL, Config, BF.Inventory, and DAL.Inventory Each object (except DAL.BaseDAL and Config) implements the IGateway interface (my creation; contains a single function, Gateway(String, String) As Object). Every object is registered in COM+ and the GAC. In this case, every object is in COM+ in a separate COM+ application, all as Server Applications running as the Interactive User. And I have the following sequence of events: TestApp.exe runs TestApp.exe calls a method on BO.Dispatch BO.Dispatch calls DAL.BaseDAL DAL.BaseDAL calls Config Config returns a connection string stored in the registry DAL.BaseDAL uses connection string to get a DataSet BO.Dispatch examines values in DataSet BO.Dispatch calls BF.Inventory BF.Inventory calls DAL.Inventory DAL.Inventory calls DAL.BaseDAL... What *should* happen is the DAL.BaseDAL calls Config for the connection string and gets another DataSet. However, I'm getting an error that DAL.Inventory can't create a DAL.BaseDAL object because it can't find it (full error is below). How can this be? It obviously *can* be found, since BO.Dispatch uses it just fine. All objects are compiled with references to the bin\[objectname].dll file they depend on, and the dependencies are set up so that, when I compile all the objects, DAL.BaseDAL is one of the first things to get compiled (after IGateway and Config). Specifically, here, both BO.Dispatch and DAL.Inventory are set to depend on BaseDAL. --Error follows-- {System.IO.FileNotFoundException} [System.IO.FileNotFoundException]: {System.IO.FileNotFoundException} HelpLink: Nothing InnerException: Nothing Message: "File or assembly name DAL.BaseDAL, or one of its dependencies, was not found." Source: "DAL.Inventory" StackTrace: " Server stack trace: at DAL.Inventory.SearchInventory(String Security, String Transaction) at DAL.Inventory.Gateway(String Security, String Transaction) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa ge msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at DAL.Inventory.Gateway(String Security, String Transaction) at BF.Inventory.PassThrough(String Security, String Transaction) at BF.Inventory.Gateway(String Security, String Transaction) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa ge msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [1]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at IGateway.Gateway(String Security, String Transaction) at modDispatch.ExecuteTransaction(String ObjectName, String Security, String Transaction) at BO.Dispatch.Gateway(String Security, String Transaction) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(Met hodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa ge msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [2]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at BO.Dispatch.Gateway(String Security, String Transaction) at TestApp.Form1.Button1_Click(Object sender, EventArgs e) in C:\WMS\TestApp\Form1.vb:line 111" TargetSite: {System.Reflection.RuntimeMethodInfo} Tag: DataRow.Select Weirdness! Tag: 62985
  - 22
    - Object reference not set to an instance of an object I am constantly receiving the "Object reference not set to an instance of an object" Exception when I try to set the autoincrement to true. I found the Knowledge Base Article 819346 which seems to address the error message, but how do I know that this is what is causing the problem..? If this is the route I must take, is the only fix for this is to upgrade to .Net 2003??? Here is the line of code I am receiving error on: Dim IdCol As String = "type_id" Dim ParentTable As String = "PgmTypes" 'Error occurs here Ds1.Tables(ParentTable).Columns(IdCol).AutoIncrement = True Ds1.Tables(ParentTable).Columns(IdCol).AutoIncrementSeed = -1 Ds1.Tables(ParentTable).Columns(IdCol).AutoIncrementStep = -1 Ds1.Tables(ParentTable).PrimaryKey = New Object() {Ds1.Tables(ParentTable).Columns(0)} sqlDataAdp.Fill(Ds1, ParentTable) uwGrid.DataSource = Ds1 uwGrid.DataMember = ParentTable 'Set the datakeyfield for the row.datakey property population uwGrid.Bands(0).DataKeyField = IdCol uwGrid.DataBind() Any help would be great, Thanks. Tag: DataRow.Select Weirdness! Tag: 62981
  - 23
    - Read This Look in this group threads there is an enourmous thread on just this in the last week or so Tag: DataRow.Select Weirdness! Tag: 62970
  - 24
    - try/catch question In building a web or windows based application, I'm not sure how best to set up my structured error handling. And any suggestions or known practice tips will be greatly apprecited. :) Specifically, in my classes that are called by a form (Web/Windows), do I try to be specific about the errors that are trapped or be more generic. Do I then be more specific on the forms? For example: Class public class DoSomethingHere public sub ASubRoutine try -- implementaion code here --- catch ex as exception throw ex end try end sub end class Windows form pub class frmMain inherits system.windows.forms.form private sub DoASubRoutine dim x as nw aSubRoutine try x.ASubroutine catch ex as sqlexception -- implemention code for a sqlexception here -- catch ex as system.arithmaticexception -- implement code for arithmatic exception here --- catch ex as exception -- implement generic exception code here -- end try end sub end class Any tips, advice, or pointers would be greately appreciated. Tag: DataRow.Select Weirdness! Tag: 62966
  - 25
    - Would like to learn asp.net, ado.net Hello. I am looking for some individual tutoring on ASP.Net and ADO.Net, in conjunction with reading/writing to an Access database. Ideally, I would like to get a "hello world" database up and running. I have learned a bit about each of these technologies through reading, although I am finding it rough going combining them to get a real-world project going. Is there anybody who'd be available for this sort of thing? I own Office 2000 and Visual Studio.Net Professional, as well as have a .Net web hosting account. I live in San Francisco, CA, and can pay (what I think is) a reasonable hourly fee. If anybody is interested, please email me at msofficeguyNOSPAM@yahoo.com. (remove the NOSPAM part) Thanks. Tag: DataRow.Select Weirdness! Tag: 62964
- Next
  - 1
    - DropdownList SelectedIndexChanged event I am using the SelectIndexChanged event for a dropdownList control. Currently, the only way the SelectIndexChange event is fired is after a user changes the selection within the dropdownlist AND clicks a command button. Does anyone know how to get this event to fire (or some other event) right after the user changes the selection w/i the dropdownList control? Tag: DataRow.Select Weirdness! Tag: 62961
  - 2
    - DataGrid question Does anyone know if you can disable the grid from allowing manual creation of new records, i want to only allow programitic creation and only allow editing of existinf records to take place in the grid. TIA Tag: DataRow.Select Weirdness! Tag: 62954
  - 3
    - problem with displaying new row Hello, My problem must be very simple to solve, but I havennt found the answer yet, so any help is appreciated. I have a form with bound controls, mostly textboxes, to an access database. When I fill the dataset the datatable which is used in the binding correctly populates the controls on the form. All navigation buttons work perfectly. The edit and delete button do their work without a problem. After a delete the label which displays current and total records by counting the rows in the table is decreased by one as it should. My only problem is after I add a new row. The row is added, but I can not navigate to it. The counter adds 1 record, so I know the add was successfull, but when I want to go to the last record it just doesnt do it. It stops at record 14/15. I use the me.databidings(dt).position = dt.rows.count - 1 to jump to the last record, which normally works, bt doesnt after I added a record. Finally, when I stop the application and restart the record the new record is added to the database and I can use it like any other record. Any ideas why I cant navigate to the new record after I created it? Thanks in advance. Tag: DataRow.Select Weirdness! Tag: 62944
  - 4
    - Earn $500 to $700 per Week Downloading FREE Software We know it sounds TOO good to BE true, but it?s REAL! Our International Technology firm will pay you hard cash each time FREE software is downloaded. Best of all you will only have to download ONE piece of software ONE time for FREE and you can be on your way to earning BIG! FIND OUT MORE BY VISITING http://JeromeMcCrea.PlugUsIn4Cash.com Tag: DataRow.Select Weirdness! Tag: 62943
  - 5
    - Login failed for user '(null)'. Reason: Not associated vs asp.net ASP.NET vs SQL Server¸ I have an ASP.NET Application In IIS I checked the Integrated Windows Authentication option In Web.Config the connection string include Integrated Security = SSPI and Impersonate=true in Web.Config When I start then Web Application I have this messge Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Could you help me PS My account have the permission to connect to SQl Server the security model is base on role security I have many users Tag: DataRow.Select Weirdness! Tag: 62936
  - 6
    - calculated column in datatable using parent's columns Can I use the parent table's columns in the Expression property of a DataColumn? Tag: DataRow.Select Weirdness! Tag: 62933
  - 7
    - Weird Timeout Expired error Hello all, Here is current snapshot of our environment: ASP.NET (C#) .Net Framework 1.0 SP2 MDAC 2.71 (SP1) Windows 2000 (Build 2195 SP3) SQL Server 2000 - 8.00.760 (SP3) We are using Microsoft SqlHelper from the Application Blocks and we currently have connection pooling = no Every now and then we get two types of errors: First Error: "System.Data.SqlClient.SqlException: General network error. Check your network documentation." This error tends to go away if we refresh the browser. Second Error: "System.Data.SqlClient.SqlException: Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." What is interesting about this error is that the procedure being called takes 1 parameter (a state UID) and returns within 3 seconds. I was getting an exception immediately (no 3 second delay) if I passed a state returning couple of hundred records consisting of VARCHAR and INT values, but works fine if there are fewer or no return values. Once I executed that same procedure using Query Analyzer for the problem state, the application started to work fine. It is happening on various procedure calls every few hours. I have looked on Microsoft's newsgroups, google, and on MSDN but I cannot find anything that applied to us. Any input would be appreciated. Fadi Tag: DataRow.Select Weirdness! Tag: 62930
  - 8
    - enforcing FK constraints on datatables that are not in a DS Hi All, I've created two datatables dtCountries and dtCities in memory. I am able to create a FK constraint on dtCities without adding these datatables to a dataset. But unless I add them to a dataset I am not able to enforce the constraint. Is there any way to enforce FK constraint without adding them to a dataset? TIA Sankar Tag: DataRow.Select Weirdness! Tag: 62926
  - 9
    - Returning a cursor from a stored procedure How do I capture a resultset from a stored procedure with ado.net code? ALTER PROCEDURE dbo.sp_ins_contacts ( @FName nvarchar(50), @LName nvarchar(50), @Initials nvarchar(50), @IntakeDate smalldatetime, @SSN nchar(10), @Advisor nvarchar(50 ) AS SET NOCOUNT OFF; INSERT INTO tbl_Contacts(FName, LName, Initials, IntakeDate, SSN, Advisor) VALUES (@FName, @LName, @Initials, @IntakeDate, @SSN, @Advisor); SELECT ContactID, FName, LName, Initials, IntakeDate, SSN, Advisor FROM tbl_Contacts WHERE (ContactID = @@IDENTITY) Tag: DataRow.Select Weirdness! Tag: 62925
  - 10
    - Returning a cursor from a stored procedure How do I capture a resultset from a stored procedure with ado.net code? ALTER PROCEDURE dbo.sp_ins_contacts ( @FName nvarchar(50), @LName nvarchar(50), @Initials nvarchar(50), @IntakeDate smalldatetime, @SSN nchar(10), @Advisor nvarchar(50 ) AS SET NOCOUNT OFF; INSERT INTO tbl_Contacts(FName, LName, Initials, IntakeDate, SSN, Advisor) VALUES (@FName, @LName, @Initials, @IntakeDate, @SSN, @Advisor); SELECT ContactID, FName, LName, Initials, IntakeDate, SSN, Advisor FROM tbl_Contacts WHERE (ContactID = @@IDENTITY) Tag: DataRow.Select Weirdness! Tag: 62924
  - 11
    - DefaultViewManager In MSDN library, it says that when data binding if you bind to a DataTable, in fact you bind to its DefaultView, and if you bind to a DataSet, in fact you bind to its DefaultViewManager. It is true for DataTable. If I use the following binding: dataGrid1.DataSource = dataSet1.Employee; dataGrid1.DataMember = null; Everytime I change the filter, the DataGrid changes, too. dataSet1.Employee.DefaultView.RowFilter = "Name < 'H'"; However, if I use the following binding: dataGrid1.DataSource = dataSet1; dataGrid1.DataMember = "Employee"; When I change the filter, the DataGrid is not responding. dataSet1.DefaultViewManager.DataViewSettings ["Employee"].RowFilter = "Name < 'H'"; I saw some programmers work around the problem by constructing a new DataViewManager. I wonder why Microsoft doesn't admit there is a bug, or say this behavior is by design. JT Tag: DataRow.Select Weirdness! Tag: 62921
  - 12
    - How do I query a DataSet to get unique IDs? Hi, I have a DataSet that contains data pairs for computers and IP addresses. Because in some cases a computer has multiple IP addresses, the HardwareID is in the DataSet multiple times. I want to create a DataView that has only the unique HardwareID's in the DataSet. How do I query my DataSet to get these HardwareIDs? Someone suggested DISTINCT but I don't know how to use DISTINCT against a DataSet to create a DataView. Could someone help me with this? Thanks, Sam Tag: DataRow.Select Weirdness! Tag: 62912
  - 13
    - String Error in ADo.Net Dataset code I am developing an database appliction using SQL 7 with a Visual Basic Front End using ADO.Net. When generating a dataset from the DataAdapter all the Textboxes and ComboBoxes contain the following error "'Convert' is not a member of 'String'" in the autogenerated DataSet Name.vb file. The error occurs in the following type Subs: Public Sub SetinvestigationNull() Me(Me.tablerer.investigationColumn) = System.Convert.DBNull End Sub If I comment out the "Me(Me.tablerer.investigationColumn) = System.Convert.DBNull" portion of the Sub the code compiles and runs correctly. Since I have many textboxes in the VB form, about 40, that is a lot commenting to get the application to run correctly. Is were a way to get the code to compile? Thanks Joe Tag: DataRow.Select Weirdness! Tag: 62909
  - 14
    - data file to database Hello I have a data file like this : 01 "" "09:04" "PLMDX " 3.20 0.35 1.74 0.23 2.49 0.17 1.37 0.18 03 02 "" "09:05" "PLMDX " 3.70 0.18 1.93 0.14 2.75 0.19 1.05 0.01 03 03... 04... ..... and i want to read each number and fileds and save it to variables to save it in to the database . with stream reader and file rader i can only read all of it as a single string , is that possible to do it with regular expression ? i don't know how . any idea ... help please Tag: DataRow.Select Weirdness! Tag: 62891
  - 15
    - What happens when you delete a DataRow ? I know that the state is changed to deleted, but what else happens ?, does the table make a new version of itself each time or the row ? The reason i'm asking is because I'm have a tough time understanding how making changes to more than one row ( but not more than one change per row ) and then trying to update the dataadapter can cause a concurrency error. There are no other users involved any assistance is appreciated in understanding this . . . Regards - Terry Tag: DataRow.Select Weirdness! Tag: 62889
  - 16
    - Oracle or SQLServer - .NET or J2EE? Hello, I am doing a very large web based database project. Over the period of 5 years, "more than 100, 000 Books" will be stored in a Database along with a LARGE amount of book attributes majorly consists of very large amount of people reviews about a book. We then need to analyze or generate reports from that large volume of STATIC data in Infinite number of ways. My questions are: Q1. Just to get general sence, Which suits the best Oracle or SQL Server for this project and Why? Keeping scalibility, volume of data, etc. in mind? Q2. Which development platform best suits best for this kind of project .NET or J2EE and Why. Q3. We have to analyze or generate reports from that STATIC data in Infinite number of ways, Which analysis technology should be used and Why? Thanks, Rafey. Tag: DataRow.Select Weirdness! Tag: 62884
  - 17
    - Connection Pooling with Microsoft Access? Hello, Is it possible to connection pool with Microsoft Access? I am coding in VB.NET and my application is giving me errors because the connection is still open and fetching records. Thanks! Tag: DataRow.Select Weirdness! Tag: 62883
  - 18
    - Unexpected error in webform any body seen this error? No error information available: E_UNEXPECTED(0x8000FFFF). 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.Data.OleDb.OleDbException: No error information available: E_UNEXPECTED(0x8000FFFF). It's random occuring mostly when i update the webserver with a fresh dll, but not every time. Only way around that is to re-start the application pool or re-start iis. My hunch at this time is that this is occuring because oledb and odbc providers are hosted in the same page. That's a wild guess though, not based on anything concrete. tia Tag: DataRow.Select Weirdness! Tag: 62856
  - 19
    - Cannot update Access database records I have code that inserts, updates, and deletes records from an Access 2002 table using OleDbCommand and OleDbConnections. Everything works great until I place the Access database on the network and more than one person launches the application. Everyone can still insert and delete but not update (using the custom app). Any ideas? Tag: DataRow.Select Weirdness! Tag: 62842
  - 20
    - [ANN] Innovation to ADO.NET - Object Access Services for .NET Innovation to ADO.NET - Object Access Services for .NET New Software Matisse Software Inc. provides its native ADO.NET Data provider for Matisse 6.0, the Database for .NET. Matisse Software has pushed the envelope of Microsoft ADO.NET architecture and extended it into a powerful Object Access Services component for .NET. Unlike the standard ADO.NET data provider, which returns data in a table format to integrate seamlessly with relational products, Matisse has extended the ADO.NET architecture to return data in an object format. http://www.matisse.com/ Tag: DataRow.Select Weirdness! Tag: 62836
  - 21
    - Schema problem with Strongly Typed dataset I have a strongly typed dataset whose schema looks as such: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="Dataset1" targetNamespace="http://tempuri.org/Dataset1.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/Dataset1.xsd" xmlns:mstns="http://tempuri.org/Dataset1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Dataset1" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="cc"> <xs:complexType> <xs:sequence> <xs:element name="usr" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="distributionList" nillable="true" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:simpleContent> <xs:extension base="xs:string" /> </xs:simpleContent> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="nam" type="xs:string" form="unqualified" /> <xs:attribute name="uid" type="xs:string" form="unqualified" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> I have a test function in a windows form in which I try to fill the dataset up with xml. My function looks as such: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New Dataset1 Dim xreader As XmlReader Try Dim stream As New System.IO.StringReader("<cc>" & _ "<usr uid=""123"" nam=""Test User"">" & _ "<distributionList>testing</distributionList>" & _ "</usr>" & _ "</cc>") xreader = New XmlTextReader(stream) ' I am crashing here ds.ReadXml(xreader, XmlReadMode.InferSchema) MsgBox(ds.GetXml) Catch ex As Exception MsgBox(ex.Message) End Try End Sub My believe my problem lies in the schema. If I specify multiple or zero distributionList nodes the xml is read into the dataset correctly. If I specify just one distributionList node I get a "Specified cast is not valid". Am I missing something in the schema? Thanks, Collin Tag: DataRow.Select Weirdness! Tag: 62835
  - 22
    - Proposed method implementation in a new generic data access component I've mentioned in other posts that I am creating a generic ADO.NET project. Version 1 is already done actually (see my signature, and read synopsis in docs) I am making alot of additions in version 2. One being the addition of a bunch of classes that form a "Gen" provider... (GenConnection, GenDataAdapter, etc...). In the constructor of each data object I'm adding an additional parameter specifying the "DbContext". For example the standard IDbCommand constructor... public IDbCommand() //creates a standard Command, must set properties separately In my GenCommand as proposed... /// <summary> /// This constructor will use the connection of the /// DbContext if it has a ConnectionString assigned. /// </summary> /// <param name="ctx"></param> public GenCommand(DbContext ctx) { _ctx = ctx; _cmd = _ctx.DbTemplate.Command(); if (_ctx.ConnectionString.Length > 0) { _cmd.Connection = _ctx.Connection; } } Do you think it is a bad idea to imply the Connection from the context? I require the context to be able to dynamically load the appropriate underlying provider (Sql, OleDb, ODbc, etc...). But should I also use it to imply the connection. If the user desired they could overide it and specifiy a different connection. However, for those lazy people, the context gives enough info to specify the connection. It behaves different than all the other providers, which is why I'm wondering if it is a bad idea? Any advice? Which would you prefer as a user? -- Michael Lang, MCSD See my .NET open source projects http://sourceforge.net/projects/dbobjecter (code generator) http://sourceforge.net/projects/genadonet ("generic" ADO.NET) Tag: DataRow.Select Weirdness! Tag: 62830
  - 23
    - how can I get the path for the error ORA-01458 it is told on the microsoft web site that to resolve this=20 problem i must contact "the microsoft support service"=20 and they will send me the patch. THERE IS TONS OF MICROSOFT SUPPORT SERVICE... which one=20 must i contact and how much it will cost... I leave in qu=E9bec - canada (i speak french) thanks Tag: DataRow.Select Weirdness! Tag: 62827
  - 24
    - Why is this login failing? I am using VS in conjunction with SQL Server 2000. I am trying to create a new SQLConnection but am getting an error message of "Login failed. Not associated with a trusted SQL Server Connection" I drag a SQLConnection to my components tray. In the Connection String property I say New connection. I give the server name (which is the name of my computer) and put the radio on specific name and password. I enter a user name of sa and a password of xxx. I click on the field "Select the database on the server" and get the above mentioned error, followed by "Login failed, Catalog info can not be retrieved". In the past I have solved this problem by going into SQL Server and in the Server, Properties, Security tab changing the authenication to SQL Server and Windows. My notes indicate that in the past when I've had this problem it was because the authentication was not set to mixed. However this does not seem to fix the problem in this case. Does anyone have any idea what's going on? Tag: DataRow.Select Weirdness! Tag: 62826
  - 25
    - Record Locking? How would I go about locking records using ADO.Net? It seems that everything in ADO.Net is based upon opening a connection, retrieving data, and closing the connection. To keep the records locked, is it as simple as leaving the database connection open? ~Thanks Tag: DataRow.Select Weirdness! Tag: 62817

Hi all,

I'm doing something really simple with my datarows:

Dim DIAL As DataTable
DIAL = DS.Tables("Dial")

' Define the whereClause as a string to select the record by refno
Dim whereClause As String = ("refno = " + CType(Me.refno, String) _
+ " AND campaignID = " + CType(Me.campaignID, String))

' Define an array of DataRows to hold the results of the query.
Dim DR() As DataRow
DR = DIAL.Select(whereClause)

Sometimes DR.Length returns > 1... BUT, the dataset is GUARANTEED to have
only 1 reference number that matches (I checked the database).

So my question is - how come DataTable.Select returns more than one
row... when in case there should be only one matching row?

Unfortunately this error happens rarely (once every 2500 - 3000
iterations)... so i can't use a debugger to reproduce it easily.

--
Lucas Tam (REMOVEnntp@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Top

Re: DataRow.Select Weirdness! by One

One
Tue Aug 19 02:18:32 CDT 2003

Sounds like a bug 2 me !

"Lucas Tam" <REMOVEnntp@rogers.com> wrote in message
news:Xns93DBBDAC5F048nntprogerscom@140.99.99.130...
> Hi all,
>
> I'm doing something really simple with my datarows:
>
> Dim DIAL As DataTable
> DIAL = DS.Tables("Dial")
>
> ' Define the whereClause as a string to select the record by refno
> Dim whereClause As String = ("refno = " + CType(Me.refno, String) _
> + " AND campaignID = " + CType(Me.campaignID, String))
>
> ' Define an array of DataRows to hold the results of the query.
> Dim DR() As DataRow
> DR = DIAL.Select(whereClause)
>
>
> Sometimes DR.Length returns > 1... BUT, the dataset is GUARANTEED to have
> only 1 reference number that matches (I checked the database).
>
> So my question is - how come DataTable.Select returns more than one
> row... when in case there should be only one matching row?
>
> Unfortunately this error happens rarely (once every 2500 - 3000
> iterations)... so i can't use a debugger to reproduce it easily.
>
>
> --
> Lucas Tam (REMOVEnntp@rogers.com)
> Please delete "REMOVE" from the e-mail address when replying.
> http://members.ebay.com/aboutme/coolspot18/

Top