I'd like to know if this kind of stored procedure is possible, do i need some sort of looping structure or something? I want to do this, basically in this order: get all rows from one table or view. (table1) based on columns from table 1, i want to set variables for use in insert/update table2. i want to reference another table, (table...
i have a sql database, and have created a dataset for a sample table in it. The dataset is HotelDataSet2 and data table adapter to insert to it is Various_itemsTableAdapter. MsgBox(HotelDataSet2.various_items.Rows.Count) Various_itemsTableAdapter.Insert(Item_nameTextBox.Text, itemcode, PackingTextBox.Text, UomTextBox.Text, PriceTextB...
I have a query that selects data into a custom type- UserData curData = dc.Users.Where(λ => (λ.Login == username) && λ.Active) .Select( λ => new UserData { ID = λ.ID, UserName = λ.Login, isAdmin = λ.Admin, isTrusted = λ.Trusted, EMail = λ.E_mail ... }); //Yeah I know this isn't a technically correct usage of 'λ' //It is ...
I am newbie at using DataSet. I am writing a program with VB.NET, there I have to select data from one table. Then I have to update about 4 tables and insert to 2 Tables. Which approach will be ok for me? I'm thinking to use DataSet. If anyone can point out that problem , please show me with Sample code to update DataSet. Thanks you all ...
Currently, I'm peppering form submissions to account for single quotes & other garbage. $form_field_value= str_replace("'", "''", stripslashes($form_field_value)); It is to prep the value for insertion using: $insert_sql = "insert into table (field) values ('".$form_field_value."')"; odbc_exec($conn, $insert_sql); Essentially,...
I have built a SQL Server Express database that is going to be housed on an external hd. I need to be able to add/update data on the database that is on my system, as well as other systems and then only backup or transfer data that has been added or edited to the external hard drive. What is the best way to accomplish this? ...
Hi everybody! I'm developing a WPF application (.NET 3.5SP1). The scenario is this: 1.using SQL Metal to extract the entity definitions (and the corresponding map file), which were afterwards used for the Data Access Layer (so i'm using LINQ to SQL). 2.using Unity (this application is "PRISM based") to register abstract classes and the...
I am using EntityFramework. I have an "Application" object (which has a field certificateReasonID) which can have one or zero CertificateReasons - so there is a ralationship to the "CertificateReason" table, and visiually on the edmx diagram we do not see the certificateReasonTypeID field. When I update an Application - it INSERTS a new...
I need to be able to change the primary keys in a table. The problem is, some of the keys will be changing to existing key values. E.g. record1.ID 3=>4 and record2.ID 4=>5. I need to keep these as primary keys as they are set as foreign keys (which cascade up update) Is there a reasonable way to accomplish this, or am I attempting sql...
Helo. Firts of all i'm sorry for my eanglish. I'm writing Windows Form application in Visual Studio 2008 in C#. I created database (Baza.mdf) or rather "Service-based Database" this is only option to create .mdf in WindowsForm App. Then i create ADO.NET Entity Data Model. I Add New Data Source and Drag and Drop "BazaDataSet" to my form....
A have a JPA entity that has timestamp field and is distinguished by a complex identifier field. What I need is to update timestamp in an entity that has already been stored, otherwise create and store new entity with the current timestamp. As it turns out the task is not as simple as it seems from the first sight. The problem is that i...
I'm doing an insert query where most of many columns would need to be updated to the new values if a unique key already existed. It goes something like this: INSERT INTO lee(exp_id, created_by, location, animal, starttime, endtime, entct, inact, inadur, inadist, smlct, ...
I need to update two tables inside a single transaction. The individual queries look something like this: 1. INSERT INTO t1 (col1, col2) VALUES (val1, val2) ON DUPLICATE KEY UPDATE col2 = val2; If the above query causes an insert then I need to run the following statement on the second table: 2. INSERT INTO t2 (col1, c...
Several of our database tables contain LastModifiedDate columns. We would like these to stay synchronized based on a single time-source. Our best time-source, in this case, is the SQL Server itself since there is only one database server but multiple application servers which could potentially be off sync. I would like to be able to use...
Hi, Apologies if there is clear answer for this somewhere. But I can't insert into a simple table due to it containing a foreign key. Task Table TaskId (PK) Description StatusId (FK) Into which I try to insert like so: Task t = new Task(); t.Id = 1234; t.Title = "foo"; t.Status = db.Status.ToList().F...
Hello, I'm still quite a mySQL newbie, so I would like to do this right to avoid future mishaps. What is the right way to detect when do I need to UPDATE an entry in a table or INSERT a new one? Thank you. ...
This is weird ... done updates loads of times before but cannot spot why this is different. although I am using .net 4.0 now - however i doubt its a bug in its L2S implementation. Its not like this is a wierd and wonderful application of it. Although i am fairly sure this code worked whilst i was using the RC. I have also managed to rep...
I'm using following update or insert Oracle statement at the moment: BEGIN UPDATE DSMS SET SURNAME = :SURNAME WHERE DSM = :DSM; IF (SQL%ROWCOUNT = 0) THEN INSERT INTO DSMS (DSM, SURNAME) VALUES (:DSM, :SURNAME); END IF; END; This runs fine except that the update statement performs dummy update if the ...
Here's my original question: merging two data sets Unfortunately I omitted some intircacies, that I'd like to elaborate here. So I have two tables events_source_1 and events_source_2 tables. I have to produce the data set from those tables into resultant dataset (that I'd be able to insert into third table, but that's irrelevant). ev...
Hi, I am using MS Access as a database and using c#, .net for updating some records in it. But it is giving error saying "No value given for one or more required parameters." There are 5 colums in Table and I want to update only 2, for that I have written the query like "update User_DTL set user_role_id = '" + _UserRole + "', auth_id...