SqlDataAdapter.Update()

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
    - DataSet / DataTable / Row selection Hi, Does someone could tell me an easy way to select the last row added in a DataTable inside a DataSet ? Something like : DataSet.Table(myTable).SelectLastRowAdded () Thank you. Tag: SqlDataAdapter.Update() Tag: 79064
  - 2
    - UTF 8 Encoding in ADO.NET Hello we are into internationzation our App. we are facing one issue : right now, VB.NET is communicating to the ODBC driver (Teradata) in utf16 encoding. but the odbc driver can handle only utf-8 encdoing , not the utf-16. we tried to use th utf-8 encoding function to convert the utf8 to utf16 which is not useful in this case because it stores the data in byte array. Is there is any specificed functions through i can set the Globally the Odbbc communcation to UTF8? please let me if you anybody has faced this issue or anyworkaround thanks paul Tag: SqlDataAdapter.Update() Tag: 79063
  - 3
    - Identifying a newly created row ? Hi I have a DataGrid bound to a DataView, and when adding a new row to the view I want it to be the current/selected one I've tried the followerin DataRowView row = myView.AddRow() row["Date"] = DateTime.Today Tag: SqlDataAdapter.Update() Tag: 79061
  - 4
    - SQLConnection Object Please HELP??? I have declared a property as a SQLConnection Object. In this implementation this property is being used in a class which is derived from a Web Control Base Class. My Class once built exposes properies in the designer. It exposes the SQLConnection Property as well. The problem is that when I use the designer to build a connectionstring for the porperty it doesn't pass it thru to the control in run time the connectionstring property comes back null meaning not initialized. The property was implemented in the standard. Dim object as new Object Property as Object get return Object end get set Object = value end set etc... Any ideas on how to use this object as a property. The SQLConnection class cannot be inherited from so I am at a loss... Thanks in Advance! Chris... Tag: SqlDataAdapter.Update() Tag: 79058
  - 5
    - Optimising app Hi We have an access application running over a win2k network. I have now rewritten the ap in vb.net and the problem is that the vb.net app runs generally slower(!) then than the access app. I am using a typical dataset/dataadapter scenario and doing most of the things in code including the data access layer and individual field binding. I am reading one master record at a time so this should not be too slow(?). The detail records appear in grids but these are indexed retrieval. How can I optimise the application? What areas can I look into and what techniques can I use to pinpoint the bottlenecks? Thanks Regards Tag: SqlDataAdapter.Update() Tag: 79056
  - 6
    - Can someone educate me? I have been building a windows app with a sql query, but I was using a view and I learned that it is very difficult to use a view for updates. So I began investigating this and found some information regarding creating multiple sqldataadapters, one for each table, and then generating a dataset to include all of the tables (sqldataadapters). The information was found at: http://msdn.microsoft.com/library/default.asp?url=/library/en- us/vbcon/html/vbwlkwalkthroughcreatingmaster-detailwindowsform.asp I have then edited the resulting XSD document and added realtionships and keys, in an attempt to replicate the relationships that exist in my SQL view. So I have a few questions about how to proceed selecting and updating the data. Now that I have multiple dataadapters, and each one has it's own select/insert/update/delete commands, and I had previously selected from a view which contained all of the necessary columns, how do I select these multiple columns from multiple tables and maintain the relationships? Which DataAdapter do I use for the select? When I do the .fill, which dataadapter should I use? How do I get the selected columns to appear in my datagrid? Why does my datagrid have a plus sign in the row header and all of the key relationships as links? Is there any material that covers these questions? I have been unable to find many relavent articles. If there is a way of updating a view, please let me know how, I may be able to salvage the original application. Thanks for your time. Aaron Tag: SqlDataAdapter.Update() Tag: 79052
  - 7
    - DataAdapter.Update Problem hi all, I'm building a typed dataset from a sql table. Later programmatically inserting rows upon user data. When I execute DataAdapter.Update(ds). I get a constraint violation on one of the columns which is non-null column. Looking at the XML data in the dataset, I get an exception on a row that is not there in the table rather a row that should be next in the sequence. For example If I insert 3 rows in the table in the dataset. Then i get error xyz column does not allow NULL data, insert fails. Can anybody guide me thru this problem. Thanks in advance. -HKM Tag: SqlDataAdapter.Update() Tag: 79051
  - 8
    - DataGrid newbie question How to change columnheader's text in datagrid ? TIA Tag: SqlDataAdapter.Update() Tag: 79048
  - 9
    - Detect changes to record in SQL Server CE I'd like to find an easy way to find out if a record in SSCE was changed by the user in my VB .NET app. I'm thinking of filling a DataSet object with the original record, show the record to the user for editing, and then after the user is done, filling another DataSet object with the record from the DB and looping through the columns in the 2 DataSets to see if anything has changed. It would be cool if you could do a DataSet.CompareToDB to find out if the DataSet you have is still the same as in the underlying database. Does anyone know a better way to do this? Tag: SqlDataAdapter.Update() Tag: 79047
  - 10
    - Concurrency Problem Hello to all, I have a problem between 2 programs I have running. We have got an old databridge for our clients to upload data to our central database. This one is written in C++ (not by me). We now have a new Databridge developped, which is written in VB.NET. Functionally they are the same, but technically there are differences. I think we have got a concurrency problem, because when the new Databridge (VB.Net) is running (several instances), the old databridge will not run. The error given by the old databridge, is that it cannot connect to the database, while it can when NOT using the new databridge. Some technical details: Old Databridge: - C++; - using port 8041 (this one has a direct connection with the client); New Databridge: - VB.Net All is running on a Win2K SBS SP3 with SQL Server 2000. It is difficult for me to explain, so when more information is needed, please ask me!! Thanks to everyone in advance. Kind Regards, Marcel Groffen Tag: SqlDataAdapter.Update() Tag: 79040
  - 11
    - Moving Data Between 2 Databases (SQL) I have created a web form that enables a user to pass a large amount of data between 2 different SQL 2000 Databases. The current methodology is to extract the source data, store it in a .Net dataset and then using the CmdBuilder, pass each line of data out to the destination database. I'm having some issues with the size (1000s of lines) and time of the data transfer that invariably ends up with either a SQL timeout (I have set all Command.Timeouts=0) or the aspnet_wp.exe process cycles during inactivity. I have attempted to use SQLServer session state management, but am not very familiar with exactly how that works (authentication is also an issue here). My question is, can I use a different method of moving the data from the dataset to the database? I feel as though there must be a more efficienct, less time consuming way. Is it possible to move an entire dataset at once? Can SQL and .Net perform this? Thanks in advance for your help. Rob Tag: SqlDataAdapter.Update() Tag: 79035
  - 12
    - Fill question Does a Fill command make an automatic connection when initiated? When it is through does it automatically disconnect? I am just wondering if I need something like the following around a fill command? mySqlConnection = New SqlConnection(myConnectionString) DaContracts.Fill(DsMain1, "Contracts") mySqlConnection.Close() Tag: SqlDataAdapter.Update() Tag: 79034
  - 13
    - Cancel a delete operation Hi, I am trying to cancel the deletion of a datarow. When the user presses the Delete button, a messagebox displays asking the user if they really want to delete the current row. If "Yes", then the delete occurs; if "No", then the current row remains in the table and is not marked for deletion. My problem is that if the user presses the "No" button on the messagebox the row is still removed from the table (marked for deletion). How can I stop that from happening using the above code description? Here's my code: ****************************** With Me.BindingContext(dvCustomers) ' references a dataview object Select Case CType(sender, Button).Name 'other case statements are omitted here; they work fine Case "btnDelete" MsgBox("Are you sure you want to delete the current row?", & _ MsgBoxStyle.YesNo, "Delete Row") If MsgBoxResult.Yes Then .RemoveAt(.Position) UpdatePosition() 'utility method End If If MsgBoxResult.No Then .Position = .Position 'problem occurs here - need help End If End Select ****************************** Thanks, Roshawn Tag: SqlDataAdapter.Update() Tag: 79029
  - 14
    - Filters with Dataview or new SELECT I am new to database programming, and would like to follow the preferred programming methods when possible... I have large databases, in a small 'always connected' environment. I have been pulling large tables, and creating filters with some checkboxes etc.., which create dataviews. Couple of questions: 1. Is there an easier way to create the filters than a bunch of IF THEN's to create the filter string? (ie: if first filter add "(", if last add ")", if not first or last add " or ")... 2. Can I use the Compute command on dataviews? 3. I have been creating some classes to help with the 'logic' of analysis on some of the data. It appears to me that developers choose between either using the DataAdapters, Datasets and bound data direct from the database for their forms, or they create class objects, and bind the classes to the datasources. It would appear that classes would be the safest, but more complex route. The VB books that I have spend good energy on classes, and then good energy on ADO, but always seem to separate ADO from classes (ie: run through all the standard dataadapter/dataset bound directly to the forms components). I am currently enjoying the Deitel VB.NET book, which I highly recommend to beginning programmers - but it will take me some time to get through it. Looking forward to any comments. Masa Tag: SqlDataAdapter.Update() Tag: 79024
  - 15
    - Repeater Vs Datagrid Hi All For one page I want to implement sortng as well as paging. Curretly that page is using datagrid for data binding and sorting. Datagrid supports attributes like sortexpression and sort order to provide sorting very easily. is there any thing supported by repeater. Also for repeater I have one paging repeater class ready with me. So, i vcan simply derive a class from it and implement things But, what i want to know is which one is better keeping into mind the performance? datagrid also supports paging. but, i suppose it will fetch all the records only to sow 25 out of it. So, can anyone please guide me on this for points like performance, less developement time etc.. Tag: SqlDataAdapter.Update() Tag: 79020
  - 16
    - DataSet serialization Hi all, I have my own classes that derives from DataTable, Ex. [Serializable] public class MyTable1 : DataTable { public MyTable1() : base { ... } public MyTable1(SerializationInfo info, StreamingContext context) : base(info, context) {} } My business layer create and fill the table and add it to the DataSet obectr and send serialiazed to the client via remouting, on the UI side when I get the table the type is simple DataTable, why ? How to serialized and desirizlized the typed DataTable, I want to get typed DaTable with best regards Viorel ghilas Tag: SqlDataAdapter.Update() Tag: 79019
  - 17
    - ODBC API Hi I don't know how to access the ODBC API through C#. The VS.NET provides OLEDB Data Provider but not ODBC E.g., select * from tbl where id= To get the data type (description) of the column 'id', the ODBC provides a function 'SQLDescribeParam()'. But, I don't know how to access this function through C#.Could anyone help me TIA Arrun Tag: SqlDataAdapter.Update() Tag: 79014
  - 18
    - rergarding assembly load error hi, i'm trying to use Mono.Data.SybaseClient.dll (sybase ADO.net driver) from a C# windows forms application. on the line where i first reference the file, i get an error saying "unable to load file Mono.Data.SybaseClient.dll". the file i've stored in my applications debig directory. any help please. TIA "Vinit". Tag: SqlDataAdapter.Update() Tag: 79013
  - 19
    - DataColumn.Add bug? DataType parameter cannot be added I am trying to create a DataColumn with Name and DataType parameters. As I understand from the documentation, one of the overloads supports creation of a column with these two parameters. When I tried folllowing, however I get error saying 'int' denotes a 'class' where a 'variable' was expected code ------- DataColumn dc = new DataColumn("Name", System.Int32) or DataColumn dc = new DataColumn("Name", System.Type.GetType(System.Int32)) or MyTable.Columns.Add("Name", System.Int32) ERROR: ------- 'int' denotes a 'class' where a 'variable' was expected I am using .NET Framework 1.1 in Visual Studio.NET environment. Is this a bug or am I doing something wrong Tag: SqlDataAdapter.Update() Tag: 79000
  - 20
    - Problem with a DataAdapter - Newbie Question Hi In the following code, I get an Error when I try to Fill the Dataset String sql = "SELECT * FROM Table1 UNION SELECT * FROM Table2 UNION SELECT * FROM Table3" SqlDataAdapter earnAggAdapter = new SqlDataAdapter(sql, con) earnAggAdapter.Fill(tempDS, "Earnings"); // I get a "System Error" her If I try with only the Union of Table1 and Table2 it works Does that mean that the DataAdapter does not support more than one Union in the same statement Is there another way to make this work thanks Jane Tag: SqlDataAdapter.Update() Tag: 78998
  - 21
    - Connection to paradox 4 from vb.net application ? Hi, How can I connect to paradox 4.0 from my vb.net application ? Any sample code ? Help me ! Tag: SqlDataAdapter.Update() Tag: 78997
  - 22
    - SqlDataReader advancing on each line of executable code within a loop I have the following code (this is only a small snippet of the code) compiled into a VB.Net exe file. The SqlDataReader (myReader) is populated via an SqlCommand.ExecuteReader() method call where the CommandType is a stored procedure on SQLServer2000. 1: myReader = myCommand.ExecuteReader() 2: Do While myReader.Read() 3: Select Case myReader.GetInt32(0) 4: Case 1 5: ' do one thing 6: Case 2 7: ' do something else 8: Case 3 9: ' do yet another thing 10: End Select 11: ' more processing of the first record Loop According to the SqlDataReader documentation it is supposed to advance through the records on each call of the Read method and it is supposed to be positioned just prior to the first record right after the ExecuteReader method fills it. The issue I am experincing is that the reader is positioned on the first record after the ExecuteReader method (line 1). Consequently, after the Raed method is called on line 2, the value of the Select Case expression is now that of the second record. Also, after each Case evaluation (lines 4,6, and 8) the reader is advancing. Therefore, by the time it loops back to the Read method (Line 2) it is impossible to determine where the reader will be positioned. Line 1 executes: reader positioned on record 1 Line 2 executes: reader positioned on record 2 Line 3 executes: reader positioned on record 3 Line 4 executes: reader positioned on record 4 Line 6 executes: reader positioned on record 5 Line 8 executes: reader positioned on record 6 Line 9 executes: reader positioned on record 7 Line 11 through N executes: the reader advances for each executable line of code. Given that this is an exe file, there is no web.config file, so I'm wondering if there is some other location that a particular setting may be causing this behavior. I know I could put the initial data from the stored procedure int a DataSet and then iterate through the Rows collection, but I'd rather keep it simple with the Reader.Read methodology. Any help or insight into the cause of the observed behavior will be appreciated. Thanks, Tim Tag: SqlDataAdapter.Update() Tag: 78994
  - 23
    - Connections Not Closing I am using the data access application block running on Windows server 2003 and accessing SQL 2000 database (on the same box). I have some very simple code that is getting executed from a asp.net page. The code is calling executeNonQuery in a loop 30 times. I notice that after the code executes and I go into SQL Enterprise Manager and look at the open connections there are 30 open connections. Is there something I am missing ? I thought the application block would handle closing the connections. The other interesting thing is if I run the same code on Windows 2000 server accessing the database on the 2003 server everything works ok. Any ideas ??? Tag: SqlDataAdapter.Update() Tag: 78991
  - 24
    - Sysntax Error Inserting into a table with an OleDbCommand Hi all, I need another set of eyes to look at a problem I'm having. I'm trying to insert data into a Micrsoft Access 2002 table using the following SQL statement (all fields are Text): "Insert Into Customers (UserName, Password, FirstName, LastName, Address, PostCode, PhoneDay, PhoneEve, PhoneMob) Values ('Jack', 'beanstalk', 'Jack', 'Beanstalk', 'Nowhere', 'Nothing', '00000000', ' ', ' ')" As far as I can tell, there is absolutely nothing wrong with this Insert statement but ADO.Net thinks different and I keep getting a "Syntax error in INSERT INTO statement" error. The code I'm using is as follows: bool AllOk = true; RowsAffected = 0; try { OleDbConnection cn = new OleDbConnection(cnString()); cn.Open(); OleDbCommand cmd = new OleDbCommand(SQLstmt, cn); RowsAffected = cmd.ExecuteNonQuery(); <----THIS DOESN'T WORK cn.Close(); cn.Dispose(); cn = null; cmd.Dispose(); cmd = null; } catch (Exception e) {AllOk = false;} I'm getting desperate, can anyone tell me what I'm doing wrong. Regards. Wole London. -- =============================== Life is not fair, get used to it! God is fair, get Him! Tag: SqlDataAdapter.Update() Tag: 78989
  - 25
    - Problem with Odbc and DB2 Hi.. My trouble is the follow I have a connection with System.Data.Odbc to DB Db2 v6.1 I called a storedp rocedure, this retrun 2 resultset, i fill a dataSet with a OdbcDataAdapter created with a OdbcCommand and the name storedprocedure and builded sentences with OdbcCommand Bulider. When i execute the DataAdapter.Fill(dataSet) i got the dataset with a table but this raise a error that is: System.Object "{"Referencia a objeto no establecida como instancia de un objeto." }" Thx by your help. Tag: SqlDataAdapter.Update() Tag: 78988
- Next
  - 1
    - Microsoft Dotnet, Timestamp, and Char <very odd> Hi there, I am calling a number of Oracle stored procedures via the Microsoft OracleClient and the ODP.Net client (Using OracleDataAdapter.Update and/or Direct OracleCommand.ExecuteNonQuery in both) and I am noticing that any char parameters are over-padded with a full set (eg. 5 for char(5)) of blank characters (even when no padding is necessary or in addition to correct padding) whenever they are located after a timestamp parameter. This, of course, causes an 'Inserted value too large' error on those overpadded columns. The timestamp parameter has a null default, and causes no problems if the parameter is not passed and the default applied. However, if the parameter is passed with a actual value or DBNull.Value then the error occurs. Has anyone experienced anything like this? We are faced with making sure timestamp parameters are always at the bottom of the parameter list or using varchars for all logically fixed string columns. Neither really addresses the root problem. Thanks, Tracy Fletcher Tag: SqlDataAdapter.Update() Tag: 78983
  - 2
    - Query string issue with Microsoft access. Hello Everyone, I am having an unusual problem. I have this string that I am using as the Select Command for an Access database: SELECT time.employee, time.timein, time.timeout, time.ichkalt, time.ochkalt, time.realin, time.realout, employees.FName, time.iDate, time.oDate, FROM departments INNER JOIN (employees INNER JOIN [time] ON employees.employeeid=time.employee) ON departments.departmentid=employees.departmentid WHERE ((time.oDate) <= " & o & " ) And ((employees.employeeid)= " & eid & " ) AND ((time.iDate)>= " & i & " ) The i, o, and eid variables have been declared already. The result set works when you remove the 'oDate <=" & o & " )' part of the statement. When you run the query without that criteria, the result set is returned correctly. When you add that criteria to the string, no results are returned, even when I am inserting correct information. Does anyone have a clue as to what to do? Thanks in advance. Tag: SqlDataAdapter.Update() Tag: 78982
  - 3
    - Confused about DataRowVersion.Default From MSDN on DataRowVersion.Default: "The row the default version for the current DataRowState. For a DataRowState value of Added, Modified or Current, the default version is Current. For a DataRowState of Deleted, the version is Original. For a DataRowState value of Detached, the version is Proposed." Reading the above, I would assume that this code: ///// ReturnValue = MyDataRow[ "MyFieldName", DataRowVersion.Default ]; ///// Should be equivalent to this code: ///// if ( MyDataRow.RowState == DataRowState.Deleted ) { ReturnValue = MyDataRow[ "MyFieldName", DataRowVersion.Original ]; } else { ReturnValue = MyDataRow[ "MyFieldName", DataRowVersion.Current ]; } ///// However, the first block of code throws DeletedRowInaccessibleException while the second one works just fine. Am I reading the documentation wrong? What am I missing? Thanks, -Steve Tag: SqlDataAdapter.Update() Tag: 78981
  - 4
    - Problem with SQL Server I have an asp.net form that works fine with an Access database. Now I want to use Sql Server 2000. It is installed on the same Windows 2003 machine as the aspx code runs. I cannot seem to have a SqlConnection successfully connect. I use the following: string str = "Persist Security Info=False;Integrated Security=SSPI;database="+strDatabase+";server="+strServer+";Connect Timeout=30"; m_SqlConnection = new SqlConnection(str); m_SqlConnection.Open(); I get Login failed for user 'NT AUTHORITY\NETWORK SERVICE' I have also tried to leave out the Persist Security Info and Integrated Security, and replace it with uid=sa;pwd=<my sa password here> but I get the error: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. The same thing occurs for any user that I add to the Enterprise Manager. At this point I am not sure what I need to do to configure Sql Server. I know that there are many knowledgable Sql Server users out there. Can anyone answer my question? Tag: SqlDataAdapter.Update() Tag: 78979
  - 5
    - odd behaviour adding record to sql database i have created a form to submit data to an sql database, and it seems to work, except for one glitch. one of the fields, the "creditcardnumbertxt" text box, when entering a number with more that 7 characters, does not work. sql says it will be truncated. in the asp code, the database, and the sql procedure, the field is correctly set to allow a (sql datablase) char type of 18 characters in size. here is the error it spits back ---------------------------------- String or binary data would be truncated.The statement has been terminated..Net SqlClient Data Provider ----------------------------------- in the code behind the page, these are the relevant lines: ------------------------------------ cmd.Parameters.Add(New SqlParameter("@credit_card_nbr", SqlDbType.Char, 18)) cmd.Parameters.Item("@credit_card_nbr").Value = RegCreditcardnumberTXT.Text ----------------------------------- the relevant lines in the procedure in the sql server is ----------------------------------- @credit_card_nbr char(18), ------------------------------------ any help would be great thanks for the help bryan Tag: SqlDataAdapter.Update() Tag: 78977
  - 6
    - Strange ADO.NET/Sybase/Sybase OLEDB problem We've recently run in to a very strange problem with a windows service that we have developed in VB.NET and that accesses a Sybase database using the Sybase OLEDB driver via ADO.NET. Every morning about 5am, the windows service checks a specified directory, looking for data export files. If it finds them then it parses them, uploads the contents to a set of temporary tables and then runs a stored procedure (call it MergeData) to merge the needed data from the temporary tables in to the tables used by our main system. It then fires off another couple of stored procedures to prepare report data and then a set of reports are generated. This has all worked fine for a couple of months now. All of a sudden the MergeData stored proc has started to finish prematurely before it has completed all of the processing it is supposed to do. The strange thing is that it doesn't raise any errors back to the windows service. It just seems to stop doing what it was doing before it has completed all of the processing and returns control to the windows service, which then carries on with the other stored proc calls. The even stranger thing is that if we then run the MergeData stored proc directly on the database it works fine and completes all the processing it was supposed to do. However, it gets even stranger. The same installation of the windows service that was used on our live server was installed on our test server, the same data export files were copied across and it works perfectly. The test server uses the same versions of .NET framework, Sybase OLEDB driver and Sybase database. So from the surface the test server looks to have exactly the same software on it - both the software we developed and the third party software we use. Why would a stored procedure not complete when run from an application (without throwing any errors) but work fine when run interactively from the database (without throwing any errors)? And why would the same version of the application on another environment work perfectly. Both the command and connection timeouts on our OLEDB objects are set to 20mins and this timeout is not being reached. The process finishes prematurely within about 9-10 minutes and then continues with the other stored procs. We've had timeout issues before but they have always thrown errors. Has anyone seen this sort of problem using ADO.NET, Sybase or the Sybase OLEDB driver? As you can see it's proving to be frustrating trying to logically conclude where the problem resides. Our code seems fine on the test server but doesn't seem to work on the live server. Therefore you'd think it would be an environment issue, however the MergeData stored proc works fine on the live server when run interactively from the database. Very confusing! :-) Sorry for the crosspost but I haven't a clue which bit of our system the problem resides in. Thanks for any help you can give, Steve Tag: SqlDataAdapter.Update() Tag: 78974
  - 7
    - SOLVED: CaseSensitive and Guid / Find() I just though I would share with the group a small problem i ran into then solved after banging my head on the monitor for a few hours. For my dataset i have an XML schema that i load up. Its not quite a strongly typed dataset, i just look for scheama changes with my data adapter. Anyway.... In my dataset the primary key(s) of tables are uniqueidentifiers. Unfortunately some of the columns coming from the database are coming out as varchar() ..don't ask , i want them all as unique ID's. So looking at the XSD schema i'll see entries like <xs:attribute name="Record_GUID" type="xs:string" msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> Loading up data into the dataset works fine. But, I found that some of the fields defined as above are of type System.Guid others are strings. Whats the difference ? If the field was a varchar in the DB and I forgot to run a Cast(Record_GUID as uniqueidentifier) operation on the column, then it shows up as System.String. Now here's the rub... values in the fields are of type string, but when you run a find on the object the compare seems to be binary ...that means it ignores the Table.CaseSensitive setting. So Table.Rows.Find( "2F79A7BA-9AD9-4D3E-835F-780FB2A9CE13") is different than Table.Rows.Find( "2f79a7ba-9ad9-4d3e-835f-780fb2a9ce13") even though the objects in the column are of type string. Anyway, i'm not sure if this is a bug, or if the data adapter that fills the schema should throw an error. I just hope this helps someone save a few tedious hours of debugging. Regards, -eric Tag: SqlDataAdapter.Update() Tag: 78967
  - 8
    - Random SQL Timeouts after Web Win2k3 upgrade. I recently upgraded our web server from windows 2000 to windows 2003. Our SQL server is a SQL 2k, Win 2k machine that has not been modified at all. Both have all of the most recent updates/patches. When I upgraded the web machine to windows 2003, we suddenly started having random timeout problems. Every few hours or so, every sql call from our web server would result in a timeout, or at least take a very long time. Then a few minutes later(anywhere from 5 to 30) everything would be fine again. Although it didn't make any sense that SQL would be causing the problem, I did run through the profiler, and everything seemed to okay there. There were no monster, life draining queries running at the start of every down time. So currently, my best guess is that it has got something to do with ado.net. Currently I'm running a strictly ASP site on the server. I've yet to utilize any of the .net functionality on this site, and we have no objects installed other than our eCommerce credit card verifier. I'm using the following connection string to connect to SQL: DRIVER={SQL Server};SERVER=10.10.10.10;NETWORK=DBMSSOCN;UID=username;PASSWORD=password;DATABASE=dbname Any help you can offer will be GREATLY appreciated. I've been spinning my wheels on this for a while. Thanks. Tag: SqlDataAdapter.Update() Tag: 78966
  - 9
    - RollbackTransaction is not working with Oracle .Net Data Provider Hi, Could any one pls tell me how this rollback transaction works. I need to call TestProc stored procedure(it has got its own transaction). I want to rollback in my ASP.net code even if the TestProc executes successfully. The follg is the code part which I'm using. It is executing the Rollback stt in the finally block but still it is not rolling back. I'm using Oracle 8.1.7 client and the server is Oracle 7.3 Pls help me!!! Many thanks. ------------------------------------------------------- Dim cmdXX As OracleCommand Dim conOra As New OracleConnection(ConnString) Dim trnOra As OracleTransaction conOra.Open() trnOra = conOra.BeginTransaction() Try ' Get Oracle Connection. cmdRegisterCandidate = New OracleCommand("TestProc", conOra, trnOra) cmdRegisterCandidate.CommandType = CommandType.StoredProcedure With cmdXX .Parameters.Add(New OracleParameter("UserName", OracleType.VarChar, 20)) .Parameters("UserName").Direction = ParameterDirection.Input .Parameters("UserName").Value = sUsername .Parameters.Add(New OracleParameter("IPAddress", OracleType.VarChar, 15)) .Parameters("IPAddress").Direction = ParameterDirection.Input .Parameters("IPAddress").Value = sIPAddress .Parameters.Add(New OracleParameter("Err", OracleType.VarChar, 100)) .Parameters("Err").Direction = ParameterDirection.Output .ExecuteNonQuery() End With Catch ex As Exception WriteToLog(......) Finally trnOra.Rollback() conOra.Close() End Try ------------------------------------------------------- Tag: SqlDataAdapter.Update() Tag: 78961
  - 10
    - connection pooling and commits I am using ado.net connection pooling and am calling stored procedures using ExecuteNonQuery. My manager says the following: "if you are using pooling, and you don't do your commit, then the implied transaction will remain open until the connection closes...if someone else jumps into the connection, then they can actually rollback your updates. Is this true? After calling ExecuteNonQuery do I have to manually commit Tag: SqlDataAdapter.Update() Tag: 78959
  - 11
    - How to save image in SQL ? Hi ! I´ve a problem saving images in SQL DB. It acccepts images size>=8k and I can´t figure out why ? This is the code I use to upload the images. It comes from ASP.Alliance. I thought it would work properly but ?? Sub UploadImage(sender as object, e as EventArgs) Dim imgstream As Stream = ImageFile.PostedFile.InputStream Dim imgdata(ImageFile.PostedFile.ContentLength) As Byte imgstream.Read(imgdata, 0, ImageFile.PostedFile.ContentLength) Dim objConn as New SQLClient.SQLConnection("Some connection string") Dim cmdText = "INSERT INTO wm_images(Name, Type, Image) VALUES( @imgtitle, @imgtype, @image)" Dim objcmd As New SqlClient.SqlCommand(cmdText, objConn) Dim titleparam As New SqlClient.SqlParameter("@imgtitle", SqlDbType.NVarChar, 100) Dim typeparam As New SqlClient.SqlParameter("@imgtype", SqlDbType.NVarChar, 100) Dim imgparam As New SqlClient.SqlParameter("@image", SqlDbType.Image) titleparam.Value = ImageTitle.Text typeparam.Value = ImageFile.PostedFile.ContentType imgparam.Value = imgdata objcmd.Parameters.Add(titleparam) objcmd.Parameters.Add(typeparam) objcmd.Parameters.Add(imgparam) objconn.Open() objcmd.ExecuteNonQuery() objconn.close() End Sub Has anyone any ideas I would be most greatful ! Regards OM "Myggan" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: SqlDataAdapter.Update() Tag: 78958
  - 12
    - ado.net , sql server, and asymptotic time complexity We are new to relational databases in general and sql server in particular. Is a search for a record by indexes O(log n)? Is the insert and delete operation O(n log n)? We are assuming that a record update without changing the primary/foreign key values is also O (log n). Correct? thanks in advance jay widman Tag: SqlDataAdapter.Update() Tag: 78954
  - 13
    - Data Import & Source Target DataType mismatch problem Hi All, I'm building app that reads data from the text files and then inserts it into SQL server table. When I read the text file into dataset, sometimes data type is not interpreted correctly. I'm using DataSet.Merge method to merge untyped dataset formed by reading the text file with typed dataset that has the schema of the database table. In the case when ODBC text driver does not interprete DataType correctly I compare the target column datatype with source column datatype in the dataset, if they dont match I try to change it but I'm getting exception stating, "column datatype cannot be changed once column has the data " which is perfectly right. Logically this operation should not be allowed but there has to be a way around. Has anybody got a way around this problem. Following are the alternatives I tried but seem to be inappropriate 1. DTS package to import text data. Doesnot work because text file contains odd number of columns, not all columns are imported. Also user edition is required before importing text file into database. 2. Create Dataset that has matching schema as that of table and clone source dataset row by row. This gets really expensive. I'm dealing with on an average 70MB of text data at a time. Can anybody suggest alternatives to this. Any help is really appreciated. Thanks, -HKM Tag: SqlDataAdapter.Update() Tag: 78953
  - 14
    - Matching 2 DataSets Hi all, I have a function that have a dataset in argument. I have an other ds from a particular dataset (dsProduct) Is there any way to match the two dataset ? Example : ds1 : columns are prod_cod_prod_desc, prod_usr dsProduit : prod_cod, prod_usr dsProduit = fct(ds1) Now I can use the right column of my dataset ( no error if column does'nt exist !) Is a such function fct or any way exist ? Thanks, Jeff Tag: SqlDataAdapter.Update() Tag: 78949
  - 15
    - MS Access Question Hi, Does MS Access have a valid timestamp data type, or must I use the datatime data type instead? Also how do I autogenerate these values? Thanks, Roshawn Tag: SqlDataAdapter.Update() Tag: 78947
  - 16
    - What is the application path for class library assembly? I am trying to create a xml config file for my class library assembly. The problem is that I can't seem to find out where the application will be running. I want to place the xml file in the /bin directory where the assembly would be. I tried Application.StartupPath but it does not work. Any suggestions? Tag: SqlDataAdapter.Update() Tag: 78941
  - 17
    - ADOMD? Hi there! Are there any smart ways to read data from olap, lika with ADOMD? Tag: SqlDataAdapter.Update() Tag: 78940
  - 18
    - How do I fetch data ? After an insert in my database using a OleDbDataAdapter, how can I fetch data ? I need to fecth data because when I don't have any data in one of my table and I add a new row in my Table, then I update it, it give me a concurrency exception. It don't give me any exception if I had a record before I fill my DataSet. Thank you for your help Tag: SqlDataAdapter.Update() Tag: 78934
  - 19
    - passing array to stored procedure hi al can u plz give me an example to passing array to stored procedure for sql serve than Mukunda Tag: SqlDataAdapter.Update() Tag: 78923
  - 20
    - Export Access to Excel Hi How to export Access table to Excel sheet programatically Thanks. Tag: SqlDataAdapter.Update() Tag: 78919
  - 21
    - Master/Detail relationship using ComboBoxes Hello! I'm wondering how to do Master/Detail relationship using ComboBoxes. I'm using VB (2003). I have DataSet containing tables called as 'State' and 'City' (not really 'State' and 'City' but idea is the same and easier to understand). I want user to select first 'State' of the ComboBox containing states and then the ComboBox containing cities should contain only cities for that selected state. I want to save only ID (.ValueMember) of the state and city to the database table. How to do this when using DataBinding? At the moment code looks like this ... '// *** 'State' ComboBox *** cbState.DataSource = ds.Tables("States") cbState.DisplayMember = "State" cbState.ValueMember = "ID" cbState.DataBindings.Add(New Binding("SelectedValue", myDataTable, "StateID")) '// *** 'City' ComboBox *** cbCity.DataSource = ds.Tables("Cities") cbCity.DisplayMember = "City" cbCity.ValueMember = "ID" cbCity.DataBindings.Add(New Binding("SelectedValue", myDataTable, "CityID")) ... and it's working fine, but I need to implement this selection relationship somehow. It should work also when myDataTable position changes - propably this is possible to do? -- Thank you in advance! Mika Tag: SqlDataAdapter.Update() Tag: 78914
  - 22
    - replacement for SQLDMO?? Hi there, i am trying to find out what is the replacement in .NET for the SQLDMO object which reads system objects and properties from SQL Server databases, eg, stored procedures, tables, views, s/proc parameters,etc...? thanks, Tag: SqlDataAdapter.Update() Tag: 78903
  - 23
    - How do I create a table and an Access database using .NET and C#? Tag: SqlDataAdapter.Update() Tag: 78900
  - 24
    - Microsoft.Jet.OLEDB.4.0 not registered Hi, I get the errormessage "The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine" trying to run a dot.net program. I'm running Windows 2000, English version. By a mistake I first installed MDAC 2.8 Norwegian version. I then installed MDAC 2.8 English version, but get the same error message. I have also tried MDAC 2.6 with no luck. Any suggestions to correct this problem will be appreciated ! Tnx Tag: SqlDataAdapter.Update() Tag: 78899
  - 25
    - Property Value Changes Value between calls Property Value Changes Value between calls In frmTopicFromStart I call a procedure in clsDataChor to retrieve the autoincrementing ID for the topic. I place it in a textbox and also put it in a public variable in btnSaveTabGeneral: clsDChor.TransferID(txtID, iTopicID) MsgBox("btn savetabgeneral " & iTopicID.ToString) The message box shows the correct value(according to the access data base, 71, as of the last run. In another tab I select topic test and click the QuickWordButton. The msgbox in quickword event handler also shows 71: Dim frm As New frmQuickWord frm.sQuick = str1 MsgBox("btnquickword " & iTopicID.ToString) frm.KSID = iTopicID frm.ShowDialog() KSID is a property in frmQuickWord and also shows 71, as it should, in the form_load event: Private Sub frmQuickWord_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load txtQuickWord.Text = sQuick.Trim cnQWKS.ConnectionString = gstrConn MsgBox("quickwordload " & KSID.ToString) End Sub Now the problem comes. There's a textbox with the selected text from the quickword button in frmtopicfromstart: This is used to add a row to the keywordsets table, the keywords table, and the searchphrase table. No problem: daQWKS.Fill(DsQWKS1, "KeywordSets") Dim tblKS As New dsQWKS.KeywordSetsDataTable Dim rowKS As dsQWKS.KeywordSetsRow Try rowKS = tblKS.NewKeywordSetsRow() Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowKS.Active = True rowKS.KeywordSet = txtQuickWord.Text 'sQuick 'rowKS.ID = -1 Try tblKS.AddKeywordSetsRow(rowKS) daQWKS.InsertCommand = New OleDb.OleDbCommand("INSERT INTO KeywordSets(Active, KeywordSet) values (?,?)", cnQWKS) daQWKS.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") daQWKS.InsertCommand.Parameters.Add("KeywordSet", OleDb.OleDbType.VarWChar, 16, "KeywordSet") AddHandler daQWKS.RowUpdated, AddressOf OnRowUpDated Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try Try Dim intModified As Integer intModified = daQWKS.Update(tblKS) Dim sOutput As String sOutput = "Modified " & intModified & " KeywordSet(s)" 'MessageBox.Show(sOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try daQWK.Fill(DsQWKS1, "Keywords") Dim tblK As New dsQWKS.KeywordsDataTable Dim rowK As dsQWKS.KeywordsRow Try rowK = tblK.NewKeywordsRow Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowK.Active = True rowK.Keyword = txtQuickWord.Text 'sQuick 'rowKS.ID = -1 rowK.KeywordSetID = KSID Try tblK.AddKeywordsRow(rowK) daQWK.InsertCommand = New OleDb.OleDbCommand("INSERT INTO Keywords(Active, Keyword,KeywordSetID) values (?,?,?)", cnQWKS) daQWK.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") daQWK.InsertCommand.Parameters.Add("Keyword", OleDb.OleDbType.VarWChar, 16, "Keyword") daQWK.InsertCommand.Parameters.Add("KeywordSetID", OleDb.OleDbType.Integer, 4, "KeywordSetID") Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try Try 'Dim intModified As Integer 'intModified = daQWK.Update(tblK) 'Dim sOutput As String 'sOutput = "Modified " & intModified & " Keyword(s)" 'MessageBox.Show(sOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try daQWSP.Fill(DsQWKS1, "SearchPhrase") Dim tblSP As New dsQWKS.SearchPhraseDataTable Dim rowSP As dsQWKS.SearchPhraseRow Try rowSP = tblSP.NewSearchPhraseRow Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowSP.Active = True rowSP.SearchPhrase = txtQuickWord.Text 'sQuick 'rowKS.ID = -1 rowSP.KeywordSetID = KSID Try tblSP.AddSearchPhraseRow(rowSP) daQWSP.InsertCommand = New OleDb.OleDbCommand("INSERT INTO SearchPhrase(Active, SearchPhrase,KeywordSetID) values (?,?,?)", cnQWKS) daQWSP.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") daQWSP.InsertCommand.Parameters.Add("SearchPhrase", OleDb.OleDbType.VarWChar, 16, "SearchPhrase") daQWSP.InsertCommand.Parameters.Add("KeywordSetID", OleDb.OleDbType.Integer, 4, "KeywordSetID") Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try Try 'Dim intModified As Integer 'intModified = daQWSP.Update(tblSP) 'Dim sOutput As String 'sOutput = "Modified " & intModified & " Keyword(s)" 'MessageBox.Show(sOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try There is one more table to update, the KeywordSetAssignments table, which tells me in which table the keywordset and other tables are assigned.(I do an indexing of all tables elsewhere). Here is part of the code for the last table: daKSTA.Fill(DsQWKS1, "KeywordSetAssignments") Dim tblKSTA As New dsQWKS.KeywordSetAssignmentsDataTable Dim rowKSTA As dsQWKS.KeywordSetAssignmentsRow Try rowKSTA = tblKSTA.NewKeywordSetAssignmentsRow Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowKSTA.BeginText = 0 Dim frm As New frmTopicFromStart rowKSTA.TopicID = KSID MsgBox("Btn save and close " & " TopicID " & rowKSTA.TopicID.ToString) rowKSTA.KeywordSetID = KSID The msgbox showed 111, and naturally the update for this table failed because there wasn't a corresponding table in topics. This happens every time and it's frustrating. Similar code works in many places elsewhere in the app. Can anybody tell me what's wrong. polynomial5d Tag: SqlDataAdapter.Update() Tag: 78898

I read some records from a text file using OleDbDataAdapter into a DataTable. Now I'd like to upload these records to Sql Server using SqlDataAdapter. Currently, I clone my DataTable and insert records into my cloned DataTable. This way the SqlDataAdapter properly recognizes that the records are new. Does anyone have an alternative technique

Thanks
Paul

Top

Re: SqlDataAdapter.Update() by Miha

Miha
Wed Feb 04 14:48:44 CST 2004

Hi Paul,

Sure, set oleDbDataAdapter.AcceptChangesDuringFill to false before Filling
data.
The rows will be marked as Added and cloning won't be necessary.

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

"Paul" <anonymous@discussions.microsoft.com> wrote in message
news:47C06014-3686-4552-B3F6-43E93483A620@microsoft.com...
> I read some records from a text file using OleDbDataAdapter into a
DataTable. Now I'd like to upload these records to Sql Server using
SqlDataAdapter. Currently, I clone my DataTable and insert records into my
cloned DataTable. This way the SqlDataAdapter properly recognizes that the
records are new. Does anyone have an alternative technique?
>
> Thanks,
> Paul

Top