concurrency violation where it makes no sense to have one

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
    - =?Utf-8?Q?Is_there_a_way_to_set_=22Jet_OLEDB?= Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: concurrency violation where it makes no sense to have one Tag: 113027
  - 2
    - Dynamically Populating a SqlParameter object I'm using the SqlHelper object model from MDAAB, which requires that I pass in a SqlParameter object if I have more then parameter when calling a Stored Procedure. My current code seems verbose in the setup of this parameter and I'm trying to figure out if there is a better approach to populate this object. Here is a sample in VB that uses SqlHelper to call a Stored Procedure: Public Shared Sub GatewayRecordCreate(ByVal GatewayName As String, _ ByVal ResponseString As String, _ ByVal UserEmail As String, _ ByVal TranAmount As String) ' Public Consts used to store element position in String Array, used in other classes Const PositionGatewayName As Short = 0 Const PositionResponseString As Short = 1 Const PositionUserEmail As Short = 2 Const PositionTranAmount As Short = 3 Const PositionMaxElement As Short = 3 Dim returnVal(PositionMaxElement) As String ' String Array returned by function Dim parms() As SqlParameter = New SqlParameter(PositionMaxElement) {} 'Used to hold Details from DB ' @GeneratedBy Input Parameter parms(PositionGatewayName) = New SqlParameter("@GatewayName", SqlDbType.VarChar, 200) parms(PositionGatewayName).Direction = ParameterDirection.Input parms(PositionGatewayName).Value = GatewayName ' @ResponseString Output Parameter parms(PositionResponseString) = New SqlParameter("@ResponseString", SqlDbType.VarChar, 5000) parms(PositionResponseString).Direction = ParameterDirection.Input parms(PositionResponseString).Value = ResponseString ' @UserEmail Output Parameter parms(PositionUserEmail) = New SqlParameter("@UserEmail", SqlDbType.VarChar, 100) parms(PositionUserEmail).Direction = ParameterDirection.Input parms(PositionUserEmail).Value = UserEmail ' @TranAmount Output Parameter parms(PositionTranAmount) = New SqlParameter("@TranAmount", SqlDbType.VarChar, 20) parms(PositionTranAmount).Direction = ParameterDirection.Input parms(PositionTranAmount).Value = TranAmount ' Call ExecuteNonQuery static method of SqlHelper class ' Pass in database connection string, command type, stored procedure name and an array of SqlParameter object SqlHelper.ExecuteNonQuery(Global.ConnectionString, CommandType.StoredProcedure, "spGatewayTranInsert", parms) End Sub My primary goal is to improve the code so that I don't have to setup Constants and hard code the PositionMaxElement value which is used SqlParameter object. Any thoughts? Please post or point to VB source code if you are replying. I learn best by example. Thanks. Tag: concurrency violation where it makes no sense to have one Tag: 113025
  - 3
    - The asp services blocked I have a problem about asp.net and databases in Access. Every time the asp service is blocked. When this happens i must phone to my ISP provider of hosting in order to begin the service again. The tell me it is a problem of access with asp.net. ¿How can i solution it? I detail below the connection line of the web.config, maybe I am doing wrong. Thank you very much. <add key="Connection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bd\bd1.mdb;Persist Security Info=True" /> Tag: concurrency violation where it makes no sense to have one Tag: 113020
  - 4
    - debug suggestion for connection pool problem with Oracle using daa Hi We have a asp.net web application with oracle 9.1. Data access layer we use is DAAB 2.0. We use connection pool and set max pool size = 150. But we always get the following error almost every month ( we have to restart web server to make it work): Timeout expired, The timeout period elapsed prior to obtaining a connection from the pool. This may have occured becasue all pooled connections where in use and max pool size was reached. As many perople said, after I went though whole implementation, I did not find any connections we did not close. Anyone have good advice for how to debug such issue? or recommend some tool? I have seen lots of similar questions and topics, and found many answers are extremely confused. Can anyone make clear for my some questions? 1. We use USING to dispose connection and OracleDataReader in most cases, but also there are some exceptions, we use close() to close connection in Catch block of try-catch. here is example: ============================================== OracleConnection cn = new OracleConnection(connectionString); cn.Open(); try { return ExecuteReader(cn, null, commandType, commandText, commandParameters, OracleConnectionOwnership.Internal); } catch { cn.Close(); throw; } ========================================== Is anything wrong for these pieces of code? 2. In many cases, we opened connection in one function, and call another to process the real operation of DB., example: =================================================== using (OracleConnection cn = new OracleConnection(connectionString)) { cn.Open(); return ExecuteNonQuery(cn, commandType, commandText, commandParameters); } =================================================== if ExecuteNonQuery() got exception, the USING still can dispose connection? 3. =================================================== using(OracleDataReader r = OracleHelper.ExecuteReader(ConnectionManager.GetConnStr(), CommandType.Text, sql.SQLString, pa)) { ArrayList al = QueryResultsParser.Parse(r, request); r.Close(); //Force the OracleDataReader to be closed return al; } ==================================================== (we have add For these pieces of code, we use datareader to get data, I wonder: 1. is it necessary we explicitely close the datareader? 2. if answer yes for 1., and if OracleHelper.ExecuteReader() falied, does it mean we cannot close connection? 4. for some objects, do we need to displose them as soon as it is not used? example: ================================================= OracleCommand cmd = new OracleCommand(); PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters); //create the DataAdapter & DataSet OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); //fill the DataSet using default values for DataTable names, etc. da.Fill(ds); cmd.Dispose(); da.Dispose(); ======================================= Tag: concurrency violation where it makes no sense to have one Tag: 113017
  - 5
    - datagrid webcontrol in C# Hi, I just have a simple question regarding dataGrid in ADO.NET. I developed the web application by ASP.net and C#. I want to implment a dataGrid for the product list. The product list display the product name, size, type, price .... But for the specfic product category, its size column may not has any data. So i want to write the code in back-end by C# to determin whether every item in the size column in dataGrid has data. How I can write it in C# ? is there methods I can use to determin every item in size column contains data ? Thank you, H. Tag: concurrency violation where it makes no sense to have one Tag: 113016
  - 6
    - Add Record to MS Access Database Is there anyone that knows how to add a record to a MS Access database with VB.NET. I have search for 3 days for some code that works. I have gathered bits and pieces of code and put it together, but I have not found a solution that works. If anyone has some code that works please reply. Thanks Thomas The following gives an Invalid SQL Statement at: oAdapter.Update(ds, "LCMR") Dim oAdapter As OleDb.OleDbDataAdapter Dim cb As OleDb.OleDbCommandBuilder Dim dr As DataRow Dim ds As DataSet Dim strSQL As String = "Select * from LCMR" Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strAppPath & "TAM.mdb;Persist Security Info=False" ds = New DataSet() oAdapter = New OleDb.OleDbDataAdapter(strSQL, strConn) oAdapter.Fill(ds, "LCMR") Try dr = ds.Tables("LCMR").NewRow() dr.BeginEdit() dr("ID") = 1000 dr("ADate") = "6-JUN-5" dr("ATime") = "01:00" dr("POO") = strPOO dr("POO_Alt") = 22 dr("POI") = strPOI dr("POI_Alt") = 22 dr("Distance") = 1000 dr("Direction") = 100 dr("Target_NO") = "KT1001" dr("Weapon Type") = "sasdf" dr("Confirmed") = 1 dr.EndEdit() ds.Tables("LCMR").Rows.Add(dr) cb = New OleDb.OleDbCommandBuilder(oAdapter) oAdapter.InsertCommand = cb.GetInsertCommand oAdapter.Update(ds, "LCMR") ds.AcceptChanges() Catch oException As Exception MessageBox.Show(oException.Message) End Try -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: concurrency violation where it makes no sense to have one Tag: 113008
  - 7
    - Oracle transaction rollback problem I have problem with transaction. When I try to rollback transaction commit happend and record is updated. Can anybody tell me, where I made a mistake. Thanx, S. Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types private sub mWriteOnOra() Dim inFile As System.IO.FileStream Dim binaryData() As Byte inFile = New System.IO.FileStream(p_datoteka, _ System.IO.FileMode.Open, _ System.IO.FileAccess.Read) ReDim binaryData(inFile.Length) Dim bytesRead As Long = inFile.Read(binaryData, _ 0, _ inFile.Length) inFile.Close() Dim cnStr As String = "Data Source=Oracle8i;User ID=" & gsUser & ";Password=" & gsPwd & ";Data Source=" & gsDs & ";" Dim sErr As String Dim cn As OracleConnection Dim myTrans As OracleTransaction Dim cmd As New OracleCommand("SP_LOAD", cn) cmd.CommandType = CommandType.StoredProcedure With cmd.Parameters .Add("BLOB_LOAD", OracleDbType.Blob, binaryData.Length, ParameterDirection.Input).Value = binaryData End With Try cmd.ExecuteNonQuery() myTrans.Rollback() ' file shouldn't be in the table, but it is there ' myTrans.Commit() Catch ex As Exception myTrans.Rollback() DoLog(1, ex.Message) Finally If cn.State <> ConnectionState.Closed Then cn.Close() End Try end sub Tag: concurrency violation where it makes no sense to have one Tag: 113005
  - 8
    - Query Result Paging with different Ordering Hi, I have posted to multiple groups - I hope this is ok. For the past week or so I have been trying to find out how to perform a search against SQL Server, and have the results sorted on a choice made by the UI (ASP.NET), and supports paging. I have trawled the net a number of times, and have spent hours looking through peoples examples which just dont seem to cut it, due to all their caveats. Can someone offer good, useful links on how I can do this type of functionality? Vry much appreciated, after so much reading and playing I am still little further forward. I am not a DB person, which is causing part of the problem. Thanks j.r Tag: concurrency violation where it makes no sense to have one Tag: 113003
  - 9
    - problem in uploading and downloading files from DB in ASP.Net hi, Can anybody tell me that thru asp.net using c#, how can we upload and download physical files in any table of SQL Server Database. the uploading part is running successfully but the problem arises in the retriving part of the code. i am not getting that how will i able to download the file which is there in the SQL Server database in the field type "image". here is the code by which i am uploading any file to the my SQL Server database private void btnUpload_Click(object sender, System.EventArgs e) { HttpPostedFile filPosted = filUpload.PostedFile; int intFileLength = System.Convert.ToInt32(filPosted.ContentLength); byte[] byteData = new byte[intFileLength]; filPosted.InputStream.Read(byteData, 0, intFileLength); Conn.OpenConnection(); string sql="Insert into HRRecruitmentMaster(CandidateName,HighestQualificationID,JobFieldID,TotalExperienceInYears,CandidatePresentLocation,FileName,CandidateResume,type,length) Values (@CandidateName," + cmbHighestQuali.SelectedValue + "," + cmbJobField.SelectedValue + "," + txtTotalExp.Text + ",'" + txtPresentLoc.Text + "',@FileName,@CandidateResume,@Type," + intFileLength + ")"; SqlCommand Cmd = new SqlCommand(); Cmd.CommandText=sql; Cmd.Connection =Conn.Cn; Cmd.Parameters.Add("@CandidateName",txtCandidateName.Text) Cmd.Parameters.Add("@FileName",System.IO.Path.GetFileName(filPosted.FileName)) Cmd.Parameters.Add("@CandidateResume",System.Data.SqlDbType.Image,intFileLength); Cmd.Parameters["@CandidateResume"].Value=byteData; Cmd.Parameters.Add("@Type",filPosted.ContentType); Cmd.ExecuteNonQuery(); Conn.CloseConnection(); } so pls. help me out in this matter i'll be very much grateful to u Regards Himanshu Saxena Sahara India India Tag: concurrency violation where it makes no sense to have one Tag: 113001
  - 10
    - Using UPDATE I con't write the dataset back to datasource It works fine with the datagrid but with the sqlAdapter. Here is the code I was using. if State is always undefined. so it skips the logic, but the Textboxes hold the changed information. I am learning, please advise. Thanks Tag: concurrency violation where it makes no sense to have one Tag: 112995
  - 11
    - ODBC Data Sources Hi All, Is there a method that I can call to return a list of available database drivers? If so, is there then a way to get the list of fields that are required for those the database drivers? L. Tag: concurrency violation where it makes no sense to have one Tag: 112989
  - 12
    - TNSPING Doesn't Do Much I have TNSPING on my Windows laptop, ver 8.1.7.3.0. It was showing good when the database was down for maintenance. Looking at the output, it doesn't appear to be sending a SID as the later versions do. Is this so? If so, then its just checking for a port? Won't it miss a large class of outages? Thanks. Tag: concurrency violation where it makes no sense to have one Tag: 112985
  - 13
    - Connection Won't Die Application - give Oracle DB connection status on an ongoing basis Technique--thread is fired off by a timer every minute. It attempts to open a connection. It catches an open error as a failure, and otherwise indicates success. It then disposes the connection and ends. The status indicated seems to be good the first time. However, subsequently, it seems to get stuck in the old status, and doesn't always see the connection as transitioning to good from bad or vice-versa. Here's a snippet --- private void testDev(Object state) { try { oracleConnection1.Open(); oracleConnection1.Dispose(); devStatus.ForeColor = Color.Green; devStatus.Text = "DEV UP"; devErrorTxt.Text = ""; } catch (Exception e) { errorMsg = e.Message.ToString(); try { oracleConnection1.Dispose(); } catch (Exception e2) { errorMsg += (" Dispose: " + e2.Message.ToString()); } devErrorTxt.Text = errorMsg; failureMode = true; devStatus.ForeColor = Color.Red; devStatus.Text = "DEV DOWN"; } TimerCallback timerDelegate = new TimerCallback(testDev); t = new System.Threading.Timer(timerDelegate,null,60000,-1); } Suggestions?? Tag: concurrency violation where it makes no sense to have one Tag: 112982
  - 14
    - Convert _Recordset to DataSet/DataTable I have a Visual C++ .NET function that is calling an unmanaged function that returns an ADO _Recordset* object. I want to be able to convert that into an ADO.NET DataSet (or DataTable). I tried to use the OleDbDataAdapter.Fill method, but I could only get that to work if I gave it an ADODB::RecordsetClass object. I couldn't figure out how to get an ADO _Recordset into an ADODB::RecordsetClass. Any ideas? I don't want to have to rewrite all of our existing unmanaged code. - Brad Tag: concurrency violation where it makes no sense to have one Tag: 112981
  - 15
    - There is a way to set "Jet OLEDB:Transaction Commit Mode"? Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: concurrency violation where it makes no sense to have one Tag: 112977
  - 16
    - Could not find installable ISAM Using William Ryan's articles as a guide (excellent help, is William) I am trying to connect to my Excel data source. However, I am running into a "Could not find installable ISAM." error message trying to connect to the datasource. Does anyone have any tips as to how this is overcome? Thanks! Tag: concurrency violation where it makes no sense to have one Tag: 112975
  - 17
    - How DataRelation object is updated After the VS 2003 creates a strongly typed DataSet object that contains a couple of tables and serveral many-to-may data relations among all the tables, and the data got populated, I am wonder how the DataRelation object of the DataSet object is updated when some new rows are added to some of the tables. Do I have to update the relation of the added rows or in somewhere the relations are added automatically? Can someone explain this for me or point me to some resources? Thanks a lots. Tag: concurrency violation where it makes no sense to have one Tag: 112967
  - 18
    - ADO or String.Format bug ? ...... Hi It seems that String.Format method, when use a ***ZERO VALUE*** object coming from a SqlDataAdapter Fill method works fine, while if the same query is runned using an SqlDataReader ExecuteReader method, the formatted result is wrong .... For my tests i've used the Sql Server 2000 Northwind database and i've updated the Orders.Freight Column to zero (UPDATE Orders SET Freight=0). My general objective is to format all significative decimal values (value > 0)using a mask: #####0.00 and format all zero values using another mask: #####.##. This is obtained with: String.Format("{0:#####0.00;-#####0.00;######.##}", VALUE-TO-FORMAT) The VALUE-TO-FORMAT is obtained either using a server-side cursor (DataReader) and a client-side cursor (DataTable). In the first case it display ",00" (!!! ???) .... ... while using a DataAdapter it (correctly) display "" ..... The complete VB.net code is the following: ============================================================================= Dim Cn As New SqlClient.SqlConnection("uid=sa; pwd=; database=northwind; server=xdev99") Dim Cmd As New SqlClient.SqlCommand("SELECT Freight FROM orders", Cn) Cn.Open() Dim Dr As SqlClient.SqlDataReader = Cmd.ExecuteReader If Dr.Read Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dr.Item("Freight"))) End If Dr.Close() Dim Dt As New DataTable Dim Da As New SqlClient.SqlDataAdapter("SELECT 0 FROM orders", Cn) Da.Fill(Dt) If Dt.Rows.Count > 0 Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dt.Rows(0).Item("Freight"))) End If Cn.Close() ============================================================================== What's your idea ? Thanks. Nicola. Tag: concurrency violation where it makes no sense to have one Tag: 112963
  - 19
    - "Object is no longer valid" exceptions Hi, we have a .NET application that uses ADOMD to query a MS analysis OLAP cube. In a typical query, we get data for about 3 dimensions (800 x 15 x 2 entities) and then iterate over the resulting cell set to extract information. Occasionally, we see "Object is no longer valid" exceptions being thrown. The object (whose access usually throws this error) is of the type "ADOMD.Position". Sometimes the error appears while executing Cell.Get_Item(). We have a mechanism to retry the query if these exceptions are thrown in a (vain) hope that on the retry the whole thing will go off successfully. This works sometimes, but not always, so this isn't satisfactory. Does anyone have any idea why this would be happening? Is this something to do with garbage collection? Are there any workarounds/fixes? I would be grateful to know. Thanks, Ramanand [P.S. Apologies if this is the wrong newsgroup for purely ADOMD queries] Tag: concurrency violation where it makes no sense to have one Tag: 112957
  - 20
    - connection question I'm getting an error while running an aspx page on a production server. The error is that either the server can not be found or the access is denied. The following code fails at line 36. Line 34: str = "Driver={SQL Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra" Line 35: C.ConnectionString = str Line 36: C.Open() Line 37: Dim R As New ADODB.Recordset Other aspx pages that don't talk to the data server run correctly. The same page run on the development PC (WinXp Pro) connects and dispays the data correctly. (SQL server is on another box) If I alter the code to run in an Access 2000 database on the same production server, it runs correctly. Thus I'm not sure how to go about getting this up and running. Any thoughts would be appreciated. Cheers Mike Tag: concurrency violation where it makes no sense to have one Tag: 112936
  - 21
    - MSDE, ASP.NET, Visual Studio .NET, and connectionstrings I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should look like? I am using the version of IIS that comes with XP Pro. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: concurrency violation where it makes no sense to have one Tag: 112929
  - 22
    - ODP.NET Publisher Policy? We recently started running into a problem. We had a .NET winform application built with ODP.NET 9.2.0.4. We rolled out a new OS image that had only the 10.1.200 Oracle client and ODP.NET. The existing application stopped working, as it wanted a 9.2.0.4 client. After doing some further research, I've discovered that publisher policies are my answer. All our machines are currently running 10.1.0.200 of ODP.NET, however, and that build did not seem to install or include publisher policies. 10.1.0.400 both includes, and installs by default these policies into the GAC. I'm hoping there's some way I can get or build publisher policies for 10.1.0.200. That way, I could get a script run that simply installs these policies into the GAC of all machines on site. Otherwise, it seems my other option is to uninstall all the 10.1.0.200, and reinstall 10.1.0.400. >From what I've managed to learn about publisher policies, they're done by the publisher of the component. I think I need access to the .key file in order to generate my own, which of course, I do not have for the Oracle.DataAccess assemblies. Anyone know if these publisher policies are available for 10.1.0.200 somewhere? Tag: concurrency violation where it makes no sense to have one Tag: 112923
  - 23
    - datatable.select("Distinct") or such to string? I am hitting a bit of a wall - I am building a table - public DataTable theTownships = new DataTable("AdjacentTownships"); public DataTable buildTownshipTable() { DataColumn tscolumn; //Townships-Range Field tscolumn = new DataColumn(); tscolumn.DataType = System.Type.GetType("System.String"); tscolumn.ColumnName = "TSR"; tscolumn.ReadOnly = false; tscolumn.Unique = false; theTownships.Columns.Add(tscolumn); return theTownships; } This table is built from another query where each coloumn in that row is turned into a row here. So I can have between 1 and 0 rows, some can be duplicates. What I need to do is then select the distinct rows from this table and pass them to a for loop that I can then parse/process each of the distinct rows. Any and all suggestions would be greatly appreciated!! -- D @ premierdata Tag: concurrency violation where it makes no sense to have one Tag: 112922
  - 24
    - Using System.GUID in a RowFilter I have a table in SQL server that has a column of type UniqueIdentifier. I use a DataAdapter to fill a typed DataSet with rows from the table. (Interestingly, when I look at the typed dataset, the datatype of this column has magically changed to STRING). Anyway, I need to use this column value in a DataView.RowFilter. However, when I try to create the RowFilter="ColumnName='" & value & "'" I get a runtime error that says I there's no operator that will contatenate (&) a STRING and a SYSYEM.GUID. Apparently, when I fill the typed dataset, the datatype changes to SYSTEM.GUID (I assume the same as UniqueIdentifier), even though the datatype in the typed dataset says STRING. So, how do I use a SYSTEM.GUID in a RowFilter when there doesn't seem to be a way to convert it into a string? -- Michael Hockstein Tag: concurrency violation where it makes no sense to have one Tag: 112921
  - 25
    - Dataset Relationship I have a grid that is bound to a typed dataset. Three fields make up the key in the parent table and those same three fields are also in the child tables with a 1 to many relationship. When I bind this dataset to a grid it displays it hierchalily (which is what I want) when I drill to the child rows however it has the child row data plus the same data that is on the parent row. I only want to see the child information in the child row. I have looked in the Dataset and found no extra fields in the two sub tables so it is my assumption that it's doing this at runtime. Any ideas how I can get this to stop? Thanks, Justin Tag: concurrency violation where it makes no sense to have one Tag: 112920
- Next
  - 1
    - Using Rollup operator in Sql Server 2000 Guys, I need some advice on displaying Rollup results this is the query (SP). select Org_lvl_2,level_one,doe,sum(RegHours),sum(OtHours) from ZT where Ppe= @PERIOD GROUP BY level_one,org_lvl_2,doe WITH ROLLUP HAVING sum(RegHours) >0 or sum(OtHours) >0 ORDER BY level_one,Org_lvl_2,Doe the Results: NULL NULL 53.0 0.0 NULL CANM 53.0 0.0 HQJ CANM 53.0 0.0 HQJ CANM 32.0 0.0 HQJ CANM 13.0 0.0 HQJ CANM 8.0 0.0 what i'd like to display in a datagrid is:(with the Grand Total @ the bottom & leaving out the Nulls) HQJ CANM 32.0 0.0 HQJ CANM 13.0 0.0 HQJ CANM 8.0 0.0 HQJ CANM 53.0 0.0 i've been able to gain a little control putting the returned dataset into a dataRow and using IsDBNull(myRow.Item(0)) -[like that] - to weed out those null values. but,i've only had success if i then use a Listbox.item.add(myRow.Item(0) & myRow.Item(1)) - like that and i do have control, except for the Grand Total appears at the top of the list, not the bottom. i'm a little lost how to do this same thing in a datagrid, but a repeater or datalist control would be fine too if that's possible. i've worked the sql to death trying to get subTotals & then Grand Total, so if anyone knows another way in sql, i'd appreciate some help on that. other wise any advice on a good asp.net Control to use and maybe the method to display this would be very helpful. i've tried using templates in the datagrid but it doesnt seem to recognize the aggregate columns. thanks again rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: concurrency violation where it makes no sense to have one Tag: 112918
  - 2
    - SQL queries and datasets etc As only an occasional ado.net user I'm realising that there's something important and basic that I don't understand: I can obviously perform SQL queries on a database, but sometimes the data I need to access is in a bare datatable. So the question is whether there is a mechanism for performing a query directly on a bare datatable or, failing that, if add the table to a temporary dataset will that do? Or do I need to go the whole hog and integrate it into a full database? (In VB.Net if it makes any difference) Thanks JGD Tag: concurrency violation where it makes no sense to have one Tag: 112913
  - 3
    - Error saving data from dataset with expression column Hi, I have a dataset created by dragging table from database explorer. Then I have added a column in dataset with expression cant * price in order to get calculation from two columns. This work fine. But when I try to save data into database using datadapter.update method i get the error: Cannot change ReadOnly Property for expression column. Anyone can help me? Thanks. Tag: concurrency violation where it makes no sense to have one Tag: 112902
  - 4
    - Loss of datetime precision when attaching parameters to an ADO.NET command Hi, I am encountering some strange losses of datetime precision when calling a stored procedure through ADO.NET. I'm using ExecuteNonQuery in the Microsoft Data Access Application Block for .NET, which simply creates an ADO.NET command, and attaches each of the parameters, before calling cmd.ExecuteNonQuery(). I have a stored procedure that does nothing but take a whole load of input parameters and insert them into a table. Calling the SP directly from Query Analyser works fine. However, calling the SP from code as follows: ... parameters[5] = new SqlParameter("@Time", SqlDbType.DateTime); parameters[5].Value = time; ... SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, "MyStoredProc", parameters); ...results in the time entry made into the database always having a zero value for the seconds. Similarly, if I execute: SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.Text, "EXEC MyStoredProc ..., @Time, ...", parameters); ...the same thing happens. However, if I dump the INSERT statement that's in the stored procedure into a string called sql in the code, and then execute: SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.Text, sql, parameters); ...then everything works just fine and I don't get the rounding error. Does anyone have any ideas as to why this may be? Many thanks in advance for your help, Chris. Tag: concurrency violation where it makes no sense to have one Tag: 112900
  - 5
    - Dataset ambiguous error I am getting an error from defining my Dataset. The error is: BC30561: 'DataSet' is ambiguous, imported from the namespaces or types 'System.Data, DreamweaverCtrls'. I am using Dreamweaver, but am doing all the database functions by hand. My function is: Sub CheckStoredLetters() Dim myDbObject as new DbObject() Dim parameters As SqlParameter () = { _ New SqlParameter("@Email",SqlDbType.VarChar,45) } parameters(0).value = session("Email") Dim dbDataSet as DataSet = myDbObject.RunProcedure("GetCoverLetters", parameters,"CoverLetters") DataList1.DataSource=dbDataSet DataList1.Member="Letters" DataList1.databind() End Sub The error is on this line: Dim dbDataSet as DataSet = myDbObject.RunProcedure("GetCoverLetters", parameters,"CoverLetters") I also got the error if I tried: Dim dbDataSet as DataSet What would cause this error? Thanks, Tom Tag: concurrency violation where it makes no sense to have one Tag: 112888
  - 6
    - DataReader error I have a dataReader that I am trying to use with datalist that works fine with my dropdown but gives me an error when binding with the datalist. The error is: Invalid attempt to FieldCount when reader is closed The code is: ********************************************************** Dim myDbObject as new DbObject() Dim DBReader As SqlDataReader Dim parameters As SqlParameter () = { _ New SqlParameter("@Email",SqlDbType.VarChar,45) } parameters(0).value = session("Email") dbReader = myDbObject.RunProcedure("GetLetters", parameters) DataList1.DataSource=dbReader DataList1.databind() ************************************************************* The myDbObject.RunProcedure is my object that fills a datareader from the Stored Procedure "GetLetters". The dropdown list worked fine when I had: StoredLetters.DataSource=dbReader StoredLetters.DataValueField="LetterID" StoredLetters.DataTextField= "LetterTitle" StoredLetters.databind() I just changed the datasource area and assumed this would work, but it doesn't. The datalist is: <asp:DataList ID="DataList1" RepeatColumns="4" RepeatDirection="Horizontal" runat="server" > <ItemTemplate><%# Container.DataItem("LetterTitle") %> </ItemTemplate> </asp:DataList> Very simple - I would have thought. What would cause that problem? It is virtually identical code, except for the dropdownlist vs the Datalist. Thanks, Tom Tag: concurrency violation where it makes no sense to have one Tag: 112886
  - 7
    - DA Update Error I realize this is a broad ADO .Net question but i thought I'd give it a shot because i can't solve it When my DG opens and I select a row for deletion everything works fine. If I add a row through a separate Add Form class that returns a merged DS and try to delete the row I just added from the DG the DA.update(DS) gives an exception ("deletecommand affected 0 records"). The Row State of the row is "Delete" and the DS haschanges(). i think the total row counts of the DS and DG are correct Any Ideas? I'm possessed by it. Steve Tag: concurrency violation where it makes no sense to have one Tag: 112883
  - 8
    - REQ: Practice code/files for Microsoft ADO.Net Step By Step - Please Hi all, Can someone please email me the code for this book .. Microsoft ADO.Net Step By Step 2002 rob012669@inbox.com Thanks in advanced Tag: concurrency violation where it makes no sense to have one Tag: 112882
  - 9
    - FYI - Alternative DB engine for .net I found a alternative DB engine for .net suited stand alone apps that may not wish to use Jet or MSDE. I have not used it so can not comments on stability. Comes with source code and a license to allow use in commercial products. http://www.gotdotnet.com/workspaces/workspace.aspx?id=ea06f702-480a-4b60-8402-70b27c6472dd Tag: concurrency violation where it makes no sense to have one Tag: 112872
  - 10
    - Help - MSDE or Jet for Stand-alone App, I am converting a older VB app to .net. The app currently strores info. Into a JET database. As this is an end user app, I can not convert to SQL server, etc. so I need to use either the older Jet engine or using MSDE. Questions: Issues with loading MSDE on a neophyte user's machine. Will it require user tweaking and will it effect their system performance? Also, will they need to install as ADMIN? Also, if multiple people need access to the same database, will MSDE need to be installed on all of the machines and can it access the same database file on a network drive? Or will one machine need to be designated as the DB server? Eg. Time for SQL server? If one is running SQL server 2000, can the databases be used by MSDE? If not, where can find info on what changes need to be done? What is the current stability state of the Jet engine. I know that the pre-4 versions had data corruption issues. Did version 4.x fix most of these issues? Thanks P.S. Any recommendations for a good tutorial on installing MSDE on the target machine and replicating the database files would be helpful. Tag: concurrency violation where it makes no sense to have one Tag: 112865
  - 11
    - SQL Server SPIDs Hello, I don't know much about SQL Server processes/SPIDs but everytime our web app creates a ADO.NET connection and closes it, the SPID is still hanging around in "sleeping status" well after it's closed in the ADO.NET code. Is this normal or I am making database calls inefficiently? I also thought mutiple connection w/ the exact same connection string becomes pooled. If pooled, will that not affect the number of SQL SPIDs created. Should I be concerned about the number of SPIDs the app is producing or is this normal? Thanks in advance, Jim Tag: concurrency violation where it makes no sense to have one Tag: 112854
  - 12
    - Database query performance I have a database table. The table has number of fields. Out of those fields one is Company and another is DateTime. The table has thousands of records. I want to get the most recent record for each company. In order to do that I am using the following query SELECT * from CompanyDetail AS X WHERE [DateTime]=(SELECT max([DateTime]) FROM CompanyDetail WHERE Company=X.Company) ORDER BY Company Note: There is only one record exists for the given company on a given date The problem is that this query is very slow. Am I doing something wrong or there could be another alternative way to improve it ? Thanks in advance KDV Tag: concurrency violation where it makes no sense to have one Tag: 112850
  - 13
    - ERROR [42724] - .NET to DB2 via Managed Provider The complete error is at the end of this cry for help. I've been tasked with hooking an interface in ASP.NET and a handheld (via web services) to an existing DB2 data store. The requirement for real-time data submission is driving the development, and all is going well, In fact, the managed provider is working perfectly to execute stored procedures to read from the data store, both ones that have no parameters (simple lookup lists), lookup lists that are pre-filtered with parameters, and ones that use identity columns to pull editable records. Performance is fine, and everything on the interface side is great. BUT (always is one), I get the same basic error (see below) every time I execute a stored procedure that inserts or updates a record. These same procedures all work perfectly from inside the command editor, and the logon to the data store there is the same as the one in the .NET development environment (to eliminate permissions issues). Yet, the error is pulled every time, and being somewhat of a newcomer to the DB2 world, I expect it is probably looking me right in the face. The code accessing the stored procedure is almost identical to the read code, rendered in VB.NET, and patterned after examples on the IBM sample set. Absolutely any insight, even where to look to resolve this, would be highly appreciated. Thanks. Frank Buchan ***ERROR DETAILS BELOW*** ERROR [42724] [IBM][DB2/NT] SQL0444N Routine "*ERT_DEST" (specific name "SQL050622125403880") is implemented with code in library or path "...2.V1_INSERT_DEST", function "MDM2.V1_INSERT_DEST" which cannot be accessed. Reason code: "4". SQLSTATE=42724 Tag: concurrency violation where it makes no sense to have one Tag: 112849
  - 14
    - Huge data needs to be transfer from Fixed width Text File to SQL S Hi Experts, I have huge fixed width text files around 9GB or 60 TO 75 millions records. I need to transfer 300GB data from these Text files to SQL Server 2000 monthly bases. I am trying to develop VB.NET application. One problem is I need to transform this data, like date is 6 char (mmddyy) which needs to be convert into real Date (mm/dd/ccyy) during the import. I tried to use datareader to bring data into DataTable and then append data into SQL Server using SQLBulkInsert but its taking long time and start failing after 10-16 millions records appended into SQL Server 2000 table. I have following questions:- 1- Which class-method should I use to read the data from text file? 2- How to perform Transformation data ( like converting 6 char date fields into DATE and other validations)? 3- Which Class-method should I use to append data into SQL Server 2000 to get the best performance? 4- Is there any better way to done the same job? I am using VB.NET 2005 Beta. Thank you so much for your time and help. Some code what I am using right now to do so Using rdrDataFile As New TextFieldParser(mstrDataFilePath) rdrDataFile.TextFieldType = FileIO.FieldType.FixedWidth rdrDataFile.SetFieldWidths(objDataFile.SplitPositions) arrNumToExclude.AddRange(objDataFile.ColumnIndicesToExclude) tblDataFile = objDataFile.StagingTable Dim currentRow As String() Dim rowIndex As Integer = 0 destConn = New SqlConnection(strConnectionString) 'Creates Connection destConn.Open() 'Opens Connection ' intTotalRowCount = 1 While Not rdrDataFile.EndOfData Try Dim myRow As DataRow = tblDataFile.NewRow currentRow = rdrDataFile.ReadFields() Dim currentField As String Dim columnIndex As Integer = 0 Dim intCounter As Integer = 0 For Each currentField In currentRow If Not arrNumToExclude.Contains(intCounter) Then myRow(columnIndex) = objDataFile.FormatData(columnIndex, currentField) columnIndex += 1 End If intCounter += 1 Next tblDataFile.Rows.Add(myRow) Catch ex As Exception End Try rowIndex += 1 If rowIndex = 100000 Or rdrDataFile.EndOfData Then 'Upload data To Database in Batches BulkCopyToDB(tblDataFile, objDataFile.DestinationTable) 'Copy Data into DB tblDataFile.Clear() rowIndex = 0 End If 'vpbDataFile.Value = IIf(intTotalRowCount < vpbDataFile.Maximum, intTotalRowCount, vpbDataFile.Value) 'intTotalRowCount += 1 End While End Using Public Sub BulkCopyToDB(ByVal vtblDataFile As DataTable, ByVal vstrDestTable As String) Dim bcp As SqlBulkCopy = Nothing Dim strConnectionString As String = "" Try bcp = New SqlBulkCopy(destConn) bcp.DestinationTableName = vstrDestTable bcp.WriteToServer(vtblDataFile) Catch ex As Exception Finally If Not bcp Is Nothing Then bcp.Close() End If End Try End Sub Regards, -Permood Tag: concurrency violation where it makes no sense to have one Tag: 112847
  - 15
    - retrieve id when adding a new record in SQL Hello, Iâ??m adding a record to a SQL database. One of the columns in the database generates a uniquely identifying integer when a record is added. I would like to retrieve this number when I add a new record to the table. By the way I do not want to use stored procedures. Iâ??m using the following VB.NET code to add a record to a database how would I change this so that at the same time I can retrieve the unique record id generated by the database in the table? Imports System.Data.SqlClient Dim conDB As SqlConnection Dim strInsert As String Dim cmdInsert As SqlCommand conDB = New SqlConnection("connection string") strInsert="Insert Products (ProdName,ProdCat) Values ('Flat Chair',â??Chairâ??)" cmdInsert = New SqlCommand(strInsert, conDB) conDB.Open() cmdInsert.ExecuteNonQuery() conDB.Close() Thank you. Tag: concurrency violation where it makes no sense to have one Tag: 112845
  - 16
    - Pivoting DataSet I currently have from SQL a stored procedure that is vaguely doing something like: SELECT FormName, frmDueDate, DepartmentName, Country frmStatus FROM wholeBunchOfTables So data will be returned like: Form1 ITDept USA Incomplete Form2 ITDept UK Completed Form1 HRDept FR Completed Form2 HRDept FR Missing The DataSet resultant from the Stored procedure execution is binded to a sortable DataGrid. However, I would like the data "pivoted": i.e. Form1 Form2 ITDept USA Incomplete Completed HRDept FR Completed Missing Is this at all possible (natively)?? - Can't think of any pivoting SQL operators?? - Can't pivot on ASP.NET/ADO.NET?? Would I have to resort to --- creating another DataSet with columns pivoted?? or --- render my own table, etc. and handle by own sorting? Tag: concurrency violation where it makes no sense to have one Tag: 112844
  - 17
    - Bug in framework? I'm having a very funny behaviour in my application. My windows App running on XP sp2, has data from various table. If I make changes to only 1 table on the form and click save, it gives an error: "Object reference not set to an instance of an object." If I debug the code, it crashes on the line with "*" (I'm showing the code above, so that it would give a better idea) public void UpdateDataSet() { // Create a new dataset to hold the changes that have been made to the main dataset. ClientManagementPro.dsClientT objDataSetChanges = new ClientManagementPro.dsClientT(); // Stop any current edits. this.BindingContext[dvClient,"relClient-ClientAddress"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-ClientNote"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-Action"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-Child"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-Job"].EndCurrentEdit(); this.BindingContext[dvClient].EndCurrentEdit(); * <------------------- It crashes here (mind u dvClient is the only thing that is modified). Now, after it gives that error, if I click save, it goes through just fine! Again this only happens sometimes, if I edit the same fields on the same tab, it works just fine. I'm completely lost here and have no clue how to troubleshoot this, any insights would be highly appreciated. Thanks HS Tag: concurrency violation where it makes no sense to have one Tag: 112840
  - 18
    - Write a XML file without accents Hello, I have a problem and I think that someone can help me. I am writing a XML file using data from a Oracle data base. I am from Brazil, and here we have accents on the words, like "acentuaÃ§Ã£o".I need write my XML file without the accents. Today I am using one DataSet to write my XML, specifically the method WriteXml. How can I resolve my problem, using a feature from the .NET Framework? Thank's -- Tiago Machado Microsoft Certified Professional C# .NET Tag: concurrency violation where it makes no sense to have one Tag: 112839
  - 19
    - DataGrid control scrolling Can I programmatically control the scrolling of DataGrid control in Windows Forms. I have DataGrid control which shows hundred of rows. I want a way of scrolling the data grid to last row KDV Tag: concurrency violation where it makes no sense to have one Tag: 112837
  - 20
    - wizard-generated stored procedure for Null-Guid-Column Hi, - occurs with .Net 2.0 Beta 2 - I have a typed-DataSet and some DataAdapters to provide the tables for the DataSet. When I create the stored-procedures with the DataAdaper-Wizard for a table with a Guid column, which can be NULL, the Wizard generates a wrong Script. (only when "use optimistic concurrency" is true). If you look at the script, the following part of the where-clause is faulty ...((@IsNull_FieldName = 1 AND [FieldName] IS NULL) OR ([FieldName] = @Original_FieldName))... (FieldName is defined as uniqueidentity, allow NULL) obviously @IsNull_FieldName = 1 is wrong, because 1 is an Integer and not a uniqueidentity. But how to fix that? regards Gunnar Tag: concurrency violation where it makes no sense to have one Tag: 112834
  - 21
    - Poor DAB performance I recently came across the Microsoft Data Access Application Block so I decided to try it out in a Windows forms application. Without using the DAAB, the following code, which creates a data reader which is then used to populate a combo box, takes 3 seconds to run: SqlConnection cn = new SqlConnection("server=.......") commandString = "select ......" SqlCommand cmd = new SqlCommand(commandString, cn); SqlDataReader dr = cmd.ExecuteReader(); The command string is a simple select statement on one table which returns the primary key for about 10 records. After installing the DAAB I modified the code as follows: Database db = DatabaseFactory.CreateDatabase(); commandString = "select ......" DBCommandWrapper dbCommandWrapper(commandString); IDataReader DataReader = db.ExecuteReader(dbCommandWrapper); This code takes 6 seconds to run, twice as long. I can see the advantages of using the DAAB, but this performance overhead is too great. Is this to be expected when using the DAAB or am I missing something? Tag: concurrency violation where it makes no sense to have one Tag: 112827
  - 22
    - Exception on SqlTransaction.Rollback(), BUT it doesn't Hi, My program injects message at the same time as SQLServer is backing up (full). I write injecting module using Try...Catch block with SqlTransaction and using SP. Within Exception block I call Rollback() (it cautch timeout exception). I've found that it got exception on Rollback() command with InvalidOperationException (message="This SqlTransaction has completed; it is no longer usable."). In this situation, sometime the message is right (inject success), but sometime it doesn't. How can I resolve this problem? Thanks in advance, Thana N. Tag: concurrency violation where it makes no sense to have one Tag: 112819
  - 23
    - SQL CLR: which assembly to reference for microsoft.sqlserver.serv I am trying to use objects (such as sqlcontext) defined in the microsoft.sqlserver.server name space, but couldn't find the right assembly to reference. Does anyone know which assembly implements the classes defined in this name space? Tag: concurrency violation where it makes no sense to have one Tag: 112816
  - 24
    - Trying to find ClientID of web form - Solution Found After pouring over about a dozen sites that clearly dealt with ClientID all by itself, I came to the realization that about 2/3+ of them were doing it wrong. It is indeed impossible to grab the Client ID of a form field from within a DataGrid like this: <%= FormFieldID.ClientID %>. At least, not without extra work. How did I do this? I created a new DataGrid from scratch, with a form above it and a form inside of it. This was a page about 50 lines long - so, very short - with no user dependencies except for the initial loading of the DG with content from the DB. While I was able to get the ClientID of the form that was outside of the DG, I was unable to do so for any form fields inside of the DG using <%= FormFieldID.ClientID %>. Doing so threw the error. That got me to thinking. Which, after nearly two days of rest from the subject, was a wee bit clearer than before Sunday. I decided to call the form field directly. I first Dim'd a name as a textbox, and then I called the right textbox by catching it when the DG was being created. Since it was in the footer (the footer is an "add" row) simply calling like this: Dim add_Date as TextBox = e.Item.Cells(1).FindControl("add_Date") was a bit difficult. Which row would be referenced? How would the script know to look in the footer? Since the footer comes and goes (I don't need it during an edit), looking for it would have to be conditional. In order to catch the right row (the footer) while the DG is being built, I added a feature to the DataGrid itself (onItemDataBound = "dg_ItemDataBound") which calls the sub dg_ItemDataBound when the DataGrid is being built. From here, I created a Sub (Sub dg_itemDataBound()) in which I contained my attempt to find the ClientID of the form field within the footer: If e.Item.ItemType = ListItemType.Footer And dg.ShowFooter = True then Dim add_Date as TextBox = e.Item.Cells(1).FindControl("add_Date") End If From here it was pretty easy to set up a RegisterStartupScript (inside the IF) that made use of add_Date.ClientID. Since I had already defined add_Date as the form field called "add_Date" in the second cell of the footer row, the usage of add_Date.ClientID no longer threw an error. I also had to implement this within the dg_Edit() Sub, in a slightly different fashion, but that's because I allow rows to be edited. *** What is really strange is the sheer number of sites that claim that using <%= FormFieldID.ClientID %> will actually work inside of a DataGrid without further modification or code. It certainly didn't work for me. I would also like to apologize to the community at large for my hissy fit on the weekend. It had been a very long week, this was just one of many problems I was still trying to solve, and Juan's reply seemed to be mocking me for my lack of progress. Normally I'm much more mild mannered, but something in me must have snapped from all the stress. That should not have happened. Gomen dasai. TIA ...Geshel -- ********************************************************************** My reply-to is an automatically monitored spam honeypot. Do not use it unless you want to be blacklisted by SpamCop. Please reply to my first name at my last name dot org. ********************************************************************** Tag: concurrency violation where it makes no sense to have one Tag: 112801
  - 25
    - minumn and maximum what is the mininum and maximum value in SQL statement select * from table1 where field1 between "minumum" and "maximum" then it will show up all the value in table1 thank regards Tag: concurrency violation where it makes no sense to have one Tag: 112800

I recieved the following error pretty much randomly (haven't been able to
reproduce it or see what caused it in code at all)

Top

Re: concurrency violation where it makes no sense to have one by Brian

Brian
Mon Jun 27 09:12:39 CDT 2005

whooops somehow sent this twice and the first one cut off...

"Brian Henry" <nospam@nospam.com> wrote in message
news:%23hEIdMxeFHA.960@TK2MSFTNGP10.phx.gbl...
>I recieved the following error pretty much randomly (haven't been able to
>reproduce it or see what caused it in code at all)
>
>

Top