Problem with a readonly table in a dataset (data source) in VS 200

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 designer in VS2005 Hi, I have two questions about the DataSet designer in Visual Studio 2005: 1. How can I make another TableAdapter under a DataTable which already has one? I'm sharing the DataSet with the DataTable between two applications, and they need separate TableAdapters... 2. I've created the DataTable with structure identical to the SQL Server table it is based on - can I easily update (not automatically, but from the designer) the DataTable to make the DataTable structure match the SQL Server table? (i.e. when a column is added or modified in the SQL Server table, I want to click a button in VS2005 so the same modification is done in the DataTable). Thanks! Regards, Nils Magnus Englund Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131974
  - 2
    - Newbie and 2005 Concurrecny Hi All, Hope you all fine? Can I ask you all a quick question? I`ve been trying to get concurrency to work for my project in VB2005. I have the following code, which to be fair i`ve got so lost with but here it is: Private Sub BTADSL_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.MasterDBDataSet.EnforceConstraints = False Me.M_BTAnalogueLinesTableAdapter.Fill(Me.MasterDBDataSet.M_BTAnalogueLines) Me.S_LocationsTableAdapter.Fill(Me.MasterDBDataSet.S_Locations) Me.M_BTADSLTableAdapter.Fill(Me.MasterDBDataSet.M_BTADSL) 'USERS M_BTADSLDataGridView.DataSource = MasterDBDataSet.M_BTADSL BTAnalougeLinesIDcomboBox.DataBindings.Add("TEXT", MasterDBDataSet.M_BTADSL.BTAnalougeLinesIDColumn, "TelephoneNumber") BTAnalougeLinesIDcomboBox.DataSource = MasterDBDataSet.M_BTADSL BTAnalougeLinesIDcomboBox.DisplayMember = "M_BTADSL.S_Locations.TelephoneNumber" BTAnalougeLinesIDcomboBox.ValueMember = "M_BTADSL.BTAnalougeLinesID" LocationsIDcomboBox.DataBindings.Add("TEXT", MasterDBDataSet.M_BTADSL.LocationsIDColumn, "Location") Dim cmBTADSL As CurrencyManager cmBTADSL = Me.BindingContext(MasterDBDataSet, "BTADSL") cmBTADSL = DirectCast(BindingContext(MasterDBDataSet.M_BTADSL), CurrencyManager) 'USER Im so confused with the concurrency thing i just don`t know where to go now. Could anybody have a look and tell me what a mess i`ve made and how to solve it? If poss maybe some links? Many Thanks A very Comfused Newbie Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131971
  - 3
    - SQL UPDATE for Dates ?? Hi folks, I have 2 code snippets. One works and one does not. This first hard-coded snippet works Dim queryString As String = "UPDATE [rfi] SET [dateresolved] = '8/16/2006' WHERE ([rfi].[id] = @id)" This second snippet does not work Dim dtNow As DateTime = DateTime.Now dRes = dtNow.ToShortDateString Dim queryString As String = "UPDATE [rfi] SET [dateresolved] = dRes WHERE ([rfi].[id] = @id)" dateresolved is a Date/Time data-type. The first snippet uses single quotes around the date but I would think the second snippet would be accepted as a string. If I debug the value of dRes, I receive the proper format of "8/16/2006" Any clues you can leave me with? Thanks, - Glenn Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131968
  - 4
    - Auto uncrement column Im am trying to create an auto increment column in a table. Where in the code below, should I make which changes in order to do that? Adrian /* dt.Columns.Add("Key", System.Type.GetType("System.Int32")); dt.Columns["Key"].AutoIncrement = true; dt.Columns["Key"].AutoIncrementSeed = 1; dt.Columns["Key"].AutoIncrementStep = 1; dt.PrimaryKey = new DataColumn[] { dt.Columns["Key"]}; */ DataColumn auto = dt.Columns.Add("Key", typeof(int)); dt.Columns["Key"].AutoIncrement = true; dt.Columns["Key"].AutoIncrementSeed = 1; dt.Columns["Key"].AutoIncrementStep = 1; //auto.AutoIncrement = true; //auto.AutoIncrementSeed = 0; //auto.AutoIncrementStep = 15; dt.PrimaryKey = new DataColumn[] {auto}; dt.Columns.Add("ForeName", System.Type.GetType("System.String")); dt.Columns.Add("LastName", System.Type.GetType("System.String")); dt.Columns.Add("TelephoneNumber", System.Type.GetType("System.String")); Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131966
  - 5
    - DataSet Designer/adding multiple tables to a dataset/ how? In the VS2005 DataSet Designer if i try to add multiple tables from an OLEDB database, i get an error: "Failed to add TableAdapter." "An item with the same key has already been added." What does this mean? How do i get around it? Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131963
  - 6
    - Changing ConnectionString programmatically Have the following situation: I have an old C++ application, which I have managed to compile with /clr to make it access .net functionality. For some of the new functionality I have decided to create a C# DLL, being a very neat and handy language. I have used wizards to create the dataset, extracting data to a grid from an SQLServer with stored procedures, all generated from wizards and life is fine. Except: The connection string that I have is of course "hard coded default", so that I could get the data in in the first place. The real life connection string that I want is something that I have read from another database in the main application (C++), which I now would like the C# DLL to use as well. This connection string also contains username and password set from a user login (using SQLServer authorisation). The C++ application, originally being unmanaged does not read an app.config file. The connection string is therefore not accessible through System.Configuration.Configuration. And the MyDLL.Properties.Settings.Default.myConnectionString is readonly, and might not change things anyway. Anyone, please? Or do I have to rewrite the whole db code? Ole Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131958
  - 7
    - what ado.net object to use problem I need to accomplish this tasks: 1. i need to query sql database 2. check if null, if not continue 3. check a certain column if null,if not continue 4. filter or split the data into two sets, these 2 will be the datasources of two gridview. i can use datareader to query sql database, check if its null (using datareader.hasrows), and check if certain column if null; however i cant use datareader to filter rows into 2 sets. To achieve this, datatable has select method or dataview has rowfilter method. Now how do i transfer data from datareader to datatable or dataset/dataview? As much as possible i want a single database query so the web app will be faster. Thanks. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131957
  - 8
    - Add money to your Paypal account with OPRAH r(;x3 Read this message until the end, and you will find out how the money flows in easy !!!!. Follow the steps and it WILL work. Trust me !!!!!. It's NOT illegal and it is NOT a scam !!!!!. PROVEN ON OPRAH! Reported in the Wall Street Journal!!!! The only thing you need is : - E-MAIL ACCOUNT - PREMIER (FREE) or BUSINESS PAYPAL ACCOUNT - $6 on this account (The only investment) - 30 minutes of your time There is no limit on how much money you can recieve, and you haven't got anything to lose with this Business program. I will explain how it works !!!!!. Follow these 4 easy steps and it WILL work !!!!!. STEP 1 : SIGN UP FOR A FREE PAYPAL ACCOUNT !!!!!. Paypal is a free and safe way to pay and receive money on the Internet. Creating a account is as easy as creating a MSN account. Copy and paste the next line in your Internet browser and sign up. HTTP://WWW.PAYPAL.COM Be sure to sign up for a FREE Premier or Business account and not for a Personal account. You cannot receive CREDITCARD payments with a Personal account and we can't have that. Do we !!!!!. STEP 2 : SENT $6 TO YOUR PAYPAL ACCOUNT This is your only investment to receive the money with ease. With your Paypal account, send $1 to each e-mailadres listed below. !!!!! IMPORTANT !!!!! Be sure to use this SUBJECT : *PLEASE PUT ME ON YOUR EMAIL LIST* when you send the money. 1) martine@pilote.net 2) dexxatol@netcourrier.com 3) armygirl8568@hotmail.com 4) comjii@starband.net 5) sinnek@bellsouth.net 6) nsi@nelasat.com STEP 3 : PUT YOUR E-MAIL ADDRESS ON THE BOTTOM OF THE LIST After you have send $1 to each e-mail address, put your e-mail address on the 6th place. Remove e-mail address number 1, and move each e-mail address 1 step up the ladder. !!!!! IMPORTANT !!!!! BE SURE THAT THE E-MAIL ADDRESS YOU USE IS THE SAME AS YOU USED TO SIGN UP AT PAYPAL. Remember that this is LEGAL. You are creating a service : an e-mail servicelist. STEP 4 : UPLOAD OR COPY THIS MESSAGE TO NEWSGROUPS, FORUMS ETC AND EMAIL IT TO ALL YOUR FRIENDS! There are 32,000 newsgroups. Upload or copy this message to at least 200 newsgroups or forums etc, but ........ remember that the more your upload the more people will see your message and the MORE MONEY WILL FLOW IN. How to upload to newsgroups and forums? : After you have followed step 1,2,3 and 4, save this message (and copy so you can use it again). Use your Internet browser and Outlook Express or another newsreader and try to find FORUMS, NEWSGROUPS, BULLETIN BOARDS, DISCUSSION GROUPS, CHAT SITES and ONLINE COMMUNITIES. Use GOOGLE or use a NEWSERVER. Use every option to post this message. Download PostXpert to send 1 message to more NEWSGROUPS at the same time. !!!!! REMEMBER !!!!! The more you post this message the more MONEY WILL FLOW IN. Why does this Business program work so well !!!!!. Lets asume that from the 200 (or more) messages that you have posted, only 5 people respond, you will have your $6 back that you have invested. Those 5 people will each send at least 200 messages with your e-mailadres on number 4. That's 6 x 6 x $1 = $36. The next 25 people will also send 200 messages with your adres on number 3. That's 36 x 6 x $1 = $216. The next 216 people also send 200 messages with your name on number 2. That's 216 x 6 x $1 = $1296!. Those 1296 people again also send 200 messages with your name on number 1. That will give us a total of 1296 x 6 x $1 = $7,776. Now the last tier! 7776 x 6 x $1 = $46,656!!!!!! This is only a EXAMPLE with 6 reactions. You WILL get MORE responses than that. Remember that most newsservers will leave the posted messages on there servers for about 2 weeks. If you will post your message again, it WILL again start from the beginning. So you can repeat this over and over again. Everyday MILLIONS of people are ONLINE and reading these messages, JUST LIKE YOU RIGHT NOW. I also was sceptical in the beginning and have read a lot of these messages. I also thought that it was bullshit. Until I thought : What the hell!, only $6. What's $6 and a couple of minutes of my time to solve my money problems. !!!!! REMEMBER !!!!! Follow every step, and IT WILL WORK, TRUST ME. !!!!! !!!!! BEST WISHES AND GOOD LUCK !!!!! w)O>+;)<9UVS;F>qaGL<Uq#v`V6(F]- rM;$g+!4IIQ*827?H4 Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131952
  - 9
    - SQL UPDATE with a DATE data-type Hi folks, I am doing an UPDATE to a table that has a field for a DATE data type. I am using MS Access. The UPDATE works fine but when I try to place the DATE field in the mix it blows up. The table name is rfi. Here's a code snippet... Dim dtNow As DateTime = DateTime.Now UPDATE [rfi] SET [dateresolved]=dtNow WHERE ([rfi].[id] = @id) It does not like dtNow, so I tried using dtNow.ToString ( ) which it also did not like. Next I changed the data-type for the dateresolved field from DATE to STRING and tried to put in dtNow.ToString ( ) which it still did not like. Finally, I hard coded a string in as "8/15/2006" which it accepted both as a DATE type and as a STRING type. Any ideas on what I may be missing would be appreciated. - Glenn Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131951
  - 10
    - Challenging ADO.NET situation (long) I've implemented a solution that I don't really think is very efficient, but I can't really think of a better way to do it. If anyone has any suggestions or citicisms, i'd be grateful to hear them. .NET 2.0/SQL 2000 (not 2005). I have two identical databases that need to be syncronized, seperated by the internet. I've implemented a web service on one server that will return a dataset containing all the currently "active" records. I then need to import (or update) those records into the local database. The records are structured in a simple master/detail format with multiple detail tables, depending on a "type" column in the master (ie some records will use one table for a detail, other records will use another). The complication is that a) I cannot change the schema. It's defined by an off the shelf application. b) Records can be added to either database independantly, but data is always transfered from remote to local, not the other way around. and c) because of b, i caanot depend on the primary key of the master being the same on both sides (an auto-increment identity value). All data besides the primary key should be copied (or updated) from the retrieved dataset to the local database. What i've done is identified some unique rows that I can use to create a secondary (though not "official") key. The database does not constrain these values to be unique, but the application is designed in such a way that it will not allow them to violate the uniqueness. The general flow is like this. I iterate over the master table, then lookup a row in the local database based on the unquie data. I then issue an insert if no records are returned, or an update if one is, tediously copying each field from the datarow to the SqlCommand.Parameters. I then check my local database for any "active" records that do not exist in the dataset returned by the remote host, because a record may have been "closed" between updates. If I find any records not in my remote dataset, I then have to issue a web service call to the remote host to return the single record for the closed record. I then update that record with the returned data ("closing" it). Then I walk through each of the detail tables, doing a lookup in a dictionary of remote:local record mappings that created while walking the master table and insert or update any records there. These records do not have to be updated if the master record has been "closed". This is generally a lot of work, and doesn't seem very efficient. If both databases were local (or even connectable directly via SQL) then I could use a DTS package to do a lot of this much easier (and do a lot more in SQL), but because I have to retrieve the data via a web service, it makes everything more difficult. The key points that I see as inefficient (and am looking for some thoughs on how to simplify) are: 1) Getting the data from my remote dataset to the new database. Manually (and tediously) copying the columns from a datarow to cmd parameters. I tried using two datasets and copying the datarow ItemArray values, but had all sorts of troubles with the dataadapter updates and insertions) 2) having to requery the remote database multiple times for each closed row. It would be more efficient if I could send a list of keys to the remote server and have it return all those rows. Any suggestions there? Any easy way to use something like an array of integers in a SQL parameter to return a list of items in a WHERE clause? I know i could do some stuff with cursors if I had to, but it doesn't seem like it should be that hard. 3) Any general thoughs on my algorithms or any suggestions for alternative ways of achieving this? I'm not married to a web service, but it seems the most efficient. I don't want to "push" changes from the remote server, i'd rather "pull". Thanks. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131949
  - 11
    - SQL2000 error: ... When connecting to SQL Server 2005 The complete error is : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Our db is SQL 2000 running on a Win 2003 cluster, where there is only one instance loaded. The client app is a Windows Service written in VS2005 that runs on a Windows 2000 server. We booted the cluster last night, now we're getting the above error in the service. Anybody else ran into this? Is the name of the default instance on a cluster MyServer\MSSQLSERVER ? Thanks Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131947
  - 12
    - Speed and memory usage of Dataset I will start by saying I am somewhat new to ADO.net, that said here goes. I have a dbase file with 450,000+ records, (400MB+ file size) I am loading only the UniqueID field into a DataSet and I have 2 problems. 1. It takes about 45 seconds to load 2. It is consuming about 400MB of RAM at that point. Is this kind of behaivor to be expected? Sample code: string connString = "Provider=VFPOLEDB.1;Data Source=c:\\btest\\"; connNav = new OleDbConnection(connString); connNav.Open(); dsNav = new DataSet(); daNav = new OleDbDataAdapter("select id from test", connNav); daNav.Fill(dsNav, "test"); <-- Takes about 45 seconds The ID field is numeric. There are about 220 other fields in the table (It was this way when I started here). Any help would be appriciated. Doug Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131946
  - 13
    - Multi-step OLE DB operation generated errors I'm getting the dreaded "Multi-step OLE DB operation generated errors" exception when trying to connect to a local Access 97 database. My program connects fine when run on other machines, but on one computer it's giving me problems and I can't figure out why. Everything on this computer is identical to the ones that work (with respect to my program, such as file locations, connection string, etc.). The stack trace looks like this: Error at: System.Data.OleDb.OleDbConnection.Open Error at: System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) Error at: System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) Error at: System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) Has anyone experienced something like this before? I'm guessing it's a problem with system files? Any suggestions? - Don Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131944
  - 14
    - Please Help! "Relation Relation1 cannot be merged, because keys have mismatch columns." "Relation Relation1 cannot be merged, because keys have mismatch columns." I get that error when I try to merge two datasets. Both datasets have a Relation named "Relation1". It is refering to the parent key, child key? How can i figure out which columns are messed up? Thank You! Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131943
  - 15
    - Please Help! "Relation Relation1 cannot be merged, because keys have mismatch columns." "Relation Relation1 cannot be merged, because keys have mismatch columns." I get that error when I try to merge two datasets. Both datasets have a Relation named "Relation1". It is refering to the parent key, child key? How can i figure out which columns are messed up? Thank You! Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131942
  - 16
    - Read XML and transform result table Hi, I have the following scenario: 1. I have an application which includes a database with a DataMain table. I have a Strong Typed DataSet (MyDB)having the DataMain typed DataTable in it. 2. I have an external xml with constant fields. i've created a xsd and a typed DataSet (Products) from it as well, containing a typed DataTable named Product. What I have to do is: a. ReadXML into the Product Typed table Here is what I don't know how to do: b. Transform the Products.Product to a MyDB.DataMain so that I can persists its data do the DB (transform one DataTable into another). c. Or somehow read the xml straight into the DataMain.DataTable. the DataMain.DataTable and the Products.Product have different column names (ID = ProductID, Name = ProductName...) etc. In adition I have a field in one of the tables which type is decimal whereas what i get from the XML is long (I need to calculate a decimal value from the long by dividing by 1000000) I guess I should search for columnMapping or XSLT info but I got lost, I would appreciate some help. -- Albert Benatov Skype: abentov http://albertbenatov.com Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200608/1 Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131940
  - 17
    - Timestamps, SQLServer, VS2005, ADO datasets and concurrency checking I'm using timestamps for concurrency checking when updating SQLServer from a modified dataset. After each insert or update, the new timestamp value is needed for a subsequent update. If the timestamp is treated as a timestamp, the original concurrency check works but each subsequent update fails. Here are the statements that don't work: SELECT NetMemberID, LoginName, FriendlyName, ApprovalStatus, MD5Password, TS FROM dbo.NetMember DELETE FROM [dbo].[NetMember] WHERE ([NetMemberID] = @Original_NetMemberID) AND (TS = @Original_TS) INSERT INTO [dbo].[NetMember] ([LoginName], [FriendlyName], [ApprovalStatus], [MD5Password]) VALUES (@LoginName, @FriendlyName, @ApprovalStatus, @MD5Password); SELECT NetMemberID, TS FROM NetMember WHERE (NetMemberID = SCOPE_IDENTITY()) UPDATE [dbo].[NetMember] SET [LoginName] = @LoginName, [FriendlyName] = @FriendlyName, [ApprovalStatus] = @ApprovalStatus, [MD5Password] = @MD5Password WHERE ([NetMemberID] = @Original_NetMemberID) AND (TS = @Original_TS);SELECT TS FROM NetMember WHERE (NetMemberID = @NetMemberID) Here are the statements that do work if the timestamp is cast as an integer: SELECT NetMemberID, LoginName, FriendlyName, ApprovalStatus, MD5Password, CAST(TS AS INT) AS TS FROM dbo.NetMember DELETE FROM [dbo].[NetMember] WHERE ([NetMemberID] = @Original_NetMemberID) AND (CAST(TS AS INT) = @Original_TS) INSERT INTO [dbo].[NetMember] ([LoginName], [FriendlyName], [ApprovalStatus], [MD5Password]) VALUES (@LoginName, @FriendlyName, @ApprovalStatus, @MD5Password); SELECT NetMemberID, CAST(TS AS INT) AS TS FROM NetMember WHERE (NetMemberID = SCOPE_IDENTITY()) UPDATE [dbo].[NetMember] SET [LoginName] = @LoginName, [FriendlyName] = @FriendlyName, [ApprovalStatus] = @ApprovalStatus, [MD5Password] = @MD5Password WHERE ([NetMemberID] = @Original_NetMemberID) AND (CAST(TS AS INT) = @Original_TS);SELECT CAST(TS AS INT) AS TS FROM NetMember WHERE (NetMemberID = @NetMemberID) Any thoughts on how to use timestamps without having to cast them as integers. Thanks Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131938
  - 18
    - Failed to enable constraints but please tell me sth. Hello. I'm know, there is tones of pages in google, etc. about problem: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I'v read a lot, but this solutions doesn't resolve my problem. I'm using Strongly typed datasets, and ObjectDataSources. And I can't operate with DataSet property EnforceConstrains. Lets look at my tables. I have 2 tables pools ------------ pools_id (PK, int, autoinc) pools_title (varchar(50) pools_questions ------------ pools_questions_id (PK, int, autoinc) pools_id (FK, not null) pools_questions_question (varchar(50)) pools_questions_votes (int, not null) Everything is ok, when my data looks like this: pools ------------ 1, "Title one" pools_questions ------------ 1, 1, "Yes", 3 but when i have 2 or more rows with the same value in: pools_questions.pools_id for example: pools_questions ------------ 1, 1, "Yes", 3 2, 1, "No", 10 3, 1, "Other", 4 4, 1, "Some", 5 then that data configuration throws error. When I'v designed my tables with SQL Server Management Studio Express, I setup relationship with property Enforce Foreing Key Constarints: True, and False - this doesnt work for me. Please somebody help me with this problem. Thanks in advance. Darek Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131935
  - 19
    - Loop Through a Folder of Excel Workbooks in VB.NET Hi, Can anyone tell me how to Loop Through a Folder of Excel Workbooks using VB.Net? I have a folder with Excel files. Each spreadsheet has multiple worksheets. I need to read each worksheet and get the data and transfer that data to a database table. I am not sure how to loop through Excel workbooks and get the worksheet name. I would appreciate any help with this. Thank you. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131927
  - 20
    - PARAMETERS/value in SQL, how to set? I would like to use access (for testing, then ASP.NET) to execute a query which uses another query where a value must be set like ID = 2 or so. How can i do that? Here is my example, i created Table2 with an ID field and a name field (totally useless but it's they idea what matters). Query2 is a total: SELECT Count(Table2.ID) As T FROM Table2 WHERE ID = ? Now i want QUERY1 to select it and fill ? Select * FROM QUERY2 WHERE ? = 1 Of course the WHERE ? part will not work. Please don't point me to parameters stuff in ado.net, i'm aware of those it the matter of preparing selects IN selects. Thanks, Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131926
  - 21
    - Locking Datatable / Data Row Hello, if you have defined a DataSet in the HttpApplicationState which is shared by all current users ... what I have to do, to make the Dataset, DataTables and DataRows thread-safe? Following my assumptions: 1) If I change a Row: lock (datarow) { datarow["xy"] = value; } 2) If I add Rows lock (datatable) { datatable.Rows.Add(..) } 3) If I use the Fill method lock (datatable) { adpt.Fill(datatable); // what happens with changed or currently locked datarows? // e.g: process 1 locks row X of datatable A thread 2 wants to lock datatable A, is process 2 waiting for process 1 to unlock row A } 4) If I make AcceptChanges to DataTable or DataRow lock (datatable) { datatable.AcceptChanges(); } 5) For datatable.Remove (lock datatable) 6) For datarow.Delete() (lock datarow) 7) For dataset.Tables.Add() (lock dataset) 8) If I do a datatable.select(...) what a have to do to make it thread-safe? Is this correct or completly wrong? in your applicatoin writes on rows can only be done by one user at the same time, reading should be possible for all users "at the same time". Maybe yo have some answers... Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131921
  - 22
    - Problems using SqlConnection When my application uses OleDb-provider like... Private Sub TryOleDbConnection() Try Dim i As Integer Using cn As OleDbConnection = New OleDbConnection() cn.ConnectionString = "Provider=sqloledb;MYSERVERNAME\MYINSTANCE;Password=xxx;User ID=sa;Initial Catalog=MYDBNAME" Using cm As OleDbCommand = New OleDbCommand() cm.Connection = cn cm.CommandText = "SELECT COUNT(*) AS X FROM MYTABLE" cn.Open() i = CType(cm.ExecuteScalar, Integer) cn.Close() End Using End Using MessageBox.Show(String.Format("answer={0}", i)) Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub ...It's working fine. BUT when my application uses Sql-provider similar way like... Private Sub TrySqlConnection() Try Dim i As Integer Using cn As SqlConnection = New SqlConnection() cn.ConnectionString = "Data Source=MYSERVERNAME\MYINSTANCE;password=XXX;User ID=sa;Initial Catalog=MYDBNAME;" Using cm As SqlCommand = New SqlCommand() cm.Connection = cn cm.CommandText = "SELECT COUNT(*) AS X FROM MYTABLE" cn.Open() i = CType(cm.ExecuteScalar, Integer) cn.Close() End Using End Using MessageBox.Show(String.Format("answer={0}", i)) Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub cn.Close()-line fails with Error Message: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" Database is SQL Server 2005 Express running on other (WinXP Pro UK + SP2 + latest updates) computer. I think some setting(s) is incorrect in SQL Server settings, but what might it be? I can't connect this database on other computer using Microsoft SQL Server Management Studio Express of my (client) computer using Sql Server authentication with user name and password. Using Microsoft SQL Server Management Studio Express from localhost where the database is is working fine. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131913
  - 23
    - OleDB Stored Procedure returns Data Rows I'm trying to Exceute a Stored Procedure with OleDB in C# I've looked all over the net and can't seem to find how to do it and have had minimal sucess: here is the sniplet of code i'm using: #region Create TieWindow DataSet DataSet dsTieWindow = new DataSet(); DataTable tieWindowTable = new DataTable(); tieWindowTable.TableName = "TieWindow"; tieWindowTable.Columns.Add("TieIndex"); tieWindowTable.Columns.Add("ReferenceEntity"); tieWindowTable.Columns.Add("ContainerName"); tieWindowTable.Columns.Add("TieName"); tieWindowTable.Columns.Add("StartTime"); //...... keep adding columns, etc #endregion OleDbDataAdapter adapter = new OleDbDataAdapter(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; //OleDB Parameter Objects to be used for all database modification #region Create OleDb Parameters OleDbParameter oMWin = new OleDbParameter("MWin", OleDbType.Double, 8, "MWin"); OleDbParameter oMWout = new OleDbParameter("MWout", OleDbType.Double, 8, "MWout"); OleDbParameter oStopTime = new OleDbParameter("StopTime", OleDbType.Date, 8, "StopTime"); OleDbParameter oStartTime = new OleDbParameter("StartTime", OleDbType.Date, 8, "StartTime"); OleDbParameter oInterfaceType = new OleDbParameter("InterfaceType", OleDbType.Integer, 4, "InterfaceType"); OleDbParameter oImportIntoSched = new OleDbParameter("ImportIntoSched ", OleDbType.Integer, 4, "ImportIntoSched"); ///....paramter, paramater, etc #endregion cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "beta_operational.dbo.WS_tie_get_tie_window '" + lowerBoundDate + "', '" + upperBoundDate + "','" + "PNM" + "', 0"; cmd.Parameters.Clear(); cmd.Parameters.Add(oTieIndex); cmd.Parameters.Add(oReferenceEntity); cmd.Parameters.Add(oContainerName); cmd.Parameters.Add(oTieName); cmd.Parameters.Add(oStartTime); cmd.Parameters.Add(oStopTime); //....paramter, parameter, etc dsTieWindow.Tables.Add("TieWindow"); adapter.SelectCommand = cmd; adapter.Fill(dsTieWindow); =============================================== The Error I get is this: OleDb Connection Error:System.Data.OleDb.OleDbException: Syntax error or access violation at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at.... What am i doing wrong? Thanks in advance. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131908
  - 24
    - change the database password (Access) ok, ya got me, how do I change the database password via code? Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131907
  - 25
    - Retrieving schema for a stored procedure. I am able to retrieve the schema for a set of stored procedures by running each of the stored procedures and then calling GetSchemaTable but I don't want to run the stored procedure if it is going to modify the database. How can I get the output schema for a stored procedure either without having to execute the stored procedure or changing each stored procedure so that the INSERT, UPDATE, DELETE, etc. doesn't happen (but the schema is still returned). Thank you for your suggestions. Kevin Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131900
- Next
  - 1
    - refresh from DataGridView to bound DataSet I can easily programmatically add a new row to a DataSet, fill the columns with the appropriate data and the new row is in the corresponding DataGridView is conveniently updated when the DataSet changes. Is there any way to do this in the other direction? That is, if the DateGridView is enabled to allow the user to add new rows by typing in the grid, is there some way to "push" this data back to the bound DataSet so that it stays in sync with the DataGridView. It doesn't appear to update the underlying database table when I do an Update on the data adapter. roy Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131889
  - 2
    - Retrieving primary key of newly added record Hi all. I have three burning ado.net questions about using the DataAdapter.Update technique of updating data (rather than calling a stored proc explicty). I can't figure them out and I'm hoping it won't be too hard for some of you ado.net gurus out there! 1. Getting the PK of a new record Using the dataset.Update method to add a new row, how can I get the primary key of the record I just added (assuming that table's primary key field is an identity/autonumber one in SQL Server - that is SQL Server automatically generates one for the next record) without doing another explicit query of SELECT Max(PK_Field) FROM TABLE query. I'm worried that if I do another explicit query, I am open to the possibility of another Insert getting in inbetween the time I added the record and checked for the maxid. I know that is not too likely, but I would really like to eliminate the possibility all together as the project scales. I want to do something like this.. DataAdapter.Update(this.DataSet.Tables[0]); (this is the new table) this.DataSet.Tables[0].AcceptChanges(); newPrimaryKey = this.DataSet.Tables[0].Rows[0][PK FIELD NAME]; I'm curious about this under a. The scenario where the dataadapter.InsertCommand is simply a dynamic sql string, "INSERT INTO MY TABLE..." where the dynamic sql was derived using the CommandBuilder object: DataAdapter.SelectCommand = new SelectCommand("SELECT * FROM Orders WHERE Order_Id = -1",CN); CommandBuilder cb = new commandBuilder(); DataAdapter.InsertCommand = cb.GetInsertCommand(); b. The scenario where it is a stored procedure. 2. Adding a new record with one round trip To add a new row with dataadapter.update, I've been in the habit of first selecting a row from a table but setting the where clause to a condition I know will not be met, so I get back an empty row, so that I can have the table information needed to create the new row. This does cause a roundtrip however. DataAdapter.SelectCommand = new SelectCommand("SELECT * FROM Orders WHERE Order_Id = -1",CN); CommandBuilder cb = new commandBuilder(); DataAdapter.InsertCommand = cb.GetInsertCommand(); DataAdapter.Fill(myDataset,"Orders"); DataRow dr= myDataset.Tables[0].NewRow; dr["Amount"] = 12.34; dr['whatever"] = "x"; myDataset.Tables[0].Rows.Add(dr); DataAdapter.Update(myDataset.Tables[0]); myDataset.Tables[0]).AcceptChanges(); The 2 round trips needed for this is nothing fatal I guess, but I'd like to avoid it if possible, without having to completely manually construct the new DataRow (ie add columns to it in code, setting (in a hard-coded way) the types, lengths, names, etc of each of them). Does anyone know of a better way? finally... 3. Handling concurrency with stored procs. So I love the way that when you do DataAdapter.Update(ds), the dataadapter automatically handles concurrency issues. By concurrency issues, I mean: Person A loads rowX Person B loads rowX Person A saves his changes (with dataadapter.update) Person B saves his chnages (with dataadapter.update) rather than Person B overwriting Person A's changes, a concurrency error will be thrown. I think SQL is generated for the DataAdapter.UpdateCommand that checks to see that all the values of the fields are the same as when the object was originally loaded by this person (UPDATE TableX where PK=1 AND value1=origvalue, value2=origvalue, etc). My question is, if I do this DataAdapter.UpdateCommand = new command("MyCustomStoredProc"); have I lost this cool feature? Is there any way I can get it back? I know that was a lot. Thanks so much in advance to anyone that can help me out. Your help is greatly appreciated!! Regards, Jeff Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131887
  - 3
    - newbie - simple Master/Details question Hi all, I am a bit of "noob" when it comes to using c#.NET datagrids, and always look at them in terms of what i could have done in VB6. I have been reading around, and understand the ideas and logic of DataSets, DataRelations, and DataTables. I understand how to populate a dataset, datatable, grid etc, and have even got as displaying a combobox in cell of the datagrid. However, I do not understand how to make relationships between multiple tables appear as I want them on the screen. For example, the following code I have used to populate data into a dataset, and establish the relationships between the data tables. This works fine, no problems: sqlAdap=new SqlDataAdapter(strSearch,sqlConn); SqlDataAdapter sqlAdap2 = new SqlDataAdapter("SELECT * FROM T_Recycle_Consignment_Detail",sqlConn); ds = new DataSet(); sqlAdap.Fill(ds,"T_Recycle_Consignment_Header"); sqlAdap2.Fill(ds,"T_Recycle_Consignment_Detail"); DataRelation Tran_Detail = new DataRelation("Items", ds.Tables[0].Columns["F_Consignment_ID"], ds.Tables[1].Columns["F_Consignment_ID"]); ds.Relations.Add(Tran_Detail); Where I am stuck, is that when I click on the "+" sign on the datagrid, I first get a link to DataRelation name "Items", which when I click it, it removes the parent grid, and just displays the child record(s). Basically what I am after is the MSHFlexGrid from VB6, which my users have always found really easy to use, and to understand. Can anyone shed any light on this problem, or refer me any sites that explain this? Many thanks, James. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131880
  - 4
    - creating a folder Hi , when we accessing some application from the server then a folder has to create on the client system . When accessing the application from server the folder has to created on the client system at any where. Any solution. Thanks in advance. Regards, Kamal. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131861
  - 5
    - How to supress deleting a Row Hello I have a DataGrid that a is bound to a DataTable. Some of the rows in the DataTable should not be deleted. How can I prohibit deleting of some identified rows? The problem could be specified in the following format too: There is a DataView object that I want to prohibit deleting of some of its DataRowView objects. that is: when drv.Delete() is called (drv is the identified DataRowView) it doesn't delete the DataRowView object (suppress that the Deleted tag is assigned to the RowState) . How can I do this job? Regards Hamed Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131858
  - 6
    - DBnull in dataTable.Columns.Add() Re the code line: dataTable.Columns.Add("columnName",System.Type.GetType("System.[whatever]")) ; (I am working in c#) Can one add that null is / is not allowed? And, if so. what is the syntax? Adrian. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131855
  - 7
    - HowTo: Updating Data in tables with an 1:n Relation Hi, I have a problem updating data in two tables which are related to each other. The parent table is called "Owners" and each owner can have multiple animals, standing in a table "Animals". "Owners" has a column "ID", which is it's primary key. In "Animals" there is a column "owner" wich is the foreign key. Now I want to add some owners and animals to the database and update the tables with those new values, but this doesn't seem to work, because I am doing something wrong, but I cannot figure out my mistake. Here's a bit of code: MyDataSet.OwnersRow newOwner = MyDataSet.Owners.NewOwnersRow(); MyDataSet.AnimalsRow newAnimal = MyDataSet.Animals.NewAnimalsRow(); // filling the columns with data and add a new Row- works fine newOwner.fname = customer.firstname; newOwner.lname = customer.name; newOwner.phone_home = customer.phone; MyDataSet.Owners.Rows.Add(newOwner); // now I want to add an animal to the customer newAnimal.name = animal.name; newAnimal.age = animal.age; MyDataSetAnimals.Rows.Add(newAnimal); // Getting the updated values and write them to DB MyDataSet.OwnersDataTable rowToadd = (MyDataSet.OwnersDataTable)MyDataSet.Owners.GetChanges(DataRowState.Added); MyDataSet.AnimalsDataTable rowToadd1 = (MyDataSet.AnimalsDataTable)MyDataSet.Animals.GetChanges(DataRowState.Added); OwnersTableAdapter.Update(rowToadd); AnimalsTableAdapter.Update(rowToadd1); This doesn't work. I always get an exception, where it says the "owner" column in the animals data table must not be DBNull. If I include a DataRelation object in my code, connecting the columns explicitly in the manner as described above, a different exception is thrown, where it says a DataRelation like that was already there. That is true, because the relation was defined in the SQL Server istself and is known to my DataSet. The next thing I tried was setting the value for the owner column in "Animals" myself, like this: // filling the columns with data and add a new Row- works fine newOwner.fname = customer.firstname; newOwner.lname = customer.name; newOwner.phone_home = customer.phone; MyDataSet.Owners.Rows.Add(newOwner); // now I want to add an animal to the customer newAnimal.name = animal.name; newAnimal.age = animal.age; newAnimal.owner = newOwner.ID; MyDataSetAnimals.Rows.Add(newAnimal); Now an exception was thrown when trying to write the data back into the SQL Server, stating there was something wrong with the foreign key. So where's my fault? How can I update my database with two related tables, using the correct foreign keys etc.? Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131844
  - 8
    - ORA-12154 connecting to Oracle XE database I have Oracle XE installed on my workstation, which is running Windows XP Professional x64. I can connect to the database through the Oracle interface or through Toad, but I cannot connect to it through Visual Studio 2005. In a new project, I add the reference to Oracle.DataAccess. When I try to add a new datasource, i select Oracle Database(OracleClient) as the datasoure, set the server name to XE, enter the user and password, then click the test connection button. The result is the ORA-12154 error, TNS could not resolve the connec identifier specified. The problem may have to do with the WinXP x64 operating system, as I don't have the same problem on a system with just WinXP. Any ideas on how to resolve this problem? thanks Dan -- dchman Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131842
  - 9
    - Cannot pass NULL to SelectParameters? Hi, I just cannot manage to perform a SELECT query with NULL parameter... My TCATEGORY table does have one row where TCATEGORYPARENTID is null (real DB null value). TCATEGORYID and TCATEGORYPARENTID are uniqueidentifier columns. My questions: - is Type="Object", below, necessary? - what shall I specify for DefaultValue in my function? I tried everything. How come the DefaultValue must be a string? Why can't I specify DBNull.Value? - How do I make this work... do I have to maintain two different SqlDataSources, one with TPARENTCATEGORYID IS NULL in the select statement, the other one with a parameter? Please let me know if this is what I have got to do. Thanks for your help. -J Code follows: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyBaseConnectionString %>" SelectCommand="SELECT [TCATEGORYID], [[TCATEGORYNAME] FROM [TCATEGORY] WHERE ([TCATEGORYPARENTID] = @TCATEGORYPARENTID) ORDER BY [TCATEGORYPARENTID], [TCATEGORYNAME]"> <SelectParameters> <asp:Parameter Name="TCATEGORYPARENTID" Type="Object" /> </SelectParameters> </asp:SqlDataSource> private void QueryCategory() { SqlDataSource1.SelectParameters["TCATEGORYPARENTID"].DefaultValue = System.Data.SqlTypes.SqlGuid.Null.ToString(); DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); if (dv != null) // I always end up with either dv null or dv.Table.Rows.Count = 0 :-( { foreach (DataRow row in dv.Table.Rows) { [...] } } } Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131835
  - 10
    - Oracle ODP.NET stored procedure help needed (PLEASE) I am using asp.net 2.0 and the latest 10.x odp.net driver to execute an update stored procedure in Oracle 9.x. I have been getting the following intermittent error ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1 It seems to run sometimes and not other times. I have been thinking it was related to my date parameters but I am really not sure. I found a post recently that mentioned setting the date format after the connection is opened (see following).... Dim dateformatvar As String = "MM/dd/yyyy HH:MI:ss AM" Dim threadGlob As OracleGlobalization = OracleGlobalization.GetThreadInfo() threadGlob.DateFormat = dateformatvar Dim Param19 As New OracleParameter("i_MODIFIED", OracleDbType.Date, ParameterDirection.Input) Param19.Value = DateTime.Parse(NewDateModified.ToString("M/d/yyyy h:mm tt")) the above is an example of how i am passing in dates. As mentioned I am not sure if this is the source of my error. It seems that the sproc will run fine once, but minutes later it will error out with the 6502 oracle error. I have searched online but am at a loss at this point. Any help or advice dealing with odp.net and executing procedures with parameters would be very much appreciated. I have ensured I am passing in the correct type and order of the parameters. thx dave Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131832
  - 11
    - Using queries in a table adaptor? I have a data set called â??ProductDataSet.xsdâ?? that include several tables one called [Drive Packages] with 14 columns and several rows of data. The table adaptor attached to this is a table adapter called â??Drive Package TableAdapterâ??. To this table adapter I have added several queries: One called list Data SELECT [Drive Package ID], [Drive Nomenclature] AS Drive, [HP Max] AS HP, [RPM Max] AS [Max RPM], [RPM Min] AS [Min RPM] FROM [Drive Package] WHERE ([Product Line ID] = ProductLineID) AND ([Unit Size] = UnitSize) ORDER BY [Drive Nomenclature] The two procedures are called FillListData and GetByListdata When I excite the following statement DataTable ListData = this.drive_PackageTableAdapter.GetListData(ProductLineID, UnitSize); The columns I have aliased above are now where to be seen. For this quarry I did not need them explicitly because I bound them to a C1 flex grid. Although, I did have to make five columns in the right order and names. Note I the correct amount of rows for the where clause. The second one Max Mins SELECT MAX([HP Max]) AS MaxHPMax, MIN([RPM Min]) AS MinRPMMin, MAX([RPM Max]) AS MaxRPMMax FROM [Drive Package] WHERE (([Product Line ID] = ProductLineID) AND ([Unit Size] = UnitSize)); The two procedures are called FillMaxMins and GetMaxMins. Again exciting DataTable dataMaxMins = this.drive_PackageTableAdapter.GetMaxMins(2, "086"); The aliases are no where to be seen. This one returns only one record and it did. So I tried: object[] MaxMins = new object[3]; MaxMins = this.drive_PackageTableAdapter.GetMaxMins(2, "086").Rows[0].ItemArray; And I can see the data I want but it is tacken on the end of an array of 14 items. One for each column in the orignal table and the there ones above. The question is how do I get the coliums in the quary and only the colums in the quary? These are not complacte quaries and if I can not use the dataset for these what good is it. -- Mike Reed Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131824
  - 12
    - Executing query with group by and aggregate on a dataset i have a dataset which pull all the info into a table , now i want to use queries based on that table. as an example in the following query it has both aggregate and group by . is there a way i can execute such a statement on the dataset and retrieve data. if sample code is given will appreciate. i just need to retrieve data from datatable any method will do either datatable or data row whatever as long as it work.... Here is one of my queries: SELECT off_the_button as position, COUNT(off_the_button) AS total_hands, SUM(total_bet) AS vol_money_in_pot, 100 * SUM(cold_call_pf) / COUNT(off_the_button) AS cold_call_pf_pct, SUM(won_hand) AS num_won, 100 * SUM(won_hand) / COUNT(off_the_button) as win_pct, SUM(saw_flop_n) AS saw_flop_n, 100 * SUM(won_hand) / COUNT(saw_flop_n) as win_pct_wsf, SUM(blind_amt) AS blind_money, SUM(total_won) AS money_won, SUM(total_won) - SUM(blind_amt) AS diff_wo_blind$, 100 * SUM(went_to_showdown_n) / COUNT(off_the_button) AS went2sd_pct, 100 * SUM(pre_flop_raise_n) / COUNT(off_the_button) AS raise_pf_pct, 100 * SUM(raised_first_pf) / COUNT(off_the_button) AS raise1st_pf_pct FROM game_players WHERE player_id = 1 GROUP BY off_the_button thanks, dotnetcoder Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131821
  - 13
    - ContextSwitchDeadlock was detected Folks, I am connecting to an Oracle 8.1.7.4.1 database and executing a stored procedure, Change_Results. The code works great but soon after my VB2005 app starts, I get this message: ContextSwitchDeadlock was detected. Message: The CLR has been unable to transition from COM context 0x190110 to COM context 0x190260 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations. Following is my code. As I said, it works perfectly. I just do not know what in the ham sandwich I am supposed to do about this warning. Public Function Change_Result(ByVal RsltID As String, _ ByVal New_Value As String, _ ByVal Stat As Long, _ ByVal Change_Reason As String, _ ByVal Rslt_Origin As String) As Long Change_Result = -1 Try Using cnLims As New OracleConnection cnLims.ConnectionString = GetLimsConnectString() _ & "User ID=" & Form1.txtUserID.Text _ & ";Password=" & Form1.txtPassword.Text cnLims.Open() Dim command As OracleCommand = cnLims.CreateCommand() command.CommandText = "NAIP_Result_API.Change_Result" command.CommandType = CommandType.StoredProcedure command.Parameters.Add(New OracleParameter("Rslt_Id", OracleType.Number)).Value = RsltID command.Parameters("Rslt_ID").Direction = ParameterDirection.Input command.Parameters.Add(New OracleParameter("New_Value", OracleType.VarChar)).Value = New_Value command.Parameters("New_Value").Direction = ParameterDirection.Input command.Parameters.Add(New OracleParameter("Stat", OracleType.Number)).Value = Stat command.Parameters("Stat").Direction = ParameterDirection.InputOutput command.Parameters.Add(New OracleParameter("Change_Reason", OracleType.VarChar)).Value = Change_Reason command.Parameters("Change_Reason").Direction = ParameterDirection.Input command.Parameters.Add(New OracleParameter("Rslt_Origin", OracleType.VarChar)).Value = Rslt_Origin command.Parameters("Rslt_Origin").Direction = ParameterDirection.Input command.ExecuteNonQuery() Change_Result = command.Parameters("Stat").Value command.Dispose() End Using My.Application.Log.WriteEntry("NAIP_Result_API.Change_Result Return Status: " & Change_Result & " (0 = SUCCESS)" & vbCrLf) Catch ex As OracleException Throw ex Catch ex As Exception Throw ex End Try Return Change_Result End Function Thanks, Vint Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131820
  - 14
    - Using Strongly Typed Datasets I am interested in using strong typed datasets, but I am having some difficulty with some things and was hoping for a little clarification. I am using VS 2005 (.net 2) and I start off by creating a Dataset to my project called MyDataset.xsd. In my Dataset I added a TableAdapter called Products, which resulted in the creation of a TableAdapter named ProductsTableAdapter and a DataTable named Products. So far so good. What I thought strongly typed datasets would allow me to do is write code like this.... MyDataset mds = new MyDataset(); mds.ProductsTableAdapter.Fill(mds.Products); or even better yet... MyDataset mds = new MyDataset(); mds.Products.GetData(); Textbox1.Text = mds.Products.Rows[1]["ProductName"]; And if I add another query to the DataAdapter such as "FillByProductID,GetDataByProductID (@ProductID)" then I could say something like... MyDataset mds = new MyDataset(); mds.Products.GetDataByProductID(someInt); Textbox1.Text = mds.Products.Rows[1]["ProductName"]; Now I know the methods I am invoking are TableAdapter methods and not DataTable methods. However, what the DataSet Designer seems to be doing is "binding" the TableAdapter to the DataTable. It seems like that coupling of the TableAdapter with the DataTable should abstract the TableAdapter and make it so you can get at the data via the DataTable directly without having to also worry about the TableAdapter. Instead I find I have to use very cumbersome code, and not at all intuitive, to get at my data in the MyDataset. using MyDatasetTableAdapters; // <== THIS TOOK A WHILE TO FIGURE OUT <snip> ProductsTableAdapter pta = new ProductsTableAdapter(); DataTable mydt = pta.GetData(); Textbox1.Text = mydt.Rows[1]["ProductName"].ToString(); // <== STRONGLY TYPED??? So what am I doing wrong? Is there a way to do what I want to do and I am just going about it all wrong? Or are Visual Studio Datasets just a waste of time? Because the data doesn't seem strongly typed if I have to access via the TableAdapter. What am I missing here? Regards. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131816
  - 15
    - DataBind() Causes Connection Pool to overflow? Hello all. I have been debugging with a Connection pool overflow issue, and I'm seeing something very unusual. Using performance monitor, I am tracking the number of Current Pooled Connections. The number stays fairly low as I connect to the database, execute my query, and fill my DataTable. However, once I evoke DataBind() for my datagrid, the number of pooled connections shoots up an amount equal to the number of rows in the grid! So, in my case I'm showing 20 rows, so 20 additional connections get used in the pool. I'm at a real loss to understand this one. Why would DataBinding use connections at all if I already have a filled DataTable? Thanks in advance for your insights/opinions/etc. DW Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131810
  - 16
    - Cannot remove Unique key from Typed DataTable. For some strange reason, which has the hairs of a bug. I created a new column on a DataTable which I first had placed in my dataset from the server explorer table. After I finished I realized that unknowingly I had added a unique key with it (maybe a UI problem in .NET) So I took out the key. Now even when the unique key is nowwhere to be found in my proyect I get a "Column 'EDP_BLOCKED_STAYS' is constrained to be unique. Value '4' is already present." error when trying to add the record to my datatable. I did a find in files on the entire project for my new column "EDP_BLOCKED_STAYS" and I did not find any references to it being a Key plus it's not indicated visually either. And when I did the same looking for "Constraint" I found all the unique keys I expected to see. I include my find results just in case; note that EVENT_DAY_PLANNING is the table that has the new "unique" column. The only thing special about my project is that the DataSet is in a Library Proyect. And all other DB acceses throught that same DataSet are working. Find all "Constraint", Subfolders, Find Results 1, "Current Project" <xs:unique name="Constraint1" msdata:PrimaryKey="true"> <xs:unique name="EVENT_DAY_PLANNING_Constraint1" msdata:ConstraintName="Constraint1"> <xs:unique name="LOCATION_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> Me.EnforceConstraints = ds.EnforceConstraints Me.EnforceConstraints = ds.EnforceConstraints Me.EnforceConstraints = true Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnEVE_RID}, true)) Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnEDP_EVE_RID, Me.columnEDP_DAY}, false)) Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnLOC_RID}, true)) Matching lines: 9 Matching files: 2 Total files searched: 14 Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131808
  - 17
    - The ConnectionString property has not been initialized. My debugger is saying that the ConnectionString property has not been initialized. when I try to open the connection. My goal is to loop through an arraylist of objects (OrderModel) and insert a record each time. What am I missing here? using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["myConnectionString"])) { int counter = 0; SqlCommand cmd = conn.CreateCommand(); cmd.Connection.Open(); foreach (OrderModel ord in NewOrders) { cmd.CommandText = buildSql(ord); try { cmd.ExecuteNonQuery(); counter++; } catch (SqlException ex) { TextBox1.Text = ex.Message; } } TextBox1.Text = counter.ToString() + " records inserted"; } Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131807
  - 18
    - Assign Null to textbox after deleting its content Hi, I have a form in which the tableadapter gets its data from an access table. Suppose I want to delete a clients phone number. I select the text in the phone number field, and press delete. The field is now empty. When I try to call the update method of the table adapter, I get an OleDb exception telling me that the field can not be an empty string. How do I get a field to become 'Null' if I delete its contents? Not in the Validating event of each text box I hope? Thx, Arend Jan -- Remove 'sac' from the reply address. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131802
  - 19
    - ASP.NET Forms Authentication and ATLAS control problem Hello, I am using Forms Authentication in ASP.NET 2.0 website. I have also implemented UIP Application Blocks. On one page I have used ATLAS Cascading Dropdown. The page looses session and redirects to login page on click of any link on the page. As soon as I replace cascading dropdown with dropdown control, it starts behaving correctly. Any clue why this is happening? Why page looses session and redirects to login page. It even does not execute Page Load of the same page. I appreciate any help regarding this. Thanks in advance, Ashish Basran Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131801
  - 20
    - Auto number generator Greetings, I am having problem with the following codes for some reason and I cannot figure it out where the problem is. However, what I'm trying to achive is to have a auto number generator for my quote form, so basically this generator would create a quote number that will change as new records are added. I am doing this in MS Access 2000. here is the code: ----------------------------------------------- Private Sub Form_BeforeInsert(Cancel As Integer) Dim rst As DAO.Recordset Dim i As Integer Dim nMaxVal As Integer Dim n As Integer nMaxVal = 1630 Set rst = Me.RecordsetClone If Not rst.BOF Then rst.MoveFirst End If Do While Not rst.EOF n = rst![Quote_Num] If n > nMaxVal Then nMaxVal = n End If rst.MoveNext Loop Me![Quote_Num] = nMaxVal + 1 End Sub ----------------------------------------------------- My guess is that problem lays in the next one ------------------------------------------------------ Private Sub txtQuoteNo_Change() Dim rst As DAO.Recordset, intI As Integer Set rst = Me.RecordsetClone If IsNull(rst![Quote_Num]) Then intI = rst![Quote_Num] Me![Quote_Num] = intI + 2 End If End Sub ------------------------------------------------------ Could you please help me figure this out. Thanks in advance -Rino Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131799
  - 21
    - SQL SERVER 2005 Data Type convertion to VB.NET 2.0 Hi guys, what i'm trying to do is to create a Dynamic class generator based on tables from a sql2005 database. To get the list of Colums from a specific table i Use: "select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'TableName'" and that query returns for a datatable all basic and necessary information for the creation process. My problem is: how should i assign a data type do a class element defenition as this example: Dim strClassOut as string = "" while myReader.Read() strClassOut &= "Public def" & myReader("Column") & " as " ReturnType(myReader("ColumnType")) end while private funtion ReturnType(ByVal str as string) as string Dim strOut as string ="" Select case str case "varchar" strOut ="String" case "bit" strOut ="Boolean" case "????????" strOut ="??????" end case return strOut end funtion where can i See the correct convertion table? or some thing like this? thanks Flávio Oliveira Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131787
  - 22
    - Web method request returning incorrect resultset FOR CONCURRENT USERS I have a C# Web Service with several Web methods. If I try to access a method that returns a dataset based on a specific criteria and another user tries to access the same method with a different criteria and we keep executing it several times from different machines then every once in a while he'd end up with the dataset that I was supposed to get and I'd get his dataset. I have unsuccessfully tried several things - it seems like the web server is seeing multiple similar requests (for the same web method) and is not directing the response to the appropriate requestor. PLEASE HELP!!!! Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131785
  - 23
    - BindingNavigatorDeleteItem Hello, I am trying to delete a row from a datagrid using BindingNavigator delete iterm. I added the following code in BindingNavigatorDeleteItem_Click(). This code only deletes the record from the datagrid, it does not delete from the database table. Private Sub BindingNavigatorDeleteItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click If MessageBox.Show("Are you sure?", "", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then ContactBindingSource.RemoveCurrent() End If End Sub To save to the database table, I need to click on the save button after deleting a row. When I click on the save button I am getting "Update requires a valid DeleteCommand when passed DataRow collection with deleted rows" error message. I have the following in Saveitem_click: Me.Validate() Me.ContactBindingSource.EndEdit() Me.ContactBindingSourceTableAdapter.Update(Me.DataSet1.Contact) I would appreciate the help with this problem. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131784
  - 24
    - BindingNavigatorDeleteItem Hello, I am trying to delete a row from a datagrid using BindingNavigator delete iterm. I added the following code in BindingNavigatorDeleteItem_Click(). This code only deletes the record from the datagrid, it does not delete from the database table. Private Sub BindingNavigatorDeleteItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click If MessageBox.Show("Are you sure?", "", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then ContactBindingSource.RemoveCurrent() End If End Sub To save to the database table, I need to click on the save button after deleting a row. When I click on the save button I am getting "Update requires a valid DeleteCommand when passed DataRow collection with deleted rows" error message. I have the following in Saveitem_click: Me.Validate() Me.ContactBindingSource.EndEdit() Me.ContactBindingSourceTableAdapter.Update(Me.DataSet1.Contact) I would appreciate the help with this problem. Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131783
  - 25
    - Get modified colums only Is there a way to get only the modified columns of the rows in a DataSet? When calling DataSet.GetChanges() I'm getting the entire row, whereas I just want the columns that have been changed. Is this possible? Tag: Problem with a readonly table in a dataset (data source) in VS 200 Tag: 131782

I created a data source that point to an Access database with 3 tables in it.
My problem is that the tables are designated read only and I don't know how
to change the setting so I can copy data to them. I can see the public
property in the config file but I am new to Visual Studio 2005 and don't know
how to fix my problem.
--
cathy

Top

Re: Problem with a readonly table in a dataset (data source) in VS 200 by W

W
Sun Aug 20 14:47:41 CDT 2006

Cathy - just so I understand, the tables in Access are Read Only? One thing
you may want to do (b/c if they are read only, you might break something
else by enabling them assuming the original developer had a reason to make
them read only).

Copy the schema of the tables to a new table. THen, configure the
dataadapter's select command to point to the source table. Now, configure
the adapter so that the INsert/Delete commands point to the new tables. Set
the AcceptChangesDuringFill property to false and fill your datatable.
Then, using the second adapters, call Update on them passing in the dataset
you created in the first step. This will cause all of the rows to be
inserted into the new table. THen you'll have the original talbe in Read
Only format as well as a set of data you can work with.

HTH,

BIll
"Cathy" <covey9257@yahoo.com> wrote in message
news:74437CB8-6812-4985-9EDC-4856F95DCCB4@microsoft.com...
>I created a data source that point to an Access database with 3 tables in
>it.
> My problem is that the tables are designated read only and I don't know
> how
> to change the setting so I can copy data to them. I can see the public
> property in the config file but I am new to Visual Studio 2005 and don't
> know
> how to fix my problem.
> --
> cathy

Top

Re: Problem with a readonly table in a dataset (data source) in VS by covey9257

covey9257
Mon Aug 21 08:39:02 CDT 2006

Thansk Bill that helped quite a bit. If I can figure out how to rate this, I
give you 2 thumbs up.
--
cathy

"W.G. Ryan eMVP" wrote:

> Cathy - just so I understand, the tables in Access are Read Only? One thing
> you may want to do (b/c if they are read only, you might break something
> else by enabling them assuming the original developer had a reason to make
> them read only).
>
> Copy the schema of the tables to a new table. THen, configure the
> dataadapter's select command to point to the source table. Now, configure
> the adapter so that the INsert/Delete commands point to the new tables. Set
> the AcceptChangesDuringFill property to false and fill your datatable.
> Then, using the second adapters, call Update on them passing in the dataset
> you created in the first step. This will cause all of the rows to be
> inserted into the new table. THen you'll have the original talbe in Read
> Only format as well as a set of data you can work with.
>
> HTH,
>
> BIll
> "Cathy" <covey9257@yahoo.com> wrote in message
> news:74437CB8-6812-4985-9EDC-4856F95DCCB4@microsoft.com...
> >I created a data source that point to an Access database with 3 tables in
> >it.
> > My problem is that the tables are designated read only and I don't know
> > how
> > to change the setting so I can copy data to them. I can see the public
> > property in the config file but I am new to Visual Studio 2005 and don't
> > know
> > how to fix my problem.
> > --
> > cathy
>
>
>

Top