using DetailsView control, update works, insert fails

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
    - Process slows when do Re-Query of Database Hi I am taking a db creating a dataset then reading some textfiles for changes to insert into the database After I process a file I requery (I call FillDS) the database to update my dataset to get the new inserted records into my dataset Everything works fine except the requery (I call FillDS) is slowing down the process - If I comment out the calls to the requery between files it speeds right along but with the requery in the code it bogs down. I -Is there a better way to design this?? Thanks private void FillDS(string strSQL, string sTable) { m_strSQL = strSQL; m_sTable = sTable; da = new OleDbDataAdapter(strSQL, cnn); cmd = new OleDbCommandBuilder(da); try { da.Fill(ds, sTable); } catch (Exception e) { } } public void UpdateDS() { da.Update(ds.Tables["Trans"]); } public void InsertTrans(string newvalue, int nType, string sProjName,string form) { string strSQL = "insert into Trans (field1,field2) Values (fieldval1, fieldval2)"; OleDbCommand cmd = new OleDbCommand(strSQL, cnn); if (!isopen) { cnn.Open(); isopen = true; } try { cmd.ExecuteNonQuery(); } catch { } } Tag: using DetailsView control, update works, insert fails Tag: 133474
  - 2
    - Ado.Net and Unicode (N') So, we're converting a large ASP.Net application from ASCII only to Unicode. The only issue we've run into, on SQL Server, is the N prefix for literals. We create all our Sql statements dynamically, and most of the time we do not (yet) use bind variables, we just construct the Sqls. So the questions is: Is it possible to add the N prefix "automagically" somehow? I guess the answer is; No, unless you use bind variables (Parameters). If so; how would I make this happen? Tag: using DetailsView control, update works, insert fails Tag: 133471
  - 3
    - CommandBuilder ConflictOption fallback I've already read the post about "CommandBuilder ConflictOption usage" http://groups.google.ch/group/microsoft.public.dotnet.framework.adonet/browse_frm/thread/e2de6b2ec4fc0f08/3519015bed9c9ba2?lnk=st&q=ConflictOption&rnum=1#3519015bed9c9ba2 Because this option is new, I tried out some of the options: CompareAllSearchableValues: - Behaves always independent of the table. CompareRowVersion: - Takes the Timestamp column if one exists. If no Timestamp column exists, it will fall back to "OverwriteChanges". This behaviour isn't described in the help. OverwriteChanges: - Uses PrimaryKey if one exists, else falls back to "CompareAllSearchableValues" as described in the help. The default option of the SqlCommandBuilder is "CompareAllSearchableValues". This isn't described in the help. MS, can you please confirm the behaviour! Thomas Tag: using DetailsView control, update works, insert fails Tag: 133470
  - 4
    - Creating a datatable on a SQL server from a dataset This is probably covered somewhere, but I am having a total brain cramp. I have a DataSet that gets loaded from an XML file. I want to do some processing on it and then save it to a SQL Server data table. I am currently doing by the brute force expedient of creating a SqlConnection, building a string that contains the SQL statements to CREATE the data table and then executing the SQL via an ExecuteNonQuery. It works, but there is a very nagging loud voice in my head telling me that I am doing it the hard way. If anyone know of an easier way or has a link to some sample code that does a similar type of process, I would be greatly appreciative. TIA, If it ain't broke....fix it anyway! [To Email Replies Remove the nospam from the address] Tag: using DetailsView control, update works, insert fails Tag: 133463
  - 5
    - Help: DataGridView Invalid data DataError Problem I have two tables feeding through one dataset: A main table with a foreign key into a lookup table. Primary keys in both tables are defined as INTEGER UNSIGNED NOT NULL. The foreign key in the main tables is defined as INTEGER UNSIGNED NULL. The main table is displayed through textboxes on the form, and a separate Combobox displays the selected, and list of lookup values from the lookup table. No data relations have been defined in the dataset. A bindingsource is used, as well as a binding navigator. This part of the form works fine. On the same form I have placed a DGV, with a subset of main table columns and one DGVCombobox column. Initially, this worked just fine. However a minor change to the database column names â?? not the data - has generated the invalid DataErrors. I have defined an error handler to trap the error and decode some information. The Column number points to the DGVCombobox, and the Context bits decode to â??Formatting, Displayâ??. Using the debugger to examine the details on the dataset, I noted that the primary key for the lookup table is defined as FullName of System.Int32. The primary key of the main table is defined as the same. However the main tableâ??s foreign key is defined as having FullName of System.UInt32. I have tried deleting the DGV and recreating it. The result is consistent and the same: as each cell of the DGV Combo box is displayed, the error exception is generated. The resulting displayed value is the foreign key value of the main table. Recall: no constructs were changed, only the column names were adjusted, and they have been thoroughly checked. Here is the code to set up the DGV. DgvCpyStatus is the DGV combobox column. dgvCpyList->DataSource = bindingSource1; dgvCpyName->DataPropertyName="CpyName"; dgvCpyPriority->DataPropertyName="CpyPriority"; dgvCpyID->DataPropertyName="idCompany"; dgvCpyStatus->DataSource=dataSet1->Tables->default["tblStatus"]; //The next line ties the DisplayMember to the foreign key dgvCpyStatus->DataPropertyName ="tblStatus_idStatus"; dgvCpyStatus->DisplayMember="StatusName"; //Textual status column dgvCpyStatus->ValueMember="idStatus"; //primary key column in tblStatus Tag: using DetailsView control, update works, insert fails Tag: 133460
  - 6
    - DataGrid - Array List - Ordering Columns Hi, I am using a datagrid in a windows app and binding it to an ArrayList. The columns in the array list were appearing out of order so I fixed that by using the DataGridColumnStyle object in the DataGrid and setting the MappingName of each column appropriately. My question though is on properties in the object that is in my ArrayList that are booleans. Before I created the DataGridColumnStyle object, the boolean properties showed up as checkboxes. Now, they show up as a string type with the value written out as "true" or "false". I'd much rather have the checkboxes. I tried to set the Format value to System.Boolean or Bool in the DataGridColumnStyle object and neither worked. Does anyone know what I should be doing? Tag: using DetailsView control, update works, insert fails Tag: 133459
  - 7
    - ?fill dataTable created at design time with dataAdpter at runtime Hello, I created a dataset and dataTable in the designer (VB2005) as the datasource for a Reportviewer control. Up to now I have been creating dataTables/datasets/dataAdapters on the fly at runtime. But I need to set field properties on the reportviewer at design time - could probably do it at run time - but too much code. So at run time I do this to fill a datatable on the fly dim da As new sqldataAdapter dim ds as new dataset da.selectcommand = new sqlcommand da.selectcommand.connection = conn da.selectcommand.commantext = "select * from tbl1") da.Fill(ds, "tblx") Now my dataset exists at design time along with the datatable. How do I fill the existing datatable? the runtime code above complains if I reference the dataset/dataTable I created at design time. Any suggestions appreciated. Thanks, Rich Tag: using DetailsView control, update works, insert fails Tag: 133458
  - 8
    - Q: Creating a head / detail view, not uppdating correctly? Hi! I am doing my first tries to create a order / detail view. I have created two tables in SQL, set relation from the details table to the head table. In Studio 2005 i use the DataSet wizard to create connection, creating the dataset. I select to add th head as simple fields, and the details as a grid. the wizard adds the, toolstrip with appropriate buttons etc. I run the application, i can add the orderhead, adding details. When i save only the orderhead is saved?!? Am i missing something, i tought it should update the details as well?! Any ideas? Point me in a direction or perhaps a link to neet page that will describe on how to do this. Regards Martin Tag: using DetailsView control, update works, insert fails Tag: 133457
  - 9
    - Multidimension string into DataTable Is there an easy way to move a Multidimension string array (string [][]) into a DataTable? I tried: ru.employerList is a string[][]. DataTable testTable; testTable = ArrayToDataTable(ru.employerList); This gives me an error: The name 'ArrayToDataTable' does not exist in the class or namespace 'integration.WebForm1' I have System.Data defined. Thanks, Tom Tag: using DetailsView control, update works, insert fails Tag: 133453
  - 10
    - Working with table adapters and multiple fills Having done all this untyped and with a lot of typing in the past, I'm trying to make efficient use of table adapters instead of data adapters. I understand that it's just a wrapper. But what I don't understand is how providing multiple fill methods gains me anything. For example, I want to pull both the phone number and the fax number for a particular contact. The value of both come from the PhoneNumber column in the PhoneNumbers table and the select differs only in their phone type. So I set up two fill methods to retrieve. However, clearly the datatable now contains ONLY the second fill. I don't see how this gains anything in terms of usability -- I may as well set up a second datatable in the dataset just for the fax numbers, and set up a separate fill there. this.phoneNumbersTableAdapter.FillOfficePhone(this.dsBrands.PhoneNumbers, _intContactID); if (dsBrands.PhoneNumbers.Rows.Count > 0) { dsBrands.PhoneNumbersRow rowPhone = dsBrands.PhoneNumbers[0]; if (!rowPhone.IsPhoneNumberNull()) { txtPhone.Text = rowPhone.PhoneNumber; } } // this fill would now overwrite the contents of the PhoneNumbers datatable this.phoneNumbersTableAdapter.FillFaxNumber(this.dsBrands.PhoneNumbers, _intContactID); ... Tag: using DetailsView control, update works, insert fails Tag: 133452
  - 11
    - da.update and Bool --> yes/no type In a data grid using Access as the data source.. The da.update is failing with "object reference not set to an instance of anobject" It looks like everything is ok and I was wondering if there is a problem that I have a bool column mapping to a yes/no type. __________________________________ Here is the code: Private Sub PopulateProductGrid() Dim conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source='C:\Program Files\MyProgramArea\Pricing\Pricing.mdb';Persist Security Info=False") Dim sSQL As String sSQL = "select * from ProductNames" conn.Open() Dim da As New System.Data.OleDb.OleDbDataAdapter(sSQL, conn) Dim cb As New OleDb.OleDbCommandBuilder(da) Try da.Fill(myDS, "ProductNames") DataGrid1.DataSource = myDS DataGrid1.DataMember = "ProductNames" Dim irow As Integer Dim icol As Integer irow = 0 DataGrid1.Select(irow) DataGrid1.SetDataBinding(myDS, "ProductNames") RowCount = DataGrid1.BindingContext(myDS, "ProductNames").Count() Catch ex As Exception MessageBox.Show("Failed to connect to data source") Finally 'conn.Close() End Try End Sub Private Sub ProductTypeSelection_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load PopulateProductGrid() StoreNameOut.Text = StoreName VolumeDiscountOut.Text = VolumeDiscount ' ' Create a Grid Table Style. Map it to the "Product Names" Table. ' Dim aGridTableStyle As New DataGridTableStyle aGridTableStyle.MappingName = "ProductNames" aGridTableStyle.AlternatingBackColor = Color.Lavender ' ' Create GridColumnStyle objects for the grid columns ' Dim aCol1 As New DataGridTextBoxColumn Dim aCol2 As New DataGridTextBoxColumn Dim aCol3 As New DataGridBoolColumn ' With aCol1 .HeaderText = "Code" .MappingName = "CODE_VALUE" .Width = 50 .Alignment = HorizontalAlignment.Center .TextBox.Enabled = False End With ' ' Set column's caption, width and disable editing. ' With aCol2 .MappingName = "CODE_MEANING" .HeaderText = "Prodcut Type" .Width = 515 .Alignment = HorizontalAlignment.Left .TextBox.Enabled = False End With With aCol3 .MappingName = "CODE_Selected" .HeaderText = "Select" .Width = 50 .Alignment = HorizontalAlignment.Center End With ' ' Add the GridColumnStyles to the DataGrid's Column Styles collection. ' With aGridTableStyle.GridColumnStyles .Add(aCol1) .Add(aCol2) .Add(aCol3) End With ' ' Add the GridColumnStyles to the aGridTableStyle. ' DataGrid1.TableStyles.Add(aGridTableStyle) End Sub Private Sub DataGrid1_Navigate(ByVal sender As System.Object, ByVal ne As System.Windows.Forms.NavigateEventArgs) Handles DataGrid1.Navigate End Sub Private Sub NextButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NextButton.Click DataGrid1.DataSource = myDS DataGrid1.DataMember = "ProductNames" Try da.Update(myDS, "ProductNames") Catch ex As Exception MsgBox(ex.Message) End Try PricingForm.StoreName = StoreName PricingForm.VolumeDiscount = VolumeDiscount PricingForm.Show() End Sub Tag: using DetailsView control, update works, insert fails Tag: 133451
  - 12
    - dataview relations hallo i try to fill 3 grids with relational data. customer -> orders -> orderdetail dvcustomer = dvm.createdataview( ds.tables["customer"]);//dvm->dataviewmanager dvorders = dvm.createdataview( ds.tables["orders"]); dvorderdetail= dvm.createdataview( ds.tables["orderdetail"]); foreach( DataRowView drv1 in dvcustomer) { dvcustomer = drv1.CreateChildView(drcustomer_orders); } foreach (DataRowView drv2 in dvorders) { dvorderdetail = drv2.CreateChildView( drorders_orderdetail); } grid1.datasource = dvm; grid1.datamember = "customer"; grid2.datasource = dvm; grid2.datamember = "customer.customer_orders";// relation grid3.datasource = dvm; grid3.datamember = "orders.orders_orderdetail";// relation it works fine , althgough grid3 shows the correct initial rows it is not updated when i change the current row in grid1 or grid2. when i change current row in grid1, grid2 is updated correctly. i have played around with the values for datasources/ datamembers but grid3 will not work as i expected. thanks for help sebastian Tag: using DetailsView control, update works, insert fails Tag: 133439
  - 13
    - rowfilter date formats Forgive me if this is not the right place to post this. I've already had it booted from the vb.database forum. ------------------------------ I'm thoroughly confused. The following expression works fine as a table view rowfilter when locale is set to US. dateField <= "#" & Now.ToShortDateString & "#" It fails when you set your locale to German. (Most embarassing for my client on a recent show and tell to his peers in Europe.:-))) Error is string is not recognized as date. Presumably because the day and month are switched in most of the world from what we do in the US. Luckily we "tested" this after the 12th of the month!!!! The following works: Dim noww As String = Now.ToString("MM/dd/yyyy") dateField <= "#" & noww & "#" At first I was puzzled because noww is e.g. 09.30.2006. On further reading the doco I see that the locale date separator is used. So the question is simple. Have I now stumbled across a formatting of the test string that will work regardless of the locale's date seperator, or have I encountered a bug, or what? More to the point where can i find a good definition of the syntax and semantics of rowFilter when dates are involved? Note MS Lurkers - as usual the VS 2005 help is as useless as <substitute your favorite off color expression for these circumstances>. It only shows an example and has nothing on globalization. (And this only after you follow your nose around the barn to "expressions"!) To use my recurring mantra these days - Yet another reason why VSTS 2005 is not ready from prime time:-) -- Regards, Al Christoph Senior Consultant Three Bears Software, LLC just right software @ just right prices @ 3bears.biz Microsoft Certified Partner (ISV) Coming soon: Windows Mail for Vista. Tag: using DetailsView control, update works, insert fails Tag: 133431
  - 14
    - A connection pooling error has occurred I am trying to clean an object in its Finalize method regarrding connection pbjects as follows : objConnection.Dispose() objConnection = Nothing shCard = Nothing The connection iscreated in another object as follows objConnection = shCard.CreateConnection I get the following error on the line "objConnection.Dispose() or objConnection.close *************************************** {System.InvalidOperationException} [System.InvalidOperationException]: {System.InvalidOperationException} HelpLink: Nothing InnerException: Nothing Message: "A connection pooling error has occurred." Source: "System.Data" StackTrace: " at System.Data.SqlClient.SqlConnection.Close() at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing) at System.ComponentModel.Component.Dispose() at ConfigBAL.ShoppingCartDB.Finalize() in C:\Inetpub\wwwroot\Configurator\Components\ShoppingCartDB.vb:line 977" TargetSite: {System.Reflection.RuntimeMethodInfo} ********************************************* Does that mean that I can not close or dispose a connection object because of pooling As I said in a previeou post, I have user connections depassing the default, which I think is 100 by default Thanks Tag: using DetailsView control, update works, insert fails Tag: 133424
  - 15
    - Storing data from multiple clients Hi to all. I'm developing a network server application which will be constantly receiving data from mobile GPRS clients and storing them in a centralized database (probably SQL Server or Oracle); from the server's point of view, the clients will just be standard TCP/IP clients, sending data using a custom protocol I'll design. The data will be sent to the server in messages, which will contain very small amounts of data (a bunch of floating point numbers), but will be sent quite often, every second or even faster. The number of client is not pre-determined, but the application needs to be able to scale up to hundreds of clients. The server won't do any processing on the incoming data, just add a timestamp and the client's ID and INSERT a new row in a table. I'm going to use async sockets to handle the connections from the clients, so the data storing actions will be triggered by incoming socket data and will be handled by the socket callback methods; I think this is much better than using worker threads to wait on the sockets, since the number of simultaneous connections can potentially become quite high (am I right on this?). Now, my question is: which is the best way to do an INSERT on the DB every time a data message arrives from a connected socket? I (obviously) don't want to manually open and close a DB connection every time; I could open one when the server starts and do all of my data access using that one, but I don't know how this method works when using a multithreaded application; if I have to use some form of mutual exclusion here, then the single DB connection will become a bottleneck. I've heard about using connection pooling, but I don't actually know how it works and if this is the ideal technique for this scenario. Can someone please help? :-) Thanks Massimo Tag: using DetailsView control, update works, insert fails Tag: 133416
  - 16
    - Marginalizing parameter In case I had a parametric query SELECT Name, Phone from MyFriends WHERE MyFriends.city = @CITY is it possible to specify a string value for @CITY in order to have the query to behave exacly like : SELECT Name, Phone from MyFriends ?? In other word, if this is possible, what is the parameter value which would correspond to eliminate the WHERE condition ? Or do I have necessary to remove the "where" part? -P Tag: using DetailsView control, update works, insert fails Tag: 133414
  - 17
    - Subselect, TableAdapter and MS-Access 1) I generated a Subselect query in MS-Access which works fine there: SELECT (SELECT Name FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerName, (SELECT Surname FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerSurname, * FROM PlannedGames This Subselect is recommended in Scott Mitchel's excellent MSDN Article "Creating a data access layer". Then I cut&paste this select statement into the TableAdapter Configuration Wizard. This generates SQL parsing errors. Does the ADO.NET 2.0 provider for MS-Access not support Subselects? 2) In general is there a comparison table which SQL-Server 2005 features / .NET 2.0 classes are not available/working when using ADO.NET 2.0 and MS-Access 2003 ? thank you very much herbert Tag: using DetailsView control, update works, insert fails Tag: 133413
  - 18
    - Timeout expired connection Ihave an application (.Net 1.1, wi2k3 SP1, SQL 2005) that works fine after severalminutes of browsing then I start to get the following error : Servor Error in '/myVirtualServer' Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. Thismay have occured because all pooled connections were in use and max pool size was reached. I have several connections opened/closed that use the same connection string What might be the issue? Is there a parameter to fine tune the number of connection allowed. Thanks Tag: using DetailsView control, update works, insert fails Tag: 133412
  - 19
    - Update Access DB from a Data Grid I have a data grid with three columns Text1, Text2, Bool3. I would like to have the user check/uncheck in Bool3 column and automatically update the Access DB. One other thing I have Text1 and Text2 and readonly and the user can only modify the Bool3 column; is there a way to have the user only in the bool3 column and never in the Text1 or Text2 columns. Thanks, Steve Tag: using DetailsView control, update works, insert fails Tag: 133406
  - 20
    - Async Ado.Net Operations (Begin/End OpenConnection) We're building high performance database applications, and are trying to use all the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the BeginExecuteCommand, but without the BeginOpen on the connection we end up with lots of deadlocked threads, all waiting for SqlConnection.Open. This means things are more-or-less useless. We looked briefly into MARS for doing this, as that might be an option, but we really prefer the more standard Async stuff as it maps much easier into working with other database providers such as Oracle. What's frustrating is that early Whidbey builds, and many old ADO.Net 2.0 articles, refer to these methods so they existed at one point. These methods were obviously removed during the .NET 2.0 RTM process, which seems really strange. Any ideas how to work around this and actually do highly scalable I/O using the Async infrastructure in ADO.NET 2.0? -- Chris Mullins MCSD.Net, MCPD Enterprise http://www.coversant.net/blogs/cmullins Tag: using DetailsView control, update works, insert fails Tag: 133397
  - 21
    - ADO.NET 2.0 Asynchronous Command Execution: Independant of Web Session? I have a small ASP.NET 2.0 application that needs to be able to kick off a long stored procedure (for importing and processing tables ) and then allow the user to continue with the session, perform other tasks, and log out without having to wait for the SP to complete. I read the following article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/async2.asp This looks very promising but I could not figure out what would happen to the thread if the user logged out before it completed. The stored procedure could take several hours depending on the parameters selected so I need the command to be independant of the web Session. Will it keep running or die when the user logs out? If it dies, can anyone suggest a way to set it up so it will run until complete? Thanks for your help! Tag: using DetailsView control, update works, insert fails Tag: 133388
  - 22
    - Getting Oracle Error Hi I'm trying to run a queries on a schema, and I keep getting ORA-00911: invalid character error. If I copy/paste it in SQL/Plus it runs fine. This is what I'm doing in code: //Set session here to ZGK037_MDB string sqlSession = string.Format("ALTER SESSION SET CURRENT_SCHEMA={0}", oDB.DatabaseName); //Note I don't close the Connection Object in this call. It just gets an OracleCommand Object cmdOracle = MiscDataUtils.GetCommandObj(sqlSession, oDB.Connection); //Execute the sqlSession query cmdOracle.ExecuteNonQuery(); //This is what it shows in my logfile...so it looks like the above worked with no exceptions [Logging-DEBUG]-9/29/2006 10:22:45 AM [GetCommandObj] ALTER SESSION SET CURRENT_SCHEMA=ZGK037_MDB Next I try to run a query on this command obj cmdOracle.CommandText = sql; //Set to my new SQL string rdr = MiscDataUtils.GetDataReaderFromCommandObj(cmdOracle); This is what the log file says: [Logging-DEBUG]-9/29/2006 10:22:45 AM [GetDataReaderFromCommandObj] Select RoFm.SymCount as Occ, csd.oid as SymbolOID, csd.m_progID as ProgID, csd.m_version as ProgVersion From CORESymbolDefinition csd, (Select Count(*) as SymCount, fm.m_defname as RoFmID FROM CORERelationOrigin RO JOIN COREFlavorMgr FM ON RO.oidTarget = FM.oid JOIN CORESymbol S ON RO.oid = S.oid Group By fm.m_defname ) RoFm Where csd.m_progID=RoFm.RoFmID Order by csd.m_progID; [Exception] ORA-00911: invalid character Any help is really appreciated. Sunit Tag: using DetailsView control, update works, insert fails Tag: 133385
  - 23
    - TableAdapter vs DataAdapter Hi, I was wondering when to use TableAdapters (TA) and when to use DataAdapters (DA). If I've got a typed dataset containing multiple related tables, I would say use a DA to fill the dataset. Why should I use TA instead? I can imagine situations where may be just one table from the dataset is needed, in that case you might say, use a TA. I agree on that. What about updating a typed dataset containing multiple related tables. In that case I also would use a DA rather than TA's. I presume I will need multiple TA's when updating multiple tables in this typed dataset (i.e. added orderd and orderdetails in the typed dataset). Conclusion: If I want to use just a few tables I would better fill the tables using TA's and if I've got just one table to update I could also use a TA. But when filling a dataset in one operation and when updating multiple tables in a dataset I would better use a DA. Is this correct? P.S.: I will not use SQL in code, just SPROC's Tag: using DetailsView control, update works, insert fails Tag: 133383
  - 24
    - Casting - IDataParameter Is there some way to cast a IDataParameter to a SQLParameter? It's not working and I'm not sure why. Tag: using DetailsView control, update works, insert fails Tag: 133381
  - 25
    - xmltype oracleclient Hi - Does anyone know if the xmltype oracle column data type is supported in system.data.oracleclient? ---------------- Sal .NET 2003 Oracle 9i Tag: using DetailsView control, update works, insert fails Tag: 133379
- Next
  - 1
    - Connection pooling parameters not working for Oracle connection I am using OracleConnection to connect to Oracle 9i Database from a VB.NET project the connection string has the parameters "User ID", "password", and "Data Source". my project import System.Data.OracleClient I tried to add connection pooling parameters like "Connection Timeout", "Incr Pool Size" and "Min Pool Size" to the connection string string but for each one I get the error that this parameters is not supported, when I try to open the connection any clue ? Tag: using DetailsView control, update works, insert fails Tag: 133378
  - 2
    - Export Table to dBase 3 (.dbf) Hi! Does anybody know the best way how to export a DataTable to a dBase 3 file? Regards Stephan Tag: using DetailsView control, update works, insert fails Tag: 133377
  - 3
    - InvalidOperationException when changing value in XmlDataDocument I'm using a XmlDataDocument to interface a DataSet. When trying to change the value of a node (I'm actually using InnerXML) I get an InvalidOperationException saying "Please set DataSet.EnforceConstraints == false before trying to edit XmlDataDocument using XML operations.". Is it not possible to make changes in the DataSet without setting EnforceConstrains to false? If I set the EnforceConstraints to false, all values that are constrained may be overrided. I only want to be able to set values that are not constrained. Tag: using DetailsView control, update works, insert fails Tag: 133375
  - 4
    - Remove association between DataSet and XmlDataDocument I have a DataSet that is not cleared untill the application is closed. But I want to associate a XmlDataDocument to the DataSet several times. If I try this I get an ArgumentException saying that a XmlDataDocument cannot be associated with a DataSet that already has an association. How do I remove this association without clearing the DataSet? Another possibility would be to retrieve the reference to the XmlDataDocument from the DataSet, but such a reference doesn't seem to exist? Tag: using DetailsView control, update works, insert fails Tag: 133374
  - 5
    - What happened to SqlConnection.BeginOpen? We're building some very high performance database applications, and are trying to use all of the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the BeginExecuteCommand, but without the BeginOpen on the connection we end up with lots of deadlocked threads, all waiting for SqlConnection.Open. We looked briefly into MARS for doing this, as that might be an option, but we really prefer the more standard Async stuff as it maps much easier into working with other database provides such as Oracle. To do this with MARS, we would still need this BeginEnd methodology. What's frustrating is that early Whidbey builds, and many old ADO.Net 2.0 articles, refer to these methods so they existed at one point. These methods were obviously removed during the .NET 2.0 RTM process, which seems really strange. Any ideas how to work around this and actually do highly scalable I/O using the Async infrastructure in ADO.NET 2.0? -- Chris Mullins MCSD.Net, MCPD Enterprise http://www.coversant.net/blogs/cmullins Tag: using DetailsView control, update works, insert fails Tag: 133370
  - 6
    - Oracle connection error when called from web service Hi, I'm having a web service which connects to a Oracle database and gets the results. When running the web service individually the database gets connected and the results are downloaded. I'm calling the same web service from another web service, the Oracle connection is not made, it provides me a exception "ORA-12154: TNS:could not resolve service name". The web services used to work perfectly until for some other purpose i changed the tnsnames.ora file, after that i reverted back with the changes earlier (which was working). But still if there is any problem in tnsnames.ora file, then the first web service should also not get connected to database. I don' t know how it gets connected. Following is the code used, string query = GetQuery( ID ); // Create a Oracle connection. OracleConnection dBConn = new OracleConnection(); // Provide the connection string details. dBConn.ConnectionString = "User Id=XXXX;Password=XXX;Data Source = XXX"; // Frame a Oracle command. OracleCommand cmd = new OracleCommand( query ); // Connect the command to connection for the Oracle database. cmd.Connection = dBConn; try { // Open the connection. dBConn.Open(); } catch( Exception ex ) { } Can anyone provide me a pointer about what is happening and how to solve the same?? Regards, Chandra Tag: using DetailsView control, update works, insert fails Tag: 133368
  - 7
    - Executing an sql script on a remote database from Visual Studio .NET 2005 I am connecting to a remote SQL Server database from Visual Studio .NET 2005. I have an sql script located on my machine containing the sql code I want to use to create several tables, and want to execute it. How can I do this from Visual Studio .NET 2005? I do not like designing the database using the designer because sometimes the designer uses different words, phrases things differently, and causes me to be unsure exactly what the properties of the fields in my database are. If anybody know how to do this, please let me know. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: using DetailsView control, update works, insert fails Tag: 133367
  - 8
    - Query works in Query Analizer but not as part of a table adapter I'm trying to run a query to return all of the customers who have not placed an order. This query runs fine in Query Analizer but when I try to run it as part of a table adapter it returns all rows (customers with orders AND customers without orders). It appears that the second select is not being utilized. What am I missing? SELECT CustomerID, Name FROM Customers WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders WHERE (OrderMonth = 9) AND (OrderYear = 2006)) Thanks, Tom Tag: using DetailsView control, update works, insert fails Tag: 133364
  - 9
    - DataBindings : wrong data displayed Hello, I'm using databindings to display data from a datatable. When I first fill my datatable, it works perfectly, and displays the current data. If I remove the datatable, and recreate it with new data, it's not working anymore : the displayed data are from the first fill of the Datatable ! (I checked, it's not the same DataTable anymore). Here's my code : SqlDataAdapter sqlda = new SqlDataAdapter("SELECT * From Data",Cnx); if (GlobalDS.Tables.Contains("Data")) { GlobalDS.Tables.Remove("Data"); } sqlda.Fill(GlobalDS, "Data"); txtName.DataBindings.Clear(); txtName.DataBindings.Add("Text", GlobalDS,"Data.Name"); Thanks, Tag: using DetailsView control, update works, insert fails Tag: 133354
  - 10
    - Creating dataset.xsd file programmatically as dragging table from Server explorer fails Visual studio 2003, MySQL database, MySQL odbc 3.51 driver Is it possible to create the file dataset.xsd programmatically? I'm trying to create my dataset1.xsd file for using with crystal reports. The database is mySQL and the data connection is sat in my server exporer bar. The tables and fields are enumerated correctly in the server explorer, but when i try to drag and drop any item onto the dataset1.xsd designer surface I receive a sql error - "The wizard detected the following problems when configuring the data adapter for "users". Details: Error in SELECT clause: exression near "" Error in FROM clause: near "" Unable to parse query text." If I press OK, then i receive the message - "The following unexpected error has occurred: There were errors dropping "users" onto the designer. The XML schema could not be interpreted from this object. " Im stuck and relatively inexperienced so I don't know where to go from here. I thought that it might be possible to create a dataset from code then write it to file. How would I go about this please? Tag: using DetailsView control, update works, insert fails Tag: 133353
  - 11
    - DTSWizard Are there any tools around similar to MSSQLs DTSWizard for importing data into a DataTable? The DTSWizard has many nice features which I would hate to recreate if it's already been done. Thanks, Joe Tag: using DetailsView control, update works, insert fails Tag: 133336
  - 12
    - ado & Active directory I am using ado to connect to active directory in a web application. I create the command: objConnection = new adodb.connection objCommand = New adodb.Command objConnection.Provider = ADSDOObject objCommand.Properties("Page Size").Value = 1000 objCommand.Properties("SearchScope").Value = 2 I have one server, one IIS, 2 directories. All permissions are the same that I can tell on both directories and IIS settings. However, when I run the above on one of the directories, it run fine, on the other I get this error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Enum.InternalGetValue() at System.Enum.System.IConvertible.ToBoolean (IFormatProvider provider) Why would I get this error on one directory and not the other, exact same program, same web.config, everything I can think of is exactly the same. And whatever could be the cause?? Thank you for your help. Tag: using DetailsView control, update works, insert fails Tag: 133335
  - 13
    - How do I connect to SQL database using applicaiton roles and ado.net? My MSDE database uses Application Roles. When I run my asp.net application I cannot open the database, I get a Logon Failed exception. I need to be able to open the DB to run the sp_setapprole stored procedure for my role access. Is there some other way that I can do this? So far the only way I can get this to work is to give the ASP.NET process SYSTEM rights. I would prefer to use the ASPNET user rights. My connection string is as follows: "Pooling=false;Server=(local);Integrated Security=SSPI;Database=MyDb" -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: using DetailsView control, update works, insert fails Tag: 133334
  - 14
    - Trapping for Connection and Command Timeout FW: 1.1 What is the best method for trapping timeout exceptions? There does not seem to be specific exceptions thrown for connection or command timeout. Should I check the message for "Timeout", or is there some other propery in the exception that better identifies a connection or command timeout? Thanks for your help. Tag: using DetailsView control, update works, insert fails Tag: 133333
  - 15
    - SQL Question Hello: I have a SQL question. If this is the improper board to post this question on, please let me know where you would suggest I post it. I have a SALES table with the following schema and structure. ID Status Date -- ------ ---- 1 Open 1-1-2000 2 Open 1-1-2001 3 Closed 1-1-2002 4 Open 1-1-2003 5 Closed 1-1-2004 I want to write a query that returns all the records where it first does a count of all the statuses, identifies where the count status is > 2, then display each record where the status = the status which has been identified as having a count of > 2. So the results I want back are: ID Status Date -- ------ ---- 1 Open 1-1-2000 2 Open 1-1-2001 4 Open 1-1-2003 So I write a query something like this: SELECT count(status), id, date FROM sales GROUP BY status HAVING count(status) > 2 I get a SQL error saying that I have to add "id" and "date" have to be in the GROUP BY clause. But when I put those fields in the GROUP BY, then the count does not calculate right and I get no results back. Could anyone enlighten me as to what I could do to fix this? Tag: using DetailsView control, update works, insert fails Tag: 133320
  - 16
    - pStartInfo in C#.Net Hi all, I want to do the foll. I want to get the process running in the name system, with name "abc", and in turn get their arguments, so that i do some processing later Foll. is my code: Process proc = new Process(); proc.StartInfo.FileName = "notepad.exe"; proc.StartInfo.Arguments = "abc.cs"; proc.StartInfo.UseShellExecute = false; proc.Start(); Process[] p = Process.GetProcessesByName("notepad"); string args = p[0].StartInfo.Arguments.ToString(); Console.WriteLine("args: " + a); //this is retning null - shd retn abc.cs string b = p[0].BasePriority.ToString(); Console.WriteLine("BASE PRIORITY: "+ b); //this comes out correctly With the above code, args is returnin a null string. (Also abc is currently running-obvious 'coz i didnt get any InvalidOperationException). when i try to print the parameters other than that of StartInfo, its working fine-only in case of StartInfo params. Tag: using DetailsView control, update works, insert fails Tag: 133314
  - 17
    - Using crystal reports with MySQL ADO connector I am a developer with limited database and zero crystal report experience. I am very confused. We wanted the ability to switch database providers easily, so I selected to use ADO components with our application. The database we're developing with is MySQL. I downloaded their MySQL Connector/NET components which are ADO compliant. Using .NET connectors, if we want to switch to another provider, there should be minimal code changes necessary to make it run. It all works fine so far. I connect to the remote database at run time using a connection string read from stored configuration information. Now I need to add reporting capabilities to the application, using Crystal reports, and this is where Im confused. http://support.businessobjects.com/communitycs/technicalpapers/rtm_reportingoffadonetdatasets.pdf This example shows preparing data for use in a web project. Ours is a desktop application. So far I've tried to keep all of this as generic and configurable from config files as possible. The example in the above link uses a wizard to link to OLE DB provider registered on the local pc. This immediately ruins the portability as it's done through a wizard. Is OLE DB the "same" as ADO? Do I need to download and install OLE DB drivers from mySQL's site? I wondered if once you've used this wizard, at later dates you can programmatically change server information. Is that possible? thanks :-) Tag: using DetailsView control, update works, insert fails Tag: 133313
  - 18
    - How to keep ALTER SESSION settings Hello All I'm trying to execute queries on a specific schema using ALTER SESSION as string sqlSession = string.Format("ALTER SESSION SET CURRENT_SCHEMA={0}", oDB.DatabaseName); MiscDataUtils.ExecuteNonQuery(sqlSession, oDB.Connection); //Change Session Here //However this one fails since this is another connection rdr = MiscDataUtils.GetDataReader(sql, oDB.Connection); Is there a better way to do this. ?? thanks Sunit Tag: using DetailsView control, update works, insert fails Tag: 133312
  - 19
    - Non English Characters Hi, We are developing a small web interface to a local ERP software, which uses SQL Server 2000 as database. The database uses SQL_Latin1_CP1 collation, and the fields are varchar (not nvarchar), however, the main program inserts and reads non-English (Turkish) characters into these columns. However, when we connect to database with ADO.NET, these characters are not read correctly. (The situation is same when I check tables with Enterprise Manager and Query Analyzer) In a past situation (which was about a Win32 application), I have heard about character conversion behaviour of ADO (and many other DB libraries) and solved that problem using BDE instead of ADO, so that the connection is made via DB-Library instead of OLEDB. But this way cannot be applied to my ASP.NET situation, and there is NO way to change database collation. Must I use a ADO.NET property, or use another provider, or maybe another library? Any advices? Thanks... Tag: using DetailsView control, update works, insert fails Tag: 133310
  - 20
    - Corrupted TableAdapter I have this a Data Set. In that data set I have three table adapters, each has there own queries. For some unknown reason, after I added two new fields to the database and mofified the store procedure to retrieve the new fields, in addition too the other fields it already retrieves, and finally modified the tableadapter "GetAssetsById" to retrieve the new fields the TableAdapter Wizard insists on putting a "GetData" as a Return a DataTable Method even though I have uncheck the box. Now my applications fails to execute. I am getting errors everywhere that uses this tableadapter. Sorry I tried but could not supply the code for the tableadapter. Tag: using DetailsView control, update works, insert fails Tag: 133306
  - 21
    - db2 commands on .net hi, i'm using db2 v8.2 and .net 2005. i'm trying to execute db2 commands but i can't . forexample, i can't get list of aliases or i can't create a new database. how can i solve this problem? please help me. Tag: using DetailsView control, update works, insert fails Tag: 133303
  - 22
    - Problem with proc.kill() Hi, My case is, i am trying to kill a process (SQLPLUS process) in my Win. Service, when either the Service is stopped or when my app exe is killed from the Task Manager. The problem is, when i kill the SQL process, its not getting killed, and its running and running. I find this in both the cases of stopping the service and killing the exe. What can i do to kill the process, because killing SQLPLUS is critical; and because of this problem, two SQLPLUS processes are overlapping with each other, when the next time i start the exe/service. Thus, my output file, where actually i spool data (using SQLPLUS) becomes inconsistent and this is bad. I couldn't find any alternative to proc.kill() [which shd. actually kill the process immediately] Can any of u help me out in this ASAP?? Tag: using DetailsView control, update works, insert fails Tag: 133302
  - 23
    - CommandBuilder and Identity Field Hi, I used a commandbuilder for my DataAdapter. i have a dataadapter "Pather" and a dataadapter "Sons" in "Pather" table i have and identity field that i use in "Sons" table to join them. How can i know with identity number i have for my new "Pather" row ? How can set my "sons" rows with this identity value ? I hope my bad english is little clean. Thank's a lots Tag: using DetailsView control, update works, insert fails Tag: 133300
  - 24
    - using access as database Hey everyone, I want an advice. I want to build a site as an internet application using database etc. Since I need to use database , I'm interested in something not expensive for my own needs. I thought about using sqlServer, but I know that it is very expensive. Though I thought to use Access. - Did anyone use Access in an Asp.net application ? - Is it comfortable and runs ok ? - Does Microsoft continue to develope and support this tool ? - Which Access do I need for my purpose ? the simple one that comes with office 2003 ? Thanks a lot for any answer !!! Tag: using DetailsView control, update works, insert fails Tag: 133298
  - 25
    - haii...adding bunch of records haii... i neeed to know how to add a bunch of records to a database table from c#.net coding.. please sugest me .... Tag: using DetailsView control, update works, insert fails Tag: 133293

Here are the commands in the sqlDataSource line.

InsertCommand="INSERT INTO T_ADMIN_LOGIN (ALID, LNAME, FNAME, USERID,
DOMAIN, STATUS) VALUES (S_ADMIN_LOGIN.NEXTVAL, :Lname, :Fname, :Userid,
'AAC', 1)"

UpdateCommand='UPDATE T_ADMIN_LOGIN SET LNAME = :Lname, FNAME = :Fname,
USERID = :Userid, STATUS = :Status where alid=:alid'>

The update works fine. The insert fails with: ORA-01036: illegal
variable name/number

Anyone got any ideas?

TIA
Chris

Top

Re: using DetailsView control, update works, insert fails by ReyN

ReyN
Wed Oct 04 10:59:55 CDT 2006

S_ADMIN_LOGIN

shouldn't this be T_ADMIN_LOGIN?

Top

Re: using DetailsView control, update works, insert fails by oaksong

oaksong
Thu Oct 05 16:02:24 CDT 2006

No. It's an Oracle sequencer, not a table.

ReyN wrote:
> S_ADMIN_LOGIN
>
> shouldn't this be T_ADMIN_LOGIN?

Top