TableAdapters and HasChanges

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
    - Does anyone know? Please Read [Third Attempt] If you got the answer, thank you so much. OK I have to ask this question again as I know it can=E2=80=99t be that difficult, nor is it that rare. So a lot of people are doing something wrong, but what are we doing wrong? Someone types text in Ms Word, say a blog entry or forum post, then they cut that text out of word and past it into a form on the web and submit it. It get written to SQL Server. The problem, word takes a single quote character #39 and turns it into #146 in most cases, by default. You then use a method let=E2=80=99s say GetDataSet() and work with that data. The text is messed up: "It=E2=80=99s" becomes "it=C3=A2=E2=82=AC= =E2=84=A2s" This is NOT a problem when using a DataReader, but when you return a DataSet... XML you get this behavior. Example I have searched the web for the afore mention characters and found that "many" web sites are displaying text in this manner For example here is one that does so: http://www.artima.com/forums/flat.jsp?forum=3D152&thread=3D159914 The first paragraph starts off this way: =E2=80=9CUsing ASP.NET 2.0=C3=A2=C2=80=C2=99s new GridView control with th= e new ObjectDataSource =E2=80=9D same messed up text in firefox Using ASP.NET 2.0=C3=A2=C2=80=C2=99s new GridView control with the new ObjectDataSource allows Tag: TableAdapters and HasChanges Tag: 135052
  - 2
    - VS 2005 datatable.copy NoNullAllowedException I am getting a NoNullAllowedException when I try to add a datatable to a dataset by using dataset.tables.add(datatableOld.copy()). I checked the AllowDBNull property on the column of datatableOld that was throwing the exception and it is set to "true". I am not sure why I am getting this exception since a null is allowed in this column and i thought a copy copied the schema and data. Any help with this would be appreciated. Tag: TableAdapters and HasChanges Tag: 135047
  - 3
    - Inserting Records Best Practice Could anyone point me in the right direction for the best way to insert a record into a SQL database using ADO.NET with 150+ columns? 1. DataReader + SqlCommand.CommandText + Insert statement 2. DataReader + SqlCommand.Paramerterized Query + Stored Procedure 3. DataSet + AddNew() 4. Other?? Thanks, Tag: TableAdapters and HasChanges Tag: 135042
  - 4
    - SqlException I have the following code to open a database. Since I don't have the db as specified in the connectionString, the connection.Open() will throw an SqlException. My question is why it opens the "SqlException occured" dialog before it goes to the catch block? Is there a setting to turn the dialog off? I am expecting to catch and handle the exception myself. I am in debug mode. try { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); } catch (Exception e) { } Tag: TableAdapters and HasChanges Tag: 135037
  - 5
    - DataTable/DataSet in Business Object Class Hi, I am implementing Business object, but while implementing this I want to have DataTable or DataSet as part of Business Object. For example, I want to bind controls directly to these Business Objects. So please suggest me how can I achieve this?? Is is good to create a Property in Business Object which will have return type as "DataTable / DataSet"?? or what could be the optimum way to achieve the same. Thanks & Regards, Manoj Singh Tag: TableAdapters and HasChanges Tag: 135035
  - 6
    - MI5 Persecution: my response to the harassment -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= my response to the harassment -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- My first reaction in 1990/91 was to assume that if I broke contact then they would not be able to follow and would lose interest. So I did the things that have been suggested by other people; I sold my television, stopped listening to the radio and tried to withdraw away from the sources of abuse as much as possible. I reasoned that they must have more important things to deal with and that normal people would simply leave me alone if it were made difficult for them to continue their harassment. I reckoned without the sheer vindictiveness of the abusers. They did not let up but instead "got to" people around me, mainly people at work, to do their dirty work for them. I went to see my GP, who refused to believe what he was being told, and refused to direct me on to anyone who could be of practical assistance. It was not until three years had passed that the GP admitted the matter was outside his competence and suggested going to the police. In the summer of 1994 we called in counter-surveillance experts from a private detective agency to sweep our house and telephone for bugging devices. They conducted a thorough search and found nothing; but as noted above, since the existence of surveillance was being forced in my face by the harassers, you would expect them to have taken the possibility of a counter-surveillance sweep into account when planning the type of devices to be employed. In Easter 1995 I made a complaint to my local Police station in London, but the police have not expressed any intention to do anything about the continuing harassment ("we're not saying it's happening and we're not saying it isn't happening" were the words used). I think the officer I spoke to at Easter wasn't aware of it happening, although other members of the police force obviously do know. From April 1995 until the present time the matter has been discussed in a lot of detail on the Usenet (Internet) "uk.misc" newsgroup. That discussion has given birth to the article which you are now reading. My hopes in posting to Usenet were that wider publicizing would discourage the security services from continuing their harassment, and "draw people out" into concurring with the truth of what was being said. Neither of those have followed, but the discussion has served a purpose in allowing this structured report to be created. 182 -- Posted via a free Usenet account from http://www.teranews.com Tag: TableAdapters and HasChanges Tag: 135031
  - 7
    - including odp.net dlls in an msi Hi, I have a C# Desktop application that uses ODP.NET as the data provider. I want to find out if there is a way to include ODP.NET dlls along with the application MSI. Just including the Oracle.DataAccess.dll within the msi does not work. Maybe I need to include ODP.NET within a launch condition, but how do I do this? Thanks. Tag: TableAdapters and HasChanges Tag: 135029
  - 8
    - MI5 Persecution: Bernard Levin expresses his views The article of which part is reproduced below was penned by Bernard Levin for the Features section of the Times on 21 September 1991. To my mind, it described the situation at the time and in particular a recent meeting with a friend, during which I for the first time admitted to someone other than my GP that I had been subjected to a conspiracy of harassment over the previous year and a half. >There is a madman running loose about London, called David Campbell; I have >no reason to believe that he is violent, but he should certainly be >approached with caution. You may know him by the curious glitter in his >eyes and a persistent trembling of his hands; if that does not suffice, you >will find him attempting to thrust no fewer than 48 books into your arms, >all hardbacks, with a promise that, if you should return to the same >meeting-place next year, he will heave another 80 at you. > >If, by now, the police have arrived and are keeping a close watch on him, >you may feel sufficiently emboldened to examine the books. The jackets are >a model of uncluttered typography, elegantly and simply laid out; there is >an unobtrusive colophon of a rising sun, probably not picked at random. >Gaining confidence - the lunatic is smiling by now, and the policemen, who >know about such things, have significantly removed their helmets - you >could do worse than take the jacket off the first book in the pile. The >only word possible to describe the binding is sumptuous; real cloth in a >glorious shade of dark green, with the title and author in black and gold >on the spine. > >Look at it more closely; your eyes do not deceive you - it truly does have >real top-bands and tail-bands, in yellow, and, for good measure, a silk >marker ribbon in a lighter green. The paper is cream-wove and acid-free, >and the book is sewn, not glued. > >Throughout the encounter, I should have mentioned, our loony has been >chattering away, although what he is trying to say is almost impossible to >understand; after a time, however, he becomes sufficiently coherent to make >clear that he is trying to sell the books to you. Well, now, such quality >in bookmaking today can only be for collectors' limited editions at a >fearsome price - #30, #40, #50? > >No, no, he says, the glitter more powerful than ever and the trembling of >his hands rapidly spreading throughout his entire body; no, no - the books >are priced variously at #7, #8 or #9, with the top price #12. > >At this, the policemen understandably put their helmets back on; one of >them draws his truncheon and the other can be heard summoning >reinforcements on his walkie-talkie. The madman bursts into tears, and >swears it is all true. > >And it is. > >David Campbell has acquired the entire rights to the whole of the >Everyman's Library, which died a lingering and shameful death a decade or >so ago, and he proposes to start it all over again - 48 volumes this >September and 80 more next year, in editions I have described, at the >prices specified. He proposes to launch his amazing venture simultaneously >in Britain and the United States, with the massive firepower of Random >Century at his back in this country, and the dashing cavalry of Knopf >across the water, and no one who loves literature and courage will forbear >to cheer. At the time this article was written I had believed for some time that columnists in the Times and other journalists had been making references to my situation. Nothing unusual about this you may think, plenty of people have the same sort of ideas and obviously the papers aren't writing about them, so why should my beliefs not be as false as those of others? What makes this article so extraordinary is that three or four days immediately preceding its publication, I had a meeting with a friend, during the course of which we discussed the media persecution, and in particular that by Times columnists. It seemed to me, reading the article by Levin in Saturday?s paper, that he was describing in some detail his "artist?s impression" of that meeting. Most telling are the final sentences, when he writes, "The madman bursts into tears, and swears it is all true. And it is." Although I did not "burst into tears" (he seems to be using a bit of poetic licence and exaggerating) I did try hard to convince my friend that it was all true; and I am able to concur with Mr Levin, because, of course, it is. At the beginning of the piece Levin reveals a fear of being attacked by the "irrational" subject of his story, saying "I have no reason to believe that he is violent, but he should certainly be approached with caution". This goes back to the xenophobic propaganda of "defence" against a "threat" which was seen at the very beginning of the harassment. The impression of a "madman running loose" who needs to be controlled through an agency which assigns to itself the mantle of the "police" is also one which had been expressed elsewhere. In the final paragraph of this extract, his reference to Everyman?s Library as having "died a lingering and shameful death a decade or so ago" shows clearly what sort of conclusion they wish to their campaign. They want a permanent solution, and as they are prevented from achieving that solution directly, they waste significant resources on methods which have been repeatedly shown to be ineffective for such a purpose. 181 -- Posted via a free Usenet account from http://www.teranews.com Tag: TableAdapters and HasChanges Tag: 135027
  - 9
    - MI5 Persecution: cost of the operation -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: cost of the operation -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Here's what a couple of other people on Usenet (uk.misc) had to say regarding the cost of running such an operation... PO: >Have some sense, grow up and smell reality. What you are talking about PO: >would take loads of planning, tens of thousands of pounds and lots of PO: >people involved in the planning, execution and maintenance of it. You PO: >must have a very high opinion of yourself to think you are worth it. PM: >But why? And why you? Do you realize how much it would cost to keep PM: >one person under continuous surveillance for five years? Think about PM: >all the man/hours. Say they _just_ allocated a two man team and a PM: >supervisor. OK., Supervisor's salary, say, #30,000 a year. Two men, PM: >#20,000 a year each. But they'd need to work in shifts -- so it would PM: >be six men at #20,000 (which with on-costs would work out at more like PM: >#30,000 to the employer.) PM: > PM: >So, we're talking #30,000 x 6. #180,000. plus say, #40,000 for the PM: >supervisor. #220,000. Then you've got the hardware involved. And PM: >any transcription that needs doing. You don't think the 'Big Boss' PM: >would listen to hours and hours of tapes, do you. PM: > PM: >So, all in all, you couldn't actually do the job for much less than PM: >a quarter million a year. Over five years. What are you doing that makes PM: >it worth the while of the state to spend over one and a quarter million PM: >on you? Those are pretty much the sort of calculations that went through my head once I stopped to consider what it must be costing them to run this operation. The partial answer is, there have been periods when the intensity has been greater, and times when little has happened. In fact, for much of 1993 and the first half of 1994, very little happened. Although I don't think that was for reasons of money - if they can tap into the taxpayer they're not going to be short of resources, are they? The more complete answer is in the enormity of what they're doing. Relative to the cost to British pride of seeing their country humiliated for the persecution of their own citizens, isn't is worth the cost of four or five people to try to bring things to a close in the manner they would wish? To the government a million or two is quite honestly nothing - if they can convince themselves of the necessity of what they're doing, resources will not be the limiting factor. 182 -- Posted via a free Usenet account from http://www.teranews.com Tag: TableAdapters and HasChanges Tag: 135024
  - 10
    - Problem adding aggregate datacolumn to datatable Hi, I've tried with: dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL", typeof(decimal),"Sum(Child(dsAES_aes-aes_packages).F35_GROSSWEIGHT)"); dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL", typeof(decimal),"Sum(Child(dsAES_aes-aes_packages.F35_GROSSWEIGHT))"); Both give me an exception like this: syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier I basically copied the statement from the VS help file so I have no idea what could be wrong here... I appreciate all help, thanks in advance! Trygve Tag: TableAdapters and HasChanges Tag: 135016
  - 11
    - DataSet Question -- Simple Concept? Beginner to 3-Tier asp.net Hi, I am trying to be a thorough coder and create an app in layers. I can do it using the sqldatasource but I really want to try creating the app with tiers....thus.... If I use VS2005 to create a typed data set, I see that I can allow VS to automatically generate INSERT, UPDATE, DELTE, statements for the dataset. 1. Since the INSERT, etc. commands are directed at the database, why would you want to write custom INSERT, etc,. commands for the dataset? I though that that was the whole point of using stored procedures? If I want to use Northwind and return all products that cost over $1, I'd create a stored procedure ReturnProductsOverOneDollar. So if you use a stored procedure, would you put it in the DAL, or as a buisness rule in the business layer? Ideally I'd have a datlist or similar control, and then call the ReturnProductsOverOneDollar sp to populate it. 2. I would then this example, want to allow the user to add a product using another stored procedure, AddProducts. AddProducts would obviously have an INSERT statement in it. Does this INSERT statement have to be defined in the DAL? Clearly I have to code as many stored procedures as I need, but does this mean that I have to write an INSERT, UPDATE, and DELETE statement in the DAL for every possible occurrence? 3. If I use northwind for example, and make a TableAdapter based on the products table (call it ProductTableAdapter), I see that it generates a Fill() method and a Get() method which returns data based on my SELECT statement. If you let the Table Adapter Wizard automatically generate the INSERT, UPDATE, etc. statements, why don't you see them as methods in the TableAdapter. Thank you so much in advance for your help. -David Tag: TableAdapters and HasChanges Tag: 135010
  - 12
    - Inserting Formatted text including images into SQL 2005 using ASP. Hi, Im trying to develope a web application that could be used for stroing data such as formated text including pictures . the text should be inserted in word documents,html or xml. please does any one can help me ? in other words i want to develope somethings like a NEWS WEB SITE that every one can insert his/her news into it. the news could have pictures Tag: TableAdapters and HasChanges Tag: 134995
  - 13
    - Internal connection error I found that when I fill over 10,000 records to a dataset, there will be an error "Internal Connection error". Please help. Tag: TableAdapters and HasChanges Tag: 134988
  - 14
    - Catalog of tables in an SSCE database What objects and services do I use to visualize the collection of tables and the table's collections of columns in a SSCE database file. Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to allow me to see the contents very quickly. The Data Source Display inside vs2005 are slow and not really user friendly. I want to build something along the lines of the Access interface when in Design mode. I do not see any objects or methods available in SSCE objects, (System.Data.SqlServerCe) and info is scarce. Garry Tag: TableAdapters and HasChanges Tag: 134964
  - 15
    - No value given for one or more required parameters I am trying to run the following method and keep getting the error "No value given for one or more required parameters". I've seen that if you have a field misspelled, that you can get this error, so I ran the query through Access and it works. Can anyone please tell me what I am doing wrong? The line it stops on is: dr = command.ExecuteReader(); Thank you. public static string Lookup(int customerID) { using (OleDbConnection conn = new OleDbConnection(JimsVideo.Properties.Settings.Default.JimsVideoConnectionString.ToString())) { using (OleDbCommand command = new OleDbCommand("SELECT FirstName, LastName, StreetAddress, StreetAddress2, City, State, Zip, Phone, Phone2, AccountBalance FROM Customer WHERE CustomerID = ?", conn)) { conn.Open(); command.Parameters.AddWithValue("customerID", customerID); OleDbDataReader dr; dr = command.ExecuteReader(); while (dr.Read()) { string firstName = dr["FirstName"].ToString(); string lastName = dr["LastName"].ToString(); string streetAddress = dr["StreetAddress"].ToString(); string streetAddress2 = dr["StreetAddress2"].ToString(); string city = dr["City"].ToString(); string state = dr["State"].ToString(); string zip = dr["Zip"].ToString(); string phone = dr["Phone"].ToString(); string phone2 = dr["Phone2"].ToString(); decimal balance = decimal.Parse(dr["AccountBalance"].ToString()); } return "complete"; //Just for testing until I get this correct. } } } Tag: TableAdapters and HasChanges Tag: 134962
  - 16
    - Storing HTML code into SQL 2005 by using asp.net2 hi, i wabt to insert a rich text format(*.rtf) file type with a picture into sql database. i have done this issue by converting rtf into web page and save the html code into sql server table. but the problem is when the web page has a picture, the picture could not be shown. whats the problem? Tag: TableAdapters and HasChanges Tag: 134957
  - 17
    - Master and Content pages I'm trying to get the hang of using master and content pages in ASP.NET 2. I have a web page of various reports setup in a table like this: ************************************************ * * * Header * * * ************************************************* * * * * M * * * E * * * N * CONTENT * * U * * * * * * * * * * * ************************************************* When the client makes a menu selection I want to select from various Content pages that specify the input variables for the report like: date range, customer number, output type etc. I can design the master page with no problem with the placeholder for the content, but how do I dynamically select different content to go into the "Content" part? It seems like the content part is just fixed to a certain content file and I want to specify it based on the menu selection. Can someone point me to a good example or just let me know if there is some better way to do this? Thanks, Rick Tag: TableAdapters and HasChanges Tag: 134956
  - 18
    - Getting a table schema from an Excel File in ADO.NET Sorry - previous post has incorrect title I am using the following code which appears in slightly different versions in many articles on the web Dim excelConn As New System.Data.OleDb.OleDbConnection Dim dtXlsSchema As DataTable Dim int As Integer excelConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strExcelFileName & ";" & "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'" excelConn.Open() dtXlsSchema = excelConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) For int = 0 To dtXlsSchema.Rows.Count - 1 Debug.WriteLine(dtXlsSchema.Rows(int).Item("Table_Name").ToString) Next The value in dtXlsSchema.Rows.Count is always zero. If in code I tried to build a DataSet from the excel file, I use a TableName/WorksheetName with the syntax strWorksheetName & "$;" with or without square brackets, with or without the dollar sign, I get an error saying that vs.net, cannot find the object {TableName}. The Excel file exists and has 5 worksheets. The Open() succeeds without any error message. Can anyone tell me what I am doing wrong?? Code after this example: dtXlsSchema = excelConn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, strWorksheetName & "$", "TABLE"}) For int = 0 To dtXlsSchema.Columns.Count - 1 Debug.WriteLine(dtXlsSchema.Columns(int).ToString) Next does have a value(28) Garry Tag: TableAdapters and HasChanges Tag: 134953
  - 19
    - Getting the Table Schema from an Access file in ADO.NET I am using the following code which appears in slightly different versions in many articles on the web Dim excelConn As New System.Data.OleDb.OleDbConnection Dim dtXlsSchema As DataTable Dim int As Integer excelConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strExcelFileName & ";" & "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'" excelConn.Open() dtXlsSchema = excelConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) For int = 0 To dtXlsSchema.Rows.Count - 1 Debug.WriteLine(dtXlsSchema.Rows(int).Item("Table_Name").ToString) Next The value in dtXlsSchema.Rows.Count is always zero. If in code I tried to build a DataSet from the excel file, I use a TableName/WorksheetName with the syntax strWorksheetName & "$;" with or without square brackets, with or without the dollar sign, I get an error saying that vs.net, cannot find the object {TableName}. The Excel file exists and has 5 worksheets. The Open() succeeds without any error message. Can anyone tell me what I am doing wrong?? Code after this example: dtXlsSchema = excelConn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, strWorksheetName & "$", "TABLE"}) For int = 0 To dtXlsSchema.Columns.Count - 1 Debug.WriteLine(dtXlsSchema.Columns(int).ToString) Next does have a value(28) Garry Tag: TableAdapters and HasChanges Tag: 134951
  - 20
    - Performanve Issue-Datasets in VB.net I'm using datasets in vb.net to pull the data from MSDE server. I refresh the data from server every 30 seconds. Since, i refresh the data i clear the dataset using dataset.clear and then fill it again. This clear method each time seems to be increasing the delay to refresh data. My dataset has information from 4 tables with relationships Also, when i save the data in database and then refresh the datasets that also keeps increasing the time delay. I'm not sure what else to do as this application is running in a multiuser enviorment and i need to refresh data on 3 PCs running the same applcation Any advise on how to tackle the problem Regards Kashif --- Posted via DotNetSlackers.com Tag: TableAdapters and HasChanges Tag: 134941
  - 21
    - How to covert an Oracle GUID to string ? Hi, I would like to convert an Oracle GUID to its string representation and I don't know how I can do this. Could you help me please. I need this GUID in its string representation to execute an sql query later with it as primary key. Thanks for your help Best Regards Fred Tag: TableAdapters and HasChanges Tag: 134940
  - 22
    - Can Strongly Typed DataSet contains Stored Procedure Wrappers? Hi There! I'm looking into Strongly Typed DataSets in the .NET Framework. I know it can generated strongly typed tables as objects and column names as properties. However, one thing that I would like to know is if it wraps database Stored Procedures as methods and functions? For instance, if I have a Stored Procedure called SelectBestProduct in the Product table, would I be able to call the Stored Procedure with Product.SelectBestProduct() statement and get DataReader or DataTable returned? Thank you all in advance! Jon Tag: TableAdapters and HasChanges Tag: 134936
  - 23
    - Check these dot net Interview Questions Hi All Check this link... http://www.dotnetinterviews.co.nr/ nice set of Interview Questions Thanks Chris Tag: TableAdapters and HasChanges Tag: 134934
  - 24
    - Question about the DataSet Merge. Dear All, Now i have a two dataset. they have same db structure and same columns and same rows. just the content is not same between them. for example: datagrid 1: name,sex,order_quality shenzhen benny,male,1000 shanghai allen,male,2000 hangzhou kevin,male,3000 datagrid 2: name,sex,order_quality shenzhen dragon,male,1000 shanghai leo,male,2000 hangzhou james,male,3000 sturcture is sames as the datagrid1. now i want to merge them into one datagrid. how to do it? (i can't used ado's Merge command, because it's not full fill my requirement). i want the combination of these two grids into: name,sex,order_quality,name1,sex1,order_quality1 shenzhen benny,male,1000,dragon,male,1000 shanghai allen,male,2000,leo,male,2000 hangzhou kevin,male,3000,james,male,3000 how to do it for the combination of the above? because the Merge command is only for the data merger for vertical. not for the horizontal. Now i must to used two for...loop...to finish this requirement. But I thinking whether i can get an easily ways to finish that. How is yor suggestion? Thanks, Benny Ng Tag: TableAdapters and HasChanges Tag: 134930
  - 25
    - World Wide Web Publishing©MIISªºÃö«Y ½Ð°ÝWorld Wide Web Publishing¬O¤£¬Oµ¥©óIIS©O? ©ÎªÌ¨âªÌ¤§¶¡¦³¤°»òÃö¨t©O? Tag: TableAdapters and HasChanges Tag: 134915
- Next
  - 1
    - What is a good strategy for joining data from separate databases I have a situation where I must restructure my data access, and was hoping the community could give me pointers or links to articles that would help. My situation is that I need to query data from two separate databases. One is my application's own database, and the other is a Data Mart created for me with a view I access. The way I do it currently requires that the SQL-Servers be linked, and, given our security setup, on the same SQL-Server. Currently the cross database queries take two forms: SELECT field FROM MyAppDataMart..vwAppData vw JOIN MyOwnDatabaseTable tbl ON vw.Field = tbl.Field OR SELECT field FROM MyAppDataMart..vwAppData vw WHERE NOT EXISTS(SELECT field FROM MyOwnDatabaseTable tbl WHERE vw.Field = tbl.Field) My current .NET business object merely makes a single stored procedure call to retrieve a resultset, with any joins required handled by the stored procedure. It is now considered unacceptable to have a dependency like that in the stored procedure and I need to re-structure the data access such that the .NET business object retrieves data separately from each database eliminiating the need for one database to be able to be linked or even aware of the other. This means, however, that I must handle any JOIN or EXISTS logic in my business object, and I am looking for strategies to accomplish that. From what I have read so far, I'm not sure the DataRelation in ADO.NET can enforce logic more complex than a INNER JOIN. In short, what I need to go to is from Existing: -Call stored procedure which bridges Database1 and Database2 and returns a resultset. Desired: -Retrieve info from Database1 -Retrieve info from Database2 -Apply any logic such as JOIN or EXISTS or NOT EXISTS to filter data -Return resultset. Any pointers or links would be greatly appreciated, thanks. Tag: TableAdapters and HasChanges Tag: 134912
  - 2
    - reuse connection object with diff username password? I have an ado.net based application (using BDP borland data provider actually). Everything is working fine. Up till now the connection string for my single connection object has been hard coded. set in designer. Now its time to implement login functionality using different user names and passwords. For a 'login' I figured, ok i'll close the connection if its open, then just change the ConnectionString. I set the exact same connection string as designer, I just set different username & password values. The second time I run thru this cycle however I get strange exceptions when trying to close the connection. "No pool found to release connection". Then when I go to use it I get "connection already open". The big question is, are connection objects meant to be reused in this manner, or must I new a new connection instance if I want to have a different connection string? thanks --- Posted via DotNetSlackers.com Tag: TableAdapters and HasChanges Tag: 134891
  - 3
    - Schema.ini is ignored Hi, i have another problem yet with |-seperated values: i have my connection: connCSV = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\path;Extended Properties=""Text""") and my schema.ini: [test.txt] Format=Delimited(|) but i get one big field containing text like "name|phone|street|" and so on. yesterday it worked, today i juggled a little with the code and i don't know what's wrong here!? has anyone an idea, i'm going crazy on this!!!! :-( thanks a lot :-) chris Tag: TableAdapters and HasChanges Tag: 134890
  - 4
    - SqlTransaction rollback error Hi, I've read through some posts on this error but none seem to exemplify what I had happen to me and wanted to see if anyone else has seen this. I know a lot of people like to see code, it's going to be hard to show you code examples as I'm using a lot of our common code (which is large) and some of that wraps Microsoft's application blocks. I'll try to explain it as best I can though: Basically, I have an app that is doing some writing to the database (don't they all? :)) and is using our common data code for committing and rolling back transactions. The data code has a class that I'm using that keeps a connection object open. In testing, my app took a very short period of time to run - but in production it is taking a much longer time (another common problem I'm sure). However, it took so long that I ended up getting this error: "This SqlTransaction has completed; it is no longer usable." My thought is that since I kept a connection object open and that the application took waaaayyy longer to run through than it should (over 8 hours), that the connection was lost and that is why I got this error because it couldn't use a transaction on a closed connection. Does that sound like a reasonable explanation of why I might get an error like this? Note: By the way, I am fixing my performance problem - it's outside the scope of this question though. :) Tag: TableAdapters and HasChanges Tag: 134886
  - 5
    - Bad record count importing excel spreadsheet to DataAdapter? Hello! I'm using the code below to import an Excel datasheet into an ado.net table. The problem is, when I get to the point where I want to iterate the recods, it always thinks that there is 999 records in the table! If the table (worksheet) is larger than that, then it returns an equally fictious number (always way more). Does anybody have any idea what I'm doing wrong? I'ts an excel 2003 spreadsheet that I'm reading from. Thanks in advance! Sub readSheet() Dim excelConn As New System.Data.OleDb.OleDbConnection excelConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\MySpreadSheet.xls;" & _ "Extended Properties=""Excel 8.0;HDR=Yes;""" excelConn.Open() Dim da As New OleDbDataAdapter("Select * From [SheetName$]", excelConn) Dim escapeExit As Boolean = False Dim ds As DataSet = New DataSet() Dim dc As DataColumn = Nothing Dim dt As DataTable = Nothing Dim rec As String = "" Dim i As Integer = 0 Dim x As Integer = 0 da.Fill(ds) dt = excelConn.GetSchema Dim dr As DataRow While Not Me.bwWorker.CancellationPending 'HERE'S THE PROBLEM: IT ALWAYS DECIDES THAT THERE'S 999 RECORDS!!! For Each dr In ds.Tables(0).Rows rec = "" For x = 0 To UBound(dr.ItemArray) rec = rec & " " & dr.ItemArray(x).ToString Next logIt(txtOutput.Text & ControlChars.CrLf & rec) 'Next Next End While excelConn.Close() excelConn.Dispose() End Sub Tag: TableAdapters and HasChanges Tag: 134882
  - 6
    - SQL Server Express Error on Connection My application uses the following code to attach and open a connection to an SQL Server Express Database: Dim conDatabase As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename="c:\database.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True") conDatabase.Open() The first time this works fine, then my application detatches the database from SQL Server Express using SSEUTIL. Then the user tries to attach and connect to another database (using the same code as above) and I get this error: A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll System.Data.SqlClient.SqlException: Unable to open the physical file "c:\anotherpath\database.mdf". Operating system error 32: "32(error not found)". An attempt to attach an auto-named database for file c:\anotherpath\database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Now the databases do have the same filename (in a different folder) but I have checked that after the first database is detached, that SSEUTIL reports that only the orginal system databases are attcahed by using "SSEUTIL -l". So, no, a database with the same name is not attached. The database is not located on a UNC share. Then if I re-write my code to continue calling the Open method of the connection until it is successful, it eventually works. This typically takes around 5000 attempts. Can anyone give me any ideas about what may be causing this problem? TIA Tag: TableAdapters and HasChanges Tag: 134881
  - 7
    - Querying a Dataset I have a dataset populated from a variety of sources, such as Access Database, SQL Database and Web services. I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE clause etc in this dataset. What's the best way to do it? Evan Camilleri Tag: TableAdapters and HasChanges Tag: 134876
  - 8
    - DataAdapter.Update bug updating Child table via Relations / RowState corrupted? Hi all. .Net 2.0. It seems the DataAdapter.Update Method changes the RowState of child records to 'Modified' when updating them through a Relation. If the child records' .RowState is "Added" or "Deleted," shouldn't they STAY that way? Otherwise when you try to update the child table, you get concurrency errors (record doesn't exist to update) or records fail to delete. Chris B. Tag: TableAdapters and HasChanges Tag: 134857
  - 9
    - Data Provider for Oracle: MS version vs. Oracle? Anyone have experience with the provider from Microsoft vs. the one from Oracle? I haven't looked very much at either. One would assume that the one written by Oracle itself should perform better, since they should be able to optimize it? Any sort of feedback or experience with either of these? Tag: TableAdapters and HasChanges Tag: 134850
  - 10
    - updating child records in a DataSet w/ new autoinc values after parent insert? Hi all. Using Dot Net 2.0. I have a typed dataset generated by VS. It contains a parent and a child table with a relationship set up in the MSSQL database and showing in the dataset. _Both_ tables have new records that need to be added to database. I'm able to retrieve the server's autoinc values on the parent table, but I can't seem to get my data adaper to filter the new autoinc values down to the foreign key field in the child table. HOW EXACTLY is this done??? I'm currently doing 3 things: 1. Added an output parameter to the insert command to grab the new autoinc value and feed it into my autoinc field. 2. Set insertCommand.UpdatedRowSource = UpdateRowSource.Both (figure good idea to grab it all). 3. Appended " SELECT @" + identityColumn.ColumnName + " = SCOPE_IDENTITY()" to the insert command. Does #3 keep the entire column's values from being fed back to the DataTable row? Do I need to AcceptChanges? What about if the operation fails and the transaction is rolled back, how do I undo changes made to the dataset? THANKS!!! Chris B. Tag: TableAdapters and HasChanges Tag: 134845
  - 11
    - Schema.ini for all textfiles in the folder Hi, i try to import several cvs-files into a database. These csv's are delimited by a "|". (don't ask me why it's named csv then ;-) .Net seems to ignore my settings in the connectionstring: ...Properties=""text;HDR=Yes;FMT=Custom-Delimited(|)""" i get a table with one field like name|street|phone and so on So i created a schema.ini and it works with one file, but: in my folder are up to 500 csv-files and im not willing to write all that stuff. now here is my question: is there a way for a global setting for that folder? in schema.ini i tried [*.csv] format=delimited(|) but it didn't work. i could read out all names (changing daily) of that folder an create a schema.ini, but in that case time plays a role and i would be glad if i coud save this time. thanks chris Tag: TableAdapters and HasChanges Tag: 134832
  - 12
    - [Datagrid Onclick Error] Hi all, Anyone know how to solve the datagrid onclick problem as below: i click a row in a datagrid then the row change to another color, but when i click on another row, the previous row that i clicked still red color, so now have two row that red in color. what I want is the previous row that i clicked change back to its original color without post back the page. I am using code below: <script language="JavaScript"> var lastColorUsed; function prettyDG_changeBackColor(row, highlight) { if (highlight) { lastColorUsed = row.style.backgroundColor; row.style.backgroundColor = 'pink'; } else if (row.style.backgroundColor == 'pink') { row.style.backgroundColor = lastColorUsed; } } var lastRowSelected; var lastRowSelectedColorUsed; function prettyDG_changeBackColor2(row) { var color = lastRowSelectedColorUsed; lastRowSelectedColorUsed= row.style.backgroundColor; row.style.backgroundColor = 'aqua'; lastRowSelected = row; if (lastRowSelected != null) { lastRowSelected.backgroundColor = color; lastRowSelected = row; } } </script> while the code behind as below: e.Item.Attributes.Add("onmouseover", "prettyDG_changeBackColor(this, true);") e.Item.Attributes.Add("onmouseout", "prettyDG_changeBackColor(this, false);") e.Item.Attributes.Add("onclick", "prettyDG_changeBackColor2(this, true);") The logic is when mouse over, the row become 'pink' color, when mouse out, if the row color is 'Pink' then change to transparent else don't change color when clicked, the row become 'Aqua' color. Please advice on how to change back the 'Aqua' to transparent color if we clicked on another row, this mean there will not more than 1 row with 'Aqua' color. Tag: TableAdapters and HasChanges Tag: 134825
  - 13
    - DataView.Find not working with GUID Using .NET 2.0, I have a DataView with two columns: JobID (a GUID) and JobNumber (an integer). DataView.Sort = "JobID". When I perform a DataView.Find(SomeJobID), I always get a result indicating the row was found, but it's the wrong row (code below). In the code below, as long as JobID is a valid GUID, the Offset is always the wrong row. This code seems to fail only when the DataView.Sort is a GUID - works fine on other types of data. Any ideas? Is this a bug in .NET 2.0? I've seen this same problem described elsewhere on the Internet, but no responses or answers. Thanks in advance, Warren Offset = DV.Find(JobID); if (Offset > -1) { JobNumberText = DV[Offset]["JobNumber"].ToString(); } //JobID was located Tag: TableAdapters and HasChanges Tag: 134824
  - 14
    - RowFilter date expression Is there an easy way to filter a datetime column on the year. The following does not work: YEAR(BeginDT) = 2006 Also does any one know if there is a list of valid expressions for the rowFilter? Thanks for your help. Tag: TableAdapters and HasChanges Tag: 134818
  - 15
    - OleDbPermission failed I am trying to test distributing a Windows application that accesses a Jet DB (.mdb) database file. On my development box running Windows XP Pro with Office Pro (and Access) installed, it runs fine. On my test machine running Windows Server 2003 without Office, it fails with Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I have checked, and the Jet Database engine is installed on that machine. It also has Framework 1.1 and 2.0 installed (this app was developed using 2.0). The code is straight from Microsoft's sample ado.net application http://msdn2.microsoft.com/en-us/library/dw70f090.aspx using the OleDb connector. I have found many clues on how to fix this problem when using ASP.NET, but nothing when it occurs in a Windows application. Anyone have any ideas? Thanks, Carole Tag: TableAdapters and HasChanges Tag: 134817
  - 16
    - InsertCommand gives "Must declare the scalar variable "@..." Hi, I have a strange problem and i think the sollutions is simple, but I don't get it. I have the following piece of code Dim pCommand As New System.Data.OleDb.OleDbCommand Dim sSql As String = "" sSql = "INSERT INTO dbo.Uitgaven ( " sSql &= " UitgavenOmschrijving," sSql &= " UitgavenBedrag," sSql &= " UitgavenKostenPostID," sSql &= " UitgavenDatum" sSql &= " ) " sSql &= "VALUES ( " sSql &= " @UitgavenOmschrijving," sSql &= " @UitgavenBedrag," sSql &= " @UitgavenKostenPostID," sSql &= " @UitgavenDatum" sSql &= " ) " pCommand.CommandText = sSql pCommand.UpdatedRowSource = UpdateRowSource.Both With pCommand .Parameters.Add("@UitgavenOmschrijving", OleDbType.VarChar, 50, "UitgavenOmschrijving") .Parameters.Add("@UitgavenBedrag", OleDbType.Double, 4, "UitgavenBedrag") .Parameters.Add("@uitgavenKostenPostID", OleDbType.Integer, 4, "UitgavenKostenPostID") .Parameters.Add("@UitgavenDatum", OleDbType.Date, 0, "UitgavenDatum") End With pCommand.Connection = pDB.Connection For iTeller As Integer = 0 To pDS.Tables(0).Rows.Count - 1 Try With pCommand .Parameters("@UitgavenOmschrijving").Value = pDS.Tables(0).Rows(iTeller).Item(3) .Parameters("@UitgavenBedrag").Value = pDS.Tables(0).Rows(iTeller).Item(1) .Parameters("@uitgavenKostenPostID").Value = pDS.Tables(0).Rows(iTeller).Item(2) .Parameters("@UitgavenDatum").Value = pDS.Tables(0).Rows(iTeller).Item(0) End With pCommand.CommandType = CommandType.Text MessageBox.Show(pCommand.ExecuteNonQuery) Catch ex As Exception MessageBox.Show(ex.Message) End Try Next I get a error "Mus declare the scalar variable "@UitgavenOmschrijving". I have not include the primary key because that is a database thing for me. Can anyone give me the sollution for my problem Thanks already Klaasjan Tag: TableAdapters and HasChanges Tag: 134816
  - 17
    - Test Tag: TableAdapters and HasChanges Tag: 134815
  - 18
    - Save DataSet to Data Definition File I have hundreds of Crystal Reports which have been created on Data Definition Files (ADO Recordset saved into ttx file) All these reports are invoked from VB6 application, and as a datasource for each of them I supply ADO Recordset. Everything works fine. Now I'm working on rewriting VB6 app in VB 2005. Using the same SQL Server SPs, I populate DataTables with data and use those DataTables as datasources for Crystal Reports. Everything works. In case I change something in underlying SP of any report, I can easy recreate TTX file in VB6. I'd like to have this ability in VB 2005. Is there any method of DataSet or DataTable object which saves the structure of underlying DataTable into TTX file. I couldn't find anything. I can recreate any TTX file manually, but I would want to do it using some methods of ADO.NET. Replacing TTX files with XML is not good too, because as I said I have hundreds of reports, and I will need to recreate each of them in case I change their bases (TTX with XML) Any idea please Tag: TableAdapters and HasChanges Tag: 134813
  - 19
    - Connection String - how to include timeout? Hi, I am having a problem creating a connection string in DotNet. Here is an example below: "Integrated Security=SSPI;database=MyDatabase;server=MySqlServer;Connect Timeout=60" The problem is in the timeout setting. I am running a query using this connection string and it is timing out at 30 seconds, it does not go to the 60 seconds. I figured it must be because it's a connection timeout setting I've used above and not an actual query timeout setting. However, I cannot determine how to set a query timeout setting in my connection string. Is there a way to do this? Tag: TableAdapters and HasChanges Tag: 134811
  - 20
    - Best way to reference a value in DataRowView When looping over items in the RowDataBound event for a GridView (ASP.NET) I can access e.Row.DataItem which shows as a DataRowView. The following code allows me to access the data for that row. e.Row.DataItem, System.Data.DataRowView).Row.Item(0) Is there a better way to access that data? This syntax looks very ugly and potentially error prone. Ideally I would simply use code like this... e.Row.DataItem("id") But I cannot seem to do that. Brennan Stehling http://brennan.offwhite.net/blog/ Tag: TableAdapters and HasChanges Tag: 134809
  - 21
    - Trouble displaying info from access db Hi Everyone, I have the project below where I'm pulling out information from 1 table "Subjects", pulling the Subjects, and SubjectCode. The Subjects are displaying in the Combo Box just fine, but I can not get the corresponding Subject Code to display in the Label. I have 2 Data adapters/dataset,1 for Subjects, and the other for SubjectCode, along with a Data View setup. I'm a newbie on VB.NET. This project is pulling from an Access DB. Is there anything that I should be looking for, or doing wrong that I'm not getting the Subject Code to display in the Label? Any help would be appreciated. __________________________________ Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Fill the List box dbSubject.Fill(DsSubject1) dbSubjectCode.Fill(DsSubjectCode2) DisplayRecordPosition() End Sub Private Sub cboSubjectName_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboSubjectName.SelectedIndexChanged ' DsSubject1.Clear() ' dbSubject.SelectCommand.Parameters("Subjects").Value = cboSubjectName.Text ' dbSubjectCode.Fill(DsSubjectCode2) End Sub Private Sub lblSubName_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lblSubName.Click DsSubjectCode2.Clear() dbSubjectCode.SelectCommand.Parameters("SubjectCode").Value = lblSubName.Text dbSubjectCode.Fill(DsSubjectCode2) End Sub '*****General Procedures***** Private Sub DisplayRecordPosition() Dim intRecordCount As Integer Dim intRecordPosition As Integer intRecordCount = DsSubject1.Tables("Subjects").Rows.Count If intRecordCount = 0 Then lblSubName.Text = "(No records)" Else intRecordPosition = Me.BindingContext(DsSubject1, "Subjects").Position + 1 lblSubName.Text = "Record: " & intRecordPosition.ToString _ & " of " & intRecordCount.ToString End If End Sub End Class _____________________________________________________ Tag: TableAdapters and HasChanges Tag: 134808
  - 22
    - Oracle Hi, My app needs support for Oracle 10 g database : reading (select ...) + updating + calling stored procedures + distributed transactions eventually. I built it in VS 2005 (ado.net 2.0). What should I use ? Microsoft Oracle .NET Managed provider or Oracle Data Provider for .NET 2.0 ? I want to know the limitations of each one, tricky pbs, licensing. Microsoft did release a new Oracle.NET for .NET 2.0 ?? I found only the version 1.0 (http://www.microsoft.com/downloads/details.aspx?FamilyID=4f55d429-17dc-45ea-bfb3-076d1c052524&DisplayLang=en). Does anyone know if I can use promotable transactions (TransactionScope) when working with Oracle 10g ? Thanks for any advice Tag: TableAdapters and HasChanges Tag: 134805
  - 23
    - Re (by Cor): update DataSet - transaction I think you finally got me! This is an answer i was looking for. But it just feels like a walkaround instead a straight forward, 'by the book (MSDN)' stuff. It's hard to belive that Microsoft did not provide something simpler for a common functionality. Why introducing TableAdapters when transaction is not provided for them? Also i can hardy belive that TableAdapters do not have a base class (or interface) so it's making it hard to program generic solution for them. Oh, yeah, can you please provide code, that would be really heplful. Thanx! > However, I thuougth that I solved with casting the tableadapter again to a > dataadapter and than add the transaction to that. > > > Cor >> "TheMaxx" <themaxxREMOVE@net.hr> schreef in bericht >> news:ejciit$55$1@magcargo.vodatel.hr... >>>I have two tables in dataset, and appropriate TableAdapters. >>> >>> How can i update both tables, but in transaction? >>> >>> I other words: >>> >>> THIS: >>> MyDSTableAdapters.Table1TableAdapter a1 = new ... >>> MyDSTableAdapters.Table1TableAdapter a2 = new ... >>> >>> a1.Update(dt1); >>> a2.Update(dt2); >>> >>> but where to put transaction ? >>> >>> P.S. DataSet and TableAdapters are generated via VS 2005 form SQL 2000 >>> ServerExplorer drag n' drop >>> Tag: TableAdapters and HasChanges Tag: 134804
  - 24
    - Important Information Check out: www.Brandon-Lands.com Tag: TableAdapters and HasChanges Tag: 134791
  - 25
    - Datagridview image column nulls I've got a datagridview bound to Sql2k database. When the image columns return null, I get the goofy looking [X] in the column instead of a blank. Anyone know how to make that just appear as empty instead of the default [X]? I would also like that to appear as empty when I insert a new row instead of the [X] if that is possible. Tag: TableAdapters and HasChanges Tag: 134789

I am really confused about TableAdapters, Datasets in general. I have
added them to my Windows Form simply by dragging fields onto my form.
Now, when the user presses the Cancel button, and I want to determine
that something has changed, ie, If Me.MYDataSet.HasChanges = False,
then MsgBox("You Have Not Made Any Changes!"). Only problem is, if I
do make a change I get the same message. What should I be doing here?
I would prefer displaying a message indicating "No Changes Made"
versus a message saying "Add/Edit Changes have been Cancelled..." Help
me out here, and thanks for helping me thru my learning curve.

Top

Re: TableAdapters and HasChanges by Cor

Cor
Tue Nov 28 22:32:31 CST 2006

JJ,

I assume you have uses some kind of designers, open the code that is in the
designer part of your program, than you will see probably all those text.

Cor

"JJ" <NoEmailForMe...> schreef in bericht
news:lu0qm2tnf01v898e8ql4tq36tq17fppv0i@4ax.com...
>I am really confused about TableAdapters, Datasets in general. I have
> added them to my Windows Form simply by dragging fields onto my form.
> Now, when the user presses the Cancel button, and I want to determine
> that something has changed, ie, If Me.MYDataSet.HasChanges = False,
> then MsgBox("You Have Not Made Any Changes!"). Only problem is, if I
> do make a change I get the same message. What should I be doing here?
> I would prefer displaying a message indicating "No Changes Made"
> versus a message saying "Add/Edit Changes have been Cancelled..." Help
> me out here, and thanks for helping me thru my learning curve.

Top